TKNAUDIT FILE
REFERENCED BY
LOOK.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TKA-PRODLINE Alpha 14
Element: Prodline
TKA-TOKEN Alpha 6
Element: Token
TKA-FC Alpha 1
Element: Fc
TKA-WEBUSER-ID Numeric 12
Element: Webuser Id
TKA-DATE Numeric 8 (yyyymmdd)
Element: Date This field contains the system date
when this was created.
TKA-TIME Numeric 6 (hhmmss)
Element: Time
TKA-RECORD-TYPE Numeric 2
Element: Record Type This field identifies the type of
record defined.
Valid values are:
S=Summary
D=Detail
TKA-SEQ Numeric 4
Element: Seq
TKA-TKN-DATA Alpha 2500 (Lower Case)
Element: Tkn Data
TKNAUDIT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TKASET1 PRODLINE LOOK.1
TOKEN
FC
WEBUSER-ID
DATE
TIME
RECORD-TYPE
SEQ
TKASET2 DATE
TIME
PRODLINE
TOKEN
FC
WEBUSER-ID
RECORD-TYPE
SEQ
TKASET3 WEBUSER-ID
PRODLINE
TOKEN
FC
DATE
TIME
RECORD-TYPE
SEQ
TKNAUDIT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Web User WEBUSER Required
TKA-WEBUSER-ID -> WUR-OBJ-ID (WURSET6)
|
