PURCHASING DETAIL Table
View exposing purchasing and procurement transaction detail by purchase order line and account assignment, including cost collector and GL account coding, vendor and sponsor references, quantities and amounts, invoicing and commitment measures, and requisition attributes used for reporting. Does not contain Singapore data (COMPANY_CODE SING).
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACCOUNT_ASSIGNMENT_NUMBER |
Account assignment number for the purchase order line. |
NUMBER |
2 |
ACCT_DISTRIBUTION_PERCENTAGE |
Percentage of the line item distributed to the account assignment. |
NUMBER |
34 |
COMMITMENT_AMOUNT |
Amount currently committed for the line item. |
NUMBER |
18,2 |
COMMITMENT_QUANTITY |
Quantity currently committed for the line item. |
NUMBER |
18,3 |
COMPANY_CODE |
Company code associated with the purchase order. |
VARCHAR2 |
4 |
COST_COLLECTOR_KEY |
Identifier for the cost collector associated with the purchase order coding. |
VARCHAR2 |
12 |
CREATED_BY_USER |
User identifier indicating who created the purchase order. |
VARCHAR2 |
12 |
CURRENCY |
Currency code associated with the purchase order amounts. |
VARCHAR2 |
5 |
GL_ACCOUNT_KEY |
Identifier for the general ledger account associated with the purchase order coding. |
VARCHAR2 |
10 |
GOODS_RECIPIENT |
Username or identifier of the goods recipient. |
VARCHAR2 |
24 |
INVOICED_AMOUNT |
Amount invoiced for the line item. |
NUMBER |
18,2 |
INVOICED_QUANTITY |
Quantity invoiced for the line item. |
NUMBER |
28,3 |
IS_LAST_LINE_ITEM_ON_PO |
Indicator identifying whether the line item is the last line on the purchase order. |
VARCHAR2 |
1 |
ITEM_AMOUNT |
Amount for the purchase order line item. |
NUMBER |
16,2 |
ITEM_DESCRIPTION |
Description of the purchase order line item. |
VARCHAR2 |
200 |
ITEM_PRICE_UNIT |
Unit of measure for the item price. |
VARCHAR2 |
6 |
ITEM_QUANTITY |
Quantity ordered for the purchase order line item. |
NUMBER |
17,3 |
ITEM_UNIT_PRICE |
Unit price for the purchase order line item. |
NUMBER |
14,2 |
MATERIAL_GROUP_KEY |
Identifier for the material group. |
VARCHAR2 |
9 |
MIT_MATERIAL_NUMBER |
MIT material number. |
VARCHAR2 |
18 |
ORDERED_AMOUNT |
Total amount ordered for the line item. |
NUMBER |
34,2 |
ORDERED_QUANTITY |
Total quantity ordered for the line item. |
NUMBER |
17,3 |
PLANT |
Plant code associated with the purchase order. |
VARCHAR2 |
4 |
POSTING_DATE |
Posting date associated with the purchase order transaction record. |
DATE |
|
PO_DATE |
Date the purchase order was created. |
DATE |
|
PO_HAS_OPEN_COMMITMENTS |
Indicator identifying whether the purchase order has open commitments. |
VARCHAR2 |
1 |
PO_LINE_NUMBER |
Line number within the purchase order. |
NUMBER |
5 |
PO_NUMBER |
Purchase order number. |
VARCHAR2 |
10 |
PO_VALIDITY_END_DATE |
End date of the purchase order validity period. |
DATE |
|
PO_VALIDITY_START_DATE |
Start date of the purchase order validity period. |
DATE |
|
PURCHASE_ORDER_TYPE_KEY |
Identifier for the purchase order type. |
VARCHAR2 |
5 |
PURCHASING_GROUP_KEY |
Identifier for the purchasing group. |
VARCHAR2 |
3 |
PURCHASING_ORG_KEY |
Identifier for the purchasing organization. |
VARCHAR2 |
4 |
REQUIREMENT_TRACKING_NUMBER |
Requirement tracking number associated with the procurement request. |
VARCHAR2 |
10 |
REQUISITIONER |
Name or identifier of the requisitioner. |
VARCHAR2 |
50 |
REQUISITION_ITEM |
Line item number within the requisition. |
NUMBER |
5 |
REQUISITION_NUMBER |
Requisition number associated with the purchase order. |
VARCHAR2 |
10 |
REQUISITION_TYPE_KEY |
Identifier for the requisition type. |
VARCHAR2 |
5 |
SPONSOR_KEY |
Identifier for the sponsor associated with the purchase order. |
VARCHAR2 |
10 |
TAX_CODE |
Tax code associated with the purchase order line item. |
VARCHAR2 |
2 |
TAX_CODE_DESCRIPTION |
Description of the tax code. |
VARCHAR2 |
100 |
TERMS_OF_PAYMENT_KEY |
Identifier for the terms of payment. |
VARCHAR2 |
4 |
TOTAL_ORDER_VALUE |
Total value of the purchase order. |
NUMBER |
18,2 |
UNLOADING_POINT |
Unloading point or location for delivery. |
VARCHAR2 |
50 |
VENDOR_KEY |
Identifier for the vendor associated with the purchase order. |
VARCHAR2 |
11 |
VENDOR_MATERIAL_NUMBER |
Vendor-provided material number. |
VARCHAR2 |
35 |
VENDOR_NAME |
Name of the vendor associated with the purchase order. |
VARCHAR2 |
50 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |