Costing Invoice to Expense Transactions
The Costing Invoice to Expense Transactions view object contains 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.
Data Store Key : FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CstInvoiceToExpTxnsExtractPVO
Primary Keys : CstInvoiceToExpTxnsPEOInvoiceToExpTxnId
Initial Extract Date : CstInvoiceToExpTxnsPEOCreationDate
Incremental Extract Date : CstInvoiceToExpTxnsPEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
Name | Description |
---|---|
CstInvoiceToExpTxnsPEOCmrPoDistributionId | Value that uniquely identifies the purchase order distribution. |
CstInvoiceToExpTxnsPEOCmrPoLineLocationId | Value that uniquely identifies the purchase order schedule. |
CstInvoiceToExpTxnsPEOCmrRcvTransactionId | Value that uniquely identifies the receiving transaction. |
CstInvoiceToExpTxnsPEOConsignedFlag | Value that identifies if the corresponding purchase order is a consigned purchase order. |
CstInvoiceToExpTxnsPEOCreatedBy | User who created the invoice to expense transaction. |
CstInvoiceToExpTxnsPEOCreationDate | Date and time when the invoice to expense transaction was created. |
CstInvoiceToExpTxnsPEOCurrencyCode | Value that identifies the currency of the transaction or cost. |
CstInvoiceToExpTxnsPEOCurrencyConversionDate | Date used to determine the exchange rates for currency conversion |
CstInvoiceToExpTxnsPEOCurrencyConversionRate | Optional user specified currency conversion rate. |
CstInvoiceToExpTxnsPEOCurrencyConversionType | Conversion type that should be used for currency conversion. |
CstInvoiceToExpTxnsPEOInventoryItemId | Value that uniquely identifies the item associated with the purchase order distribution. |
CstInvoiceToExpTxnsPEOInventoryOrgId | Value that uniquely identifies the inventory organization associated with the purchase order distribution. |
CstInvoiceToExpTxnsPEOInvoiceToExpAmt | Value that identifies the amount to be moved out of receiving inspection. |
CstInvoiceToExpTxnsPEOInvoiceToExpTxnId | Value that uniquely identifies the invoice to expense transaction. This is the primary key of the Costing Invoice to Expense Transactions view object. |
CstInvoiceToExpTxnsPEOLastUpdateDate | Date when the invoice to expense transaction row was last updated. |
CstInvoiceToExpTxnsPEOLastUpdateLogin | Session login associated with the user who last updated the invoice to expense transaction row. |
CstInvoiceToExpTxnsPEOLastUpdatedBy | User who last updated the invoice to expense transaction row. |
CstInvoiceToExpTxnsPEOPreprocessedFlag | Value that identifies if the record has been picked and expanded by book. |
CstInvoiceToExpTxnsPEOReverseInvoiceToExpTxnId | Value that identifies the original expense transaction being reversed. |
CstInvoiceToExpTxnsPEOTransactionFlowType | Value that identifies the transaction flow. A list of accepted values is defined in the lookup type ORA_CST_TRANSACTION_FLOW_TYPES. |
CstInvoiceToExpTxnsPEOTxnAccountDate | Date to be used for accounting this transaction. It's 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 transaction. |