CU_Options                             CRM Options                    Rel: 4.40  Bld: 398  8/28/2009
 Bus Obj: CU_Options_bus
 SQL Def: Y  SysDB: N                                            "MAS_"+%C$+"/CU"+%C$+"/CU_Options.M4T"

 KPRIMARY: ModuleCode

 Fld  Column Name                     M/L TUR  Description/Notes              Class

   1  ModuleCode. . . . . . . . . .     3 SYY  Module Code . . . . . . . . . .MODULECODE
   2  NewSystem . . . . . . . . . .     1 SYN  New System. . . . . . . . . . .
                                                DfltVal:Y Valid:Y,N,S
   3  AllowCustomerCreation . . . .     1 SYY  Allow Customer Creation . . . .YESNO
                                                DfltVal:N Valid:Y,N
   4  AutomaticallyAssignCustomerNo     1 SYY  Automatically Assign Customer NYESNO
                                                DfltVal:N Valid:Y,N
   5  DefaultCustomerTemplate . . .    20 SNY  Default Customer Template . . .
                                                DfltVal:DEFAULT
   6  ProspectARDivisionNo. . . . .     2 SNY  Prospect AR Division Number . .ARDIVISION
                                                Mask:00
   7  ProspectCustomerNo. . . . . .    20 SYY  Customer Number . . . . . . . .CUSTOMERNO
   8  AllowedToSelectTemplate . . .     1 SYY  Allowed To Select Template. . .YESNO
                                                DfltVal:N Valid:Y,N
   9  CreateCustomers . . . . . . .     1 SYY  Automatically Create Accounts .YESNO
                                                DfltVal:Y Valid:Y,N
  10  CreateAdditionalContacts. . .     1 SYY  Automatically Create Contacts .YESNO
                                                DfltVal:Y Valid:Y,N
  11  CreateShipToAddress . . . . .     1 SYY  Automatically Create Ship To AdYESNO
                                                DfltVal:Y Valid:Y,N
  12  LogCRMCreation. . . . . . . .     1 SYY  Log Account Creation. . . . . .YESNO
                                                DfltVal:Y Valid:Y,N
  13  LogARCreation . . . . . . . .     1 SYY  Log Customer Creation . . . . .YESNO
                                                DfltVal:Y Valid:Y,N
  14  LogNoteCreation . . . . . . .     1 SYY  Log Note Creation . . . . . . .YESNO
                                                DfltVal:Y Valid:Y,N
  15  LogSynchronization. . . . . .     1 SYY  Log Synchronization . . . . . .YESNO
                                                DfltVal:Y Valid:Y,N
  16  CRMSQLServer. . . . . . . . .   128 SNN  CRM SQL Server. . . . . . . . .
  17  CRMSQLDatabase. . . . . . . .   128 SNN  CRM SQL Database. . . . . . . .
                                                DfltVal:CRM
  18  CRMSQLUsername. . . . . . . .   128 SNN  CRM SQL Username. . . . . . . .
                                                DfltVal:sa
  19  CRMSQLPassword. . . . . . . .   128 SNN  CRM SQL Password. . . . . . . .
  20  CRMSQLIntegratedSecurity. . .     1 SNN  CRM SQL Integrated Security . .YESNO
                                                DfltVal:N Valid:Y,N
  21  CRMWebPortalAddress . . . . .   128 SNN  CRM Web Portal Address. . . . .
  22  CRMVirtualDirectoryPath . . .   128 SNN  SageCRM Virtual Directory Path.
  23  DataVersion . . . . . . . . .  5.2  NNN  Data Version. . . . . . . . . .
                                                Mask:#0.00
  24  DataSublevel. . . . . . . . .  2.0  NNN  Data Sub Level. . . . . . . . .
                                                Mask:#0 Valid:0-99
  25  AllowOTFOpportunities . . . .     1 SYN  Allow On-the-Fly Opportunities.YESNO
                                                DfltVal:N Valid:Y,N
  26  DateUpdated . . . . . . . . .     8 SNN  Last Update Date. . . . . . . .DATE
                                                Read Only:Y
  27  TimeUpdated . . . . . . . . .     8 SNN  Last Update Time. . . . . . . .
                                                Read Only:Y
  28  UserUpdatedKey. . . . . . . .    10 SNN  Last Update User ID . . . . . .USER
                                                Read Only:Y Mask:0000000000