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

COMPANY..SVA0564 Table Definition

(COMPANY..SV_Maint_Invoice_MSTR_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


DATE1 datetime

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)


Corporate_Invoice_Number char(17)


Corporate_Contract_Nbr char(21)


WSMSTRCONTSQ int


Position_on_Invoice smallint


Wennsoft_Billing_Date datetime


Wennsoft_Period_ID smallint


Billable_Tax numeric(19,5)


Billable_Subtotal numeric(19,5)


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_Amount4 numeric(19,5)


Billable_All numeric(19,5)


PORDNMBR char(21)

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


Invoice_Comment_ID_2 smallint


Contract_Billing_Desc char(41)


Billing_Date datetime


RMDNUMWK char(17)

RM Documen...(more) Join Now RM10301.RMDNUMWK
RMDTYPAL smallint

RM Documen...(more) Join Now RM20101.RMDTYPAL
PB_ACTINDX int


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


No_Times_Printed smallint


Printed_Date datetime


Wennsoft_Posting_Status char(1)


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)


SV_Language_ID smallint


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)


Base_Currency_Amount numeric(19,5)


Billing_Currency_Amount numeric(19,5)


Billable_Escalation numeric(19,5)


Billable_Total numeric(19,5)


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)


Contract_Escalation_Desc char(41)


Bill_Customer_Number char(15)


Bill_Address_Code 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)


WS_GL_Posting_Date datetime


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