Module List >
Module SV tables
SVA0507
You are currently viewing the COMPANY
database.
Change
|
COMPANY..SVA0507 Table Definition
(COMPANY..SV_Contract_Billing_HIST_Archive)
Field Definitions:
What is the 'source' column?
| 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
|
|
|
|
|
| SEQNUMBR |
int
|
Field Type...(more) Join Now
|
|
|
|
| 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)
|
|
|
|
|
| Wennsoft_Close_Date |
datetime
|
|
|
|
|
| YEAR1 |
smallint
|
Field Type...(more) Join Now
|
|
|
|
| PERIODID |
smallint
|
Field Type...(more) Join Now
|
|
|
|
| Contract_Billing_Desc |
char(41)
|
|
|
|
|
| Billing_Date |
datetime
|
|
|
|
|
| Corporate_Invoice_Number |
char(17)
|
|
|
|
|
| Corporate_Contract_Nbr |
char(21)
|
|
|
|
|
| WSMSTRCONTSQ |
int
|
|
|
|
|
| RMDTYPAL |
smallint
|
RM Documen...(more) Join Now
|
RM20101.RMDTYPAL
|
|
|
| Tax_Detail_ID_1 |
char(15)
|
|
|
|
|
| Tax_Amount1 |
numeric(19,5)
|
|
|
|
|
| Tax_Detail_ID_2 |
char(15)
|
|
|
|
|
| Tax_Amount2 |
numeric(19,5)
|
|
|
|
|
| Tax_Detail_ID_3 |
char(15)
|
|
|
|
|
| Tax_Amount3 |
numeric(19,5)
|
|
|
|
|
| Tax_Detail_ID_4 |
char(15)
|
|
|
|
|
| Tax_Amount_4 |
numeric(19,5)
|
|
|
|
|
| DOCAMNT |
numeric(19,5)
|
Field Type...(more) Join Now
|
|
|
|
| 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)
|
|
|
|
|
| Escalation_Pct_Equip |
numeric(19,5)
|
|
|
|
|
| Escalation_Pct_Material |
numeric(19,5)
|
|
|
|
|
| Escalation_Pct_Labor |
numeric(19,5)
|
|
|
|
|
| Escalation_Pct_Subs |
numeric(19,5)
|
|
|
|
|
| Escalation_Pct_Other |
numeric(19,5)
|
|
|
|
|
| Escal_Fixed_Amt_Equip |
numeric(19,5)
|
|
|
|
|
| Escalation_Fixed_Amt_Mat |
numeric(19,5)
|
|
|
|
|
| Escal_Fixed_Amt_Labor |
numeric(19,5)
|
|
|
|
|
| Escal_Fixed_Amt_Subs |
numeric(19,5)
|
|
|
|
|
| Escal_Fixed_Amt_Other |
numeric(19,5)
|
|
|
|
|
| Billable_Escalation |
numeric(19,5)
|
|
|
|
|
| Billable_Total |
numeric(19,5)
|
|
|
|
|
| Contract_Escalation_Desc |
char(41)
|
|
|
|
|
| DATE1 |
datetime
|
Field Type...(more) Join Now
|
|
|
|
| POSTDATE |
datetime
|
Post Dateb...(more) Join Now
|
RM20101.POSTDATE
|
|
|
| Period2 |
smallint
|
|
|
|
|
| WS_Closed |
tinyint
|
|
|
|
|
| Invoice_Comment_ID_1 |
smallint
|
|
|
|
|
| Invoice_Comment_ID_2 |
smallint
|
|
|
|
|
| SLPRSNID |
char(15)
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| COMPRCNT |
smallint
|
Field Type...(more) Join Now
|
|
|
|
| Commission_Pct_of_Sale |
smallint
|
|
|
|
|
| COMMERNG |
numeric(19,5)
|
|
|
|
|
| SALSTERR |
char(15)
|
Sales Terr...(more) Join Now
|
RM10301.SALSTERR
|
|
join ... more text available
|
| Salesperson_ID_2 |
char(15)
|
|
|
|
|
| Commission_Percent_2 |
smallint
|
|
|
|
|
| Commission_Pct_of_Sale_2 |
smallint
|
|
|
|
|
| Commission_Earnings_2 |
numeric(19,5)
|
|
|
|
|
| Sales_Territory_2 |
char(15)
|
|
|
|
|
| Invoice_Style |
smallint
|
|
|
|
|
| Service_User_Define_1 |
char(21)
|
|
|
|
|
| Service_User_Define_2 |
char(21)
|
|
|
|
|
| Service_User_Define_3 |
char(31)
|
|
|
|
|
| Service_User_Define_4 |
char(31)
|
|
|
|
|
| Service_User_Define_5 |
int
|
|
|
|
|
| Service_User_Define_6 |
int
|
|
|
|
|
| Service_User_Define_7 |
int
|
|
|
|
|
| Service_User_Define_8 |
int
|
|
|
|
|
| Service_User_Define_9 |
datetime
|
|
|
|
|
| Service_User_Define_10 |
datetime
|
|
|
|
|
| Service_User_Define_11 |
datetime
|
|
|
|
|
| Service_User_Define_12 |
datetime
|
|
|
|
|
| Service_User_Define_18 |
tinyint
|
|
|
|
|
| Service_User_Define_19 |
tinyint
|
|
|
|
|
| Service_User_Define_20 |
tinyint
|
|
|
|
|
| Service_User_Define_21 |
tinyint
|
|
|
|
|
| Service_User_Define_22 |
numeric(19,5)
|
|
|
|
|
| Service_User_Define_23 |
numeric(19,5)
|
|
|
|
|
| Service_User_Define_24 |
numeric(19,5)
|
|
|
|
|
| Service_User_Define_25 |
numeric(19,5)
|
|
|
|
|
| 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)
|
|
|
|
|
| Base_Curr_Conv_Factor |
numeric(19,7)
|
|
|
|
|
| Billing_Currency_ID |
char(15)
|
|
|
|
|
| Billing_Curr_Conv_Factor |
numeric(19,7)
|
|
|
|
|
| Local_Currency_ID |
char(15)
|
|
|
|
|
| Bill_Customer_Number |
char(15)
|
|
|
|
|
| Bill_Address_Code |
char(15)
|
|
|
|
|
| RMDNUMWK |
char(17)
|
RM Documen...(more) Join Now
|
RM10301.RMDNUMWK
|
|
|
| ACTINDX_CR |
int
|
|
|
|
|
| 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
|
|
|
|
|