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

COMPANY..JC50201 Table Definition

(COMPANY..JC_Application_Payment_TEMP)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
WS_Job_Number char(17)


WS_Job_Name char(31)


CUSTNMBR char(15)

Customer N...(more) Join Now RM20101.CUSTNMBR
join ... more text available
RMDNUMWK char(17)

RM Documen...(more) Join Now RM10301.RMDNUMWK
RMDTYPAL smallint

RM Documen...(more) Join Now RM20101.RMDTYPAL
WS_Application_Number char(5)


Printed_Date datetime


Schedule_Start_Date datetime


JC_Contract_Number char(15)


Orig_Contract_Amount numeric(19,5)


Change_Orders_TTD numeric(19,5)


Expected_Contract numeric(19,5)


Completed_Stored numeric(19,5)


Retention_Pct numeric(19,5)


RETNAGAM numeric(19,5)

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


Total_Retention numeric(19,5)


Total_Earned numeric(19,5)


Net_Billed_TTD numeric(19,5)


DOCAMNT numeric(19,5)

Source Doc...(more) Join Now PM10000.DOCAMNT
Prev_Chg_Ord_Add numeric(19,5)


Prev_Chg_Ord_Ded numeric(19,5)


Curr_Month_Chg_Ord_Add numeric(19,5)


Curr_Month_Chg_Ord_Ded numeric(19,5)


CMPANYID smallint

Company ID...(more) Join Now CM00100.CMPANYID
join ... more text available
PORDNMBR char(21)

Purchase O...(more) Join Now
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