This table requires activation of Receipt Accounting functional area. This fact table stores Accrual balances for all purchase order distributions with Acrrual at period end
Module: Purchasing
PERIOD_START_DATE, CMR_PO_DISTRIBUTION_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
CMR_PO_DISTRIBUTION_ID | NUMBER | 38 | 0 | True | Internal identifier of the purchase order distribution. | ||
PERIOD_START_DATE | DATE | True | Date when the accounting period begins. #2 | DW_DAY_D | CALENDAR_DATE | ||
SOURCE_RECORD_ID | VARCHAR2 | 64 | This column is for Oracle Internal use only. System | ||||
PERIOD_END_DATE | DATE | Date when the accounting period ends. | DW_DAY_D | CALENDAR_DATE | |||
PERIOD_NAME | VARCHAR2 | 16 | Fiscal period name | ||||
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 | |
INVENTORY_ORGANIZATION_ID | NUMBER | 38 | 0 | Inventory organization id where the item is stored | DW_INTERNAL_ORG_D | ORGANIZATION_ID | |
INVENTORY_ITEM_ID | NUMBER | 38 | 0 | Inventory item identifier, it will be null for description based item #1 | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID | |
ITEM_DESCRIPTION | VARCHAR2 | 256 | Item description. | ||||
BILL_TO_BUSINESS_UNIT_ID | NUMBER | 38 | 0 | Business unit that will create the invoice for the purchase. | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID | |
PRIMARY_LEDGER_ID | NUMBER | 38 | 0 | Ledger identifier associated with Bill 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 | ||
PROFIT_CENTER_BUSINESS_UNIT_ID | NUMBER | 38 | 0 | Profit Center Business Unit identifier | 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 | Accrued amount in ledger currency | |||||
LEDGER_INVOICE_AMOUNT | NUMBER | Invoice amount in ledger currency | |||||
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 | Accrued quantity in purchase order unit of measure | |||||
PO_TXN_INVOICED_QTY | NUMBER | Invoiced quantity in purchase order unit of measure | |||||
PUOM_CODE | VARCHAR2 | 32 | Primary UOM code | 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 | |||||
PO_TXN_UNINVOICED_QTY | NUMBER | Un-invoiced Quantity in purchase order unit of measure | |||||
PUOM_UNINVOICED_QTY | NUMBER | Un-invoiced Quantity in primary unit of measure |
#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 PERIOD_START_DATE column
Copyright © 2019, 2024, Oracle and/or its affiliates.