DW_CMR_SLA_DISTRIBUTIONS_CF (Preview)

This table requires activation of Procurement Receipt Accounting functional area. This fact table stores Receipt Accounting SLA Distribution details for PO source

Details

Module: Purchasing

Key Columns

AE_HEADER_ID, REF_AE_HEADER_ID, APPLICATION_ID, TEMP_LINE_NUM

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
AE_HEADER_ID NUMBER 38 0 True Subledger journal entry identifier.
TEMP_LINE_NUM NUMBER 38 0 True Intermediary line number generated by the accounting engine when the entries are in most detail form.
APPLICATION_ID NUMBER 38 0 True Application Identifier
REF_AE_HEADER_ID NUMBER 38 0 True Reversed subledger journal entry header identifier
SOURCE_RECORD_ID VARCHAR2 256 This column is for Oracle Internal use only. System Generated
XLA_LEDGER_ID NUMBER 38 0 XLA Ledger Identifier DW_LEDGER_D LEDGER_ID
XLA_FISCAL_PERIOD_SET_NAME VARCHAR2 16 XLA Fiscal period set name #1 DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
XLA_FISCAL_PERIOD_TYPE VARCHAR2 16 XLA Fiscal period type #1 DW_FISCAL_DAY_D FISCAL_PERIOD_TYPE
XLA_FISCAL_PERIOD_NAME VARCHAR2 64 Accounting period name.
XLA_EVENT_TYPE_CODE VARCHAR2 64 XLA Event type code #3 DW_XLA_EVENT_TYPES_LKP_TL EVENT_TYPE_CODE
XLA_EVENT_CLASS_CODE VARCHAR2 32 XLA Event class code #2 DW_XLA_EVENT_CLASSES_LKP_TL EVENT_CLASS_CODE
XLA_SOURCE_DISTRIBUTION_TYPE VARCHAR2 32 Classification of transaction source distribution #2 DW_XLA_EVENT_CLASSES_LKP_TL ENTITY_CODE
XLA_LEDGER_CURRENCY_CODE VARCHAR2 16 Functional currency of the ledger. DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
XLA_TRANSACTION_CURRENCY_CODE VARCHAR2 16 Entered currency for the transaction data DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
GLOBAL_CURRENCY_CODE VARCHAR2 16 Global currency code DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
GLOBAL_CURRENCY_EXCH_RATE BIGDECIMAL 10 Ledger Currency to Global Currency Exchange Rate in BigDecimal format
XLA_UNROUNDED_TRANSACTION_AMOUNT BIGDECIMAL 10 XLA Amount in transaction Currency
XLA_UNROUNDED_ENTERED_DR BIGDECIMAL 10 Unrounded debit amount for the journal line in transaction Currency
XLA_UNROUNDED_ENTERED_CR BIGDECIMAL 10 Unrounded credit amount for the journal line in transaction Currency
XLA_UNROUNDED_LEDGER_AMOUNT BIGDECIMAL 10 XLA Amount in Ledger Currency
XLA_UNROUNDED_ACCOUNTED_DR BIGDECIMAL 10 Unrounded debit amount of the journal entry line in Ledger Currency
XLA_UNROUNDED_ACCOUNTED_CR BIGDECIMAL 10 Unrounded credit amount of the journal entry line in Ledger Currency
XLA_UNROUNDED_GLOBAL_AMOUNT BIGDECIMAL 10 XLA Amount in Global Currency
XLA_UNROUNDED_GLOBAL_DR BIGDECIMAL 10 Unrounded debit amount for the journal line in Global Currency.
XLA_UNROUNDED_GLOBAL_CR BIGDECIMAL 10 Unrounded Credit amount for the journal line in Global Currency.
XLA_ACCOUNTING_LINE_CODE VARCHAR2 32 Short name of a rule to convert transactional data into a journal entry line.
XLA_ACCOUNTING_LINE_TYPE_CODE VARCHAR2 16 Type of journal line rule: Debit, Credit, Gain or Loss.
XLA_CREATION_TIMESTAMP TIMESTAMP XLA Distribution Creation Date
XLA_LAST_UPDATE_TIMESTAMP TIMESTAMP XLA Distribution Last Update Date
XLA_ACCOUNTING_DATE DATE Date, referenced from Oracle Fusion General Ledger, used to determine the accounting period for transactions. DW_DAY_D CALENDAR_DATE
XLA_ACCOUNT_ID NUMBER 38 0 Code Combination Identifier of the XLA Account DW_GL_CODE_COMBINATION_D CODE_COMBINATION_ID
XLA_ACCOUNT_GL_BALANCING_SEGMENT VARCHAR2 32 Balancing segment. DW_BALANCING_SEGMENT_D GL_BALANCING_SEGMENT
XLA_ACCOUNT_GL_BLNC_SGMNT_VALUESET_CODE VARCHAR2 64 Balancing segment value set code. DW_BALANCING_SEGMENT_D GL_BLNC_SGMNT_VALUESET_CODE
XLA_ACCOUNT_COST_CENTER_SEGMENT VARCHAR2 32 Cost center segment. DW_COST_CENTER_D COST_CENTER_SEGMENT
XLA_ACCOUNT_COST_CENTER_VALUESET_CODE VARCHAR2 64 Cost center value set code. DW_COST_CENTER_D COST_CENTER_VALUESET_CODE
XLA_ACCOUNT_NATURAL_ACCOUNT_SEGMENT VARCHAR2 32 Natural account segment. DW_NATURAL_ACCOUNT_D NATURAL_ACCOUNT_SEGMENT
XLA_ACCOUNT_NTRL_ACNT_SGMNT_VALUESET_CODE VARCHAR2 64 Natural account value set code. DW_NATURAL_ACCOUNT_D NTRL_ACNT_SGMNT_VALUESET_CODE
XLA_ACCOUNT_GL_SEGMENT1 VARCHAR2 32 Accounting segment 1. DW_GL_SEGMENT1_D GL_SEGMENT_CODE
XLA_ACCOUNT_GL_SEGMENT1_VALUESET_CODE VARCHAR2 64 Accounting segment 1 value set code. DW_GL_SEGMENT1_D GL_SEGMENT_VALUESET_CODE
XLA_ACCOUNT_GL_SEGMENT2 VARCHAR2 32 Accounting segment 2. DW_GL_SEGMENT2_D GL_SEGMENT_CODE
XLA_ACCOUNT_GL_SEGMENT2_VALUESET_CODE VARCHAR2 64 Accounting segment 2 value set code. DW_GL_SEGMENT2_D GL_SEGMENT_VALUESET_CODE
XLA_ACCOUNT_GL_SEGMENT3 VARCHAR2 32 Accounting segment 3. DW_GL_SEGMENT3_D GL_SEGMENT_CODE
XLA_ACCOUNT_GL_SEGMENT3_VALUESET_CODE VARCHAR2 64 Accounting segment 3 value set code. DW_GL_SEGMENT3_D GL_SEGMENT_VALUESET_CODE
XLA_ACCOUNT_GL_SEGMENT4 VARCHAR2 32 Accounting segment 4. DW_GL_SEGMENT4_D GL_SEGMENT_CODE
XLA_ACCOUNT_GL_SEGMENT4_VALUESET_CODE VARCHAR2 64 Accounting segment 4 value set code. DW_GL_SEGMENT4_D GL_SEGMENT_VALUESET_CODE
XLA_ACCOUNT_GL_SEGMENT5 VARCHAR2 32 Accounting segment 5. DW_GL_SEGMENT5_D GL_SEGMENT_CODE
XLA_ACCOUNT_GL_SEGMENT5_VALUESET_CODE VARCHAR2 64 Accounting segment 5 value set code. DW_GL_SEGMENT5_D GL_SEGMENT_VALUESET_CODE
XLA_ACCOUNT_GL_SEGMENT6 VARCHAR2 32 Accounting segment 6. DW_GL_SEGMENT6_D GL_SEGMENT_CODE
XLA_ACCOUNT_GL_SEGMENT6_VALUESET_CODE VARCHAR2 64 Accounting segment 6 value set code. DW_GL_SEGMENT6_D GL_SEGMENT_VALUESET_CODE
XLA_ACCOUNT_GL_SEGMENT7 VARCHAR2 32 Accounting segment 7. DW_GL_SEGMENT7_D GL_SEGMENT_CODE
XLA_ACCOUNT_GL_SEGMENT7_VALUESET_CODE VARCHAR2 64 Accounting segment 7 value set code. DW_GL_SEGMENT7_D GL_SEGMENT_VALUESET_CODE
XLA_ACCOUNT_GL_SEGMENT8 VARCHAR2 32 Accounting segment 8. DW_GL_SEGMENT8_D GL_SEGMENT_CODE
XLA_ACCOUNT_GL_SEGMENT8_VALUESET_CODE VARCHAR2 64 Accounting segment 8 value set code. DW_GL_SEGMENT8_D GL_SEGMENT_VALUESET_CODE
XLA_ACCOUNT_GL_SEGMENT9 VARCHAR2 32 Accounting segment 9. DW_GL_SEGMENT9_D GL_SEGMENT_CODE
XLA_ACCOUNT_GL_SEGMENT9_VALUESET_CODE VARCHAR2 64 Accounting segment 9 value set code. DW_GL_SEGMENT9_D GL_SEGMENT_VALUESET_CODE
XLA_ACCOUNT_GL_SEGMENT10 VARCHAR2 32 Accounting segment 10. DW_GL_SEGMENT10_D GL_SEGMENT_CODE
XLA_ACCOUNT_GL_SEGMENT10_VALUESET_CODE VARCHAR2 64 Accounting segment 10 value set code. DW_GL_SEGMENT10_D GL_SEGMENT_VALUESET_CODE
DEFAULT_ACCRUAL_ACCOUNT_ID NUMBER 38 0 Code Combination Identifier of the Default Accrual Account DW_GL_CODE_COMBINATION_D CODE_COMBINATION_ID
DEFAULT_ACCRUAL_ACCOUNT_GL_BALANCING_SEGMENT VARCHAR2 32 Balancing segment. DW_BALANCING_SEGMENT_D GL_BALANCING_SEGMENT
DEFAULT_ACCRUAL_ACCOUNT_GL_BLNC_SGMNT_VALUESET_CODE VARCHAR2 64 Balancing segment value set code. DW_BALANCING_SEGMENT_D GL_BLNC_SGMNT_VALUESET_CODE
DEFAULT_ACCRUAL_ACCOUNT_COST_CENTER_SEGMENT VARCHAR2 32 Cost center segment. DW_COST_CENTER_D COST_CENTER_SEGMENT
DEFAULT_ACCRUAL_ACCOUNT_COST_CENTER_VALUESET_CODE VARCHAR2 64 Cost center value set code. DW_COST_CENTER_D COST_CENTER_VALUESET_CODE
DEFAULT_ACCRUAL_ACCOUNT_NATURAL_ACCOUNT_SEGMENT VARCHAR2 32 Natural account segment. DW_NATURAL_ACCOUNT_D NATURAL_ACCOUNT_SEGMENT
DEFAULT_ACCRUAL_ACCOUNT_NTRL_ACNT_SGMNT_VALUESET_CODE VARCHAR2 64 Natural account value set code. DW_NATURAL_ACCOUNT_D NTRL_ACNT_SGMNT_VALUESET_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT1 VARCHAR2 32 Accounting segment 1. DW_GL_SEGMENT1_D GL_SEGMENT_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT1_VALUESET_CODE VARCHAR2 64 Accounting segment 1 value set code. DW_GL_SEGMENT1_D GL_SEGMENT_VALUESET_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT2 VARCHAR2 32 Accounting segment 2. DW_GL_SEGMENT2_D GL_SEGMENT_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT2_VALUESET_CODE VARCHAR2 64 Accounting segment 2 value set code. DW_GL_SEGMENT2_D GL_SEGMENT_VALUESET_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT3 VARCHAR2 32 Accounting segment 3. DW_GL_SEGMENT3_D GL_SEGMENT_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT3_VALUESET_CODE VARCHAR2 64 Accounting segment 3 value set code. DW_GL_SEGMENT3_D GL_SEGMENT_VALUESET_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT4 VARCHAR2 32 Accounting segment 4. DW_GL_SEGMENT4_D GL_SEGMENT_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT4_VALUESET_CODE VARCHAR2 64 Accounting segment 4 value set code. DW_GL_SEGMENT4_D GL_SEGMENT_VALUESET_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT5 VARCHAR2 32 Accounting segment 5. DW_GL_SEGMENT5_D GL_SEGMENT_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT5_VALUESET_CODE VARCHAR2 64 Accounting segment 5 value set code. DW_GL_SEGMENT5_D GL_SEGMENT_VALUESET_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT6 VARCHAR2 32 Accounting segment 6. DW_GL_SEGMENT6_D GL_SEGMENT_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT6_VALUESET_CODE VARCHAR2 64 Accounting segment 6 value set code. DW_GL_SEGMENT6_D GL_SEGMENT_VALUESET_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT7 VARCHAR2 32 Accounting segment 7. DW_GL_SEGMENT7_D GL_SEGMENT_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT7_VALUESET_CODE VARCHAR2 64 Accounting segment 7 value set code. DW_GL_SEGMENT7_D GL_SEGMENT_VALUESET_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT8 VARCHAR2 32 Accounting segment 8. DW_GL_SEGMENT8_D GL_SEGMENT_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT8_VALUESET_CODE VARCHAR2 64 Accounting segment 8 value set code. DW_GL_SEGMENT8_D GL_SEGMENT_VALUESET_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT9 VARCHAR2 32 Accounting segment 9. DW_GL_SEGMENT9_D GL_SEGMENT_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT9_VALUESET_CODE VARCHAR2 64 Accounting segment 9 value set code. DW_GL_SEGMENT9_D GL_SEGMENT_VALUESET_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT10 VARCHAR2 32 Accounting segment 10. DW_GL_SEGMENT10_D GL_SEGMENT_CODE
DEFAULT_ACCRUAL_ACCOUNT_GL_SEGMENT10_VALUESET_CODE VARCHAR2 64 Accounting segment 10 value set code. DW_GL_SEGMENT10_D GL_SEGMENT_VALUESET_CODE
XLA_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
XLA_MANUAL_OVERRIDE_FLAG VARCHAR2 16 Flag to identify if the CCID is overridden. DW_YN_LKP_TL YN_LKP_CODE
AE_LINE_NUM NUMBER 38 0 Number that is associated with each subledger journal entry line.
XLA_LINE_UNROUNDED_TRANSACTION_AMOUNT BIGDECIMAL 10 XLA Line Amount in transaction Currency
XLA_LINE_UNROUNDED_ENTERED_DR BIGDECIMAL 10 Unrounded debit amount for the journal line in transaction Currency
XLA_LINE_UNROUNDED_ENTERED_CR BIGDECIMAL 10 Unrounded credit amount for the journal line in transaction Currency
XLA_LINE_UNROUNDED_LEDGER_AMOUNT BIGDECIMAL 10 XLA Line Amount in Ledger Currency
XLA_LINE_UNROUNDED_ACCOUNTED_DR BIGDECIMAL 10 Unrounded debit amount of the journal entry line in Ledger Currency
XLA_LINE_UNROUNDED_ACCOUNTED_CR BIGDECIMAL 10 Unrounded credit amount of the journal entry line in Ledger Currency
XLA_LINE_UNROUNDED_GLOBAL_AMOUNT BIGDECIMAL 10 XLA Line Amount in Global Currency
XLA_LINE_UNROUNDED_GLOBAL_DR BIGDECIMAL 10 Unrounded debit amount of the journal entry line in Global Currency
XLA_LINE_UNROUNDED_GLOBAL_CR BIGDECIMAL 10 Unrounded credit amount of the journal entry line in Global Currency
DISTRIBUTION_ID NUMBER 38 0 Receipt accounting distribution identifier
SUBLEDGER_LINKAGE_DST_ENTITY_ID VARCHAR2 256 Receipt accounting distribution identifier
DISTRIBUTION_ACCOUNTING_EVENT_ID NUMBER 38 0 Receipt accounting event identifier
DISTRIBUTION_ACCOUNTING_LINE_TYPE VARCHAR2 64 Distribution accounting line type #4 DW_XLA_ACCNT_LINE_TYPES_LKP_TL ACCOUNTING_LINE_CODE
DISTRIBUTION_CREATED_BY VARCHAR2 128 Indicates the user who created the row. DW_USER_D USERNAME
DISTRIBUTION_CREATION_DATE DATE Distribution creation date without timestamp DW_DAY_D CALENDAR_DATE
DISTRIBUTION_CREATION_TIMESTAMP TIMESTAMP Distribution creation date with timestamp
DISTRIBUTION_LAST_UPDATED_BY VARCHAR2 128 Indicates the user who last updated the row. DW_USER_D USERNAME
DISTRIBUTION_LAST_UPDATE_DATE DATE Distribution last update date without timestamp DW_DAY_D CALENDAR_DATE
DISTRIBUTION_LAST_UPDATE_TIMESTAMP TIMESTAMP Distribution last update date with timestamp
EVENT_TXN_TABLE_NAME VARCHAR2 32 Stores transaction event creation source transaction table name.
EVENT_SOURCE VARCHAR2 32 Receipt accounting event source DW_ORA_CMR_DOC_FLOW_TYPES_LKP_TL ORA_CMR_DOC_FLOW_TYPES_CODE
PO_HEADER_ID NUMBER 38 0 Purchase order header identifier of source PO
SOURCE_DOC_NUMBER VARCHAR2 64 Source document number
PO_LINE_ID NUMBER 38 0 Purchase order line identifier
SOURCE_DOC_LINE_NUMBER VARCHAR2 64 Source document line number
PO_LINE_LOCATION_ID NUMBER 38 0 Purchase order schedule identifier
PO_SCHEDULE_NUMBER VARCHAR2 64 Purchase order schedule number
PO_DISTRIBUTION_ID NUMBER 38 0 Purchase order distribution identifier
PO_DISTRIBUTION_NUMBER VARCHAR2 64 Purchase order distribution number
CMR_PO_DISTRIBUTION_ID NUMBER 38 0 Identifier for Receipt accounting PO Distributions
CMR_RCV_TRANSACTION_ID NUMBER 38 0 Identifier for the Receipt accounting receiving transaction.
RCV_TRANSACTION_ID NUMBER 38 0 Receiving transaction identifier
RECEIPT_NUMBER VARCHAR2 64 Receipt Number
RECEIPT_LINE_NUMBER NUMBER 38 0 Receipt Line Number
RECEIPT_CREATION_DATE DATE Receipt creation date DW_DAY_D CALENDAR_DATE
PROFIT_CENTER_BUSINESS_UNIT_ID NUMBER 38 0 Profit Center Business Unit identifier DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
BILL_TO_BUSINESS_UNIT_ID NUMBER 38 0 Bill to Business Unit Identifier DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
DISTRIBUTION_LEDGER_ID NUMBER 38 0 Distribution Ledger identifier DW_LEDGER_D LEDGER_ID
DISTRIBUTION_LEGAL_ENTITY_ID NUMBER 38 0 Distribution Legal entity identifier DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
INVENTORY_ORG_ID NUMBER 38 0 Inventory organization id where the item is stored #6 DW_INTERNAL_ORG_D ORGANIZATION_ID
INVENTORY_ITEM_ID NUMBER 38 0 Inventory item identifier, it will be null for description based item #6 DW_INVENTORY_ITEM_D INVENTORY_ITEM_ID
ITEM_DESCRIPTION VARCHAR2 256 Item description.
TRANSACTION_DATE DATE Transaction date DW_DAY_D CALENDAR_DATE
TRANSACTION_TYPE_ID NUMBER 38 0 Transaction Type Identifier DW_CMR_TRANSACTION_TYPES_TL TRANSACTION_TYPE_ID
TRANSACTION_TYPE_CODE VARCHAR2 64 Transaction Type Code
DESTINATION_TYPE_CODE VARCHAR2 32 Identifies type of destination for the material: Inventory, Expense DW_DESTINATION_TYPE_LKP_TL DESTINATION_TYPE_CODE
VENDOR_ID NUMBER 38 0 Identifies the Supplier #7 DW_PARTY_D SUPPLIER_ID
VENDOR_PARTY_ID NUMBER 38 0 Identifies the Supplier Party #7 DW_PARTY_D PARTY_ID
VENDOR_SITE_ID NUMBER 38 0 Identifies the Supplier site DW_SUPPLIER_SITE_D SUPPLIER_SITE_ID
SHIP_TO_LOCATION_ID NUMBER 38 0 The identifier of the specific location that the goods are being shipped to. DW_WORKER_LOCATION_D LOCATION_ID
CMR_AP_INVOICE_DIST_ID NUMBER 38 0 CMR AP Invoice Distribution Identifier
AP_INVOICE_DIST_ID NUMBER 38 0 Payables invoice distribution identifier
AP_INVOICE_ID NUMBER 38 0 Invoice identifier
AP_INVOICE_NUMBER VARCHAR2 64 Invoice number
AP_INVOICE_LINE_NUMBER VARCHAR2 64 Invoice line number
PJC_PROJECT_ID NUMBER 38 0 Project Identifier DW_PROJECT_D PROJECT_ID
PJC_TASK_ID NUMBER 38 0 Project task identifier DW_PROJECT_ELEMENT_D PROJ_ELEMENT_ID
PJC_EXPENDITURE_TYPE_ID NUMBER 38 0 Project expenditure type identifier DW_PROJECT_EXPENDITURE_TYPE_D EXPENDITURE_TYPE_ID
PJC_EXPENDITURE_ITEM_DATE DATE Project expenditure date DW_DAY_D CALENDAR_DATE
PJC_ORGANIZATION_ID NUMBER 38 0 Project expenditure organization DW_INTERNAL_ORG_D ORGANIZATION_ID

Notes

#1 In these cases to join with DW_FISCAL_DAY_D apart from XLA_FISCAL_PERIOD_TYPE and XLA_FISCAL_PERIOD_SET_NAME the relationship should be based on XLA_ACCOUNTING_DATE column. #2 Apart from the join conditions for DW_XLA_EVENT_CLASSES_LKP_TL also condition DW_XLA_EVENT_CLASSES_LKP_TL.APPLICATION_ID=10096 should be added. #3 Apart from EVENT_TYPE_CODE the join with DW_XLA_EVENT_TYPES_LKP_TL should also be done on XLA_EVENT_CLASS_CODE and XLA_SOURCE_DISTRIBUTION_TYPE (ENTITY_CODE) and DW_XLA_EVENT_TYPES_LKP_TL.APPLICATION_ID = 10096. #4 Apart from DISTRIBUTION_ACCOUNTING_LINE_TYPE the join with DW_XLA_ACCNT_LINE_TYPES_LKP_TL should also be done on XLA_SOURCE_DISTRIBUTION_TYPE and XLA_EVENT_CLASS_CODE and DW_XLA_ACCNT_LINE_TYPES_LKP_TL.APPLICATION_ID=10096 and ACCOUNTING_LINE_TYPE_CODE='S'. #5 In these cases to join with DW_FISCAL_DAY_D apart from FISCAL_PERIOD_TYPE and FISCAL_PERIOD_SET_NAME the relationship should be based on TRANSACTION_DATE column. #6 For join with Item Dimension along with INVENTORY_ITEM_ID also join on column INVENTORY_ORG_ID. #7 Depending on the association (Vendor or Vendor party), any one of the 2 joins with party dimension can be picked.