Table 5137 Job Planning Line Archive in 24
- App
- Base Application
- Namespace
- Microsoft.Projects.Project.Archive
Versions171819202122232425262728latest
Source29
Fields, 103
| Id | Name | Type | Obsolete |
|---|---|---|---|
| 1 | Line No. | Integer | - |
| 2 | Job No. | Code[20] | - |
| 3 | Planning Date | Date | - |
| 4 | Document No. | Code[20] | - |
| 5 | Type | Enum Job Planning Line Type | - |
| 7 | No. | Code[20] | - |
| 8 | Description | Text[100] | - |
| 9 | Quantity | Decimal | - |
| 11 | Direct Unit Cost (LCY) | Decimal | - |
| 12 | Unit Cost (LCY) | Decimal | - |
| 13 | Total Cost (LCY) | Decimal | - |
| 14 | Unit Price (LCY) | Decimal | - |
| 15 | Total Price (LCY) | Decimal | - |
| 16 | Resource Group No. | Code[20] | - |
| 17 | Unit of Measure Code | Code[10] | - |
| 18 | Qty. Rounding Precision | Decimal | - |
| 19 | Qty. Rounding Precision (Base) | Decimal | - |
| 20 | Location Code | Code[10] | - |
| 29 | Last Date Modified | Date | - |
| 30 | User ID | Code[50] | - |
| 32 | Work Type Code | Code[10] | - |
| 33 | Customer Price Group | Code[10] | - |
| 79 | Country/Region Code | Code[10] | - |
| 80 | Gen. Bus. Posting Group | Code[20] | - |
| 81 | Gen. Prod. Posting Group | Code[20] | - |
| 83 | Document Date | Date | - |
| 84 | Planning Due Date | Date | - |
| 900 | Qty. to Assemble | Decimal | - |
| 901 | Qty. to Assemble (Base) | Decimal | - |
| 902 | Assemble to Order | Boolean | - |
| 903 | BOM Item No. | Code[20] | - |
| 904 | Attached to Line No. | Integer | - |
| 1000 | Job Task No. | Code[20] | - |
| 1001 | Line Amount (LCY) | Decimal | - |
| 1002 | Unit Cost | Decimal | - |
| 1003 | Total Cost | Decimal | - |
| 1004 | Unit Price | Decimal | - |
| 1005 | Total Price | Decimal | - |
| 1006 | Line Amount | Decimal | - |
| 1007 | Line Discount Amount | Decimal | - |
| 1008 | Line Discount Amount (LCY) | Decimal | - |
| 1015 | Cost Factor | Decimal | - |
| 1019 | Serial No. | Code[50] | - |
| 1020 | Lot No. | Code[50] | - |
| 1021 | Line Discount % | Decimal | - |
| 1022 | Line Type | Enum Job Planning Line Line Type | - |
| 1023 | Currency Code | Code[10] | - |
| 1024 | Currency Date | Date | - |
| 1025 | Currency Factor | Decimal | - |
| 1026 | Schedule Line | Boolean | - |
| 1027 | Contract Line | Boolean | - |
| 1030 | Job Contract Entry No. | Integer | - |
| 1035 | Invoiced Amount (LCY) | Decimal | - |
| 1036 | Invoiced Cost Amount (LCY) | Decimal | - |
| 1037 | VAT Unit Price | Decimal | - |
| 1038 | VAT Line Discount Amount | Decimal | - |
| 1039 | VAT Line Amount | Decimal | - |
| 1041 | VAT % | Decimal | - |
| 1042 | Description 2 | Text[50] | - |
| 1043 | Job Ledger Entry No. | Integer | - |
| 1048 | Status | Enum Job Planning Line Status | - |
| 1050 | Ledger Entry Type | Enum Job Ledger Entry Type | - |
| 1051 | Ledger Entry No. | Integer | - |
| 1052 | System-Created Entry | Boolean | - |
| 1053 | Usage Link | Boolean | - |
| 1060 | Remaining Qty. | Decimal | - |
| 1061 | Remaining Qty. (Base) | Decimal | - |
| 1062 | Remaining Total Cost | Decimal | - |
| 1063 | Remaining Total Cost (LCY) | Decimal | - |
| 1064 | Remaining Line Amount | Decimal | - |
| 1065 | Remaining Line Amount (LCY) | Decimal | - |
| 1070 | Qty. Posted | Decimal | - |
| 1071 | Qty. to Transfer to Journal | Decimal | - |
| 1072 | Posted Total Cost | Decimal | - |
| 1073 | Posted Total Cost (LCY) | Decimal | - |
| 1074 | Posted Line Amount | Decimal | - |
| 1075 | Posted Line Amount (LCY) | Decimal | - |
| 1080 | Qty. Transferred to Invoice | Decimal | - |
| 1081 | Qty. to Transfer to Invoice | Decimal | - |
| 1090 | Qty. Invoiced | Decimal | - |
| 1091 | Qty. to Invoice | Decimal | - |
| 1100 | Reserved Quantity | Decimal | - |
| 1101 | Reserved Qty. (Base) | Decimal | - |
| 1102 | Reserve | Enum Reserve Method | - |
| 1103 | Planned | Boolean | - |
| 5047 | Version No. | Integer | - |
| 5402 | Variant Code | Code[10] | - |
| 5403 | Bin Code | Code[20] | - |
| 5404 | Qty. per Unit of Measure | Decimal | - |
| 5410 | Quantity (Base) | Decimal | - |
| 5790 | Requested Delivery Date | Date | - |
| 5791 | Promised Delivery Date | Date | - |
| 5794 | Planned Delivery Date | Date | - |
| 5900 | Service Order No. | Code[20] | - |
| 6515 | Package No. | Code[50] | - |
| 7000 | Price Calculation Method | Enum Price Calculation Method | - |
| 7001 | Cost Calculation Method | Enum Price Calculation Method | - |
| 7300 | Pick Qty. | Decimal | - |
| 7301 | Qty. Picked | Decimal | - |
| 7302 | Qty. Picked (Base) | Decimal | - |
| 7303 | Completely Picked | Boolean | - |
| 7304 | Pick Qty. (Base) | Decimal | - |
| 7305 | Qty. on Journal | Decimal | - |
Keys, 1
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | Job No., Job Task No., Version No., Line No. | - |