Service table in Microsoft Dynamics 365 Business Central. 68 fields, 0 records in Cronus demo.
The primary key uniquely identifies each record in this table. It consists of: Entry No..
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Entry No. PK | Integer | Normal | |
| 2 | Service Contract No. | Code | Normal | → Service Contract Header #5965 |
| 3 | Document Type | Option | Normal | |
| 4 | Document No. | Code | Normal | |
| 5 | Serv. Contract Acc. Gr. Code | Code | Normal | → Service Contract Account Group #5973 |
| 6 | Document Line No. | Integer | Normal | |
| 8 | Moved from Prepaid Acc. | Boolean | Normal | |
| 9 | Posting Date | Date | Normal | |
| 11 | Amount (LCY) | Decimal | Normal | |
| 12 | Customer No. | Code | Normal | → Customer #18 |
| 13 | Ship-to Code | Code | Normal | → Ship-to Address #222 |
| 14 | Item No. (Serviced) | Code | Normal | → Item #27 |
| 15 | Serial No. (Serviced) | Code | Normal | |
| 16 | User ID | Code | Normal | |
| 17 | Contract Invoice Period | Text | Normal | |
| 18 | Global Dimension 1 Code | Code | Normal | → Dimension Value #349 |
| 19 | Global Dimension 2 Code | Code | Normal | → Dimension Value #349 |
| 20 | Service Item No. (Serviced) | Code | Normal | → Service Item #5940 |
| 21 | Variant Code (Serviced) | Code | Normal | → Item Variant #5401 |
| 22 | Contract Group Code | Code | Normal | → Contract Group #5966 |
| 23 | Type | Option | Normal | |
| 24 | No. | Code | Normal | |
| 25 | Cost Amount | Decimal | Normal | |
| 26 | Discount Amount | Decimal | Normal | |
| 27 | Unit Cost | Decimal | Normal | |
| 28 | Quantity | Decimal | Normal | |
| 29 | Charged Qty. | Decimal | Normal | |
| 30 | Unit Price | Decimal | Normal | |
| 31 | Discount % | Decimal | Normal | |
| 32 | Contract Disc. Amount | Decimal | Normal | |
| 33 | Bill-to Customer No. | Code | Normal | → Customer #18 |
| 34 | Fault Reason Code | Code | Normal | → Fault Reason Code #5917 |
| 35 | Description | Text | Normal | |
| 37 | Service Order Type | Code | Normal | → Service Order Type #5903 |
| 39 | Service Order No. | Code | Normal | |
| 40 | Project No. | Code | Normal | → Job #167 |
| 41 | Gen. Bus. Posting Group | Code | Normal | → Gen. Business Posting Group #250 |
| 42 | Gen. Prod. Posting Group | Code | Normal | → Gen. Product Posting Group #251 |
| 43 | Location Code | Code | Normal | → Location #14 |
| 44 | Unit of Measure Code | Code | Normal | → Unit of Measure #204 |
| 45 | Work Type Code | Code | Normal | → Work Type #200 |
| 46 | Bin Code | Code | Normal | → Bin #7354 |
| 47 | Responsibility Center | Code | Normal | → Responsibility Center #5714 |
| 48 | Variant Code | Code | Normal | |
| 50 | Entry Type | Option | Normal | |
| 51 | Open | Boolean | Normal | |
| 52 | Serv. Price Adjmt. Gr. Code | Code | Normal | → Service Price Adjustment Group #6082 |
| 53 | Service Price Group Code | Code | Normal | → Service Price Group #6080 |
| 54 | Prepaid | Boolean | Normal | |
| 55 | Apply Until Entry No. | Integer | Normal | |
| 56 | Applies-to Entry No. | Integer | Normal | |
| 57 | Amount | Decimal | Normal | |
| 58 | Project Task No. | Code | Normal | → Job Task #1001 |
| 59 | Project Line Type | Option | Normal | |
| 60 | Project Posted | Boolean | Normal | |
| 61 | External Document No. | Code | Normal | |
| 480 | Dimension Set ID | Integer | Normal | → Dimension Set Entry #480 |
| 481 | Shortcut Dimension 3 Code ⚡ FLOW | Code | FlowField | |
| 482 | Shortcut Dimension 4 Code ⚡ FLOW | Code | FlowField | |
| 483 | Shortcut Dimension 5 Code ⚡ FLOW | Code | FlowField | |
| 484 | Shortcut Dimension 6 Code ⚡ FLOW | Code | FlowField | |
| 485 | Shortcut Dimension 7 Code ⚡ FLOW | Code | FlowField | |
| 486 | Shortcut Dimension 8 Code ⚡ FLOW | Code | FlowField | |
| 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 Ledger Entry table through TableRelation properties.