Bank Statement Headers
The bank statement headers view object contains information related to bank statement headers, such as bank account name, statement from date, statement to date, reconciliation status, and so on.
Data store key : FscmTopModelAM.FinExtractAM.CeBiccExtractAM.BankStatementHeaderExtractPVO
Primary Keys : BankStatementHeaderStatementHeaderId
Initial Extract Date : BankStatementHeaderCreationDate
Incremental Extract Date : BankStatementHeaderLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| BankStatementHeaderAttribute1 | A segment of the Bank Statement Headers descriptive flexfield. |
| BankStatementHeaderAttribute10 | A segment of the Bank Statement Headers descriptive flexfield. |
| BankStatementHeaderAttribute11 | A segment of the Bank Statement Headers descriptive flexfield. |
| BankStatementHeaderAttribute12 | A segment of the Bank Statement Headers descriptive flexfield. |
| BankStatementHeaderAttribute13 | A segment of the Bank Statement Headers descriptive flexfield. |
| BankStatementHeaderAttribute14 | A segment of the Bank Statement Headers descriptive flexfield. |
| BankStatementHeaderAttribute15 | A segment of the Bank Statement Headers descriptive flexfield. |
| BankStatementHeaderAttribute2 | A segment of the Bank Statement Headers descriptive flexfield. |
| BankStatementHeaderAttribute3 | A segment of the Bank Statement Headers descriptive flexfield. |
| BankStatementHeaderAttribute4 | A segment of the Bank Statement Headers descriptive flexfield. |
| BankStatementHeaderAttribute5 | A segment of the Bank Statement Headers descriptive flexfield. |
| BankStatementHeaderAttribute6 | A segment of the Bank Statement Headers descriptive flexfield. |
| BankStatementHeaderAttribute7 | A segment of the Bank Statement Headers descriptive flexfield. |
| BankStatementHeaderAttribute8 | A segment of the Bank Statement Headers descriptive flexfield. |
| BankStatementHeaderAttribute9 | A segment of the Bank Statement Headers descriptive flexfield. |
| BankStatementHeaderAttributeCategory | The descriptive flexfield context name for the Bank Statement Headers descriptive flexfield. |
| BankStatementHeaderAutorecProcessCode | The status of the automatic reconciliation program completion. A list of accepted values is defined in the lookup type AUTO_REC_PROCESS_CODE. |
| BankStatementHeaderAutorecProcessId | The unique identifier of the automatic reconciliation process. This is a foreign key to the REQUEST_HISTORY table. |
| BankStatementHeaderBalanceCheck | The amount difference between the opening balance plus all activities compared to the closing balance reported on the bank statement. If the amount does not equal zero there is an issue with the bank statement and needs to be investigated. |
| BankStatementHeaderBankAccountId | The unique identifier of the bank account. This is a foreign key to the CE_BANK_ACCOUNTS table. |
| BankStatementHeaderCreatedBy | The user who created the bank statement header. |
| BankStatementHeaderCreationDate | The date and time when the bank statement header was created. |
| BankStatementHeaderCurrencyCode | The currency of the bank statement. This is a foreign key to the FND_CURRENCIES table. |
| BankStatementHeaderElectronicSeqNum | The sequential number of the statement, assigned by the account servicer. It is increased incrementally for each statement sent electronically. |
| BankStatementHeaderGlobalAttribute1 | A segment of the Bank Statement Headers global descriptive flexfield. |
| BankStatementHeaderGlobalAttribute10 | A segment of the Bank Statement Headers global descriptive flexfield. |
| BankStatementHeaderGlobalAttribute11 | A segment of the Bank Statement Headers global descriptive flexfield. |
| BankStatementHeaderGlobalAttribute12 | A segment of the Bank Statement Headers global descriptive flexfield. |
| BankStatementHeaderGlobalAttribute13 | A segment of the Bank Statement Headers global descriptive flexfield. |
| BankStatementHeaderGlobalAttribute14 | A segment of the Bank Statement Headers global descriptive flexfield. |
| BankStatementHeaderGlobalAttribute15 | A segment of the Bank Statement Headers global descriptive flexfield. |
| BankStatementHeaderGlobalAttribute2 | A segment of the Bank Statement Headers global descriptive flexfield. |
| BankStatementHeaderGlobalAttribute3 | A segment of the Bank Statement Headers global descriptive flexfield. |
| BankStatementHeaderGlobalAttribute4 | A segment of the Bank Statement Headers global descriptive flexfield. |
| BankStatementHeaderGlobalAttribute5 | A segment of the Bank Statement Headers global descriptive flexfield. |
| BankStatementHeaderGlobalAttribute6 | A segment of the Bank Statement Headers global descriptive flexfield. |
| BankStatementHeaderGlobalAttribute7 | A segment of the Bank Statement Headers global descriptive flexfield. |
| BankStatementHeaderGlobalAttribute8 | A segment of the Bank Statement Headers global descriptive flexfield. |
| BankStatementHeaderGlobalAttribute9 | A segment of the Bank Statement Headers global descriptive flexfield. |
| BankStatementHeaderGlobalAttributeCategory | The global descriptive flexfield context name for the Bank Statement Headers global descriptive flexfield. |
| BankStatementHeaderInboundFileId | The identifier of the file from where the statement is imported. This is a foreign key to the IBY_INBOUND_FILE table. |
| BankStatementHeaderIntradayFlag | Indicates whether the bank statement is an intraday bank statement. A list of accepted values is defined in the lookup type YES_NO. |
| BankStatementHeaderLastUpdateDate | The date and time when the bank statement header was last updated. |
| BankStatementHeaderLastUpdateLogin | The session login associated with the user who last updated the bank statement header. |
| BankStatementHeaderLastUpdatedBy | The user who last updated the bank statement header. |
| BankStatementHeaderLegalSeqNum | The legal sequential number of the bank statement, assigned by the account servicer. |
| BankStatementHeaderObjectVersionNumber | The number of times the bank statement header row has been updated. |
| BankStatementHeaderReconStatusCode | The reconciliation status of the bank statement. A list of accepted values is defined in the lookup type HDR_RECON_STATUS. |
| BankStatementHeaderStatementDate | The date when the bank statement was created. It appears on the bank statement. |
| BankStatementHeaderStatementEntryType | Indicates whether the bank statement is manually entered or electronically imported. A list of accepted values is defined in the lookup type STMT_ENTRY_TYPE. |
| BankStatementHeaderStatementHeaderId | The unique identifier of the bank statement. This is the primary key of the Bank Statement Headers view object. |
| BankStatementHeaderStatementNumber | The number of the bank statement. |
| BankStatementHeaderStmtFromDate | The date that the bank statement period starts. |
| BankStatementHeaderStmtToDate | The date that the bank statement period ends. |