DW_PURCHASE_ORDER_CF

Purchase Order Fact

Details

Module: Purchasing

Key Columns

PO_DISTRIBUTION_ID, PO_SCHEDULE_ID, PURCHASE_ORDER_LINE_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     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_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    
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, 2023, Oracle and/or its affiliates.