Table WSB_PMPJobPlanningLineArchive¶

Obsolete

The Job/Project Archive will be removed as this is now available in the Microsoft Base Application.

Stores project archive planning lines.

Properties¶

Name	Value
Access	Public
Caption	Project Planning Line Archive
DataClassification	CustomerContent
DataPerCompany	True
ObsoleteReason	The Job/Project Archive will be removed as this is now available in the Microsoft Base Application.
ObsoleteState	Pending
ObsoleteTag	1.20.0.0

Fields¶

ID	Type	Name
1	`Integer`	`Line No.`
2	`Code[20]`	`Job No.`
3	`Date`	`Planning Date`
4	`Code[20]`	`Document No.`
5	`Enum Job Planning Line Type`	`Type`
7	`Code[20]`	`No.`
8	`Text[100]`	`Description`
9	`Decimal`	`Quantity`
11	`Decimal`	`Direct Unit Cost (LCY)`
12	`Decimal`	`Unit Cost (LCY)`
13	`Decimal`	`Total Cost (LCY)`
14	`Decimal`	`Unit Price (LCY)`
15	`Decimal`	`Total Price (LCY)`
16	`Code[20]`	`Resource Group No.`
17	`Code[10]`	`Unit of Measure Code`
20	`Code[10]`	`Location Code`
29	`Date`	`Last Date Modified`
30	`Code[50]`	`User ID`
32	`Code[10]`	`Work Type Code`
33	`Code[10]`	`Customer Price Group`
79	`Code[10]`	`Country/Region Code`
80	`Code[20]`	`Gen. Bus. Posting Group`
81	`Code[20]`	`Gen. Prod. Posting Group`
83	`Date`	`Document Date`
1000	`Code[20]`	`Job Task No.`
1001	`Decimal`	`Line Amount (LCY)`
1002	`Decimal`	`Unit Cost`
1003	`Decimal`	`Total Cost`
1004	`Decimal`	`Unit Price`
1005	`Decimal`	`Total Price`
1006	`Decimal`	`Line Amount`
1007	`Decimal`	`Line Discount Amount`
1008	`Decimal`	`Line Discount Amount (LCY)`
1015	`Decimal`	`Cost Factor`
1019	`Code[50]`	`Serial No.`
1020	`Code[50]`	`Lot No.`
1021	`Decimal`	`Line Discount %`
1022	`Enum Job Planning Line Line Type`	`Line Type`
1023	`Code[10]`	`Currency Code`
1024	`Date`	`Currency Date`
1025	`Decimal`	`Currency Factor`
1026	`Boolean`	`Schedule Line`
1027	`Boolean`	`Contract Line`
1030	`Integer`	`Job Contract Entry No.`
1035	`Decimal`	`Invoiced Amount (LCY)`
1036	`Decimal`	`Invoiced Cost Amount (LCY)`
1037	`Decimal`	`VAT Unit Price`
1038	`Decimal`	`VAT Line Discount Amount`
1039	`Decimal`	`VAT Line Amount`
1041	`Decimal`	`VAT %`
1042	`Text[50]`	`Description 2`
1043	`Integer`	`Job Ledger Entry No.`
1048	`Enum Job Planning Line Status`	`Status`
1050	`Enum Job Ledger Entry Type`	`Ledger Entry Type`
1051	`Integer`	`Ledger Entry No.`
1052	`Boolean`	`System-Created Entry`
1053	`Boolean`	`Usage Link`
1060	`Decimal`	`Remaining Qty.`
1061	`Decimal`	`Remaining Qty. (Base)`
1062	`Decimal`	`Remaining Total Cost`
1063	`Decimal`	`Remaining Total Cost (LCY)`
1064	`Decimal`	`Remaining Line Amount`
1065	`Decimal`	`Remaining Line Amount (LCY)`
1070	`Decimal`	`Qty. Posted`
1071	`Decimal`	`Qty. to Transfer to Journal`
1072	`Decimal`	`Posted Total Cost`
1073	`Decimal`	`Posted Total Cost (LCY)`
1074	`Decimal`	`Posted Line Amount`
1075	`Decimal`	`Posted Line Amount (LCY)`
1080	`Decimal`	`Qty. Transferred to Invoice`
1081	`Decimal`	`Qty. to Transfer to Invoice`
1090	`Decimal`	`Qty. Invoiced`
1091	`Decimal`	`Qty. to Invoice`
1100	`Decimal`	`Reserved Quantity`
1101	`Decimal`	`Reserved Qty. (Base)`
1102	`Enum Reserve Method`	`Reserve`
1103	`Boolean`	`Planned`
5402	`Code[10]`	`Variant Code`
5403	`Code[20]`	`Bin Code`
5404	`Decimal`	`Qty. per Unit of Measure`
5410	`Decimal`	`Quantity (Base)`
5790	`Date`	`Requested Delivery Date`
5791	`Date`	`Promised Delivery Date`
5794	`Date`	`Planned Delivery Date`
5900	`Code[20]`	`Service Order No.`
6515	`Code[50]`	`Package No.`
7000	`Enum Price Calculation Method`	`Price Calculation Method`
7001	`Enum Price Calculation Method`	`Cost Calculation Method`
70257710	`Integer`	`WSB_PMPVersionNo`