1. Tables and Views for SCM
  2. CMF_FD_LINES_INT

CMF_FD_LINES_INT

Stores the Lines of the Fiscal Document.

Details

  • Schema: FUSION

  • Object owner: CMF

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

CMF_FD_LINES_INT_PK

FD_LINES_INT_ID

Columns

Name Datatype Length Precision Not-null Comments Status
FD_LINES_INT_ID NUMBER 18 Yes Stores the foreign key which identifies the Interface FD Header row. Active
FD_HEADERS_INT_ID NUMBER 18 Stores the Unique key which identifies the row. Active
DOCUMENT_LINE_ID NUMBER 18 Line identifier of the document. Active
DOCUMENT_HEADER_ID NUMBER 18 Stores the foreign key which identifies the FD Header row. Active
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. Active
LINE_NUMBER NUMBER 9 Stores the Fiscal Document Line Number. Active
FISCAL_CLASSIFICATION VARCHAR2 240 Stores the Fiscal Classification of the fiscal document line. Active
UNIT_OF_MEASURE VARCHAR2 6 Stores the Unit of Measure of the fiscal document line. Active
QUANTITY NUMBER Stores the Quantity of the fiscal document line. Active
UNIT_PRICE NUMBER Stores the Unit Price of the fiscal document line. Active
LINE_AMOUNT NUMBER Stores the fiscal document line amount. Active
FREIGHT_LINE_AMOUNT NUMBER Stores the Freight charge amount for the fiscal document line. Active
INSURANCE_LINE_AMOUNT NUMBER Stores the Insurance charge amount for the fiscal document line. Active
OTHER_EXPENSES_LINE_AMOUNT NUMBER Stores the Miscellaneous charge amount for the fiscal document line. Active
DISCOUNT_LINE_AMOUNT NUMBER Stores the Discount charge amount for the fiscal document line. Active
SOURCE_DOCUMENT_NUMBER VARCHAR2 100 Stores the source document number of the line. Active
SOURCE_DOCUMENT_LINE NUMBER Stores the source document line number of the fiscal document line. Active
ITEM_CODE VARCHAR2 60 Stores the Item Code of the fiscal document line. Active
ITEM_ID NUMBER 18 Stores the inventory item identifier of the document line.
ITEM_DESCRIPTION VARCHAR2 250 Stores the Item description of the fiscal document line. Active
CFOP VARCHAR2 20 This information will be used to identify the FD Type and Source Document Type. Active
SOURCE_DOC_HEADER_ID NUMBER 18 Stores the identifier of the source document mapped to the fiscal document line. Active
SOURCE_DOC_LINE_ID NUMBER 18 Stores the source document line identifier of the fiscal document line. Active
SOURCE_DOC_SCHEDULE_ID NUMBER 18 Stores the source document schedule identifier of the fiscal document line. Active
SOURCE_DOCUMENT_TYPE VARCHAR2 30 Document type of the source document. Active
LINE_TYPE VARCHAR2 30 Stores the Type of the fiscal document line. Active
SOURCE_DOC_BU_ID NUMBER 18 Stores the BU of the Source Document. Active
CHARGES_AMOUNT NUMBER Stores the total charges amount of the fiscal document line. Active
INTENDED_USE NUMBER 18 Stores the Intended Use identifier. Active
VALIDATION_STATUS VARCHAR2 10 Stores the Status of the validation results of the current entity. Active
REF_DOCUMENT_HEADER_ID NUMBER 18 Stores the Referenced Document Header Id. Active
REF_DOCUMENT_LINE_ID NUMBER 18 Stores the Referenced Fiscal Document Line Id. Active
EXTERNAL_SYSTEM_REFERENCE VARCHAR2 240 Is used for backend processing based on the interface records. Active
EXTERNAL_SYSTEM_REF_ID VARCHAR2 30 Is used for backend processing based on the interface records. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. Active
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
SOURCE_CURRENCY_CODE VARCHAR2 30 Currency code for source document. Active
PRODUCT_FISCAL_CLASSIF_ID NUMBER 18 Set codes used to classify the product. It is used for determining taxes and rates. Active
FD_CONVERTED_CFOP VARCHAR2 240 Set of codes determined by Tax Authority. It is used to classify the Operation Nature. This code is chosen when the Fiscal Document is being entered into the system.
FREIGHT_MODAL VARCHAR2 240 The freight modal defines the means of transportation used to carry the goods.
PRODUCT_CATEGORY VARCHAR2 240 It stores Product Origin when Line Type is "Goods" or Service Type when Line Type is "Services".
REF_FD_DOCUMENT_TYPE VARCHAR2 32 Stores the identification of the Referenced Fiscal Document Type.
REQ_BU_ID NUMBER 18 Stores the Requisitioning BU for this line.
SOURCE_REF_DOC_LINE_ID NUMBER 18 Identifies a line in the referenced source document header for the fiscal document. Eg. shipment line for the ASN/ASNB associated with drop ship seller flow, a line in consumption advice for the consigned flow etc.
ASSESSABLE_VALUE NUMBER Deemed price at which a product is valued, by a tax authority for a given tax, for tax calculation purposes.
FINAL_DISCHARGE_LOCATION_ID NUMBER 18 Unique Identifier for the final destination location of the purchases made by a customer.
TAX_CLASSIFICATION_CODE VARCHAR2 30 Input Tax classification code for Procure to Pay products is represented by this column.
EFD_PROD_ADD_INFO VARCHAR2 500 Additional information about the electronic fiscal document line.
EFD_ITEM_CODE VARCHAR2 300 Item code given in the electronic fiscal document.
EFD_ITEM_DESCRIPTION VARCHAR2 250 Item description given in the electronic fiscal document.
TUOM_TO_SUOM_CONV_FACT NUMBER The UOM conversion rate between fiscal document transaction UOM and item secondary UOM.
SECONDARY_UOM_CODE VARCHAR2 30 The secondary unit of measure code of the inventory item.
SECONDARY_QUANTITY NUMBER Fiscal document quantity in the item's secondary unit of measure.
FCI_CONTROL_NUMBER VARCHAR2 36 This column Stores the FCI Control Number in FD xml.
ICMS_ORIGIN_CODE VARCHAR2 2 This column stores the Origin Code of the ICMS tax in FD xml.

Indexes

Index Uniqueness Tablespace Columns Status
CMF_FD_LINES_INT_U1 Unique Default FD_LINES_INT_ID Active
CMF_FD_LINES_INT_U2 Unique Default FD_HEADERS_INT_ID, LINE_NUMBER