CST_INV_TRANSACTION_DTLS
This table is used by the PreProcessor. This table is Costings inventory transactin details table that stores the lot, serial and grade information of the imported inventory transactions.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
CST_INV_TRANSACTION_DTLS_PK |
CST_INV_TRANSACTION_DTL_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
CST_INV_TRANSACTION_DTL_ID | NUMBER | 18 | Yes | Inventory transaction detail identifier within costing | |
CST_INV_TRANSACTION_ID | NUMBER | 18 | Yes | Inventory transaction identifier within costing that references costings inventory transaction table | |
LOT_NUMBER | VARCHAR2 | 80 | The lot number of the item | ||
PARENT_LOT_NUMBER | VARCHAR2 | 80 | Parent lot number, incase the new lot was derived due to a lot merge or split transaction. | ||
VENDOR_LOT_NUMBER | VARCHAR2 | 80 | The lot number at the Vendors location | ||
SERIAL_NUMBER | VARCHAR2 | 80 | The serial number of the item | ||
GRADE_CODE | VARCHAR2 | 150 | Grade of the Lot for a grade controlled Item | ||
TRANSACTION_QTY | NUMBER | Quantity in the transaction unit of measure as stamped in the header transaction. | |||
PRIMARY_QTY | NUMBER | Quantity in the items Primary unit of measure as stamped in the header transaction. | |||
SECONDARY_TRANSACTION_QTY | NUMBER | Quantity in the Items secondary unit of measure as stamped in the header transaction. | |||
TRANSFER_CST_INV_TXN_ID | NUMBER | 18 | Source inventory transaction detail, such as lot or serial, identifying the other leg of transfer transaction. This is populated only if the item is lot or serial controlled in both source and destination organizations. | ||
TRANSFER_CST_INV_TXN_DTL_ID | NUMBER | 18 | Source inventory transaction detail, such as lot or serial, identifying the other leg of transfer transaction. This is populated only if the item is lot or serial controlled in both source and destination organizations. | ||
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. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
CST_INV_TRANSACTION_DTLS | cst_inv_transactions | CST_INV_TRANSACTION_ID |
cst_transactions | cst_inv_transaction_dtls | CST_INV_TRANSACTION_DTL_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
CST_INV_TRANSACTION_DTLS_N1 | Non Unique | FUSION_TS_TX_DATA | CST_INV_TRANSACTION_ID |
CST_INV_TRANSACTION_DTLS_N2 | Non Unique | FUSION_TS_TX_DATA | TRANSFER_CST_INV_TXN_ID, TRANSFER_CST_INV_TXN_DTL_ID |
CST_INV_TRANSACTION_DTLS_U1 | Unique | FUSION_TS_TX_DATA | CST_INV_TRANSACTION_DTL_ID |