GP Tables

JC10703 - JC_Payroll_Post_WORK

SQL Query Builder

11 Columns

Column Description Type Length
BACHNUMB char(15)
JRNENTRY int
SQNCLINE numeric(19,5)
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
TRXAMNT numeric(19,5)
EMPLOYID char(15)
DSCRIPTN char(31)
GLLINMSG binary(4)
GLLINMS2 binary(4)
CURRNIDX smallint
DEX_ROW_ID int auto number (1,1)

Related Tables

Tables that share columns with JC10703. Click "Join" to add to your query.

DEX_ROW_ID

AAG00200 AAG00201 AAG00202 AAG00300 AAG00301 AAG00302 ACColumn AF00100

BACHNUMB

APR_APR30000 ASIEXP06 ASIEXP08 ASIEXP09 ASIEXP10 ASIEXP12 ASIEXP19 ASIEXP20

CURRNIDX

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 AAG50001 AAG60001

GLLINMSG