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

COMPANY..JC20401 Table Definition

(COMPANY..JC_Job_Transaction_Entry_POST)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
USERID char(15)

The user t...(more) Join Now
join ... more text available
BCHSOURC char(15)

Batch Sour...(more) Join Now
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
WS_Job_Number char(17)


WS_Job_Name char(31)


Cost_Code_Number_1 char(7)


Cost_Code_Number_2 char(7)


Cost_Code_Number_3 char(7)


Cost_Code_Number_4 char(7)


Cost_Element smallint


Cost_Code_Description char(31)


ACTINDX int

Account In...(more) Join Now UPR00100.ACTINDX
join ... more text available
OFFINDX int


TRXAMNT numeric(19,5)

TrxAmount Amount of the transaction ME123504.TRXAMNT
TRXQTY numeric(19,5)

TRX QTY: T...(more) Join Now IV10001.TRXQTY
GLLINMSG binary(4)


TRXDATE datetime

TrxDate Transaction Date used when the transaction was posted CM20502.TRXDATE
ACCTTYPE smallint


DSCRIPTN char(31)

Descriptio...(more) Join Now CM20200.DSCRIPTN
PSTGSTUS smallint

Posting St...(more) Join Now RM10301.PSTGSTUS
WSReserved_CB1 tinyint


WSReserved_CB2 tinyint


WSReserved_CB3 tinyint


WSReserved_CB4 tinyint


WSReserved_CB5 tinyint


WSReserved_STR1 char(11)


WSReserved_STR2 char(11)


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