SY1UID I/T User ID File (SY1UID_ITUserIDFile) Level: 4.40 Record Type: 1 User ID Record 08/28/2009 File Type: Mkeyed Key Size: 15 Rec Len: 793 Min Len: 791 Define: Y
Main Key (KNO=0)UserID(1,15) 2nd Key (KNO=1) UserType(41,1)+CompanyCode(42,3)+ApplicationMasterFileNumber(45,9)+UserID(1,15) 3rd Key (KNO=2) Guid(355,40) 4th Key (KNO=3) EMailAddress(303,50) 5th Key (KNO=4) CompanyCode(42,3)+UserID(1,15) 6th Key (KNO=5) ApplicationMasterFileNumber(45,9)+ContactCode(54,10)+CompanyCode(42,3) 7th Key (KNO=6) CurrentlyLoggedOn(64,1)+UserID(1,15)+CompanyCode(42,3)+ApplicationMasterFileNumber(45,9) 8th Key (KNO=7) CompanyCode(42,3)+ApplicationMasterFileNumber(45,9)+UserID(1,15) 9th Key (KNO=8) CompanyCode(42,3)+EMailAddress(303,50)
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
User ID . . . . . . . . . . . . . . . . UserID. . . . . . . . . . . . Uppercase *(1,15) Password. . . . . . . . . . . . . . . . Password. . . . . . . . . . . String (16,25) User Type . . . . . . . . . . . . . . . UserType. . . . . . . . . . . Uppercase (41,1) Company Code. . . . . . . . . . . . . . CompanyCode . . . . . . . . . Uppercase (42,3) Application Master File Number. . . . . ApplicationMasterFileNumber . Account (45,9) Contact Code. . . . . . . . . . . . . . ContactCode . . . . . . . . . Uppercase (54,10) Currently Logged On . . . . . . . . . . CurrentlyLoggedOn . . . . . . Yes/No (64,1) Date of Last on Session . . . . . . . . DateofLastonSession . . . . . Date (65,6) Time of Last Request. . . . . . . . . . TimeofLastRequest . . . . . . String (71,6) User Name . . . . . . . . . . . . . . . UserName. . . . . . . . . . . String (77,30) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (107,10) Address 1 . . . . . . . . . . . . . . . Address1. . . . . . . . . . . String (117,30) Address 2 . . . . . . . . . . . . . . . Address2. . . . . . . . . . . String (147,30) Address 3 . . . . . . . . . . . . . . . Address3. . . . . . . . . . . String (177,30) City. . . . . . . . . . . . . . . . . . City. . . . . . . . . . . . . String (207,20) State . . . . . . . . . . . . . . . . . State . . . . . . . . . . . . Uppercase (227,2) Zip Code. . . . . . . . . . . . . . . . ZipCode . . . . . . . . . . . String (229,10) Country Code. . . . . . . . . . . . . . CountryCode . . . . . . . . . Uppercase (239,3) Telephone 1 . . . . . . . . . . . . . . Telephone . . . . . . . . . . String (242,17) Extension 1 . . . . . . . . . . . . . . Extension . . . . . . . . . . String (259,5) Telephone 2 . . . . . . . . . . . . . . Telephone2. . . . . . . . . . String (264,17) Extension 2 . . . . . . . . . . . . . . Extension2. . . . . . . . . . String (281,5) Fax Number. . . . . . . . . . . . . . . FaxNumber . . . . . . . . . . String (286,17) E-Mail Address. . . . . . . . . . . . . EMailAddress. . . . . . . . . String (303,50) Supervisor. . . . . . . . . . . . . . . Supervisor. . . . . . . . . . Yes/No (353,1) Allow Submission of Sales Orders. . . . AllowSubmissionofSalesOrders. Yes/No (354,1) Guid. . . . . . . . . . . . . . . . . . Guid. . . . . . . . . . . . . String (355,40) Suspend Access. . . . . . . . . . . . . SuspendAccess . . . . . . . . Yes/No (395,1) Include All Invoice Numbers . . . . . . SO_InvoiceInclAllInvNos . . . Yes/No (396,1) Starting Invoice Number . . . . . . . . SO_InvoiceStartingInvNo . . . String (397,7) Ending Invoice Number . . . . . . . . . SO_InvoiceEndingInvNo . . . . String (404,7) Include All Invoice Dates . . . . . . . SO_InvoiceInclAllInvDates . . Yes/No (411,1) Starting Invoice Date . . . . . . . . . SO_InvoiceStartingInvDate . . Date (412,6) Ending Invoice Date . . . . . . . . . . SO_InvoiceEndingInvDate . . . Date (418,6) Include Invoices With Zero Balance. . . SO_InvoiceInclInvWithZeroBal. Yes/No (424,1) Include Transaction Detail. . . . . . . SO_InvoiceInclTransDetail . . Yes/No (425,1) Calculate Account Balance . . . . . . . SO_InvoiceCalcAccountBal. . . Yes/No (426,1) Open Sales Order Inq Settings . . . . . . . . . . . . . . . . . . . Memo Include All Sales Order Numbers . . . . SO_InquiryIncAll_SO_Nos . . . Yes/No (427,1) Starting Sales Order Number . . . . . . SO_InquiryStartingSO_No . . . String (428,7) Ending Sales Order Number . . . . . . . SO_InquiryEndingSO_No . . . . String (435,7) Include All Sales Order Dates . . . . . SO_InquiryInclAllSO_Dates . . Yes/No (442,1) Starting Sales Order Date . . . . . . . SO_InquiryStartingSO_Date . . Date (443,6) Ending Sales Order Date . . . . . . . . SO_InquiryEndingSO_Date . . . Date (449,6) Include All Ship Dates. . . . . . . . . SO_InquiryInclAllShipDates. . Yes/No (455,1) Starting Ship Date. . . . . . . . . . . SO_InquiryStartingShipDate. . Date (456,6) Ending Ship Date. . . . . . . . . . . . SO_InquiryEndingShipDate. . . Date (462,6) Include Order Types (SBQMR) . . . . . . SO_InquiryInclOrderTypes. . . Uppercase (468,5) Customer PO Number, SO Inquiry. . . . . SO_InquiryCustomerPO_No . . . String (473,15) SO History Inquiry Options. . . . . . . . . . . . . . . . . . . . . Memo Include All Sales Order Numbers . . . . SO_HistoryIncAll_SO_Nos . . . Yes/No (488,1) Starting Sales Order Number . . . . . . SO_HistoryStartingSO_No . . . String (489,7) Ending Sales Order Number . . . . . . . SO_HistoryEndingSO_No . . . . String (496,7) Include All Sales Order Dates . . . . . SO_HistoryInclAllSO_Dates . . Yes/No (503,1) Starting Sales Order Date . . . . . . . SO_HistoryStartingSO_Date . . Date (504,6) Ending Sales Order Date . . . . . . . . SO_HistoryEndingSO_Date . . . Date (510,6) Customer PO Number, SO History. . . . . SO_HistoryCustomerPO_No . . . String (516,15) Title . . . . . . . . . . . . . . . . . Title . . . . . . . . . . . . String (531,15) Include All RMA Numbers . . . . . . . . IncludeAllRMANumbers. . . . . Yes/No (546,1) Starting RMA Number . . . . . . . . . . StartingRMANumber . . . . . . Account (547,7) Ending RMA Number . . . . . . . . . . . EndingRMANumber . . . . . . . Account (554,7) Include All RMA Dates . . . . . . . . . IncludeAllRMADates. . . . . . Yes/No (561,1) Starting RMA Date . . . . . . . . . . . StartingRMADate . . . . . . . Date (562,6) Ending RMA Date . . . . . . . . . . . . EndingRMADate . . . . . . . . Date (568,6) Include All Receipt Dates . . . . . . . IncludeAllReceiptDates. . . . Yes/No (574,1) Starting Receipt Date . . . . . . . . . StartingReceiptDate . . . . . Date (575,6) Ending Receipt Date . . . . . . . . . . EndingReceiptDate . . . . . . Date (581,6) RMA Status Selections (HNOPR) . . . . . RMAStatusSelections . . . . . Uppercase (587,5) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (592,200) ________ Total Bytes 793