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 SV02200
You are currently viewing the COMPANY database.
Change

COMPANY..SV02200 Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
RCRDTYPE smallint

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

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

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

 Field Type...(more) Join Now
join ... more text available
UPSZONE char(3)

 UPS Zone: ...(more) Join Now RM00101.UPSZONE
SHIPMTHD char(15)

 Shipping M...(more) Join Now RM20101.SHIPMTHD
join ... more text available
TAXSCHID char(15)
join ... more text available
CNTCPRSN char(61)

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

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

 Field Type...(more) Join Now
COUNTRY 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
PHONE1 char(21)

 Field Type...(more) Join Now
PHONE2 char(21)

 Field Type...(more) Join Now
FAX char(21)

 Fax: Same...(more) Join Now RM00101.FAX
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
Map_Grid char(15)
Service_Area char(15)
LOCATNNM char(31)
Labor_Group_Name char(15)
Pricing_Matrix_Name char(15)
Technician char(11)
Technician_2 char(11)
Technician_ID2 char(15)
Contact_Name char(15)
Hold_Transaction_ID int
User_Define_1a char(31)
User_Define_2a char(31)
User_Define_3a char(31)
User_Define_4a char(31)
User_Define_5a char(31)
User_Define_6a char(31)
PO_Required tinyint
Out_of_Service_Flag tinyint
Alarm_Flag tinyint
Supervisors_ID char(15)
Supervisors_Hold_Flag tinyint
CPRCSTNM char(15)

 Corporate ...(more) Join Now RM00101.CPRCSTNM
Time_Zone char(3)
SV_Language_ID smallint
Base_Currency_ID char(15)
Billing_Currency_ID char(15)
Local_Currency_ID char(15)
Priority_of_Call char(1)
Divisions char(15)
SVSLARES char(11)
Time_Zone_Tag char(5)
Safety_Flag tinyint
Blanket_PO_CB tinyint
Blanket_PO_Number char(17)
Orig_Blanket_PO_Amt numeric(19,5)
Blanket_PO_Amt_Spent numeric(19,5)
Blanket_PO_Amt__Remainin numeric(19,5)
Blanket_PO_Exp_Date datetime
Bill_Customer_Number char(15)
Bill_Address_Code char(15)
Import_Journal_Number char(15)
Import_Journal_Number_Count smallint
Import_Status char(15)
Import_Status_Descriptio char(89)
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
Archives | Table Listing | eConnect Error Database | eConnect Schema | Gold Star Locksmith
3