Standard Purchase Order Entity
Module: Purchasing
PURCHASE_ORDER_ID
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 |