Lawson Insight Technical Documentation |
|
SIRDIDHDR
SIRDIDHDR FILE
REFERENCED BY
BS40.1 BS70.1 BS99.1 BS99.2 BS99.3 BS99.4
LX90.3 LX90.2 LX90.4 LX90.5 LX995 RD06.1
RD06.2 RD06.3 RD10.1 RD10.2 RD25.1 RD25.2
RD32.1 RD32.2 RD32.3 RD32.4 RD32.5 RD32.6
RD34.1 RD40.1 RD40.2 RD41.1 RD41.2 RD41.3
RD41.4 RD54.2 RD54.4 RD54.6 RD54.7 RD54.8
RD54.9 RD55.2 RD55.4 RD55.6 RD55.7 RD55.8
RD55.9 RD56.1 RD64.1 RD64.2 RD64.3 RD65.2
RD65.3 RD87.1 RD87.2 RD88.3 RD88.4 RD88.5
RD90.1 RD941 RD955 RD96.1 WF12.1 WF12.2
WF12.3 WF12.4 WF12.5 WF200 WF205 LO12.1
LO920 RD990 LO14.3 LO30.1 LO63.1 LO901
LX95.1
UPDATED BY
LO900 RD30.1 RD30.2 RD50.1 RD50.2 RD70.1
RD70.2 RD930
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IDH-ID Alpha 20 (Lower Case) LO900 RD30.1
Element: Id RD30.2 RD50.1
RD50.2 RD70.1
RD70.2 RD930
IDH-RECORD-TYPE Numeric 2 LO900 RD30.1
Element: Record Type This field identifies the type of RD30.2 RD50.1
record defined. RD50.2 RD70.1
RD70.2 RD930
Valid values are:
S=Summary
D=Detail
01 = People
02 = Organizations
03 = Things
09 = Universal
IDH-ID-STATUS Numeric 1 LO900 RD30.1
Element: Id Status 1 = Active RD30.2 RD50.1
2 = Inactive RD50.2 RD70.1
9 = Historical RD70.2 RD930
IDH-OBJ-ID Numeric 12 LO900 RD30.1
Element: Obj Id RD30.2 RD50.1
RD50.2 RD70.1
RD70.2 RD930
IDH-WEB-USER Alpha 80 (Lower Case) LO900 RD30.1
Element: Web User RD50.1 RD70.1
RD930
IDH-ID-TYPE Alpha 15 (Lower Case) LO900 RD30.1
Element: Id Type RD30.2 RD50.1
RD50.2 RD70.1
RD70.2 RD930
IDH-DESCRIPTION Alpha 50 (Lower Case) LO900 RD30.1
Element: Description This field contains the description. RD30.2 RD50.1
RD50.2 RD70.1
RD70.2 RD90.1
RD930
IDH-DATE Numeric 8 (yyyymmdd) LO900 RD30.1
Element: Date This field contains the system date RD30.2 RD50.1
when this was created. RD50.2 RD70.1
RD70.2 RD930
IDH-TIME Numeric 6 (hhmmss) LO900 RD30.1
Element: Time RD30.2 RD50.1
RD50.2 RD70.1
RD70.2 RD930
IDH-SH-WEB-USER Derived
Element: Sh Web User
SIRDIDHDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IDHSET1 ID BS40.1 BS70.1
BS99.1 BS99.2
BS99.3 BS99.4
LO900 LX90.3
LX995 RD06.1
RD06.2 RD06.3
RD10.1 RD10.2
RD25.1 RD25.2
RD30.1 RD30.2
RD32.1 RD32.2
RD32.3 RD32.4
RD32.5 RD32.6
RD34.1 RD40.1
RD40.2 RD41.1
RD41.2 RD41.3
...
IDHSET2 ID-STATUS KeyChange
ID
IDHSET3 RECORD-TYPE KeyChange LX90.2 LX90.3
ID LX90.4 LX90.5
RD30.1 RD30.2
RD50.1 RD50.2
RD70.1 RD70.2
IDHSET4 OBJ-ID KeyChange, Subset LO12.1 LO900
Where OBJ-ID != Zeroes LO920 RD990
IDHSET5 RECORD-TYPE KeyChange
ID-TYPE
ID
IDHSET7 WEB-USER KeyChange, Subset LO14.3 LO30.1
Where WEB-USER != Spaces LO63.1 LO900
LO901 LX95.1
LX995 RD30.1
RD50.1 RD70.1
RD941 RD955
IDHSET8 ID-TYPE KeyChange
ID
SIRDIDHDR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Addr1 LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID (LMVSET1)
"PRIMARY " -> LMV-MATRIX-TYPE
"ADDR-1 "-> LMV-MATRIX-CAT
Addr2 LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"ADDR-2 "-> LMV-MATRIX-CAT
Addr3 LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"ADDR-3 "-> LMV-MATRIX-CAT
Addr4 LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"ADDR-4 "-> LMV-MATRIX-CAT
Addr5 LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"ADDR-5 "-> LMV-MATRIX-CAT
Comment LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"COMMENT "-> LMV-MATRIX-CAT
Company Name LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"COMPANY-NAME "-> LMV-MATRIX-CAT
Contact LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"CONTACT "-> LMV-MATRIX-CAT
Contact Name LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"CONTACT-NAME "-> LMV-MATRIX-CAT
Country LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"COUNTRY "-> LMV-MATRIX-CAT
Date LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"DATE "-> LMV-MATRIX-CAT
Description LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"DESCRIPTION "-> LMV-MATRIX-CAT
District LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"DISTRICT "-> LMV-MATRIX-CAT
Edi Nbr LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"EDI-NBR "-> LMV-MATRIX-CAT
Email LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"EMAIL "-> LMV-MATRIX-CAT
Fax Email LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"FAX-EMAIL "-> LMV-MATRIX-CAT
Fax Nbr LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"FAX-NBR "-> LMV-MATRIX-CAT
Fax Pre LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"FAX-PRE "-> LMV-MATRIX-CAT
Fax Suf LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"FAX-SUF "-> LMV-MATRIX-CAT
Group LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"GROUP "-> LMV-MATRIX-CAT
Group Name LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"GROUP-NAME "-> LMV-MATRIX-CAT
Job Dept LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"JOB-DEPT "-> LMV-MATRIX-CAT
Job Title LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"JOB-TITLE "-> LMV-MATRIX-CAT
Locality LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"LOCALITY "-> LMV-MATRIX-CAT
Memo LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"MEMO "-> LMV-MATRIX-CAT
Mobile Nbr LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"MOBILE-NBR "-> LMV-MATRIX-CAT
Mobile Pre LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"MOBILE-PRE "-> LMV-MATRIX-CAT
Mobile Suf LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"MOBILE-SUF "-> LMV-MATRIX-CAT
Mtx Desc LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"MTX-DESC "-> LMV-MATRIX-CAT
Mtx Type LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"MTX-TYPE "-> LMV-MATRIX-CAT
Name First LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"NAME-FIRST "-> LMV-MATRIX-CAT
Name Last LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"NAME-LAST "-> LMV-MATRIX-CAT
Name Legal LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"NAME-LEGAL "-> LMV-MATRIX-CAT
Name Middle LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"NAME-MIDDLE "-> LMV-MATRIX-CAT
Name Middle I LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"NAME-MIDDLE-I "-> LMV-MATRIX-CAT
Name Prefix LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"NAME-PREFIX "-> LMV-MATRIX-CAT
Name Search LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"NAME-SEARCH "-> LMV-MATRIX-CAT
Name Suffix LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"NAME-SUFFIX "-> LMV-MATRIX-CAT
Nick Name LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"NICK-NAME "-> LMV-MATRIX-CAT
Page Email LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"PAGE-EMAIL "-> LMV-MATRIX-CAT
Page Nbr LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"PAGE-NBR "-> LMV-MATRIX-CAT
Page Pre LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"PAGE-PRE "-> LMV-MATRIX-CAT
Page Suf LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"PAGE-SUF "-> LMV-MATRIX-CAT
Phone Nbr LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"PHONE-NBR "-> LMV-MATRIX-CAT
Phone Pre LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"PHONE-PRE "-> LMV-MATRIX-CAT
Phone Suf LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"PHONE-SUF "-> LMV-MATRIX-CAT
Picture LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"PICTURE "-> LMV-MATRIX-CAT
Port LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"PORT "-> LMV-MATRIX-CAT
Postal Box LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"POSTAL-BOX "-> LMV-MATRIX-CAT
Postal Cd LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"POSTAL-CD "-> LMV-MATRIX-CAT
Region LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"REGION "-> LMV-MATRIX-CAT
Register Id LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"REGISTER-ID "-> LMV-MATRIX-CAT
Sirdtype SIRDTYPE Required
IDH-ID-TYPE -> IDT-ID-TYPE
State Prov LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"STATE-PROV "-> LMV-MATRIX-CAT
Structure LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"STRUCTURE "-> LMV-MATRIX-CAT
Tax Id LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"TAX-ID "-> LMV-MATRIX-CAT
Telex Nbr LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"TELEX-NBR "-> LMV-MATRIX-CAT
Time LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"TIME "-> LMV-MATRIX-CAT
Url LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"URL "-> LMV-MATRIX-CAT
Useropts USEROPTS Required
IDH-WEB-USER -> USO-WEB-USER
Webuser WEBUSER Required
IDH-WEB-USER -> WUR-WEB-USER
Wfusrprofl WFUSRPROFL Not Required
IDH-ID -> WFU-ID
SIRDIDHDR FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Bsidchan BSIDCHAN
IDH-ID -> ICH-ID
ICH-ORDER-OPT
ICH-CHANNEL
Bsidchfld BSIDCHFLD
IDH-ID -> ICF-ID
ICF-CHANNEL
ICF-ORDER-OPT
ICF-FOLDER
Bsidpub BSIDPUB
IDH-ID -> IPB-ID
IPB-PUBLISH
Bslistgrp BSLISTGRP
IDH-ID -> LGR-ID
LGR-GROUP
LGR-LIST
Bssubscr BSSUBSCR
IDH-ID -> SUB-ID
SUB-GROUP
Lomxvalue LOMXVALUE
IDH-OBJ-ID -> LMV-OBJ-ID
LMV-MATRIX-TYPE
LMV-MATRIX-CAT
Lowdgtusr LOWDGTUSR Delete Cascades
IDH-WEB-USER -> LWU-WEB-USER
LWU-WIDGET-ID
Mxidobjcat MXIDOBJCAT
IDH-ID-TYPE -> IOC-ID-TYPE
IOC-MATRIX-TYPE
IOC-MATRIX-CAT
Mxobjcat MXOBJCAT
IDH-ID-TYPE -> MOC-ID-TYPE
MOC-MATRIX-TYPE
Sibslistid SIBSLISTID
IDH-ID -> LSD-ID
LSD-LIST
Sirdcollct SIRDCOLLCT
IDH-ID -> COL-ID
COL-COLLECTION
Sirdgrpid SIRDGRPID
IDH-ID -> GID-ID
GID-ROLE
GID-GROUP
Sirdidcol SIRDIDCOL
IDH-ID -> ICL-ID
ICL-COLLECTION
ICL-NON-MEMBER-ID
ICL-MEMBER-ID
Sirdidgrp SIRDIDGRP
IDH-ID -> WDG-ID
WDG-GROUP
Sirdidlgn SIRDIDLGN
IDH-ID -> ILG-ID
ILG-LOGIN-TYPE
ILG-USER-LOGIN
Sirdidpref SIRDIDPREF
IDH-ID -> SIP-ID
SIP-SYSTEM-NAME
SIP-FIELD-NAME
Sirdidrole SIRDIDROLE Delete Cascades
IDH-ID -> SIR-ID
SIR-ROLE
Sirdidstt SIRDIDSTT
IDH-ID -> IDS-ID
IDS-STRUCTURE
Sirdlevel SIRDLEVEL
IDH-ID-TYPE -> SLV-ID-TYPE
SLV-LEVEL
Sirdnonmem SIRDNONMEM
IDH-ID -> CDT-ID
CDT-NON-MEMBER-ID
Sirdproxy SIRDPROXY
IDH-ID -> PXY-ID
PXY-PROXY-ID
Sirdstrdtl SIRDSTRDTL
IDH-ID -> STD-ID
STD-STRUCTURE
STD-LEVEL
STD-LEVEL-PARENT
Sirdstruct SIRDSTRUCT
IDH-ID-TYPE -> STR-ID-TYPE
STR-STRUCTURE
Sisched SISCHED
IDH-WEB-USER -> SSD-WEB-USER
SSD-SEQ-NUMBER
|