REQLINE

Requisition Line

This file contains the line item information for the requisition.

REFERENCED BY
AM19.1 AM19.2 AP115 AP220 AP305 POIF.1
POIG.1 POIM.1 MM280 RQ50.1 ICI9.1


UPDATED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 API1.1 API2.1
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MAI1.1 PO136
PO190 PO300 PO520 POCP.1 POI3.1 POII.1
POIJ.1 RQ300

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).
POIF.1 POIG.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.
POIF.1 POIG.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.
POIF.1 POIG.1
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.
POIF.1 POIG.1
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.
POIF.1 POIG.1
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
POIF.1 POIG.1
RLN-SERVICE-CODE
Element: Service Code		Alpha 1

Q = Quantity
" " = Not Service Item
A = Amount
POIF.1 POIG.1
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.
POIF.1 POIG.1
RLN-QUANTITY
Element: Quantity		Signed 13.4
Enter the requested quantity. If left blank, this defaults to 1.
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP25.1 AP25.2
AP30.4 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 POIF.1
POIG.1
RLN-ENTERED-UOM
Element: Uom		Alpha 4
This field contains the valid stock unit of measure for this item.
POIF.1 POIG.1
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.
POIF.1 POIG.1
RLN-RETURN-QTY
Element: Quantity		Signed 13.4
This field contains the desired quantity.
POIF.1 POIG.1
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.
POIF.1 POIG.1
RLN-COST-OPTION
Element: Cost Option		Alpha 1

1 = Cost Required
2 = No Charge
3 = Vendor Determined
POIF.1 POIG.1
RLN-OVERIDE-CST-FL
Element: Overide Cst Fl		Alpha 1

Y = Yes
N = No
POIF.1 POIG.1
RLN-CREATE-PO-FL
Element: Create Po Fl		Alpha 1

Y = Yes
N = No
POIF.1 POIG.1
RLN-AGREEMENT-REF
Element: Agreement Ref		Alpha 30
POIF.1 POIG.1
RLN-VENDOR
Element: Vendor		Alpha 9 (Right Justified)
The vendor's identification code.
POIF.1 POIG.1
RLN-PURCH-FR-LOC
Element: Purch Fr Loc		Alpha 4
The vendor's purchase from location.
POIF.1 POIG.1
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.
POIF.1 POIG.1
RLN-PURCH-MINOR
Element: Minor Class		Alpha 4
Purchase Class Minor Field.
POIF.1 POIG.1
RLN-BUYER
Element: Buyer		Alpha 3
Buyer code, defaulted from the Requisition Header or Item Location file if the buyer code is blank.
POIF.1 POIG.1
RLN-FROM-COMPANY
Element: Company		Numeric 4
The company from which the requisition gets replenished.
POIF.1 POIG.1
RLN-FROM-LOCATION
Element: Location		Alpha 5
This field contains a valid stocking location within the company inventory.
POIF.1 POIG.1
RLN-REQ-LOCATION
Element: Req Location		Alpha 5
The location requisitioning items. This location can be an inventory or noninventory location.
POIF.1 POIG.1
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.
POIF.1 POIG.1
RLN-LATE-DL-DATE
Element: Late Dl Date		Numeric 8 (yyyymmdd)
This field contains the late delivery date.
POIF.1 POIG.1
RLN-CREATION-DATE
Element: Creation Date		Numeric 8 (yyyymmdd)
This is the date that this line was added to the requisition.
POIF.1 POIG.1
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.
POIF.1 POIG.1
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
POIF.1 POIG.1
RLN-PO-CODE
Element: Po Code		Alpha 4
This is the purchase order code.
POIF.1 POIG.1
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.
POIF.1 POIG.1
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
POIF.1 POIG.1
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
POIF.1 POIG.1
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
POIF.1 POIG.1
RLN-LAST-RET-SEQ
Element: Seq		Numeric 3
This field contains the record sequence number.
POIF.1 POIG.1
RLN-VEN-ITEM
Element: Item		Alpha 32
The vendor's identifier for this item.
POIF.1 POIG.1
RLN-STATUS
Element: Status		Numeric 1
This is the processing status of a requisition line.
0 = Unreleased
1 = Released
8 = Rejected
9 = Processed
POIF.1 POIG.1
RLN-CLOSED-FL
Element: Closed Fl		Alpha 1
The Closed Flag.
Y = Yes
N = No
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POIF.1
POIG.1 POII.1
POIJ.1 RQ300
RLN-BIN
Element: Bin		Alpha 7
This field contains a storage area for an item or any number of items.
POIF.1 POIG.1
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.
POIF.1 POIG.1
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.
POIF.1 POIG.1
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.
POIF.1 POIG.1
RLN-USER-DATE-3
Element: Date		Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
POIF.1 POIG.1
RLN-USER-DATE-4
Element: Date		Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
POIF.1 POIG.1
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.
POIF.1 POIG.1
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.
POIF.1 POIG.1
RLN-MANUF-CODE
Element: Manuf Code		Alpha 4
This is a user defined code that indicates the manufacturer of an item.
POIF.1 POIG.1
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.
POIF.1 POIG.1
RLN-MANUF-NBR
Element: Manuf Nbr		Alpha 35
This is the identifier that the manufacturer has assigned to an item.
POIF.1 POIG.1
RLN-LAST-DIST-SEQ
Element: Seq Nbr		Numeric 4
An automatically assigned sequence number.
POIF.1 POIG.1
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
POIF.1 POIG.1
RLN-KILL-QUANTITY
Element: Kill Quantity		Signed 13.4
POIF.1 POIG.1
RLN-ENTERED-ITEM
Element: Entered Item		Alpha 25
POIF.1 POIG.1
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
POIF.1 POIG.1
RLN-ENTRY-FL
Element: Entry Fl		Alpha 1

1 = Item
2 = UPC
3 = UPN1
4 = UPN2
5 = NDC
6 = SKU
POIF.1 POIG.1
RLN-RQSRC-MACHINE
Element: Rqsrc Machine		Alpha 6

DROYAL
ESIOB
HBOC
OMNICL
PAREXC
PERSE
PYXIS
INTER
EAM
POIF.1 POIG.1
RLN-PAR-ORDER-ID
Element: Par Order Id		Alpha 20
POIF.1 POIG.1
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
POIF.1 POIG.1
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
POIF.1 POIG.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
RLN-RQ-SOURCE
Element: Rq Source		Numeric 2

00 = Upgrade
01 = IC142
02 = IC141
03 = IC83
04 = RQ35
05 = RQ500
06 = RSS
07 = RQ10
08 = DR100
09 = Website
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
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
RLN-PROD-TAX-CAT
Element: Prod Tax Cat		Alpha 15
POIF.1 POIG.1
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
POIF.1 POIG.1
RLN-PO-USER-FLD-7
Element: User Fld 7		Alpha 10 (Lower Case)
RLN-EAM-OPER-NBR
Element: Operation Nbr		Numeric 4
POIF.1 POIG.1
RLN-EAM-SEQ-NBR
Element: Seq Nbr		Numeric 4
POIF.1 POIG.1
RLN-EAM-WO-NBR
Element: Work Order		Numeric 8
POIF.1 POIG.1
RLN-ORIGINAL-UOM
Element: Uom		Alpha 4
RLN-ORIGINAL-COST
Element: Intl Cost		Signed 18.5
RLN-CREATION-TIME
Element: Time		Numeric 8
POIF.1 POIG.1


REQLINE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RLNSET1 COMPANY
REQ-NUMBER
LINE-NBR
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
RLNSET10 COMPANY
REQ-NUMBER
AGREEMENT-REF
ITEM
VEN-ITEM
ENTERED-UOM
LINE-NBR
Subset
Where(AGREEMENT-REF !=Spaces)
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
RLNSET11 COMPANY
REQ-LOCATION
ITEM
CREATION-DATE*
REQ-NUMBER*
LINE-NBR
KeyChange
RLNSET2 COMPANY
REQ-NUMBER-A
LINE-NBR
Subset
WhereITEM-TYPE ="I"
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
RLNSET3 FROM-COMPANY
FROM-LOCATION
ITEM
REQ-NUMBER
LINE-NBR
KeyChange
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
RLNSET4 COMPANY
REQ-NUMBER
LINE-NBR
Subset
Where(CLOSED-FL !="Y")
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
RLNSET5 COMPANY
REQ-LOCATION
ITEM
REQ-DEL-DATE*
REQ-NUMBER
LINE-NBR
KeyChange
RLNSET6 COMPANY
REQ-LOCATION
CREATION-DATE
ITEM
REQ-NUMBER
LINE-NBR
KeyChange
RLNSET7 COMPANY
REQ-NUMBER
LINE-NBR
ITEM-TYPE
KeyChange
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
RLNSET8 COMPANY
ITEM
REQ-NUMBER
LINE-NBR
ICI9.1
RLNSET9 FROM-COMPANY
REQ-NUMBER-A
LINE-NBR
KeyChange, Subset
WhereCOMPANY !=FROM-COMPANY


REQLINE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Ap Company APCOMPANY Not Required
PCY-COMPANY->CPY-COMPANY (CPYSET1)
Commcodes COMMCODES Not Required
ITE-ITEM-GROUP->ISC-ITEM-GROUP
RLN-COMMODITY-CODE->ISC-COMMODITY-CODE
From Location ICLOCATION Required
RLN-FROM-COMPANY->ICL-COMPANY
RLN-FROM-LOCATION->ICL-LOCATION
Ic Company ICCOMPANY Required
RLN-FROM-COMPANY->ICC-COMPANY
Item ITEMMAST Required
When RLN-ITEM-TYPE ="I"
OrRLN-ITEM-TYPE ="N"
ICC-ITEM-GROUP->ITE-ITEM-GROUP
RLN-ITEM->ITE-ITEM
Item Location ITEMLOC Required
When RLN-ITEM-TYPE ="I"
RLN-FROM-COMPANY->ITL-COMPANY
RLN-FROM-LOCATION->ITL-LOCATION
RLN-ITEM->ITL-ITEM
Mmuaval MMUAVAL Not Required
RLN-COMPANY->MUA-COMPANY
"RQ"->MUA-SYSTEM-CD
RLN-FROM-LOCATION->MUA-LOCATION
"RQ"->MUA-DOC-TYPE
Spaces->MUA-DOC-NUMBER
RLN-REQ-NUMBER->MUA-DOC-NBR-NUM
Spaces->MUA-PO-CODE
RLN-LINE-NBR->MUA-LINE-NBR
Zeroes->MUA-API-OBJ-ID
Zeroes->MUA-SEQ-NBR
Po Company POCOMPANY Required
RLN-FROM-COMPANY->PCY-COMPANY
Pocontgrp POCONTGRP Required
When RLN-CM-CONTRACT !=Zeroes
RLN-CONTRACT-GROUP->CNG-CONTRACT-GROUP
Pocontract POCONTRACT Required
When RLN-CM-CONTRACT !=Zeroes
RLN-CONTRACT-GROUP->CMH-CONTRACT-GROUP
RLN-CM-CONTRACT->CMH-CM-CONTRACT
Porlnuf PORLNUF Not Required, Delete Cascades
RLN-COMPANY->UFQ-COMPANY
RLN-REQ-NUMBER->UFQ-REQ-NUMBER
RLN-LINE-NBR->UFQ-LINE-NBR
Povagrmtln POVAGRMTLN Not Required
RLN-PVN-OBJ-ID->PVN-PVN-OBJ-ID
Povapartln POVAPARTLN Not Required
PCY-PROCURE-GROUP->TPL-PROCURE-GROUP
RLN-AGREEMENT-REF->TPL-VEN-AGRMT-REF
RLN-PVN-OBJ-ID->TPL-PVN-OBJ-ID
RLN-PART-SEQ-NBR->TPL-PART-SEQ-NBR
Req Location RQLOC Required
RLN-COMPANY->RQL-COMPANY
RLN-REQ-LOCATION->RQL-REQ-LOCATION
Requester REQUESTER Required
RQH-REQUESTER->REQ-REQUESTER
Requisition REQHEADER Required
RLN-COMPANY->RQH-COMPANY
RLN-REQ-NUMBER->RQH-REQ-NUMBER
Vendor APVENMAST Not Required
CPY-VENDOR-GROUP->VEN-VENDOR-GROUP
RLN-VENDOR->VEN-VENDOR
Whdemand Phar WHDEMAND Not Required
RLN-COMPANY->WDM-COMPANY
"PH"->WDM-SYSTEM-CD
RLN-REQ-NUMBER-A->WDM-DOC-NBR
RLN-LINE-NBR->WDM-LINE-NBR
Zeroes->WDM-COMPONENT-SEQ
RLN-FROM-LOCATION->WDM-LOCATION
Whdemndhdr WHDEMNDHDR Not Required
RLN-FROM-COMPANY->WDH-COMPANY
"RQ"->WDH-SYSTEM-CD
RLN-REQ-NUMBER->WDH-DOC-NBR-NUM


REQLINE FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Accounts MMDIST
RLN-COMPANY->MMD-COMPANY
RLN-REQ-NUMBER->MMD-DOC-NBR-NUM
RLN-LINE-NBR->MMD-LINE-NBR
  MMD-LINE-SEQ
Location Rule WHLOCRULE
RLN-FROM-COMPANY->WHU-COMPANY
RLN-LOCATION-RULE->WHU-LOCATION-RULE
  WHU-LEVEL
Pointaudit POINTAUDIT
PCY-PROCURE-GROUP->PII-PROCURE-GROUP
RLN-COMPANY->PII-OPER-COMPANY
"RQ"->PII-ORIGIN-CD
Spaces->PII-SOURCE-DOC-A
RLN-REQ-NUMBER->PII-SOURCE-DOC-N
RLN-LINE-NBR->PII-LINE-NBR
  PII-UPDATE-DATE
  PII-UPDATE-TIME
  PII-FLD-NBR
  PII-AUDIT-TYPE
  PII-AUDIT-ACTION
Polinesrc POLINESRC
Valid When RLN-CREATE-PO-FL ="Y"
AndRLN-STATUS >=1
RLN-COMPANY->PLS-OPER-COMPANY
"RQ"->PLS-ORIGIN-CD
RLN-REQ-NUMBER->PLS-SOURCE-DOC-N
RLN-LINE-NBR->PLS-SRC-LINE-NBR
  PLS-PO-CODE
  PLS-PO-NUMBER
  PLS-PO-RELEASE
  PLS-LINE-NBR
Whdemand WHDEMAND
RLN-FROM-COMPANY->WDM-COMPANY
"RQ"->WDM-SYSTEM-CD
RLN-REQ-NUMBER-A->WDM-DOC-NBR
RLN-LINE-NBR->WDM-LINE-NBR
RLN-FROM-LOCATION->WDM-LOCATION
  WDM-COMPONENT-SEQ
Whshipline WHSHIPLINE
RLN-FROM-COMPANY->WHL-COMPANY
"RQ"->WHL-SYSTEM-CD
RLN-REQ-NUMBER-A->WHL-DOC-NBR
RLN-LINE-NBR->WHL-LINE-NBR
  WHL-SHIPMENT-NBR
Whshipment WHSHIPMENT
RLN-FROM-COMPANY->WHS-COMPANY
RLN-FROM-LOCATION->WHS-LOCATION
RLN-REQ-NUMBER-A->WHS-DOC-NBR
  WHS-SHIPMENT-NBR

File created: Wed Jun 08 20:51:35 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.