Purchase Order Fact
Module: Purchasing
PO_SCHEDULE_ID, PURCHASE_ORDER_LINE_ID, PURCHASE_ORDER_ID, PO_DISTRIBUTION_ID
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 | 2048 | 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 | ||||
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 | 2048 | 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. | ||||
PO_DISTRIBUTION_NUMBER | NUMBER | Distribution number | |||||
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 | 1024 | 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 |