 |
Lawson Insight Technical Documentation |
|
PORECADJHD FILE
Receiving Adjustments Header
REFERENCED BY
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 IC28.1 MA180 MA43.9 MA43.3 MA530
MA60.2 MA60.3 MA60.5 MA61.1 MA66.3 MA67.1
MA67.2 MA70.1 MAI1.1 PO100 PO101 PO122
PO131 PO20.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO23.1 PO29.1 PO31.1 PO31.2 PO32.2
PO35.1 PO38.1 PO39.1 PO39.2 PO44.1 PO50.1
PO520 POI3.1 POI4.1 POI6.1 POIE.1 POII.1
POIJ.1 RQ10.1 RQ10.2 WH20.2 WH20.7 MA63.1
PO199
UPDATED BY
MA531 PO133 PO30.1 PO30.2 PO30.3 PO300
PO33.1 PO34.1 PO52.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PJH-COMPANY Numeric 4 AP125 AP126
Company The company number represents an AP131 AP25.1
established company and is entered on AP25.2 AP26.1
all function codes. AP27.1 IC28.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
WH20.2 WH20.7
PJH-DOC-TYPE Alpha 2 AP125 AP126
Document Type This field contains the type of AP131 AP25.1
transaction. AP25.2 AP26.1
RA = Receiving Adjustment AP27.1 IC28.1
IN = Inspection MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
WH20.2 WH20.7
PJH-DOC-NBR-NUM Numeric 10 AP125 AP126
Doc Nbr Num AP131 AP25.1
AP25.2 AP26.1
AP27.1 IC28.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
WH20.2 WH20.7
PJH-REFERENCE-NO Alpha 10 (Right Justified) AP125 AP126
Reference No AP131 AP25.1
AP25.2 AP26.1
AP27.1 IC28.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
WH20.2 WH20.7
PJH-REC-NUMBER Numeric 10 AP125 AP126
Receiver Number The receiver number. Assigned when AP131 AP25.1
this receiving information was added. AP25.2 AP26.1
AP27.1 IC28.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
WH20.2 WH20.7
PJH-OPER-ID Alpha 10 AP125 AP126
Operator AP131 AP25.1
Identification AP25.2 AP26.1
AP27.1 IC28.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
WH20.2 WH20.7
PJH-DATE Numeric 8 (yyyymmdd) AP125 AP126
Date This field displays the system date AP131 AP25.1
when this was created. AP25.2 AP26.1
AP27.1 IC28.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
WH20.2 WH20.7
PJH-ACTUAL-TIME Numeric 4 AP125 AP126
Actual Time This field contains the actual time the AP131 AP25.1
receiver was entered into the system. AP25.2 AP26.1
This filed defaults to the system date AP27.1 IC28.1
if an actual time was not entered. MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
WH20.2 WH20.7
PJH-UPDATE-DATE Numeric 8 (yyyymmdd) AP125 AP126
Update Date This field contains the date the record AP131 AP25.1
was updated. AP25.2 AP26.1
AP27.1 IC28.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
WH20.2 WH20.7
PJH-UPDATE-TIME Numeric 6 AP125 AP126
Update Time This field contains the system time AP131 AP25.1
when the record was updated. AP25.2 AP26.1
AP27.1 IC28.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
WH20.2 WH20.7
PJH-VEN-CLAIM-TYPE Alpha 2 AP125 AP126
Ven Claim Type CB = Chargeback AP131 AP25.1
CM = Credit Memo AP25.2 AP26.1
N = None AP27.1 IC28.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
WH20.2 WH20.7
PJH-REPLACE-GOODS Alpha 1 AP125 AP126
Replace Goods Y = Yes AP131 AP25.1
N = No AP25.2 AP26.1
AP27.1 IC28.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
WH20.2 WH20.7
PJH-SHIP-OR-HOLD Alpha 1 AP125 AP126
Ship Or Hold S = Ship AP131 AP25.1
H = Hold AP25.2 AP26.1
AP27.1 IC28.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
WH20.2 WH20.7
PJH-STATUS Numeric 1 AP125 AP126
Status This field displays the status of the AP131 AP25.1
transaction. AP25.2 AP26.1
AP27.1 IC28.1
0 = Unreleased MA180 MA43.9
1 = Released MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
WH20.2 WH20.7
PJH-LOGGED-FLAG Alpha 1 AP125 AP126
Logged Flag If set to "Y", this field indicates the AP131 AP25.1
receiving or receiving adjustment log AP25.2 AP26.1
has been run against this record in a AP27.1 IC28.1
print all unprinted transactions mode. MA180 MA43.9
Y = Yes MA530 MA531
N = No MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO133
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
RQ10.2 WH20.2
WH20.7
PJH-REC-REF-NO Derived
Rec Ref No
PORECADJHD FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PJHSET1 COMPANY AP125 AP126
DOC-TYPE AP131 AP25.1
DOC-NBR-NUM* AP25.2 AP26.1
AP27.1 IC28.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO133
PO20.1 PO21.2
PO21.3 PO21.4
...
PJHSET2 COMPANY KeyChange, Subset AP125 AP126
DOC-TYPE Where REFERENCE-NO != Spaces AP131 AP25.1
REFERENCE-NO AP25.2 AP26.1
AP27.1 IC28.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
...
PJHSET3 COMPANY Subset AP125 AP126
REC-NUMBER Where STATUS = Zeroes AP131 AP25.1
DOC-TYPE AP25.2 AP26.1
DOC-NBR-NUM AP27.1 IC28.1
MA180 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO199
PO20.1 PO21.2
...
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
|