CST_AP_INVOICE_GT
Global temporary table used in the cost preprocessor. It holds the AP invoice distribution information and PO information for creation of invoice variance transactions for service based PO
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CMR_AP_INVOICE_DIST_ID | NUMBER | 18 | Yes | Internal AP Invoice Distribution Identifier | |
| INVOICE_NUMBER | VARCHAR2 | 50 | User specified invoice number | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Inventory Item Identifier | ||
| ACCOUNTING_DATE | TIMESTAMP | Date when invoice was accounted | |||
| PO_DISTRIBUTION_ID | NUMBER | 18 | Source Identifier of the purchase order distribution that is matched to the invoice distribution. | ||
| PO_NUMBER | VARCHAR2 | 40 | User specified number of the purchase order | ||
| WORK_ORDER_ID | NUMBER | 18 | Internal identifier of the work order | ||
| WORK_ORDER_OPERATION_ID | NUMBER | 18 | Internal identifier of the work order operation | ||
| INVOICE_AMT | NUMBER | Amount on the invoice distribution | |||
| CURRENCY_CODE | VARCHAR2 | 15 | Identifies the currency of the invoice amount | ||
| ITEM_DESCRIPTION | VARCHAR2 | 240 | Description of the item | ||
| CMR_PO_DISTRIBUTION_ID | NUMBER | 18 | Internal identifier of the purchase order distribution that is matched to the invoice distribution. | ||
| COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | 2 | Code for the country of manufacture. | ||
| INVOICE_DISTRIBUTION_TYPE | VARCHAR2 | 25 | Yes | Identifies the distribution type such as Exchange Rate Variance, Invoice Price Variance, Tax Variance etc. | |
| INVENTORY_ORG_ID | NUMBER | 18 | Internal identifier of the inventory organization | ||
| INVOICE_BASE_AMOUNT | NUMBER | Amount on the invoice distribution in functional currency | |||
| PO_CURRENCY_CODE | VARCHAR2 | 15 | Currency code of the PO | ||
| CURRENCY_CONVERSION_DATE | TIMESTAMP | Date to be used to determine exchange rates for currency conversion | |||
| ACTIVE_FLAG | VARCHAR2 | 2 | Flag to verify if receipt transaction exist in costing for the po_distribution_id | ||
| CMR_RCV_TRANSACTION_ID | NUMBER | 18 | Internal identifier of the receiving transaction. | ||
| FISCAL_DOC_HEADER_ID | NUMBER | 18 | Internal identifier of fiscal doc header | ||
| FISCAL_DOC_LINE_ID | NUMBER | 18 | Internal identifier of fiscal document line | ||
| FISCAL_DOC_SCHEDULE_ID | NUMBER | 18 | Internal identifier of fiscal document schedule | ||
| FISCAL_DOC_ACCESS_KNUM | VARCHAR2 | 64 | Fiscal documents access number | ||
| REF_FISCAL_DOC_HEADER_ID | NUMBER | 18 | Internal identifier of reference fiscal document header | ||
| REF_FISCAL_DOC_LINE_ID | NUMBER | 18 | Internal identifier of reference fiscal document line | ||
| REF_FISCAL_DOC_SCHEDULE_ID | NUMBER | 18 | Internal identifier of reference fiscal document schedule | ||
| REF_FISCAL_DOC_ACCESS_KNUM | VARCHAR2 | 64 | Reference fiscal documents access key number |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_AP_INVOICE_GT_N1 | Non Unique | CMR_AP_INVOICE_DIST_ID |