Module List > Module UPR tables DD10100
You are currently viewing the COMPANY database.
Change

COMPANY..DD10100 Table Definition

(COMPANY..Direct Deposit Employee Deposits Work)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
EMPLOYID char(15)
''
Employee I...(more) Join Now
join ... more text available
EMPLNAME char(41)
''
Employee N...(more) Join Now
PRINTED tinyint
0
Printed: ...(more) Join Now
VOIDED tinyint
0
Voided: ...(more) Join Now
CHEKDATE datetime
'1/1/1900'
Check Date...(more) Join Now
CHEKNMBR char(21)
''
Check Numb...(more) Join Now
PYADNMBR int
0
Payment/Ad...(more) Join Now
SOCSCNUM char(15)
''
Social Sec...(more) Join Now
NTWPYRN numeric(19,5)
0.00
Net Wages/...(more) Join Now
GRWGPRN numeric(19,5)
0.00
Gross Wage...(more) Join Now
STTPYPRD datetime
'1/1/1900'
Start Pay ...(more) Join Now
ENPAYPRD datetime
'1/1/1900'
End Pay Pe...(more) Join Now
INACTIVE tinyint
0
Inactive: ...(more) Join Now
DDVOIDED tinyint
0
DD Voided:...(more) Join Now
DDMASKDLR tinyint
0
DD Mask Do...(more) Join Now
DDSUPCHK smallint
0
DD Suppres...(more) Join Now
DDNBRACCTS smallint
0
DD Number ...(more) Join Now
DDATRXCODE_1 char(3)
''
DD Array12...(more) Join Now
DDATRXCODE_2 char(3)
''
DD Array12...(more) Join Now
DDATRXCODE_3 char(3)
''
DD Array12...(more) Join Now
DDATRXCODE_4 char(3)
''
DD Array12...(more) Join Now
DDATRXCODE_5 char(3)
''
DD Array12...(more) Join Now
DDATRXCODE_6 char(3)
''
DD Array12...(more) Join Now
DDATRXCODE_7 char(3)
''
DD Array12...(more) Join Now
DDATRXCODE_8 char(3)
''
DD Array12...(more) Join Now
DDATRXCODE_9 char(3)
''
DD Array12...(more) Join Now
DDATRXCODE_10 char(3)
''
DD Array12...(more) Join Now
DDATRXCODE_11 char(3)
''
DD Array12...(more) Join Now
DDATRXCODE_12 char(3)
''
DD Array12...(more) Join Now
DDATRANSIT_1 char(9)
''
DD Array12...(more) Join Now
DDATRANSIT_2 char(9)
''
DD Array12...(more) Join Now
DDATRANSIT_3 char(9)
''
DD Array12...(more) Join Now
DDATRANSIT_4 char(9)
''
DD Array12...(more) Join Now
DDATRANSIT_5 char(9)
''
DD Array12...(more) Join Now
DDATRANSIT_6 char(9)
''
DD Array12...(more) Join Now
DDATRANSIT_7 char(9)
''
DD Array12...(more) Join Now
DDATRANSIT_8 char(9)
''
DD Array12...(more) Join Now
DDATRANSIT_9 char(9)
''
DD Array12...(more) Join Now
DDATRANSIT_10 char(9)
''
DD Array12...(more) Join Now
DDATRANSIT_11 char(9)
''
DD Array12...(more) Join Now
DDATRANSIT_12 char(9)
''
DD Array12...(more) Join Now
DDAACCOUNT_1 char(17)
''
DD Array12...(more) Join Now
DDAACCOUNT_2 char(17)
''
DD Array12...(more) Join Now
DDAACCOUNT_3 char(17)
''
DD Array12...(more) Join Now
DDAACCOUNT_4 char(17)
''
DD Array12...(more) Join Now
DDAACCOUNT_5 char(17)
''
DD Array12...(more) Join Now
DDAACCOUNT_6 char(17)
''
DD Array12...(more) Join Now
DDAACCOUNT_7 char(17)
''
DD Array12...(more) Join Now
DDAACCOUNT_8 char(17)
''
DD Array12...(more) Join Now
DDAACCOUNT_9 char(17)
''
DD Array12...(more) Join Now
DDAACCOUNT_10 char(17)
''
DD Array12...(more) Join Now
DDAACCOUNT_11 char(17)
''
DD Array12...(more) Join Now
DDAACCOUNT_12 char(17)
''
DD Array12...(more) Join Now
DDAAMOUNT_1 numeric(19,5)
0.00

DDAAMOUNT_2 numeric(19,5)
0.00
DD Array12...(more) Join Now
DDAAMOUNT_3 numeric(19,5)
0.00
DD Array12...(more) Join Now
DDAAMOUNT_4 numeric(19,5)
0.00
DD Array12...(more) Join Now
DDAAMOUNT_5 numeric(19,5)
0.00
DD Array12...(more) Join Now
DDAAMOUNT_6 numeric(19,5)
0.00
DD Array12...(more) Join Now
DDAAMOUNT_7 numeric(19,5)
0.00
DD Array12...(more) Join Now
DDAAMOUNT_8 numeric(19,5)
0.00
DD Array12...(more) Join Now
DDAAMOUNT_9 numeric(19,5)
0.00
DD Array12...(more) Join Now
DDAAMOUNT_10 numeric(19,5)
0.00
DD Array12...(more) Join Now
DDAAMOUNT_11 numeric(19,5)
0.00
DD Array12...(more) Join Now
DDAAMOUNT_12 numeric(19,5)
0.00
DD Array12...(more) Join Now
ERRDESCR char(131)
''
Error Desc...(more) Join Now
USERID char(15)
''
The user t...(more) Join Now
join ... more text available
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
3