Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA01501
Product: Project Accounting (258)
Series:
Display Name: PA Users Master
Physical Name: PA01501
Technical Name: PA_Users_MSTR
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | USERID | User ID | String | STR15_User_ID | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['PA Users Master'].USERID AS 'PA Users Master-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
PA01501 AS ['PA Users Master']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['PA Users Master'].USERID = ['Users Master'].USERID | ||||||
2 | PAddltssysetp | PA DDL System Setup - TS | Integer | PA_DDL_System_Setup-TS | 0 | |
3 | PAtsemid | PA Employee ID - TS | String | STR15_Employee_ID | 15 | |
4 | PAtsemcid | PA Employee Class ID - TS | String | STR15_Employee_Class | 15 | |
5 | PAATPTSv20 | PA Allow TRX Posting - TS | Boolean | PA_CB_Allow_Transaction_Posting | 0 | |
6 | PAABPTSv20 | PA Allow Batch Posting - TS | Boolean | PA_CB_Allow_Batch_Posting | 0 | |
7 | PAADETSv20 | PA Allow Description Entry - TS | Boolean | PA_CB_Allow_Description_Entry | 0 | |
8 | PAddlELlsysetp | PA DDL System Setup - EL | Integer | PA_DDL_System_Setup-EL | 0 | |
9 | PAEQPTCLIDEL | PA Equipment Class ID - EL | String | STR15_Equipment_Class_ID | 15 | |
10 | PA_Equipment_ID_EL | PA Equipment ID - EL | String | STR15_Equipment_ID | 15 | |
11 | PAATPEL | PA Allow TRX Posting - EL | Boolean | PA_CB_Allow_Transaction_Posting | 0 | |
12 | PAABPEL | PA Allow Batch Posting - EL | Boolean | PA_CB_Allow_Batch_Posting | 0 | |
13 | PAADEEL | PA Allow Description Entry - EL | Boolean | PA_CB_Allow_Description_Entry | 0 | |
14 | PAddlMLsysetup | PA DDL System Setup - ML | Integer | PA_DDL_System_Setup-ML | 0 | |
15 | PAMLclid | PA Miscellaneous Class ID - ML | String | STR15_Equipment_Class_ID | 15 | |
16 | PAALLTRXPOSTML | PA Allow TRX Posting - ML | Boolean | PA_CB_Allow_Transaction_Posting | 0 | |
17 | PAMLallbtpst | PA Allow Batch Posting - ML | Boolean | PA_CB_Allow_Batch_Posting | 0 | |
18 | PAMLade | PA Allow Description Entry - ML | Boolean | PA_CB_Allow_Description_Entry | 0 | |
19 | PAddlposysetup | PA DDL System Setup - PO | Integer | PA_DDL_System_Setup-PO | 0 | |
20 | PApovendclid | PA Vendor Class ID - PO | String | STR15_Vendor_Class_ID | 15 | |
21 | PApoade | PA Allow Description Entry - PO | Boolean | PA_CB_Allow_Description_Entry | 0 | |
22 | PAALLPRNTPOv20 | PA Allow PO Printing | Boolean | PA_CB_Allow_Print_PO | 0 | |
23 | PAALLCLOSEPOv20 | PA Allow PO Closing | Boolean | PA_CB_Allow_Close_PO | 0 | |
24 | PAAllowTRXPostingIV | PA Allow TRX Posting - IV | Boolean | PA_CB_Allow_Transaction_Posting | 0 | |
25 | PAAllowBatchPostingIV | PA Allow Batch Posting - IV | Boolean | PA_CB_Allow_Batch_Posting | 0 | |
26 | PAAllowBillNoteEntryIV | PA Allow Description Entry - IV | Boolean | PA_CB_Allow_Description_Entry | 0 | |
27 | PAAllowChangeBillTypeIV | PA Allow Change in Bill Type - IV | Boolean | PA_CB_Allow_Change_Billing_Type | 0 | |
28 | PAddlvisysetup | PA DDL System Setup - VI | Integer | PA_DDL_System_Setup-VI | 0 | |
29 | PAvivendclid | PA Vendor Class ID - VI | String | STR15_Vendor_Class_ID | 15 | |
30 | PAATPVIv20 | PA Allow TRX Posting - VI | Boolean | PA_CB_Allow_Transaction_Posting | 0 | |
31 | PAABPVIv20 | PA Allow Batch Posting - VI | Boolean | PA_CB_Allow_Batch_Posting | 0 | |
32 | PAADEVIv20 | PA Allow Description Entry - VI | Boolean | PA_CB_Allow_Description_Entry | 0 | |
33 | PAddlersysetup | PA DDL System Setup - EE | Integer | PA_DDL_System_Setup-EE | 0 | |
34 | PAermepid | PA Employee ID - EE | String | STR15_Employee_ID | 15 | |
35 | PAeremclid | PA Employee Class ID - EE | String | STR15_Employee_Class | 15 | |
36 | PAALLTRXPOSTEEv20 | PA Allow TRX Posting - EE | Boolean | PA_CB_Allow_Transaction_Posting | 0 | |
37 | PAALLBTPOSTEEv20 | PA Allow Batch Posting - EE | Boolean | PA_CB_Allow_Batch_Posting | 0 | |
38 | PAALLDEEEEv20 | PA Allow Description Entry - EE | Boolean | PA_CB_Allow_Description_Entry | 0 | |
39 | PAcustclassbill | PA Customer Class - Biller | String | STR15_Customer_Class | 15 | |
40 | PAcustnumbill | PA Customer Number - Biller | String | STR15_Customer_Number | 15 | |
41 | PAddlsysetpbill | PA DDL System Setup - Biller | Integer | PA_DDL_System_Setup-Biller | 0 | |
42 | PAallowbtchpostbill | PA Allow Batch Posting - Biller | Boolean | PA_CB_Allow_Batch_Posting | 0 | |
43 | PAallowtrxpostbill | PA Allow TRX Posting - Biller | Boolean | PA_CB_Allow_Transaction_Posting | 0 | |
44 | PAELALLWCHGBLLTYPE | PA Allow Change in Bill Type - EL | Boolean | PA_CB_Allow_Change_Billing_Type | 0 | |
45 | PAALLWCHGBLLTYPEEE | PA Allow Change in Bill Type - EE | Boolean | PA_CB_Allow_Change_Billing_Type | 0 | |
46 | PAALLWCHGBLLTYPEML | PA Allow Change in Bill Type - ML | Boolean | PA_CB_Allow_Change_Billing_Type | 0 | |
47 | PAALLWCHGBLLTYPETS | PA Allow Change in Bill Type - TS | Boolean | PA_CB_Allow_Change_Billing_Type | 0 | |
48 | PAALLWCHGBLLTYPEVI | PA Allow Change in Bill Type - VI | Boolean | PA_CB_Allow_Change_Billing_Type | 0 | |
49 | PAAllow_ChangePaycode | PA Allow Change Paycode | Boolean | PA_CB_Allow_CHG_PayCode | 0 | |
50 | PAChangeJobTitle | PA Allow Change Job Title | Boolean | PA_CB_Allow_CHG_Job_Title | 0 | |
51 | PAAllowChangeDepartment | PA Allow Change Department | Boolean | PA_CB_Allow_CHG_Department | 0 | |
52 | PAELALLCGEBRATE | PA Allow Change Billing Rate - EL | Boolean | PA_CB_Allow_Change_Billing_Rate | 0 | |
53 | PAALLCHGBRATEEE | PA Allow Change Billing Rate - EE | Boolean | PA_CB_Allow_Change_Billing_Rate | 0 | |
54 | PAALLCHGBRATEML | PA Allow Change Billing Rate - ML | Boolean | PA_CB_Allow_Change_Billing_Rate | 0 | |
55 | PAAllowChangeBillRateIV | PA Allow Change Billing Rate - IV | Boolean | PA_CB_Allow_Change_Billing_Rate | 0 | |
56 | PAALLCHGBRATETS | PA Allow Change Billing Rate - TS | Boolean | PA_CB_Allow_Change_Billing_Rate | 0 | |
57 | PAALLCHGBRATEVI | PA Allow Change Billing Rate - VI | Boolean | PA_CB_Allow_Change_Billing_Rate | 0 | |
58 | PAAssign_LookupEL | PA Assign Lookup - EL | Boolean | PA_CB_Use_Assign_Lookup | 0 | |
59 | PAAssign_LookupEE | PA Assign Lookup - EE | Boolean | PA_CB_Use_Assign_Lookup | 0 | |
60 | PAAssign_LookupTS | PA Assign Lookup - TS | Boolean | PA_CB_Use_Assign_Lookup | 0 | |
61 | PA_Default_Doc_Date_TS | PA Default Doc Date - TS | Integer | DDL_Default_Date | 0 | |
62 | PA_Default_DocDateEL | PA Default Doc Date - EL | Integer | DDL_Default_Date | 0 | |
63 | PA_Default_Doc_Date_ML | PA Default Doc Date - ML | Integer | DDL_Default_Date | 0 | |
64 | PA_Default_Doc_Date_PO | PA Default Doc Date - PO | Integer | DDL_Default_Date | 0 | |
65 | PA_Default_Doc_Date_IV | PA Default Doc Date - IV | Integer | DDL_Default_Date | 0 | |
66 | PA_Default_Doc_Date_VI | PA Default Doc Date - VI | Integer | DDL_Default_Date | 0 | |
67 | PA_Default_Doc_Date_EE | PA Default Doc Date - EE | Integer | DDL_Default_Date | 0 | |
68 | PA_Default_Doc_Date_BL | PA Default Doc Date - Biller | Integer | DDL_Default_Date | 0 | |
69 | PATRX_Line_Date_FromTS | PA TRX Line Date From - TS | Integer | PA_DDL_Trx_Date | 0 | |
70 | PATRX_Line_Date_FromEL | PA TRX Line Date From - EL | Integer | PA_DDL_Trx_Date | 0 | |
71 | PATRX_Line_Date_FromML | PA TRX Line Date From - ML | Integer | PA_DDL_Trx_Date | 0 | |
72 | PATRX_Line_Date_FromEE | PA TRX Line Date From - EE | Integer | PA_DDL_Trx_Date | 0 | |
73 | PALLOWCHGSTATUS | PA Allow Change Status | Boolean | PA_CB_Allow_Change_Status | 0 | |
74 | PAAllowSetCloseProjBill | PA Allow Set Close to Project Billings | Boolean | PA_CB_Allow_Set_Close_Project_Billings | 0 | |
75 | PAAllowSETProjCost | PA Allow Set Close to Project Costs | Boolean | PA_CB_Allow_Set_Close_Project_Costs | 0 | |
76 | PAeraeonbi | PA Allow Entry of New Budg Items - EE | Boolean | PA_CB_Allow_Entry_New_Budg_Items | 0 | |
77 | PAELaeonbi | PA Allow Entry of New Budg Items - EL | Boolean | PA_CB_Allow_Entry_New_Budg_Items | 0 | |
78 | PAMLaeonbi | PA Allow Entry of New Budg Items - ML | Boolean | PA_CB_Allow_Entry_New_Budg_Items | 0 | |
79 | PAtsaeondi | PA Allow Entry of New Budg Items - TS | Boolean | PA_CB_Allow_Entry_New_Budg_Items | 0 | |
80 | PANewMatItemsIV | PA Allow Entry of New Material Items - IV | Boolean | paCBAllowEntryNewMaterialItems | 0 | |
81 | PANewMatItemsPI | PA Allow Entry of New Material Items - PI | Boolean | paCBAllowEntryNewMaterialItems | 0 | |
82 | PANewMatItemsPO | PA Allow Entry of New Material Items - PO | Boolean | paCBAllowEntryNewMaterialItems | 0 | |
83 | PALLOWNONEPROJEE | PA Allow Entry of None Project - EE | Boolean | PA_CB_Allow_Entry_None_Project | 0 | |
84 | PALLWNONEPROJEL | PA Allow Entry of None Project - EL | Boolean | PA_CB_Allow_Entry_None_Project | 0 | |
85 | PALLWNONEPROJIV | PA Allow Entry of None Project - IV | Boolean | PA_CB_Allow_Entry_None_Project | 0 | |
86 | PALLWNONEPROJML | PA Allow Entry of None Project - ML | Boolean | PA_CB_Allow_Entry_None_Project | 0 | |
87 | PALLWNONEPROJPO | PA Allow Entry of None Project - PO | Boolean | PA_CB_Allow_Entry_None_Project | 0 | |
88 | PALLWNONEPROJTS | PA Allow Entry of None Project - TS | Boolean | PA_CB_Allow_Entry_None_Project | 0 | |
89 | PALLWNONEPROJVI | PA Allow Entry of None Project - VI | Boolean | PA_CB_Allow_Entry_None_Project | 0 | |
90 | PAALLCRETCO | PA Allow Create Change Orders | Boolean | PA_CB_Allow_Create_Change_Orders | 0 | |
91 | APALLWAPPRVECO | PA Allow Approve Change Orders | Boolean | PA_CB_Allow_Approve_Change_Orders | 0 | |
92 | PAALLWCHGFRCST | PA Allow Change to Forecast | Boolean | PA_CB_Allow_Change_To_Forecast | 0 | |
93 | PAAllowBlankProjandCCPO | PA Allow Blank Proj and CC - PO | Boolean | PA_CB_Allow_Blank_Proj_CC | 0 | |
94 | PAAllowBlankProjandCCVI | PA Allow Blank Proj and CC - VI | Boolean | PA_CB_Allow_Blank_Proj_CC | 0 | |
95 | PADDLSysSetupREQ | PA DDL System Setup REQ | Integer | PA_DDL_System_Setup-PO | 0 | |
96 | PAVendorClassIDREQ | PA Vendor Class ID REQ | String | STR15_Vendor_Class_ID | 15 | |
97 | PADefaultDocDateREQ | PA Default Doc Date REQ | Integer | DDL_Default_Date | 0 | |
98 | PAAllowDespEntryREQ | PA Allow Descriptions Entry REQ | Boolean | PA_CB_Allow_Description_Entry | 0 | |
99 | PANewMatItemsREQ | PA Allow Entry of New Material Items REQ | Boolean | paCBAllowEntryNewMaterialItems | 0 | |
100 | PAAllowBlankProjandCCREQ | PA Allow Blank Proj and CC REQ | Boolean | PA_CB_Allow_Blank_Proj_CC | 0 |