Lawson Insight Technical Documentation |
|
SIRDIDXREF
SIRDIDXREF FILE
REFERENCED BY
RD61.1
UPDATED BY
RD41.1 RD41.2 RD941 RD990
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
XRF-XREF-ID Numeric 12 RD41.1 RD41.2
Element: Xref Id RD941 RD990
XRF-XREF-TYPE Alpha 15 (Lower Case) RD41.1 RD41.2
Element: Xref Type RD941 RD990
XRF-ID Alpha 20 (Lower Case) RD41.1 RD41.2
Element: Id RD941 RD990
XRF-EXTERNAL-ID Alpha 180 (Lower Case) RD41.1 RD41.2
Element: External Id RD941 RD990
XRF-NAMESPACE-ID Alpha 20 (Lower Case) RD41.2 RD941
Element: Namespace Id RD990
XRF-DATE Numeric 8 (yyyymmdd)
Element: Date This field contains the system date
when this was created.
XRF-TIME Numeric 6 (hhmmss)
Element: Time
SIRDIDXREF FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
XRFSET1 XREF-ID RD41.1 RD41.2
RD941 RD990
XRFSET2 ID KeyChange RD41.1 RD41.2
XREF-TYPE RD41.3 RD41.4
EXTERNAL-ID
XRFSET3 XREF-TYPE KeyChange RD41.1 RD41.2
EXTERNAL-ID RD61.1 RD941
RD990
SIRDIDXREF FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Sirdidhdr SIRDIDHDR Required
XRF-ID -> IDH-ID
Sirdxrftyp SIRDXRFTYP Required
XRF-XREF-TYPE -> XRT-XREF-TYPE
SIRDIDXREF FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Sirdxrfdtl SIRDXRFDTL Delete Cascades
XRF-XREF-ID -> XRD-XREF-ID
XRD-ATTRIBUTE
Sirdxtydef SIRDXTYDEF
XRF-XREF-TYPE -> XTY-XREF-TYPE
XTY-ATTRIBUTE
|