Objects/Tables/Table 1293 Payment Application Proposal
Table 1293 Payment Application Proposal in 24
Jonas Paprotka, Base Application 24.5.23489.36097, checked
- App
- Base Application
- Namespace
- Microsoft.Bank.Reconciliation
Fields, 28Keys, 4Procedures, 10Events, 1
Versions171819202122232425262728latest
Source29
Fields, 28
| Id | Name | Type | Obsolete |
|---|
| 1 | Bank Account No. | Code[20] | - |
| 2 | Statement No. | Code[20] | - |
| 3 | Statement Line No. | Integer | - |
| 20 | Statement Type | Enum Bank Acc. Rec. Stmt. Type | - |
| 21 | Account Type | Enum Gen. Journal Account Type | - |
| 22 | Account No. | Code[20] | - |
| 23 | Applies-to Entry No. | Integer | - |
| 24 | Applied Amount | Decimal | - |
| 25 | Applied | Boolean | - |
| 29 | Applied Pmt. Discount | Decimal | - |
| 30 | Quality | Integer | - |
| 31 | Posting Date | Date | - |
| 32 | Document Type | Enum Gen. Journal Document Type | - |
| 33 | Document No. | Code[20] | - |
| 34 | Description | Text[100] | - |
| 35 | Currency Code | Code[10] | - |
| 36 | Due Date | Date | - |
| 37 | External Document No. | Code[35] | - |
| 50 | Match Confidence | Enum Bank Rec. Match Confidence | - |
| 51 | Pmt. Disc. Due Date | Date | - |
| 52 | Remaining Pmt. Disc. Possible | Decimal | - |
| 53 | Pmt. Disc. Tolerance Date | Date | - |
| 60 | Applied Amt. Incl. Discount | Decimal | - |
| 61 | Remaining Amount | Decimal | - |
| 62 | Remaining Amt. Incl. Discount | Decimal | - |
| 63 | Type | Option | - |
| 100 | Sorting Order | Integer | - |
| 101 | Stmt To Rem. Amount Difference | Decimal | - |
Keys, 4
| Name | Fields | Obsolete |
|---|
| Key1, clustered | Statement Type, Bank Account No., Statement No., Statement Line No., Account Type, Account No., Applies-to Entry No. | - |
| Key2 | Applied, Quality | - |
| Key3 | Sorting Order | - |
| Key4 | Applied, Account Type, Account No., Type | - |
Procedures, 10
| Name | Parameters | Returns | Access | Obsolete |
|---|
| GetAppliedPaymentEntry | (var Record Applied Payment Entry) | Boolean | public | - |
| TransferFromBankAccReconLine | (Record Bank Acc. Reconciliation Line) | | public | - |
| CreateFromAppliedPaymentEntry | (Record Applied Payment Entry) | | public | - |
| CreateFromBankStmtMacthingBuffer | (Record Bank Statement Matching Buffer, Record Bank Acc. Reconciliation Line, Record Bank Account) | | public | - |
| GetRemainingAmountAfterPostingValue | () | Decimal | public | - |
| RemoveApplications | () | | public | - |
| AccountNameDrillDown | () | | public | - |
| GetAccountName | () | Text | public | - |
| AppliesToEntryNoDrillDown | () | | public | - |
| UpdateDefaultCalculatedFields | (var Record Bank Account, Integer) | | public | - |
Events, 1
| Kind | Name | Parameters | Obsolete |
|---|
| Integration event | OnAfterCreateFromBankStmtMacthingBuffer | (var Record Payment Application Proposal, Record Bank Statement Matching Buffer, Record Bank Acc. Reconciliation Line, Record Bank Account) | - |