CST_INVOICE_TO_EXP_TXNS
This table holds the transactions created to expense the invoice balances where the net delivered quantity for the PO distribution (in case of match to PO invoices) or the PO distribution receipt combination (in case of match to receipt invoices) is zero.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
CST_INVOICE_TO_EXP_TXNS_PK |
INVOICE_TO_EXP_TXN_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
INVOICE_TO_EXP_TXN_ID | NUMBER | 18 | Yes | Unique identifier of the transaction | |
CMR_PO_DISTRIBUTION_ID | NUMBER | 18 | Purchase order distribution identifier | ||
CMR_PO_LINE_LOCATION_ID | NUMBER | 18 | Purchase Order Schedule identifier. | ||
CMR_RCV_TRANSACTION_ID | NUMBER | 18 | Receiving transaction identifier | ||
INVOICE_TO_EXP_AMT | NUMBER | The amount to be moved out of receiving inspection | |||
TXN_ACCOUNT_DATE | TIMESTAMP | Date to be used for accounting this transaction. It is picked up to be the date of the latest receipt that has caused the net delivered quantity to go to zero. For reversals, the date will be the txn_account_date of the original txn. | |||
INVENTORY_ORG_ID | NUMBER | 18 | Identifier of the inventory organization associated with the purchase order distribution. | ||
INVENTORY_ITEM_ID | NUMBER | 18 | Item associated with the Purchase Order Distribution | ||
REVERSE_INVOICE_TO_EXP_TXN_ID | NUMBER | 18 | The original expensing txn that is being reversed. | ||
CURRENCY_CODE | VARCHAR2 | 15 | Identifies the currency of the transaction / cost. | ||
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. | |||
TRANSACTION_FLOW_TYPE | NUMBER | 18 | Transaction Flow Identifier, 1 - Internal Drop Shipment, 2 - Global Procurement, 3 - Customer Drop Shipment, 4 - Intransit Interorg Transfer, 5 - Direct Interorg Transfer, 6 - Intraorg Transfer, 7 - Transfer Order Intransit Interorg Transfer, 8 - Transfer Order Direct Interorg Transfer, 9 - Transfer Order Intraorg Transfer, 10 - TIR/TIRR at ownership change in procuring org for consigned PO, 11 - TIRR of TO Return with Scrap or null for others. | ||
CONSIGNED_FLAG | VARCHAR2 | 1 | Indicates if the corresponding purchase order is a consigned PO. | ||
PREPROCESSED_FLAG | VARCHAR2 | 1 | Indicates if the record has been picked and expanded by book | ||
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_invoice_to_exp_acctg | cst_invoice_to_exp_txns | INVOICE_TO_EXP_TXN_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
CST_INVOICE_TO_EXP_TXNS_PK | Unique | FUSION_TS_TX_DATA | INVOICE_TO_EXP_TXN_ID |