Module List >
Module UPR tables
UPR10100
You are currently viewing the COMPANY
database.
Change
|
COMPANY..UPR10100 Table Definition
(COMPANY..Payroll Year End Header)
Field Definitions:
What is the 'source' column?
| 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
|
|
|
|
|
|