CMF_I_FISCAL_DOC_LINES

Stores the Lines of the FISCAL Document.

Details

  • Schema: FUSION

  • Object owner: CMF

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

CMF_I_FISCAL_DOC_LINES_PK

EFD_INTERFACE_LINE_ID

Columns

Name Datatype Length Precision Not-null Comments
EFD_INTERFACE_LINE_ID NUMBER 18 Yes Stores the foreign key which identifies the Interface FD Header row.
EFD_INTERFACE_HEADER_ID NUMBER 18 Stores the Unique key which identifies the row.
DOCUMENT_LINE_ID NUMBER 18 Line identifier of the document.
DOCUMENT_HEADER_ID NUMBER 18 Stores the foreign key which identifies the FD Header row.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
LINE_NUMBER NUMBER 9 Stores the FISCAL Document Line Number.
FISCAL_CLASSIFICATION VARCHAR2 240 Stores the FISCAL Document Item FISCAL Classification.
UNIT_OF_MEASURE VARCHAR2 6 Stores the FISCAL Document Line Unit of Measure.
QUANTITY NUMBER Stores the FISCAL Document Item Quantity.
UNIT_PRICE NUMBER Stores the FISCAL Document Line Unit Price.
LINE_AMOUNT NUMBER Stores the FISCAL Document Line Amount.
FREIGHT_LINE_AMOUNT NUMBER Stores the FISCAL Document Line Amount of Freight.
INSURANCE_LINE_AMOUNT NUMBER Stores the FISCAL Document Line Amount of Insurance.
OTHER_EXPENSES_LINE_AMOUNT NUMBER Stores the FISCAL Document Line Amount of Other Expenses.
DISCOUNT_LINE_AMOUNT NUMBER Stores the FISCAL Document Line Amount of Discount.
SOURCE_DOCUMENT_NUMBER VARCHAR2 15 Stores the Source FISCAL Document Number.
SOURCE_DOCUMENT_LINE NUMBER 6 Stores the Source FISCAL Document Line Number.
SOURCE_DOCUMENT_SCHEDULE NUMBER 18 Stores the Source FISCAL Document Schedule Number.
ITEM_CODE VARCHAR2 60 Stores the Item Code from the FISCAL document Line.
ITEM_DESCRIPTION VARCHAR2 120 Stores the Item Description of the FISCAL Document Line.
CFOP NUMBER 6 This information will be used to identify the FD Type and Source Document Type.
SOURCE_DOC_CURRENCY_CODE VARCHAR2 30 Currency code for source document.
SOURCE_DOC_CUR_CONVERSION_TYPE VARCHAR2 30 Currency conversion type for source document.
TRANSACTION_DATE VARCHAR2 30 Date of transaction of the FISCAL Document Line.
OPERATION_TYPE VARCHAR2 30 Type of operation of the FISCAL Document Line.
SOURCE_DOC_HEADER_ID NUMBER 18 Header identifier of the source document.
SOURCE_DOC_LINE_ID NUMBER 18 Line identifier of the source document.
SOURCE_DOC_SCHEDULE_ID NUMBER 18 Stores the Source FISCAL Document Schedule Number.
DOCUMENT_TYPE VARCHAR2 30 Stores Document Type, used in the validation process.
SOURCE_DOCUMENT_TYPE VARCHAR2 30 Document type of the source document.
LINE_TYPE VARCHAR2 30 Stores the Line Type of the FISCAL Document.
SOURCE_DOC_BU_ID NUMBER 18 Stores the BU of the Source Document.
CHARGES_AMOUNT NUMBER Stores the FISCAL Document Line Amount of Charges.
TAXES_RECOVERABLES NUMBER Stores the FISCAL Document Line Recoverable Taxes.
TAXES_NON_RECOVERABLE NUMBER Stores the FISCAL Document Line Non Recoverable Taxes.
PHYSICAL_RECEIPT_QUANTITY NUMBER Stores the FISCAL Document Line Physical Receipt Quantity.
PHYSICAL_RECEIPT_UOM VARCHAR2 30 Physical receipt unit of measure.
PHYSICAL_RECEIPT_DATE TIMESTAMP Stores the FISCAL Document Line Physical Receipt Date.
INTENDED_USE VARCHAR2 30 Stores the Intended Use identifier.
LINE_STATUS VARCHAR2 30 Stores the Status of the FISCAL Document Line.
FISCAL_QTY_TOLERANCE_ID NUMBER 18 FISCAL Quantity Tolerance Hold Id.
FISCAL_PRICE_TOLERANCE_ID NUMBER 18 FISCAL Price Tolerance Hold Id.
PHYSICAL_QTY_TOLERANCE_ID NUMBER 18 Physical Qhantity Tolerance Hold Id.
VALIDATION_STATUS VARCHAR2 10 Stores the Status of the validation results of the current entity.
EXTERNAL_SYSTEM_REFERENCE VARCHAR2 240 Is used for backend processing based on the interface records.
EXTERNAL_SYSTEM_REF_ID VARCHAR2 30 Is used for backend processing based on the interface records.
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.
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.
SOURCE_CURRENCY_CODE VARCHAR2 30 Currency code for source document.

Foreign Keys

Table Foreign Table Foreign Key Column
CMF_I_FISCAL_DOC_LINES cmf_i_fiscal_doc_headers EFD_INTERFACE_HEADER_ID

Indexes

Index Uniqueness Tablespace Columns
CMF_I_FISCAL_DOC_LINES_F1 Non Unique FUSION_TS_TX_DATA EFD_INTERFACE_HEADER_ID
CMF_I_FISCAL_DOC_LINES_U1 Unique FUSION_TS_TX_DATA EFD_INTERFACE_LINE_ID