DW_PO_HEADERS_EN

Standard Purchase Order Entity

Details

Module: Purchasing

Key Columns

PURCHASE_ORDER_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PURCHASE_ORDER_ID NUMBER 38 0 True Document header unique identifier    
SOURCE_RECORD_ID VARCHAR2 64     Source record identifier    
SUBLEDGER_LINKAGE_HDR_ENTITY_ID VARCHAR2 64     Document header unique identifier    
PURCHASE_ORDER_NUMBER VARCHAR2 32     Purchase order number    
TYPE_LOOKUP_CODE VARCHAR2 32     Type of the document - Standard    
PROCUREMENT_BU_ID NUMBER 38 0   Proc BU ID DW_INTERNAL_ORG_D ORGANIZATION_ID
REQUISITION_BU_ID NUMBER 38 0   Req BU ID DW_INTERNAL_ORG_D ORGANIZATION_ID
BUYER_ID NUMBER 38 0   Buyer unique identifier DW_PERSON_D PERSON_ID
PAYMENT_TERMS_ID NUMBER 38 0   Payment terms unique identifier AP_TERMS_TL TERMS_ID
MODE_OF_TRANSPORT VARCHAR2 32     Type of transportation used to ship the product, such as truck, air or boat    
PO_CREATION_DATE TIMESTAMP       indicates the date and time of the creation of the row    
BILL_TO_LOCATION_ID NUMBER 38 0   Bill-to location unique identifier (References HR_LOCATIONS_ALL.location_id)    
STYLE_ID NUMBER 38 0   Determines the Purchasing Style of the document.    
DOCUMENT_STATUS VARCHAR2 32     Header status    
COMMENTS VARCHAR2 256     Descriptive comments for the document    
CURRENCY_CODE VARCHAR2 16     Unique identifier for the currency (References FND_CURRENCIES.currency_code)    
PCARD_ID NUMBER 38 0   Unique identifer for the procurement card used for the order (References AP_CARDS_ALL.card_id)    
BUDGET_CONTROL_ENABLED_FLAG VARCHAR2 16     Flag to indicate if Budgetary conrol was enabled at the time of Purchase Order creation. Not applicable to Agreements.    
DOCUMENT_CREATION_METHOD VARCHAR2 32     Method in which the document got created - Autocreate, enter PO , etc...    
FROZEN_FLAG VARCHAR2 16     Indicates whether the document is frozen or not    
FUNDS_STATUS VARCHAR2 32     status to indicate whether funds have been reserved on the document or not    
REVISION_NUM NUMBER       Document revision number    
REVISED_DATE TIMESTAMP       Date the document was last revised    
ACCEPTANCE_DUE_DATE TIMESTAMP       Date by which the supplier should accept the purchase order    
ACCEPTANCE_REQUIRED_FLAG VARCHAR2 16     Indicates whether acceptance from the supplier is required or not    
TERMS_ID NUMBER 38 0   Payment terms unique identifier (References to AP_TERMS_TL.term_id)    
BUYER_MANAGED_TRANSPORT_FLAG VARCHAR2 16     A flag to indicate that the buying company is responsible for arranging the transportation, from picking up the requested goods to delivering to ship-to locations specified on the order. The value is Y/N.    
CONFIRMING_ORDER_FLAG VARCHAR2 16     Indicates whether the purchase order is a confirming order or not    
PO_APPROVED_DATE TIMESTAMP       Date the purchase order was last approved    
VENDOR_ID NUMBER 38 0   Supplier unique identifier    
VENDOR_SITE_ID NUMBER 38 0   Supplier site unique identifier    
APPROVED_FLAG VARCHAR2 16     Indicates whether the purchase order is approved or not    
RATE_TYPE VARCHAR2 32     Currency conversion rate type    
PAY_ON_CODE VARCHAR2 32     Indicator of whether the purchase order will be paid upon receipt    
CLOSED_DATE DATE       Date the document was closed    
CARRIER_ID NUMBER 38 0   Carrier ID (Party ID)    
SERVICE_LEVEL VARCHAR2 32     Priority of transportation that affects how quickly goods are transported    
SUPPLIER_NOTIF_METHOD VARCHAR2 32     Supplier Notification Method    
BILLTO_BU_ID NUMBER 38 0   Bill-to Business Unit unique identifier. This captures the business unit which vouches the supplier invoices received for a purchase orde    
CREATED_BY VARCHAR2 64     Who column: indicates the user who created the row.    
SOLDTO_LE_ID NUMBER 38 0   Sold to Legal Entity unique identifier. Indicates the party which is financially responsible for the purchases on a purchase order