RQRQLAUDIT

Requesting Location Audit

The Requesting Location Audit table is created as a result of choosing the audit option in IC01.1 (IC Company). When this option is selected, entries to this table are added whenever changes are made to a Requesting Location.
UPDATED BY
AP510 IC64.1 IC64.2 IC64.3 IC64.4 IC64.5
IC64.6 IC64.7 IC64.8 IC64.9 IC81.1 IC840
RQ01.1 RQ191 RQ810 RQ91.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RLA-COMPANY
Element: Company		Numeric 4
AP510 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC81.1 IC840
RQ01.1 RQ810
RLA-REQ-LOCATION
Element: Req Location		Alpha 5
AP510 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC81.1 IC840
RQ01.1 RQ810
RLA-DATE
Element: Date		Numeric 8 (yyyymmdd)
AP510 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC81.1 IC840
RQ01.1 RQ810
RLA-TIME
Element: Time		Numeric 8
This field displays the system time when this was created.
AP510 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC81.1 IC840
RQ01.1 RQ810
RLA-FLD-NBR
Element: Fld Nbr		Numeric 4
This field contains a unique number assigned to a field that identifies the description of the field.
AP510 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC81.1 IC840
RQ01.1 RQ810
RLA-BEFORE-IMAGE
Element: Field Val		Alpha 35
AP510 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC81.1 IC840
RQ01.1 RQ810
RLA-AFTER-IMAGE
Element: Field Val		Alpha 35
This field contains the field image after the change.
AP510 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC81.1 IC840
RQ01.1 RQ810
RLA-OPERATOR
Element: Operator		Alpha 10
AP510 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC81.1 IC840
RQ01.1 RQ810
RLA-DESCRIPTION
Element: Description		Alpha 30 (Lower Case)
AP510 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC81.1 IC840
RQ01.1 RQ810
RLA-AUDIT-ACTION
Element: Audit Action		Alpha 1

A = Add
C = Change
D = Delete
AP510 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC81.1 IC840
RQ01.1 RQ810


RQRQLAUDIT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RLASET1 COMPANY
REQ-LOCATION
DATE*
TIME*
FLD-NBR
AP510 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC81.1 IC840
RQ01.1 RQ191
RQ810 RQ91.1


RQRQLAUDIT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Iccompany ICCOMPANY Required
RLA-COMPANY->ICC-COMPANY
Rqloc RQLOC Required
RLA-COMPANY->RQL-COMPANY
RLA-REQ-LOCATION->RQL-REQ-LOCATION

File created: Thu Jun 09 02:32:09 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.