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