Applied Payment Entry #1294

Other table in Microsoft Dynamics 365 Business Central. 23 fields, 6 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 (23)

Applied Payment Entry — 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
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
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 Applied Payment Entry 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