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

COMPANY..JC30001L Table Definition

(COMPANY..JC_RFP_Transaction_HIST_LINES)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
VCHNUMWK char(17)

Voucher Nu...(more) Join Now PM10000.VCHNUMWK
DOCTYPE smallint

Document T...(more) Join Now PM10000.DOCTYPE
SEQNUMBR int

Sequence L...(more) Join Now GL20000.SEQNUMBR
WS_Job_Number char(17)


Cost_Code_Number_Alias char(35)


GROSAMNT numeric(19,5)


TAXABLE tinyint

Taxable: ...(more) Join Now UPR00400.TAXABLE
TAXSCHID char(15)

Tax Schedu...(more) Join Now PM10000.TAXSCHID
join ... more text available
TRDISAMT numeric(19,5)

Trade Disc...(more) Join Now RM20101.TRDISAMT
RETNAGAM numeric(19,5)

Retainage ...(more) Join Now PM10000.RETNAGAM
CIS_Amount numeric(19,5)


CITB_Amount numeric(19,5)


TAXAMNT numeric(19,5)

Tax Amount...(more) Join Now RM20101.TAXAMNT
TXENGCLD tinyint

Tax Engine...(more) Join Now RM10301.TXENGCLD
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