Prepayment Inv. Line Buffer #461

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

The Prepayment Inv. Line Buffer table (ID 461) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 36 fields, with a primary key of G/L Account No., Line No., Project No., Tax Area Code, Tax Liable, Tax Group Code, Invoice Rounding, Adjustment, Dimension Set ID. Use the reference below to explore every field, data type, and table relation.

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: G/L Account No., Line No., Project No., Tax Area Code, Tax Liable, Tax Group Code, Invoice Rounding, Adjustment, Dimension Set ID.

All fields (36)

Prepayment Inv. Line Buffer — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	G/L Account No. PK	Code	Normal	→ G/L Account #15
2	Line No. PK	Integer	Normal
3	Amount	Decimal	Normal
4	Description	Text	Normal
5	Gen. Bus. Posting Group	Code	Normal	→ Gen. Business Posting Group #250
6	Gen. Prod. Posting Group	Code	Normal	→ Gen. Product Posting Group #251
7	VAT Bus. Posting Group	Code	Normal	→ VAT Business Posting Group #323
8	VAT Prod. Posting Group	Code	Normal	→ VAT Product Posting Group #324
9	VAT Amount	Decimal	Normal
10	VAT Calculation Type	Option	Normal
11	VAT Base Amount	Decimal	Normal
12	Amount (ACY)	Decimal	Normal
13	VAT Amount (ACY)	Decimal	Normal
14	VAT Base Amount (ACY)	Decimal	Normal
15	VAT Difference	Decimal	Normal
16	VAT %	Decimal	Normal
17	VAT Identifier	Code	Normal
19	Global Dimension 1 Code	Code	Normal	→ Dimension Value #349
20	Global Dimension 2 Code	Code	Normal	→ Dimension Value #349
21	Project No. PK	Code	Normal	→ Job #167
22	Amount Incl. VAT	Decimal	Normal
24	Tax Area Code PK	Code	Normal	→ Tax Area #318
25	Tax Liable PK	Boolean	Normal
26	Tax Group Code PK	Code	Normal	→ Tax Group #321
27	Invoice Rounding PK	Boolean	Normal
28	Adjustment PK	Boolean	Normal
29	VAT Base Before Pmt. Disc.	Decimal	Normal
30	Original Pmt. Disc. Possible	Decimal	Normal
31	Location Code	Code	Normal
480	Dimension Set ID PK	Integer	Normal	→ Dimension Set Entry #480
1001	Project Task No.	Code	Normal	→ Job Task #1001
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