DynDeveloper.com

DynDeveloper.com
Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now! Log In
Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
Module List > Module SV tables SV00702
You are currently viewing the COMPANY database.
Change

COMPANY..SV00702 Table Definition

(COMPANY..SV_Invoice_MSTR_Report)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
Service_Call_ID char(17)
CUSTNMBR char(15)

 Field Type...(more) Join Now
join ... more text available
Call_Invoice_Number char(17)
ADRSCODE char(15)

 Field Type...(more) Join Now
PRBTADCD char(15)

 Primary Bi...(more) Join Now RM00101.PRBTADCD
join ... more text available
Invoice_Type smallint

 img alt=""...(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)
CUSTNAME char(65)

 Field Type...(more) Join Now
Corporate_Invoice_Number char(17)
CPRCSTNM char(15)

 Corporate ...(more) Join Now RM00101.CPRCSTNM
BACHNUMB char(15)

 Batch Numb...(more) Join Now
join ... more text available
BCHSOURC char(15)

 Batch Sour...(more) Join Now
Labor_Cost_Catagory_1 numeric(19,5)
Labor_Cost_Catagory_2 numeric(19,5)
Labor_Cost_Catagory_3 numeric(19,5)
Labor_Cost_Catagory_4 numeric(19,5)
Labor_Cost_Catagory_5 numeric(19,5)
Cost_Equipment numeric(19,5)
Cost_Material numeric(19,5)
Cost_Labor numeric(19,5)
Cost_Subs numeric(19,5)
Cost_Other numeric(19,5)
Cost_All numeric(19,5)
Labor_Billing_Catagory_1 numeric(19,5)
Labor_Billing_Catagory_2 numeric(19,5)
Labor_Billing_Catagory_3 numeric(19,5)
Labor_Billing_Catagory_4 numeric(19,5)
Labor_Billing_Catagory_5 numeric(19,5)
Billable_Equipment numeric(19,5)
Billable_Material numeric(19,5)
Billable_Labor numeric(19,5)
Billable_Subs numeric(19,5)
Billable_Other 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_Amount_4 numeric(19,5)
Billable_Tax numeric(19,5)
Billable_All numeric(19,5)
TOTLAMNT_1 numeric(19,5)
TOTLAMNT_2 numeric(19,5)
TOTLAMNT_3 numeric(19,5)
TOTLAMNT_4 numeric(19,5)
TOTLAMNT_5 numeric(19,5)
TOTLAMNT_6 numeric(19,5)
TOTLAMNT_7 numeric(19,5)
TOTLAMNT_8 numeric(19,5)
TOTLAMNT_9 numeric(19,5)
TOTLAMNT_10 numeric(19,5)
TOTLAMNT_11 numeric(19,5)
TOTLAMNT_12 numeric(19,5)
TOTLAMNT_13 numeric(19,5)
TOTLAMNT_14 numeric(19,5)
TOTLAMNT_15 numeric(19,5)
TOTLAMNT_16 numeric(19,5)
TOTLAMNT_17 numeric(19,5)
TOTLAMNT_18 numeric(19,5)
TOTLAMNT_19 numeric(19,5)
TOTLAMNT_20 numeric(19,5)
TOTLAMNT_21 numeric(19,5)
TOTLAMNT_22 numeric(19,5)
TOTLAMNT_23 numeric(19,5)
TOTLAMNT_24 numeric(19,5)
TOTLAMNT_25 numeric(19,5)
TOTLAMNT_26 numeric(19,5)
TOTLAMNT_27 numeric(19,5)
TOTLAMNT_28 numeric(19,5)
TOTLAMNT_29 numeric(19,5)
TOTLAMNT_30 numeric(19,5)
TOTLAMNT_31 numeric(19,5)
TOTLAMNT_32 numeric(19,5)
TOTLAMNT_33 numeric(19,5)
TOTLAMNT_34 numeric(19,5)
TOTLAMNT_35 numeric(19,5)
TOTLAMNT_36 numeric(19,5)
TOTLAMNT_37 numeric(19,5)
TOTLAMNT_38 numeric(19,5)
TOTLAMNT_39 numeric(19,5)
TOTLAMNT_40 numeric(19,5)
ACCTAMNT numeric(19,5)

 Account Am...(more) Join Now
PYMTRMID char(21)

 Payment Te...(more) Join Now
SY033... more text available
TAXSCHID char(15)
join ... more text available
Invoice_Comment_ID_1 smallint
Invoice_Comment_ID_2 smallint
CASHAMNT numeric(19,5)

 Cash Amoun...(more) Join Now PM10000.CASHAMNT
DOCDATE datetime

 Document D...(more) Join Now PM10000.DOCDATE
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)
PORDNMBR char(21)

 Field Type...(more) Join Now
TRDISAMT numeric(19,5)

 Trade Disc...(more) Join Now RM20101.TRDISAMT
CBKIDCHK char(15)

 Checkbook ...(more) Join Now RM20101.CBKIDCHK
CASHDATE datetime

 Cash Date:...(more) Join Now RM10301.CASHDATE
DCNUMCSH char(21)

 Document N...(more) Join Now RM10301.DCNUMCSH
CHEKAMNT numeric(19,5)

 Check Amou...(more) Join Now PM10000.CHEKAMNT
CBKIDCRD char(15)

 Checkbook ...(more) Join Now RM20101.CBKIDCRD
CHEKNMBR char(21)

 Check Numb...(more) Join Now PM10000.CHEKNMBR
CHEKDATE datetime

 Check Date...(more) Join Now PM10000.CHEKDATE
DCNUMCHK char(21)

 Document N...(more) Join Now RM10301.DCNUMCHK
DCNUMCRD char(21)

 Document N...(more) Join Now RM10301.DCNUMCRD
CRCRDAMT numeric(19,5)

 Credit Car...(more) Join Now PM10000.CRCRDAMT
CRCRDNAM char(15)

 Credit Car...(more) Join Now RM10301.CRCRDNAM
RCTNCCRD char(21)

 Receipt Nu...(more) Join Now RM10301.RCTNCCRD
CRCARDDT datetime

 Credit Car...(more) Join Now PM10000.CRCARDDT
DISTKNAM numeric(19,5)

 Discount T...(more) Join Now RM20101.DISTKNAM
CBKIDCSH char(15)

 Checkbook ...(more) Join Now RM20101.CBKIDCSH
POSTEDDT datetime

 Field Type...(more) Join Now
Invoice_Style smallint
No_Times_Printed smallint
Printed_Date datetime
Chgd_Since_Printing_Flag tinyint
DOCAMNT numeric(19,5)

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

 Field Type...(more) Join Now
DSCDLRAM numeric(19,5)

 Field Type...(more) Join Now
DISAVAMT numeric(19,5)

 Discount A...(more) Join Now RM20101.DISAVAMT
DISCDATE datetime

 Discount D...(more) Join Now PM10000.DISCDATE
DUEDATE datetime

 Due Date: ...(more) Join Now PM10000.DUEDATE
RMDNUMWK char(17)

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

 RM Documen...(more) Join Now RM20101.RMDTYPAL
Date_Paid datetime
Amount_Recieved numeric(19,5)
Corporate_Contract_Nbr char(21)
WSMSTRCONTSQ int
Contract_Number char(11)
WSCONTSQ int
Tax_Date datetime

 Tax Date: ...(more) Join Now RM20101.Tax_Date
Labor_Group_Name char(15)
Pricing_Matrix_Name char(15)
Travel_Rate_Name char(15)
Bill_Customer_Number char(15)
Bill_Address_Code char(15)
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)
Time_Zone char(3)
SV_Language_ID smallint
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)
Invoice_Short_Desc char(31)
Manual_Sales_Dist tinyint
Manual_Commission_Dist tinyint
ADDRESS1 char(61)

 Field Type...(more) Join Now
ADDRESS2 char(61)

 Field Type...(more) Join Now
CITY char(35)

 Field Type...(more) Join Now
STATE char(29)

 Field Type...(more) Join Now
ZIP char(11)

 Field Type...(more) Join Now
COUNTRY char(61)

 Field Type...(more) Join Now
Invoice_Comment_1 char(61)
Invoice_Comment_2 char(61)
CURNCYID char(15)

 Field Type...(more) Join Now
join ... more text available
CURRNIDX smallint

 Field Type...(more) Join Now
join ... more text available
ORDISTKN numeric(19,5)

 Orig Disco...(more) Join Now SOP30200.ORDISTKN
WS_Orig_Billable_All numeric(19,5)
WS_Orig_Billable_Equipme numeric(19,5)
WS_Orig_Billable_Labor numeric(19,5)
WS_Orig_Billable_Materia numeric(19,5)
WS_Orig_Billable_Other numeric(19,5)
WS_Orig_Billable_Subs numeric(19,5)
WS_Orig_Billable_Tax numeric(19,5)
WS_Orig_Billable_Subtota numeric(19,5)
WS_Orig_Tax_Amount_4 numeric(19,5)
WS_Orig_Tax_Amount1 numeric(19,5)
WS_Orig_Tax_Amount2 numeric(19,5)
WS_Orig_Tax_Amount3 numeric(19,5)
ORCCDAMT numeric(19,5)

 Originatin...(more) Join Now PTE30500.ORCCDAMT
ORCHKAMT numeric(19,5)

 Originatin...(more) Join Now PTE30500.ORCHKAMT
ORCASAMT numeric(19,5)

 Originatin...(more) Join Now PTE30500.ORCASAMT
DEX_ROW_ID int
auto number (1,1)
 Unique ide...(more) Join Now
Invoice_Description text
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
Archives | Table Listing | eConnect Error Database | eConnect Schema | Gold Star Locksmith
3