SY_EBusinessManagerUserID             SY EBusiness Manager User ID    Rel: 4.40  Bld: 398  8/28/2009
 Bus Obj: IT_EBusinessManagerUserID_bus,IT_ShoppingCart_upd,IT_UIDCustomerChange_upd
 SQL Def: Y  SysDB: N                                          MAS_SYSTEM\SY_EBusinessManagerUserID.M4T

 KPRIMARY: UserID
 KUSERTYPE: UserType+CompanyCode+UserID
 KGUID: Guid
 KEMAILADDR: EmailAddress
 KCOMPUSER: CompanyCode+UserID
 KCONTACTCOMP: ContactCode+CompanyCode
 KLOGGEDON: CurrentlyLoggedOn+UserID+CompanyCode
 KCOMPEMAILADDR: CompanyCode+EmailAddress
 KCOMPCUSTOMER: CompanyCode+ARDivisionNo+CustomerNo+UserID

 Fld  Column Name                     M/L TUR  Description/Notes              Class

   1  UserID. . . . . . . . . . . .    15 SYY  User ID . . . . . . . . . . . .
                                                FmtType:CHARNUM Notes:
                                                {SY1UID$(1,15)}
   2  Password. . . . . . . . . . .    25 SNN  Password. . . . . . . . . . . .
                                                DepVal:REQUIRED Notes:
                                                {SY1UID$(16,25)}
   3  UserType. . . . . . . . . . .     1 SYY  UserType. . . . . . . . . . . .
                                                DfltVal:1 Valid:1,2 Notes:
                                                1=Business, 2=Customer
                                                {SY1UID$(41,1)}
   4  CompanyCode . . . . . . . . .     3 SYY  Company Code. . . . . . . . . .COMPANYCODE
                                                Notes: {SY1UID$(42,3)}
   5  ARDivisionNo. . . . . . . . .     2 SNN  AR Division Number. . . . . . .ARDIVISION
                                                Mask:00 DepVal:REQUIRED
   6  CustomerNo. . . . . . . . . .    20 SNN  Customer Number . . . . . . . .CUSTOMERNO
                                                FmtType:MASTERNUMC DepVal:REQ
                                                UIRED
   7  ContactCode . . . . . . . . .    10 SYN  Contact Code. . . . . . . . . .ARCONTACT
                                                Notes: {SY1UID$(54,10)}
   8  CurrentlyLoggedOn . . . . . .     1 SYN  Currently Logged On . . . . . .YESNO
                                                Read Only:Y DfltVal:N
                                                Valid:Y,N Notes: {SY1UID$(64,
                                                1)}
   9  DateOfLastSession . . . . . .     8 SNN  Date Of Last Sesssion . . . . .DATE
                                                Read Only:Y Notes: {SY1UID$(6
                                                5,6)}
  10  TimeOfLastRequest . . . . . .     6 SNN  Time Of Last Request. . . . . .
                                                Read Only:Y Notes: {SY1UID$(7
                                                1,6)}
  11  UserName. . . . . . . . . . .    30 SNN  User Name . . . . . . . . . . .NAME
                                                Notes: {SY1UID$(77,30)}
  12  AddressLine1. . . . . . . . .    30 SNN  Address Line 1. . . . . . . . .ADDRESSLINE
                                                Notes: {SY1UID$(117,30)}
  13  AddressLine2. . . . . . . . .    30 SNN  Address Line 2. . . . . . . . .ADDRESSLINE
                                                Notes: {SY1UID$(147,30)}
  14  AddressLine3. . . . . . . . .    30 SNN  Address Line 3. . . . . . . . .ADDRESSLINE
                                                Notes: {SY1UID$(177,30)}
  15  City. . . . . . . . . . . . .    20 SNN  City. . . . . . . . . . . . . .CITY
                                                Notes: {SY1UID$(207,20)}
  16  State . . . . . . . . . . . .     2 SNN  State . . . . . . . . . . . . .STATE
                                                Notes: {SY1UID$(227,2)}
  17  ZipCode . . . . . . . . . . .    10 SNN  Zip Code. . . . . . . . . . . .ZIPCODE
                                                Notes: {SY1UID$(229,10)}
  18  CountryCode . . . . . . . . .     3 SNN  Country Code. . . . . . . . . .COUNTRY
                                                Notes: {SY1UID$(239,3)}
  19  Title . . . . . . . . . . . .    15 SNN  Title . . . . . . . . . . . . .
                                                Notes: {SY1UID$(531,15)}
  20  TelephoneNo1. . . . . . . . .    17 SNN  Telephone Number 1. . . . . . .TELEPHONENO
                                                Notes: {SY1UID$(242,17)}
  21  TelephoneExt1 . . . . . . . .     5 SNN  Telephone Extension 1 . . . . .TELEPHONEEXT
                                                Notes: {SY1UID$(259,5)}
  22  TelephoneNo2. . . . . . . . .    17 SNN  Telephone Number 2. . . . . . .TELEPHONENO
                                                Notes: {SY1UID$(264,17)}
  23  TelephoneExt2 . . . . . . . .     5 SNN  Telephone Extension 2 . . . . .TELEPHONEEXT
                                                Notes: {SY1UID$(281,5)}
  24  FaxNo . . . . . . . . . . . .    17 SNN  Fax Number. . . . . . . . . . .TELEPHONENO
                                                Notes: {SY1UID$(286,17)}
  25  EmailAddress. . . . . . . . .    50 SNN  Email Address . . . . . . . . .EMAILADDRESS
                                                DepVal:REQUIRED Notes:
                                                {SY1UID$(303,50)}
  26  SupervisorRights. . . . . . .     1 SYN  Supervisor Rights . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N Notes:
                                                {SY1UID$(353,1)}
  27  AllowSubmissionOfShoppingCart     1 SYN  Allow Submission Of Shopping CaYESNO
                                                DfltVal:N Valid:Y,N Notes:
                                                {SY1UID$(354,1)}
  28  Guid. . . . . . . . . . . . .    40 SNN  Guid. . . . . . . . . . . . . .
                                                Read Only:Y Notes: {SY1UID$(3
                                                55,40)}
  29  SuspendAccess . . . . . . . .     1 SYN  Suspend Access. . . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N Notes:
                                                {SY1UID$(395,1)}
  30  TotalItemsInShoppingCart. . . 16.0  NNN  Total Items In Shopping Cart. .
                                                Mask:##,###,##0
  31  TotalExtAmtInShoppingCart . . 13.2  NNN  Total Extension Amount In ShoppAMOUNT
                                                Mask:###,###,###.00
  32  IncludeAllARInvoiceNos. . . .     1 SYN  Include All Accounts ReceivableYESNO
                                                DfltVal:Y Valid:Y,N Notes:
                                                {SY1UID$(396,1)}
  33  StartingARInvoiceNo . . . . .     7 SYN  Starting Accounts Receivable InINVOICE
                                                FmtType:MASTERNUM Notes:
                                                {SY1UID$(397,7)}
  34  EndingARInvoiceNo . . . . . .     7 SYN  Ending Accounts Receivable InvoINVOICE
                                                FmtType:MASTERNUM Notes:
                                                {SY1UID$(404,7)}
  35  IncludeAllARInvoiceDates. . .     1 SYN  Include All Accounts ReceivableYESNO
                                                DfltVal:Y Valid:Y,N Notes:
                                                {SY1UID$(411,1)}
  36  StartingARInvoiceDate . . . .     8 SNN  Starting Accounts Receivable InDATE
                                                Notes: {SY1UID$(412,6)}
  37  EndingARInvoiceDate . . . . .     8 SNN  Ending Accounts Receivable InvoDATE
                                                Notes: {SY1UID$(418,6)}
  38  IncludeARInvoicesWithZeroBal.     1 SYN  Include Accounts Receivable InvYESNO
                                                DfltVal:Y Valid:Y,N Notes:
                                                {SY1UID$(424,1)}
  39  IncludeARTransactionDetail. .     1 SYN  Include Accounts Receivable TraYESNO
                                                DfltVal:N Valid:Y,N Notes:
                                                {SY1UID$(425,1)}
  40  CalculateARAccountBal . . . .     1 SYN  Calculate Accounts Receivable AYESNO
                                                DfltVal:N Valid:Y,N Notes:
                                                Open Sales Order Inquiry
                                                Settings {SY1UID$(426,1)}
  41  IncludeAllOpenSalesOrderNos .     1 SYN  Include All Open Sales Order NuYESNO
                                                DfltVal:Y Valid:Y,N Notes:
                                                {SY1UID$(427,1)}
  42  StartingOpenSalesOrderNo. . .     7 SYN  Starting Open Sales Order NumbeSALESORDERNO
                                                FmtType:CHARNUM Notes:
                                                {SY1UID$(428,7)}
  43  EndingOpenSalesOrderNo. . . .     7 SYN  Ending Open Sales Order Number.SALESORDERNO
                                                FmtType:CHARNUM Notes:
                                                {SY1UID$(435,7)}
  44  IncludeAllOpenSalesOrderDates     1 SYN  Include All Open Sales Order DaYESNO
                                                DfltVal:Y Valid:Y,N Notes:
                                                {SY1UID$(442,1)}
  45  StartingOpenSalesOrderDate. .     8 SNN  Starting Open Sales Order Date.DATE
                                                Notes: {SY1UID$(443,6)}
  46  EndingOpenSalesOrderDate. . .     8 SNN  Ending Open Sales Order Dates .DATE
                                                Notes: {SY1UID$(449,6)}
  47  InclAllOpenSalesOrderShipDates    1 SYN  Include All Open Sales Order ShYESNO
                                                DfltVal:Y Valid:Y,N Notes:
                                                {SY1UID$(455,1)}
  48  StartingOpenSalesOrderShipDate    8 SNN  Starting Open Sales Order ShippDATE
                                                Notes: {SY1UID$(456,6)}
  49  EndingOpenSalesOrderShipDate.     8 SNN  Ending Open Sales Order ShippinDATE
                                                Notes: {SY1UID$(462,6)}
  50  OpenSalesOrderTypesSelection.     5 SYN  Include Sales Order Types In Se
                                                Notes: SBQMR {SY1UID$(468,5)}
  51  CustomerPONoInInquiry . . . .    15 SNN  Customer PO Number In Inquiry .CUSTOMERPONO
                                                Notes: SO History Inquiry
                                                Options {SY1UID$(473,15)}
  52  IncludeAllSalesOrderNosInHist     1 SYN  Include All Sales Order NumbersYESNO
                                                DfltVal:Y Valid:Y,N Notes:
                                                {SY1UID$(488,1)}
  53  StartingSalesOrderNoInHist. .     7 SYN  Starting Sales Order Number In SALESORDERNO
                                                FmtType:CHARNUM Notes:
                                                {SY1UID$(489,7)}
  54  EndingSalesOrderNoInHist. . .     7 SYN  Ending Sales Order Number In HiSALESORDERNO
                                                FmtType:CHARNUM Notes:
                                                {SY1UID$(496,7)}
  55  InclAllSalesOrderDatesInHist.     1 SYN  Include All Sales Order Dates IYESNO
                                                DfltVal:Y Valid:Y,N Notes:
                                                {SY1UID$(503,1)}
  56  StartingSalesOrderDateInHist.     8 SNN  Starting Sales Order Date In HiDATE
                                                Notes: {SY1UID$(504,6)}
  57  EndingSalesOrderDateInHist. .     8 SNN  Ending Sales Order Date In HistDATE
                                                Notes: {SY1UID$(510,6)}
  58  CustomerPONoInHistory . . . .    15 SNN  Customer PO Number In History .CUSTOMERPONO
                                                Notes: {SY1UID$(516,15)}
  59  IncludeAllRMANos. . . . . . .     1 SYN  Include All RMA Numbers . . . .YESNO
                                                DfltVal:Y Valid:Y,N Notes:
                                                {SY1UID$(546,1)}
  60  StartingRMANo . . . . . . . .     7 SYN  Starting RMA Number . . . . . .RMANO
                                                FmtType:CHARNUM Notes:
                                                {SY1UID$(547,7)}
  61  EndingRMANo . . . . . . . . .     7 SYN  Ending RMA Number . . . . . . .RMANO
                                                FmtType:CHARNUM Notes:
                                                {SY1UID$(554,7)}
  62  IncludeAllRMADates. . . . . .     1 SYN  Include All RMA Dates . . . . .YESNO
                                                DfltVal:Y Valid:Y,N Notes:
                                                {SY1UID$(561,1)}
  63  StartingRMADate . . . . . . .     8 SNN  Starting RMA Date . . . . . . .DATE
                                                Notes: {SY1UID$(562,6)}
  64  EndingRMADate . . . . . . . .     8 SNN  Ending RMA Date . . . . . . . .DATE
                                                Notes: {SY1UID$(568,6)}
  65  IncludeAllReceiptDates. . . .     1 SYN  Include All Receipt Dates . . .YESNO
                                                DfltVal:Y Valid:Y,N Notes:
                                                {SY1UID$(574,1)}
  66  StartingReceiptDate . . . . .     8 SNN  Starting Receipt Date . . . . .DATE
                                                Notes: {SY1UID$(575,6)}
  67  EndingReceiptDate . . . . . .     8 SNN  Ending Receipt Date . . . . . .DATE
                                                Notes: {SY1UID$(581,6)}
  68  RMAStatusSelections . . . . .     5 SYN  RMA Status Selections . . . . .
                                                Notes: HNOPR {SY1UID$(587,5)}
  69  DateCreated . . . . . . . . .     8 SNY  Creation Date . . . . . . . . .DATE
                                                Read Only:Y Notes: YYYYMMDD
  70  TimeCreated . . . . . . . . .     8 SNY  Creation Time . . . . . . . . .
                                                Read Only:Y
  71  UserCreatedKey. . . . . . . .    10 SYY  Creation User ID. . . . . . . .USER
                                                Read Only:Y Mask:0000000000
                                                FmtType:ZEROFILL
  72  DateUpdated . . . . . . . . .     8 SNN  Last Update Date. . . . . . . .DATE
                                                Read Only:Y Notes: YYYYMMDD
  73  TimeUpdated . . . . . . . . .     8 SNN  Last Update Time. . . . . . . .
                                                Read Only:Y
  74  UserUpdatedKey. . . . . . . .    10 SYN  Last Update User ID . . . . . .USER
                                                Read Only:Y Mask:0000000000
                                                FmtType:ZEROFILL