PA Users Master (PA01501)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA01501

Product: Project Accounting (258)
Series: System

Display Name: PA Users Master
Physical Name: PA01501
Technical Name: PA_Users_MSTR

Group Display Name: PA Cards
Group Technical Name: PA Cards

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1USERID SearchUser IDSTR15_User_IDString15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['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
2PAddltssysetp SearchPA DDL System Setup - TSPA_DDL_System_Setup-TSInteger0
3PAtsemid SearchPA Employee ID - TSSTR15_Employee_IDString15
4PAtsemcid SearchPA Employee Class ID - TSSTR15_Employee_ClassString15
5PAATPTSv20 SearchPA Allow TRX Posting - TSPA_CB_Allow_Transaction_PostingBoolean0
6PAABPTSv20 SearchPA Allow Batch Posting - TSPA_CB_Allow_Batch_PostingBoolean0
7PAADETSv20 SearchPA Allow Description Entry - TSPA_CB_Allow_Description_EntryBoolean0
8PAddlELlsysetp SearchPA DDL System Setup - ELPA_DDL_System_Setup-ELInteger0
9PAEQPTCLIDEL SearchPA Equipment Class ID - ELSTR15_Equipment_Class_IDString15
10PA_Equipment_ID_EL SearchPA Equipment ID - ELSTR15_Equipment_IDString15
11PAATPEL SearchPA Allow TRX Posting - ELPA_CB_Allow_Transaction_PostingBoolean0
12PAABPEL SearchPA Allow Batch Posting - ELPA_CB_Allow_Batch_PostingBoolean0
13PAADEEL SearchPA Allow Description Entry - ELPA_CB_Allow_Description_EntryBoolean0
14PAddlMLsysetup SearchPA DDL System Setup - MLPA_DDL_System_Setup-MLInteger0
15PAMLclid SearchPA Miscellaneous Class ID - MLSTR15_Equipment_Class_IDString15
16PAALLTRXPOSTML SearchPA Allow TRX Posting - MLPA_CB_Allow_Transaction_PostingBoolean0
17PAMLallbtpst SearchPA Allow Batch Posting - MLPA_CB_Allow_Batch_PostingBoolean0
18PAMLade SearchPA Allow Description Entry - MLPA_CB_Allow_Description_EntryBoolean0
19PAddlposysetup SearchPA DDL System Setup - POPA_DDL_System_Setup-POInteger0
20PApovendclid SearchPA Vendor Class ID - POSTR15_Vendor_Class_IDString15
21PApoade SearchPA Allow Description Entry - POPA_CB_Allow_Description_EntryBoolean0
22PAALLPRNTPOv20 SearchPA Allow PO PrintingPA_CB_Allow_Print_POBoolean0
23PAALLCLOSEPOv20 SearchPA Allow PO ClosingPA_CB_Allow_Close_POBoolean0
24PAAllowTRXPostingIV SearchPA Allow TRX Posting - IVPA_CB_Allow_Transaction_PostingBoolean0
25PAAllowBatchPostingIV SearchPA Allow Batch Posting - IVPA_CB_Allow_Batch_PostingBoolean0
26PAAllowBillNoteEntryIV SearchPA Allow Description Entry - IVPA_CB_Allow_Description_EntryBoolean0
27PAAllowChangeBillTypeIV SearchPA Allow Change in Bill Type - IVPA_CB_Allow_Change_Billing_TypeBoolean0
28PAddlvisysetup SearchPA DDL System Setup - VIPA_DDL_System_Setup-VIInteger0
29PAvivendclid SearchPA Vendor Class ID - VISTR15_Vendor_Class_IDString15
30PAATPVIv20 SearchPA Allow TRX Posting - VIPA_CB_Allow_Transaction_PostingBoolean0
31PAABPVIv20 SearchPA Allow Batch Posting - VIPA_CB_Allow_Batch_PostingBoolean0
32PAADEVIv20 SearchPA Allow Description Entry - VIPA_CB_Allow_Description_EntryBoolean0
33PAddlersysetup SearchPA DDL System Setup - EEPA_DDL_System_Setup-EEInteger0
34PAermepid SearchPA Employee ID - EESTR15_Employee_IDString15
35PAeremclid SearchPA Employee Class ID - EESTR15_Employee_ClassString15
36PAALLTRXPOSTEEv20 SearchPA Allow TRX Posting - EEPA_CB_Allow_Transaction_PostingBoolean0
37PAALLBTPOSTEEv20 SearchPA Allow Batch Posting - EEPA_CB_Allow_Batch_PostingBoolean0
38PAALLDEEEEv20 SearchPA Allow Description Entry - EEPA_CB_Allow_Description_EntryBoolean0
39PAcustclassbill SearchPA Customer Class - BillerSTR15_Customer_ClassString15
40PAcustnumbill SearchPA Customer Number - BillerSTR15_Customer_NumberString15
41PAddlsysetpbill SearchPA DDL System Setup - BillerPA_DDL_System_Setup-BillerInteger0
42PAallowbtchpostbill SearchPA Allow Batch Posting - BillerPA_CB_Allow_Batch_PostingBoolean0
43PAallowtrxpostbill SearchPA Allow TRX Posting - BillerPA_CB_Allow_Transaction_PostingBoolean0
44PAELALLWCHGBLLTYPE SearchPA Allow Change in Bill Type - ELPA_CB_Allow_Change_Billing_TypeBoolean0
45PAALLWCHGBLLTYPEEE SearchPA Allow Change in Bill Type - EEPA_CB_Allow_Change_Billing_TypeBoolean0
46PAALLWCHGBLLTYPEML SearchPA Allow Change in Bill Type - MLPA_CB_Allow_Change_Billing_TypeBoolean0
47PAALLWCHGBLLTYPETS SearchPA Allow Change in Bill Type - TSPA_CB_Allow_Change_Billing_TypeBoolean0
48PAALLWCHGBLLTYPEVI SearchPA Allow Change in Bill Type - VIPA_CB_Allow_Change_Billing_TypeBoolean0
49PAAllow_ChangePaycode SearchPA Allow Change PaycodePA_CB_Allow_CHG_PayCodeBoolean0
50PAChangeJobTitle SearchPA Allow Change Job TitlePA_CB_Allow_CHG_Job_TitleBoolean0
51PAAllowChangeDepartment SearchPA Allow Change DepartmentPA_CB_Allow_CHG_DepartmentBoolean0
52PAELALLCGEBRATE SearchPA Allow Change Billing Rate - ELPA_CB_Allow_Change_Billing_RateBoolean0
53PAALLCHGBRATEEE SearchPA Allow Change Billing Rate - EEPA_CB_Allow_Change_Billing_RateBoolean0
54PAALLCHGBRATEML SearchPA Allow Change Billing Rate - MLPA_CB_Allow_Change_Billing_RateBoolean0
55PAAllowChangeBillRateIV SearchPA Allow Change Billing Rate - IVPA_CB_Allow_Change_Billing_RateBoolean0
56PAALLCHGBRATETS SearchPA Allow Change Billing Rate - TSPA_CB_Allow_Change_Billing_RateBoolean0
57PAALLCHGBRATEVI SearchPA Allow Change Billing Rate - VIPA_CB_Allow_Change_Billing_RateBoolean0
58PAAssign_LookupEL SearchPA Assign Lookup - ELPA_CB_Use_Assign_LookupBoolean0
59PAAssign_LookupEE SearchPA Assign Lookup - EEPA_CB_Use_Assign_LookupBoolean0
60PAAssign_LookupTS SearchPA Assign Lookup - TSPA_CB_Use_Assign_LookupBoolean0
61PA_Default_Doc_Date_TS SearchPA Default Doc Date - TSDDL_Default_DateInteger0
62PA_Default_DocDateEL SearchPA Default Doc Date - ELDDL_Default_DateInteger0
63PA_Default_Doc_Date_ML SearchPA Default Doc Date - MLDDL_Default_DateInteger0
64PA_Default_Doc_Date_PO SearchPA Default Doc Date - PODDL_Default_DateInteger0
65PA_Default_Doc_Date_IV SearchPA Default Doc Date - IVDDL_Default_DateInteger0
66PA_Default_Doc_Date_VI SearchPA Default Doc Date - VIDDL_Default_DateInteger0
67PA_Default_Doc_Date_EE SearchPA Default Doc Date - EEDDL_Default_DateInteger0
68PA_Default_Doc_Date_BL SearchPA Default Doc Date - BillerDDL_Default_DateInteger0
69PATRX_Line_Date_FromTS SearchPA TRX Line Date From - TSPA_DDL_Trx_DateInteger0
70PATRX_Line_Date_FromEL SearchPA TRX Line Date From - ELPA_DDL_Trx_DateInteger0
71PATRX_Line_Date_FromML SearchPA TRX Line Date From - MLPA_DDL_Trx_DateInteger0
72PATRX_Line_Date_FromEE SearchPA TRX Line Date From - EEPA_DDL_Trx_DateInteger0
73PALLOWCHGSTATUS SearchPA Allow Change StatusPA_CB_Allow_Change_StatusBoolean0
74PAAllowSetCloseProjBill SearchPA Allow Set Close to Project BillingsPA_CB_Allow_Set_Close_Project_BillingsBoolean0
75PAAllowSETProjCost SearchPA Allow Set Close to Project CostsPA_CB_Allow_Set_Close_Project_CostsBoolean0
76PAeraeonbi SearchPA Allow Entry of New Budg Items - EEPA_CB_Allow_Entry_New_Budg_ItemsBoolean0
77PAELaeonbi SearchPA Allow Entry of New Budg Items - ELPA_CB_Allow_Entry_New_Budg_ItemsBoolean0
78PAMLaeonbi SearchPA Allow Entry of New Budg Items - MLPA_CB_Allow_Entry_New_Budg_ItemsBoolean0
79PAtsaeondi SearchPA Allow Entry of New Budg Items - TSPA_CB_Allow_Entry_New_Budg_ItemsBoolean0
80PANewMatItemsIV SearchPA Allow Entry of New Material Items - IVpaCBAllowEntryNewMaterialItemsBoolean0
81PANewMatItemsPI SearchPA Allow Entry of New Material Items - PIpaCBAllowEntryNewMaterialItemsBoolean0
82PANewMatItemsPO SearchPA Allow Entry of New Material Items - POpaCBAllowEntryNewMaterialItemsBoolean0
83PALLOWNONEPROJEE SearchPA Allow Entry of None Project - EEPA_CB_Allow_Entry_None_ProjectBoolean0
84PALLWNONEPROJEL SearchPA Allow Entry of None Project - ELPA_CB_Allow_Entry_None_ProjectBoolean0
85PALLWNONEPROJIV SearchPA Allow Entry of None Project - IVPA_CB_Allow_Entry_None_ProjectBoolean0
86PALLWNONEPROJML SearchPA Allow Entry of None Project - MLPA_CB_Allow_Entry_None_ProjectBoolean0
87PALLWNONEPROJPO SearchPA Allow Entry of None Project - POPA_CB_Allow_Entry_None_ProjectBoolean0
88PALLWNONEPROJTS SearchPA Allow Entry of None Project - TSPA_CB_Allow_Entry_None_ProjectBoolean0
89PALLWNONEPROJVI SearchPA Allow Entry of None Project - VIPA_CB_Allow_Entry_None_ProjectBoolean0
90PAALLCRETCO SearchPA Allow Create Change OrdersPA_CB_Allow_Create_Change_OrdersBoolean0
91APALLWAPPRVECO SearchPA Allow Approve Change OrdersPA_CB_Allow_Approve_Change_OrdersBoolean0
92PAALLWCHGFRCST SearchPA Allow Change to ForecastPA_CB_Allow_Change_To_ForecastBoolean0
93PAAllowBlankProjandCCPO SearchPA Allow Blank Proj and CC - POPA_CB_Allow_Blank_Proj_CCBoolean0
94PAAllowBlankProjandCCVI SearchPA Allow Blank Proj and CC - VIPA_CB_Allow_Blank_Proj_CCBoolean0
95PADDLSysSetupREQ SearchPA DDL System Setup REQPA_DDL_System_Setup-POInteger0
96PAVendorClassIDREQ SearchPA Vendor Class ID REQSTR15_Vendor_Class_IDString15
97PADefaultDocDateREQ SearchPA Default Doc Date REQDDL_Default_DateInteger0
98PAAllowDespEntryREQ SearchPA Allow Descriptions Entry REQPA_CB_Allow_Description_EntryBoolean0
99PANewMatItemsREQ SearchPA Allow Entry of New Material Items REQpaCBAllowEntryNewMaterialItemsBoolean0
100PAAllowBlankProjandCCREQ SearchPA Allow Blank Proj and CC REQPA_CB_Allow_Blank_Proj_CCBoolean0
101DEX_ROW_ID Searchintint10

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

Leave a Reply

Your email address will not be published. Required fields are marked *