PO LINE RAW Table
View exposing raw purchase order line records including item, quantity, pricing, and procurement attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACCOUNT_DISTRIBUTION_METHOD |
Account distribution method associated with the record. |
VARCHAR2 |
1 |
ACKNOWLEDGMENT_REQUIRED_IND |
Acknowledgment required ind associated with the record. |
VARCHAR2 |
1 |
ADDRESS |
Address associated with the record. |
VARCHAR2 |
10 |
CHAR6_FIELDS |
Char6 fields associated with the record. |
VARCHAR2 |
24 |
COMMITMENT_ITEM |
Commitment item associated with the record. |
VARCHAR2 |
14 |
CUSTOMER |
Customer associated with the record. |
VARCHAR2 |
10 |
DELETION_INDICATOR |
Indicator identifying whether deletion (Y/N). |
VARCHAR2 |
1 |
EFFECTIVE_ITEM_VALUE |
Effective item value associated with the record. |
VARCHAR2 |
16 |
FINAL_INVOICE_IND |
Final invoice ind associated with the record. |
VARCHAR2 |
1 |
FUND |
Fund associated with the record. |
VARCHAR2 |
10 |
FUNDS_CENTER |
Funds center associated with the record. |
VARCHAR2 |
16 |
GENERAL_CONFIG_MATERIAL |
General config material associated with the record. |
VARCHAR2 |
18 |
GOODS_RECEIPT_IND |
Goods receipt ind associated with the record. |
VARCHAR2 |
1 |
GOODS_RECEIPT_NV_IND |
Goods receipt nv ind associated with the record. |
VARCHAR2 |
1 |
GROSS_PO_VALUE |
Gross po value associated with the record. |
NUMBER |
16,2 |
GR_INVOICE_VERIF_IND |
Gr invoice verif ind associated with the record. |
VARCHAR2 |
1 |
INVOICE_RECEIPT_IND |
Invoice receipt ind associated with the record. |
VARCHAR2 |
1 |
IS_DELIVERY_COMPLETE |
Indicator identifying whether delivery complete (Y/N). |
VARCHAR2 |
1 |
ITEM_CHANGE_DATE |
Date associated with item change. |
DATE |
|
ITEM_TEXT |
Item text associated with the record. |
VARCHAR2 |
200 |
LINE_ITEM_NUMBER |
Line item number associated with the record. |
NUMBER |
5 |
MATERIAL_CATEGORY |
Material category associated with the record. |
VARCHAR2 |
2 |
MATERIAL_GROUP |
Material group associated with the record. |
VARCHAR2 |
9 |
MATERIAL_NUMBER_1 |
Material number 1 associated with the record. |
VARCHAR2 |
18 |
MATERIAL_NUMBER_2 |
Material number 2 associated with the record. |
VARCHAR2 |
18 |
MATERIAL_TYPE |
Material type associated with the record. |
VARCHAR2 |
4 |
NET_PO_VALUE |
Net po value associated with the record. |
NUMBER |
16,2 |
NET_PRICE |
Net price associated with the record. |
NUMBER |
14,2 |
ORDER_ACKNOWLEDGMENT_NUMBER |
Order acknowledgment number associated with the record. |
VARCHAR2 |
20 |
ORDER_PRICE_UNIT |
Order price unit associated with the record. |
VARCHAR2 |
10 |
ORDER_UNIT |
Order unit associated with the record. |
VARCHAR2 |
10 |
PARTIAL_INVOICE_IND |
Partial invoice ind associated with the record. |
VARCHAR2 |
1 |
PLANT |
Plant associated with the record. |
VARCHAR2 |
4 |
PO_QUANTITY |
Po quantity associated with the record. |
NUMBER |
17,3 |
PRICE_DETERMINATION_DATE |
Date associated with price determination. |
DATE |
|
PRICE_UNIT |
Price unit associated with the record. |
NUMBER |
5 |
PRICING_SUBTOTAL_1 |
Pricing subtotal 1 associated with the record. |
NUMBER |
18,2 |
PRICING_SUBTOTAL_2 |
Pricing subtotal 2 associated with the record. |
NUMBER |
18,2 |
PRINC_PURCH_AGREEMENT_ITEM |
Princ purch agreement item associated with the record. |
VARCHAR2 |
5 |
PRINC_PURCH_AGREEMENT_NUMBER |
Princ purch agreement number associated with the record. |
VARCHAR2 |
10 |
PROFIT_CENTER |
Profit center associated with the record. |
VARCHAR2 |
10 |
PURCHASE_REQ_ITEM_NUMBER |
Purchase req item number associated with the record. |
NUMBER |
5 |
PURCHASE_REQ_NUMBER |
Purchase req number associated with the record. |
VARCHAR2 |
10 |
PURCHASING_DOCUMENT_CATEGORY |
Purchasing document category associated with the record. |
VARCHAR2 |
1 |
PURCHASING_DOCUMENT_NUMBER |
Purchasing document number associated with the record. |
VARCHAR2 |
10 |
PURCHASING_INFO_REC_NUMBER |
Purchasing info rec number associated with the record. |
VARCHAR2 |
10 |
REQUIREMENT_TRACKING_NUMBER |
Requirement tracking number associated with the record. |
VARCHAR2 |
10 |
STD_REL_ORDER_QUANTITY |
Std rel order quantity associated with the record. |
VARCHAR2 |
17 |
TARGET_QUANTITY |
Target quantity associated with the record. |
NUMBER |
17,3 |
TAX_CODE |
Code identifying tax. |
VARCHAR2 |
2 |
TAX_CODE_PROCEDURE |
Tax code procedure associated with the record. |
VARCHAR2 |
6 |
UNIT_OF_MEASURE |
Unit of measure associated with the record. |
VARCHAR2 |
3 |
UNIVERSAL_PRODUCT_CODE |
Code identifying universal product. |
VARCHAR2 |
18 |
VENDOR_MATERIAL_NUMBER |
Vendor material number associated with the record. |
VARCHAR2 |
35 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |