Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
PAsetupkey | PA Setup Key |
Integer | 2 | View | |
PAcontractdefined1 | PA User Defined Prompt 1 - Contract |
String | 16 | View | |
PAcontractdefined2 | PA User Defined Prompt 2 - Contract |
String | 16 | View | |
PAcostcatdefined1 | PA User Defined Prompt 1 - Cost Cat |
String | 16 | View | |
PAcostcatdefined2 | PA User Defined Prompt 2 - Cost Cat |
String | 16 | View | |
PAcustomerdefined1 | PA User Defined Prompt 1 - Customer |
String | 16 | View | |
PAcustomerdefined2 | PA User Defined Prompt 2 - Customer |
String | 16 | View | |
PAemployeedefined1 | PA User Defined Prompt 1 - Employee |
String | 16 | View | |
PAemployeedefined2 | PA User Defined Prompt 2 - Employee |
String | 16 | View | |
PAvendordefinedprompt1 | PA User Defined Prompt 1 - Vendor |
String | 16 | View | |
PAvendordefinedprompt2 | PA User Defined Prompt 2 - Vendor |
String | 16 | View | |
PAMISCdefined1 | PA User Defined Prompt 1 - Miscellaneous |
String | 16 | View | |
PAMISCLdefined2 | PA User Defined Prompt 2 - Miscellaneous |
String | 16 | View | |
PAprojectdefined1 | PA User Defined Prompt 1 - Project |
String | 16 | View | |
PAprojectdefined2 | PA User Defined Prompt 2 - Project |
String | 16 | View | |
PAEQUIPTdefined1 | PA User Defined Prompt 1 - Equipment |
String | 16 | View | |
PAEQUIPTdefined2 | PA User Defined Prompt 2 - Equipment |
String | 16 | View | |
PAUserDefinedPrompt1Fee | PA User Defined Prompt 1 - Fee |
String | 16 | View | |
PAUserDefinedPrompt2Fee | PA User Defined Prompt 2 - Fee |
String | 16 | View | |
PAcontractstatus_1 | PA Contract Status[1] |
String | 14 | View | |
PAcontractstatus_2 | PA Contract Status[2] |
String | 14 | View | |
PAcontractstatus_3 | PA Contract Status[3] |
String | 14 | View | |
PAcontractstatus_4 | PA Contract Status[4] |
String | 14 | View | |
PAcontractstatus_5 | PA Contract Status[5] |
String | 14 | View | |
PAcontractstatus_6 | PA Contract Status[6] |
String | 14 | View | |
PAcontractstatus_7 | PA Contract Status[7] |
String | 14 | View | |
PAcontractstatus_8 | PA Contract Status[8] |
String | 14 | View | |
PAcontractstatus_9 | PA Contract Status[9] |
String | 14 | View | |
PAcontractstatus_10 | PA Contract Status[10] |
String | 14 | View | |
PACONTSTATCB_1 | PA Contract Status CB[1] |
Boolean | 2 | View | |
PACONTSTATCB_2 | PA Contract Status CB[2] |
Boolean | 2 | View | |
PACONTSTATCB_3 | PA Contract Status CB[3] |
Boolean | 2 | View | |
PACONTSTATCB_4 | PA Contract Status CB[4] |
Boolean | 2 | View | |
PACONTSTATCB_5 | PA Contract Status CB[5] |
Boolean | 2 | View | |
PACONTSTATCB_6 | PA Contract Status CB[6] |
Boolean | 2 | View | |
PACONTSTATCB_7 | PA Contract Status CB[7] |
Boolean | 2 | View | |
PACONTSTATCB_8 | PA Contract Status CB[8] |
Boolean | 2 | View | |
PACONTSTATCB_9 | PA Contract Status CB[9] |
Boolean | 2 | View | |
PACONTSTATCB_10 | PA Contract Status CB[10] |
Boolean | 2 | View | |
PAprojectstatus_1 | PA Project Status[1] |
String | 14 | View | |
PAprojectstatus_2 | PA Project Status[2] |
String | 14 | View | |
PAprojectstatus_3 | PA Project Status[3] |
String | 14 | View | |
PAprojectstatus_4 | PA Project Status[4] |
String | 14 | View | |
PAprojectstatus_5 | PA Project Status[5] |
String | 14 | View | |
PAprojectstatus_6 | PA Project Status[6] |
String | 14 | View | |
PAprojectstatus_7 | PA Project Status[7] |
String | 14 | View | |
PAprojectstatus_8 | PA Project Status[8] |
String | 14 | View | |
PAprojectstatus_9 | PA Project Status[9] |
String | 14 | View | |
PAprojectstatus_10 | PA Project Status[10] |
String | 14 | View | |
PAPORJSTATCB_1 | PA Project Status CB[1] |
Boolean | 2 | View | |
PAPORJSTATCB_2 | PA Project Status CB[2] |
Boolean | 2 | View | |
PAPORJSTATCB_3 | PA Project Status CB[3] |
Boolean | 2 | View | |
PAPORJSTATCB_4 | PA Project Status CB[4] |
Boolean | 2 | View | |
PAPORJSTATCB_5 | PA Project Status CB[5] |
Boolean | 2 | View | |
PAPORJSTATCB_6 | PA Project Status CB[6] |
Boolean | 2 | View | |
PAPORJSTATCB_7 | PA Project Status CB[7] |
Boolean | 2 | View | |
PAPORJSTATCB_8 | PA Project Status CB[8] |
Boolean | 2 | View | |
PAPORJSTATCB_9 | PA Project Status CB[9] |
Boolean | 2 | View | |
PAPORJSTATCB_10 | PA Project Status CB[10] |
Boolean | 2 | View | |
PAUsePayCodes | PA Use PayCodes |
Boolean | 2 | View | |
DECPLQTY | Decimal Places QTYS |
Integer | 2 | View | |
DECPLCUR | Decimal Places Currency |
Integer | 2 | View | |
TM_WIP_SRC | TM WIP SRC 1 – None |
Integer | 2 | View | |
TM_COGS_SRC | TM COGS SRC 1 – None |
Integer | 2 | View | |
TM_Cost_Contra_SRC | TM Cost Contra SRC 1 – None |
Integer | 2 | View | |
TM_Unbilled_AR_SRC | TM Unbilled AR SRC 1 – None |
Integer | 2 | View | |
TM_Unbilled_Rev_SRC | TM Unbilled Rev SRC 1 – None |
Integer | 2 | View | |
TM_AR_SRC | TM AR SRC 1 – None |
Integer | 2 | View | |
TM_Prj_Rev_SRC | TM Prj Rev SRC 1 – None |
Integer | 2 | View | |
TM_OVHD_SRC | TM OVHD SRC 1 – None |
Integer | 2 | View | |
FF_WIP_SRC | FF WIP SRC 1 – None |
Integer | 2 | View | |
FF_Cost_Contra_SRC | FF Cost Contra SRC 1 – None |
Integer | 2 | View | |
FF_AR_SRC | FF AR SRC 1 – None |
Integer | 2 | View | |
FF_Prj_Billings_SRC | FF Prj Billings SRC 1 – None |
Integer | 2 | View | |
FF_Prj_Expense_SRC | FF Prj Expense SRC 1 – None |
Integer | 2 | View | |
FF_Prj_Revenue_SRC | FF Prj Revenue SRC 1 – None |
Integer | 2 | View | |
FF_Prj_Loss_SRC | FF Prj Loss SRC 1 – None |
Integer | 2 | View | |
FF_BIEE_SRC | FF BIEE SRC 1 – None |
Integer | 2 | View | |
FF_EIEB_SRC | FF EIEB SRC 1 – None |
Integer | 2 | View | |
FF_OVHD_SRC | FF OVHD SRC 1 – None |
Integer | 2 | View | |
TM_Prj_Deferred_Rev_Fee_ | TM Prj Deferred Rev Fee SRC |
Integer | 2 | View | |
TM_Prj_Rev_Fee_SRC | TM Prj Rev Fee SRC |
Integer | 2 | View | |
TM_AR_Fee_SRC | TM AR Fee SRC |
Integer | 2 | View | |
TM_BIEE_Fee_SRC | TM BIEE Fee SRC |
Integer | 2 | View | |
TM_EIEB_Fee_SRC | TM EIEB Fee SRC |
Integer | 2 | View | |
FF_WIP_Fee_SRC | FF WIP Fee SRC |
Integer | 2 | View | |
FF_Prj_Billings_Fee_SRC | FF Prj Billings Fee SRC |
Integer | 2 | View | |
PAFF_AR_Fee_SRC | FF AR Fee SRC |
Integer | 2 | View | |
FF_Prj_Rev_Fee_SRC | FF Prj Rev Fee SRC |
Integer | 2 | View | |
FF_Retention_Fee_SRC | FF Retention Fee SRC |
Integer | 2 | View | |
FF_Prj_Deferred_Rev_Fee_ | FF Prj Deferred Rev Fee SRC |
Integer | 2 | View | |
FF_BIEE_Fee_SRC | FF BIEE Fee SRC |
Integer | 2 | View | |
FF_EIEB_Fee_SRC | FF EIEB Fee SRC |
Integer | 2 | View | |
PAINCPRCHTXPRJCST | PA Incl Purch Tax Proj Cost |
Boolean | 2 | View | |
PATRKCHGORDS | PA Track Change Orders |
Boolean | 2 | View | |
PATRKCOBDGADDFLY | PA Track CO for Budgets Add on fly |
Boolean | 2 | View | |
PAallow_1 | PA Allow Options[1] |
Boolean | 2 | View | |
PAallow_2 | PA Allow Options[2] |
Boolean | 2 | View | |
PAallow_3 | PA Allow Options[3] |
Boolean | 2 | View | |
PAallow_4 | PA Allow Options[4] |
Boolean | 2 | View | |
PAallow_5 | PA Allow Options[5] |
Boolean | 2 | View | |
PAallow_6 | PA Allow Options[6] |
Boolean | 2 | View | |
PAallow_7 | PA Allow Options[7] |
Boolean | 2 | View | |
PAallow_8 | PA Allow Options[8] |
Boolean | 2 | View | |
PAallow_9 | PA Allow Options[9] |
Boolean | 2 | View | |
PAallow_10 | PA Allow Options[10] |
Boolean | 2 | View | |
PAallow_11 | PA Allow Options[11] |
Boolean | 2 | View | |
PAallow_12 | PA Allow Options[12] |
Boolean | 2 | View | |
PAallow_13 | PA Allow Options[13] |
Boolean | 2 | View | |
PApasswordoptions_1 | PA Password Options[1] |
String | 12 | View | |
PApasswordoptions_2 | PA Password Options[2] |
String | 12 | View | |
PApasswordoptions_3 | PA Password Options[3] |
String | 12 | View | |
PApasswordoptions_4 | PA Password Options[4] |
String | 12 | View | |
PApasswordoptions_5 | PA Password Options[5] |
String | 12 | View | |
PApasswordoptions_6 | PA Password Options[6] |
String | 12 | View | |
PApasswordoptions_7 | PA Password Options[7] |
String | 12 | View | |
PApasswordoptions_8 | PA Password Options[8] |
String | 12 | View | |
PApasswordoptions_9 | PA Password Options[9] |
String | 12 | View | |
PApasswordoptions_10 | PA Password Options[10] |
String | 12 | View | |
PApasswordoptions_11 | PA Password Options[11] |
String | 12 | View | |
PApasswordoptions_12 | PA Password Options[12] |
String | 12 | View | |
PApasswordoptions_13 | PA Password Options[13] |
String | 12 | View | |
PAdexcriptionoptions_1 | PA Description Options[1] |
String | 52 | View | |
PAdexcriptionoptions_2 | PA Description Options[2] |
String | 52 | View | |
PAdexcriptionoptions_3 | PA Description Options[3] |
String | 52 | View | |
PAdexcriptionoptions_4 | PA Description Options[4] |
String | 52 | View | |
PAdexcriptionoptions_5 | PA Description Options[5] |
String | 52 | View | |
PAdexcriptionoptions_6 | PA Description Options[6] |
String | 52 | View | |
PAdexcriptionoptions_7 | PA Description Options[7] |
String | 52 | View | |
PAdexcriptionoptions_8 | PA Description Options[8] |
String | 52 | View | |
PAdexcriptionoptions_9 | PA Description Options[9] |
String | 52 | View | |
PAdexcriptionoptions_10 | PA Description Options[10] |
String | 52 | View | |
PAdexcriptionoptions_11 | PA Description Options[11] |
String | 52 | View | |
PAdexcriptionoptions_12 | PA Description Options[12] |
String | 52 | View | |
PAdexcriptionoptions_13 | PA Description Options[13] |
String | 52 | View |