Lawson Insight Technical Documentation |
|
WEBUSER
WEBUSER FILE
REFERENCED BY
LO15.1 LO15.2 LO15.3 LO16.1 LO30.1 LO61.1
LO63.1 RD03.1 RD40.1 RD40.2 RD60.1 LO12.1
LO920
UPDATED BY
LO14.3 LO900 LX900 RD30.1 RD30.2 RD50.1
RD50.2 RD70.1 RD70.2 RD930
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WUR-WEB-USER Alpha 80 (Lower Case) LO14.3 RD30.1
Element: Web User RD50.1 RD70.1
RD930
WUR-EMPLOYEE Numeric 9 RD30.1 RD50.1
Element: Employee RD70.1 RD930
WUR-REQUESTER Alpha 10 (Lower Case) RD30.1 RD50.1
Element: Requester RD70.1 RD930
WUR-TYPE Alpha 2 LO900 RD30.1
Element: Type EM = Employee RD50.1 RD70.1
VN = Vendor RD930
CU = Customer
PR = Prospect
PA = Partner
BU = Buyer
AD = Administrator
RQ = Requester
FN = Finance
BD = Bidder
JU = Jed User
EC = E Console
WUR-STATUS Numeric 1 RD30.1 RD50.1
Element: Status This field contains the status of the RD70.1 RD930
transaction.
0 = Inactive
1 = Active
WUR-COMPANY Numeric 4 RD30.1 RD50.1
Element: Company RD70.1 RD930
WUR-APPROVE-CD Alpha 5 RD30.1 RD50.1
Element: Approve Cd RD70.1 RD930
WUR-CUSTOMER Alpha 9 (Right Justified) RD30.1 RD50.1
Element: Customer RD70.1 RD930
WUR-VENDOR Alpha 9 RD30.1 RD50.1
Element: Vendor RD70.1 RD930
WUR-VENDOR-GROUP Alpha 4 RD30.1 RD50.1
Element: Vendor Group RD70.1 RD930
WUR-BUYER-CODE Alpha 3 RD30.1 RD50.1
Element: Buyer Code RD70.1 RD930
WUR-PROSPECT Alpha 9 (Right Justified) RD30.1 RD50.1
Element: Prospect RD70.1 RD930
WUR-PARTNER Alpha 9 RD30.1 RD50.1
Element: Partner RD70.1 RD930
WUR-EMAIL Alpha 100 (Lower Case) RD30.1 RD50.1
Element: Email RD70.1 RD930
WUR-LOGIN Alpha 20 (Lower Case) RD30.1 RD50.1
Element: Login RD70.1 RD930
WUR-CUST-GROUP Alpha 5 RD30.1 RD50.1
Element: Customer Group RD70.1 RD930
WUR-CONTACT-ID Numeric 4
Element: Contact Id
WUR-ACCT-UNIT Alpha 15 RD930
Element: Accounting Unit
WUR-VIEW-CONTRACTS Alpha 1 LO900 RD930
Element: View Contracts
WUR-PRODLINE Alpha 14 RD30.1 RD50.1
Element: Prodline RD70.1 RD930
WUR-PRODLINE2 Alpha 15 RD30.1 RD50.1
Element: Prodline2 RD70.1 RD930
WUR-ACCESS Alpha 1 LO900 RD30.1
Element: Access RD50.1 RD70.1
RD930
WUR-VENDOR-LOC Alpha 4 RD930
Element: Vendor Loc
WUR-ALLOWJOBQUEUE Alpha 1 LO900 RD30.1
Element: Allowjobqueue RD50.1 RD70.1
RD930
WUR-APP-LOGIN Alpha 20 (Lower Case) RD930
Element: App Login
WUR-OBJ-ID Numeric 12 LO900 LX900
Element: Obj Id RD930
WUR-ACGRP-COLLECT Alpha 15 RD30.1 RD50.1
Element: Acgrp Collect RD70.1 RD930
WUR-ACTIVITY-LIST Alpha 12 RD30.1 RD50.1
Element: Activity List RD70.1 RD930
WEBUSER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WURSET1 WEB-USER LO14.1 LO14.2
LO14.3 LO15.1
LO15.2 LO15.3
LO16.1 LO30.1
LO61.1 LO63.1
LO900 LX900
RD03.1 RD30.1
RD30.2 RD40.1
RD40.2 RD50.1
RD50.2 RD60.1
RD70.1 RD70.2
RD930
WURSET2 COMPANY KeyChangeDuplicates
EMPLOYEE
WURSET3 REQUESTER KeyChangeDuplicates
WURSET4 VENDOR-GROUP KeyChangeDuplicates
VENDOR
WURSET5 CUST-GROUP KeyChangeDuplicates
CUSTOMER
WURSET6 OBJ-ID KeyChange, Subset LO12.1 LO14.3
Where (OBJ-ID != Zeroes ) LO900 LO920
WEBUSER FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Global Opts USEROPTS Required
"lawson -> USO-WEB-USER
Sirdidhdr SIRDIDHDR Required
WUR-WEB-USER -> IDH-WEB-USER
Sirdidlgn SIRDIDLGN Not Required, Delete Cascades
IDH-ID -> ILG-ID
"WEB " -> ILG-LOGIN-TYPE
WUR-WEB-USER -> ILG-USER-LOGIN
User Options USEROPTS Not Required, Delete Cascades
WUR-WEB-USER -> USO-WEB-USER
WEBUSER FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Attrib Values LOMXVALUE Delete Cascades
"WEBUS -> LMV-ID-TYPE
WUR-OBJ-ID -> LMV-OBJ-ID
LMV-MATRIX-TYPE
LMV-MATRIX-CAT
Lomxvalue LOMXVALUE
WUR-OBJ-ID -> LMV-OBJ-ID
LMV-MATRIX-TYPE
LMV-MATRIX-CAT
Lopersbkmk LOPERSBKMK Delete Cascades
WUR-WEB-USER -> PBM-WEB-USER
PBM-PERSONAL-BKMRK
Lousrbkmrk LOUSRBKMRK Delete Cascades
WUR-WEB-USER -> USP-WEB-USER
USP-BOOK-MARK
Lousrbkopt LOUSRBKOPT Delete Cascades
WUR-WEB-USER -> UBO-WEB-USER
UBO-BOOK-MARK
Lowdgtattr LOWDGTATTR Delete Cascades
WUR-WEB-USER -> LWA-WEB-USER
LWA-WIDGET-ID
LWA-MATRIX-CAT
Lowdgtusr LOWDGTUSR Delete Cascades
WUR-WEB-USER -> LWU-WEB-USER
LWU-WIDGET-ID
Sisched SISCHED
WUR-WEB-USER -> SSD-WEB-USER
SSD-SEQ-NUMBER
Spconfig SPCONFIG
WUR-WEB-USER -> SFG-WEB-USER
SFG-CONTID
SFG-OBJID
|