Notes, Tips and Tricks on Developing in Dynamics GP
| Name |
Physical Name |
Type |
Keyable |
Storage |
| GPS_Reserved |
GPS_RESERVED |
Long Integer |
10 |
4 |
| WS Job Number |
WS_Job_Number |
String |
17 |
18 |
| Customer Number |
CUSTNMBR |
String |
15 |
16 |
| Address Code |
ADRSCODE |
String |
15 |
16 |
| WS Job Location Type |
WS_Job_Location_Type |
Integer |
3 |
2 |
| User ID |
USERID |
String |
15 |
16 |
| User Define 1 |
User_Define_1 |
String |
30 |
32 |
| User Define 2 |
User_Define_2 |
String |
30 |
32 |
| User Defined 1 |
USERDEF1 |
String |
20 |
22 |
| User Defined 2 |
USERDEF2 |
String |
20 |
22 |
| User Defined Integer 1 |
User_Def_Integer_1 |
Long Integer |
6 |
4 |
| User Defined Integer 2 |
User_Def_Integer_2 |
Long Integer |
6 |
4 |
| User Defined Integer 3 |
User_Defined_Integer_3 |
Long Integer |
6 |
4 |
| User Defined Integer 4 |
User_Defined_Integer_4 |
Long Integer |
6 |
4 |
| User Defined Dollar 1 |
User_Defined_Dollar_1 |
Currency |
14 |
10 |
| User Defined Dollar 2 |
User_Defined_Dollar_2 |
Currency |
14 |
10 |
| User Defined Dollar 3 |
User_Defined_Dollar_3 |
Currency |
14 |
10 |
| User Defined Dollar 4 |
User_Defined_Dollar_4 |
Currency |
14 |
10 |
| User Defined Date 1 |
USRDAT01 |
Date |
8 |
4 |
| User Defined Date 2 |
USRDAT02 |
Date |
8 |
4 |
| WS User Defined Date 3 |
User_Defined_Date_3 |
Date |
6 |
4 |
| WS User Defined Date 4 |
User_Defined_Date_4 |
Date |
6 |
4 |
| User Defined CB 1 |
User_Defined_CB_1 |
Boolean |
0 |
2 |
| User Defined CB 2 |
User_Defined_CB_2 |
Boolean |
0 |
2 |
| User Defined CB 3 |
User_Defined_CB_3 |
Boolean |
0 |
2 |
| User Defined CB 4 |
User_Defined_CB_4 |
Boolean |
0 |
2 |
| Wennsoft Affiliate |
Wennsoft_Affiliate |
String |
15 |
16 |
| Wennsoft Branch |
Wennsoft_Branch |
String |
15 |
16 |
| Wennsoft Region |
Wennsoft_Region |
String |
15 |
16 |
| Modified Date |
MODIFDT |
Date |
8 |
4 |
| Modified Time |
Modified_Time |
Time |
6 |
4 |
| Modified User ID |
MDFUSRID |
String |
15 |
16 |
| SV Language ID |
SV_Language_ID |
Integer |
2 |
2 |
| Time Zone |
Time_Zone |
String |
3 |
4 |
| Technician ID |
Technician_ID |
String |
15 |
16 |
| Technician Team |
Technician_Team |
String |
15 |
16 |
| WS Inactive |
WS_Inactive |
Boolean |
0 |
2 |
| WSReserved CB1 |
WSReserved_CB1 |
Boolean |
0 |
2 |
| WSReserved CB2 |
WSReserved_CB2 |
Boolean |
0 |
2 |
| WSReserved CB3 |
WSReserved_CB3 |
Boolean |
0 |
2 |
| WSReserved CB4 |
WSReserved_CB4 |
Boolean |
0 |
2 |
| WSReserved CB5 |
WSReserved_CB5 |
Boolean |
0 |
2 |
| WSReserved CB6 |
WSReserved_CB6 |
Boolean |
0 |
2 |
| WSReserved CB7 |
WSReserved_CB7 |
Boolean |
0 |
2 |
| WSReserved CB8 |
WSReserved_CB8 |
Boolean |
0 |
2 |
| WSReserved CB9 |
WSReserved_CB9 |
Boolean |
0 |
2 |
| WSReserved CB10 |
WSReserved_CB10 |
Boolean |
0 |
2 |
| WSReserved STR1 |
WSReserved_STR1 |
String |
10 |
12 |
| WSReserved STR2 |
WSReserved_STR2 |
String |
10 |
12 |
About Steve Gray
Steve is a seasoned (translate: old) developer in VB and ASP.NET. He spends most of his time in Dynamics GP, writing custom mods for consulting firms. Crystal reports, eConnect, VS Tools for Dynamics... anything that comes along.