Jobs table in Microsoft Dynamics 365 Business Central. 17 fields, 0 records in Cronus demo.
The Job Planning Line Invoice table (ID 1022) is part of the Jobs area in Microsoft Dynamics 365 Business Central. It contains 17 fields, with a primary key of Project No., Project Task No., Project Planning Line No., Document Type, Document No., Line No.. 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: Project No., Project Task No., Project Planning Line No., Document Type, Document No., Line No..
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Project No. PK | Code | Normal | → Job #167 |
| 2 | Project Task No. PK | Code | Normal | → Job Task #1001 |
| 3 | Project Planning Line No. PK | Integer | Normal | → Job Planning Line #1003 |
| 4 | Document Type PK | Option | Normal | |
| 5 | Document No. PK | Code | Normal | |
| 6 | Line No. PK | Integer | Normal | |
| 7 | Quantity Transferred | Decimal | Normal | |
| 8 | Transferred Date | Date | Normal | |
| 9 | Invoiced Date | Date | Normal | |
| 10 | Invoiced Amount (LCY) | Decimal | Normal | |
| 11 | Invoiced Cost Amount (LCY) | Decimal | Normal | |
| 12 | Project Ledger Entry No. | Integer | Normal | → Job Ledger Entry #169 |
| 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 Planning Line Invoice table through TableRelation properties.