Module List >
Module JC tables
JC50201
You are currently viewing the COMPANY
database.
Change
|
COMPANY..JC50201 Table Definition
(COMPANY..JC_Application_Payment_TEMP)
Field Definitions:
What is the 'source' column?
| 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
|
|
|
|
|