CMR_I_CONSIGNED_PO_PRICE_DTLS
Interface table to hold consigned purchase order price history information. This information will be used to perform accrual accounting and calculate acquisition costs. Only approved consigned purchase order prices changes need to be interfaced into this table.
Details
-
Schema: FUSION
-
Object owner: CMR
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
CMR_I_CONSIGNED_PO_PRICE_PK |
EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID, EFFECTIVE_DATE, TRANSFER_TO_OWNED_TXN_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 60 | Yes | Identifier of the source system that owns the purchase order entity | |
| EXTERNAL_SYSTEM_REF_ID | VARCHAR2 | 30 | Yes | Identifier of the purchase order entity that determines the price in the source system. | |
| EFFECTIVE_DATE | TIMESTAMP | Yes | Date of effectivity of the consigned PO price. | ||
| TRANSFER_TO_OWNED_TXN_ID | NUMBER | 18 | Yes | Inventory transfer to owned transaction identifier with positive quantity to indicate quantity is moved inventory from consigned | |
| REFERENCE_IDENTIFIER_LEVEL | VARCHAR2 | 20 | Indicates the level of the purchase order entity identified by the EXTERNAL_SYSTEM_REF_ID. Valid values are 'LINE', 'SCHEDULE', 'DISTRIBUTION'. Only 'LINE' is currently supported and it has to match the corresponding PO_LINE_ID in CMR_I_PURCHASE_ORDER_DTLS. | ||
| TAX_EXCLUSIVE_PRICE | NUMBER | PO line price exclusive of all taxes | |||
| PRICE | NUMBER | Transfer owned price with inclusive of taxes | |||
| NONRECOVERABLE_EXCLUSIVE_TAX | NUMBER | Non recoverable exclusive tax (per unit) amount | |||
| NONRECOVERABLE_INCLUSIVE_TAX | NUMBER | Non recoverable inclusive tax (per unit) amount. | |||
| PROCESSING_STATUS | VARCHAR2 | 20 | Used by the costing preprocessors to indicate the processing status of the interface record. The records in status 'ERROR' will remain in the interface until the underlying issue is fixed. The corresponding error codes will be in the table CMR_PROCESS_ERRORS. | ||
| 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 | Tablespace | Columns |
|---|---|---|---|
| CMR_I_CONS_PO_PRICE_DTLS_U1 | Unique | FUSION_TS_TX_DATA | EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID, EFFECTIVE_DATE, TRANSFER_TO_OWNED_TXN_ID |