Site Search:
Sign in | Join | Help
4Penny.net

Dynamics GP

Notes, Tips and Tricks on Developing in Dynamics GP

JC00601a

Name Physical Name Type Keyable Storage
GPS_Reserved GPS_RESERVED Long Integer 10 4
WS Job Number WS_Job_Number String 17 18
Cost Element Cost_Element Integer 3 2
Bill Code Number Bill_Code_Number String 26 28
Bill Code Description Bill_Code_Description String 30 32
Bill % Bill_Pct Integer 5 2
Bill Amount Bill_Amount Currency 14 10
Billed Amount TTD Billed_Amount_TTD Currency 14 10
Total Billable Amount Total_Billable_Amount Currency 14 10
Originating Total Billable Amount Orig_Tot_Billable_Amt Currency 19 10
Originating Bill Amount Orig_Bill_Amt Currency 19 10
Originating Billed Amount TTD OrigBilledAmtTTD Currency 19 10
Retention Billed TTD Retention_Billed_TTD Currency 14 10
Originating Retention Billed TTD OrigRetentionBilledTTD Currency 14 10
Originating Retention Amount TTD OrigRetentionAmtTTD Currency 14 10
Added By CO Module Added_By_CO_Module Boolean 0 2
Change Order # Change_Order_Nbr String 14 16
Units Billable Units_Billable Currency 14 10
Units Billed TTD Units_Billed_TTD Currency 14 10
Units Billing Rate Units_Billing_Rate Currency 14 10
Retention Amount TTD Retention_Amount_TTD Currency 14 10
Account Index ACTINDX Long Integer 14 4
Profit Type Number Profit_Type_Number Integer 2 2
Profit Amount Profit_Amount Currency 14 10
Work In Place Work_In_Place Currency 14 10
Stored To Date Stored_To_Date Currency 14 10
Bill Code Alias Bill_Code_Alias String 30 32
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 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 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 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
Modified User ID MDFUSRID String 15 16
Modified Date MODIFDT Date 8 4
Modified Time Modified_Time Time 6 4
SV Language ID SV_Language_ID Integer 2 2
Time Zone Time_Zone String 3 4
Wennsoft Affiliate Wennsoft_Affiliate String 15 16
Wennsoft Branch Wennsoft_Branch String 15 16
Wennsoft Region Wennsoft_Region String 15 16
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
Published May 31 2007, 01:13 PM by Steve Gray

Comments

 

Dynamics GP said:

AS000100 AS_Asset_MSTR AS_Asset_MSTR AS000210 AS_Fleet_Setup_MSTR AS_Fleet_Setup_MSTR AS000220 AS_User_Define_MSTR

May 31, 2007 1:23 PM

Leave a Comment

(required)  
(optional)
(required)  
Add

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.