CMR_BU_AP_INVOICES_GT
This table stores all invoices belonging to single business unit 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 | Identifies the payables 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 purchase order 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 | Source identifier of the receipt transaction. | ||
| 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 | Quantity being invoiced in unit of measure code. | |||
| INVOICE_QTY_IN_PO_UOM | NUMBER | Invoice quantity in purchase order document's unit of measure code. | |||
| UNIT_OF_MEASURE | VARCHAR2 | 25 | Invoice unit of measure code. This can be purchase order or receipt transaction unit of measure code. | ||
| INVOICE_DISTRIBUTION_TYPE | VARCHAR2 | 25 | Identifies the distribution type such as Accrual, Exchange Rate Variance, Freight, Invoice Price Variance, Item, Non-recoverable 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 purchase order or the receipt after the final match. | ||
| ACCOUNTING_DATE | DATE | Date when the invoice was accounted. | |||
| PURCHASE_BASIS | VARCHAR2 | 30 | Identifies whether the purchase order 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 purchase order 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. | ||
| SOURCE_DOC_LINE_NUMBER | VARCHAR2 | 40 | User specified number for the purchase order line. | ||
| SOURCE_DOC_SHIPMENT_NUMBER | VARCHAR2 | 40 | User specified number for the purchase order shipment. | ||
| SOURCE_DOC_DISTRIB_NUMBER | VARCHAR2 | 40 | User specified number for the purchase order distribution. | ||
| VENDOR_ID | NUMBER | 18 | Identifies the Supplier and references to {POZ_SUPPLIERS.vendor_id}. | ||
| VENDOR_SITE_ID | NUMBER | 18 | Identifies the supplier site and references to {POZ_SUPPLIER_SITES_ALL_M.vendor_site_id}. | ||
| SHIP_TO_LOCATION_ID | NUMBER | 18 | The identifier of the specific location that the goods are being shipped. | ||
| PO_ITEM_DESCRIPTION | VARCHAR2 | 240 | Item description specified in purchase order line. Especially needed for purchase orders involving non inventory items. | ||
| FISCAL_DOC_NUMBER | VARCHAR2 | 30 | Number for the Fiscal Document given on the Fiscal Document sent by the supplier. | ||
| FISCAL_DOC_LINE_NUMBER | NUMBER | Indicates the line number of the Fiscal Document item line. |