Bank Statement Lines
The bank statement lines view object contains information related to bank statement lines, such as line number, booking date, transaction code, transaction type, reconciliation reference, transaction amount, transaction identification information, and so on. It includes reconciled and unreconciled bank statements lines.
Data store key : FscmTopModelAM.FinExtractAM.CeBiccExtractAM.BankStatementLinesExtractPVO
Primary Keys : BankStatementLinesStatementLineId
Initial Extract Date : BankStatementLinesCreationDate
Incremental Extract Date : BankStatementLinesLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| BBankStatementLinesReversalIndFlag | Indicates whether the entry is the result of a reversal operation. A list of accepted values is defined in the lookup type YES_NO. |
| BankStatementLinesAccntServicerRef | The account servicing institution's reference for the entry. |
| BankStatementLinesAddendaTxt | The additional information on the entry details. |
| BankStatementLinesAmount | The amount of the bank statement line. |
| BankStatementLinesAttribute1 | A segment of the Bank Statement Lines descriptive flexfields. |
| BankStatementLinesAttribute10 | A segment of the Bank Statement Lines descriptive flexfields. |
| BankStatementLinesAttribute11 | A segment of the Bank Statement Lines descriptive flexfields. |
| BankStatementLinesAttribute12 | A segment of the Bank Statement Lines descriptive flexfields. |
| BankStatementLinesAttribute13 | A segment of the Bank Statement Lines descriptive flexfields. |
| BankStatementLinesAttribute14 | A segment of the Bank Statement Lines descriptive flexfields. |
| BankStatementLinesAttribute15 | A segment of the Bank Statement Lines descriptive flexfields. |
| BankStatementLinesAttribute2 | A segment of the Bank Statement Lines descriptive flexfields. |
| BankStatementLinesAttribute3 | A segment of the Bank Statement Lines descriptive flexfields. |
| BankStatementLinesAttribute4 | A segment of the Bank Statement Lines descriptive flexfields. |
| BankStatementLinesAttribute5 | A segment of the Bank Statement Lines descriptive flexfields. |
| BankStatementLinesAttribute6 | A segment of the Bank Statement Lines descriptive flexfields. |
| BankStatementLinesAttribute7 | A segment of the Bank Statement Lines descriptive flexfields. |
| BankStatementLinesAttribute8 | A segment of the Bank Statement Lines descriptive flexfields. |
| BankStatementLinesAttribute9 | A segment of the Bank Statement Lines descriptive flexfields. |
| BankStatementLinesAttributeCategory | The descriptive flexfields context name for the Bank Statement Lines descriptive flexfields. |
| BankStatementLinesBookingDate | The date and time when an entry is posted to an account on the account servicer's books. |
| BankStatementLinesCheckNumber | The check number on the bank statement line. |
| BankStatementLinesClearingSystemRef | The unique and unambiguous identifier for a payment instruction, assigned by the clearing system. |
| BankStatementLinesCommWaiverIndFlag | Indicates whether the transaction is exempted from commission. A list of accepted values is defined in the lookup type YES_NO. |
| BankStatementLinesContractIdentification | The unique and unambiguous identifier of the foreign exchange contract. |
| BankStatementLinesCreatedBy | The user who created the bank statement line. |
| BankStatementLinesCreationDate | The date and time when the bank statement line was created. |
| BankStatementLinesCustomerReference | The customer reference text in the bank statement line. |
| BankStatementLinesEndToEndId | The unique identification assigned by the initiating party to unambiguously identify the transaction. This identification is passed on, unchanged, throughout the entire end-to-end chain. |
| BankStatementLinesExceptionFlag | Indicates whether a reconciliation exception is found for the statement line. A list of accepted values is defined in the lookup type YES_NO. |
| BankStatementLinesExchangeRate | The exchange rate of the bank statement line. |
| BankStatementLinesExchangeRateDate | The date and time at which an exchange rate is quoted. |
| BankStatementLinesExchangeRateType | The exchange rate type used in foreign exchange. |
| BankStatementLinesExternalTransactionId | The unique identifier of the external cash transaction created from a bank statement line. This is a foreign key of the bank statement transaction created in the CE_EXTERNAL_TRANSACTIONS table. |
| BankStatementLinesFlowIndicator | Indicates whether a debit or credit is entered on the bank statement line. A list of accepted values is defined in the lookup type FLOW_INDICATOR. |
| BankStatementLinesGlobalAttribute1 | A segment of the Bank Statement Lines global descriptive flexfields. |
| BankStatementLinesGlobalAttribute10 | A segment of the Bank Statement Lines global descriptive flexfields. |
| BankStatementLinesGlobalAttribute11 | A segment of the Bank Statement Lines global descriptive flexfields. |
| BankStatementLinesGlobalAttribute12 | A segment of the Bank Statement Lines global descriptive flexfields. |
| BankStatementLinesGlobalAttribute13 | A segment of the Bank Statement Lines global descriptive flexfields. |
| BankStatementLinesGlobalAttribute14 | A segment of the Bank Statement Lines global descriptive flexfields. |
| BankStatementLinesGlobalAttribute15 | A segment of the Bank Statement Lines global descriptive flexfields. |
| BankStatementLinesGlobalAttribute2 | A segment of the Bank Statement Lines global descriptive flexfields. |
| BankStatementLinesGlobalAttribute3 | A segment of the Bank Statement Lines global descriptive flexfields. |
| BankStatementLinesGlobalAttribute4 | A segment of the Bank Statement Lines global descriptive flexfields. |
| BankStatementLinesGlobalAttribute5 | A segment of the Bank Statement Lines global descriptive flexfields. |
| BankStatementLinesGlobalAttribute6 | A segment of the Bank Statement Lines global descriptive flexfields. |
| BankStatementLinesGlobalAttribute7 | A segment of the Bank Statement Lines global descriptive flexfields. |
| BankStatementLinesGlobalAttribute8 | A segment of the Bank Statement Lines global descriptive flexfields. |
| BankStatementLinesGlobalAttribute9 | A segment of the Bank Statement Lines global descriptive flexfields. |
| BankStatementLinesGlobalAttributeCategory | The global descriptive flexfields context name for the Bank Statement Lines global descriptive flexfields. |
| BankStatementLinesInstructionIdentification | The unique identification as assigned by an instructing party for an instructed party to unambiguously identify the instruction. It is a point to point reference. |
| BankStatementLinesLastUpdateDate | The date and time when the bank statement line was last updated. |
| BankStatementLinesLastUpdateLogin | The session login associated with the user who last updated the bank statement line. |
| BankStatementLinesLastUpdatedBy | The user who last updated the bank statement line. |
| BankStatementLinesLineNumber | A number assigned to a bank statement line. |
| BankStatementLinesObjectVersionNumber | The number of times the bank statement line row has been updated. |
| BankStatementLinesOrigBankAccountId | The identifier of the supplier or customer bank account. |
| BankStatementLinesReconHistoryId | The unique identifier of the last reconciliation performed for the bank statement line. This is a foreign key to the CE_RECON_HISTORY table. |
| BankStatementLinesReconReference | The reconciliation reference of the bank statement line. It is an identifier used for reconciliation matching. |
| BankStatementLinesReconStatus | Indicates whether a statement line is reconciled or not. A list of accepted values is defined in the lookup type CE_RECON_STATUS. |
| BankStatementLinesServicerStatus | The status of an entry on the books of an account servicer. |
| BankStatementLinesStatementHeaderId | The unique identifier of the bank statement header. This is a foreign key to the CE_STATEMENT_HEADERS table. |
| BankStatementLinesStatementLineId | The unique identifier of the bank statement line. This is the primary key of the Bank Statement Lines view object. |
| BankStatementLinesTransactionId | The unique identification assigned by the first instructing agent to unambiguously identify the transaction and passed on, unchanged, throughout the entire interbank chain. |
| BankStatementLinesTrxAmount | The amount of the underlying foreign currency transaction. |
| BankStatementLinesTrxCodeId | The unique identifier of the transaction code associated to the bank statement line. This is a foreign key to the CE_TRANSACTION_CODES table. |
| BankStatementLinesTrxCurrCode | The original transaction currency of the bank statement line. This is a foreign key to the FND_CURRENCIES table. |
| BankStatementLinesTrxType | The transaction type of the bank statement line. A list of accepted values is defined in the lookup type CE_TRX_TYPE. |
| BankStatementLinesValueDate | The date assets become available to the account owner in a credit entry, or cease to be available to the account owner in a debit entry. |