Lawson Insight Technical Documentation |
|
PORQHUF
PORQHUF FILE
REFERENCED BY
RQII.1
UPDATED BY
RQ10.1 RQ10.3 RQ11.1 RQ13.2 RQ35.1 RQ500
RQIB.1 RQIF.1 RQIJ.1 RQ300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
UFH-COMPANY Numeric 4 RQ10.1 RQ10.3
Element: Company Identifies the AP company if the RQ11.1 RQ13.2
resource type = V. Identifies the HR RQ35.1 RQ500
company if the resource type = E. It is RQIB.1 RQIF.1
blank for type A, P or Q resources. RQIJ.1
UFH-REQ-NUMBER Numeric 7 RQ10.1 RQ10.3
Element: Req Number This is the assigned number to identify RQ11.1 RQ13.2
this requisition. RQ35.1 RQ500
RQIB.1 RQIF.1
RQIJ.1
UFH-RQH-USR-FLD-01 Alpha 20 RQ10.1 RQ10.3
Element: Rqh Usr Fld 01 RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQIJ.1
UFH-RQH-USR-FLD-02 Alpha 20 RQ10.1 RQ10.3
Element: Rqh Usr Fld 02 RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQIJ.1
UFH-RQH-USR-FLD-03 Alpha 20 RQ10.1 RQ10.3
Element: Rqh Usr Fld 03 RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQIJ.1
UFH-RQH-USR-FLD-04 Alpha 20 RQ10.1 RQ10.3
Element: Rqh Usr Fld 04 RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQIJ.1
UFH-RQH-USR-FLD-05 Alpha 20 RQ10.1 RQ10.3
Element: Rqh Usr Fld 05 RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQIJ.1
PORQHUF FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
UFHSET1 COMPANY RQ10.1 RQ10.3
REQ-NUMBER RQ11.1 RQ13.2
RQ300 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
PORQHUF FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Reqheader REQHEADER Required
UFH-COMPANY -> RQH-COMPANY
UFH-REQ-NUMBER -> RQH-REQ-NUMBER
|