The Requisition 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 Requisition.
UPDATED BY
| FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
RHA-COMPANY
Element: Company | Numeric 4
|
|
RHA-REQ-NUMBER
Element: Req Number | Numeric 7
|
|
RHA-LINE-NBR
Element: Line Nbr | Numeric 6
|
|
RHA-LINE-SEQ
Element: Seq | Numeric 3
This is the sequence number for a
distribution.
|
|
RHA-BIN
Element: Bin | Alpha 7
|
|
RHA-LOT-SERIAL
Element: Serial | Alpha 16
This field contains either the serial
number or the lot number for an item or
any number of items.
|
|
RHA-UOM
Element: Uom | Alpha 4
|
|
RHA-DATE
Element: Date | Numeric 8 (yyyymmdd)
|
|
RHA-TIME
Element: Time | Numeric 8
|
|
RHA-FLD-NBR
Element: Fld Nbr | Numeric 4
|
|
RHA-AUDIT-TYPE
Element: Audit Type | Alpha 2
DS = Requisition Line Distribution
HD = Requisition Header
LD = Requisition Line Detail
LN = Requisition Line |
|
RHA-BEFORE-IMAGE
Element: Field Value | Alpha 60
|
|
RHA-AFTER-IMAGE
Element: Field Value | Alpha 60
This field contains the field image
after the change.
|
|
RHA-OPERATOR
Element: Operator | Alpha 10
|
|
RHA-DESCRIPTION
Element: Description | Alpha 30 (Lower Case)
|
|
RHA-AUDIT-ACTION
Element: Audit Action | Alpha 1
A = Add
C = Change
D = Delete
R = Release
U = Unrelease
I = Issue
P = Approve
E = Reject |
|
RELATION
NAME |
RELATED FILE |
INTEGRITY RULES / FIELD MATCH |
| Iccompany |
ICCOMPANY |
Required
| RHA-COMPANY | -> | ICC-COMPANY (ICCSET1) |
|
| Icvaluom |
ICVALUOM |
Not Required
| Valid When | | RHA-UOM | != | Spaces | |
| ICC-ITEM-GROUP | -> | ICV-ITEM-GROUP |
| RHA-UOM | -> | ICV-VALID-UOM |
|
| Itserial |
ITSERIAL |
Not Required
| Valid When | | RHA-LOT-SERIAL | != | Spaces | |
| RHA-COMPANY | -> | SER-COMPANY |
| RLN-ITEM | -> | SER-ITEM |
| RHA-LOT-SERIAL | -> | SER-SERIAL |
|
| Mmdist |
MMDIST |
Required
| When | | RHA-AUDIT-TYPE | = | "DS" | |
| RHA-COMPANY | -> | MMD-COMPANY |
| RHA-REQ-NUMBER | -> | MMD-DOC-NBR-NUM |
| RHA-LINE-NBR | -> | MMD-LINE-NBR |
| RHA-LINE-SEQ | -> | MMD-LINE-SEQ |
|
| Porlnuf |
PORLNUF |
Not Required
| Valid When | | RHA-AUDIT-TYPE | = | "LN" | |
| RHA-COMPANY | -> | UFQ-COMPANY |
| RHA-REQ-NUMBER | -> | UFQ-REQ-NUMBER |
| RHA-LINE-NBR | -> | UFQ-LINE-NBR |
|
| Porqhuf |
PORQHUF |
Not Required
| Valid When | | RHA-AUDIT-TYPE | = | "HD" | |
| RHA-COMPANY | -> | UFH-COMPANY |
| RHA-REQ-NUMBER | -> | UFH-REQ-NUMBER |
|
| Reqheader |
REQHEADER |
Required
| When | | RHA-AUDIT-TYPE | = | "HD" | |
| RHA-COMPANY | -> | RQH-COMPANY |
| RHA-REQ-NUMBER | -> | RQH-REQ-NUMBER |
|
| Reqline |
REQLINE |
Required
| When | | RHA-AUDIT-TYPE | = | "LN" | |
| RHA-COMPANY | -> | RLN-COMPANY |
| RHA-REQ-NUMBER | -> | RLN-REQ-NUMBER |
| RHA-LINE-NBR | -> | RLN-LINE-NBR |
|
| Rqlinedtl |
RQLINEDTL |
Not Required
| Valid When | | RHA-AUDIT-TYPE | = | "LD" | |
| RHA-COMPANY | -> | RQD-COMPANY |
| RHA-REQ-NUMBER | -> | RQD-REQ-NUMBER |
| RHA-LINE-NBR | -> | RQD-LINE-NBR |
| RHA-BIN | -> | RQD-BIN |
| RHA-LOT-SERIAL | -> | RQD-LOT-SERIAL |
| RHA-UOM | -> | RQD-UOM |
|
