| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| AUCTRLCD | Audit Control Code |
String | 14 | View | |
| PYADNMBR | Payment/Adjustment Number |
Long Integer | 4 | View | |
| PYRLRTYP | Payroll Record Type 1 = Regular Pay Codes |
Integer | 2 | View | |
| TRXNUMBER | TRX Number |
Long Integer | 4 | View | |
| SEQNUMBR | Sequence Number |
Long Integer | 4 | View | |
| SRCECODE | Source Code |
String | 8 | View | |
| DEPRTMNT | Department |
String | 8 | View | |
| JOBTITLE | Job Title |
String | 8 | View | |
| STATECD | State Code |
String | 4 | View | |
| EMPLOYID | Employee ID |
String | 16 | View | |
| DEBITAMT | Debit Amount |
Currency | 10 | View | |
| CRDTAMNT | Credit Amount |
Currency | 10 | View | |
| ACTINDX | Account Index |
Long Integer | 4 | View | |
| POSTEDDT | Posted Date |
Date | 4 | View | |
| PAYROLCD | Payroll Code |
String | 8 | View | |
| UPRACTYP | UPR Account Type |
Integer | 2 | View |