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

COMPANY..JC30202 Table Definition

(COMPANY..JC_Job_TRX_HDR_HIST)

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
BCHSOURC char(15)

Batch Sour...(more) Join Now
JRNENTRY int

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

Recurring ...(more) Join Now GL20000.RCTRXSEQ
SOURCDOC char(11)

Field values: 1= Invoice 2= Finance Charge 3= Miscellaneous Charges 4= Return 5= Credit Memo PP000001.SOURCDOC
REFRENCE char(31)

Reference:...(more) Join Now POP30300.REFRENCE
TRXDATE datetime

TrxDate Transaction Date used when the transaction was posted CM20502.TRXDATE
RVRSNGDT datetime


RCRNGTRX tinyint


BALFRCLC smallint


PSTGSTUS smallint

Posting St...(more) Join Now RM10301.PSTGSTUS
LASTUSER char(15)

Last User:...(more) Join Now GL20000.LASTUSER
LSTDTEDT datetime

Last Date ...(more) Join Now GL20000.LSTDTEDT
USWHPSTD char(15)

User Who P...(more) Join Now GL20000.USWHPSTD
TRXTYPE smallint


SQNCLINE numeric(19,5)

Sequence L...(more) Join Now VAT10302.SQNCLINE
GLHDRMSG binary(4)


GLHDRMS2 binary(4)


TRXSORCE char(13)

Transactio...(more) Join Now
SERIES smallint

Series: I...(more) Join Now SY00500.SERIES
ORTRXTYP smallint

Originatin...(more) Join Now GL20000.ORTRXTYP
ORCTRNUM char(21)

Originatin...(more) Join Now GL20000.ORCTRNUM
ORMSTRID char(31)

Originatin...(more) Join Now GL20000.ORMSTRID
ORMSTRNM char(65)

Originatin...(more) Join Now GL20000.ORMSTRNM
ORDOCNUM char(21)

Originatin...(more) Join Now GL20000.ORDOCNUM
ORPSTDDT datetime

Originatio...(more) Join Now GL20000.ORPSTDDT
ORTRXSRC char(13)
0
Originatin...(more) Join Now
CURNCYID char(15)

Currency I...(more) Join Now CM20000
join ... more text available
NOTEINDX numeric(19,5)

Note Index...(more) Join Now
join ... more text available
WSReserved_CB1 tinyint


WSReserved_CB2 tinyint


WSReserved_CB3 tinyint


WSReserved_CB4 tinyint


WSReserved_CB5 tinyint


WSReserved_CB6 tinyint


WSReserved_CB7 tinyint


WSReserved_CB10 tinyint


OPENYEAR smallint

Open Year:...(more) Join Now GL20000.OPENYEAR
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