CMF_AP_INVOICES_GT
Staging table for fiscal document information used to generate invoice headers.
Details
-
Schema: FUSION
-
Object owner: CMF
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CMF_AP_INVOICES_GT_PK |
INVOICE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INVOICE_ID | NUMBER | 18 | Yes | Invoice identifier. Must be unique. | |
| INVOICE_NUM | VARCHAR2 | 50 | Supplier invoice number. Validation: must be unique for the supplier site. | ||
| FISCAL_DOC_HEADER_ID | NUMBER | 18 | Yes | Fiscal document header unique identifier. | |
| FISCAL_DOC_ACCESS_KEY | VARCHAR2 | 64 | Fiscal document access key number. | ||
| REF_FISCAL_DOC_HEADER_ID | NUMBER | 18 | Referenced fiscal document header unique identifier. | ||
| INVOICE_TYPE_LOOKUP_CODE | VARCHAR2 | 25 | Type of invoice. Use the Manage Payables Lookups task, lookup type INVOICE TYPE to identify valid values. | ||
| INVOICE_DATE | DATE | Invoice date used to calculate due date per payment terms. | |||
| VENDOR_ID | NUMBER | 18 | Supplier identifier. If the identifier is not available, Validated against POZ_SUPPLIERS.VENDOR_ID. | ||
| VENDOR_LOCATION_ID | NUMBER | 18 | Supplier location identifier originally captured in the fiscal document. Used for deriving supplier id and supplier site id. | ||
| VENDOR_SITE_ID | NUMBER | 18 | Supplier site identifier. Validated against POZ_SUPPLIER_SITES_ALL.VENDOR_SITE_ID. | ||
| VENDOR_TAXPAYER_ID | NUMBER | 18 | Supplier site unique taxpayer identifier originally captured in the fiscal document. Used for deriving supplier id and supplier site id. | ||
| INVOICE_AMOUNT | NUMBER | Invoice amount in transaction currency. Should be positive for standard and prepayment invoices. Should be negative for credit memos. | |||
| INVOICE_CURRENCY_CODE | VARCHAR2 | 15 | Currency of invoice. Use the Manage Currencies task to identify valid values. Use the three character ISO currency code. Example: US Dollars is USD. | ||
| EXCHANGE_RATE | NUMBER | Exchange rate used for foreign currency invoices. User entered conversion rate. Not validated. | |||
| EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Exchange rate type for foreign currency invoices. Use the Manage Conversion Rate Types task to identify valid values. Validated against GL_DAILY_CONVERSION_TYPES.CONVERSION_TYPE. | ||
| EXCHANGE_DATE | DATE | Date exchange rate is effective. Usually the accounting date of the transaction. | |||
| SOURCE | VARCHAR2 | 80 | Feeder system from which invoice is imported. Use the Manage Payables Lookups task, lookup type SOURCE to identify valid values. | ||
| GROUP_ID | VARCHAR2 | 80 | Value used to select invoices for importing. Free text field. Not validated. | ||
| GOODS_RECEIVED_DATE | DATE | Date when goods on the invoice were received. Required if the terms date basis is Goods Received. | |||
| INVOICE_RECEIVED_DATE | DATE | Date when the invoice was received. Also known as terms date. Required if the terms date basis is Invoice Received Date. | |||
| GL_DATE | DATE | Default accounting date for invoice distributions. The date must be in an open or future open accounting period. | |||
| ORG_ID | NUMBER | 18 | Indicates the identifier of the business unit associated to the row. | ||
| SHIP_TO_LOCATION | VARCHAR2 | 40 | Ship to location for purchase order matching. | ||
| LEGAL_ENTITY_ID | NUMBER | 18 | Unique identifier of the legal entity. | ||
| EXTERNAL_DOC_REF | VARCHAR2 | 240 | Internal fiscal document reference number. | ||
| APPLICATION_ID | NUMBER | 18 | For Oracle Fusion applications interfacing to Oracle Fusion Payables. | ||
| IMPORT_DOCUMENT_NUMBER | VARCHAR2 | 50 | Customer assigned document number. | ||
| IMPORT_DOCUMENT_DATE | DATE | Customer assigned date during import of invoice. | |||
| TAXATION_COUNTRY | VARCHAR2 | 30 | Sets the context for tax drivers such as Product Classification Code. If no value is entered, it will display the legal entity country by default. | ||
| CALC_TAX_DURING_IMPORT_FLAG | VARCHAR2 | 1 | Indicates whether tax should be calculated for the invoice during import. Valid values: Y,N, NULL. | ||
| ADD_TAX_TO_INV_AMT_FLAG | VARCHAR2 | 1 | Indicates whether the invoice amount should be grossed up by the calculated tax. Valid values: Y, N, NULL. | ||
| INVOICE_IMPORT_STATUS | VARCHAR2 | 1 | Interface status after invoice import program processing. Possible values are: NULL, (I)gnored, (E)rrored or (S)ucceeded. | ||
| 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. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CMF_AP_INVOICES_GT_N1 | Non Unique | REQUEST_ID |
| CMF_AP_INVOICES_GT_N2 | Non Unique | FISCAL_DOC_HEADER_ID |
| CMF_AP_INVOICES_GT_U1 | Unique | INVOICE_ID |