Other table in Microsoft Dynamics 365 Business Central. 111 fields, 512 records in Cronus demo.
The Sales Shipment Line table (ID 111) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 111 fields, with a primary key of Document No., Line No., and includes 1 calculated FlowField. Use the reference below to explore every field, data type, and table relation.
The primary key uniquely identifies each record in this table. It consists of: Document No., Line No..
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 2 | Sell-to Customer No. | Code | Normal | → Customer #18 |
| 3 | Document No. PK | Code | Normal | → Sales Shipment Header #110 |
| 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 | |
| 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 | |
| 39 | Item Shpt. Entry No. | 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 |
| 58 | Qty. Shipped Not Invoiced | Decimal | Normal | |
| 61 | Quantity Invoiced | Decimal | Normal | |
| 65 | Order No. | Code | Normal | |
| 66 | Order Line No. | Integer | Normal | |
| 68 | Bill-to Customer No. | Code | Normal | → Customer #18 |
| 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 Shipment Line #111 |
| 81 | Exit Point | Code | Normal | → Entry/Exit Point #282 |
| 82 | Area | Code | Normal | → Area #284 |
| 83 | Transaction Specification | Code | Normal | → Transaction Specification #285 |
| 85 | Tax Area Code | Code | Normal | → Tax Area #318 |
| 86 | Tax Liable | Boolean | Normal | |
| 87 | Tax Group Code | Code | Normal | → Tax Group #321 |
| 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 ⚡ FLOW | Code | FlowField | |
| 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 | |
| 107 | IC Partner Ref. Type | Option | Normal | |
| 108 | IC Partner Reference | Code | Normal | |
| 131 | Posting Date | Date | Normal | |
| 138 | IC Item Reference No. | Code | Normal | |
| 480 | Dimension Set ID | Integer | Normal | → Dimension Set Entry #480 |
| 826 | Authorized for Credit Card | Boolean | Normal | |
| 1001 | Project Task No. | Code | Normal | → Job Task #1001 |
| 1002 | Project Contract Entry No. | Integer | 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 | |
| 5461 | Qty. Invoiced (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 | |
| 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 | |
| 5811 | Appl.-from Item Entry | Integer | Normal | |
| 5812 | Item Charge Base Amount | Decimal | Normal | |
| 5817 | Correction | Boolean | 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 | |
| 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 |
| 8000 | Document Id | GUID | 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 |
Tables referenced by fields on the Sales Shipment Line table through TableRelation properties.