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

COMPANY..SVA0534 Table Definition

(COMPANY..SV_Maint_Escalation_HIST_Archive)

4Penny.net

Field Definitions:

What is the 'source' column?

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


Contract_Amount numeric(19,5)


Escalation_Date datetime


Escalation_Year smallint


Escalation_Month smallint


Wennsoft_Affiliate char(15)


Wennsoft_Region char(15)


Wennsoft_Branch char(15)


New_Contract_Price numeric(19,5)


Next_Escalation_Date datetime


Escal_Notify_Days smallint


Escalation_Calc_Date datetime


Escalation_Calculated_By char(15)


Escalation_Approved tinyint


SLPRSNID char(15)

Field Type...(more) Join Now
join ... more text available
APPRVLDT datetime

Approval D...(more) Join Now SY00500.APPRVLDT
Escalation_Idx_ID_Equip char(3)


Escal_Idx_ID_Material char(3)


Escalation_Idx_ID_Labor char(3)


Escalation_Index_ID_Subs char(3)


Escalation_Idx_ID_Other char(3)


Proposed_Billing_Equip numeric(19,5)


Prop_Billing_Material numeric(19,5)


Proposed_Billing_Labor numeric(19,5)


Proposed_Billing_Subs numeric(19,5)


Proposed_Billing_Other numeric(19,5)


Accepted_Billing_Equip numeric(19,5)


Accepted_Billing_Materl numeric(19,5)


Accepted_Billing_Labor numeric(19,5)


Accepted_Billing_Subs numeric(19,5)


Accepted_Billing_Other numeric(19,5)


Proposed_Estimate_Equip numeric(19,5)


Proposed_Est_Material numeric(19,5)


Proposed_Estimate_Labor numeric(19,5)


Proposed_Estimate_Subs numeric(19,5)


Proposed_Estimate_Other numeric(19,5)


Proposed_Estimate_Hours int


Accepted_Estimate_Equip numeric(19,5)


Accepted_Est_Material numeric(19,5)


Accepted_Estimate_Labor numeric(19,5)


Accepted_Estimate_Subs numeric(19,5)


Accepted_Estimate_Other numeric(19,5)


Accepted_Estimate_Hours int


Actual_Equipment numeric(19,5)


Actual_Material numeric(19,5)


Actual_Labor numeric(19,5)


Actual_Subs numeric(19,5)


Actual_Other numeric(19,5)


Actual_Hours int


Estimate_Equipment numeric(19,5)


Estimate_Material numeric(19,5)


Estimate_Labor numeric(19,5)


Estimate_Subs numeric(19,5)


Estimate_Other numeric(19,5)


Estimate_Hours int


POSTED tinyint

Field Type...(more) Join Now
POSTEDDT datetime

Field Type...(more) Join Now
SV_Language_ID smallint


MODIFDT datetime

Date the r...(more) Join Now
Modified_Time datetime


MDFUSRID char(15)

User that ...(more) Join Now
join ... more text available
WSReserved_CB1 tinyint


WSReserved_CB2 tinyint


WSReserved_CB3 tinyint


WSReserved_CB4 tinyint


WSReserved_CB5 tinyint


WSReserved_STR1 char(11)


WSReserved_STR2 char(11)


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