RQREQAUDIT

Requester Audit

The Requester 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 Requester.
UPDATED BY
RQ04.1 RQ194 RQ94.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RQA-COMPANY
Element: Company		Numeric 4
RQ04.1
RQA-REQUESTER
Element: Requester		Alpha 10 (Lower Case)
RQ04.1
RQA-PURCH-MAJOR
Element: Major Class		Alpha 4
This field contains the user-defined major purchasing class identifier.
RQ04.1
RQA-PURCH-MINOR
Element: Minor Class		Alpha 4
This field contains the user-defined minor purchasing class identifier.
RQ04.1
RQA-ACCT-UNIT
Element: Acct Unit		Alpha 15
RQ04.1
RQA-DIST-COMPANY
Element: Company		Numeric 4
RQ04.1
RQA-DATE
Element: Date		Numeric 8 (yyyymmdd)
RQ04.1
RQA-TIME
Element: Time		Numeric 8
This field displays the system time when this was created.
RQ04.1
RQA-FLD-NBR
Element: Fld Nbr		Numeric 4
RQ04.1
RQA-BEFORE-IMAGE
Element: Field Value		Alpha 60
RQ04.1
RQA-AFTER-IMAGE
Element: Field Value		Alpha 60
This field contains the field image after the change.
RQ04.1
RQA-OPERATOR
Element: Operator		Alpha 10
RQ04.1
RQA-DESCRIPTION
Element: Description		Alpha 30 (Lower Case)
RQ04.1
RQA-AUDIT-ACTION
Element: Audit Action		Alpha 1

A = Add
C = Change
D = Delete
RQ04.1


RQREQAUDIT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RQASET1 COMPANY
REQUESTER
PURCH-MAJOR
PURCH-MINOR
ACCT-UNIT
DIST-COMPANY
DATE*
TIME*
FLD-NBR
RQ04.1 RQ194
RQ94.1


RQREQAUDIT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Glnames GLNAMES Not Required
RQA-COMPANY->GLN-COMPANY
RQA-ACCT-UNIT->GLN-ACCT-UNIT
Iccompany ICCOMPANY Required
RQA-COMPANY->ICC-COMPANY
Majorcl MAJORCL Not Required
ICC-ITEM-GROUP->MAJ-ITEM-GROUP
"P"->MAJ-CLASS-TYPE
RQA-PURCH-MAJOR->MAJ-MAJOR-CLASS
Minorcl MINORCL Not Required
ICC-ITEM-GROUP->MIN-ITEM-GROUP
"P"->MIN-CLASS-TYPE
RQA-PURCH-MAJOR->MIN-MAJOR-CLASS
RQA-PURCH-MINOR->MIN-MINOR-CLASS
Requester REQUESTER Required
RQA-COMPANY->REQ-COMPANY
RQA-REQUESTER->REQ-REQUESTER
Rqacctu RQACCTU Not Required
RQA-COMPANY->RQU-COMPANY
RQA-REQUESTER->RQU-REQUESTER
RQA-ACCT-UNIT->RQU-ACCT-UNIT
RQA-DIST-COMPANY->RQU-DIST-COMPANY
Rqpurchcls RQPURCHCLS Not Required
RQA-COMPANY->RQP-COMPANY
RQA-REQUESTER->RQP-REQUESTER
RQA-PURCH-MAJOR->RQP-PURCH-MAJOR
RQA-PURCH-MINOR->RQP-PURCH-MINOR

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

Home
Contact Us



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