Lawson Insight Technical Documentation |
|
SIRDCOLLCT
SIRDCOLLCT FILE
UPDATED BY
RD25.1 RD25.2 RD32.1 RD32.2 RD32.3 RD32.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
COL-ID Alpha 20 (Lower Case) RD25.1 RD25.2
Element: Id RD32.1 RD32.2
RD32.3 RD32.4
COL-COLLECTION Alpha 20 (Lower Case) RD25.1 RD25.2
Element: Collection RD32.1 RD32.2
RD32.3 RD32.4
COL-DESCRIPTION Alpha 50 (Lower Case) RD25.1 RD25.2
Element: Description This field contains the description. RD32.1 RD32.2
RD32.3 RD32.4
COL-STATUS Numeric 1 RD25.1 RD25.2
Element: Status This field contains the status of the RD32.1 RD32.2
transaction. RD32.3 RD32.4
1 = Active
2 = Inactive
COL-DATE Numeric 8 (yyyymmdd) RD25.1 RD25.2
Element: Date This field contains the system date RD32.1 RD32.2
when this was created. RD32.3 RD32.4
COL-TIME Numeric 6 (hhmmss) RD25.1 RD25.2
Element: Time RD32.1 RD32.2
RD32.3 RD32.4
SIRDCOLLCT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
COLSET1 ID RD25.1 RD25.2
COLLECTION RD32.1 RD32.2
RD32.3 RD32.4
COLSET2 COLLECTION
ID
SIRDCOLLCT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Sirdidhdr SIRDIDHDR Required
COL-ID -> IDH-ID (IDHSET1)
SIRDCOLLCT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Sirdidcol SIRDIDCOL Delete Cascades
COL-ID -> ICL-ID
COL-COLLECTION -> ICL-COLLECTION
ICL-NON-MEMBER-ID
ICL-MEMBER-ID
|