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