Sales Invoice Line #113

Posted Sales table in Microsoft Dynamics 365 Business Central. 125 fields, 512 records in Cronus demo.

125

Fields

512

Records

Primary key

FlowFields

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 (125)

Sales Invoice Line — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
2	Sell-to Customer No.	Code	Normal	→ Customer #18
3	Document No. PK	Code	Normal	→ Sales Invoice Header #112
4	Line No. PK	Integer	Normal
5	Type	Option	Normal
6	No.	Code	Normal
7	Location Code	Code	Normal	→ Location #14
8	Posting Group	Code	Normal
10	Shipment Date	Date	Normal
11	Description	Text	Normal
12	Description 2	Text	Normal
13	Unit of Measure	Text	Normal
15	Quantity	Decimal	Normal
22	Unit Price	Decimal	Normal
23	Unit Cost (LCY)	Decimal	Normal
25	VAT %	Decimal	Normal
27	Line Discount %	Decimal	Normal
28	Line Discount Amount	Decimal	Normal
29	Amount	Decimal	Normal
30	Amount Including VAT	Decimal	Normal
32	Allow Invoice Disc.	Boolean	Normal
34	Gross Weight	Decimal	Normal
35	Net Weight	Decimal	Normal
36	Units per Parcel	Decimal	Normal
37	Unit Volume	Decimal	Normal
38	Appl.-to Item Entry	Integer	Normal
40	Shortcut Dimension 1 Code	Code	Normal	→ Dimension Value #349
41	Shortcut Dimension 2 Code	Code	Normal	→ Dimension Value #349
42	Customer Price Group	Code	Normal	→ Customer Price Group #6
45	Project No.	Code	Normal	→ Job #167
52	Work Type Code	Code	Normal	→ Work Type #200
63	Shipment No.	Code	Normal
64	Shipment Line No.	Integer	Normal
65	Order No.	Code	Normal
66	Order Line No.	Integer	Normal
68	Bill-to Customer No.	Code	Normal	→ Customer #18
69	Inv. Discount Amount	Decimal	Normal
73	Drop Shipment	Boolean	Normal
74	Gen. Bus. Posting Group	Code	Normal	→ Gen. Business Posting Group #250
75	Gen. Prod. Posting Group	Code	Normal	→ Gen. Product Posting Group #251
77	VAT Calculation Type	Option	Normal
78	Transaction Type	Code	Normal	→ Transaction Type #258
79	Transport Method	Code	Normal	→ Transport Method #259
80	Attached to Line No.	Integer	Normal	→ Sales Invoice Line #113
81	Exit Point	Code	Normal	→ Entry/Exit Point #282
82	Area	Code	Normal	→ Area #284
83	Transaction Specification	Code	Normal	→ Transaction Specification #285
84	Tax Category	Code	Normal
85	Tax Area Code	Code	Normal	→ Tax Area #318
86	Tax Liable	Boolean	Normal
87	Tax Group Code	Code	Normal	→ Tax Group #321
88	VAT Clause Code	Code	Normal	→ VAT Clause #560
89	VAT Bus. Posting Group	Code	Normal	→ VAT Business Posting Group #323
90	VAT Prod. Posting Group	Code	Normal	→ VAT Product Posting Group #324
97	Blanket Order No.	Code	Normal	→ Sales Header #36
98	Blanket Order Line No.	Integer	Normal	→ Sales Line #37
99	VAT Base Amount	Decimal	Normal
100	Unit Cost	Decimal	Normal
101	System-Created Entry	Boolean	Normal
103	Line Amount	Decimal	Normal
104	VAT Difference	Decimal	Normal
106	VAT Identifier	Code	Normal
107	IC Partner Ref. Type	Option	Normal
108	IC Partner Reference	Code	Normal
123	Prepayment Line	Boolean	Normal
130	IC Partner Code	Code	Normal	→ IC Partner #413
131	Posting Date	Date	Normal
138	IC Item Reference No.	Code	Normal
145	Pmt. Discount Amount	Decimal	Normal
180	Line Discount Calculation	Option	Normal
480	Dimension Set ID	Integer	Normal	→ Dimension Set Entry #480
1001	Project Task No.	Code	Normal	→ Job Task #1001
1002	Project Contract Entry No.	Integer	Normal
1700	Deferral Code	Code	Normal	→ Deferral Template #1700
2678	Allocation Account No.	Code	Normal
2679	Allocation Sales Line SystemId	GUID	Normal
5402	Variant Code	Code	Normal
5403	Bin Code	Code	Normal	→ Bin #7354
5404	Qty. per Unit of Measure	Decimal	Normal
5407	Unit of Measure Code	Code	Normal
5415	Quantity (Base)	Decimal	Normal
5600	FA Posting Date	Date	Normal
5602	Depreciation Book Code	Code	Normal	→ Depreciation Book #5611
5605	Depr. until FA Posting Date	Boolean	Normal
5612	Duplicate in Depreciation Book	Code	Normal	→ Depreciation Book #5611
5613	Use Duplication List	Boolean	Normal
5700	Responsibility Center	Code	Normal	→ Responsibility Center #5714
5709	Item Category Code	Code	Normal
5710	Catalog	Boolean	Normal
5711	Purchasing Code	Code	Normal	→ Purchasing #5721
5725	Item Reference No.	Code	Normal
5726	Unit of Measure (Item Ref.)	Code	Normal
5727	Item Reference Type	Option	Normal
5728	Item Reference Type No.	Code	Normal
5811	Appl.-from Item Entry	Integer	Normal
6210	Sustainability Account No.	Code	Normal	→ Sustainability Account #6210
6211	Sustainability Account Name	Text	Normal
6212	Sustainability Account Category	Code	Normal	→ Sustain. Account Category #6211
6213	Sustainability Account Subcategory	Code	Normal	→ Sustain. Account Subcategory #6212
6214	CO2e per Unit	Decimal	Normal
6215	Total CO2e	Decimal	Normal
6217	EPR Fee per Unit	Decimal	Normal
6218	Total EPR Fee	Decimal	Normal
6250	EPR Reported	Boolean	Normal
6608	Return Reason Code	Code	Normal	→ Return Reason #6635
7000	Price Calculation Method	Option	Normal
7001	Allow Line Disc.	Boolean	Normal
7002	Customer Disc. Group	Code	Normal	→ Customer Discount Group #340
7004	Price description	Text	Normal
7012	Sell-to Customer Name ⚡ FLOW	Text	FlowField
8051	Subscription Contract No.	Code	Normal	→ Customer Subscription Contract #8052
8052	Subscription Contract Line No.	Integer	Normal	→ Cust. Sub. Contract Line #8062
8053	Recurring Billing from	Date	Normal
8054	Recurring Billing to	Date	Normal
8058	Discount	Boolean	Normal
10500	Reverse Charge Item	Boolean	Normal
10501	Reverse Charge	Decimal	Normal
10507	Reverse Charge Item	Boolean	Normal
10508	Reverse Charge	Decimal	Normal
30100	Shopify Order Line Id	BigInteger	Normal
30101	Shopify Order No.	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