Table "Posted Payment Recon. Line"
Stores completed payment reconciliation line details after posting. Maintains historical record of reconciled transactions for audit and reporting purposes.
Properties
| Name | Value |
|---|---|
| Caption | Posted Payment Recon. Line |
| PasteIsValid | False |
| DataClassification | CustomerContent |
Fields
| Name | Type | Description |
|---|---|---|
| "Bank Account No." | Code[20] | Bank account identifier for the reconciliation line. |
| "Statement No." | Code[20] | Statement number identifying the posted reconciliation. |
| "Statement Line No." | Integer | Sequential line number within the statement. |
| "Document No." | Code[20] | Document number assigned during reconciliation processing. |
| "Transaction Date" | Date | Transaction date from the bank statement. |
| Description | Text[100] | Transaction description from the bank statement. |
| "Statement Amount" | Decimal | Amount from the bank statement in bank account currency. |
| Difference | Decimal | Difference between statement amount and applied amount. |
| "Applied Amount" | Decimal | Total amount applied to ledger entries during reconciliation. |
| Type | Option | Type of transaction processed during reconciliation. |
| "Applied Entries" | Integer | Number of ledger entries applied to this reconciliation line. |
| "Value Date" | Date | Value date for transaction processing and reporting. |
| "Check No." | Code[20] | Check number for check-based transactions. |
| "Related-Party Name" | Text[250] | Name of the related party from the bank statement. |
| "Additional Transaction Info" | Text[100] | Additional transaction information from the bank statement. |
| "Data Exch. Entry No." | Integer | Reference to data exchange entry for imported transactions. |
| "Data Exch. Line No." | Integer | Line number in the data exchange for imported transactions. |
| "Account Type" | Enum Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Account Type" | Account type for transaction posting. |
| "Account No." | Code[20] | Account number for transaction posting. |
| "Applied Document No." | Text[250] | Contains the document numbers of all applied entries, concatenated as text. |
| "Applied Entry No." | Text[250] | Contains the entry numbers of all applied entries, concatenated as text. |
| "Transaction ID" | Text[250] | Specifies the unique transaction identifier from the bank statement. |
| Reconciled | Boolean | Indicates whether this payment reconciliation line has been reconciled. |
| SystemId | Guid | |
| SystemCreatedAt | DateTime | |
| SystemCreatedBy | Guid | |
| SystemModifiedAt | DateTime | |
| SystemModifiedBy | Guid | |
| SystemCreatedByUserName | Text[50] | |
| SystemCreatedByFullName | Text[80] | |
| SystemModifiedByUserName | Text[50] | |
| SystemModifiedByFullName | Text[80] | |
| SystemRowVersion | BigInteger |