Table WSB_PMPJobArchive¶

Obsolete

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

Stores project archive records.

Properties¶

Name	Value
Access	Public
Caption	Project Archive
DataCaptionFields	1,3
DataClassification	CustomerContent
DataPerCompany	True
ObsoleteReason	The Job/Project Archive has been removed as this is now available in the Microsoft Base Application.
ObsoleteState	Removed
ObsoleteTag	1.20.0.0

Fields¶

ID	Type	Name
1	`Code[20]`	`No.`
2	`Code[100]`	`Search Description`
3	`Text[100]`	`Description`
4	`Text[50]`	`Description 2`
5	`Code[20]`	`Bill-to Customer No.`
12	`Date`	`Creation Date`
13	`Date`	`Starting Date`
14	`Date`	`Ending Date`
19	`Enum Job Status`	`Status`
20	`Code[20]`	`Person Responsible`
21	`Code[20]`	`Global Dimension 1 Code`
22	`Code[20]`	`Global Dimension 2 Code`
23	`Code[20]`	`Job Posting Group`
24	`Enum Job Blocked`	`Blocked`
29	`Date`	`Last Date Modified`
30	`Boolean`	`Comment`
31	`Code[20]`	`Customer Disc. Group`
32	`Code[10]`	`Customer Price Group`
41	`Code[10]`	`Language Code`
49	`Decimal`	`Scheduled Res. Qty.`
50	`Code[20]`	`Resource filter`
51	`Date`	`Posting Date filter`
55	`Code[20]`	`Resource Gr. filter`
56	`Decimal`	`Scheduled Res. Gr. Qty.`
58	`Text[100]`	`Bill-to Name`
59	`Text[100]`	`Bill-to Address`
60	`Text[50]`	`Bill-to Address 2`
61	`Text[30]`	`Bill-to City`
63	`Text[30]`	`Bill-to County`
64	`Code[20]`	`Bill-to Post Code`
66	`Code[20]`	`No. Series`
67	`Code[10]`	`Bill-to Country/Region Code`
68	`Text[50]`	`Bill-to Name 2`
117	`Enum Reserve Method`	`Reserve`
140	`Media`	`Image`
1000	`Code[20]`	`WIP Method`
1001	`Code[10]`	`Currency Code`
1002	`Code[20]`	`Bill-to Contact No.`
1003	`Text[100]`	`Bill-to Contact`
1004	`Date`	`Planning Date filter`
1007	`Boolean`	`WIP Entries Exist`
1008	`Date`	`WIP Posting Date`
1011	`Code[10]`	`Invoice Currency Code`
1012	`Option`	`Exch. Calculation (Cost)`
1013	`Option`	`Exch. Calculation (Price)`
1014	`Boolean`	`Allow Schedule/Contract Lines`
1015	`Boolean`	`Complete`
1024	`Date`	`Next Invoice Date`
1025	`Boolean`	`Apply Usage Link`
1026	`Boolean`	`WIP Warnings`
1027	`Option`	`WIP Posting Method`
1030	`Decimal`	`Calc. Recog. Sales Amount`
1031	`Decimal`	`Calc. Recog. Costs Amount`
1032	`Decimal`	`Calc. Recog. Sales G/L Amount`
1033	`Decimal`	`Calc. Recog. Costs G/L Amount`
1035	`Boolean`	`Over Budget`
1036	`Code[50]`	`Project Manager`
7000	`Enum Price Calculation Method`	`Price Calculation Method`
7001	`Enum Price Calculation Method`	`Cost Calculation Method`
70257700	`Integer`	`WSB_PMPVersionNo`
70257730	`Code[20]`	`WSB_GenBusPostingGroupPMP`
70257731	`Code[20]`	`WSB_JobTypePMP`