APR_APR30300 - APR Pay Run History
SQL Query Builder
46 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| USERID | char(15) '' | |||
| ACTINDX | Links to GL00105 to get the full concatenated account number and description. This is the primary key for account lookups across all modules. | int 0 | ||
| AUCTRLCD | char(13) '' | |||
| BLDCHDID | char(15) '' | |||
| BLDCHKDT | datetime '1/1/1900' | |||
| BLDCHTIM | datetime '1/1/1900' | |||
| PYRNTYPE | smallint 0 | |||
| COMPPYRN | smallint 0 | |||
| EMPCLRNG | smallint 0 | |||
| STTEMPCL | char(15) '' | |||
| ENEMPCLS | char(15) '' | |||
| EMPIDRNG | smallint 0 | |||
| STTEMPID | char(15) '' | |||
| ENDEMPL | char(15) '' | |||
| PYRNSTDT | datetime '1/1/1900' | |||
| PYRNENDT | datetime '1/1/1900' | |||
| PYRNIWLY | tinyint 0 | |||
| PYRNIBWK | tinyint 0 | |||
| PRNISMLY | tinyint 0 | |||
| PYRNIMLY | tinyint 0 | |||
| PYRNIQLY | tinyint 0 | |||
| PYRNISAN | tinyint 0 | |||
| PYRNIANN | tinyint 0 | |||
| PYRNIDMS | tinyint 0 | |||
| PYRNISRY | tinyint 0 | |||
| PYRNIPSN | tinyint 0 | |||
| PYRNIEIC | tinyint 0 | |||
| PYRNIPTP | smallint 0 | |||
| PYRNIDED | smallint 0 | |||
| PYRNIBFT | smallint 0 | |||
| DAYSWRDK | int 0 | |||
| WKSWRKD | int 0 | |||
| BLCHWREX | tinyint 0 | |||
| BDCHEREX | tinyint 0 | |||
| PRCHKPTD | tinyint 0 | |||
| PYRLCHPS | tinyint 0 | |||
| CHEKDATE | datetime '1/1/1900' | |||
| POSTEDDT | datetime '1/1/1900' | |||
| NUMOFTRX | int 0 | |||
| NUMOFEMP | smallint 0 | |||
| CNTRLTRX | int 0 | |||
| CTRLEMPCT | smallint 0 | |||
| APPROVL | tinyint 0 | |||
| APPRVLDT | datetime '1/1/1900' | |||
| APRVLUSERID | char(15) '' | |||
| DEX_ROW_ID | int auto number (1,1) |
Related Tables
Tables that share columns with APR_APR30300. Click "Join" to add to your query.