DW_INVOICE_SPEND_CF

Invoice Spend Currency Fact

Details

Module: Purchasing

Key Columns

INVOICE_DISTRIBUTION_ID, REF_AE_HEADER_ID, INVOICE_LINE_NUMBER, PREPAY_APP_DIST_ID, TEMP_LINE_NUM, AE_HEADER_ID, INVOICE_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 This column is for Oracle Internal use only. 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. Possible values are INVOICE GATEWAY, Recurring Invoice, Self Service, Confirm Payment Batch, LOANS, Manual Invoice Entry, Quick Check and so on.
INVOICE_TYPE_CODE VARCHAR2 32 Invoice type. Possible values are STANDARD, CREDIT, DEBIT, PAYMENT REQUEST, PREPAYMENT, INTEREST, INVOICE REQUEST, AWT, CREDIT MEMO REQUEST, EXPENSE REPORT, MIXED, and so on.
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. Possible Values are Approved, Cancelled, Unpaid, Available, Needs Reapproval
INVOICE_APPROVAL_STATUS_CODE VARCHAR2 64 Invoice approval status. Possible values are INITIATED, MANUALLY APPROVED, NOT REQUIRED, REJECTED, REMOVED FROM APPROVAL, REQUIRED, WFAPPROVED, etc.
INVOICE_INTER_COMPANY_FLAG VARCHAR2 16 Inter-company flag added to incorporate FUN team's inter-company feature.
INVOICE_RECEIVED_DATE DATE Date when invoice is received. DW_DAY_D CALENDAR_DATE
INVOICED_ON_DATE_SOURCE DATE Date when invoice is created. Same as source.
INVOICED_ON_DATE DATE Date when invoiced is created. #1 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.Possible values are Accounted, Unaccounted, Partially Accounted.
INVOICE_PAYMENT_STATUS_CODE VARCHAR2 16 Invoice payment status.Possible values are Y, N and P
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. Possible values are Imported, Maual Entry, Etax, Header Match
LINE_TYPE_LOOKUP_CODE VARCHAR2 32 Line type.Possible values are Item, Freight, Miscellaneous, tax, Prepay
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.
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).
LINE_APPROVAL_STATUS_CODE VARCHAR2 32 Invoice line approval status.Possible values are INITIATED, MANUALLY APPROVED, NOT REQUIRED, REJECTED, REMOVED FROM APPROVAL, REQUIRED, WFAPPROVED, etc.
DISTRIBUTION_LINE_NUMBER NUMBER 38 0 Distribution line number.
DISTRIBUTION_DESCRIPTION VARCHAR2 256 Distribution description.
DISTRIBUTION_TYPE_CODE VARCHAR2 32 Invoice type. Possible values are ITEM, ACCRUAL, AWT, IPV, ERV, FREIGHT, RETAINAGE etc.
PREPAY_DIST_TYPE_CODE VARCHAR2 32 Type of prepayment application distribution.
DISTRIBUTION_VALIDATION_STATUS VARCHAR2 32 Invoice Distribution validation status.Possible values are Approved, Cancelled, Rejected, Needs Reapproval.
DISTRIBUTION_MATCH_TYPE VARCHAR2 32 Indicates whether an invoice matched a PO or a receipt of material. Possible values are NOT_MATCHED, ITEM_TO_SERVICE_PO, ITEM_TO_PO, ITEM_TO_CA
DIST_CANCELLED_INDICATOR VARCHAR2 16 Indicates a cancelled distribution.
DIST_REVERSAL_INDICATOR VARCHAR2 16 Flag that indicates if distribution is part of a reversal pair.
DISTRIBUTION_ACCOUNTING_DATE_SOURCE DATE Accounting date. Same as source.
DISTRIBUTION_ACCOUNTING_DATE DATE Accounting date. #1 DW_DAY_D CALENDAR_DATE
DISTRIBUTION_POSTED_FLAG VARCHAR2 16 Invoice distribution accounting status.Possible values are Y,N,S,P.
TRACK_AS_ASSET VARCHAR2 16 Flag indicates that the item should be treated as an asset.
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. Possible values are PARCEL, LTL etc.
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).
AGREEMENT_PROCUREMENT_BU_ID NUMBER 38 0 Agreement Procurement business unit identifier. DW_INTERNAL_ORG_D ORGANIZATION_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
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.
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.Possible values are Drop-ship, Inventory, Expense, Manufacturing etc.
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.
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 BIGDECIMAL 10 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. 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
IS_ADDRESSABLE_FLAG VARCHAR2 16 Flag to indicate if the invoice distribution is addressable. Considered following invoice distributions types (excludes any Tax related distributions) - - Accrual - Item - Exchange Rate Variance - Invoice Price Variance - Retainage - Retro Accrual
IS_PURCHASE_ORDER_MATCHED_FLAG VARCHAR2 16 Flag that indicates if invoice is matched to a Purchase Order or Receipt of a Purchase Order.
IS_AGREEMENT_BASED_FLAG VARCHAR2 16 Flag that indicates if purchase order line has an agreement associated. 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
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. 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
IS_NEGOTIATED_FLAG VARCHAR2 16 Flag that indicates if negotiation check box was selected for purchase order line.
IS_SOURCING_BASED_FLAG VARCHAR2 16 Flag that indicates if purchase order line has sourcing negotiation id assigned.
IS_REQUISITION_BASED_FLAG VARCHAR2 16 Flag that indicates if purchase order is associated with a requisition.
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.
PROJECT_ID NUMBER 38 0 Identifier of the project used to build the transaction descriptive flexfield for project related transaction distributions DW_PROJECT_D PROJECT_ID
TASK_ID NUMBER 38 0 Identifier of the task used to build the transaction descriptive flexfield for project related transaction distributions. DW_PROJECT_ELEMENT_D PROJ_ELEMENT_ID
EXPENDITURE_TYPE_ID NUMBER 38 0 Identifier of the expenditure used to build the transaction descriptive flexfield for project related transaction distributions. DW_PROJECT_EXPENDITURE_TYPE_D EXPENDITURE_TYPE_ID
EXPENDITURE_ORGANIZATION_ID NUMBER 38 0 Organization identifier used to build the transaction descriptive flexfield for project related transaction distributions. DW_INTERNAL_ORG_D ORGANIZATION_ID
EXPENDITURE_ITEM_DATE DATE Date on which a project related transaction is incurred.
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.
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 BIGDECIMAL 10 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 BIGDECIMAL 10 Line level unrounded entered debit amount for the journal line.
XLA_LINE_ENTERED_CR_AMOUNT BIGDECIMAL 10 Line level unrounded entered credit amount for the journal line.
XLA_LINE_LEDGER_AMOUNT BIGDECIMAL 10 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 BIGDECIMAL 10 Line level unrounded accounted debit amount of the journal entry line.
XLA_LINE_ACCOUNTED_CR_AMOUNT BIGDECIMAL 10 Line level unrounded accounted credit amount of the journal entry line.
XLA_LINE_GLOBAL_AMOUNT BIGDECIMAL 10 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 BIGDECIMAL 10 Line level unrounded global debit amount for the journal line.
XLA_LINE_GLOBAL_CR_AMOUNT BIGDECIMAL 10 Line level unrounded global credit amount for the journal line.
XLA_TRANSACTION_AMOUNT BIGDECIMAL 10 Unrounded entered debit amount for the journal line minus Unrounded entered credit amount for the journal line.
XLA_ENTERED_DR_AMOUNT BIGDECIMAL 10 Unrounded entered debit amount for the journal line.
XLA_ENTERED_CR_AMOUNT BIGDECIMAL 10 Unrounded entered credit amount for the journal line.
XLA_LEDGER_AMOUNT BIGDECIMAL 10 Unrounded accounted debit for journal entry line minus Unrounded accounted credit for journal entry line.
XLA_ACCOUNTED_DR_AMOUNT BIGDECIMAL 10 Unrounded accounted debit for journal entry line.
XLA_ACCOUNTED_CR_AMOUNT BIGDECIMAL 10 Unrounded accounted credit for journal entry line.
XLA_GLOBAL_AMOUNT BIGDECIMAL 10 Unrounded global debit amount for the journal line minus Unrounded global credit amount for the journal line.
XLA_GLOBAL_DR_AMOUNT BIGDECIMAL 10 Unrounded global debit amount for the journal line.
XLA_GLOBAL_CR_AMOUNT BIGDECIMAL 10 Unrounded global credit amount for the journal line.
XDL_CREATION_DATE TIMESTAMP Creation date
INVOICED_FISCAL_PERIOD_NAME VARCHAR2 64 Fiscal Period Name anchored to Invoiced On Date
ACCOUNTING_FISCAL_PERIOD_NAME VARCHAR2 64 Fiscal Period Name anchored to Distribution Accounting Date
SPEND_XLA_LEDGER_AMOUNT BIGDECIMAL 10 Spend Subledger Amount in Ledger Currency
AGREEMENT_LEAKAGE_XLA_LEDGER_AMOUNT BIGDECIMAL 10 Agreement Leakage Subledger Amount in Ledger Currency
AGREEMENT_BASED_XLA_LEDGER_AMOUNT BIGDECIMAL 10 Agreement Based Subledger Amount in Ledger Currency
PURCHASE_ORDER_MATCHED_XLA_LEDGER_AMOUNT BIGDECIMAL 10 Purchase Order Matched Subledger Amount in Ledger Currency
ADDRESSABLE_XLA_LEDGER_AMOUNT BIGDECIMAL 10 Addressable Subledger Amount in Ledger Currency
NEGOTIATED_XLA_LEDGER_AMOUNT BIGDECIMAL 10 Negotiatied Subledger Amount in Ledger Currency
SPEND_XLA_GLOBAL_AMOUNT BIGDECIMAL 10 Spend Subledger Amount in Global Currency
AGREEMENT_LEAKAGE_XLA_GLOBAL_AMOUNT BIGDECIMAL 10 Agreement Leakage Subledger Amount in Global Currency
AGREEMENT_BASED_XLA_GLOBAL_AMOUNT BIGDECIMAL 10 Agreement Based Subledger Amount in Global Currency
PURCHASE_ORDER_MATCHED_XLA_GLOBAL_AMOUNT BIGDECIMAL 10 Purchase Order Matched Subledger Amount in Global Currency
ADDRESSABLE_XLA_GLOBAL_AMOUNT BIGDECIMAL 10 Addressable Subledger Amount in Global Currency
NEGOTIATED_XLA_GLOBAL_AMOUNT BIGDECIMAL 10 Negotiatied Subledger Amount in Global Currency

Notes

#1 If the dates are higher than 31-12-2100, those are capped to 31-12-2100 and If the dates are lower than 01-01-1901, those are capped to 01-01-1901.