CMF_I_FD_LINES_GT

Stores the Lines of the FISCAL Document.

Details

• Schema: FUSION

• Object owner: CMF

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CMF_I_FD_LINES_GT_PK	EFD_INTERFACE_LINE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
EFD_INTERFACE_LINE_ID	NUMBER		18	Yes	Stores the foreign key which identifies the Interface FD Header row.	Active
EFD_INTERFACE_HEADER_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 Document Item FISCAL Classification.	Active
UNIT_OF_MEASURE	VARCHAR2	6			Stores the FISCAL Document Line Unit of Measure.	Active
QUANTITY	NUMBER				Stores the FISCAL Document Item Quantity.	Active
UNIT_PRICE	NUMBER				Stores the FISCAL Document Line Unit Price.	Active
LINE_AMOUNT	NUMBER				Stores the FISCAL Document Line Amount.	Active
FREIGHT_LINE_AMOUNT	NUMBER				Stores the FISCAL Document Line Amount of Freight.	Active
INSURANCE_LINE_AMOUNT	NUMBER				Stores the FISCAL Document Line Amount of Insurance.	Active
OTHER_EXPENSES_LINE_AMOUNT	NUMBER				Stores the FISCAL Document Line Amount of Other Expenses.	Active
DISCOUNT_LINE_AMOUNT	NUMBER				Stores the FISCAL Document Line Amount of Discount.	Active
SOURCE_DOCUMENT_NUMBER	VARCHAR2	15			Stores the Source FISCAL Document Number.	Active
SOURCE_DOCUMENT_LINE	NUMBER		6		Stores the Source FISCAL Document Line Number.	Active
SOURCE_DOCUMENT_SCHEDULE	NUMBER				Stores the Source FISCAL Document Schedule Number.	Active
ITEM_CODE	VARCHAR2	60			Stores the Item Code from the FISCAL document Line.	Active
ITEM_DESCRIPTION	VARCHAR2	120			Stores the Item Description of the FISCAL Document Line.	Active
CFOP	NUMBER		6		This information will be used to identify the FD Type and Source Document Type.	Active
SOURCE_DOC_CURRENCY_CODE	VARCHAR2	30			Currency code for source document.	Active
SOURCE_DOC_CUR_CONVERSION_TYPE	VARCHAR2	30			Currency conversion type for source document.	Active
TRANSACTION_DATE	TIMESTAMP				Date of transaction of the FISCAL Document Line.	Active
OPERATION_TYPE	VARCHAR2	30			Type of operation of the FISCAL Document Line.	Active
SOURCE_DOC_HEADER_ID	NUMBER		18		Header identifier of the source document.	Active
SOURCE_DOC_LINE_ID	NUMBER		18		Line identifier of the source document.	Active
SOURCE_DOC_SCHEDULE_ID	NUMBER		18		Stores the Source FISCAL Document Schedule Number.	Active
DOCUMENT_TYPE	VARCHAR2	30			Stores Document Type, used in the validation process.	Active
SOURCE_DOCUMENT_TYPE	VARCHAR2	30			Document type of the source document.	Active
LINE_TYPE	VARCHAR2	30			Stores the Line Type of the FISCAL Document.	Active
SOURCE_DOC_BU_ID	NUMBER		18		Stores the BU of the Source Document.	Active
CHARGES_AMOUNT	NUMBER				Stores the FISCAL Document Line Amount of Charges.	Active
RECOVERABLES_TAX	NUMBER				Stores the Recoverables taxes values.	Active
NON_RECOVERABLE_TAX	NUMBER				Stores the Non recoverable taxes values.	Active
PHYSICAL_RECEIPT_QUANTITY	NUMBER				Stores the FISCAL Document Line Physical Receipt Quantity.	Active
PHYSICAL_RECEIPT_UOM	VARCHAR2	30			Physical receipt unit of measure.	Active
PHYSICAL_RECEIPT_DATE	TIMESTAMP				Stores the FISCAL Document Line Physical Receipt Date.	Active
INTENDED_USE	VARCHAR2	30			Stores the Intended Use identifier.	Active
LINE_STATUS	VARCHAR2	30			Stores the Status of the FISCAL Document Line.	Active
FISCAL_QTY_TOLERANCE_ID	NUMBER		18		FISCAL Quantity Tolerance Hold Id.	Active
FISCAL_PRICE_TOLERANCE_ID	NUMBER		18		FISCAL Price Tolerance Hold Id.	Active
PHYSICAL_QTY_TOLERANCE_ID	NUMBER		18		Physical Qhantity Tolerance Hold Id.	Active
BASIS	VARCHAR2	30			Stores de fiscal documet line basis	Active
PERCENTAGE	NUMBER				Stores de fiscal documet line percentage	Active
FD_AMOUNT	NUMBER				Stored the fiscal document line ammount	Active
ALLOCATION_BASIS	VARCHAR2	30			Stores de fiscal document allocation basis.	Active
ALLOCATION_UOM	VARCHAR2	30			Stores the fiscal document unit of measure	Active
CHARGE_LINE_STATUS	VARCHAR2	30			Stored the fiscal document status of charge line.	Active
CHARGE_ID	NUMBER		18		Stores the fiscal document identifier of the charge.	Active
ALLOCATION_BASE_VALUE	NUMBER				Stores the line allocation base value.	Active
ALLOCATION_PERCENTAGE	NUMBER				Stores the line percentage of the allocation	Active
VARIABLE_PERCENTAGE	NUMBER				Stores the line variable percentage	Active
VALIDATION_STATUS	VARCHAR2	30			Stores the Status of the validation results of the current entity.	Active

Indexes

Index	Uniqueness	Columns	Status
CMF_I_FD_LINES_GT_N1	Non Unique	EFD_INTERFACE_HEADER_ID	Active
CMF_I_FD_LINES_GT_U1	Unique	EFD_INTERFACE_LINE_ID	Active