Module List > Module JC tables JC10703
You are currently viewing the COMPANY database.
Change

COMPANY..JC10703 Table Definition

(COMPANY..JC_Payroll_Post_WORK)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
BACHNUMB char(15)

Batch Numb...(more) Join Now
join ... more text available
JRNENTRY int

Journal En...(more) Join Now GL20000.JRNENTRY
SQNCLINE numeric(19,5)

Sequence L...(more) Join Now VAT10302.SQNCLINE
ACTINDX int

Account In...(more) Join Now UPR00100.ACTINDX
join ... more text available
TRXAMNT numeric(19,5)

TrxAmount Amount of the transaction ME123504.TRXAMNT
EMPLOYID char(15)

Employee I...(more) Join Now UPR00100.EMPLOYID
join ... more text available
DSCRIPTN char(31)

Descriptio...(more) Join Now CM20200.DSCRIPTN
GLLINMSG binary(4)


GLLINMS2 binary(4)


CURRNIDX smallint

Currency I...(more) Join Now CM20200.CURRNIDX
join ... more text available
DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3