Prepayment Inv. Line Buffer #461

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

36
Fields
0
Records
9
Primary key
0
FlowFields
14
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.FIELDTYPECLASSRELATION
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

Related tables (12)

Tables referenced by fields on the Prepayment Inv. Line Buffer table through TableRelation properties.

G/L Account
#15 · General Ledger · via G/L Account No.
Gen. Business Posting Group
#250 · Other · via Gen. Bus. Posting Group
Gen. Product Posting Group
#251 · Other · via Gen. Prod. Posting Group
VAT Business Posting Group
#323 · Other · via VAT Bus. Posting Group
VAT Product Posting Group
#324 · Other · via VAT Prod. Posting Group
Dimension Value
#349 · Dimensions · via Global Dimension 1 Code, Global Dimension 2 Code
Job
#167 · Other · via Project No.
Tax Area
#318 · Other · via Tax Area Code
Tax Group
#321 · Other · via Tax Group Code
Dimension Set Entry
#480 · Dimensions · via Dimension Set ID
Job Task
#1001 · Jobs · via Project Task No.