PURCHASING DETAIL FULL Table
View exposing detailed purchasing records including purchase orders, line items, vendors, amounts, and procurement lifecycle attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACCOUNT_ASSIGNMENT_NUMBER |
Account assignment number associated with the record. |
NUMBER |
2 |
ACCT_DISTRIBUTION_PERCENTAGE |
Acct distribution percentage associated with the record. |
NUMBER |
34 |
COMMITMENT_AMOUNT |
Commitment amount associated with the record. |
NUMBER |
18,2 |
COMMITMENT_QUANTITY |
Commitment quantity associated with the record. |
NUMBER |
18,3 |
COMPANY_CODE |
Code identifying company. |
VARCHAR2 |
4 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
CREATED_BY_USER |
Created by user associated with the record. |
VARCHAR2 |
12 |
CURRENCY |
Currency associated with the record. |
VARCHAR2 |
5 |
GL_ACCOUNT_KEY |
Surrogate key identifying the gl account. |
VARCHAR2 |
10 |
GOODS_RECIPIENT |
Goods recipient associated with the record. |
VARCHAR2 |
24 |
INVOICED_AMOUNT |
Invoiced amount associated with the record. |
NUMBER |
18,2 |
INVOICED_QUANTITY |
Invoiced quantity associated with the record. |
NUMBER |
28,3 |
IS_LAST_LINE_ITEM_ON_PO |
Indicator identifying whether last line item on po (Y/N). |
VARCHAR2 |
1 |
ITEM_AMOUNT |
Item amount associated with the record. |
NUMBER |
16,2 |
ITEM_DESCRIPTION |
Description of item. |
VARCHAR2 |
200 |
ITEM_PRICE_UNIT |
Item price unit associated with the record. |
VARCHAR2 |
6 |
ITEM_QUANTITY |
Item quantity associated with the record. |
NUMBER |
17,3 |
ITEM_UNIT_PRICE |
Item unit price associated with the record. |
NUMBER |
14,2 |
MATERIAL_GROUP_KEY |
Surrogate key identifying the material group. |
VARCHAR2 |
9 |
MIT_MATERIAL_NUMBER |
Mit material number associated with the record. |
VARCHAR2 |
18 |
ORDERED_AMOUNT |
Ordered amount associated with the record. |
NUMBER |
34,2 |
ORDERED_QUANTITY |
Ordered quantity associated with the record. |
NUMBER |
17,3 |
PLANT |
Plant associated with the record. |
VARCHAR2 |
4 |
POSTING_DATE |
Date associated with posting. |
DATE |
|
PO_DATE |
Date associated with po. |
DATE |
|
PO_HAS_OPEN_COMMITMENTS |
Po has open commitments associated with the record. |
VARCHAR2 |
1 |
PO_LINE_NUMBER |
Po line number associated with the record. |
NUMBER |
5 |
PO_NUMBER |
Po number associated with the record. |
VARCHAR2 |
10 |
PO_VALIDITY_END_DATE |
Date associated with po validity end. |
DATE |
|
PO_VALIDITY_START_DATE |
Date associated with po validity start. |
DATE |
|
PURCHASE_ORDER_TYPE_KEY |
Surrogate key identifying the purchase order type. |
VARCHAR2 |
5 |
PURCHASING_GROUP_KEY |
Surrogate key identifying the purchasing group. |
VARCHAR2 |
3 |
PURCHASING_ORG_KEY |
Surrogate key identifying the purchasing org. |
VARCHAR2 |
4 |
REQUIREMENT_TRACKING_NUMBER |
Requirement tracking number associated with the record. |
VARCHAR2 |
10 |
REQUISITIONER |
Requisitioner associated with the record. |
VARCHAR2 |
50 |
REQUISITION_ITEM |
Requisition item associated with the record. |
NUMBER |
5 |
REQUISITION_NUMBER |
Requisition number associated with the record. |
VARCHAR2 |
10 |
REQUISITION_TYPE_KEY |
Surrogate key identifying the requisition type. |
VARCHAR2 |
5 |
SPONSOR_KEY |
Surrogate key identifying the sponsor. |
VARCHAR2 |
10 |
TAX_CODE |
Code identifying tax. |
VARCHAR2 |
2 |
TAX_CODE_DESCRIPTION |
Description of tax code. |
VARCHAR2 |
100 |
TERMS_OF_PAYMENT_KEY |
Surrogate key identifying the terms of payment. |
VARCHAR2 |
4 |
TOTAL_ORDER_VALUE |
Total order value associated with the record. |
NUMBER |
18,2 |
UNLOADING_POINT |
Unloading point associated with the record. |
VARCHAR2 |
50 |
VENDOR_KEY |
Surrogate key identifying the vendor. |
VARCHAR2 |
11 |
VENDOR_MATERIAL_NUMBER |
Vendor material number associated with the record. |
VARCHAR2 |
35 |
VENDOR_NAME |
Vendor name associated with the record. |
VARCHAR2 |
50 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |