Module List >
Module SV tables
SVA0514
You are currently viewing the COMPANY
database.
Change
|
COMPANY..SVA0514 Table Definition
(COMPANY..SV_Revenue_Recognition_Summary_Archi)
Field Definitions:
What is the 'source' column?
| Wennsoft_Affiliate |
char(15)
|
|
|
|
|
| Wennsoft_Region |
char(15)
|
|
|
|
|
| Wennsoft_Branch |
char(15)
|
|
|
|
|
| USERID |
char(15)
|
The user t...(more) Join Now
|
|
|
join ... more text available
|
| Technician_ID |
char(15)
|
|
|
|
|
| Technician_Team |
char(15)
|
|
|
|
|
| CUSTNMBR |
char(15)
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| ADRSCODE |
char(15)
|
Field Type...(more) Join Now
|
|
|
|
| Contract_Number |
char(11)
|
|
|
|
|
| WSCONTSQ |
int
|
|
|
|
|
| Wennsoft_Close_Date |
datetime
|
|
|
|
|
| YEAR1 |
smallint
|
Field Type...(more) Join Now
|
|
|
|
| PERIODID |
smallint
|
Field Type...(more) Join Now
|
|
|
|
| TTD_Billed |
numeric(19,5)
|
|
|
|
|
| Actual_Labor |
numeric(19,5)
|
|
|
|
|
| Actual_Material |
numeric(19,5)
|
|
|
|
|
| Actual_Equipment |
numeric(19,5)
|
|
|
|
|
| Actual_Subs |
numeric(19,5)
|
|
|
|
|
| Actual_Other |
numeric(19,5)
|
|
|
|
|
| Excess_Cost |
numeric(19,5)
|
|
|
|
|
| Unbilled_Receivable |
numeric(19,5)
|
|
|
|
|
| Prior_Year_Retained |
numeric(19,5)
|
|
|
|
|
| TTD_Contract_Earned |
numeric(19,5)
|
|
|
|
|
| YTD_Contract_Earned |
numeric(19,5)
|
|
|
|
|
| YTD_Labor |
numeric(19,5)
|
|
|
|
|
| YTD_Material |
numeric(19,5)
|
|
|
|
|
| YTD_Equipment |
numeric(19,5)
|
|
|
|
|
| YTD_Subcontractor |
numeric(19,5)
|
|
|
|
|
| YTD_Other |
numeric(19,5)
|
|
|
|
|
| Contract_Amount |
numeric(19,5)
|
|
|
|
|
| Contract_Start_Date |
datetime
|
|
|
|
|
| PY_Contract_Earned |
numeric(19,5)
|
|
|
|
|
| Forecast_Equipment |
numeric(19,5)
|
|
|
|
|
| Forecast_Material |
numeric(19,5)
|
|
|
|
|
| Forecast_Labor |
numeric(19,5)
|
|
|
|
|
| Forecast_Subs |
numeric(19,5)
|
|
|
|
|
| Forecast_Other |
numeric(19,5)
|
|
|
|
|
| Forecast_Total_Cost |
numeric(19,5)
|
|
|
|
|
| Journal_Number |
int
|
|
|
|
|
| Division |
smallint
|
|
|
|
|
| Divisions |
char(15)
|
|
|
|
|
| MODIFDT |
datetime
|
Date the r...(more) Join Now
|
|
|
|
| Modified_Time |
datetime
|
|
|
|
|
| MDFUSRID |
char(15)
|
User that ...(more) Join Now
|
|
|
join ... more text available
|
| Time_Zone |
char(3)
|
|
|
|
|
| Base_Currency_ID |
char(15)
|
|
|
|
|
| Billing_Currency_ID |
char(15)
|
|
|
|
|
| Local_Currency_ID |
char(15)
|
|
|
|
|
| WSReserved_CB1 |
tinyint
|
|
|
|
|
| WSReserved_CB2 |
tinyint
|
|
|
|
|
| WSReserved_CB3 |
tinyint
|
|
|
|
|
| WSReserved_CB4 |
tinyint
|
|
|
|
|
| WSReserved_CB5 |
tinyint
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|