Requisition Line
This file contains the line item information for the requisition.
REFERENCED BY
| FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RLN-COMPANY Element: Company | Numeric 4 Enter the company number defined in Company (IC01.1) or Company (MA01.1). |
|
||||||||||||||||||||||
| RLN-REQ-NUMBER Element: Req Number | Numeric 7 This is the requisition number. Requisition numbers are automatically assigned if the company is set up for automatic numbering in IC01.1 (Company) or MA00.1 (Company). Otherwise, requisition numbers are user defined. Automatically assigned requisition numbers are incremented by one from the last number used, as defined in IC01.1 or MA00.1. |
|
||||||||||||||||||||||
| RLN-REQ-NUMBER-A Element: Req Number A | Alpha 10 (Right Justified) This field is used to connect Warehouse system demand records with the requisitions to facilitate Drill Around activity. |
|
||||||||||||||||||||||
| RLN-LINE-NBR Element: Line Nbr | Numeric 6 This is the system-assigned line number for the requested line. The system increments this by one with each requested line. |
|
||||||||||||||||||||||
| RLN-ITEM Element: Item | Alpha 32 This is the item number to be requested. If you are requesting a Nonstock item, this item must be defined in IC11 (Item Master). If the requested item is an Inventory item, the item must be defined in IC11 (Item Master) and defined in IC12 (Item Location) for the "from" location. If the item is either Service or Special item, the item number field is user-defined. |
|
||||||||||||||||||||||
| RLN-ITEM-TYPE Element: Item Type | Alpha 1 Enter the type of item requested. An inventoried item is maintained in inventory and must be defined in IC11 (Item Master) and IC12 (Item Location) for the "from" location. A nonstock item is set up in IC11 (Item Master) but is not maintained in inventory. An X (special order) item is not set up in IC11 (Item Master) and is not being tracked in inventory. A service is not defined in IC11 (Item Master) and does not require receiving. I = Inventoried S = Service X = Special N = Non-stock |
|
||||||||||||||||||||||
| RLN-SERVICE-CODE Element: Service Code | Alpha 1 Q = Quantity " " = Not Service Item A = Amount |
|
||||||||||||||||||||||
| RLN-DESCRIPTION Element: Description | Alpha 30 (Lower Case) Enter the description of the item. Use IC11 (Item Master) to enter the description for inventory and nonstock type items. If the item type is either an I or an N, the description can not be changed. If the item is a special order (X) or service (S) item, you must enter a description of the requested item. |
|
||||||||||||||||||||||
| RLN-QUANTITY Element: Quantity | Signed 13.4 Enter the requested quantity. If left blank, this defaults to 1. |
|||||||||||||||||||||||
| RLN-ENTERED-UOM Element: Uom | Alpha 4 This field contains the valid stock unit of measure for this item. |
|
||||||||||||||||||||||
| RLN-ENT-UOM-MULT Element: Uom Mult | Signed 13.7 This field contains the multiplier for converting this unit of measure to the stock unit of measure. |
|
||||||||||||||||||||||
| RLN-RETURN-QTY Element: Quantity | Signed 13.4 This field contains the desired quantity. |
|
||||||||||||||||||||||
| RLN-DTL-RET-QTY Element: Quantity | Signed 13.4 This is the total of the returned quantity from the detail records. Detail records are created for multiple bins, lot, or serial tracked items. |
|
||||||||||||||||||||||
| RLN-UNIT-COST Element: Intl Cost | Signed 18.5 This field contains the unit cost in base currency. When the PO is created, then the cost on the PO will be reflected in transaction currency. |
|
||||||||||||||||||||||
| RLN-COST-OPTION Element: Cost Option | Alpha 1 1 = Cost Required 2 = No Charge 3 = Vendor Determined |
|
||||||||||||||||||||||
| RLN-OVERIDE-CST-FL Element: Overide Cst Fl | Alpha 1 Y = Yes N = No |
|
||||||||||||||||||||||
| RLN-CREATE-PO-FL Element: Create Po Fl | Alpha 1 Y = Yes N = No |
|
||||||||||||||||||||||
| RLN-AGREEMENT-REF Element: Agreement Ref | Alpha 30 |
|
||||||||||||||||||||||
| RLN-VENDOR Element: Vendor | Alpha 9 (Right Justified) The vendor's identification code. |
|
||||||||||||||||||||||
| RLN-PURCH-FR-LOC Element: Purch Fr Loc | Alpha 4 The vendor's purchase from location. |
|
||||||||||||||||||||||
| RLN-PURCH-MAJOR Element: Major Class | Alpha 4 Purchase Class Major Field. This field can be used to control the classes of items that a requester can enter on a requisition. |
|
||||||||||||||||||||||
| RLN-PURCH-MINOR Element: Minor Class | Alpha 4 Purchase Class Minor Field. |
|
||||||||||||||||||||||
| RLN-BUYER Element: Buyer | Alpha 3 Buyer code, defaulted from the Requisition Header or Item Location file if the buyer code is blank. |
|
||||||||||||||||||||||
| RLN-FROM-COMPANY Element: Company | Numeric 4 The company from which the requisition gets replenished. |
|
||||||||||||||||||||||
| RLN-FROM-LOCATION Element: Location | Alpha 5 This field contains a valid stocking location within the company inventory. |
|
||||||||||||||||||||||
| RLN-REQ-LOCATION Element: Req Location | Alpha 5 The location requisitioning items. This location can be an inventory or noninventory location. |
|
||||||||||||||||||||||
| RLN-REQ-DEL-DATE Element: Date | Numeric 8 (yyyymmdd) This is the date that the requester would like the items to be delivered. This date defaults from the requested delivery date on the requisition header. |
|
||||||||||||||||||||||
| RLN-LATE-DL-DATE Element: Late Dl Date | Numeric 8 (yyyymmdd) This field contains the late delivery date. |
|
||||||||||||||||||||||
| RLN-CREATION-DATE Element: Creation Date | Numeric 8 (yyyymmdd) This is the date that this line was added to the requisition. |
|
||||||||||||||||||||||
| RLN-DIST-CODE Element: Dist Code | Alpha 9 This user-defined code is defined in the Terms system. The code allows multiple line distributions for noninventory items. The code is not valid for inventory tracked items. When the requested line is converted to a purchase order line, the program passes the distribution code with its distributions to the Purchase Order system. If the item is requested from multiple requisitions, the system tracks all the distributions for the item. The distributions are expensed when an invoice is processed in the Accounts Payable system. |
|
||||||||||||||||||||||
| RLN-IC-TRANS-TYPE Element: Ic Trans Type | Alpha 2 This code indicates the type of inventory transaction created when the line is picked in WH30 (Picking Feedback). IS = Issues DT = Direct Transfer IT = Intransit Transfer |
|
||||||||||||||||||||||
| RLN-PO-CODE Element: Po Code | Alpha 4 This is the purchase order code. |
|
||||||||||||||||||||||
| RLN-PURCH-TAX-CD Element: Tax Code | Alpha 10 This code is used to determine if this item is taxable when purchased at this location and to extract the tax data from the Tax file based on this tax code. This field value is passed to the PO when the PO is created. |
|
||||||||||||||||||||||
| RLN-PURCH-TAX-FL Element: Purch Tax Fl | Alpha 1 This flag specifies if this item is taxable when it is purchased for this location. This field value is passed to the PO when the PO is created. N = Nontaxable Y = Taxable |
|
||||||||||||||||||||||
| RLN-CERT-REQ-FL Element: Cert Req Fl | Alpha 1 This flag indicates whether a certification is required for this line when it is purchased. This field value is passed to the PO when the PO line is created. N = No Y = Yes |
|
||||||||||||||||||||||
| RLN-INSP-REQ-FL Element: All Flag | Alpha 1 This flag indicates whether this item has to be inspected when received using a PO. N = No Y = Yes |
|
||||||||||||||||||||||
| RLN-LAST-RET-SEQ Element: Seq | Numeric 3 This field contains the record sequence number. |
|
||||||||||||||||||||||
| RLN-VEN-ITEM Element: Item | Alpha 32 The vendor's identifier for this item. |
|
||||||||||||||||||||||
| RLN-STATUS Element: Status | Numeric 1 This is the processing status of a requisition line. 0 = Unreleased 1 = Released 8 = Rejected 9 = Processed |
|
||||||||||||||||||||||
| RLN-CLOSED-FL Element: Closed Fl | Alpha 1 The Closed Flag. Y = Yes N = No |
|||||||||||||||||||||||
| RLN-BIN Element: Bin | Alpha 7 This field contains a storage area for an item or any number of items. |
|
||||||||||||||||||||||
| RLN-PO-USER-FLD-2 Element: Po User Fld 2 | Alpha 2 Purchase order line user defined field. This field is passed to the PO line when the PO is created. |
|
||||||||||||||||||||||
| RLN-PO-USER-FLD-4 Element: User Fld2 | Alpha 30 (Lower Case) Purchase order line user defined field. This field is passed to the PO line when the PO is created. |
|
||||||||||||||||||||||
| RLN-PO-USER-FLD-6 Element: User Fld3 | Alpha 15 (Lower Case) Purchase order line user defined field. This field is passed to the PO line when the PO is created. |
|
||||||||||||||||||||||
| RLN-USER-DATE-3 Element: Date | Numeric 8 (yyyymmdd) This field displays the system date when this was created. |
|
||||||||||||||||||||||
| RLN-USER-DATE-4 Element: Date | Numeric 8 (yyyymmdd) This field displays the system date when this was created. |
|
||||||||||||||||||||||
| RLN-ALLOC-PRI Element: Alloc Pri | Numeric 2 This is the allocation priority for this requisition. Valid values are from 0 to 99, with 99 being the highest. This field defaults to 50. This field is used in the Warehouse module to determine the order in which inventory demand gets allocated. |
|
||||||||||||||||||||||
| RLN-DELIVER-TO Element: Deliver To | Alpha 30 (Lower Case) This field can be used to specify where to deliver the items. This field prints on the delivery ticket when you run Delivery Ticket Print program. |
|
||||||||||||||||||||||
| RLN-MANUF-CODE Element: Manuf Code | Alpha 4 This is a user defined code that indicates the manufacturer of an item. |
|
||||||||||||||||||||||
| RLN-MANUF-DIVISION Element: Manuf Division | Alpha 4 This is a user defined code that indicates which division of a manufacturer is tied to an item. |
|
||||||||||||||||||||||
| RLN-MANUF-NBR Element: Manuf Nbr | Alpha 35 This is the identifier that the manufacturer has assigned to an item. |
|
||||||||||||||||||||||
| RLN-LAST-DIST-SEQ Element: Seq Nbr | Numeric 4 An automatically assigned sequence number. |
|
||||||||||||||||||||||
| RLN-NEW-REQ Element: New Req | Alpha 1 N = No Y = Yes |
|
||||||||||||||||||||||
| RLN-FILL-OR-KILL Element: Fill Or Kill | Alpha 1 F = Fill Backorders K = Kill Backorders |
|
||||||||||||||||||||||
| RLN-KILL-QUANTITY Element: Kill Quantity | Signed 13.4 |
|
||||||||||||||||||||||
| RLN-ENTERED-ITEM Element: Entered Item | Alpha 25 |
|
||||||||||||||||||||||
| RLN-COST-CD Element: Cost Cd | Alpha 1 Unit cost origin code E = Entered L = Last Cost C = Contract T = Catalog/Quote B = Blanket P = Last PO Created I = Inventory Cost G = Punchout Y = Tier - Company Participant N = Tier - IC Location Participant Q = Tier - Req Loc Participant W = Website V = Procurement Template Agrmt Ref |
|
||||||||||||||||||||||
| RLN-ENTRY-FL Element: Entry Fl | Alpha 1 1 = Item 2 = UPC 3 = UPN1 4 = UPN2 5 = NDC 6 = SKU |
|
||||||||||||||||||||||
| RLN-RQSRC-MACHINE Element: Rqsrc Machine | Alpha 6 DROYAL ESIOB HBOC OMNICL PAREXC PERSE PYXIS INTER EAM |
|
||||||||||||||||||||||
| RLN-PAR-ORDER-ID Element: Par Order Id | Alpha 20 |
|
||||||||||||||||||||||
| RLN-APPROVED-FL Element: All Flag | Alpha 1 |
|
||||||||||||||||||||||
| RLN-CAP-TECH-FLAG Element: Cap Tech Flag | Numeric 1 0 = None 1 = Capital 2 = Technical 3 = Both |
|
||||||||||||||||||||||
| RLN-PFLOW-APRV-LVL Element: Pflow Aprv Lvl | Alpha 20 |
|
||||||||||||||||||||||
| RLN-PUNCHOUT-ID Element: Punchout Id | Alpha 64 |
|
||||||||||||||||||||||
| RLN-PFLOW-CREATED Element: Pflow Created | Numeric 1 0 = PFlow work unit not created 1 = PFlow work unit created |
|
||||||||||||||||||||||
| RLN-TRAN-UNIT-COST Element: Intl Cost | Signed 18.5 |
|
||||||||||||||||||||||
| RLN-TRAN-CURR-CODE Element: Currency Code | Alpha 5 This field contains the company base currency code established in Company (GL10.1 ). |
|
||||||||||||||||||||||
| RLN-CNV-RATE Element: Ent Cnv Rate | Signed 14.7 Currency conversion rate at Purchase Order entry time. |
|
||||||||||||||||||||||
| RLN-COMMIT-REMAIN Element: Quantity | Signed 13.4 This field contains the desired quantity. |
|||||||||||||||||||||||
| RLN-RQ-SOURCE Element: Rq Source | Numeric 2 00 = Upgrade 01 = IC142 02 = IC141 03 = IC83 04 = RQ35 05 = RQ500 06 = RQC 07 = RQ10 08 = DR100 09 = Website 99 = Mobile Requisitions 97 = Perfect Commerce 98 = SciQuest |
|
||||||||||||||||||||||
| RLN-SS-EVENT-REQD Element: Ss Event Reqd | Numeric 1 0 = No 1 = Yes |
|
||||||||||||||||||||||
| RLN-COMMODITY-CODE Element: Commodity Code | Alpha 35 |
|
||||||||||||||||||||||
| RLN-P-CARD-FLAG Element: Flag Num | Numeric 1 |
|
||||||||||||||||||||||
| RLN-PCARD-NBR Element: Pcard Nbr | Alpha 16 |
|
||||||||||||||||||||||
| RLN-CONTRACT-GROUP Element: Enterprise Grp | Alpha 4 |
|
||||||||||||||||||||||
| RLN-CM-CONTRACT Element: Cm Contract | Numeric 15 |
|
||||||||||||||||||||||
| RLN-TIER Element: Tier | Alpha 4 |
|
||||||||||||||||||||||
| RLN-PREFERRED-FLAG Element: Preffered Flag | Numeric 1 0 = No 1 = Contract 2 = Manufacturer 3 = Contract and Manufacturer |
|
||||||||||||||||||||||
| RLN-DER-ORIGIN-CD Element: Der Origin Cd | Derived |
|
||||||||||||||||||||||
| RLN-DER-REQUESTER Element: Der Requester | Derived |
|
||||||||||||||||||||||
| RLN-DER-CLOSE-STAT Element: Der Close Stat | Derived |
|
||||||||||||||||||||||
| RLN-APPROVAL-VAL Element: Approval Val | Derived This field is a sum of the three item total fields (I Total, N Total, and S X Total amount fields). This value is the total value of the requisition. It is used for approval processing. |
|
||||||||||||||||||||||
| RLN-PVN-OBJ-ID Element: Obj Id | Numeric 12 |
|
||||||||||||||||||||||
| RLN-PART-SEQ-NBR Element: Seq Number | Numeric 6 |
|
||||||||||||||||||||||
| RLN-PIF-CXL-QTY Element: Quantity | Signed 13.4 |
|||||||||||||||||||||||
| RLN-PROD-TAX-CAT Element: Prod Tax Cat | Alpha 15 |
|
||||||||||||||||||||||
| RLN-LOCATION-RULE Element: Rule Name | Alpha 12 |
|
||||||||||||||||||||||
| RLN-RELEASED-DATE Element: Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||
| RLN-RELEASED-TIME Element: Time | Numeric 8 |
|
||||||||||||||||||||||
| RLN-REL-OPER-ID Element: Operator | Alpha 10 |
|
||||||||||||||||||||||
| RLN-APR-REJ-DATE Element: Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||
| RLN-APR-REJ-TIME Element: Time | Numeric 8 |
|
||||||||||||||||||||||
| RLN-APR-REJ-OPR-ID Element: Operator | Alpha 10 |
|
||||||||||||||||||||||
| RLN-GTIN Element: Gtin | Numeric 14 |
|
||||||||||||||||||||||
| RLN-PO-USER-FLD-7 Element: User Fld 7 | Alpha 10 (Lower Case) |
|
||||||||||||||||||||||
| RLN-EAM-OPER-NBR Element: Operation Nbr | Numeric 4 |
|
||||||||||||||||||||||
| RLN-EAM-SEQ-NBR Element: Seq Nbr | Numeric 4 |
|
||||||||||||||||||||||
| RLN-EAM-WO-NBR Element: Work Order | Numeric 8 |
|
||||||||||||||||||||||
| RLN-CREATION-TIME Element: Time | Numeric 8 |
|
||||||||||||||||||||||
| RLN-PATIENT-LNAME Element: Last Name | Alpha 30 (Lower Case) |
|
||||||||||||||||||||||
| RLN-PATIENT-FNAME Element: First Name | Alpha 15 (Lower Case) |
|
||||||||||||||||||||||
| RLN-PATIENT-MINIT Element: Middle Init | Alpha 1 |
|
||||||||||||||||||||||
| RLN-PAT-VISIT-NBR Element: Visit Nbr | Alpha 12 |
|
||||||||||||||||||||||
| RLN-SERIAL Element: Serial | Alpha 16 |
|
||||||||||||||||||||||
| RLN-SS-EVENT-NBR Element: Ss Event Nbr | Numeric 8 |
|
||||||||||||||||||||||
| RLN-PUNCHOUT-UGNAM Element: Punchout Ugnam | Alpha 40 (Lower Case) |
|
||||||||||||||||||||||
| RLN-CREATED-BY Element: Operator | Alpha 10 |
|
||||||||||||||||||||||
| RLN-LAST-UPDT-DATE Element: Date | Numeric 8 (yyyymmdd) |
|||||||||||||||||||||||
| RLN-LAST-UPDT-TIME Element: Time | Numeric 8 |
|||||||||||||||||||||||
| RLN-LAST-UPDATE-BY Element: Operator | Alpha 10 |
|||||||||||||||||||||||
| RLN-HPP-OBJ-ID Element: Obj Id | Numeric 12 |
|
||||||||||||||||||||||
| RLN-CN-CODE Element: Consign Code | Alpha 2 |
|
||||||||||||||||||||||
| RLN-GLBL-LINE-TYPE Element: Glbl Line Type | Alpha 15 |
|
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Ap Company | APCOMPANY |
Not Required
| ||||||||||||||||||||||||||||||
| Commcodes | COMMCODES |
Not Required
| ||||||||||||||||||||||||||||||
| From Location | ICLOCATION |
Required
| ||||||||||||||||||||||||||||||
| Hcpatproc | HCPATPROC |
Not Required
| ||||||||||||||||||||||||||||||
| Ic Company | ICCOMPANY |
Required
| ||||||||||||||||||||||||||||||
| Item | ITEMMAST |
Required
| ||||||||||||||||||||||||||||||
| Item Location | ITEMLOC |
Required
| ||||||||||||||||||||||||||||||
| Mmuaval | MMUAVAL |
Not Required
| ||||||||||||||||||||||||||||||
| Po Company | POCOMPANY |
Required
| ||||||||||||||||||||||||||||||
| Pocontgrp | POCONTGRP |
Required
| ||||||||||||||||||||||||||||||
| Pocontract | POCONTRACT |
Required
| ||||||||||||||||||||||||||||||
| Porlnuf | PORLNUF |
Not Required, Delete Cascades
| ||||||||||||||||||||||||||||||
| Povagrmtln | POVAGRMTLN |
Not Required
| ||||||||||||||||||||||||||||||
| Povapartln | POVAPARTLN |
Not Required
| ||||||||||||||||||||||||||||||
| Req Location | RQLOC |
Required
| ||||||||||||||||||||||||||||||
| Requester | REQUESTER |
Required
| ||||||||||||||||||||||||||||||
| Requisition | REQHEADER |
Required
| ||||||||||||||||||||||||||||||
| Vendor | APVENMAST |
Not Required
| ||||||||||||||||||||||||||||||
| Whdemand Phar | WHDEMAND |
Not Required
| ||||||||||||||||||||||||||||||
| Whdemndhdr | WHDEMNDHDR |
Not Required
|
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Accounts | MMDIST |
| ||||||||||||||||||||||||||||||||||||
| Itemsub | ITEMSUB |
| ||||||||||||||||||||||||||||||||||||
| Location Rule | WHLOCRULE |
| ||||||||||||||||||||||||||||||||||||
| Pointaudit | POINTAUDIT |
| ||||||||||||||||||||||||||||||||||||
| Polinesrc | POLINESRC |
| ||||||||||||||||||||||||||||||||||||
| Rqaocline | RQAOCDTL |
| ||||||||||||||||||||||||||||||||||||
| Rqaudit | RQAUDIT |
| ||||||||||||||||||||||||||||||||||||
| Rqlinedtl | RQLINEDTL |
| ||||||||||||||||||||||||||||||||||||
| Whdemand | WHDEMAND |
| ||||||||||||||||||||||||||||||||||||
| Whshipline | WHSHIPLINE |
| ||||||||||||||||||||||||||||||||||||
| Whshipment | WHSHIPMENT |
|
All trademarks and registered trademarks are the property of their
respective owners.