Module List >
Module JC tables
JC30601
You are currently viewing the COMPANY
database.
Change
|
COMPANY..JC30601 Table Definition
(COMPANY..JC_Billing_Codes_HIST)
Field Definitions:
What is the 'source' column?
| WS_Job_Number |
char(17)
|
|
|
|
|
| Cost_Element |
smallint
|
|
|
|
|
| Bill_Code_Number |
char(27)
|
|
|
|
|
| Bill_Code_Description |
char(31)
|
|
|
|
|
| Bill_Pct |
smallint
|
|
|
|
|
| Bill_Amount |
numeric(19,5)
|
|
|
|
|
| Billed_Amount_TTD |
numeric(19,5)
|
|
|
|
|
| Total_Billable_Amount |
numeric(19,5)
|
|
|
|
|
| Orig_Tot_Billable_Amt |
numeric(19,5)
|
|
|
|
|
| Orig_Bill_Amt |
numeric(19,5)
|
|
|
|
|
| OrigBilledAmtTTD |
numeric(19,5)
|
|
|
|
|
| Retention_Billed_TTD |
numeric(19,5)
|
|
|
|
|
| OrigRetentionBilledTTD |
numeric(19,5)
|
|
|
|
|
| OrigRetentionAmtTTD |
numeric(19,5)
|
|
|
|
|
| Added_By_CO_Module |
tinyint
|
|
|
|
|
| Change_Order_Nbr |
char(15)
|
|
|
|
|
| Units_Billable |
numeric(19,5)
|
|
|
|
|
| Units_Billed_TTD |
numeric(19,5)
|
|
|
|
|
| Units_Billing_Rate |
numeric(19,5)
|
|
|
|
|
| Retention_Amount_TTD |
numeric(19,5)
|
|
|
|
|
| ACTINDX |
int
|
Account In...(more) Join Now
|
UPR00100.ACTINDX
|
|
join ... more text available
|
| Profit_Type_Number |
smallint
|
1 = ...(more) Join Now
|
|
|
|
| Profit_Amount |
numeric(19,5)
|
|
|
|
|
| Work_In_Place |
numeric(19,5)
|
|
|
|
|
| Stored_To_Date |
numeric(19,5)
|
|
|
|
|
| Bill_Code_Alias |
char(31)
|
|
|
|
|
| USERID |
char(15)
|
The user t...(more) Join Now
|
|
|
join ... more text available
|
| User_Define_1 |
char(31)
|
|
|
|
|
| User_Define_2 |
char(31)
|
|
|
|
|
| USERDEF1 |
char(21)
|
UserDefine...(more) Join Now
|
|
|
|
| USERDEF2 |
char(21)
|
UserDefine...(more) Join Now
|
|
|
|
| User_Defined_Dollar_1 |
numeric(19,5)
|
|
|
|
|
| User_Defined_Dollar_2 |
numeric(19,5)
|
|
|
|
|
| User_Defined_Dollar_3 |
numeric(19,5)
|
|
|
|
|
| User_Defined_Dollar_4 |
numeric(19,5)
|
|
|
|
|
| User_Def_Integer_1 |
int
|
|
|
|
|
| User_Def_Integer_2 |
int
|
|
|
|
|
| User_Defined_Integer_3 |
int
|
|
|
|
|
| User_Defined_Integer_4 |
int
|
|
|
|
|
| USRDAT01 |
datetime
|
|
|
|
|
| USRDAT02 |
datetime
|
|
|
|
|
| User_Defined_Date_3 |
datetime
|
|
|
|
|
| User_Defined_Date_4 |
datetime
|
|
|
|
|
| User_Defined_CB_1 |
tinyint
|
|
|
|
|
| User_Defined_CB_2 |
tinyint
|
|
|
|
|
| User_Defined_CB_3 |
tinyint
|
|
|
|
|
| User_Defined_CB_4 |
tinyint
|
|
|
|
|
| MDFUSRID |
char(15)
|
User that ...(more) Join Now
|
|
|
join ... more text available
|
| MODIFDT |
datetime
|
Date the r...(more) Join Now
|
|
|
|
| Modified_Time |
datetime
|
|
|
|
|
| SV_Language_ID |
smallint
|
|
|
|
|
| Time_Zone |
char(3)
|
|
|
|
|
| Wennsoft_Affiliate |
char(15)
|
|
|
|
|
| Wennsoft_Branch |
char(15)
|
|
|
|
|
| Wennsoft_Region |
char(15)
|
|
|
|
|
| WSReserved_CB1 |
tinyint
|
|
|
|
|
| WSReserved_CB2 |
tinyint
|
|
|
|
|
| WSReserved_CB3 |
tinyint
|
|
|
|
|
| WSReserved_CB4 |
tinyint
|
|
|
|
|
| WSReserved_CB5 |
tinyint
|
|
|
|
|
| WSReserved_CB6 |
tinyint
|
|
|
|
|
| WSReserved_CB7 |
tinyint
|
|
|
|
|
| WSReserved_CB8 |
tinyint
|
|
|
|
|
| WSReserved_CB9 |
tinyint
|
|
|
|
|
| WSReserved_CB10 |
tinyint
|
|
|
|
|
| WSReserved_STR1 |
char(11)
|
|
|
|
|
| WSReserved_STR2 |
char(11)
|
|
|
|
|
| Allocated_Percent |
numeric(19,5)
|
|
|
|
|
| Revenue_Allocated |
numeric(19,5)
|
|
|
|
|
| Percent_Complete |
numeric(19,5)
|
|
|
|
|
| Est_Hr_to_Complete |
numeric(19,5)
|
|
|
|
|
| Estimate_Date |
datetime
|
|
|
|
|
| WS_Inactive |
tinyint
|
0 = Active...(more) Join Now
|
|
|
|
| Reimbursable |
tinyint
|
|
|
|
|
| Project_Number |
char(17)
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|