JC50201 - JC_Application_Payment_TEMP
SQL Query Builder
27 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| WS_Job_Number | char(17) | |||
| WS_Job_Name | char(31) | |||
| CUSTNMBR | char(15) | |||
| RMDNUMWK | char(17) | |||
| RMDTYPAL | smallint | |||
| 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) | |||
| 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) | |||
| 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 | |||
| PORDNMBR | char(21) | |||
| DEX_ROW_ID | int auto number (1,1) |
Related Tables
Tables that share columns with JC50201. Click "Join" to add to your query.