Module List > Module SV tables SVA0514
You are currently viewing the COMPANY database.
Change

COMPANY..SVA0514 Table Definition

(COMPANY..SV_Revenue_Recognition_Summary_Archi)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
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
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