XPT / Schema / Sales Line

Sales Line #37

Sales Documents table in Microsoft Dynamics 365 Business Central. 223 fields, 80 records in Cronus demo.

223
Fields
80
Records
3
Primary key
17
FlowFields
48
Relations
Open in Data Explorer →

Primary key

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

All fields (223)

Sales Line — FIELDS
NO.FIELDTYPECLASSRELATION
1 Document Type PK Option Normal
2 Sell-to Customer No. Code Normal → Customer #18
3 Document No. PK Code Normal → Sales Header #36
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
16 Outstanding Quantity Decimal Normal
17 Qty. to Invoice Decimal Normal
18 Qty. to Ship 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
56 Recalculate Invoice Disc. Boolean Normal
57 Outstanding Amount Decimal Normal
58 Qty. Shipped Not Invoiced Decimal Normal
59 Shipped Not Invoiced Decimal Normal
60 Quantity Shipped Decimal Normal
61 Quantity Invoiced Decimal Normal
63 Shipment No. Code Normal
64 Shipment Line No. Integer Normal
67 Profit % Decimal Normal
68 Bill-to Customer No. Code Normal → Customer #18
69 Inv. Discount Amount Decimal Normal
71 Purchase Order No. Code Normal
72 Purch. Order Line No. Integer 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 Line #37
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
91 Currency Code Code Normal → Currency #4
92 Outstanding Amount (LCY) Decimal Normal
93 Shipped Not Invoiced (LCY) Incl. VAT Decimal Normal
94 Shipped Not Invoiced (LCY) Decimal Normal
95 Reserved Quantity ⚡ FLOW Decimal FlowField
96 Reserve Option Normal
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
105 Inv. Disc. Amount to Invoice Decimal Normal
106 VAT Identifier Code Normal
107 IC Partner Ref. Type Option Normal
108 IC Partner Reference Code Normal
109 Prepayment % Decimal Normal
110 Prepmt. Line Amount Decimal Normal
111 Prepmt. Amt. Inv. Decimal Normal
112 Prepmt. Amt. Incl. VAT Decimal Normal
113 Prepayment Amount Decimal Normal
114 Prepmt. VAT Base Amt. Decimal Normal
115 Prepayment VAT % Decimal Normal
116 Prepmt. VAT Calc. Type Option Normal
117 Prepayment VAT Identifier Code Normal
118 Prepayment Tax Area Code Code Normal → Tax Area #318
119 Prepayment Tax Liable Boolean Normal
120 Prepayment Tax Group Code Code Normal → Tax Group #321
121 Prepmt Amt to Deduct Decimal Normal
122 Prepmt Amt Deducted Decimal Normal
123 Prepayment Line Boolean Normal
124 Prepmt. Amount Inv. Incl. VAT Decimal Normal
129 Prepmt. Amount Inv. (LCY) Decimal Normal
130 IC Partner Code Code Normal → IC Partner #413
132 Prepmt. VAT Amount Inv. (LCY) Decimal Normal
135 Prepayment VAT Difference Decimal Normal
136 Prepmt VAT Diff. to Deduct Decimal Normal
137 Prepmt VAT Diff. Deducted Decimal Normal
138 IC Item Reference No. Code Normal
145 Pmt. Discount Amount Decimal Normal
146 Prepmt. Pmt. Discount Amount Decimal Normal
180 Line Discount Calculation Option Normal
480 Dimension Set ID Integer Normal → Dimension Set Entry #480
900 Qty. to Assemble to Order Decimal Normal
901 Qty. to Asm. to Order (Base) Decimal Normal
902 ATO Whse. Outstanding Qty. ⚡ FLOW Decimal FlowField
903 ATO Whse. Outstd. Qty. (Base) ⚡ FLOW Decimal FlowField
1001 Project Task No. Code Normal → Job Task #1001
1002 Project Contract Entry No. Integer Normal
1300 Posting Date ⚡ FLOW Date FlowField
1700 Deferral Code Code Normal → Deferral Template #1700
1702 Returns Deferral Start Date Date Normal
2675 Allocation Account No. Code Normal → Allocation Account #2670
2677 Allocation Account Distributions Modified ⚡ FLOW Boolean FlowField
2678 Posting Allocation Account No. Code Normal → Allocation Account #2670
2679 Allocation Sales Line SystemId GUID Normal
5402 Variant Code Code Normal
5403 Bin Code Code Normal
5404 Qty. per Unit of Measure Decimal Normal
5405 Planned Boolean Normal
5406 Qty. Rounding Precision Decimal Normal
5407 Unit of Measure Code Code Normal
5408 Qty. Rounding Precision (Base) Decimal Normal
5415 Quantity (Base) Decimal Normal
5416 Outstanding Qty. (Base) Decimal Normal
5417 Qty. to Invoice (Base) Decimal Normal
5418 Qty. to Ship (Base) Decimal Normal
5458 Qty. Shipped Not Invd. (Base) Decimal Normal
5460 Qty. Shipped (Base) Decimal Normal
5461 Qty. Invoiced (Base) Decimal Normal
5495 Reserved Qty. (Base) ⚡ FLOW Decimal FlowField
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
5701 Out-of-Stock Substitution Boolean Normal
5702 Substitution Available ⚡ FLOW Boolean FlowField
5703 Originally Ordered No. Code Normal
5704 Originally Ordered Var. Code Code Normal
5709 Item Category Code Code Normal → Item Category #5722
5710 Catalog Boolean Normal
5711 Purchasing Code Code Normal → Purchasing #5721
5713 Special Order Boolean Normal
5714 Special Order Purchase No. Code Normal
5715 Special Order Purch. Line No. Integer Normal
5725 Item Reference No. Code Normal
5726 Reference Unit of Measure Code Normal
5727 Item Reference Type Option Normal
5728 Item Reference Type No. Code Normal
5749 Whse. Outstanding Qty. ⚡ FLOW Decimal FlowField
5750 Whse. Outstanding Qty. (Base) ⚡ FLOW Decimal FlowField
5752 Completely Shipped Boolean Normal
5790 Requested Delivery Date Date Normal
5791 Promised Delivery Date Date Normal
5792 Shipping Time DateFormula Normal
5793 Outbound Whse. Handling Time DateFormula Normal
5794 Planned Delivery Date Date Normal
5795 Planned Shipment Date Date Normal
5796 Shipping Agent Code Code Normal → Shipping Agent #291
5797 Shipping Agent Service Code Code Normal → Shipping Agent Services #5790
5800 Allow Item Charge Assignment Boolean Normal
5801 Qty. to Assign ⚡ FLOW Decimal FlowField
5802 Qty. Assigned ⚡ FLOW Decimal FlowField
5803 Return Qty. to Receive Decimal Normal
5804 Return Qty. to Receive (Base) Decimal Normal
5805 Return Qty. Rcd. Not Invd. Decimal Normal
5806 Ret. Qty. Rcd. Not Invd.(Base) Decimal Normal
5807 Return Rcd. Not Invd. Decimal Normal
5808 Return Rcd. Not Invd. (LCY) Decimal Normal
5809 Return Qty. Received Decimal Normal
5810 Return Qty. Received (Base) Decimal Normal
5811 Appl.-from Item Entry Integer Normal
5812 Item Charge Qty. to Handle ⚡ FLOW Decimal FlowField
5909 BOM Item No. Code Normal → Item #27
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
6216 Posted Total CO2e Decimal Normal
6217 EPR Fee Per Unit Decimal Normal
6218 Total EPR Fee Decimal Normal
6219 Posted Total EPR Fee Decimal Normal
6600 Return Receipt No. Code Normal
6601 Return Receipt Line No. Integer Normal
6608 Return Reason Code Code Normal → Return Reason #6635
6610 Copied From Posted Doc. Boolean Normal
7000 Price Calculation Method Option Normal
7001 Allow Line Disc. Boolean Normal
7002 Customer Disc. Group Code Normal → Customer Discount Group #340
7003 Subtype Option Normal
7004 Price description Text Normal
7010 Attached Doc Count ⚡ FLOW Integer FlowField
7011 Attached Lines Count ⚡ FLOW Integer FlowField
7012 Sell-to Customer Name ⚡ FLOW Text FlowField
8053 Recurring Billing from Date Normal
8054 Recurring Billing to Date Normal
8055 Subscription Lines ⚡ FLOW Integer FlowField
8057 Subscription Option ⚡ FLOW Option FlowField
8058 Discount Boolean Normal
8059 Exclude from Document Total 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
30103 Shopify Refund Id BigInteger Normal
30104 Shopify Refund Line Id BigInteger Normal
30105 Shopify Refund Shipping Line Id BigInteger 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 (39)

Tables referenced by fields on the Sales Line table through TableRelation properties.

Customer
#18 · Sales · via Sell-to Customer No., Bill-to Customer No.
Sales Header
#36 · Sales Documents · via Document No., Blanket Order No.
Location
#14 · General Ledger · via Location Code
Dimension Value
#349 · Dimensions · via Shortcut Dimension 1 Code, Shortcut Dimension 2 Code
Customer Price Group
#6 · General Ledger · via Customer Price Group
Job
#167 · Other · via Project No.
Work Type
#200 · Other · via Work Type Code
Gen. Business Posting Group
#250 · Other · via Gen. Bus. Posting Group
Gen. Product Posting Group
#251 · Other · via Gen. Prod. Posting Group
Transaction Type
#258 · Other · via Transaction Type
Transport Method
#259 · Other · via Transport Method
Sales Line
#37 · Sales Documents · via Attached to Line No., Blanket Order Line No.
Entry/Exit Point
#282 · Other · via Exit Point
Area
#284 · Other · via Area
Transaction Specification
#285 · Other · via Transaction Specification
Tax Area
#318 · Other · via Tax Area Code, Prepayment Tax Area Code
Tax Group
#321 · Other · via Tax Group Code, Prepayment Tax Group Code
VAT Clause
#560 · Other · via VAT Clause Code
VAT Business Posting Group
#323 · Other · via VAT Bus. Posting Group
VAT Product Posting Group
#324 · Other · via VAT Prod. Posting Group
Currency
#4 · General Ledger · via Currency Code
IC Partner
#413 · Other · via IC Partner Code
Dimension Set Entry
#480 · Dimensions · via Dimension Set ID
Job Task
#1001 · Jobs · via Project Task No.
Deferral Template
#1700 · Other · via Deferral Code
Allocation Account
#2670 · Other · via Allocation Account No., Posting Allocation Account No.
Depreciation Book
#5611 · Fixed Assets · via Depreciation Book Code, Duplicate in Depreciation Book
Responsibility Center
#5714 · Other · via Responsibility Center
Item Category
#5722 · Other · via Item Category Code
Purchasing
#5721 · Other · via Purchasing Code
Shipping Agent
#291 · Other · via Shipping Agent Code
Shipping Agent Services
#5790 · Other · via Shipping Agent Service Code
Item
#27 · Inventory · via BOM Item No.
Sustainability Account
#6210 · Other · via Sustainability Account No.
Sustain. Account Category
#6211 · Other · via Sustainability Account Category
Sustain. Account Subcategory
#6212 · Other · via Sustainability Account Subcategory
Return Reason
#6635 · Other · via Return Reason Code
Customer Discount Group
#340 · Other · via Customer Disc. Group

© 2026 Xpertly Ltd · Company No. 14753894 · VAT No. 452840787

HomeData ExplorerPricingPrivacyTerms