1. Tables and Views for SCM
  2. CMF_RCV_CHARGE_ALLOCS

CMF_RCV_CHARGE_ALLOCS

This entity will hold the per unit Fiscal document charges allocated at receipt level. This entity will act as interface between CMF and CMR/CST from charges perspective. CMR/CST will read the per unit charges from this table and use them for accrual/inventory. These charges, like landed cost charges, are on top of the price so, they must be included over and above invoice price

Details

  • Schema: FUSION

  • Object owner: CMF

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

CMF_RCV_CHARGE_ALLOCS_PK

RCV_CHARGE_ALLOC_ID

Columns

Name Datatype Length Precision Not-null Comments
RCV_CHARGE_ALLOC_ID NUMBER 18 Yes SurrogateID identifying a row in this table.
CMR_RCV_TRANSACTION_ID NUMBER 18 Single column FK, identifies the root receiving transaction in receipt accounting.
FISCAL_DOC_HEADER_ID NUMBER 18 Yes Single Column FK, identifies a fiscal document header.
FISCAL_DOC_LINE_ID NUMBER 18 Yes Single Column FK: Identifies a fiscal document line.
FISCAL_DOC_LINE_NUM NUMBER 9 Yes Indicates the fiscal document line number.
INVOICE_ID NUMBER 18 Identifies the Payables Invoice Identifier
INVOICE_LINE_NUMBER VARCHAR2 40 Identifies the user specified invoice line number
CHARGE_ID NUMBER 18 Yes Single Column FK: Identifies the charge name against which the amount is incurred.
REQ_BU_ID NUMBER 18 Yes Surrogate ID identifying the business unit which is requisitioning the charge. For standard fiscal docs its the req BU on the material PO. For freight fiscal doc its the req BU on the freight PO if available else req BU on the associated material PO.
EFFECTIVE_DATE TIMESTAMP Yes Used to allow date effectivity. System time when the charge line is inserted in this table.
ACTIVE_FLAG VARCHAR2 1 Yes Flag indicating if a row is active or not. Possible values are Y and N.
CMR_PO_LINE_LOCATION_ID NUMBER 18 Yes Surrogate ID identifying a po line location in receipt accounting.
UNIT_AMOUNT NUMBER Yes Per unit allocated charge amount in source document(e.g. PO) UOM and requisition BU(as indiciated above) functional currency.
UNIT_TAX NUMBER Yes Per unit allocated tax amount in source document(e.g. PO) UOM and requisition BU(as indiciated above) functional currency.
SOURCE_DOC_UOM_CODE VARCHAR2 3 Yes Source document UOM. Values in this table are stored in this UOM.
CURRENCY_CODE VARCHAR2 15 Yes Requisition BU functional currency. Amounts in this table are stored in this currency.
SHIP_TO_ORGANIZATION_ID NUMBER 18 This column stores receiving organization unique identifier where the receiving transaction is created.
PROCESSED_BY_CA_FLAG VARCHAR2 5 Indicates whether the row is processed by cost accounting.
PROCESSED_BY_RA_FLAG VARCHAR2 5 Indicates whether the rows is processed by receipt accounting.
PRIMARY_UOM_CONV_FACTOR NUMBER Conversion factor between source document UOM and primary UOM of the item in receiving organization. To be derived using primary quantity and source document quantity on receipt.
CURRENCY_CONVERSION_TYPE VARCHAR2 30 Currency conversion type used to calculate conversion factor from charge requisition BU currency to material BU functional currency.
CURRENCY_CONVERSION_DATE DATE Currency conversion date. Transaction date of the material receipt.
CURRENCY_CONVERSION_RATE NUMBER Currency conversion rate used to convert from charge requisition BU currency to material BU functional currency.
PREPROCESS_STATUS VARCHAR2 30 Indicates the status of this transaction for downstream applications. SUCCESS - rows is ready to be picked, ERROR - some required columns values failed to derive.
MAT_REQ_BU_FUNC_CURRENCY_CODE VARCHAR2 15 Functional currency code of the material requisition BU.
BILL_TO_BUSINESS_UNIT_ID NUMBER 18 Bill to business unit for this charge. Value available on FD header.
INTERCOMPANY_BILL_TO_BU_ID NUMBER 18 Bill to business unit in case of intercompany flow. When the profit center BU of the material receipt is differnt than the charge requisition BU.
INTERCOMPANY_PROCESSED_FLAG VARCHAR2 5 Indicates if intercompany processing has happend for this charge in receipt accounting.
SERVICE_PO_FLAG VARCHAR2 1 Indicates if the charge is associated with a Service PO.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.

Indexes

Index Uniqueness Tablespace Columns
CMF_RCV_CHARGE_ALLOCS_N1 Non Unique Default CMR_RCV_TRANSACTION_ID, ACTIVE_FLAG
CMF_RCV_CHARGE_ALLOCS_N2 Non Unique Default REQ_BU_ID, PROCESSED_BY_CA_FLAG
CMF_RCV_CHARGE_ALLOCS_N3 Non Unique Default ACTIVE_FLAG, PREPROCESS_STATUS, PROCESSED_BY_CA_FLAG
CMF_RCV_CHARGE_ALLOCS_PK Unique Default RCV_CHARGE_ALLOC_ID
CMF_RCV_CHARGE_ALLOCS_U1 Unique Default CMR_RCV_TRANSACTION_ID, FISCAL_DOC_HEADER_ID, FISCAL_DOC_LINE_NUM, CHARGE_ID, EFFECTIVE_DATE
CMF_RCV_CHARGE_ALLOCS_U2 Unique Default CMR_RCV_TRANSACTION_ID, FISCAL_DOC_LINE_ID, CHARGE_ID, EFFECTIVE_DATE