CMR_I_AP_INVOICE_DTLS
Interface table to hold accounts payable invoice information at the invoice distribution level. Only invoices that can be tied to a Purchase Order or a Receipt transaction should be populated in this interface. This interface does not support any change management to information that has already been passed to it. So populate invoices only when it is in a state that cannot be modified in the source system.
Details
-
Schema: FUSION
-
Object owner: CMR
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
CMR_I_AP_INVOICE_DTLS_PK |
EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 60 | Yes | Identifier of the source system that owns the Accounts Payable Invoice entity | |
| EXTERNAL_SYSTEM_REF_ID | VARCHAR2 | 30 | Yes | Identifier of the AP Invoice distribution line in the source system | |
| CMR_AP_INVOICE_DIST_ID | NUMBER | 18 | Internal AP Invoice Distribution Identifier | ||
| INVOICE_ID | NUMBER | 18 | Yes | Identifies the Payables Invoice Identifier and references to {AP_INVOICE_LINES_ALL} | |
| INVOICE_NUMBER | VARCHAR2 | 50 | User specified invoice number while creating the payable invoice. | ||
| INVOICING_BUSINESS_UNIT_ID | NUMBER | 18 | Yes | Identifier of the business unit that owns the invoice | |
| INVOICE_LINE_NUMBER | VARCHAR2 | 40 | User specified invoice line number | ||
| INVOICE_AMT | NUMBER | Amount on the invoice distribution | |||
| INVOICE_BASE_AMOUNT | NUMBER | invoice amount on the distribution in functional currency | |||
| DIST_CODE_COMBINATION_ID | NUMBER | 18 | Account identifier associated with invoice distribution | ||
| 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 | |||
| UNIT_OF_MEASURE | VARCHAR2 | 25 | Identifies the unit of measure for the invoice quantity | ||
| DISTRIBUTION_MATCH_TYPE | VARCHAR2 | 25 | Identifies whether the invoice is matched to a Purchase order or a receipt transaction | ||
| INVOICE_DISTRIBUTION_TYPE | VARCHAR2 | 25 | Identifies the distribution type such as Accrual, Exchange Rate Variance, Freight, Invoice Price Variance, Item, Nonrecoverable tax, Miscellaneous etc. | ||
| INVOICE_LINE_TYPE | VARCHAR2 | 30 | Type of invoice line. Valid values are ITEM, FREIGHT, MISCELLANEOUS, TAX. | ||
| TAX_CODE_ID | NUMBER | 18 | Identifies the tax code that was used on this distribution for the invoice date. | ||
| LCM_ENABLED_FLAG | VARCHAR2 | 1 | Indicates if this invoice line is for a landed cost charge. | ||
| LINE_CANCELLED_FLAG | VARCHAR2 | 1 | Indicates whether the invoice line has been cancelled. Y - Yes, NULL or N - No. | ||
| VENDOR_ID | NUMBER | 18 | Identifies the Supplier and {References PO_VENDORS.vendor_id}. | ||
| VENDOR_SITE_ID | NUMBER | 18 | Identifies the Supplier Site and references {PO_VENDOR_SITES_ALL.vendor_site_id}. | ||
| PO_DISTRIBUTION_ID | NUMBER | 18 | Identifier of the purchase order distribution that is matched to the Invoice distribution. This value is expected for match to PO as well as match to Receipt cases. | ||
| RCV_TRANSACTION_ID | NUMBER | 18 | Identifier of the receipt transaction. This value is expected only for the match to receipt cases. | ||
| CONSUMPTION_ADVICE_HEADER_ID | NUMBER | 18 | Header identifier of the consumption advice line that is matched to the invoice. | ||
| CONSUMPTION_ADVICE_LINE_ID | NUMBER | 18 | Identifier of the consumption advice line that is matched to the invoice. | ||
| 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 | TIMESTAMP | Date when the invoice was accounted. | |||
| INVOICE_CREATION_DATE | TIMESTAMP | Date when the invoice was created | |||
| EXPENDITURE_ITEM_DATE | TIMESTAMP | Expenditure item date that will be passed on to Projects. | |||
| CORRECTED_INVOICE_DIST_ID | NUMBER | 18 | For correction invoices, this identifies the invoice distribution that is being corrected. | ||
| INVOICE_SOURCE | VARCHAR2 | 25 | Identifies the source of the invoice such as Intercompany, Credit Card etc. Mainly used by Cost Management to filter Intercompany invoices. | ||
| RELATED_DISTRIBUTION_ID | NUMBER | 18 | Identifier that links related distributions. | ||
| CHARGE_APPLICABLE_TO_DIST_ID | NUMBER | 18 | Identifies the invoice distribution to which this one applies. | ||
| 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 | TIMESTAMP | The date to be used to determine the exchange rates for currency conversion | |||
| CURRENCY_CONVERSION_RATE | NUMBER | Optional user specified currency conversion rate. | |||
| REVERSAL_FLAG | VARCHAR2 | 1 | Indicates if this invoice distribution is reversing another invoice distribution. This could happen due to invoice line cancellation, discarding an invoice line etc. | ||
| SELF_ASSESSED_FLAG | VARCHAR2 | 1 | Self Assessed Flag to indicate the NONREC TAX invoice distribution line is self assessed or not. | ||
| PARENT_REVERSAL_ID | NUMBER | 18 | Identifies the invoice distribution that is being reversed. | ||
| FISCAL_DOC_HEADER_ID | NUMBER | Surrogate Identifying the fiscal document header. | |||
| FISCAL_DOC_LINE_ID | NUMBER | Surrogate Identifying a fiscal document line. | |||
| FISCAL_CHARGE_TYPE | VARCHAR2 | 30 | Tax driver. Subclassification for invoice line type of Freight or Miscellaneous. Valid values are from lookup ZX_CHARGE_TYPE. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| PROCESSING_STATUS | VARCHAR2 | 20 | This attribute explains about the processing status information | ||
| 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. | ||
| TAX_POINT_BASIS | VARCHAR2 | 30 | Tax point basis applicable to the tax line on each invoice distribution. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CMR_I_AP_INVOICE_DTLS_N1 | Non Unique | Default | INVOICE_ID |
| CMR_I_AP_INVOICE_DTLS_PK | Unique | FUSION_TS_TX_DATA | EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID |