Service table in Microsoft Dynamics 365 Business Central. 103 fields, 0 records in Cronus demo.
The primary key uniquely identifies each record in this table. It consists of: Document No., Line No..
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 2 | Customer No. | Code | Normal | → Customer #18 |
| 3 | Document No. PK | Code | Normal | → Service Cr.Memo Header #5994 |
| 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 | |
| 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 | |
| 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 |
| 46 | Project Task No. | Code | Normal | → Job Task #1001 |
| 52 | Work Type Code | Code | Normal | → Work Type #200 |
| 63 | Shipment No. | Code | Normal | |
| 68 | Bill-to Customer No. | Code | Normal | → Customer #18 |
| 69 | Inv. Discount Amount | Decimal | 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 | → Service Cr.Memo Line #5995 |
| 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 |
| 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 |
| 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 | |
| 145 | Pmt. Discount Amount | Decimal | Normal | |
| 480 | Dimension Set ID | Integer | Normal | → Dimension Set Entry #480 |
| 1019 | Project Planning Line 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 | |
| 5700 | Responsibility Center | Code | Normal | → Responsibility Center #5714 |
| 5709 | Item Category Code | Code | Normal | → Item Category #5722 |
| 5710 | Catalog | Boolean | Normal | |
| 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 | |
| 5902 | Service Item No. | Code | Normal | → Service Item #5940 |
| 5903 | Appl.-to Service Entry | Integer | Normal | |
| 5905 | Service Item Serial No. | Code | Normal | |
| 5906 | Service Item Line Description | Text | Normal | |
| 5908 | Posting Date | Date | Normal | |
| 5910 | Needed by Date | Date | Normal | |
| 5916 | Ship-to Code | Code | Normal | → Ship-to Address #222 |
| 5928 | Service Price Group Code | Code | Normal | → Service Price Group #6080 |
| 5929 | Fault Area Code | Code | Normal | → Fault Area #5915 |
| 5930 | Symptom Code | Code | Normal | → Symptom Code #5916 |
| 5931 | Fault Code | Code | Normal | → Fault Code #5918 |
| 5932 | Resolution Code | Code | Normal | → Resolution Code #5919 |
| 5933 | Exclude Warranty | Boolean | Normal | |
| 5934 | Warranty | Boolean | Normal | |
| 5936 | Contract No. | Code | Normal | → Service Contract Header #5965 |
| 5938 | Contract Disc. % | Decimal | Normal | |
| 5939 | Warranty Disc. % | Decimal | Normal | |
| 5965 | Component Line No. | Integer | Normal | |
| 5966 | Spare Part Action | Option | Normal | |
| 5967 | Fault Reason Code | Code | Normal | → Fault Reason Code #5917 |
| 5968 | Replaced Item No. | Code | Normal | → Item #27 |
| 5969 | Exclude Contract Discount | Boolean | Normal | |
| 5994 | Price Adjmt. Status | Option | Normal | |
| 5997 | Line Discount Type | Option | Normal | |
| 5999 | Copy Components From | Option | 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 |
| 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 Service Cr.Memo Line table through TableRelation properties.