PORECADJLN FILE
Receiving Adjustments Line
REFERENCED BY
IC130 PO133 PO199 POIJ.1 IC234 PO135
PO64.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PJL-COMPANY Numeric 4 POIJ.1
Company The company number represents an
established company and is entered on
all function codes.
PJL-DOC-TYPE Alpha 2 POIJ.1
Document Type This field contains the type of
transaction.
RA = Receiving Adjustment
IN = Inspection
PJL-DOC-NBR-NUM Numeric 10 POIJ.1
Doc Nbr Num
PJL-DOCUMENT-A Alpha 10 (Right Justified) POIJ.1
Document A
PJL-REFERENCE-NO Alpha 10 (Right Justified) POIJ.1
Reference No
PJL-LINE-NBR Numeric 6 POIJ.1
Line Number This field contains the line number.
PJL-REC-NUMBER Numeric 10 POIJ.1
Receiver Number The receiver number. Assigned when
this receiving information was added.
PJL-PO-NUMBER Alpha 14 (Right Justified) POIJ.1
PO Number This field contains the number
representing the purchase order.
PJL-PO-RELEASE Numeric 4 POIJ.1
PO Release Number Used to identify a purchase order
release (created from a Blanket or
Standing order).
PJL-PO-CODE Alpha 4 POIJ.1
Po Code This is the purchase order code.
PJL-PO-LINE-NBR Numeric 6 POIJ.1
PO Line Number The PO line number this record is
associated with.
PJL-UPDATE-DATE Numeric 8 (yyyymmdd) POIJ.1
Update Date This field contains the date the record
was updated.
PJL-UPDATE-TIME Numeric 6 POIJ.1
Update Time This field contains the system time
when the record was updated.
PJL-DATE Numeric 8 (yyyymmdd) POIJ.1
Date This field displays the system date
when this was created.
PJL-QUANTITY Signed 13.4 POIJ.1
Quantity This field contains the desired
quantity.
PJL-CATCH-WT-QTY Signed 13.4 POIJ.1
Catch Weight This field contains the quantity
Quantity received for catch weight shipments.
PJL-BIN Alpha 7 POIJ.1
Bin This field contains a storage area for
an item or any number of items.
PJL-CANCEL-BO-FL Alpha 1 POIJ.1
Cancel Back Order This flag indicates whether the
Flag backordered quantity is to be cancelled
and the line is to be considered closed.
PJL-DETAIL-BAL-FL Alpha 1 POIJ.1
Detail Balance Flag
PJL-STATUS Numeric 1 POIJ.1
Status This field displays the status of the
transaction.
0 = Unreleased
1 = Released
PJL-LAST-POT-SEQ Numeric 6 POIJ.1
Last Pot Seq
PJL-WRITE-OFF Alpha 1 POIJ.1
Write Off Y = Write Off
N = Create Return
" " = No Rejections
PJL-RETURN-NUMBER Numeric 10 POIJ.1
Return Number This is the number assigned to the
return for purposes of referencing the
return internally and with the customer
or vendor.
PJL-RET-LINE-NBR Numeric 6 POIJ.1
Return Line Number This is the return line number.
PJL-BUYER-MSG-FLAG Alpha 1 POIJ.1
Buyer Msg Flag Indicates whether a buyer message exists
for this receiving line.
Y = Yes
N = No
PORECADJLN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PJLSET1 COMPANY IC130 PO133
DOC-TYPE PO199 POIJ.1
DOC-NBR-NUM*
LINE-NBR
PJLSET2 COMPANY IC234 PO135
REC-NUMBER POIJ.1
LINE-NBR
DOC-TYPE
DOC-NBR-NUM
PJLSET3 COMPANY KeyChange, Subset PO64.1
PO-NUMBER Where STATUS = 1
PO-RELEASE
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
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 (POMSET5)
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
POT-SEQ
|
