DW_CMR_RCPT_ACCRUAL_BALANCES_CF (Preview)
This table requires activation of Procurement Receipt Accounting functional area. This fact table stores Accrual Balances for all Purchase Order Distributions with Accrual at Receipt
Details
Module: Purchasing
Key Columns
CMR_ACCR_RECONC_HEADER_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| CMR_ACCR_RECONC_HEADER_ID | NUMBER | 38 | 0 | True | Receipt accounting accrual reconciliation header identifier. | ||
| SOURCE_RECORD_ID | VARCHAR2 | 64 | This column is for Oracle Internal use only. System | ||||
| CMR_PO_DISTRIBUTION_ID | NUMBER | 38 | 0 | Identifies an entity in Receipt accounting PO Distributions | |||
| PO_HEADER_ID | NUMBER | 38 | 0 | Purchase order header identifier of source PO | |||
| PO_NUMBER | VARCHAR2 | 64 | Purchase order number | ||||
| PO_LINE_ID | NUMBER | 38 | 0 | Purchase order line identifier | |||
| PO_LINE_NUMBER | VARCHAR2 | 64 | Purchase order 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 | ||||
| SUPPLIER_ID | NUMBER | 38 | 0 | Identifies the Supplier | DW_PARTY_D | SUPPLIER_ID | |
| SUPPLIER_SITE_ID | NUMBER | 38 | 0 | Identifies the Supplier site | DW_SUPPLIER_SITE_D | SUPPLIER_SITE_ID | |
| PO_EVENT_DATE | DATE | Latest event date of purchase order distribution #2 | DW_DAY_D | CALENDAR_DATE | |||
| INVENTORY_ITEM_ID | NUMBER | 38 | 0 | Inventory Item Identifier on the purchase order line #1 | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID | |
| INVENTORY_ORGANIZATION_ID | NUMBER | 38 | 0 | Inventory organization identifier. | DW_INTERNAL_ORG_D | ORGANIZATION_ID | |
| ITEM_DESCRIPTION | VARCHAR2 | 256 | Item description. | ||||
| BILL_TO_BUSINESS_UNIT_ID | NUMBER | 38 | 0 | Bill to business unit identifier where invoice is created. | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID | |
| PRIMARY_LEDGER_ID | NUMBER | 38 | 0 | Ledger identifier associated with Deliver to business unit | DW_LEDGER_D | LEDGER_ID | |
| FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 | Name of the accounting calendar. #2 | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME | ||
| FISCAL_PERIOD_TYPE | VARCHAR2 | 16 | Accounting period type. Examples are Weekly, Monthly, Quarterly. #2 | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE | ||
| DELIVER_TO_BUSINESS_UNIT_ID | NUMBER | 38 | 0 | Business unit of the deliver to organization | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID | |
| LEDGER_CURRENCY_CODE | VARCHAR2 | 16 | Ledger currency code | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
| LEDGER_ACCRUED_AMOUNT | NUMBER | Net posted Accrual Amount by CMR to SLA. | |||||
| LEDGER_INVOICE_AMOUNT | NUMBER | Net posted Accrual Amount by Account Payables to SLA. | |||||
| GLOBAL_CURRENCY_CODE | VARCHAR2 | 16 | Global currency code | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
| GLOBAL_EXCHANGE_RATE | NUMBER | Ledger to Global currency conversion rate | |||||
| GLOBAL_ACCRUED_AMOUNT | NUMBER | Accrued amount in global currency | |||||
| GLOBAL_INVOICE_AMOUNT | NUMBER | Invoice amount in global currency | |||||
| PO_TXN_UOM_CODE | VARCHAR2 | 32 | Unit of Measure code of Purchase order | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE | ||
| PO_TXN_RECEIVED_QTY | NUMBER | Net received quantity as reported by receipt accounting. | |||||
| PO_TXN_INVOICED_QTY | NUMBER | Invoice quantity as reported by accounts payable. | |||||
| PUOM_CODE | VARCHAR2 | 32 | 1. Primary UOM code for regular items 2. Base UOM code for description based items 3. Not Available for Service Based/Amount Based items | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE | ||
| PUOM_CONVERSION_FACTOR | NUMBER | Purchase order UOM to Primary UOM conversion factor | |||||
| PUOM_RECEIVED_QTY | NUMBER | Accrued quantity in primary unit of measure | |||||
| PUOM_INVOICED_QTY | NUMBER | Invoiced quantity in primary unit of measure | |||||
| LEDGER_OPEN_ACCRUAL_BALANCE_AMOUNT | NUMBER | Open Accrual Balance in ledger currency | |||||
| GLOBAL_OPEN_ACCRUAL_BALANCE_AMOUNT | NUMBER | Open Accrual Balance in global currency | |||||
| XLA_ACCRUAL_ACCOUNT_ID | NUMBER | 38 | 0 | Code Combination Identifier of the XLA Accrual Account in Primary Ledger | DW_GL_CODE_COMBINATION_D | CODE_COMBINATION_ID | |
| XLA_ACCRUAL_ACCOUNT_GL_BALANCING_SEGMENT | VARCHAR2 | 32 | Balancing segment. | DW_BALANCING_SEGMENT_D | GL_BALANCING_SEGMENT | ||
| XLA_ACCRUAL_ACCOUNT_GL_BLNC_SGMNT_VALUESET_CODE | VARCHAR2 | 64 | Balancing segment value set code. | DW_BALANCING_SEGMENT_D | GL_BLNC_SGMNT_VALUESET_CODE | ||
| XLA_ACCRUAL_ACCOUNT_COST_CENTER_SEGMENT | VARCHAR2 | 32 | Cost center segment. | DW_COST_CENTER_D | COST_CENTER_SEGMENT | ||
| XLA_ACCRUAL_ACCOUNT_COST_CENTER_VALUESET_CODE | VARCHAR2 | 64 | Cost center value set code. | DW_COST_CENTER_D | COST_CENTER_VALUESET_CODE | ||
| XLA_ACCRUAL_ACCOUNT_NATURAL_ACCOUNT_SEGMENT | VARCHAR2 | 32 | Natural account segment. | DW_NATURAL_ACCOUNT_D | NATURAL_ACCOUNT_SEGMENT | ||
| XLA_ACCRUAL_ACCOUNT_NTRL_ACNT_SGMNT_VALUESET_CODE | VARCHAR2 | 64 | Natural account value set code. | DW_NATURAL_ACCOUNT_D | NTRL_ACNT_SGMNT_VALUESET_CODE | ||
| XLA_ACCRUAL_ACCOUNT_GL_SEGMENT1 | VARCHAR2 | 32 | Accounting segment 1. | DW_GL_SEGMENT1_D | GL_SEGMENT_CODE | ||
| XLA_ACCRUAL_ACCOUNT_GL_SEGMENT1_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 1 value set code. | DW_GL_SEGMENT1_D | GL_SEGMENT_VALUESET_CODE | ||
| XLA_ACCRUAL_ACCOUNT_GL_SEGMENT2 | VARCHAR2 | 32 | Accounting segment 2. | DW_GL_SEGMENT2_D | GL_SEGMENT_CODE | ||
| XLA_ACCRUAL_ACCOUNT_GL_SEGMENT2_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 2 value set code. | DW_GL_SEGMENT2_D | GL_SEGMENT_VALUESET_CODE | ||
| XLA_ACCRUAL_ACCOUNT_GL_SEGMENT3 | VARCHAR2 | 32 | Accounting segment 3. | DW_GL_SEGMENT3_D | GL_SEGMENT_CODE | ||
| XLA_ACCRUAL_ACCOUNT_GL_SEGMENT3_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 3 value set code. | DW_GL_SEGMENT3_D | GL_SEGMENT_VALUESET_CODE | ||
| XLA_ACCRUAL_ACCOUNT_GL_SEGMENT4 | VARCHAR2 | 32 | Accounting segment 4. | DW_GL_SEGMENT4_D | GL_SEGMENT_CODE | ||
| XLA_ACCRUAL_ACCOUNT_GL_SEGMENT4_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 4 value set code. | DW_GL_SEGMENT4_D | GL_SEGMENT_VALUESET_CODE | ||
| XLA_ACCRUAL_ACCOUNT_GL_SEGMENT5 | VARCHAR2 | 32 | Accounting segment 5. | DW_GL_SEGMENT5_D | GL_SEGMENT_CODE | ||
| XLA_ACCRUAL_ACCOUNT_GL_SEGMENT5_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 5 value set code. | DW_GL_SEGMENT5_D | GL_SEGMENT_VALUESET_CODE | ||
| XLA_ACCRUAL_ACCOUNT_GL_SEGMENT6 | VARCHAR2 | 32 | Accounting segment 6. | DW_GL_SEGMENT6_D | GL_SEGMENT_CODE | ||
| XLA_ACCRUAL_ACCOUNT_GL_SEGMENT6_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 6 value set code. | DW_GL_SEGMENT6_D | GL_SEGMENT_VALUESET_CODE | ||
| XLA_ACCRUAL_ACCOUNT_GL_SEGMENT7 | VARCHAR2 | 32 | Accounting segment 7. | DW_GL_SEGMENT7_D | GL_SEGMENT_CODE | ||
| XLA_ACCRUAL_ACCOUNT_GL_SEGMENT7_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 7 value set code. | DW_GL_SEGMENT7_D | GL_SEGMENT_VALUESET_CODE | ||
| XLA_ACCRUAL_ACCOUNT_GL_SEGMENT8 | VARCHAR2 | 32 | Accounting segment 8. | DW_GL_SEGMENT8_D | GL_SEGMENT_CODE | ||
| XLA_ACCRUAL_ACCOUNT_GL_SEGMENT8_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 8 value set code. | DW_GL_SEGMENT8_D | GL_SEGMENT_VALUESET_CODE | ||
| XLA_ACCRUAL_ACCOUNT_GL_SEGMENT9 | VARCHAR2 | 32 | Accounting segment 9. | DW_GL_SEGMENT9_D | GL_SEGMENT_CODE | ||
| XLA_ACCRUAL_ACCOUNT_GL_SEGMENT9_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 9 value set code. | DW_GL_SEGMENT9_D | GL_SEGMENT_VALUESET_CODE | ||
| XLA_ACCRUAL_ACCOUNT_GL_SEGMENT10 | VARCHAR2 | 32 | Accounting segment 10. | DW_GL_SEGMENT10_D | GL_SEGMENT_CODE | ||
| XLA_ACCRUAL_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 |
Notes
#1 For join with Item Dimension along with INVENTORY_ITEM_ID also join on column INVENTORY_ORGANIZATION_ID. #2 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 PO_EVENT_DATE column