Jobs table in Microsoft Dynamics 365 Business Central. 17 fields, 0 records in Cronus demo.
The Job WIP Buffer table (ID 1018) is part of the Jobs area in Microsoft Dynamics 365 Business Central. It contains 17 fields, with a primary key of Posting Group, Type, G/L Account No., Project No., Project WIP Total Entry No., Reverse, Dim Combination ID. 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: 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.