CMR_BU_AP_INVOICES_GT

This table stores all Invoices belonging to single BU transactions

Details

• Schema: FUSION

• Object owner: CMR

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CMR_AP_INVOICE_DIST_ID	NUMBER		18	Yes	ap invoice distribution identifier
INVOICE_ID	NUMBER		18	Yes	Identifies the Payables Invoice Identifier
INVOICING_BUSINESS_UNIT_ID	NUMBER		18	Yes	Identifier of the business unit that owns the invoice
DELIVER_TO_BUSINESS_UNIT_ID	NUMBER		18		deliver to business unit identifier on Purchase order.
DELIVER_TO_INVENTORY_ORG_ID	NUMBER		18		Inventory organization where the material is scheduled to be received
CMR_PO_DISTRIBUTION_ID	NUMBER		18		Single column FK: Identifies entity in Receipt accounting PO Distributions. This value will exist for match to PO as well as match to Receipt cases.
CMR_RCV_TRANSACTION_ID	NUMBER		18		Single Column FK: Identifies the receiving transaction.
PO_LINE_LOCATION_ID	NUMBER		18		Purchase Order Schedule Identifier.
RCV_TRANSACTION_ID	NUMBER		18		Receipt Transaction Identifier.
INVENTORY_ITEM_ID	NUMBER		18		inventory item identifier and References {EGP_SYSTEM_ITEMS_B.inventory_item_id}.
INVOICE_AMT	NUMBER				Amount on the invoice distribution
INVOICE_BASE_AMOUNT	NUMBER				Amount on the invoice distribution in functional currency
INVOICE_TYPE	VARCHAR2	25			Identifies the type of invoice such as Standard Invoice, Credit memo, Debit memo etc.
INVOICE_QTY	NUMBER				invoice quantity in unit of measure of po UOM or receipt transaction UOM for PO flows.
INVOICE_QTY_IN_PO_UOM	NUMBER				Invoice qty in purchase order document's unit of measure code.
UNIT_OF_MEASURE	VARCHAR2	25			invoice unit of measure code. This can be PO UOM code or Receipt transaction UOM code.
INVOICE_DISTRIBUTION_TYPE	VARCHAR2	25			Identifies the distribution type such as Accrual, Exchange Rate Variance, Freight, Invoice Price Variance, Item, Nonrecoverable tax, Miscellaneous etc.
DISTRIBUTION_MATCH_TYPE	VARCHAR2	25			Identifies whether the invoice is matched to a Purchase order or a receipt transaction.
DESTINATION_TYPE_CODE	VARCHAR2	25			identifies the destination type for material - RECEIVING, INVENTORY or EXPENSE
FINAL_MATCH_FLAG	VARCHAR2	1			Indicates whether this is a final match invoice. No further invoices are expected for the PO or the Receipt after the final match.
ACCOUNTING_DATE	DATE				Date when the invoice was accounted.
PURCHASE_BASIS	VARCHAR2	30			Identifies whether the PO line is for Goods or Services. Valid values are 'GOODS' and 'SERVICES'
MATCH_OPTION	VARCHAR2	25			Invoice match option, P indicates order matched, R indicated receipt matched.
CURRENCY_CODE	VARCHAR2	15			Identifies the currency of the invoice amount
CURRENCY_CONVERSION_TYPE	VARCHAR2	30			Conversion type that should be used for currency conversion.
CURRENCY_CONVERSION_DATE	DATE				The date to be used to determine the exchange rates for currency conversion
CURRENCY_CONVERSION_RATE	NUMBER				Optional user specified currency conversion rate.
INVOICING_BU_FUNC_CURR_CODE	VARCHAR2	15			invoicing business unit's functional currency code
SELF_ASSESSED_FLAG	VARCHAR2	1			Self Assessed Flag on invoice distribution for TAX lines.
INVOICE_NUMBER	VARCHAR2	50			Payable invoice number created against this PO distribution
PO_NUMBER	VARCHAR2	50			Purchase order number defined and matched to against this invoice.
CONSIGNED_FLAG	VARCHAR2	1			Indicates Purchase order is for consigned flow or not.
RECEIPT_TXN_DATE	DATE				Transaction_Date of the receipt
RECEIPT_CREATION_DATE	DATE				Date when the receipt got created
LEGAL_ENTITY_ID	NUMBER		18		Legal entity from purchase order document
LEDGER_ID	NUMBER		18		ledger of business unit for invoice distribution
FISCAL_DOCUMENT_DETAIL_ID	NUMBER		18		Fiscal Document detail Identifier and this maps FDC document identifier table.
INCLUSIVE_FLAG	VARCHAR2	1			Inclusive flag to find out invoice amounts on each invoice distribution is a tax exclusive and tax inclusive amount or not.
INTERCOMPANY_INVOICING_FLAG	VARCHAR2	1			Flag to indicate if intercompany invoicing is enabled or not.