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

COMPANY..UPR10100 Table Definition

(COMPANY..Payroll Year End Header)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
RPTNGYR smallint
0

EPRIDNBR char(9)
''

YENDCRTD tinyint
0

ESTIDNBR char(21)
''

LOCATNID char(15)
''
Location I...(more) Join Now
join ... more text available
CMPNYNAM char(65)
''
Company Na...(more) Join Now POP10100.CMPNYNAM
ADDRESS1 char(61)
''

ADDRESS2 char(61)
''

ADDRESS3 char(61)
''

CITY char(35)
''
City: City...(more) Join Now
STATE char(29)
''

ZIPCODE char(11)
''
Zip Code: ...(more) Join Now
INACW2RN tinyint
0

YEPRW2SK smallint
0

YPMQGEW2 smallint
0

YP1099RS smallint
0

FICASSTR int
0

FICASSWL numeric(19,5)
0.00

TICAMTRT int
0

FICAMWLM numeric(19,5)
0.00

EICMXWHG numeric(19,5)
0.00

Establishment_Type smallint
0

Establishment_Number char(5)
''

Charged_Tips numeric(19,5)
0.00

Charged_Receipts numeric(19,5)
0.00

Indirect_Tips numeric(19,5)
0.00

Direct_Tips numeric(19,5)
0.00

RECEIPTS numeric(19,5)
0.00

Directly_Tipped smallint
0

Return_Type smallint
0

Reported_Tips numeric(19,5)
0.00

ALOCTIPS numeric(19,5)
0.00

EmployerKind smallint
0

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
PHONE1 char
''

Employer_SelfInsured tinyint
0

PayerKind smallint
0

W2Published tinyint
0

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