DW_PURCHASE_ORDER_CF

Purchase Order Fact

Details

Module: Purchasing

Key Columns

PURCHASE_ORDER_LINE_ID, PURCHASE_ORDER_ID, PO_DISTRIBUTION_ID, PO_SCHEDULE_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