DW_INVOICE_SPEND_CF

Invoice Spend Currency Fact

Details

Module: Purchasing

Key Columns

AE_HEADER_ID, INVOICE_DISTRIBUTION_ID, REF_AE_HEADER_ID, INVOICE_ID, TEMP_LINE_NUM, INVOICE_LINE_NUMBER, PREPAY_APP_DIST_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
INVOICE_ID NUMBER 38 0 True Invoice identifier.    
INVOICE_LINE_NUMBER NUMBER 38 0 True Invoice line number.    
INVOICE_DISTRIBUTION_ID NUMBER 38 0 True Invoice distribution identifier.    
PREPAY_APP_DIST_ID NUMBER 38 0 True Prepayment application distribution identifier.    
REF_AE_HEADER_ID NUMBER 38 0 True Reversed sub-ledger journal entry header identifier.    
TEMP_LINE_NUM NUMBER 38 0 True Intermediary line number generated by the accounting engine when the entries are in most detail form.    
AE_HEADER_ID NUMBER 38 0 True Sub-ledger journal entry identifier.    
SOURCE_RECORD_ID VARCHAR2 256     Source record identifier. Value is derived from a combination of invoice identifier, invoice line number, distribution line number and invoice distribution identifier.    
INVOICE_NUMBER VARCHAR2 64     Invoice number.    
INVOICE_DESCRIPTION VARCHAR2 256     Invoice description.    
INVOICE_SOURCE_CODE VARCHAR2 32     Invoice source. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=SOURCE. Possible values are INVOICE GATEWAY, Recurring Invoice, Self Service, Confirm Payment Batch, LOANS, Manual Invoice Entry, Quick Check and so on. DW_SCM_CODE_VALUES_LKP_TL CODE
INVOICE_TYPE_CODE VARCHAR2 32     Invoice type. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=INVOICE TYPE. Possible values are STANDARD, CREDIT, DEBIT, PAYMENT REQUEST, PREPAYMENT, INTEREST, INVOICE REQUEST, AWT, CREDIT MEMO REQUEST, EXPENSE REPORT, MIXED, and so on. DW_SCM_CODE_VALUES_LKP_TL CODE
INVOICE_PAYMENT_TERMS_ID NUMBER 38 0   Payment terms identifier. DW_AP_TERMS_D PAYMENT_TERMS_ID
INVOICE_VALIDATION_STATUS_CODE VARCHAR2 32     Invoice validation status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AP_INVOICE_VALIDATION_STATUS_CODE. Possible Values are Approved, Cancelled, Unpaid, Available, Needs Reapproval DW_CODE_VALUES_LKP_TL CODE
INVOICE_APPROVAL_STATUS_CODE VARCHAR2 64     Invoice approval status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AP_WFAPPROVAL_STATUS. Possible values are INITIATED, MANUALLY APPROVED, NOT REQUIRED, REJECTED, REMOVED FROM APPROVAL, REQUIRED, WFAPPROVED, etc. DW_CODE_VALUES_LKP_TL CODE
INVOICE_INTER_COMPANY_FLAG VARCHAR2 16     Inter-company flag added to incorporate FUN team's inter-company feature. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO DW_CODE_VALUES_LKP_TL CODE
INVOICE_RECEIVED_DATE DATE       Date when invoice is received. DW_DAY_D CALENDAR_DATE
INVOICED_ON_DATE DATE       Date when invoiced is created. DW_DAY_D CALENDAR_DATE
INVOICE_CREATION_DATE TIMESTAMP       Date when invoice row was created in the table. DW_DAY_D CALENDAR_DATE
INVOICE_CREATION_DATE_1 DATE       Date when invoice row was created in the table.    
INVOICE_CANCELLED_DATE DATE       Date when invoice was cancelled. DW_DAY_D CALENDAR_DATE
INVOICE_ACCOUNTING_DATE DATE       Date when invoice was accounted DW_DAY_D CALENDAR_DATE
INVOICE_ACCOUNTING_STATUS_CODE VARCHAR2 32     Invoice Header accounting status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AP_ACCOUNTING_STATUS. Possible values are Accounted, Unaccounted, Partially Accounted. DW_CODE_VALUES_LKP_TL CODE
INVOICE_PAYMENT_STATUS_CODE VARCHAR2 16     Invoice payment status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=INVOICE PAYMENT STATUS. Possible values are Y, N and P DW_CODE_VALUES_LKP_TL CODE
PAYABLES_BU_ID NUMBER 38 0   Payable invoicing business unit identifier. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEGAL_ENTITY_ID NUMBER 38 0   Legal entity identifier. DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
PARTY_ID NUMBER 38 0   Party identifier. DW_PARTY_D PARTY_ID
SUPPLIER_ID NUMBER 38 0   Supplier identifier. DW_PARTY_D SUPPLIER_ID
SUPPLIER_SITE_ID NUMBER 38 0   Supplier site identifier. DW_SUPPLIER_SITE_D SUPPLIER_SITE_ID
SUPPLIER_SITE_PROC_BU_ID NUMBER 38 0   Procurement business unit identifier. DW_INTERNAL_ORG_D ORGANIZATION_ID
FISCAL_PERIOD_SET_NAME VARCHAR2 16     Accounting calendar name. DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
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
HEADER_CREATED_BY_USER_ID VARCHAR2 128     User who created the invoice. DW_USER_D USERNAME
HEADER_UPDATED_BY_USER_ID VARCHAR2 128     User who updated the invoice. DW_USER_D USERNAME
LINE_DESCRIPTION VARCHAR2 256     Description of the invoice line.    
LINE_SOURCE_CODE VARCHAR2 32     Source of the invoice line. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AP_INVOICE_LINE_SOURCE. Possible values are Imported, Maual Entry, Etax, Header Match DW_SCM_CODE_VALUES_LKP_TL CODE
LINE_TYPE_LOOKUP_CODE VARCHAR2 32     Line type. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AP_INVOICE_LINE_TYPE. Possible values are Item, Freight, Miscellaneous, tax, Prepay DW_SCM_CODE_VALUES_LKP_TL CODE
REQUESTER_ID NUMBER 38 0   The name of the person who the requested items are intended for. DW_PERSON_D PERSON_ID
LINE_PURCHASING_CATEGORY_ID NUMBER 38 0   Item category unique identifier. DW_ITEM_CATEGORIES_D CATEGORY_ID
CONSUMPTION_ADVICE_AVAILABLE VARCHAR2 16     Basis Consumption Advice availability. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO DW_CODE_VALUES_LKP_TL CODE
SHIP_TO_LOCATION_ID NUMBER 38 0   Ship to location ID. Value entered by user only if line is not PO matched. DW_WORKER_LOCATION_D LOCATION_ID
INVENTORY_ITEM_ID NUMBER       Inventory item identifier. DW_INVENTORY_ITEM_D INVENTORY_ITEM_ID
ITEM_DESCRIPTION VARCHAR2 256     Description of the item in the invoice line.    
PRODUCT_TYPE VARCHAR2 256     Type of product (Goods/Services). Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AP_PRODUCT_TYPE.    
LINE_APPROVAL_STATUS_CODE VARCHAR2 32     Invoice line approval status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AP_WFAPPROVAL_STATUS. Possible values are INITIATED, MANUALLY APPROVED, NOT REQUIRED, REJECTED, REMOVED FROM APPROVAL, REQUIRED, WFAPPROVED, etc. DW_CODE_VALUES_LKP_TL CODE
DISTRIBUTION_LINE_NUMBER NUMBER 38 0   Distribution line number.    
DISTRIBUTION_DESCRIPTION VARCHAR2 256     Distribution description.    
DISTRIBUTION_TYPE_CODE VARCHAR2 32     Invoice type. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=INVOICE DISTRIBUTION TYPE. Possible values are ITEM, ACCRUAL, AWT, IPV, ERV, FREIGHT, RETAINAGE etc. DW_SCM_CODE_VALUES_LKP_TL CODE
PREPAY_DIST_TYPE_CODE VARCHAR2 32     Type of prepayment application distribution.    
DISTRIBUTION_VALIDATION_STATUS VARCHAR2 32     Invoice Distribution validation status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AP_INVOICE_VALIDATION_STATUS_CODE. Possible values are Approved, Cancelled, Rejected, Needs Reapproval. DW_CODE_VALUES_LKP_TL CODE
DISTRIBUTION_MATCH_TYPE VARCHAR2 32     Indicates whether an invoice matched a PO or a receipt of material. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=MATCH_STATUS. Possible values are NOT_MATCHED, ITEM_TO_SERVICE_PO, ITEM_TO_PO, ITEM_TO_CA DW_SCM_CODE_VALUES_LKP_TL CODE
DIST_CANCELLED_INDICATOR VARCHAR2 16     Indicates a cancelled distribution. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. DW_CODE_VALUES_LKP_TL CODE
DIST_REVERSAL_INDICATOR VARCHAR2 16     Flag that indicates if distribution is part of a reversal pair. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. DW_CODE_VALUES_LKP_TL CODE
DISTRIBUTION_ACCOUNTING_DATE DATE       Accounting date. DW_DAY_D CALENDAR_DATE
DISTRIBUTION_POSTED_FLAG VARCHAR2 16     Invoice distribution accounting status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AP_POSTING_STATUS. Possible values are Y,N,S,P. DW_CODE_VALUES_LKP_TL CODE
TRACK_AS_ASSET VARCHAR2 16     Flag indicates that the item should be treated as an asset. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO DW_CODE_VALUES_LKP_TL CODE
CREATED_BY_USER_ID VARCHAR2 128     User who created the record. DW_USER_D USERNAME
UPDATED_BY_USER_ID VARCHAR2 128     User who updated the record. DW_USER_D USERNAME
PAYABLES_CODE_COMB_ID NUMBER 38 0   Expense account identifier. DW_GL_CODE_COMBINATION_D CODE_COMBINATION_ID
GL_CODE_COMBINATION_ID NUMBER 38 0   Payable liability account identifier. DW_GL_CODE_COMBINATION_D CODE_COMBINATION_ID
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 10. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT10_VALUESET_CODE VARCHAR2 64     Accounting segment 10 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
RECEIVING_SHIPMENT_RECEIPT_NUM VARCHAR2 32     Shipment receipt number.    
RECEIVING_SHIPMENT_LINE_NUMBER NUMBER 38 0   Shipment line number.    
RECEIVING_SHIPMENT_RECEIPT_ID NUMBER 38 0   Shipment receipt identifier.    
RECEIVING_SHIPMENT_LINE_ID NUMBER 38 0   Shipment line identifier.    
PURCHASE_ORDER_ID NUMBER 38 0   Purchase order header ID    
PURCHASE_ORDER_NUMBER VARCHAR2 32     Purchase order number.    
PO_PAYMENT_TERMS_ID NUMBER 38 0   Purchase order Payment terms identifier. DW_AP_TERMS_D PAYMENT_TERMS_ID
PROCUREMENT_BU_ID NUMBER 38 0   Procurement business unit identifier. DW_INTERNAL_ORG_D ORGANIZATION_ID
REQUISITION_BU_ID NUMBER 38 0   Requisition business unit identifier. DW_INTERNAL_ORG_D ORGANIZATION_ID
BUYER_ID NUMBER 38 0   Buyer unique identifier. DW_PERSON_D PERSON_ID
MODE_OF_TRANSPORT VARCHAR2 32     Type of transportation used to ship the product such as truck, air or boat. Values are from the table DW_SCM_CODE_VALUES_LKP_TL with CODE_TYPE=WSH_MODE_OF_TRANSPORT. Possible values are PARCEL, LTL etc. DW_SCM_CODE_VALUES_LKP_TL CODE
PO_CREATION_DATE TIMESTAMP       Indicates the date and time of the creation of the row. DW_DAY_D CALENDAR_DATE
PO_CREATION_DATE_1 DATE       Indicates the date and time of the creation of the row.    
PURCHASE_ORDER_LINE_ID NUMBER 38 0   Purchase order line ID.    
PURCHASE_ORDER_LINE_NUMBER NUMBER       Purchase order line number.    
PO_LINE_PURCHASING_CATEGORY_ID NUMBER 38 0   Item category unique identifier. DW_ITEM_CATEGORIES_D CATEGORY_ID
SUPPLIER_ITEM_NAME VARCHAR2 512     Supplier item number.    
PO_LINE_TYPE_ID NUMBER 38 0   Line type unique identifier. DW_PURCHASING_LINE_TYPE_D LINE_TYPE_ID
PO_LINE_ITEM_ID NUMBER 38 0   Purchase order item unique identifier. DW_INVENTORY_ITEM_D INVENTORY_ITEM_ID
PO_LINE_ITEM_DESCRIPTION VARCHAR2 256     Purchase order item description.    
SPEND_ITEM_ID NUMBER 38 0   Purchase order item unique identifier. This is coalesced from PO_LINE_ITEM_ID (purchase order side) and INVENTORY_ITEM_ID (invoice side). DW_INVENTORY_ITEM_D INVENTORY_ITEM_ID
SPEND_ITEM_DESCRIPTION VARCHAR2 256     Purchase order item description. This is coalesced from PO_LINE_ITEM_DESCRIPTION (purchase order side) and ITEM_DESCRIPTION (invoice side).    
SPEND_PURCHASING_CATEGORY_ID NUMBER 38 0   Item category unique identifier. This is coalesced from PO_LINE_PURCHASING_CATEGORY_ID (purchase order side) and LINE_PURCHASING_CATEGORY_ID (invoice side). DW_ITEM_CATEGORIES_D CATEGORY_ID
SOURCE_AGREEMENT_DOC_STYLE_ID NUMBER 38 0   Agreement Document Style Identifier. DW_DOC_STYLE_LINES_TL STYLE_ID
SOURCE_AGREEMENT_DOC_TYPE VARCHAR2 32     Agreement Document Type (Blanket/Contract). Values are from the table DW_SCM_CODE_VALUES_LKP_TL with CODE_TYPE=POO:DOCUMENT_TYPE DW_SCM_CODE_VALUES_LKP_TL CODE
AGREEMENT_PROCUREMENT_BU_ID NUMBER 38 0   Agreement Procurement business unit identifier. DW_INTERNAL_ORG_D ORGANIZATION_ID
PO_SCHEDULE_ID NUMBER 38 0   Purchase order schedule identifier.    
PO_SCHEDULE_NUMBER NUMBER       Purchase order schedule number.    
MATCH_OPTION VARCHAR2 32     Indicator of whether the invoice for the shipment should be matched to the purchase order or the receipt. Values are from the table DW_SCM_CODE_VALUES_LKP_TL with CODE_TYPE=PO INVOICE MATCH OPTION. DW_SCM_CODE_VALUES_LKP_TL CODE
SHIP_TO_ORGANIZATION_ID NUMBER 38 0   Ship-to organization unique identifier for purchase order matched invoices. DW_INTERNAL_ORG_D ORGANIZATION_ID
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
PO_DISTRIBUTION_ID NUMBER 38 0   Purchase order distribution ID.    
PO_DISTRIBUTION_NUMBER NUMBER       Purchase order distribution number.    
DESTINATION_TYPE VARCHAR2 32     Final destination of the purchased items. Values are from the table DW_SCM_CODE_VALUES_LKP_TL with CODE_TYPE=POR_DESTINATION_TYPE. Possible values are Drop-ship, Inventory, Expense, Manufacturing etc. DW_SCM_CODE_VALUES_LKP_TL CODE
REQUISITION_NUMBER VARCHAR2 64     Requisition Header Number.    
REQUISITION_SOURCE VARCHAR2 32     Source of requisition from requisition import.    
REQUISITION_ITEM_SOURCE VARCHAR2 32     Indicates whether item comes from Catalog, Non-catalog, Quick Create, Punchout, Req Import or Service.. Values are from the table DW_SCM_CODE_VALUES_LKP_TL with CODE_TYPE=POR_ITEM_SOURCE. DW_SCM_CODE_VALUES_LKP_TL CODE
REQUISITION_DISTRIBUTION_ID NUMBER 38 0   Requisition Distribution Identifier. DW_REQ_DISTRIBUTIONS_EN DISTRIBUTION_ID
REQUISITION_LINE_ID NUMBER 38 0   Requisition Line Identifier. DW_REQUISITION_LINES_EN REQUISITION_LINE_ID
REQUISITION_ID NUMBER 38 0   Requisition Header Identifier. DW_REQUISITION_HEADERS_EN REQUISITION_HEADER_ID
TRANSACTION_CURRENCY_CODE VARCHAR2 16     Invoice currency code. DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
INVOICE_LINE_UNIT_PRICE NUMBER       Unit price for purchase order, receipt matched invoice lines, and price or quantity corrections    
TRANSACTION_LINE_UOM_CODE VARCHAR2 32     Unit of measure for line quantity invoiced. DW_UNIT_OF_MEASURE_D_TL UOM_CODE
INVOICE_LINE_QUANTITY NUMBER       Quantity invoiced. Quantity of items for matched invoice lines, price corrections, quantity corrections or unmatched invoice lines.    
INVOICE_LINE_AMOUNT NUMBER       Line amount in invoice currency.    
PUOM_CODE VARCHAR2 32     Line Primary Unit Of Measure code    
PUOM_CONVERSION_FACTOR NUMBER       Primary Unit of Measure to Transation Unit of Measure Conversion Rate    
PUOM_INVOICE_LINE_QUANTITY NUMBER       Line Quantity in Primary Unit of Measure    
DISTRIBUTION_UNIT_PRICE NUMBER       Unit price for purchase order, receipt matched invoice distributions, and price or quantity corrections.    
TRANSACTION_UOM_CODE VARCHAR2 32     Unit of measure for distribution quantity invoiced. DW_UNIT_OF_MEASURE_D_TL UOM_CODE
DISTRIBUTION_QUANTITY NUMBER       Quantity billed for purchase order or receipt matched invoice distributions.    
TRANSACTION_AMOUNT NUMBER       Distribution amount in invoice currency.    
GLOBAL_CURRENCY_CODE VARCHAR2 16     Global currency code.    
GLOBAL_CURRENCY_EXCH_RATE NUMBER       Global currency conversion rate.    
PUOM_DISTRIBUTION_QUANTITY NUMBER       Quantity billed for purchase order or receipt matched invoice distributions in PUOM    
IS_SPEND_FLAG VARCHAR2 16     Flag to indicate if the distribution is Spend. Values are from the table DW_SCM_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. Sum of Accounting Distribution Amounts on the basis of following conditions - - Don't consider invoices for withholding taxes - Don't consider Prepayment invoices - Don't consider Prepayment applications in invoices - Don't consider Withholding taxes applied in Invoices - Invoice is approved or doesn't require approval - Invoice distribution is validated and accounted DW_CODE_VALUES_LKP_TL CODE
IS_ADDRESSABLE_FLAG VARCHAR2 16     Flag to indicate if the invoice distribution is addressable. Values are from the table DW_SCM_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. Considered following invoice distributions types (excludes any Tax related distributions) - - Accrual - Item - Exchange Rate Variance - Invoice Price Variance - Retainage - Retro Accrual DW_CODE_VALUES_LKP_TL CODE
IS_PURCHASE_ORDER_MATCHED_FLAG VARCHAR2 16     Flag that indicates if invoice is matched to a Purchase Order or Receipt of a Purchase Order. Values are from the table DW_SCM_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. DW_CODE_VALUES_LKP_TL CODE
IS_AGREEMENT_BASED_FLAG VARCHAR2 16     Flag that indicates if purchase order line has an agreement associated. Values are from the table DW_SCM_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. Conditions for agreement based spend - - It is a PO Matched Spend Any one of the below condition is met for the purchase order line - - PO Line is created referring a blanket agreement - PO Line is created referring a contract agreement DW_CODE_VALUES_LKP_TL CODE
IS_AGREEMENT_LEAKAGE_FLAG VARCHAR2 16     Flag that indicates purchase order line doesn't have a agreement associated even though an open blanket agreement is available for the item. Values are from the table DW_SCM_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. Conditions for agreement leakage flag (For 'Inventory Item' Based Purchase Orders only) - - Blanket Header is Approved - Blanket Line was created before PO distribution was created - If Blanket line was cancelled than it was cancelled later than PO distribution creation - If Blanket line was closed than it was closed later than PO distribution creation - PO distribution was created when agreement was available (Blanket Start and End Date) - Blanket Line was not expired before PO distribution was created - The Requisitioning BU in PO is Enabled as Requisitioning BU in Agreement - Item in the PO line matches with item in the Blanket Line DW_CODE_VALUES_LKP_TL CODE
IS_NEGOTIATED_FLAG VARCHAR2 16     Flag that indicates if negotiation check box was selected for purchase order line. Values are from the table DW_SCM_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. DW_CODE_VALUES_LKP_TL CODE
IS_SOURCING_BASED_FLAG VARCHAR2 16     Flag that indicates if purchase order line has sourcing negotiation id assigned. Values are from the table DW_SCM_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. DW_CODE_VALUES_LKP_TL CODE
IS_REQUISITION_BASED_FLAG VARCHAR2 16     Flag that indicates if purchase order is associated with a requisition. Values are from the table DW_SCM_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. DW_CODE_VALUES_LKP_TL CODE
SPEND_SEC_BU_ID NUMBER 38 0   Indicates procurement BU incase of PO matched distributions otherwise supplier site procurement BU. DW_INTERNAL_ORG_D ORGANIZATION_ID
LINKAGE_ID NUMBER 38 0   Subledger linkage identifier.    
XLA_LEDGER_ID NUMBER 38 0   Self-contained accounting information set for single or multiple legal or management entities. DW_LEDGER_D LEDGER_ID
AE_LINE_NUM NUMBER 38 0   Number that is associated with each subledger journal entry line.    
ACCOUNTING_CLASS_CODE VARCHAR2 32     Short name of a lookup type that is shared across application used to classify journal entry lines. DW_XLA_ACCOUNT_CLASS_LKP_TL ACCOUNTING_CLASS_CODE
SOURCE_DISTRIBUTION_TYPE VARCHAR2 32     Classification of transaction source distribution.    
ACCOUNTING_LINE_CODE VARCHAR2 32     Short name of a rule to convert transactional data into a journal entry line.    
ACCOUNTING_LINE_TYPE_CODE VARCHAR2 16     Indicates whether the journal line rule is seeded.    
XLA_MANUAL_OVERRIDE_FLAG VARCHAR2 32     Indicates a manual override. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. DW_CODE_VALUES_LKP_TL CODE
XLA_ACCOUNTING_DATE DATE       Date used to determine the accounting period for transactions (referenced from Oracle Fusion General Ledger).    
XLA_TRANSACTION_CURRENCY_CODE VARCHAR2 16     Entered currency for the transaction data. DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
XLA_LEDGER_CURRENCY_CODE VARCHAR2 16     Functional currency of the ledger. DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
XLA_LINE_TRANSACTION_AMOUNT NUMBER       Line level unrounded entered debit amount for the journal line minus Line level unrounded entered credit amount for the journal line.    
XLA_LINE_ENTERED_DR_AMOUNT NUMBER       Line level unrounded entered debit amount for the journal line.    
XLA_LINE_ENTERED_CR_AMOUNT NUMBER       Line level unrounded entered credit amount for the journal line.    
XLA_LINE_LEDGER_AMOUNT NUMBER       Line level unrounded accounted debit amount of the journal entry line minus Line level unrounded accounted credit amount of the journal entry line.    
XLA_LINE_ACCOUNTED_DR_AMOUNT NUMBER       Line level unrounded accounted debit amount of the journal entry line.    
XLA_LINE_ACCOUNTED_CR_AMOUNT NUMBER       Line level unrounded accounted credit amount of the journal entry line.    
XLA_LINE_GLOBAL_AMOUNT NUMBER       Line level unrounded global debit amount for the journal line minus Line level unrounded global credit amount for the journal line.    
XLA_LINE_GLOBAL_DR_AMOUNT NUMBER       Line level unrounded global debit amount for the journal line.    
XLA_LINE_GLOBAL_CR_AMOUNT NUMBER       Line level unrounded global credit amount for the journal line.    
XLA_TRANSACTION_AMOUNT NUMBER       Unrounded entered debit amount for the journal line minus Unrounded entered credit amount for the journal line.    
XLA_ENTERED_DR_AMOUNT NUMBER       Unrounded entered debit amount for the journal line.    
XLA_ENTERED_CR_AMOUNT NUMBER       Unrounded entered credit amount for the journal line.    
XLA_LEDGER_AMOUNT NUMBER       Unrounded accounted debit for journal entry line minus Unrounded accounted credit for journal entry line.    
XLA_ACCOUNTED_DR_AMOUNT NUMBER       Unrounded accounted debit for journal entry line.    
XLA_ACCOUNTED_CR_AMOUNT NUMBER       Unrounded accounted credit for journal entry line.    
XLA_GLOBAL_AMOUNT NUMBER       Unrounded global debit amount for the journal line minus Unrounded global credit amount for the journal line.    
XLA_GLOBAL_DR_AMOUNT NUMBER       Unrounded global debit amount for the journal line.    
XLA_GLOBAL_CR_AMOUNT NUMBER       Unrounded global credit amount for the journal line.