PA01501 - PA Users Master | Prospr - Dynamics GP Table Reference

PA01501 - PA Users Master

Query Builder

Select * from PA01501

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
USERID	User ID	String	16	View
PAddltssysetp	PA DDL System Setup - TS	Integer	2	View
PAtsemid	PA Employee ID - TS	String	16	View
PAtsemcid	PA Employee Class ID - TS	String	16	View
PAATPTSv20	PA Allow TRX Posting - TS	Boolean	2	View
PAABPTSv20	PA Allow Batch Posting - TS	Boolean	2	View
PAADETSv20	PA Allow Description Entry - TS	Boolean	2	View
PAddlELlsysetp	PA DDL System Setup - EL	Integer	2	View
PAEQPTCLIDEL	PA Equipment Class ID - EL	String	16	View
PA_Equipment_ID_EL	PA Equipment ID - EL	String	16	View
PAATPEL	PA Allow TRX Posting - EL	Boolean	2	View
PAABPEL	PA Allow Batch Posting - EL	Boolean	2	View
PAADEEL	PA Allow Description Entry - EL	Boolean	2	View
PAddlMLsysetup	PA DDL System Setup - ML	Integer	2	View
PAMLclid	PA Miscellaneous Class ID - ML	String	16	View
PAALLTRXPOSTML	PA Allow TRX Posting - ML	Boolean	2	View
PAMLallbtpst	PA Allow Batch Posting - ML	Boolean	2	View
PAMLade	PA Allow Description Entry - ML	Boolean	2	View
PAddlposysetup	PA DDL System Setup - PO	Integer	2	View
PApovendclid	PA Vendor Class ID - PO	String	16	View
PApoade	PA Allow Description Entry - PO	Boolean	2	View
PAALLPRNTPOv20	PA Allow PO Printing	Boolean	2	View
PAALLCLOSEPOv20	PA Allow PO Closing	Boolean	2	View
PAAllowTRXPostingIV	PA Allow TRX Posting - IV	Boolean	2	View
PAAllowBatchPostingIV	PA Allow Batch Posting - IV	Boolean	2	View
PAAllowBillNoteEntryIV	PA Allow Description Entry - IV	Boolean	2	View
PAAllowChangeBillTypeIV	PA Allow Change in Bill Type - IV	Boolean	2	View
PAddlvisysetup	PA DDL System Setup - VI	Integer	2	View
PAvivendclid	PA Vendor Class ID - VI	String	16	View
PAATPVIv20	PA Allow TRX Posting - VI	Boolean	2	View
PAABPVIv20	PA Allow Batch Posting - VI	Boolean	2	View
PAADEVIv20	PA Allow Description Entry - VI	Boolean	2	View
PAddlersysetup	PA DDL System Setup - EE	Integer	2	View
PAermepid	PA Employee ID - EE	String	16	View
PAeremclid	PA Employee Class ID - EE	String	16	View
PAALLTRXPOSTEEv20	PA Allow TRX Posting - EE	Boolean	2	View
PAALLBTPOSTEEv20	PA Allow Batch Posting - EE	Boolean	2	View
PAALLDEEEEv20	PA Allow Description Entry - EE	Boolean	2	View
PAcustclassbill	PA Customer Class - Biller	String	16	View
PAcustnumbill	PA Customer Number - Biller	String	16	View
PAddlsysetpbill	PA DDL System Setup - Biller	Integer	2	View
PAallowbtchpostbill	PA Allow Batch Posting - Biller	Boolean	2	View
PAallowtrxpostbill	PA Allow TRX Posting - Biller	Boolean	2	View
PAELALLWCHGBLLTYPE	PA Allow Change in Bill Type - EL	Boolean	2	View
PAALLWCHGBLLTYPEEE	PA Allow Change in Bill Type - EE	Boolean	2	View
PAALLWCHGBLLTYPEML	PA Allow Change in Bill Type - ML	Boolean	2	View
PAALLWCHGBLLTYPETS	PA Allow Change in Bill Type - TS	Boolean	2	View
PAALLWCHGBLLTYPEVI	PA Allow Change in Bill Type - VI	Boolean	2	View
PAAllow_ChangePaycode	PA Allow Change Paycode	Boolean	2	View
PAChangeJobTitle	PA Allow Change Job Title	Boolean	2	View
PAAllowChangeDepartment	PA Allow Change Department	Boolean	2	View
PAELALLCGEBRATE	PA Allow Change Billing Rate - EL	Boolean	2	View
PAALLCHGBRATEEE	PA Allow Change Billing Rate - EE	Boolean	2	View
PAALLCHGBRATEML	PA Allow Change Billing Rate - ML	Boolean	2	View
PAAllowChangeBillRateIV	PA Allow Change Billing Rate - IV	Boolean	2	View
PAALLCHGBRATETS	PA Allow Change Billing Rate - TS	Boolean	2	View
PAALLCHGBRATEVI	PA Allow Change Billing Rate - VI	Boolean	2	View
PAAssign_LookupEL	PA Assign Lookup - EL	Boolean	2	View
PAAssign_LookupEE	PA Assign Lookup - EE	Boolean	2	View
PAAssign_LookupTS	PA Assign Lookup - TS	Boolean	2	View
PA_Default_Doc_Date_TS	PA Default Doc Date - TS	Integer	2	View
PA_Default_DocDateEL	PA Default Doc Date - EL	Integer	2	View
PA_Default_Doc_Date_ML	PA Default Doc Date - ML	Integer	2	View
PA_Default_Doc_Date_PO	PA Default Doc Date - PO	Integer	2	View
PA_Default_Doc_Date_IV	PA Default Doc Date - IV	Integer	2	View
PA_Default_Doc_Date_VI	PA Default Doc Date - VI	Integer	2	View
PA_Default_Doc_Date_EE	PA Default Doc Date - EE	Integer	2	View
PA_Default_Doc_Date_BL	PA Default Doc Date - Biller	Integer	2	View
PATRX_Line_Date_FromTS	PA TRX Line Date From - TS	Integer	2	View
PATRX_Line_Date_FromEL	PA TRX Line Date From - EL	Integer	2	View
PATRX_Line_Date_FromML	PA TRX Line Date From - ML	Integer	2	View
PATRX_Line_Date_FromEE	PA TRX Line Date From - EE	Integer	2	View
PALLOWCHGSTATUS	PA Allow Change Status	Boolean	2	View
PAAllowSetCloseProjBill	PA Allow Set Close to Project Billings	Boolean	2	View
PAAllowSETProjCost	PA Allow Set Close to Project Costs	Boolean	2	View
PAeraeonbi	PA Allow Entry of New Budg Items - EE	Boolean	2	View
PAELaeonbi	PA Allow Entry of New Budg Items - EL	Boolean	2	View
PAMLaeonbi	PA Allow Entry of New Budg Items - ML	Boolean	2	View
PAtsaeondi	PA Allow Entry of New Budg Items - TS	Boolean	2	View
PANewMatItemsIV	PA Allow Entry of New Material Items - IV	Boolean	2	View
PANewMatItemsPI	PA Allow Entry of New Material Items - PI	Boolean	2	View
PANewMatItemsPO	PA Allow Entry of New Material Items - PO	Boolean	2	View
PALLOWNONEPROJEE	PA Allow Entry of None Project - EE	Boolean	2	View
PALLWNONEPROJEL	PA Allow Entry of None Project - EL	Boolean	2	View
PALLWNONEPROJIV	PA Allow Entry of None Project - IV	Boolean	2	View
PALLWNONEPROJML	PA Allow Entry of None Project - ML	Boolean	2	View
PALLWNONEPROJPO	PA Allow Entry of None Project - PO	Boolean	2	View
PALLWNONEPROJTS	PA Allow Entry of None Project - TS	Boolean	2	View
PALLWNONEPROJVI	PA Allow Entry of None Project - VI	Boolean	2	View
PAALLCRETCO	PA Allow Create Change Orders	Boolean	2	View
APALLWAPPRVECO	PA Allow Approve Change Orders	Boolean	2	View
PAALLWCHGFRCST	PA Allow Change to Forecast	Boolean	2	View
PAAllowBlankProjandCCPO	PA Allow Blank Proj and CC - PO	Boolean	2	View
PAAllowBlankProjandCCVI	PA Allow Blank Proj and CC - VI	Boolean	2	View

PA01501 - PA Users Master

Query Builder

Customer Service

Information

My Account

Contact Us