PORECADJHD FILE
Receiving Adjustments Header
REFERENCED BY
POI4.1 POI6.1 POIJ.1 MA63.1 PO199
UPDATED BY
PO133
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PJH-COMPANY Numeric 4 POIJ.1
Company The company number represents an
established company and is entered on
all function codes.
PJH-DOC-TYPE Alpha 2 POIJ.1
Document Type This field contains the type of
transaction.
RA = Receiving Adjustment
IN = Inspection
PJH-DOC-NBR-NUM Numeric 10 POIJ.1
Doc Nbr Num
PJH-REFERENCE-NO Alpha 10 (Right Justified) POIJ.1
Reference No
PJH-REC-NUMBER Numeric 10 POIJ.1
Receiver Number The receiver number. Assigned when
this receiving information was added.
PJH-OPER-ID Alpha 10 POIJ.1
Operator
Identification
PJH-DATE Numeric 8 (yyyymmdd) POIJ.1
Date This field displays the system date
when this was created.
PJH-ACTUAL-TIME Numeric 4 POIJ.1
Actual Time This field contains the actual time the
receiver was entered into the system.
This filed defaults to the system date
if an actual time was not entered.
PJH-UPDATE-DATE Numeric 8 (yyyymmdd) POIJ.1
Update Date This field contains the date the record
was updated.
PJH-UPDATE-TIME Numeric 6 POIJ.1
Update Time This field contains the system time
when the record was updated.
PJH-VEN-CLAIM-TYPE Alpha 2 POIJ.1
Ven Claim Type CB = Chargeback
CM = Credit Memo
N = None
PJH-REPLACE-GOODS Alpha 1 POIJ.1
Replace Goods Y = Yes
N = No
PJH-SHIP-OR-HOLD Alpha 1 POIJ.1
Ship Or Hold S = Ship
H = Hold
PJH-STATUS Numeric 1 POIJ.1
Status This field displays the status of the
transaction.
0 = Unreleased
1 = Released
PJH-LOGGED-FLAG Alpha 1 PO133 POIJ.1
Logged Flag If set to "Y", this field indicates the
receiving or receiving adjustment log
has been run against this record in a
print all unprinted transactions mode.
Y = Yes
N = No
PJH-REC-REF-NO Derived
Rec Ref No
PORECADJHD FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PJHSET1 COMPANY PO133 POI4.1
DOC-TYPE POI6.1 POIJ.1
DOC-NBR-NUM*
PJHSET2 COMPANY KeyChange, Subset POIJ.1
DOC-TYPE Where REFERENCE-NO != Spaces
REFERENCE-NO
PJHSET3 COMPANY Subset MA63.1 PO199
REC-NUMBER Where STATUS = Zeroes POIJ.1
DOC-TYPE
DOC-NBR-NUM
PJHSET4 COMPANY KeyChange, Subset PO133
DATE Where DOC-TYPE = "RA"
DOC-NBR-NUM And STATUS = 1
PORECADJHD FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Poreceive PORECEIVE Required
PJH-COMPANY -> POR-COMPANY
PJH-REC-NUMBER -> POR-REC-NUMBER
|
