MGCLatticeSetBasedBankStatementLineEntity
Imports bank statement lines (advanced bank reconciliation) in bulk with set-based processing. Lines are added to an existing open bank statement identified by bank account and statement ID; the statement's number of entries and net amount are recalculated.
- Primary key:
BankAccountId,StatementId,LineNumber
Fields
| Name | Type | Mandatory | Description |
|---|---|---|---|
BankAccountId | CompanyBankAccountId | Yes | |
StatementId | BankStatementId | Yes | |
LineNumber | LineNum | Yes | |
BookingDate | BankStatementBookingDate | No | |
DebitAmount | AmountCur | No | |
CreditAmount | AmountCur | No | |
LineStatus | BankStatementLineStatus | No | |
ReversalIndicator | NoYesId | No | |
EntryReference | BankStmtISOMax500Text | No | |
AccountServicerReference | BankStmtISOMax500Text | No | |
ReferenceNumber | BankStmtISOMax500Text | No | |
BankDocumentNumber | BankStatementIdentificationText | No | |
BankTransactionCode | BankStatementIdentificationText | No | |
Description | BankStmtISOMax500Text | No | |
CreditorReference | BankStmtCreditorReferenceInformation | No | |
CounterpartyName | BankStatementNameText | No | |
CounterpartyId | BankStatementIdentificationText | No | |
CounterpartyBankAccount | BankStatementIdentificationText | No | |
CounterpartyBankName | BankStatementNameText | No | |
CounterCurrencyCode | BankStmtISOCurrencyCode | No | |
CounterCurrencyAmount | AmountCur | No | |
CounterExchangeRate | ExchRate | No |
Mappings
| Entity field | Data source | Field |
|---|---|---|
BankAccountId | BankStmtISOAccountStatement | BankAccountTable |
StatementId | BankStmtISOAccountStatement | Identification |
BookingDate | BankStmtISOReportEntry | BookingDateTime |
LineStatus | BankStmtISOReportEntry | BankStatementLineStatus |
ReversalIndicator | BankStmtISOReportEntry | ReversalIndicator |
EntryReference | BankStmtISOReportEntry | EntryReference |
AccountServicerReference | BankStmtISOReportEntry | AccountServicerReference |
ReferenceNumber | BankStmtISOReportEntry | ReferenceNumber |
BankDocumentNumber | BankStmtISOReportEntry | BankDocumentNumber |
BankTransactionCode | BankStmtISOReportEntry | ProprietaryBankTransactionCode |
Description | BankStmtISOReportEntry | AdditionalEntryInformation |
CreditorReference | BankStmtISOReportEntry | CreditorReferenceInformation |
CounterpartyName | BankStmtISOPartyIdentification | Name |
CounterpartyId | BankStmtISOPartyIdentification | PartyIdOrganisationGenericOrgId |
CounterpartyBankAccount | BankStmtISOReportEntry | RelatedBankAccount |
CounterpartyBankName | BankStmtISOReportEntry | RelatedBankName |
CounterCurrencyCode | BankStmtISOReportEntry | BankStatementCounterCurrency |
CounterCurrencyAmount | BankStmtISOReportEntry | BankStatementCounterCurrencyAmount |
CounterExchangeRate | BankStmtISOReportEntry | BankStatementCounterExchangeRate |