Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
EMPLOYID | Employee ID |
String | 16 | View | |
EMPLNAME | Employee Name |
String | 42 | View | |
PRINTED | Printed |
Boolean | 2 | View | |
VOIDED | Voided |
Boolean | 2 | View | |
CHEKDATE | Check Date |
Date | 4 | View | |
CHEKNMBR | Check Number |
String | 22 | View | |
PYADNMBR | Payment/Adjustment Number |
Long Integer | 4 | View | |
SOCSCNUM | Social Security Number |
String | 16 | View | |
NTWPYRN | Net Wages/Pay Run |
Currency | 10 | View | |
GRWGPRN | Gross Wages/Pay Run |
Currency | 10 | View | |
STTPYPRD | Start Pay Period |
Date | 4 | View | |
ENPAYPRD | End Pay Period |
Date | 4 | View | |
INACTIVE | Inactive |
Boolean | 2 | View | |
DDVOIDED | DD Voided |
Boolean | 2 | View | |
DDMASKDLR | DD Mask Dollar |
Boolean | 2 | View | |
DDSUPCHK | DD Suppress Check |
Integer | 2 | View | |
DDNBRACCTS | DD Number of Accounts |
Integer | 2 | View | |
DDATRXCODE_1 | DD Array12 Transaction Code[1] |
String | 4 | View | |
DDATRXCODE_2 | DD Array12 Transaction Code[2] |
String | 4 | View | |
DDATRXCODE_3 | DD Array12 Transaction Code[3] |
String | 4 | View | |
DDATRXCODE_4 | DD Array12 Transaction Code[4] |
String | 4 | View | |
DDATRXCODE_5 | DD Array12 Transaction Code[5] |
String | 4 | View | |
DDATRXCODE_6 | DD Array12 Transaction Code[6] |
String | 4 | View | |
DDATRXCODE_7 | DD Array12 Transaction Code[7] |
String | 4 | View | |
DDATRXCODE_8 | DD Array12 Transaction Code[8] |
String | 4 | View | |
DDATRXCODE_9 | DD Array12 Transaction Code[9] |
String | 4 | View | |
DDATRXCODE_10 | DD Array12 Transaction Code[10] |
String | 4 | View | |
DDATRXCODE_11 | DD Array12 Transaction Code[11] |
String | 4 | View | |
DDATRXCODE_12 | DD Array12 Transaction Code[12] |
String | 4 | View | |
DDATRANSIT_1 | DD Array12 Transit Number[1] |
String | 10 | View | |
DDATRANSIT_2 | DD Array12 Transit Number[2] |
String | 10 | View | |
DDATRANSIT_3 | DD Array12 Transit Number[3] |
String | 10 | View | |
DDATRANSIT_4 | DD Array12 Transit Number[4] |
String | 10 | View | |
DDATRANSIT_5 | DD Array12 Transit Number[5] |
String | 10 | View | |
DDATRANSIT_6 | DD Array12 Transit Number[6] |
String | 10 | View | |
DDATRANSIT_7 | DD Array12 Transit Number[7] |
String | 10 | View | |
DDATRANSIT_8 | DD Array12 Transit Number[8] |
String | 10 | View | |
DDATRANSIT_9 | DD Array12 Transit Number[9] |
String | 10 | View | |
DDATRANSIT_10 | DD Array12 Transit Number[10] |
String | 10 | View | |
DDATRANSIT_11 | DD Array12 Transit Number[11] |
String | 10 | View | |
DDATRANSIT_12 | DD Array12 Transit Number[12] |
String | 10 | View | |
DDAACCOUNT_1 | DD Array12 Account Number[1] |
String | 18 | View | |
DDAACCOUNT_2 | DD Array12 Account Number[2] |
String | 18 | View | |
DDAACCOUNT_3 | DD Array12 Account Number[3] |
String | 18 | View | |
DDAACCOUNT_4 | DD Array12 Account Number[4] |
String | 18 | View | |
DDAACCOUNT_5 | DD Array12 Account Number[5] |
String | 18 | View | |
DDAACCOUNT_6 | DD Array12 Account Number[6] |
String | 18 | View | |
DDAACCOUNT_7 | DD Array12 Account Number[7] |
String | 18 | View | |
DDAACCOUNT_8 | DD Array12 Account Number[8] |
String | 18 | View | |
DDAACCOUNT_9 | DD Array12 Account Number[9] |
String | 18 | View | |
DDAACCOUNT_10 | DD Array12 Account Number[10] |
String | 18 | View | |
DDAACCOUNT_11 | DD Array12 Account Number[11] |
String | 18 | View | |
DDAACCOUNT_12 | DD Array12 Account Number[12] |
String | 18 | View | |
DDAAMOUNT_1 | DD Array12 Amount[1] |
Currency | 10 | View | |
DDAAMOUNT_2 | DD Array12 Amount[2] |
Currency | 10 | View | |
DDAAMOUNT_3 | DD Array12 Amount[3] |
Currency | 10 | View | |
DDAAMOUNT_4 | DD Array12 Amount[4] |
Currency | 10 | View | |
DDAAMOUNT_5 | DD Array12 Amount[5] |
Currency | 10 | View | |
DDAAMOUNT_6 | DD Array12 Amount[6] |
Currency | 10 | View | |
DDAAMOUNT_7 | DD Array12 Amount[7] |
Currency | 10 | View | |
DDAAMOUNT_8 | DD Array12 Amount[8] |
Currency | 10 | View | |
DDAAMOUNT_9 | DD Array12 Amount[9] |
Currency | 10 | View | |
DDAAMOUNT_10 | DD Array12 Amount[10] |
Currency | 10 | View | |
DDAAMOUNT_11 | DD Array12 Amount[11] |
Currency | 10 | View | |
DDAAMOUNT_12 | DD Array12 Amount[12] |
Currency | 10 | View | |
ERRDESCR | Error Description |
String | 132 | View | |
USERID | User ID |
String | 16 | View |