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 BS tables B3980270
You are currently viewing the COMPANY database.
Change

COMPANY..B3980270 Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
CMPNYNAM char(65)
''
Company Na...(more) Join Now POP10100.CMPNYNAM
EMPLOYID char(15)
''
Employee I...(more) Join Now UPR00100.EMPLOYID
join ... more text available
DEPRTMNT char(7)
''
Department...(more) Join Now TATX1030.DEPRTMNT
join ... more text available
JOBTITLE char(7)
''
Job Title:...(more) Join Now TATX1030.JOBTITLE
INTXSHAN tinyint
0

SOCSCNUM char(15)
''

LASTNAME char(21)
''
Last Name:...(more) Join Now UPR00100.LASTNAME
FRSTNAME char(15)
''

MIDLNAME char(15)
''

MNTHSWGS numeric(19,5)
0.00

WKSWRKD int
0

YEARWAGS numeric(19,5)
0.00

MTDTXBWG numeric(19,5)
0.00

YTDTXWGS numeric(19,5)
0.00

FUSUTXRT int
0

FUSUWLMT numeric(19,5)
0.00

SUTASTAT char(3)
''
Suta State...(more) Join Now UPR00400.SUTASTAT
SUTAMTDT numeric(19,5)
0.00

EMPCOUNT smallint
0

WGTPCOMP numeric(19,5)
0.00

FEDITXWH numeric(19,5)
0.00

FITXWHAD numeric(19,5)
0.00

SSECWAGS numeric(19,5)
0.00

FICASSTR int
0

SSECTAX numeric(19,5)
0.00

TXBLTIPS numeric(19,5)
0.00

TXONTIPS numeric(19,5)
0.00

MCRWGTPS numeric(19,5)
0.00

TICAMTRT int
0

MDICRTAX numeric(19,5)
0.00

FICATXTL numeric(19,5)
0.00

FRCTNERR char(15)
''

FICATXFERR numeric(19,5)
0.00

FICA_Tax_Other_Adj numeric(19,5)
0.00

FICATTAD numeric(19,5)
0.00

TAXTOTAL numeric(19,5)
0.00

EICPYQTD numeric(19,5)
0.00

TXNETQTD numeric(19,5)
0.00

FIL941SB char(1)
''

LIA941M1_1 numeric(19,5)
0.00

LIA941M1_2 numeric(19,5)
0.00

LIA941M1_3 numeric(19,5)
0.00

LIA941M1_4 numeric(19,5)
0.00

LIA941M1_5 numeric(19,5)
0.00

LIA941M1_6 numeric(19,5)
0.00

LIA941M1_7 numeric(19,5)
0.00

LIA941M1_8 numeric(19,5)
0.00

LIA941M1_9 numeric(19,5)
0.00

LIA941M1_10 numeric(19,5)
0.00

LIA941M1_11 numeric(19,5)
0.00

LIA941M1_12 numeric(19,5)
0.00

LIA941M1_13 numeric(19,5)
0.00

LIA941M1_14 numeric(19,5)
0.00

LIA941M1_15 numeric(19,5)
0.00

LIA941M1_16 numeric(19,5)
0.00

LIA941M1_17 numeric(19,5)
0.00

LIA941M1_18 numeric(19,5)
0.00

LIA941M1_19 numeric(19,5)
0.00

LIA941M1_20 numeric(19,5)
0.00

LIA941M1_21 numeric(19,5)
0.00

LIA941M1_22 numeric(19,5)
0.00

LIA941M1_23 numeric(19,5)
0.00

LIA941M1_24 numeric(19,5)
0.00

LIA941M1_25 numeric(19,5)
0.00

LIA941M1_26 numeric(19,5)
0.00

LIA941M1_27 numeric(19,5)
0.00

LIA941M1_28 numeric(19,5)
0.00

LIA941M1_29 numeric(19,5)
0.00

LIA941M1_30 numeric(19,5)
0.00

LIA941M1_31 numeric(19,5)
0.00

LIA941M2_1 numeric(19,5)
0.00

LIA941M2_2 numeric(19,5)
0.00

LIA941M2_3 numeric(19,5)
0.00

LIA941M2_4 numeric(19,5)
0.00

LIA941M2_5 numeric(19,5)
0.00

LIA941M2_6 numeric(19,5)
0.00

LIA941M2_7 numeric(19,5)
0.00

LIA941M2_8 numeric(19,5)
0.00

LIA941M2_9 numeric(19,5)
0.00

LIA941M2_10 numeric(19,5)
0.00

LIA941M2_11 numeric(19,5)
0.00

LIA941M2_12 numeric(19,5)
0.00

LIA941M2_13 numeric(19,5)
0.00

LIA941M2_14 numeric(19,5)
0.00

LIA941M2_15 numeric(19,5)
0.00

LIA941M2_16 numeric(19,5)
0.00

LIA941M2_17 numeric(19,5)
0.00

LIA941M2_18 numeric(19,5)
0.00

LIA941M2_19 numeric(19,5)
0.00

LIA941M2_20 numeric(19,5)
0.00

LIA941M2_21 numeric(19,5)
0.00

LIA941M2_22 numeric(19,5)
0.00

LIA941M2_23 numeric(19,5)
0.00

LIA941M2_24 numeric(19,5)
0.00

LIA941M2_25 numeric(19,5)
0.00

LIA941M2_26 numeric(19,5)
0.00

LIA941M2_27 numeric(19,5)
0.00

LIA941M2_28 numeric(19,5)
0.00

LIA941M2_29 numeric(19,5)
0.00

LIA941M2_30 numeric(19,5)
0.00

LIA941M2_31 numeric(19,5)
0.00

LIA941M3_1 numeric(19,5)
0.00

LIA941M3_2 numeric(19,5)
0.00

LIA941M3_3 numeric(19,5)
0.00

LIA941M3_4 numeric(19,5)
0.00

LIA941M3_5 numeric(19,5)
0.00

LIA941M3_6 numeric(19,5)
0.00

LIA941M3_7 numeric(19,5)
0.00

LIA941M3_8 numeric(19,5)
0.00

LIA941M3_9 numeric(19,5)
0.00

LIA941M3_10 numeric(19,5)
0.00

LIA941M3_11 numeric(19,5)
0.00

LIA941M3_12 numeric(19,5)
0.00

LIA941M3_13 numeric(19,5)
0.00

LIA941M3_14 numeric(19,5)
0.00

LIA941M3_15 numeric(19,5)
0.00

LIA941M3_16 numeric(19,5)
0.00

LIA941M3_17 numeric(19,5)
0.00

LIA941M3_18 numeric(19,5)
0.00

LIA941M3_19 numeric(19,5)
0.00

LIA941M3_20 numeric(19,5)
0.00

LIA941M3_21 numeric(19,5)
0.00

LIA941M3_22 numeric(19,5)
0.00

LIA941M3_23 numeric(19,5)
0.00

LIA941M3_24 numeric(19,5)
0.00

LIA941M3_25 numeric(19,5)
0.00

LIA941M3_26 numeric(19,5)
0.00

LIA941M3_27 numeric(19,5)
0.00

LIA941M3_28 numeric(19,5)
0.00

LIA941M3_29 numeric(19,5)
0.00

LIA941M3_30 numeric(19,5)
0.00

LIA941M3_31 numeric(19,5)
0.00

TXLBTYM1 numeric(19,5)
0.00

TXLBTYM2 numeric(19,5)
0.00

TXLBTYM3 numeric(19,5)
0.00

TXLBTYTL numeric(19,5)
0.00

EIDNBRYE char(11)
''

QRTRENDT datetime
'1/1/1900'

WRKRCOMP char(7)
''
Workers Co...(more) Join Now UPR00400.WRKRCOMP
MNTHHRS numeric(19,5)
0.00

MTDDYWKD numeric(19,5)
0.00

MONTHTAX numeric(19,5)
0.00

STATECD char(3)
''
State Code...(more) Join Now UPR00300.STATECD
DSCRIPTN char(31)
''

SEQNUMBR int
0
Sequence N...(more) Join Now POP10340.SEQNUMBR
INACTIVE tinyint
0
Inactive: ...(more) Join Now UPR00100.INACTIVE
HOURSWKD int
0

Employee_Cobra1 smallint
0

COBRA_Premium_Total1 numeric(19,5)
0.00

BSSI_Facility_ID char(67)
''

EXEMPTFICAWAGE numeric(19,5)
0.00

EXEMPTFICAWAGEMAR numeric(19,5)
0.00

NOEXEMPTEMPMAR int
0

NOQUALQTR int
0

TOTQUALQTR int
0

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