CML_NEW_INVOICE_LINES_GT

This table would be a GT table. This would act as a driver table to drive the association process. All the new invoice lines that need to be processed would be staged in this table.

Details

• Schema: FUSION

• Object owner: CML

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Length	Precision	Not-null	Comments
INVOICE_ID	NUMBER		18	Yes	Surrogate Id that identifies Invoice
INVOICE_NUMBER	VARCHAR2	50			Number specified by the user for invoice.
INVOICE_LINE_NUMBER	VARCHAR2	40		Yes	Uniquely identifies the invoice line.
PROCUREMENT_BUSINESS_UNIT_ID	NUMBER		18	Yes	Surrogate Id that identifies Proc Bu
VENDOR_ID	NUMBER		18	Yes	Surrogate id in the supplier table. Will be used as the supplier id
VENDOR_SITE_ID	NUMBER		18	Yes	Surrogate id in the supplier site table. Will be used as the supplier site id.
INVOICE_LINE_TYPE	VARCHAR2	30			Type of invoice line. Valid values are ITEM, FREIGHT, MISCELLANEOUS, TAX.
CURRENCY_CODE	VARCHAR2	15			Currency code in which invoice is created.
INVOICE_AMOUNT	NUMBER				The invoice amount in invoice currency
TAX_AMOUNT	NUMBER				Tax amount calculated for invoice line.
FUNCTIONAL_INVOICE_AMOUNT	NUMBER				Invoice amount in functional currency
FUNCTIONAL_TAX_AMOUNT	NUMBER				Tax amount in functional currency
FUNCTIONAL_CURRENCY_CODE	VARCHAR2	15			Currency code of the invoicing business unit.
EXTERNAL_SYSTEM_REFERENCE	VARCHAR2	60			Identifier of the source system that owns the Invoice entity.

Indexes

Index	Uniqueness	Columns
CML_NEW_INVOICE_LINES_GT_N1	Non Unique	INVOICE_ID, INVOICE_LINE_NUMBER, PROCUREMENT_BUSINESS_UNIT_ID, VENDOR_ID, VENDOR_SITE_ID, EXTERNAL_SYSTEM_REFERENCE