Jobs table in Microsoft Dynamics 365 Business Central. 17 fields, 0 records in Cronus demo.
The primary key uniquely identifies each record in this table. It consists of: Posting Group, Type, G/L Account No., Project No., Project WIP Total Entry No., Reverse, Dim Combination ID.
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Posting Group PK | Code | Normal | |
| 2 | Type PK | Option | Normal | |
| 3 | WIP Entry Amount | Decimal | Normal | |
| 4 | G/L Account No. PK | Code | Normal | → G/L Account #15 |
| 5 | Bal. G/L Account No. | Code | Normal | → G/L Account #15 |
| 6 | WIP Method | Code | Normal | |
| 7 | Project No. PK | Code | Normal | → Job #167 |
| 8 | Project Complete | Boolean | Normal | |
| 9 | Project WIP Total Entry No. PK | Integer | Normal | → Job WIP Total #1021 |
| 22 | Reverse PK | Boolean | Normal | |
| 23 | WIP Posting Method Used | Option | Normal | |
| 71 | Dim Combination ID PK | Integer | 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 Job WIP Buffer table through TableRelation properties.