DynDeveloper.com

DynDeveloper.com
Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now! Log In
Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
Module List > Module PA tables PA41701
You are currently viewing the COMPANY database.
Change

COMPANY..PA41701 Table Definition

(COMPANY..PA Project Budget Setup)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
PAsetupkey smallint
0

PAcontractdefined1 char(15)
''

PAcontractdefined2 char(15)
''

PAcostcatdefined1 char(15)
''

PAcostcatdefined2 char(15)
''

PAcustomerdefined1 char(15)
''

PAcustomerdefined2 char(15)
''

PAemployeedefined1 char(15)
''

PAemployeedefined2 char(15)
''

PAvendordefinedprompt1 char(15)
''

PAvendordefinedprompt2 char(15)
''

PAMISCdefined1 char(15)
''

PAMISCLdefined2 char(15)
''

PAprojectdefined1 char(15)
''

PAprojectdefined2 char(15)
''

PAEQUIPTdefined1 char(15)
''

PAEQUIPTdefined2 char(15)
''

PAUserDefinedPrompt1Fee char(15)
''

PAUserDefinedPrompt2Fee char(15)
''

PAcontractstatus_1 char(13)
''

PAcontractstatus_2 char(13)
''

PAcontractstatus_3 char(13)
''

PAcontractstatus_4 char(13)
''

PAcontractstatus_5 char(13)
''

PAcontractstatus_6 char(13)
''

PAcontractstatus_7 char(13)
''

PAcontractstatus_8 char(13)
''

PAcontractstatus_9 char(13)
''

PAcontractstatus_10 char(13)
''

PACONTSTATCB_1 tinyint
0

PACONTSTATCB_2 tinyint
0

PACONTSTATCB_3 tinyint
0

PACONTSTATCB_4 tinyint
0

PACONTSTATCB_5 tinyint
0

PACONTSTATCB_6 tinyint
0

PACONTSTATCB_7 tinyint
0

PACONTSTATCB_8 tinyint
0

PACONTSTATCB_9 tinyint
0

PACONTSTATCB_10 tinyint
0

PAprojectstatus_1 char(13)
''

PAprojectstatus_2 char(13)
''

PAprojectstatus_3 char(13)
''

PAprojectstatus_4 char(13)
''

PAprojectstatus_5 char(13)
''

PAprojectstatus_6 char(13)
''

PAprojectstatus_7 char(13)
''

PAprojectstatus_8 char(13)
''

PAprojectstatus_9 char(13)
''

PAprojectstatus_10 char(13)
''

PAPORJSTATCB_1 tinyint
0

PAPORJSTATCB_2 tinyint
0

PAPORJSTATCB_3 tinyint
0

PAPORJSTATCB_4 tinyint
0

PAPORJSTATCB_5 tinyint
0

PAPORJSTATCB_6 tinyint
0

PAPORJSTATCB_7 tinyint
0

PAPORJSTATCB_8 tinyint
0

PAPORJSTATCB_9 tinyint
0

PAPORJSTATCB_10 tinyint
0

PAUsePayCodes tinyint
0

DECPLQTY smallint
0
 Decimal Pl...(more) Join Now
DECPLCUR smallint
0
 Number of ...(more) Join Now
TM_WIP_SRC smallint
0
TM WIP SRC...(more) Join Now PA01301.TM_WIP_SRC
TM_COGS_SRC smallint
0
TM COGS SR...(more) Join Now PA01301.TM_COGS_SRC
TM_Cost_Contra_SRC smallint
0
M Cost Con...(more) Join Now PA01301.TM_Cost_Contra_SRC
TM_Unbilled_AR_SRC smallint
0
TM Unbille...(more) Join Now PA01301.TM_Unbilled_AR_SRC
TM_Unbilled_Rev_SRC smallint
0
TM Unbille...(more) Join Now PA01301.TM_Unbilled_Rev_SRC
TM_AR_SRC smallint
0
TM AR SRC ...(more) Join Now PA01301.TM_AR_SRC
TM_Prj_Rev_SRC smallint
0
TM Prj Rev...(more) Join Now PA01301.TM_Prj_Rev_SRC
TM_OVHD_SRC smallint
0
TM OVHD SR...(more) Join Now PA01301.TM_OVHD_SRC
FF_WIP_SRC smallint
0
FF WIP SRC...(more) Join Now PA01301.FF_WIP_SRC
FF_Cost_Contra_SRC smallint
0
FF Cost Co...(more) Join Now PA01301.FF_Cost_Contra_SRC
FF_AR_SRC smallint
0
FF AR SRC ...(more) Join Now PA01301.FF_AR_SRC
FF_Prj_Billings_SRC smallint
0
FF Prj Bil...(more) Join Now PA01301.FF_Prj_Billings_SRC
FF_Prj_Expense_SRC smallint
0
FF Prj Exp...(more) Join Now PA01301.FF_Prj_Expense_SRC
FF_Prj_Revenue_SRC smallint
0
FF Prj Rev...(more) Join Now PA01301.FF_Prj_Revenue_SRC
FF_Prj_Loss_SRC smallint
0
FF Prj Los...(more) Join Now PA01301.FF_Prj_Loss_SRC
FF_BIEE_SRC smallint
0
FF BIEE SR...(more) Join Now PA01301.FF_BIEE_SRC
FF_EIEB_SRC smallint
0
FF EIEB SR...(more) Join Now PA01301.FF_EIEB_SRC
FF_OVHD_SRC smallint
0
FF OVHD SR...(more) Join Now PA01301.FF_OVHD_SRC
TM_Prj_Deferred_Rev_Fee_ smallint
0
TM Prj Def...(more) Join Now
TM_Prj_Rev_Fee_SRC smallint
0
TM Prj Rev...(more) Join Now
TM_AR_Fee_SRC smallint
0
TM AR Fee ...(more) Join Now
TM_BIEE_Fee_SRC smallint
0

TM_EIEB_Fee_SRC smallint
0

FF_WIP_Fee_SRC smallint
0
FF WIP Fee...(more) Join Now
FF_Prj_Billings_Fee_SRC smallint
0
FF Prj Bil...(more) Join Now
PAFF_AR_Fee_SRC smallint
0
FF AR Fee ...(more) Join Now
FF_Prj_Rev_Fee_SRC smallint
0
FF Prj Rev...(more) Join Now
FF_Retention_Fee_SRC smallint
0
FF Retenti...(more) Join Now
FF_Prj_Deferred_Rev_Fee_ smallint
0
FF Prj Def...(more) Join Now
FF_BIEE_Fee_SRC smallint
0
FF BIEE Fe...(more) Join Now
FF_EIEB_Fee_SRC smallint
0
FF EIEB Fe...(more) Join Now
PAINCPRCHTXPRJCST tinyint
0

PATRKCHGORDS tinyint
0

PATRKCOBDGADDFLY tinyint
0

PAallow_1 tinyint
0

PAallow_2 tinyint
0

PAallow_3 tinyint
0

PAallow_4 tinyint
0

PAallow_5 tinyint
0

PAallow_6 tinyint
0

PAallow_7 tinyint
0

PAallow_8 tinyint
0

PAallow_9 tinyint
0

PAallow_10 tinyint
0

PAallow_11 tinyint
0

PAallow_12 tinyint
0

PAallow_13 tinyint
0

PApasswordoptions_1 char(11)
''

PApasswordoptions_2 char(11)
''

PApasswordoptions_3 char(11)
''

PApasswordoptions_4 char(11)
''

PApasswordoptions_5 char(11)
''

PApasswordoptions_6 char(11)
''

PApasswordoptions_7 char(11)
''

PApasswordoptions_8 char(11)
''

PApasswordoptions_9 char(11)
''

PApasswordoptions_10 char(11)
''

PApasswordoptions_11 char(11)
''

PApasswordoptions_12 char(11)
''

PApasswordoptions_13 char(11)
''

PAdexcriptionoptions_1 char(51)
''

PAdexcriptionoptions_2 char(51)
''

PAdexcriptionoptions_3 char(51)
''

PAdexcriptionoptions_4 char(51)
''

PAdexcriptionoptions_5 char(51)
''

PAdexcriptionoptions_6 char(51)
''

PAdexcriptionoptions_7 char(51)
''

PAdexcriptionoptions_8 char(51)
''

PAdexcriptionoptions_9 char(51)
''

PAdexcriptionoptions_10 char(51)
''

PAdexcriptionoptions_11 char(51)
''

PAdexcriptionoptions_12 char(51)
''

PAdexcriptionoptions_13 char(51)
''

DEX_ROW_ID int
auto number (1,1)
 Unique ide...(more) Join Now
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
Archives | Table Listing | eConnect Error Database | eConnect Schema | Gold Star Locksmith
3