BC14 Posted Sales Inv Line #46881

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

The BC14 Posted Sales Inv Line table (ID 46881) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 29 fields, with a primary key of Document No., Line No.. Use the reference below to explore every field, data type, and table relation.

29
Fields
0
Records
2
Primary key
0
FlowFields
2
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Document No., Line No..

All fields (29)

BC14 Posted Sales Inv Line — FIELDS
NO.FIELDTYPECLASSRELATION
1 Document No. PK Code Normal
2 Line No. PK Integer Normal
3 Type Option Normal
4 No. Code Normal
5 Description Text Normal
6 Description 2 Text Normal
10 Quantity Decimal Normal
11 Unit of Measure Code Code Normal
12 Qty. per Unit of Measure Decimal Normal
20 Unit Price Decimal Normal
21 Line Discount % Decimal Normal
22 Line Discount Amount Decimal Normal
23 Amount Decimal Normal
24 Amount including VAT Decimal Normal
30 Shortcut Dimension 1 Code Code Normal
31 Shortcut Dimension 2 Code Code Normal
40 VAT % Decimal Normal
41 VAT base amount Decimal Normal
50 Location Code Code Normal
60 Gen. Bus. Posting Group Code Normal
61 Gen. Prod. Posting Group Code Normal
62 VAT bus. posting group Code Normal
63 VAT prod. posting group Code Normal
70 Bin Code Code 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