1. Tables and Views for SCM
  2. CMR_FISCAL_DOCUMENT_DETAILS

CMR_FISCAL_DOCUMENT_DETAILS

This table contains the details of fiscal documents validated for both CST and CMR processors to use for creating necessary accounting.

Details

  • Schema: FUSION

  • Object owner: CMR

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

CMR_FISCAL_DOCUMENT_DTL_PK

FISCAL_DOCUMENT_DETAIL_ID

Columns

Name Datatype Length Precision Not-null Comments
FISCAL_DOCUMENT_DETAIL_ID NUMBER 18 Yes Surrogate key that uniquely identifies a single fiscal document detail record in the table.
FD_HEADER_ID NUMBER 18 Yes Identifier for the Fiscal Document header.
FD_LINE_ID NUMBER 18 Yes Identifier for the Fiscal Document item line.
FD_SCHEDULE_ID NUMBER 18 Yes Identifier for the Fiscal Document schedule.
FD_ACCESS_KEY_NUMBER VARCHAR2 64 Access Key number generated by issuer for each electronic fiscal document or electronic freight fiscal document.
FD_DOCUMENT_TYPE VARCHAR2 30 Indicates the type of Fiscal Document. Valid values are in lookup type ORA_CMF_DOC_TYPE
FD_LINE_TYPE VARCHAR2 30 Indicates the line type of the Fiscal Document item line. Valid values are in lookup type ORA_CMF_LINE_TYPE.
FD_LINE_NUMBER NUMBER Indicates the line number of the Fiscal Document item line.
FD_LINE_QUANTITY NUMBER Indicates the line quantity of the Fiscal Document item line.
SOURCE_DOCUMENT_TYPE VARCHAR2 30 Source document type as captured in FDC. Valid values are in lookup type ORA_CMF_SOURCE_DOC_TYPE
SOURCE_DOCUMENT_LINE_ID NUMBER 18 Source document line identifier.
SOURCE_DOCUMENT_SCHEDULE_ID NUMBER 18 Source document schedule identifier.
REFERENCE_FD_HEADER_ID NUMBER 18 Identifier for the Reference Fiscal Document.
REFERENCE_FD_LINE_ID NUMBER 18 Identifier for the Reference Fiscal Document item line.
REQUISITION_BU_ID NUMBER 18 Identifier of the requisition business unit for the given combination of Source Document Number, Line, and Schedule.
PROCUREMENT_BU_ID NUMBER 18 Identifier of the procurement business unit for the given combination of Source Document Number, Line, and Schedule.
BILL_TO_BUSINESS_UNIT_ID NUMBER 18 Bill-to Business Unit identifier.
SOLD_TO_LEGAL_ENTITY_ID NUMBER 18 Sold-to Legal Entity identifier.
FD_ACKNOWLEDGED_DATE DATE Date when FD is acknowledged in the FDC.
RCV_TRANSACTION_ID NUMBER 18 Physical receipt transaction identifier as captured in FDC.
SHIP_TO_ORGANIZATION_ID NUMBER 18 This column stores receiving organization unique identifier where the receiving transaction is created.
RECEIPT_NUM VARCHAR2 50 Physical receipt number as captured in FDC.
RECEIPT_LINE_NUM NUMBER 18 Physical receipt line number as captured in FDC.
TRANSACTION_DATE DATE Physical receipt transaction date.
INVENTORY_ITEM_ID NUMBER 18 Item details as captured on the FD item line.
TRANSACTION_QTY NUMBER Indicates the physical receipt quantity.
TRANSACTION_UOM_CODE VARCHAR2 3 UOM of the physical receipt quantity.
TAX_AMOUNT_INCLUDED_FLAG VARCHAR2 1 Indicates whether this tax line is inclusive. Valid values are Y or N.
FD_UOM_CODE VARCHAR2 30 UOM for the FD line as captured in FDC.
SOURCE_DOCUMENT_UOM_CODE VARCHAR2 3 UOM in the source document line for a given FD line.
FD_LINE_UNIT_PRICE NUMBER Fiscal Document item line unit price.
TAX_AMOUNT NUMBER Fiscal Document item line tax amount.
CHARGE_AMOUNT NUMBER Fiscal Document item line charge amount.
FD_CURRENCY_CODE VARCHAR2 15 Identifier for the Fiscal Document currency code.
SOURCE_DOCUMENT_CURRENCY_CODE VARCHAR2 15 Identifier for the source document currency code.
REQ_BU_FUNC_CURRENCY_CODE VARCHAR2 15 Identifier for the requisition business unit functional currency code.
REQ_BU_FUNC_CURRENCY_RATE NUMBER Indicates the currency conversion rate for converting from the fiscal document currency to the requisition business unit functional currency based on the fiscal document's currency conversion type and date values. This value is < 0 if the currency conversion rate retrieval was not successful.
FD_CURRENCY_CONVERSION_TYPE VARCHAR2 30 The currency conversion type as captured in FDC.
FD_CURRENCY_CONVERSION_DATE DATE Fiscal Document Acknowledged Date (Date as used in FDC for Conversion). For Complementary FDs the date used will be that of the one recorded in Standard FD.
FD_CURRENCY_CONVERSION_RATE NUMBER The currency conversion rate as captured in FDC
SERVICE_PO_LINE_FLAG VARCHAR2 1 Indicates if the line is backed by Service PO. It would be Y in case of Freight FDs which is based on a Purchase Order.
PROCESSED_BY_RA_FLAG VARCHAR2 1 Flag to indicate if the row is picked or processed by Receipt Accounting Distribution Processor.
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.

Foreign Keys

Table Foreign Table Foreign Key Column
CMR_FISCAL_DOCUMENT_DETAILS cmf_fiscal_doc_headers FD_HEADER_ID

Indexes

Index Uniqueness Tablespace Columns
CMR_FISCAL_DOCUMENT_DTLS_N1 Non Unique Default FD_HEADER_ID, FD_LINE_ID, FD_SCHEDULE_ID
CMR_FISCAL_DOCUMENT_DTLS_N2 Non Unique Default PROCESSED_BY_RA_FLAG, REQUISITION_BU_ID
CMR_FISCAL_DOCUMENT_DTLS_PK Unique Default FISCAL_DOCUMENT_DETAIL_ID