PURCHASING DETAIL Table
The Purchasing Detail table provides a detailed view of purchase order information, right down to the Account Distribution (or Account Assignment) level. Thus each record in this table represents the fraction of a PO Line Item that was assigned to a single account (or more accurately a given Cost Collector/GL Account pair). A record in this table is uniquely identified by the combination of PO Number, PO Line Number and Account Assignment Number. The only additive fields in this table are ordered qty & amount (representing qty & dollars on the PO assigned to the account), commitment qty &amount (the current open commitment qty & dollar amount for this record) and invoiced qty &amount (the qty & dollar amount for this record which has been invoiced). All other numeric amounts on the table are informational only - they should not be summed on a report.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACCOUNT_ASSIGNMENT_NUMBER |
Account distribution assignment serial number. This number identifies a single account distribution for a line item. |
NUMBER |
22 |
ACCT_DISTRIBUTION_PERCENTAGE |
The percentage of the line item value which has been assigned to a particular cost collector/GL account. The percentage values of the account distributions for a given PO line item will total 100. |
NUMBER |
22 |
COMMITMENT_AMOUNT |
The dollars committed (set aside) but not yet paid for the line item. |
NUMBER |
11 |
COMMITMENT_QUANTITY |
Quantity of material for an open commitment. |
NUMBER |
22 |
COMPANY_CODE |
Shows to which "company" in SAP a cost collector is attached. MIT uses separate "companies" in SAP to differentiate financial transactions for different legal entities with differing business rules or reporting requirements. There are currently three company codes, "CUR" for main campus, "TECR" for MIT's alumni magazine, Technology Review, and "LCP1" for Lincoln Laboratory. |
VARCHAR2 |
4 |
COST_COLLECTOR_KEY |
Key used to join the Cost Collector to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
12 |
CREATED_BY_USER |
XXX |
VARCHAR2 |
8 |
CURRENCY |
XXX |
VARCHAR2 |
5 |
GL_ACCOUNT_KEY |
Key used to join the GL_ACCOUNT to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
10 |
GOODS_RECIPIENT |
The person or group who will receive the goods. |
VARCHAR2 |
12 |
INVOICED_AMOUNT |
The dollar amount associated with this transaction which has been invoiced. This value equates to the 'actual amounts' seen in the Financial Detail table. |
NUMBER |
22 |
INVOICED_QUANTITY |
The quantity of material associated with this transaction which has been invoiced. |
NUMBER |
22 |
IS_LAST_LINE_ITEM_ON_PO |
This field is associated with purchase order line item information and indicates whether or not the line item is the last line item on the PO. Values are Y (line item is the last one) or N (is not the last line item). |
VARCHAR2 |
1 |
ITEM_AMOUNT |
The dollar value of a purchase order line item. In most cases, equates to Ordered Quantity multiplied by Unit Price |
NUMBER |
22 |
ITEM_DESCRIPTION |
The short description of an ordered item. |
VARCHAR2 |
60 |
ITEM_PRICE_UNIT |
Indicates what "unit" the Unit Price on a PO Line Item refers to. Usually equal to 1. |
VARCHAR2 |
6 |
ITEM_QUANTITY |
Ordered Quantity on a PO Line Item |
NUMBER |
22 |
ITEM_UNIT_PRICE |
Unit Price on a PO Line Item |
NUMBER |
22 |
MATERIAL_GROUP_KEY |
Key identifying which Material Group an ordered item belongs to. This field should only be used for linking tables together, not for reporting. |
VARCHAR2 |
9 |
MIT_MATERIAL_NUMBER |
XXX |
VARCHAR2 |
50 |
ORDERED_AMOUNT |
Dollar amount recorded on a Purchase Order |
NUMBER |
22 |
ORDERED_QUANTITY |
Quantity recorded on a Purchase Order |
NUMBER |
22 |
PLANT |
The plant code associated with the PO line item. |
VARCHAR2 |
4 |
POSTING_DATE |
The date the financial document was posted in SAP. Effective date of posting, not actual date. For example, a costing sheet posting could be generated in early July, but posted to June 30, if so specified by an authorized users. |
DATE |
8 |
PO_DATE |
The date on which the PO was originated. |
DATE |
8 |
PO_HAS_OPEN_COMMITMENTS |
Indicates whether a Purchase Order currently has any open commitments. Values are 'Y' if there are open commitments for the PO, 'N' if not. |
VARCHAR2 |
1 |
PO_LINE_NUMBER |
Purchase Order Line Number. |
NUMBER |
22 |
PO_NUMBER |
Purchase Order number. |
VARCHAR2 |
10 |
PO_VALIDITY_END_DATE |
The date on which a PO's valid period ends. This only applies to certain types of POs. |
DATE |
8 |
PO_VALIDITY_START_DATE |
The date on which a PO's valid period begins. This only applies to certain types of POs. |
DATE |
8 |
PURCHASE_ORDER_TYPE_KEY |
Key identifying the type of Purchase Order. This key is used only for linking to the Purchase Order Type table, not for reporting. |
VARCHAR2 |
5 |
PURCHASING_GROUP_KEY |
Key identifying a Purchasing Group. This field should only be used for linking tables together, not for reporting. |
VARCHAR2 |
3 |
PURCHASING_ORG_KEY |
Key identifying a Purchasing Organization. This field should only be used for linking tables together, not for reporting. |
VARCHAR2 |
4 |
REQUIREMENT_TRACKING_NUMBER |
Entered on a Purchasing Requisition and copied to subsequent Purchase Orders. Enables grouping of Purchasing Documents by Material Requirement |
VARCHAR2 |
10 |
REQUISITIONER |
Person who originated a Purchase Requisition |
VARCHAR2 |
12 |
REQUISITION_ITEM |
Purchase Requisition Item Number |
NUMBER |
22 |
REQUISITION_NUMBER |
Purchase Requisition Document Number |
VARCHAR2 |
10 |
REQUISITION_TYPE_KEY |
Key field used to join to the REQUISITION_TYPE table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
5 |
SPONSOR_KEY |
Key identifying an entry in the Sponsor master table. This field should only be used for linking tables together, not for reporting. |
VARCHAR2 |
10 |
TAX_CODE |
XXX |
VARCHAR2 |
2 |
TAX_CODE_DESCRIPTION |
XXX |
VARCHAR2 |
50 |
TERMS_OF_PAYMENT_KEY |
XXX |
VARCHAR2 |
4 |
TOTAL_ORDER_VALUE |
The total dollar amount for a Purchase Order. This field is informational only - it can be included on reports along with other PO header fields (e.g. PO Number, PO Date) but should not be summed on reports. |
NUMBER |
11 |
UNLOADING_POINT |
The location to which the goods should be delivered. |
VARCHAR2 |
25 |
VENDOR_KEY |
Key identifying an entry in the VENDOR master table. This field should only be used for linking tables together, not for reporting. |
VARCHAR2 |
11 |
VENDOR_MATERIAL_NUMBER |
XXX |
VARCHAR2 |
35 |
VENDOR_NAME |
In the Financial Detail Table, the Vendor to whom a Purchase Order was issued. |
VARCHAR2 |
144 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |