Lawson Insight Technical Documentation |
|
PORECADJLN
PORECADJLN FILE
Receiving Adjustments Line
REFERENCED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.4 API1.1 IC130 IC28.1
MA180 MA41.2 MA41.7 MA43.1 MA43.2 MA43.3
MA43.9 MA530 MA60.2 MA60.3 MA60.5 MA61.1
MA66.2 MA66.3 MA67.1 MA67.2 MA70.1 MA75.1
MA80.1 MAI1.1 PO100 PO101 PO122 PO131
PO133 PO199 PO20.1 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO23.1 PO25.1 PO25.5
PO25.6 PO25.7 PO27.2 PO29.1 PO31.1 PO31.2
PO32.2 PO35.1 PO36.1 PO36.2 PO38.1 PO44.1
PO50.1 PO520 PO536 POI3.1 POII.1 POIJ.1
RQ10.1 RQ10.2 RQ10.3 RQIE.1 WH20.2 WH20.7
IC234 PO135 PO139 PO277 PO64.1
UPDATED BY
MA531 PO30.1 PO30.2 PO30.3 PO300 PO33.1
PO34.1 PO39.2 PO52.1 POD0.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PJL-COMPANY Numeric 4 AP125 AP126
Element: Company The company number represents an AP131 AP20.1
established company and is entered on AP20.2 AP20.3
all function codes. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PJL-DOC-TYPE Alpha 2 AP125 AP126
Element: Document Type This field contains the type of AP131 AP20.1
transaction. AP20.2 AP20.3
RA = Receiving Adjustment AP20.4 AP20.5
IN = Inspection AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PJL-DOC-NBR-NUM Numeric 10 AP125 AP126
Element: Doc Nbr Num AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PJL-DOCUMENT-A Alpha 10 (Right Justified) AP125 AP126
Element: Document A AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PJL-REFERENCE-NO Alpha 10 (Right Justified) AP125 AP126
Element: Reference No AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PJL-LINE-NBR Numeric 6 AP125 AP126
Element: Line Number This field contains the line number. AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PJL-REC-NUMBER Numeric 10 AP125 AP126
Element: Receiver NumbeThe receiver number. Assigned when AP131 AP20.1
this receiving information was added. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PJL-PO-NUMBER Alpha 14 (Right Justified) AP125 AP126
Element: PO Number This field contains the number AP131 AP20.1
representing the purchase order. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PJL-PO-RELEASE Numeric 4 AP125 AP126
Element: PO Release NumUsed to identify a purchase order AP131 AP20.1
release (created from a Blanket or AP20.2 AP20.3
Standing order). AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PJL-PO-CODE Alpha 4 AP125 AP126
Element: Po Code This is the purchase order code. AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PJL-PO-LINE-NBR Numeric 6 AP125 AP126
Element: Line Number AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PJL-UPDATE-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Date AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PJL-UPDATE-TIME Numeric 6 AP125 AP126
Element: Update Time This field contains the system time AP131 AP20.1
when the record was updated. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PJL-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Date This field displays the system date AP131 AP20.1
when this was created. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PJL-QUANTITY Signed 13.4 AP125 AP126
Element: Quantity This field contains the desired AP131 AP20.1
quantity. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PJL-CATCH-WT-QTY Signed 13.4 AP125 AP126
Element: Quantity AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PJL-BIN Alpha 7 AP125 AP126
Element: Bin This field contains a storage area for AP131 AP20.1
an item or any number of items. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PJL-CANCEL-BO-FL Alpha 1 AP125 AP126
Element: All Flag AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PJL-DETAIL-BAL-FL Alpha 1 AP125 AP126
Element: All Flag AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PJL-STATUS Numeric 1 AP125 AP126
Element: Status This field displays the status of the AP131 AP20.1
transaction. AP20.2 AP20.3
0 = Unreleased AP20.4 AP20.5
1 = Released AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PJL-LAST-POT-SEQ Numeric 6 AP125 AP126
Element: Last Pot Seq AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PJL-WRITE-OFF Alpha 1 AP125 AP126
Element: Write Off Y = Write Off AP131 AP20.1
N = Create Return AP20.2 AP20.3
" " = No Rejections AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PJL-RETURN-NUMBER Numeric 10 AP125 AP126
Element: Return Number This is the number assigned to the AP131 AP20.1
return for purposes of referencing the AP20.2 AP20.3
return internally and with the customer AP20.4 AP20.5
or vendor. AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PJL-RET-LINE-NBR Numeric 6 AP125 AP126
Element: Line Number AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PJL-BUYER-MSG-FLAG Alpha 1 AP125 AP126
Element: Buyer Msg FlagIndicates whether a buyer message exists AP131 AP20.1
for this receiving line. AP20.2 AP20.3
Y = Yes AP20.4 AP20.5
N = No AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PORECADJLN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PJLSET1 COMPANY AP125 AP126
DOC-TYPE AP131 AP20.1
DOC-NBR-NUM* AP20.2 AP20.3
LINE-NBR AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC130 IC28.1
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
...
PJLSET2 COMPANY AP125 AP126
REC-NUMBER AP131 AP20.1
LINE-NBR AP20.2 AP20.3
DOC-TYPE AP20.4 AP20.5
DOC-NBR-NUM AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC234 IC28.1
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
...
PJLSET3 COMPANY KeyChange, Subset MA66.2 MA70.1
PO-NUMBER Where STATUS = 1 MA75.1 PO277
PO-RELEASE PO64.1
PO-CODE
PO-LINE-NBR
DATE*
DOC-TYPE
DOC-NBR-NUM
LINE-NBR
PJLSET4 COMPANY Subset IC234
DOCUMENT-A Where DOC-TYPE = "RA"
LINE-NBR
PJLSET5 COMPANY Subset IC234
DOCUMENT-A Where DOC-TYPE = "IN"
LINE-NBR
PORECADJLN FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Buyer Message POMESSAGE Not Required
PJL-COMPANY -> POM-COMPANY
PJL-REC-NUMBER -> POM-REC-NUMBER
PJL-DOC-NBR-NUM -> POM-LINE-NBR
PJL-LINE-NBR -> POM-DOC-NBR-NUM
Porecadjhd PORECADJHD Required
PJL-COMPANY -> PJH-COMPANY
PJL-DOC-TYPE -> PJH-DOC-TYPE
PJL-DOC-NBR-NUM -> PJH-DOC-NBR-NUM
Porecline PORECLINE Required
PJL-COMPANY -> PRL-COMPANY
PJL-REC-NUMBER -> PRL-REC-NUMBER
PJL-LINE-NBR -> PRL-LINE-NBR
PORECADJLN FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Ictrans ICTRANS
PJL-COMPANY -> ICT-COMPANY
PRL-LOCATION -> ICT-LOCATION
PJL-DOC-TYPE -> ICT-DOC-TYPE
"PO" -> ICT-SYSTEM-CD
PJL-DOCUMENT-A -> ICT-DOCUMENT
Zeroes -> ICT-SHIPMENT-NBR
PJL-LINE-NBR -> ICT-LINE-NBR
ICT-COMPONENT-SEQ
Potransdtl POTRANSDTL Delete Cascades
PJL-COMPANY -> POT-COMPANY
PJL-DOC-TYPE -> POT-DOC-TYPE
PJL-DOC-NBR-NUM -> POT-DOC-NBR-NUM
PJL-LINE-NBR -> POT-LINE-NBR
POT-TRANS-SEQ
|