PO HDR RAW Table
View exposing raw purchase order header records including vendor, dates, and procurement attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
APPLICATION_CLOSING_DATE |
Date associated with application closing. |
DATE |
|
BID_INVITATION_NUMBER |
Bid invitation number associated with the record. |
VARCHAR2 |
10 |
COMPANY_CODE |
Code identifying company. |
VARCHAR2 |
4 |
COMPLETE_DELIVERY_IND |
Complete delivery ind associated with the record. |
VARCHAR2 |
1 |
CREATED_BY |
Created by associated with the record. |
VARCHAR2 |
12 |
CURRENCY_KEY |
Surrogate key identifying the currency. |
VARCHAR2 |
5 |
CUSTOMER_NUMBER |
Customer number associated with the record. |
VARCHAR2 |
10 |
CUSTOMER_REFERENCE_NUMBER |
Customer reference number associated with the record. |
VARCHAR2 |
12 |
DELETION_INDICATOR |
Indicator identifying whether deletion (Y/N). |
VARCHAR2 |
1 |
DIFFERENT_INVOICING_PARTY |
Different invoicing party associated with the record. |
VARCHAR2 |
10 |
DOCUMENT_CATEGORY |
Document category associated with the record. |
VARCHAR2 |
1 |
DOCUMENT_CONDITION_NUMBER |
Document condition number associated with the record. |
VARCHAR2 |
10 |
DOCUMENT_DATE |
Date associated with document. |
DATE |
|
DOCUMENT_RELEASE_IND |
Document release ind associated with the record. |
VARCHAR2 |
1 |
DOCUMENT_STATUS |
Document status associated with the record. |
VARCHAR2 |
1 |
DOCUMENT_TYPE |
Document type associated with the record. |
VARCHAR2 |
4 |
DOCUMENT_TYPE_CTL_IND |
Document type ctl ind associated with the record. |
VARCHAR2 |
1 |
DOCUMENT_TYPE_KEY |
Surrogate key identifying the document type. |
VARCHAR2 |
5 |
DUMMY |
Dummy associated with the record. |
VARCHAR2 |
21 |
DUMMY2 |
Dummy2 associated with the record. |
VARCHAR2 |
10 |
DUMMY3 |
Dummy3 associated with the record. |
VARCHAR2 |
20 |
EXCHANGE_RATE_FIXING_IND |
Exchange rate fixing ind associated with the record. |
VARCHAR2 |
1 |
EXPORT_DATA_NUMBER |
Export data number associated with the record. |
VARCHAR2 |
10 |
GOODS_RCPT_MESSAGE_IND |
Goods rcpt message ind associated with the record. |
VARCHAR2 |
1 |
INCOTERMS_PART_1 |
Incoterms part 1 associated with the record. |
VARCHAR2 |
3 |
INCOTERMS_PART_2 |
Incoterms part 2 associated with the record. |
VARCHAR2 |
28 |
ITEM_INTERVAL |
Item interval associated with the record. |
NUMBER |
5 |
LANGUAGE_KEY |
Surrogate key identifying the language. |
VARCHAR2 |
1 |
LAST_ITEM_NUMBER |
Last item number associated with the record. |
NUMBER |
5 |
LOGICAL_SYSTEM |
Logical system associated with the record. |
VARCHAR2 |
10 |
MASTER_CONDITIONS_IND |
Master conditions ind associated with the record. |
VARCHAR2 |
1 |
MIT_REFERENCE |
Mit reference associated with the record. |
VARCHAR2 |
12 |
PRINC_PURCH_AGREEMENT_NUMBER |
Princ purch agreement number associated with the record. |
VARCHAR2 |
10 |
PROCEDURE |
Procedure associated with the record. |
VARCHAR2 |
6 |
PURCHASING_DOCUMENT_NUMBER |
Purchasing document number associated with the record. |
VARCHAR2 |
10 |
PURCHASING_GROUP |
Purchasing group associated with the record. |
VARCHAR2 |
3 |
PURCHASING_ORG |
Purchasing org associated with the record. |
VARCHAR2 |
4 |
QUOTATION_BINDING_PERIOD |
Quotation binding period associated with the record. |
DATE |
|
QUOTATION_NUMBER |
Quotation number associated with the record. |
VARCHAR2 |
10 |
QUOTATION_SUBMISSION_DATE |
Date associated with quotation submission. |
DATE |
|
QUOTE_SUB_DEADLINE_DATE |
Date associated with quote sub deadline. |
DATE |
|
RECEIVING_VENDOR |
Receiving vendor associated with the record. |
VARCHAR2 |
10 |
RECORD_CREATION_DATE |
Date associated with record creation. |
DATE |
|
REJECTION_REASON |
Rejection reason associated with the record. |
VARCHAR2 |
2 |
RELEASE_COMPLETE_IND |
Release complete ind associated with the record. |
VARCHAR2 |
1 |
RELEASE_GROUP |
Release group associated with the record. |
VARCHAR2 |
2 |
RELEASE_STRATEGY |
Release strategy associated with the record. |
VARCHAR2 |
2 |
REQ_RELEASE_IND |
Req release ind associated with the record. |
VARCHAR2 |
8 |
RFQ_COLLECTIVE_NUMBER |
Rfq collective number associated with the record. |
VARCHAR2 |
10 |
SUB_ITEM_INTERVAL |
Sub item interval associated with the record. |
NUMBER |
5 |
SUPPLYING_PLANT |
Supplying plant associated with the record. |
VARCHAR2 |
4 |
SUPPLYING_VENDOR |
Supplying vendor associated with the record. |
VARCHAR2 |
10 |
TAX_RETURN_COUNTRY |
Tax return country associated with the record. |
VARCHAR2 |
3 |
TERMS_OF_PAYMENT_KEY |
Surrogate key identifying the terms of payment. |
VARCHAR2 |
4 |
UPDATE_GROUP |
Update group associated with the record. |
VARCHAR2 |
6 |
VALIDITY_END_DATE |
Date associated with validity end. |
DATE |
|
VALIDITY_START_DATE |
Date associated with validity start. |
DATE |
|
VENDOR_KEY |
Surrogate key identifying the vendor. |
VARCHAR2 |
11 |
VENDOR_PHONE |
Vendor phone associated with the record. |
VARCHAR2 |
16 |
VENDOR_SALESPERSON |
Vendor salesperson associated with the record. |
VARCHAR2 |
50 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |
|
WARRANTY_PERIOD_START_DATE |
Date associated with warranty period start. |
DATE |