Payment Application Proposal #1293

Other table in Microsoft Dynamics 365 Business Central. 33 fields, 0 records in Cronus demo.

Fields

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Bank Account No., Statement No., Statement Line No., Statement Type, Account Type, Account No., Applies-to Entry No..

All fields (33)

Payment Application Proposal — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Bank Account No. PK	Code	Normal	→ Bank Account #270
2	Statement No. PK	Code	Normal	→ Bank Acc. Reconciliation #273
3	Statement Line No. PK	Integer	Normal
20	Statement Type PK	Option	Normal
21	Account Type PK	Option	Normal
22	Account No. PK	Code	Normal
23	Applies-to Entry No. PK	Integer	Normal
24	Applied Amount	Decimal	Normal
25	Applied	Boolean	Normal
29	Applied Pmt. Discount	Decimal	Normal
30	Quality	Integer	Normal
31	Posting Date	Date	Normal
32	Document Type	Option	Normal
33	Document No.	Code	Normal
34	Description	Text	Normal
35	Currency Code	Code	Normal	→ Currency #4
36	Due Date	Date	Normal
37	External Document No.	Code	Normal
50	Match Confidence	Option	Normal
51	Pmt. Disc. Due Date	Date	Normal
52	Remaining Pmt. Disc. Possible	Decimal	Normal
53	Pmt. Disc. Tolerance Date	Date	Normal
60	Applied Amt. Incl. Discount	Decimal	Normal
61	Remaining Amount	Decimal	Normal
62	Remaining Amt. Incl. Discount	Decimal	Normal
63	Type	Option	Normal
100	Sorting Order	Integer	Normal
101	Stmt To Rem. Amount Difference	Decimal	Normal
2000000000	System ID	GUID	Normal
2000000001	Created At	DateTime	Normal
2000000002	Created By	GUID	Normal
2000000003	Modified At	DateTime	Normal
2000000004	Modified By	GUID	Normal

Related tables (4)

Tables referenced by fields on the Payment Application Proposal table through TableRelation properties.

Bank Account

#270 · Other · via Bank Account No.

Bank Acc. Reconciliation

#273 · Other · via Statement No.

Currency

#4 · General Ledger · via Currency Code