Service table in Microsoft Dynamics 365 Business Central. 146 fields, 0 records in Cronus demo.
The Service Cr.Memo Header table (ID 5994) is part of the Service area in Microsoft Dynamics 365 Business Central. It contains 146 fields, with a primary key of No., and includes 10 calculated FlowFields. 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: No..
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 2 | Customer No. | Code | Normal | → Customer #18 |
| 3 | No. PK | Code | Normal | |
| 4 | Bill-to Customer No. | Code | Normal | → Customer #18 |
| 5 | Bill-to Name | Text | Normal | |
| 6 | Bill-to Name 2 | Text | Normal | |
| 7 | Bill-to Address | Text | Normal | |
| 8 | Bill-to Address 2 | Text | Normal | |
| 9 | Bill-to City | Text | Normal | → Post Code #225 |
| 10 | Bill-to Contact | Text | Normal | |
| 11 | Your Reference | Text | Normal | |
| 12 | Ship-to Code | Code | Normal | → Ship-to Address #222 |
| 13 | Ship-to Name | Text | Normal | |
| 14 | Ship-to Name 2 | Text | Normal | |
| 15 | Ship-to Address | Text | Normal | |
| 16 | Ship-to Address 2 | Text | Normal | |
| 17 | Ship-to City | Text | Normal | → Post Code #225 |
| 18 | Ship-to Contact | Text | Normal | |
| 20 | Posting Date | Date | Normal | |
| 22 | Posting Description | Text | Normal | |
| 23 | Payment Terms Code | Code | Normal | → Payment Terms #3 |
| 24 | Due Date | Date | Normal | |
| 25 | Payment Discount % | Decimal | Normal | |
| 26 | Pmt. Discount Date | Date | Normal | |
| 27 | Shipment Method Code | Code | Normal | → Shipment Method #10 |
| 28 | Location Code | Code | Normal | → Location #14 |
| 29 | Shortcut Dimension 1 Code | Code | Normal | → Dimension Value #349 |
| 30 | Shortcut Dimension 2 Code | Code | Normal | → Dimension Value #349 |
| 31 | Customer Posting Group | Code | Normal | → Customer Posting Group #92 |
| 32 | Currency Code | Code | Normal | → Currency #4 |
| 33 | Currency Factor | Decimal | Normal | |
| 34 | Customer Price Group | Code | Normal | → Customer Price Group #6 |
| 35 | Prices Including VAT | Boolean | Normal | |
| 37 | Invoice Disc. Code | Code | Normal | |
| 40 | Customer Disc. Group | Code | Normal | → Customer Discount Group #340 |
| 41 | Language Code | Code | Normal | → Language #8 |
| 42 | Format Region | Text | Normal | |
| 43 | Salesperson Code | Code | Normal | → Salesperson/Purchaser #13 |
| 46 | Comment ⚡ FLOW | Boolean | FlowField | |
| 47 | No. Printed | Integer | Normal | |
| 52 | Applies-to Doc. Type | Option | Normal | |
| 53 | Applies-to Doc. No. | Code | Normal | |
| 55 | Bal. Account No. | Code | Normal | |
| 60 | Amount ⚡ FLOW | Decimal | FlowField | |
| 61 | Amount Including VAT ⚡ FLOW | Decimal | FlowField | |
| 70 | VAT Registration No. | Text | Normal | |
| 73 | Reason Code | Code | Normal | → Reason Code #231 |
| 74 | Gen. Bus. Posting Group | Code | Normal | → Gen. Business Posting Group #250 |
| 75 | EU 3-Party Trade | Boolean | Normal | |
| 76 | Transaction Type | Code | Normal | → Transaction Type #258 |
| 77 | Transport Method | Code | Normal | → Transport Method #259 |
| 78 | VAT Country/Region Code | Code | Normal | → Country/Region #9 |
| 79 | Name | Text | Normal | |
| 80 | Name 2 | Text | Normal | |
| 81 | Address | Text | Normal | |
| 82 | Address 2 | Text | Normal | |
| 83 | City | Text | Normal | → Post Code #225 |
| 84 | Contact Name | Text | Normal | |
| 85 | Bill-to Post Code | Code | Normal | → Post Code #225 |
| 86 | Bill-to County | Text | Normal | |
| 87 | Bill-to Country/Region Code | Code | Normal | → Country/Region #9 |
| 88 | Post Code | Code | Normal | → Post Code #225 |
| 89 | County | Text | Normal | |
| 90 | Country/Region Code | Code | Normal | → Country/Region #9 |
| 91 | Ship-to Post Code | Code | Normal | → Post Code #225 |
| 92 | Ship-to County | Text | Normal | |
| 93 | Ship-to Country/Region Code | Code | Normal | → Country/Region #9 |
| 94 | Bal. Account Type | Option | Normal | |
| 97 | Exit Point | Code | Normal | → Entry/Exit Point #282 |
| 98 | Correction | Boolean | Normal | |
| 99 | Document Date | Date | Normal | |
| 100 | External Document No. | Code | Normal | |
| 101 | Area | Code | Normal | → Area #284 |
| 102 | Transaction Specification | Code | Normal | → Transaction Specification #285 |
| 104 | Payment Method Code | Code | Normal | → Payment Method #289 |
| 105 | Shipping Agent Code | Code | Normal | → Shipping Agent #291 |
| 107 | Pre-Assigned No. Series | Code | Normal | → No. Series #308 |
| 108 | No. Series | Code | Normal | → No. Series #308 |
| 111 | Pre-Assigned No. | Code | Normal | |
| 112 | User ID | Code | Normal | |
| 113 | Source Code | Code | Normal | → Source Code #230 |
| 114 | Tax Area Code | Code | Normal | → Tax Area #318 |
| 115 | Tax Liable | Boolean | Normal | |
| 116 | VAT Bus. Posting Group | Code | Normal | → VAT Business Posting Group #323 |
| 119 | VAT Base Discount % | Decimal | Normal | |
| 129 | Company Bank Account Code | Code | Normal | → Bank Account #270 |
| 131 | VAT Date | Date | Normal | |
| 200 | Work Description | BLOB | Normal | |
| 480 | Dimension Set ID | Integer | Normal | → Dimension Set Entry #480 |
| 710 | Document Exchange Identifier | Text | Normal | |
| 711 | Document Exchange Status | Option | Normal | |
| 712 | Doc. Exch. Original Identifier | Text | Normal | |
| 5052 | Contact No. | Code | Normal | → Contact #5050 |
| 5053 | Bill-to Contact No. | Code | Normal | → Contact #5050 |
| 5700 | Responsibility Center | Code | Normal | → Responsibility Center #5714 |
| 5794 | Shipping Agent Service Code | Code | Normal | → Shipping Agent Services #5790 |
| 5902 | Description | Text | Normal | |
| 5904 | Service Order Type | Code | Normal | → Service Order Type #5903 |
| 5905 | Link Service to Service Item | Boolean | Normal | |
| 5907 | Priority | Option | Normal | |
| 5911 | Allocated Hours ⚡ FLOW | Decimal | FlowField | |
| 5915 | Phone No. | Text | Normal | |
| 5916 | Text | Normal | ||
| 5917 | Phone No. 2 | Text | Normal | |
| 5918 | Fax No. | Text | Normal | |
| 5921 | No. of Unallocated Items ⚡ FLOW | Integer | FlowField | |
| 5923 | Order Time | Time | Normal | |
| 5924 | Default Response Time (Hours) | Decimal | Normal | |
| 5925 | Actual Response Time (Hours) | Decimal | Normal | |
| 5926 | Service Time (Hours) | Decimal | Normal | |
| 5927 | Response Date | Date | Normal | |
| 5928 | Response Time | Time | Normal | |
| 5929 | Starting Date | Date | Normal | |
| 5930 | Starting Time | Time | Normal | |
| 5931 | Finishing Date | Date | Normal | |
| 5932 | Finishing Time | Time | Normal | |
| 5933 | Contract Serv. Hours Exist ⚡ FLOW | Boolean | FlowField | |
| 5934 | Reallocation Needed ⚡ FLOW | Boolean | FlowField | |
| 5936 | Notify Customer | Option | Normal | |
| 5937 | Max. Labor Unit Price | Decimal | Normal | |
| 5938 | Warning Status | Option | Normal | |
| 5939 | No. of Allocations ⚡ FLOW | Integer | FlowField | |
| 5940 | Contract No. | Code | Normal | → Service Contract Header #5965 |
| 5951 | Type Filter | Option | FlowFilter | |
| 5952 | Customer Filter | Code | FlowFilter | → Customer #18 |
| 5953 | Resource Filter | Code | FlowFilter | → Resource #156 |
| 5954 | Contract Filter | Code | FlowFilter | → Service Contract Header #5965 |
| 5955 | Ship-to Fax No. | Text | Normal | |
| 5956 | Ship-to Email | Text | Normal | |
| 5957 | Resource Group Filter | Code | FlowFilter | → Resource Group #152 |
| 5958 | Ship-to Phone | Text | Normal | |
| 5959 | Ship-to Phone 2 | Text | Normal | |
| 5966 | Service Zone Filter | Code | FlowFilter | → Service Zone #5957 |
| 5968 | Service Zone Code | Code | Normal | → Service Zone #5957 |
| 5981 | Expected Finishing Date | Date | Normal | |
| 6165 | QR Code Image | MediaSet | Normal | |
| 6166 | QR Code Base64 | BLOB | Normal | |
| 6210 | Sustainability Lines Exist ⚡ FLOW | Boolean | FlowField | |
| 6211 | Total CO2e ⚡ FLOW | Decimal | FlowField | |
| 7000 | Price Calculation Method | Option | Normal | |
| 7001 | Allow Line Disc. | Boolean | Normal | |
| 9001 | Quote 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 Service Cr.Memo Header table through TableRelation properties.