# DW_PURCHASE_ORDER_CF

Purchase Order Fact

## Details

Module: Purchasing

## Key Columns

PURCHASE_ORDER_LINE_ID, PO_DISTRIBUTION_ID, PO_SCHEDULE_ID, PURCHASE_ORDER_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
PURCHASE_ORDER_ID | NUMBER | 38 | 0 | True | PO header unique identifier |  |
PURCHASE_ORDER_LINE_ID | NUMBER | 38 | 0 | True | PO Line unique identifier |  |
PO_SCHEDULE_ID | NUMBER | 38 | 0 | True | PO line location unique identifier |  |
PO_DISTRIBUTION_ID | NUMBER | 38 | 0 | True | Purchase order distribution identifier |  |
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. Source record identifier |  |
PURCHASE_ORDER_NUMBER | VARCHAR2 | 32 |  |  | Purchase order number |  |
BILL_TO_LOCATION_ID | NUMBER | 38 | 0 |  | Bill-to location unique identifier | DW_WORKER_LOCATION_D | LOCATION_ID
BUYER_ID | NUMBER | 38 | 0 |  | Buyer unique identifier. | DW_PERSON_NAME_CURRENT_D | PERSON_ID
STYLE_ID | NUMBER | 38 | 0 |  | Document Style Identifier . Along with LANGUAGE, fact (DOCUMENT_STYLE_ID,AGREEMENT_TYPE ) will join with DW_DOC_STYLE_LINES_TL (STYLE_ID,DOCUMENT_SUBTYPE) | DW_DOC_STYLE_LINES_TL | STYLE_ID DOCUMENT_SUBTYPE
DOCUMENT_STATUS | VARCHAR2 | 32 |  |  | Header status (values could be "CLOSED FOR INVOICING",OPEN, "CLOSED FOR RECEIVING", etc) | DW_DOCUMENT_STATUS_D_TL | CODE
COMMENTS | VARCHAR2 | 256 |  |  | Descriptive comments for the document |  |
CURRENCY_CODE | VARCHAR2 | 16 |  |  | Unique identifier for the purchase order currency. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
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. | DW_Y_N_D_TL | CODE
DOCUMENT_CREATION_METHOD | VARCHAR2 | 32 |  |  | Method in which the document got created - Autocreate, enter PO , etc... | DW_PO_DOC_CREATION_METHOD_D_TL | CODE
FUNDS_STATUS | VARCHAR2 | 32 |  |  | Status to indicate whether funds have been reserved on the document or not (values could be LIQUIDATED, PARTIALLY_LIQUIDATED, RESERVED etc..) | DW_POR_FUNDS_STATUS_D_TL | CODE
REVISION_NUM | NUMBER |  |  |  | Document revision number |  |
REVISED_DATE | DATE |  |  |  | Date the document was last revised |  |
ACCEPTANCE_DUE_DATE | DATE |  |  |  | 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 | DW_ACCEPTANCE_REQUIRED_D_TL | CODE
TERMS_ID | NUMBER | 38 | 0 |  | Payment terms unique identifier | DW_AP_TERMS_D | PAYMENT_TERMS_ID
PO_DOCUMENT_TYPE | VARCHAR2 | 32 |  |  | Type of the document. Value will be STANDARD. For translations, need to filter DOCUMENT_TYPE_CODE='PA' in DW_PO_DOCUMENT_TYPES_ALL_D_TL. To be joined with DW_PO_DOCUMENT_TYPES_ALL_D_TL (DOCUMENT_SUBTYPE, PRC_BU_ID) using (AGREEMENT_TYPE, PROCUREMENT_BU_ID) | DW_PO_DOCUMENT_TYPES_ALL_D_TL | DOCUMENT_SUBTYPE PRC_BU_ID
PO_CREATION_DATE | TIMESTAMP |  |  |  | Indicates the date and time of the creation of the row |  |
PO_CREATION_DATE_1 | DATE |  |  |  | Indicates the date and time of the creation of the row |  |
PROCUREMENT_BU_ID | NUMBER | 38 | 0 |  | Procurement Business unit ID | DW_INTERNAL_ORG_D | ORGANIZATION_ID
AGREEMENT_PROCUREMENT_BU_ID | NUMBER | 38 | 0 |  | Procurement BU of the Agreement (Blanket or Contract) | DW_INTERNAL_ORG_D | ORGANIZATION_ID
REQUISITION_BASED_FLAG | VARCHAR2 | 16 |  |  | If REQUISITION_DISTRIBUTION_ID is present or not in DW_PURCHASE_ORDER (values Y/N) | DW_Y_N_D_TL | CODE
SOURCING_BASED_FLAG | VARCHAR2 | 16 |  |  | If AUCTION_HEADER_ID is present or not in DW_PURCHASE_ORDER (values Y/N) | DW_Y_N_D_TL | CODE
AGREEMENT_LEAKAGE_FLAG | VARCHAR2 | 16 |  |  | If POLine is present in DW_AGREEMENT_LEAKAGE_STAGE table then Y else N | DW_Y_N_D_TL | CODE
PROC_CARD_INDICATOR | VARCHAR2 | 16 |  |  | Unique identifer for the procurement card used for the order. If Procurement card id is not null then Y else N | DW_Y_N_D_TL | CODE
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. Value will be Y/N | DW_Y_N_D_TL | CODE
CONFIRMING_ORDER_FLAG | VARCHAR2 | 16 |  |  | Indicates whether the purchase order is a confirming order or not (values would be Y/N) | DW_Y_N_D_TL | CODE
SUPPLIER_ID | NUMBER | 38 | 0 |  | Supplier unique identifier | DW_PARTY_D | SUPPLIER_ID
SUPPLIER_SITE_ID | NUMBER | 38 | 0 |  | Supplier site unique identifier | DW_SUPPLIER_SITE_D | SUPPLIER_SITE_ID
COMMUNICATION_METHOD | VARCHAR2 | 32 |  |  | Supplier Notification Method (valuescould be EMAIL, FAX, NONE etc) | DW_DOC_COMM_METHOD_D_TL | CODE
APPROVED_FLAG | VARCHAR2 | 16 |  |  | PO approval flag indicator (Value would be Y ) | DW_Y_N_D_TL | CODE
PO_RATE_TYPE | VARCHAR2 | 32 |  |  | Currency conversion rate type ( values would be Corporate, User) | DW_RATE_TYPE_D_TL | CODE
PAY_ON_RECEIPT_INDICATOR | VARCHAR2 | 16 |  |  | Indicator of whether the purchase order will be paid upon receipt (logic to calculate when PO PAY_ON_CODE = 'RECEIPT' then Y else N) | DW_Y_N_D_TL | CODE
PO_CLOSED_DATE | DATE |  |  |  | Date the document was closed |  |
LEGAL_ENTITY_ID | NUMBER | 38 | 0 |  | Sold to Legal Entity unique identifier. Indicates the party which is financially responsible for the purchases on a purchase order. | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID
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 | DW_INTERNAL_ORG_D | ORGANIZATION_ID
PO_REQUISITION_BU_ID | NUMBER | 38 | 0 |  | Req BU ID | DW_INTERNAL_ORG_D | ORGANIZATION_ID
SUBMITTER_ID | NUMBER | 38 | 0 |  | Submitter for revision zero of the PO (Derived from PO action history table) | DW_PERSON_NAME_CURRENT_D | PERSON_ID
PO_CREATED_BY | VARCHAR2 | 64 |  |  | Who column: indicates the user who created the header | DW_USER_D | USERNAME
FROZEN_FLAG | VARCHAR2 | 16 |  |  | Indicates whether the document is frozen or not | DW_Y_N_D_TL | CODE
SOURCE_AGREEMENT_DOC_STYLE_ID | NUMBER | 38 | 0 |  | Document Style Identifier | DW_DOC_STYLE_LINES_TL | STYLE_ID
SOURCE_AGREEMENT_DOC_TYPE | VARCHAR2 | 32 |  |  | BLANKET or CONTRACT | DW_PO_DOCUMENT_TYPES_ALL_D_TL | DOCUMENT_SUBTYPE PRC_BU_ID
PROC_FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 |  |  | Accounting calendar name. | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
PROC_FISCAL_PERIOD_TYPE | VARCHAR2 | 16 |  |  | Accounting period type. | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE
REQ_FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 |  |  | Accounting calendar name. | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
REQ_FISCAL_PERIOD_TYPE | VARCHAR2 | 16 |  |  | Accounting period type. | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE
FISCAL_PERIOD_NAME | VARCHAR2 | 64 |  |  | Accounting period name. | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME
PO_HEADER_MODE_OF_TRANSPORT | VARCHAR2 | 32 |  |  | Type of transportation used to ship the product, such as truck, air or boat |  |
PO_HEADER_CARRIER_ID | NUMBER | 38 | 0 |  | Carrier ID (Party ID) |  |
PO_HEADER_SERVICE_LEVEL | VARCHAR2 | 32 |  |  | Priority of transportation that affects how quickly goods are transported |  |
PO_PROCUREMENT_LEDGER_ID | NUMBER | 38 | 0 |  | Primary ledger ID of Procurement BU |  |
AGREEMENT_PROC_LEDGER_ID | NUMBER | 38 | 0 |  | Primary ledger ID of Agreement procurement BU |  |
PO_REQUISITION_LEDGER_ID | NUMBER | 38 | 0 |  | Primary ledger ID of Requisition BU |  |
PO_APPROVER_COUNT | NUMBER | 38 | 0 |  | Purchase order total approver count for revision |  |
PO_FINAL_APPROVER_ID | NUMBER | 38 | 0 |  | Purchase order final approver for revision | DW_PERSON_NAME_CURRENT_D | PERSON_ID
PO_TOTAL_AMENDMENT_COUNT | NUMBER | 38 | 0 |  | Purchase order total amendment count (when po revision number > ) |  |
PO_BUYER_AMENDMENT_COUNT | NUMBER | 38 | 0 |  | Purchase order buyer amendment count (when po revision number > ) |  |
PO_SUPPLIER_AMENDMENT_COUNT | NUMBER | 38 | 0 |  | Purchase order supplier amendment count (when po revision number > ) |  |
PO_DOCUMENT_DATE | DATE |  |  |  | PO Document date for revision |  |
PO_SUBMIT_DATE | DATE |  |  |  | PO Submit date for revision |  |
PO_OPEN_DATE | DATE |  |  |  | PO Open date for revision |  |
PO_APPROVED_DATE | DATE |  |  |  | PO Approval date for revision |  |
PO_COMMUNICATED_DATE | DATE |  |  |  | PO Communicated Date for revision |  |
PURCHASE_ORDER_LINE_NUMBER | NUMBER |  |  |  | Line number |  |
INV_ITEM_ID | NUMBER | 38 | 0 |  | Item unique identifier. | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID ,ORGANIZATION_ID
INV_ITEM_DESCRIPTION | VARCHAR2 | 256 |  |  | Item description. |  |
SUPPLIER_ITEM_NAME | VARCHAR2 | 512 |  |  | Supplier item number |  |
PURCHASING_CATEGORY_ID | NUMBER | 38 | 0 |  | Item category unique identifier | DW_ITEM_CATEGORIES_D | CATEGORY_ID
NEGOTIATED_FLAG | VARCHAR2 | 16 |  |  | Indicates whether the buyer negotiated the price or not (values Y/N) | DW_Y_N_D_TL | CODE
LINE_STATUS | VARCHAR2 | 32 |  |  | Purchase order line status (values could be "CLOSED FOR INVOICING",OPEN, "CLOSED FOR RECEIVING", etc) | DW_PO_LINE_STATUS_D_TL | CODE
NOTE_TO_VENDOR | VARCHAR2 | 999 |  |  | Short note to supplier |  |
QUANTITY | NUMBER |  |  |  | Quantity ordered on the line |  |
PUOM_QUANTITY | NUMBER |  |  |  | Quantity ordered on the line in PUOM |  |
DISCOUNT | NUMBER |  |  |  |  |  |
DISCOUNT_TYPE | VARCHAR2 | 32 |  |  |  |  |
BASE_UNIT_PRICE | NUMBER |  |  |  | Base unit price |  |
BASE_UNIT_PRICE_GLOBAL | NUMBER |  |  |  | Base Unit price in global currency |  |
CANCEL_REASON | VARCHAR2 | 256 |  |  | Cancellation reason provided by employee |  |
CLOSED_REASON | VARCHAR2 | 256 |  |  | Describes why the line is closed |  |
PO_LINE_UNIT_PRICE | NUMBER |  |  |  | Unit price for the line |  |
PO_LINE_UNIT_PRICE_GLOBAL | NUMBER |  |  |  | Unit price for the line in global currency |  |
PO_LINE_UNIT_PRICE_DERIVED | NUMBER |  |  |  | Derived unit price for the line with logic : WHEN PO_LINES_ALL.ORDER_TYPE_LOOKUP_CODE = 'FIXED PRICE' THEN TOTAL_EXCLUDING_ALL_TAX ELSE PO_LINE_UNIT_PRICE |  |
PO_LINE_UNIT_PRICE_DERIVED_GLOBAL | NUMBER |  |  |  | Derived unit price for the line in global currency |  |
DISCOUNT_REASON | VARCHAR2 | 256 |  |  | Description of the reason for the discount |  |
CONSIGNMENT_LINE_FLAG | VARCHAR2 | 16 |  |  | Indicates whether the item on line will be purchased under consignment arrangement from supplier. Values: Y/N. Applicable to both BPA and PO Lines. | DW_Y_N_D_TL | CODE
PO_LINE_TYPE_ID | NUMBER | 38 | 0 |  | Line type unique identifier | DW_PURCHASING_LINE_TYPE_D | LINE_TYPE_ID
NEGOTIATION_HEADER_ID | NUMBER | 38 | 0 |  | Reference to the negotiation id in sourcing |  |
NEGOTIATION_LINE_NUMBER | NUMBER |  |  |  | Reference to the negotiation line number in Sourcing |  |
PO_LINE_CANCEL_DATE | DATE |  |  |  | Cancellation date |  |
PO_LINE_CANCELLED_BY | NUMBER | 38 | 0 |  | Unique identifier of the employee who cancelled the line | DW_PERSON_NAME_CURRENT_D | PERSON_ID
SOURCE_AGREEMENT_HEADER_ID | NUMBER | 38 | 0 |  | Unique identifier of the quotation (standard or planned POs only) or global agreement (standard POs only) referenced by this line |  |
SOURCE_AGREEMENT_LINE_ID | NUMBER | 38 | 0 |  | Unique identifier of the quotation line (standard or planned POs only) or global agreement line (standard POs only) referenced by this line |  |
SOURCE_AGREEMENT_ORDER_NUMBER | VARCHAR2 | 32 |  |  | Header Number of the BPA or CPA |  |
SOURCE_AGREEMENT_LINE_NUMBER | NUMBER | 38 | 0 |  | Line Number of the BPA or CPA |  |
MANUAL_PRICE_CHANGE_FLAG | VARCHAR2 | 16 |  |  | Only for Standard PO lines referencing a Global Agreement, Contract, or Quotation: Y if the user has manually entered a price overriding the source document price, N or null otherwise | DW_Y_N_D_TL | CODE
PO_LINE_UOM_CODE | VARCHAR2 | 16 |  |  | Unit of measure for the quantity ordered | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
NEGO_LINE_CREATION_DATE | DATE |  |  |  | Negotiation line creation date. |  |
ORDER_TYPE_LOOKUP_CODE | VARCHAR2 | 32 |  |  | Value basis of the line |  |
MANUFACTURER | VARCHAR2 | 999 |  |  | Name of the company that manufactures the item being purchased. |  |
MANUFACTURER_PART_NUM | VARCHAR2 | 999 |  |  | Number that uniquely identifies the item as provided by the manufacturer. |  |
PO_LINE_CREATION_DATE | DATE |  |  |  | PO Line Creation date |  |
PO_SCHEDULE_NUMBER | NUMBER |  |  |  | Shipment line number |  |
SHIP_TO_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Ship-to organization unique identifier | DW_INV_ORGANIZATION_D | INV_ORGANIZATION_ID
COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | 16 |  |  | Country of manufacture for this shipment ( values could be US, IN, FR etc..) | DW_PO_COUNTRY_CODE_D_TL | CODE
DESTINATION_TYPE_CODE | VARCHAR2 | 32 |  |  | Final destination of the purchased items ( values could be MANUFACTURING, EXPENSE, INVENTORY etc..) | DW_POR_DESTINATION_TYPE_D_TL | CODE
NOTE_TO_RECEIVER | VARCHAR2 | 999 |  |  | Shipment level Note to receiver, which would hold the note to receiver info coming from req lines. |  |
FINAL_DISCHARGE_LOCATION_ID | NUMBER | 38 | 0 |  | The final discharge location identifier. | DW_WORKER_LOCATION_D | LOCATION_ID
PRODUCT_TYPE | VARCHAR2 | 256 |  |  | The value of product type specifies whether the transaction line is for a good, or a service, or it is a memo line. ( values could be GOODS,SERVICES) | DW_ZX_PRODUCT_TYPE_D_TL | CODE
RECEIVING_ROUTING_ID | NUMBER | 38 | 0 |  | Receipt routing unique identifier | DW_RCV_ROUTING_HEADERS_D_TL | CODE
ALLOW_SUBSTITUTE_RECEIPTS_FLAG | VARCHAR2 | 16 |  |  | Indicates whether substitute items can be received in place of the ordered items ( values would be Y/N) | DW_Y_N_D_TL | CODE
MATCH_OPTION | VARCHAR2 | 32 |  |  | Indicator of whether the invoice for the shipment should be matched to the purchase order or the receipt ( values would be R - Receipt, P - Order, C - Consumption Advice) | DW_PO_MATCH_OPTION_D_TL | CODE
PO_SCH_QUANTITY | NUMBER |  |  |  | Quantity ordered or break quantity for blanket purchase orders, RFQs and quotations |  |
PUOM_PO_SCH_QUANTITY | NUMBER |  |  |  | Quantity ordered or break quantity for blanket purchase orders, RFQs and quotations in PUOM |  |
PO_SCH_QUANTITY_CANCELLED | NUMBER |  |  |  | Quantity cancelled |  |
PUOM_PO_SCH_QUANTITY_CANCELLED | NUMBER |  |  |  | Quantity cancelled in PUOM |  |
QUANTITY_RECEIVED | NUMBER |  |  |  | Quantity received until today |  |
PUOM_QUANTITY_RECEIVED | NUMBER |  |  |  | Quantity received until today in PUOM |  |
QUANTITY_SHIPPED | NUMBER |  |  |  | Quantity shipped |  |
PUOM_QUANTITY_SHIPPED | NUMBER |  |  |  | Quantity shipped in PUOM |  |
QUANTITY_ACCEPTED | NUMBER |  |  |  | Quantity accepted after inspection, up until today |  |
PUOM_QUANTITY_ACCEPTED | NUMBER |  |  |  | Quantity accepted after inspection, up until today in PUOM |  |
QUANTITY_REJECTED | NUMBER |  |  |  | Quantity rejected after inspection, up until today |  |
PUOM_QUANTITY_REJECTED | NUMBER |  |  |  | Quantity rejected after inspection, up until today in PUOM |  |
AMOUNT_ACCEPTED | NUMBER |  |  |  | Amount Accepted for service lines |  |
AMOUNT_RECEIVED | NUMBER |  |  |  | Stores the amount received for service lines |  |
AMOUNT_SHIPPED | NUMBER |  |  |  | Amount pending for Work Confirmation |  |
AMOUNT_ACCEPTED_GLOBAL | NUMBER |  |  |  | Amount Accepted for service lines in global currency |  |
AMOUNT_RECEIVED_GLOBAL | NUMBER |  |  |  | Stores the amount received for service lines in global currency |  |
AMOUNT_SHIPPED_GLOBAL | NUMBER |  |  |  | Amount pending for Work Confirmation in global currency |  |
PROMISED_DATE | DATE |  |  |  | Promised Delivery Date. A date that the supplier has promised to deliver the ordered item or service |  |
NEED_BY_DATE | DATE |  |  |  | Requested Delivery Date. A date that the buying company requests the ordered item or service to be delivered |  |
UOM_CODE | VARCHAR2 | 16 |  |  | Unit of measure for the quantity ordered | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
PUOM_CODE | VARCHAR2 | 16 |  |  | Primary Unit of measure for the quantity ordered | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
PUOM_CONVERSION_FACTOR | NUMBER |  |  |  | Conversion Factor from Transation UOM To PUOM |  |
PROMISED_SHIP_DATE | DATE |  |  |  | A date that the supplier has promised to ship the item ordered by the buying company |  |
REQUESTED_SHIP_DATE | DATE |  |  |  | A date that the buying company requests the ordered item ready to ship |  |
CLOSED_FOR_INVOICE_DATE | DATE |  |  |  | Date when the Shipment is closed for Invoice |  |
CLOSED_FOR_RECEIVING_DATE | DATE |  |  |  | Date when the Shipment is closed for receiving |  |
CANCEL_DATE | DATE |  |  |  | Cancellation date |  |
SHIPMENT_CLOSED_DATE | DATE |  |  |  | Date when the Shipment is closed for both Receiving and Invoice |  |
SHIP_TO_CUST_ID | NUMBER | 38 | 0 |  | Customer to whom merchandise is being sent | DW_PARTY_D | PARTY_ID
SHIP_TO_CUST_LOCATION_ID | NUMBER | 38 | 0 |  | Attribute,Location where the supplier should ship the goods | DW_CUSTOMER_LOCATION_D | CUSTOMER_LOCATION_ID
SHIP_TO_LOCATION_ID | NUMBER | 38 | 0 |  | Unique identifier for the ship-to location | DW_WORKER_LOCATION_D | LOCATION_ID
MATCH_APPROVAL_LEVEL | VARCHAR2 | 16 |  |  | Match approval level. Values can be 2-way, 3 way, 4 way. | DW_PO_MATCHING_TYPE_D_TL | CODE
SCHEDULE_STATUS | VARCHAR2 | 32 |  |  | Shipment status(applicable only to SPO) | DW_PO_SCHEDULE_STATUS_D_TL | CODE
BACK_TO_BACK_FLAG | VARCHAR2 | 16 |  |  | Indicates the purchase order schedule has a backing sales order that is fulfilled using a back to back order. | DW_Y_N_D_TL | CODE
PO_LINE_LOC_MODE_OF_TRANSPORT | VARCHAR2 | 32 |  |  | Type of transportation used to ship the product, such as truck, air or boat. IFNULL(SCHEDULE columns, HEADER columns) logic is implemented for this | DW_PO_MODE_OF_TRANSPORT_D_TL | CODE
PO_LINE_LOC_CARRIER_ID | NUMBER | 38 | 0 |  | Type of carrier for the RFQ or quotation shipment. IFNULL(SCHEDULE columns, HEADER columns) logic is implemented for this | DW_PARTY_D | PARTY_ID
PO_LINE_LOC_SERVICE_LEVEL | VARCHAR2 | 32 |  |  | Priority of transportation that affects how quickly goods are transported. IFNULL(SCHEDULE columns, HEADER columns) logic is implemented for this | DW_PO_SERVICE_LEVELS_D_TL | CODE
PRICE_OVERRIDE | NUMBER |  |  |  | Order shipment price or break price for blanket purchase orders, RFQs, and quotations |  |
SALES_ORDER_NUMBER | VARCHAR2 | 64 |  |  | Backing Sales Order Number |  |
SALES_ORDER_LINE_NUMBER | VARCHAR2 | 64 |  |  | Backing Sales Order Line Number |  |
SALES_ORDER_SCHEDULE_NUMBER | VARCHAR2 | 64 |  |  | Backing Sales Order Schedule Number |  |
CUSTOMER_PO_NUMBER | VARCHAR2 | 64 |  |  | Customer PO number on the Sales Order. |  |
CUSTOMER_PO_LINE_NUMBER | VARCHAR2 | 64 |  |  | Customer PO number on the Sales Line Order. |  |
CUSTOMER_PO_SCHEDULE_NUMBER | VARCHAR2 | 64 |  |  | Customer PO number on the Sales Schedule Order. |  |
WORK_ORDER_ID | NUMBER | 38 | 0 |  | Unique identifier for the work order |  |
WORK_ORDER_OPERATION_ID | NUMBER | 38 | 0 |  | The unique identifier of a work order operation |  |
WORK_ORDER_NUMBER | VARCHAR2 | 128 |  |  | Number of the manufacturing work order |  |
WORK_ORDER_OPERATION_SEQ | NUMBER |  |  |  | Indicates execution sequence of the work order operation |  |
PO_DISTRIBUTION_NUMBER | NUMBER |  |  |  | Distribution number |  |
PO_DISTRIBUTION_CREATION_DATE | TIMESTAMP |  |  |  | Indicates the date of the creation of the distribution row |  |
ACCRUAL_ACCOUNT_ID | NUMBER | 38 | 0 |  | Unique identifier for the General Ledger accrual account | DW_GL_CODE_COMBINATION_D | CODE_COMBINATION_ID
VARIANCE_ACCOUNT_ID | NUMBER | 38 | 0 |  | Unique identifier for the General Ledger variance account | DW_GL_CODE_COMBINATION_D | CODE_COMBINATION_ID
QUANTITY_CANCELLED | NUMBER |  |  |  | Quantity cancelled for the distribution |  |
PUOM_QUANTITY_CANCELLED | NUMBER |  |  |  | Quantity cancelled for the distribution in PUOM |  |
CONSIGNMENT_QUANTITY | NUMBER |  |  |  | Quantity In Consigned Inventory after deliver transaction |  |
PUOM_CONSIGNMENT_QUANTITY | NUMBER |  |  |  | Quantity In Consigned Inventory after deliver transaction in PUOM |  |
QUANTITY_BILLED | NUMBER |  |  |  | Quantity invoiced by Oracle Payables against the distribution |  |
PUOM_QUANTITY_BILLED | NUMBER |  |  |  | Quantity invoiced by Oracle Payables against the distribution in PUOM |  |
QUANTITY_DELIVERED | NUMBER |  |  |  | Quantity delivered against the distribution |  |
PUOM_QUANTITY_DELIVERED | NUMBER |  |  |  | Quantity delivered against the distribution in PUOM |  |
AMOUNT_BILLED | NUMBER |  |  |  | Amount invoiced by Oracle Payables against the distribution |  |
AMOUNT_DELIVERED | NUMBER |  |  |  | Amount delivered for service lines |  |
AMOUNT_CANCELLED | NUMBER |  |  |  | Amount cancelled for service lines |  |
RECOVERABLE_EXCLUSIVE_TAX | NUMBER |  |  |  | The Recoverable exclusive tax amount for the distribution. |  |
NONRECOVERABLE_EXCLUSIVE_TAX | NUMBER |  |  |  | The Nonrecoverable exclusive tax amount for the distribution. |  |
RECOVERABLE_INCLUSIVE_TAX | NUMBER |  |  |  | The portion of the taxes paid that is included in the Distribution Ordered amount and which is recoverable. |  |
NONRECOVERABLE_INCLUSIVE_TAX | NUMBER |  |  |  | The portion of the taxes paid that is included in the Distribution Ordered amount and which is nonrecoverable. |  |
TOTAL_EXCLUDING_ALL_TAX | NUMBER |  |  |  | The Purchase order distribution amount that is exclusive of all the taxes |  |
AMOUNT_BILLED_GLOBAL | NUMBER |  |  |  | Amount invoiced by Oracle Payables against the distribution in global currency |  |
AMOUNT_DELIVERED_GLOBAL | NUMBER |  |  |  | Amount delivered for service lines in global currency |  |
AMOUNT_CANCELLED_GLOBAL | NUMBER |  |  |  | Amount cancelled for service lines in global currency |  |
RECOVERABLE_EXCLUSIVE_TAX_GLOBAL | NUMBER |  |  |  | The Recoverable exclusive tax amount for the distribution in global currency |  |
NONRECOVERABLE_EXCLUSIVE_TAX_GLOBAL | NUMBER |  |  |  | The Nonrecoverable exclusive tax amount for the distribution in global currency |  |
RECOVERABLE_INCLUSIVE_TAX_GLOBAL | NUMBER |  |  |  | The portion of the taxes paid in global currency that is included in the Distribution Ordered amount and which is recoverable. |  |
NONRECOVERABLE_INCLUSIVE_TAX_GLOBAL | NUMBER |  |  |  | The portion of the taxes paid in global currency that is included in the Distribution Ordered amount and which is nonrecoverable. |  |
TOTAL_EXCLUDING_ALL_TAX_GLOBAL | NUMBER |  |  |  | The Purchase order distribution amount in global currency that is exclusive of all the taxes |  |
DELIVER_TO_PERSON_ID | NUMBER | 38 | 0 |  | Unique identifier for the requester | DW_PERSON_NAME_CURRENT_D | PERSON_ID
ORIGINAL_QUANTITY_ORDERED | NUMBER |  |  |  | Quantity ordered on the distribution |  |
PUOM_ORIGINAL_QUANTITY_ORDERED | NUMBER |  |  |  | Quantity ordered on the distribution in PUOM |  |
PO_DIST_RATE_DATE | DATE |  |  |  | Currency conversion date |  |
PO_DIST_RATE | NUMBER |  |  |  | Currency conversion rate |  |
DELIVER_TO_LOCATION_ID | NUMBER | 38 | 0 |  | Unique identifier for the delivery location | DW_CUSTOMER_LOCATION_D | CUSTOMER_LOCATION_ID
DELIVER_TO_CUST_LOCATION_ID | NUMBER | 38 | 0 |  | The final location where goods will be delivered that were previously received from a supplier | DW_CUSTOMER_LOCATION_D | CUSTOMER_LOCATION_ID
DELIVER_TO_CUST_ID | NUMBER | 38 | 0 |  | Customer to whom merchandise is being delivered |  |
GL_CODE_COMBINATION_ID | NUMBER | 38 | 0 |  | Unique identifier for the General Ledger charge account | DW_GL_CODE_COMBINATION_D | CODE_COMBINATION_ID
PO_DIST_CREATED_BY | VARCHAR2 | 64 |  |  | Who column: indicates the user who created the distribution | DW_USER_D | USERNAME
GLOBAL_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Global currency code. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
GLOBAL_CURRENCY_EXCH_RATE | NUMBER |  |  |  | Global currency conversion rate. |  |
COST_CENTER_SEGMENT | VARCHAR2 | 32 |  |  | Cost center segment. | DW_COST_CENTER_D | COST_CENTER_SEGMENT
COST_CENTER_VALUESET_CODE | VARCHAR2 | 64 |  |  | Cost center value set code. | DW_COST_CENTER_D | COST_CENTER_VALUESET_CODE
GL_BALANCING_SEGMENT | VARCHAR2 | 32 |  |  | Balancing segment. | DW_BALANCING_SEGMENT_D | GL_BALANCING_SEGMENT
GL_BLNC_SGMNT_VALUESET_CODE | VARCHAR2 | 64 |  |  | Balancing segment value set code. | DW_BALANCING_SEGMENT_D | GL_BLNC_SGMNT_VALUESET_CODE
NATURAL_ACCOUNT_SEGMENT | VARCHAR2 | 32 |  |  | Natural account segment. | DW_NATURAL_ACCOUNT_D | NATURAL_ACCOUNT_SEGMENT
NTRL_ACNT_SGMNT_VALUESET_CODE | VARCHAR2 | 64 |  |  | Natural account value set code. | DW_NATURAL_ACCOUNT_D | NTRL_ACNT_SGMNT_VALUESET_CODE
GL_SEGMENT1 | VARCHAR2 | 32 |  |  | Accounting segment 1. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT1_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 1 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT2 | VARCHAR2 | 32 |  |  | Accounting segment 2. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT2_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 2 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT3 | VARCHAR2 | 32 |  |  | Accounting segment 3. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT3_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 3 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT4 | VARCHAR2 | 32 |  |  | Accounting segment 4. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT4_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 4 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT5 | VARCHAR2 | 32 |  |  | Accounting segment 5. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT5_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 5 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT6 | VARCHAR2 | 32 |  |  | Accounting segment 6. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT6_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 6 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT7 | VARCHAR2 | 32 |  |  | Accounting segment 7. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT7_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 7 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT8 | VARCHAR2 | 32 |  |  | Accounting segment 8. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT8_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 8 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT9 | VARCHAR2 | 32 |  |  | Accounting segment 9. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT9_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 9 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT10 | VARCHAR2 | 32 |  |  | Accounting segment 1. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT10_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 1 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
PROJECT_ID | NUMBER | 38 | 0 |  | Identifier of the project used to build the transaction descriptive flexfield for project related transaction distributions |  |
TASK_ID | NUMBER | 38 | 0 |  | Identifier of the task used to build the transaction descriptive flexfield for project related transaction distributions. |  |
EXPENDITURE_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Organization identifier used to build the transaction descriptive flexfield for project related transaction distributions. |  |
EXPENDITURE_TYPE_ID | NUMBER | 38 | 0 |  | Identifier of the expenditure used to build the transaction descriptive flexfield for project related transaction distributions. |  |
REQUISITION_HEADER_ID | NUMBER | 38 | 0 |  | Unique system generated Requisition Order Id |  |
REQUISITION_LINE_ID | NUMBER | 38 | 0 |  | Requisition Line Id |  |
REQUISITION_DISTRIBUTION_ID | NUMBER | 38 | 0 |  | Requisition distribution unique identifier |  |
REQUISITION_BU_ID | NUMBER | 38 | 0 |  | Requisition business unit identifier. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
REQUISITION_NUMBER | VARCHAR2 | 64 |  |  | Requisition Number |  |
REQUISITION_ITEM_SOURCE | VARCHAR2 | 32 |  |  | Indicates whether item comes from catalog noncatalog quick create punchout req import or service | DW_POR_ITEM_SOURCE_D_TL | CODE
REQUISITION_LINE_NUMBER | NUMBER |  |  |  | Line number |  |
REQUISITION_URGENT_FLAG | VARCHAR2 | 16 |  |  | Indicates whether the requisition is urgent or not ( values could be Y/N) | DW_Y_N_D_TL | CODE
REQUISITION_NEGOTIATED_FLAG | VARCHAR2 | 16 |  |  | Indicates whether price has been negotiated by buyer ( values could be Y/N) | DW_Y_N_D_TL | CODE
REQUISITION_LAST_APPROVAL_DATE | DATE |  |  |  | This attribute captures the time when the requisition lines is last approved. It is used to compute the average approval time metric for the items on requisition lines. |  |
REQUISITION_LAST_SUBMITTED_DATE | DATE |  |  |  | This attribute captures the time when the requisition line is last submitted for approval. It is used to compute the average approval time metric for the items on requisition lines. |  |
REQUISITION_UNIT_PRICE | NUMBER |  |  |  | Unit price in functional currency |  |
REQUISITION_MODIFIED_BY_BUYER_FLAG | VARCHAR2 | 16 |  |  | Indicates whether a buyer modified this line or not | DW_Y_N_D_TL | CODE
REQUISITION_IMPORT_SOURCE | VARCHAR2 | 32 |  |  | Source of requisition from Requisition Import |  |
REQUISITION_EMERGENCY_REQ_FLAG | VARCHAR2 | 16 |  |  | Stores state of emergency req checkbox | DW_Y_N_D_TL | CODE
REQUISITION_JUSTIFICATION | VARCHAR2 | 999 |  |  | Note to approver |  |
REQUISITION_CREATION_DATE | DATE |  |  |  | Who column: indicates the date and time of the creation of the row. |  |
REQUISITION_APPROVED_DATE | DATE |  |  |  | Date when Requisition is approved |  |
REQUISITION_PREPARER_ID | NUMBER | 38 | 0 |  | Unique identifier of the employee who prepared the requisition | DW_PERSON_NAME_CURRENT_D | PERSON_ID
QUANTITY_ORDERED | NUMBER |  |  |  | Ordered quantity ( this is net of quantity i.e ORIGINAL_QUANTITY_ORDERED - QUANTITY_CANCELLED) |  |
PUOM_QUANTITY_ORDERED | NUMBER |  |  |  | Ordered quantity in PUOM ( this is net of quantity i.e ORIGINAL_QUANTITY_ORDERED - QUANTITY_CANCELLED) |  |
PRE_PROCESSING_LEAD_TIME | NUMBER |  |  |  | Pre processing lead time in days (IFNULL(PO Approval date, PO Document date) - PO Creation date) |  |
PR_TO_PO_CYCLE_TIME | NUMBER |  |  |  | PR to PO cycle time in days ( PO Creation date - Requisition Approval date) |  |
PO_OPEN_CYCLE_TIME | NUMBER |  |  |  | PO Open cycle time in days (PO Processed date - PO Creation date) |  |
PO_APPROVAL_CYCLE_TIME | NUMBER |  |  |  |  |  |
NEGO_TO_PO_CYCLE_TIME | NUMBER |  |  |  | Negotiation to PO cycle time in days (IFNULL(PO Approval date, PO Document date) - Negotiation creation date) |  |
PO_CLOSE_CYCLE_TIME | NUMBER |  |  |  | PO Close cycle time in days (PO Close date - PO Creation date) |  |
ORDERED_AMOUNT | NUMBER |  |  |  | Ordered amount ( this is sum of TAX_EXCLUSIVE_AMOUNT, RECOVERABLE_INCLUSIVE_TAX and NONRECOVERABLE_INCLUSIVE_TAX) |  |
TOTAL_EXCLUSIVE_TAX_AMOUNT | NUMBER |  |  |  | Total exclusive tax amount ( RECOVERABLE_TAX + NONRECOVERABLE_TAX) |  |
TOTAL_AMOUNT | NUMBER |  |  |  | Total amount including all taxes ( sum of TAX_EXCLUSIVE_AMOUNT, RECOVERABLE_INCLUSIVE_TAX, NONRECOVERABLE_INCLUSIVE_TAX, RECOVERABLE_TAX, NONRECOVERABLE_TAX) |  |
ORDERED_AMOUNT_GLOBAL | NUMBER |  |  |  | Ordered amount in global currency |  |
TOTAL_EXCLUSIVE_TAX_AMOUNT_GLOBAL | NUMBER |  |  |  | Total exclusive tax amount in global currency |  |
TOTAL_AMOUNT_GLOBAL | NUMBER |  |  |  | Total amount including all taxes in global currency |  |
LOCATION_TYPE | VARCHAR2 | 32 |  |  | Shipping location type (values could be INTERNAL, EXTERNAL), If SHIP to location ID is available then 'INTERNAL' else 'EXTERNAL' | DW_PO_LOCATION_TYPE_D_TL | CODE
OVER_RECEIPT_QUANTITY_FLAG | VARCHAR2 | 16 |  |  | Indicates whether quantity received is greater than ordered, flag value - YES/NO | DW_Y_N_D_TL | CODE

Copyright © 2019, 2025, Oracle and/or its affiliates.