| AUCTRLCD |
char(13)
''
|
|
|
|
|
| CHEKNMBR |
char(21)
''
|
|
|
|
|
| PYADNMBR |
int
0
|
Payment/Ad...(more) Join Now
|
|
|
|
| VOIDED |
tinyint
0
|
Voided TRU...(more) Join Now
|
CM20100.VOIDED
|
|
|
| CHEKDATE |
datetime
'1/1/1900'
|
Check Date...(more) Join Now
|
PM10000.CHEKDATE
|
|
|
| POSTEDDT |
datetime
'1/1/1900'
|
Posted Dat...(more) Join Now
|
RM10301.POSTEDDT
|
|
|
| EMPLOYID |
char(15)
''
|
Employee I...(more) Join Now
|
|
|
join ... more text available
|
| EMPLNAME |
char(41)
''
|
|
|
|
|
| GRWGPRN |
numeric(19,5)
0.00
|
Gross Wage...(more) Join Now
|
|
|
|
| FDWDGPRN |
numeric(19,5)
0.00
|
Federal Wi...(more) Join Now
|
|
|
|
| FDTXTIPS |
numeric(19,5)
0.00
|
Federal Ti...(more) Join Now
|
|
|
|
| FICAMWPR |
numeric(19,5)
0.00
|
FICA/Medic...(more) Join Now
|
|
|
|
| FICMTPTX |
numeric(19,5)
0.00
|
FICA/Med T...(more) Join Now
|
|
|
|
| Uncollected_FICAMed_TaxP |
numeric(19,5)
0.00
|
Uncollecte...(more) Join Now
|
|
|
|
| FCASWPR |
numeric(19,5)
0.00
|
FICA/Socia...(more) Join Now
|
|
|
|
| FICSTPTX |
numeric(19,5)
0.00
|
FICA/SS Ta...(more) Join Now
|
|
|
|
| Uncollected_FICASS_TaxP |
numeric(19,5)
0.00
|
Uncollecte...(more) Join Now
|
|
|
|
| ADEICPMT |
numeric(19,5)
0.00
|
Advance EI...(more) Join Now
|
|
|
|
| Reported_Tips |
numeric(19,5)
0.00
|
|
|
|
|
| Charged_Tips |
numeric(19,5)
0.00
|
|
|
|
|
| ALOCTIPS |
numeric(19,5)
0.00
|
Allocated ...(more) Join Now
|
|
|
|
| TTLDDTNS |
numeric(19,5)
0.00
|
Total Dedu...(more) Join Now
|
|
|
|
| TTLBNFTS |
numeric(19,5)
0.00
|
Taxable Be...(more) Join Now
|
|
|
|
| NTWPYRN |
numeric(19,5)
0.00
|
div>span s...(more) Join Now
|
|
|
|
| CHEKBKID |
char(15)
''
|
Checkbook ID Checkbook this transaction affects
|
SY30500.CHEKBKID
|
|
join ... more text available
|
| DEPRTMNT |
char(7)
''
|
Department...(more) Join Now
|
|
|
join ... more text available
|
| SOCSCNUM |
char(15)
''
|
|
|
|
|
| VACTMACC |
numeric(19,5)
0.00
|
Vacation T...(more) Join Now
|
|
|
|
| VACTMLBL |
numeric(19,5)
0.00
|
Vacation T...(more) Join Now
|
|
|
|
| VACAVLBL |
int
0
|
Vaca...(more) Join Now
|
|
|
|
| SKTMACCR |
numeric(19,5)
0.00
|
Sick Time ...(more) Join Now
|
|
|
|
| SKTMLBTY |
numeric(19,5)
0.00
|
Sick Time ...(more) Join Now
|
|
|
|
| SIKTIMAV |
int
0
|
Sick Time ...(more) Join Now
|
|
|
|
| TOTLTAXS |
numeric(19,5)
0.00
|
Total Taxe...(more) Join Now
|
|
|
|
| Voided_by_Void_Checks |
tinyint
0
|
|
|
|
|
| FDWGPYRN |
numeric(19,5)
0.00
|
Federal Wa...(more) Join Now
|
|
|
|
| Federal_TipsPay_Run |
numeric(19,5)
0.00
|
|
|
|
|
| FICASSWP |
numeric(19,5)
0.00
|
FICA/Socia...(more) Join Now
|
|
|
|
| FICASS_TipsPay_Run |
numeric(19,5)
0.00
|
FICA/SS Ti...(more) Join Now
|
|
|
|
| FICAMWGP |
numeric(19,5)
0.00
|
FICA/Medic...(more) Join Now
|
|
|
|
| FICAMed_TipsPay_Run |
numeric(19,5)
0.00
|
|
|
|
|
| Reported_Receipts |
numeric(19,5)
0.00
|
|
|
|
|
| Charged_Receipts |
numeric(19,5)
0.00
|
|
|
|
|
| YEAR1 |
smallint
0
|
Year: The ...(more) Join Now
|
|
|
|
| ISCHECK |
tinyint
0
|
|
|
|
|
| RSNCHKVD |
char(31)
''
|
Reason Che...(more) Join Now
|
|
|
|
| COMPPYRN |
smallint
0
|
Computer P...(more) Join Now
|
|
|
|
| EFICASSWH |
numeric
0.00
|
Employer F...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
| EFICASS_Tax_On_Tips |
numeric
0.00
|
Employer F...(more) Join Now
|
|
|
|
| EFICAMWPR |
numeric
0.00
|
Employer F...(more) Join Now
|
|
|
|
| EFICAMed_Tax_On_Tips |
numeric
0.00
|
|
|
|
|
| PayPeriodBeginDate |
datetime
'1/1/1900'
|
|
|
|
|
| PayPeriodEndDate |
datetime
'1/1/1900'
|
|
|
|
|