PORECLINE FILE PO Line Item Receivings This file contains purchase order receiving line item detail and status information. REFERENCED BY IC240 MA40.1 MA40.2 MA41.1 MA41.2 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA52.1 PO122 PO199 PO20.1 PO21.3 PO21.5 PO21.6 PO22.2 PO22.3 PO221 PO230 PO274 PO38.1 RQ10.1 RQ10.2 PO131 PO37.1 BL92.1 IN20.1 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 PO277 RQ20.1 RQ20.3 RQ20.4 WH20.2 WH20.7 PO135 PO223 PO236 PO275 PO276 PO64.1 PO94.1 IC220 IC234 IC50.1 IC50.2 IC50.3 IC851 PO85.1 IC242 IC12.1 UPDATED BY AP125 AP126 AP225 AP226 AP25.1 AP25.2 AP26.1 MA300 MA530 MA540 PO133 PO180 PO30.1 PO30.2 PO31.1 PO33.1 PO34.1 PO35.1 PO39.1 PO52.1 PO530 PO963 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY PRL-COMPANY Numeric 4 PO30.1 PO30.2 Company The company number. PO34.1 PO530 PO963 PRL-DOC-TYPE Alpha 2 PO30.1 PO30.2 Document Type This field contains the type of PO33.1 PO34.1 transaction. PO530 PO963 PO = Receiving RA = Receiving Adjustment RJ = Inspection Rejection PRL-DOCUMENT Alpha 10 (Right Justified) PO30.1 PO30.2 Document ID This field identifies the document from PO33.1 PO34.1 which this transaction record was PO530 PO963 created. PRL-LINE-NBR Numeric 6 PO30.1 PO30.2 Line Number This field contains the line number. PO34.1 PO530 PO963 PRL-REC-NUMBER Alpha 10 (Right Justified) PO30.1 PO30.2 Receiver Number The receiver number. Assigned when PO530 PO963 this receiving information was added. PRL-PO-NUMBER Alpha 7 (Right Justified) PO30.1 PO30.2 PO Number This field contains the number PO530 PO963 representing the purchase order. PRL-PO-RELEASE Numeric 6 PO30.1 PO30.2 PO Release Number Used to identify a purchase order PO530 PO963 release (created from a Blanket or Standing order). PRL-PO-LINE-NBR Numeric 6 PO30.1 PO30.2 PO Line Number The purchase order line number this PO530 PO963 record is associated with. PRL-ITEM Alpha 32 PO30.1 PO30.2 Item Number This field contains the item PO530 PO963 identifier. PRL-ITEM-TYPE Alpha 1 PO30.1 PO30.2 Item Type This field identifies the line item PO530 PO963 type. I = Inventory N = Non-Stock S = Service X = Special PRL-LOCATION Alpha 5 PO30.1 PO30.2 Location Code This field contains a valid stock PO530 PO963 location within the company inventory. PRL-PROCESS-LEVEL Alpha 5 PO30.1 PO30.2 Process Level This field contains the process level, PO530 PO963 which is the reporting hierarchy below company. PRL-OPER-ID Alpha 10 PO30.1 PO30.2 Operator Unique identification code that defines PO33.1 PO34.1 Identification who is entering the receiver. PO530 PO963 PRL-TRANS-DATE Numeric 8 (yyyymmdd) PO30.1 PO30.2 Transaction Date The date of the transaction. PO33.1 PO34.1 PO35.1 PO530 PO963 PRL-GL-DATE Numeric 8 (yyyymmdd) PO30.1 PO33.1 General Ledger Date General ledger update date for this PO34.1 PO35.1 receiving line. PO530 PO963 PRL-ENT-REC-QTY Signed 13.4 PO30.1 PO30.2 Entered Received Entered receipt quantity. PO33.1 PO34.1 Quantity PO52.1 PO530 PO963 PRL-ENT-REC-UOM Alpha 4 PO30.1 PO30.2 Entered Received UOM Entered valid receipt unit of measure. PO530 PO963 PRL-ENT-RUOM-MULT Signed 13.7 PO30.1 PO30.2 Entered Recvd UOM This multiplier is used to convert PO530 PO963 Multiplier entered unit of measure quantity down to stock unit of measure. PRL-REJECT-QTY Signed 13.4 PO33.1 PO34.1 Inspection Reject The rejected quantity for this PO963 Quantity receiving. PRL-ORIG-REC-QTY Signed 13.4 PO30.1 PO30.2 Original Received Any adjustment to the original received PO33.1 PO34.1 Quantity quantity is accumulated in the Entered PO52.1 PO530 Received Quantity field. This quantity PO963 is the original quantity when this receiver was first released. PRL-APPROVE-QTY Signed 13.4 PO30.1 PO33.1 Approved Quantity The total approved quantity for this PO34.1 PO35.1 line item. PO530 PO963 PRL-SOH-QTY Signed 13.4 PO30.1 PO33.1 Stock On Hand This field contains the quantity that PO34.1 PO35.1 Quantity is currently on hand in inventory. PO530 PO963 PRL-CATCH-WT-QTY Signed 13.4 PO30.1 PO30.2 Catch Weight This field contains the quantity PO33.1 PO34.1 Quantity received for catch weight shipments. PO530 PO963 PRL-CATCH-WT-UOM Alpha 4 PO30.1 PO30.2 Catch Weight Unit This is the receiving catch weight PO530 PO963 Of Measure unit of measure. PRL-CATCH-WT-MULT Signed 13.7 PO30.1 PO30.2 Catch Wt Mult This is the multiplier used to PO530 PO963 calculate to stock for the entered catch weight quantity. PRL-ENT-UNIT-CST Signed 13.5 PO30.1 PO33.1 Entered Unit Cost The entered unit cost. PO34.1 PO35.1 PO530 PO963 PRL-BIN Alpha 7 PO30.1 PO30.2 Bin This field contains a storage area for PO33.1 PO34.1 an item or any number of items. PO39.1 PO530 PO963 PRL-CANCEL-BO-FL Alpha 1 PO30.1 PO30.2 Cancel Back Order This flag indicates whether the PO33.1 PO34.1 Flag backordered quantity is to be canceled PO35.1 PO52.1 and the line is to be considered closed. PO530 PO963 N = No Y = Yes PRL-INSP-REQ-FL Alpha 1 PO30.1 PO30.2 Inspection Required This flag indicates whether this item PO33.1 PO34.1 Flag has to be inspected when received via PO530 PO963 purchase order. N = No Y = Yes PRL-DETAIL-BAL-FL Alpha 1 PO30.1 PO30.2 Detail Balance Flag This flag is set to Yes when all items PO33.1 PO34.1 received for this line have bins, serial PO39.1 PO52.1 numbers, and/or lots/sublots assigned if PO530 PO963 necessary. PRL-SUB-EXISTS-FL Alpha 1 PO30.1 PO30.2 Substitute Exists Indicates whether this receiving line PO33.1 PO34.1 Flag also has a substitute receiving line. PO530 PO963 N = No Y = Yes PRL-NOTES Alpha 20 (Lower Case) PO30.1 PO33.1 Notes The receiving notes narrative. PO34.1 PO963 PRL-STATUS Numeric 1 PO133 PO30.1 Status Current receiving status for this line. PO30.2 PO33.1 0 = Entered PO34.1 PO35.1 1 = Released/Inspected PO52.1 PO530 5 = Released/Requires Inspection PO963 6 = Released/Unreleased Inspection 4 = Outstanding Buyer Message PRL-GL-STATUS Numeric 1 PO180 PO33.1 General Ledger Current general ledger status for this PO34.1 PO530 Status receiving line. PO963 0 = Unposted 1 = Posted 5 = Posting In Progress PRL-ADJ-STATUS Numeric 1 PO33.1 PO34.1 Adjustment Status Adjustment status for this receiving PO530 PO963 line. 0 = No Adjustments 1 = Unreleased Adjustment(s) 2 = Released Adjustment(s) PRL-LAST-ICD-SEQ Numeric 3 PO33.1 PO34.1 Last IC Trans Last inventory control transaction PO39.1 PO530 Detail Seq Nbr detail sequence line created by this PO963 receiving. PRL-UPDATE-DATE Numeric 8 (yyyymmdd) PO30.1 PO33.1 Update Date This field contains the date the record PO34.1 PO35.1 was updated. PO530 PO963 PRL-UPDATE-TIME Numeric 6 PO30.1 PO33.1 Update Time This field contains the system time PO34.1 PO35.1 when the record was updated. PO530 PO963 PRL-TRAN-COUNTER Numeric 6 PO30.1 PO33.1 Tran Counter This field contains a transaction PO34.1 PO35.1 object number used to determine the PO530 PO963 sequence of updating of the item location file. PRL-APPROVED-FL Alpha 1 AP125 AP126 Approved Flag The approval status of this receiving. AP225 AP226 N = No AP25.1 AP25.2 Y = Yes AP26.1 MA530 MA540 PO30.1 PO31.1 PO33.1 PO34.1 PO530 PO963 PRL-VENDOR Alpha 9 AP125 AP126 Vendor ID The vendor's identification code. AP225 AP226 AP25.1 AP25.2 AP26.1 MA530 MA540 PO30.1 PO30.2 PO31.1 PO33.1 PO34.1 PO530 PO963 PRL-INVOICE Alpha 22 AP125 AP126 Invoice Number Used to identify the invoice. AP225 AP226 AP25.1 AP25.2 AP26.1 MA530 MA540 PO31.1 PO33.1 PO34.1 PO530 PO963 PRL-SUFFIX Numeric 3 AP125 AP126 Invoice Suffix This is the suffix for the invoice. AP225 AP226 AP25.1 AP25.2 AP26.1 MA530 MA540 PO31.1 PO33.1 PO34.1 PO530 PO963 PRL-POTENCY Signed 7.3 PO963 Potency Factor This field is not used. PRL-CURRENT-COST Signed 13.5 PO30.1 PO35.1 Current Cost The unit cost of the item at the time PO530 PO963 of the receiver release. This cost is reflected in the company costing method defined in Inventory Control. PRL-HIST-PERIOD Numeric 2 PO180 PO963 Historical Period The historical period of the receiver when being posted to general ledger for an inventory item. PRL-HIST-YEAR Numeric 4 PO180 PO963 Historical Year The historical year of the receiver when being posted to the general ledger if this is an inventory item. PRL-ACTUAL-TIME Numeric 4 PO30.1 PO30.2 Actual Time This field contains the actual time the PO33.1 PO34.1 receiver was entered into the system. PO530 PO963 This filed defaults to the system date if an actual time was not entered. PRL-BASE-COST Signed 13.5 PO30.1 PO33.1 Base Cost This is the average cost as of this PO35.1 PO530 receiver. This is used when stock on PO963 hand becomes negative for an average cost company. PRL-ILEAD-RVW-FL Alpha 1 PO30.1 PO35.1 Item Lead Time Used to indicate excessive receiving PO530 PO963 Review Flag leadtimes. N = No Y = Yes PRL-MSDS-FLAG Alpha 1 PO30.1 PO30.2 Material Safety This flag indicates if this item PO530 PO963 DataSheet Flag requires a Material Safety Data Sheet. N = No Y = Yes PRL-SUBSTITUTE Derived Substitute PRL-SHORT-DOC-TYPE Derived Short Doc Type PRL-ENT-UNIT-PRC Signed 13.5 PO30.1 PO30.2 Ent Unit Prc The cost of the item provided by the PO530 PO963 vendor at receipt time. This is used by the Evaluated Receipts Settlement process to create the invoice, and by the Receiving Batch Update process when processing EDI 857 transactions. PRL-VPRI-QUANTITY Signed 13.4 PO30.1 PO30.2 Vendor Price The entered line quantity system PO530 PO963 Quantity converted to vendor pricing terms. PRL-LINE-EXT Derived Line Ext This field is used by a predefined Logan report to display dollars processed through receiving. PORECLINE FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN PRLSET1 COMPANY IC240 MA40.1 DOC-TYPE MA40.2 MA41.1 DOCUMENT MA41.2 MA41.5 LINE-NBR MA41.6 MA43.1 MA43.2 MA43.3 MA52.1 MA530 MA540 PO122 PO133 PO199 PO20.1 PO21.3 PO22.2 PO22.3 PO221 PO230 PO274 PO30.1 PO30.2 PO31.1 PO33.1 PO34.1 PO35.1 PO38.1 ... PRLSET10 COMPANY This index is used to obtain all lines MA40.1 MA40.2 DOC-TYPE on a receiver that require inspection. MA41.1 MA41.2 DOCUMENT It was added to support Evaluated MA41.5 MA41.6 LINE-NBR Receipt Settlement processing - a MA43.1 MA43.2 receiver MA43.3 MA52.1 can not generate an invoice until all MA530 MA540 lines have been inspected. PO122 PO20.1 Subset PO21.3 PO22.2 Where DOC-TYPE = "PO" PO22.3 PO30.1 And (STATUS = 5 PO31.1 PO34.1 Or STATUS = 6 ) PO35.1 PO52.1 PO530 RQ10.1 RQ10.2 PRLSET2 COMPANY KeyChange PO131 DOC-TYPE DOCUMENT ITEM BIN PO-LINE-NBR LINE-NBR PRLSET3 COMPANY KeyChange, Subset PO37.1 LOCATION Where DOC-TYPE = "PO" ITEM And (STATUS = 5 DOCUMENT Or STATUS = 6 ) LINE-NBR PRLSET4 COMPANY AP125 AP126 PO-NUMBER AP225 AP226 PO-RELEASE AP25.1 AP25.2 PO-LINE-NBR AP26.1 BL92.1 DOC-TYPE IN20.1 MA300 DOCUMENT MA40.1 MA41.1 LINE-NBR MA41.2 MA43.1 MA43.2 MA52.1 MA530 MA540 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 ... PRLSET5 COMPANY KeyChange, Subset PO135 PO223 PO-NUMBER Where STATUS > Zeroes PO236 PO275 PO-RELEASE And STATUS != 4 PO276 PO64.1 PO-LINE-NBR PO94.1 UPDATE-DATE UPDATE-TIME TRAN-COUNTER DOCUMENT LINE-NBR PRLSET6 COMPANY KeyChange, Subset PO180 PROCESS-LEVEL Where ITEM-TYPE = "I" LOCATION And STATUS > Zeroes ITEM And (GL-STATUS = Zeroes GL-DATE Or GL-STATUS = 5 ) DOC-TYPE DOCUMENT LINE-NBR PRLSET7 COMPANY KeyChange, Subset IC220 IC234 LOCATION Where STATUS != Zeroes IC50.1 IC50.2 ITEM And STATUS != 4 IC851 PO85.1 UPDATE-DATE* UPDATE-TIME* TRAN-COUNTER* DOCUMENT LINE-NBR PRLSET8 COMPANY KeyChange, Subset IC234 IC242 LOCATION Where STATUS != Zeroes IC50.3 ITEM And STATUS != 4 TRANS-DATE* And ITEM-TYPE = "I" ACTUAL-TIME* TRAN-COUNTER* PRLSET9 COMPANY KeyChange IC12.1 PO274 ITEM LOCATION DOC-TYPE DOCUMENT LINE-NBR PORECLINE FILE RELATIONS ONE TO ONE RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Apcompany APCOMPANY Required PRL-COMPANY -> CPY-COMPANY Buyer BUYER Required PRL-COMPANY -> BUY-COMPANY PCR-BUYER-CODE -> BUY-BUYER-CODE Buyer Message POMESSAGE Required When PRL-STATUS = 4 PRL-COMPANY -> POM-COMPANY PRL-REC-NUMBER -> POM-REC-NUMBER PRL-LINE-NBR -> POM-LINE-NBR Icbin ICBIN Required When PRL-BIN != Spaces And PRL-BIN != "* " PRL-COMPANY -> ICB-COMPANY PRL-LOCATION -> ICB-LOCATION PRL-BIN -> ICB-BIN Iccategory ICCATEGORY Required When PRL-ITEM-TYPE = "I" PRL-COMPANY -> ICA-COMPANY PRL-LOCATION -> ICA-LOCATION ITL-GL-CATEGORY -> ICA-GL-CATEGORY Iccompany ICCOMPANY Required PRL-COMPANY -> ICC-COMPANY Iclocation ICLOCATION Required PRL-COMPANY -> ICL-COMPANY PRL-LOCATION -> ICL-LOCATION Itemloc ITEMLOC Required When PRL-ITEM-TYPE = "I" PRL-COMPANY -> ITL-COMPANY PRL-LOCATION -> ITL-LOCATION PRL-ITEM -> ITL-ITEM Itemmast ITEMMAST Required When PRL-ITEM-TYPE = "I" Or PRL-ITEM-TYPE = "N" ICC-ITEM-GROUP -> ITE-ITEM-GROUP PRL-ITEM -> ITE-ITEM Pocompany POCOMPANY Required PRL-COMPANY -> PCY-COMPANY Poline POLINE Required When PRL-PO-NUMBER != Spaces PRL-COMPANY -> PLI-COMPANY PRL-PO-NUMBER -> PLI-PO-NUMBER PRL-PO-RELEASE -> PLI-PO-RELEASE PRL-LINE-NBR -> PLI-LINE-NBR Poproclev POPROCLEV Required When PRL-PROCESS-LEVEL != Spaces PRL-COMPANY -> POP-COMPANY PRL-PROCESS-LEVEL -> POP-PROCESS-LEVEL Poreceive PORECEIVE Required When PRL-DOC-TYPE = "PO" PRL-COMPANY -> POR-COMPANY PRL-REC-NUMBER -> POR-REC-NUMBER Purchorder PURCHORDER Required When PRL-PO-NUMBER != Spaces PRL-COMPANY -> PCR-COMPANY PRL-PO-NUMBER -> PCR-PO-NUMBER PRL-PO-RELEASE -> PCR-PO-RELEASE Vendloc APVENLOC Not Required CPY-VENDOR-GROUP -> VLO-VENDOR-GROUP PLI-VENDOR -> VLO-VENDOR PLI-PURCH-FR-LOC -> VLO-LOCATION-CODE Vendor APVENMAST Required CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP POR-VENDOR -> VEN-VENDOR PORECLINE FILE RELATIONS ONE TO MANY RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Ersaocdtl ERSAOCDTL Delete Cascades PRL-COMPANY -> ERS-COMPANY PRL-DOCUMENT -> ERS-REC-NUMBER PRL-LINE-NBR -> ERS-LINE-NBR ERS-AOC-CODE Ictransdtl ICTRANSDTL PRL-COMPANY -> ICD-COMPANY PRL-LOCATION -> ICD-LOCATION PRL-DOC-TYPE -> ICD-DOC-TYPE "PO" -> ICD-SYSTEM-CD PRL-DOCUMENT -> ICD-DOCUMENT Zeroes -> ICD-SHIPMENT-NBR PRL-LINE-NBR -> ICD-LINE-NBR Zeroes -> ICD-COMPONENT-SEQ ICD-SEQ Mmdist MMDIST Delete Cascades Valid When PRL-GL-STATUS = 1 And PRL-ITEM-TYPE = "I" PRL-COMPANY -> MMD-COMPANY "PO" -> MMD-SYSTEM-CD Spaces -> MMD-LOCATION PRL-DOC-TYPE -> MMD-DOC-TYPE PRL-DOCUMENT -> MMD-DOC-NBR Zeroes -> MMD-DOC-NBR-NUM PRL-LINE-NBR -> MMD-LINE-NBR Zeroes -> MMD-COMPONENT-SEQ Spaces -> MMD-AOC-CODE MMD-LINE-SEQ Poaocdtl POAOCDTL PRL-COMPANY -> PAO-COMPANY Spaces -> PAO-ORDER-NAME PRL-PO-NUMBER -> PAO-PO-NUMBER PRL-PO-RELEASE -> PAO-PO-RELEASE PRL-PO-LINE-NBR -> PAO-LINE-NBR PAO-AOC-CODE Poapprove POAPPROVE Delete Restricted PRL-COMPANY -> POA-COMPANY PRL-VENDOR -> POA-VENDOR PRL-INVOICE -> POA-INVOICE PRL-SUFFIX -> POA-SUFFIX PRL-PO-NUMBER -> POA-PO-NUMBER PRL-PO-RELEASE -> POA-PO-RELEASE PRL-LINE-NBR -> POA-LINE-NBR POA-AOC-CODE Pocomments POCOMMENTS Required When PRL-LINE-NBR = PRL-PO-LINE-NBR PRL-COMPANY -> POC-COMPANY Spaces -> POC-ORDER-NAME Zeroes -> POC-RETURN-NUMBER PRL-PO-NUMBER -> POC-PO-NUMBER PRL-PO-RELEASE -> POC-PO-RELEASE PRL-LINE-NBR -> POC-LINE-NBR POC-SEQ Substitutes PORECLINE Delete Cascades PRL-COMPANY -> PRL-COMPANY PRL-PO-NUMBER -> PRL-PO-NUMBER PRL-PO-RELEASE -> PRL-PO-RELEASE PRL-PO-LINE-NBR -> PRL-PO-LINE-NBR PRL-DOC-TYPE -> PRL-DOC-TYPE PRL-DOCUMENT -> PRL-DOCUMENT PRL-LINE-NBR |