Vendor Location Master
This file contains information for a vendor's purchase-from location. This information is for use by the Purchase Order system.
REFERENCED BY
| AP10.2 | IC141 | IC266 | PO99.1 | POIT.1 | RQ11.1 |
| RQIB.1 | RQIC.1 | RQID.1 | RQIG.1 | RQIH.1 | RQIJ.1 |
| IC258 | IC58.1 | IC58.2 | IC58.3 |
| FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PVL-VENDOR-GROUP Element: Vendor Group | Alpha 4 A vendor group represents a group of vendors that can be shared by one or more companies. |
|
||||||||||||
| PVL-VENDOR Element: Vendor | Alpha 9 (Right Justified) The vendor's identification code. |
|
||||||||||||
| PVL-PURCH-FR-LOC Element: Purch Fr Loc | Alpha 4 The vendor's purchase from location. |
|
||||||||||||
| PVL-LEADTIME-DAYS Element: Leadtime Days | Numeric 3 This field contains the average lead-time days. The average of the last and the previous lead-time days if system calculated. |
|
||||||||||||
| PVL-EDI-NUMBER Element: Edi Nbr | Alpha 15 |
|
||||||||||||
| PVL-FAX-PREFIX Element: Phone Prefix | Alpha 6 The telephone number country code. |
|
||||||||||||
| PVL-FAX-EXT Element: Phone Ext | Alpha 5 This field contains the telephone extension number. |
|
||||||||||||
| PVL-FAX-NUMBER Element: Phone | Alpha 15 Phone number. |
|
||||||||||||
| PVL-FREIGHT-TERMS Element: Freight Terms | Alpha 1 Freight terms are used to define who pays for freight costs incurred when goods are shipped. Prepaid, for instance, would normally mean that the vendor would pay for freight. Collect would mean the customer would pay for freight. A freight terms code can be entered on a purchase order, or defaulted by vendor or company. |
|
||||||||||||
| PVL-SHIP-VIA Element: Ship Via | Alpha 12 (Lower Case) The vendor location's default ship via description. |
|
||||||||||||
| PVL-FOB-CODE Element: Fob Code | Alpha 3 User-defined ship term code is defined as a default for this vendor location. |
|
||||||||||||
| PVL-NORM-DEL-DAY Element: Norm Del Day | Alpha 3 The normal delivery day for this vendor at this location. Information only. FRI = Friday MON = Monday SAT = Saturday SUN = Sunday THU = Thursday TUE = Tuesday WED = Wednesday |
|
||||||||||||
| PVL-USHIP-TOL-PCT Element: Uship Tol Pct | Percent 6.3 (Percent) This is the quantity undership percentage for automatic back order cancellation. If a value of 10% is entered here, for instance, and a quantity of 91 is shipped against an ordered quantity of 100, that would be considered a 9% undershipment. Since this is less than the 10% limit, the backordered amount would be canceled. This process takes place at receiving time. If a backorder is not canceled manually, the system checks, in order, the purchase order line, the purchase order vendor purchase from record, the purchase order vendor record, and the company record. If an undershipment percentage of a zero percent flag set to Y is encountered at any level, that value is used. NOTE-The percentage can be set at 100%, which would cancel all backorders. This file contains purchase order specific information for purchase order vendor defaulting. |
|
||||||||||||
| PVL-ISSUE-METH Element: Issue Meth | Alpha 1 Specifies the method that will be used to issue the purchase order to the vendor. P = Paper F = Fax E = EDI I = Internet Mail D = Do Not Print |
|
||||||||||||
| PVL-REV-ISSUE-METH Element: Rev Issue Meth | Alpha 1 Specifies the method that will be used to issue purchase order revisions to the vendor. P = Paper F = Fax E = EDI I = Internet Mail D = Do Not Print |
|
||||||||||||
| PVL-REV-EDI-NUMBER Element: Edi Nbr | Alpha 15 |
|
||||||||||||
| PVL-REV-EDI-TRANS Element: Rev Edi Trans | Alpha 1 For vendors that receive purchase order revisions via EDI, this specifies whether the EDI transaction is a normal EDI purchase order transaction (for example, an ANSI X12 850) or a change purchase order transaction (for example, an ANSI X12 860). N = Not Applicable P = PO Transaction C = Change Transaction |
|
||||||||||||
| PVL-REVISIONS-INCL Element: Revisions Incl | Alpha 1 Specifies what information will be included when a revised Purchase Order is re-issued. You may specify that only the revised information is included, along with messages that indicate what was revised (option O - Revisions Only). Alternately, you may specify that the entire PO is included, along with messages that indicate the revisions. Finally, you may specify that the entire PO is re-issued. No revision messages will appear. If the PO has not been printed, or the revised PO is not to be re-issued, this field will be blank (Not Applicable). O = Revisions Only C = Revisions Complete I = Reissue " " = Not Applicable |
|
||||||||||||
| PVL-VENDOR-CONTCT Element: Vendor Name | Alpha 30 The requester can enter the recommended vendor's name for the requested items. |
|
||||||||||||
| PVL-PHONE-PREFIX Element: Phone Prefix | Alpha 6 The telephone number country code. |
|
||||||||||||
| PVL-PHONE-NUM Element: Phone | Alpha 15 Phone number. |
|
||||||||||||
| PVL-PHONE-EXT Element: Phone Ext | Alpha 5 This field contains the telephone extension number. |
|
||||||||||||
| PVL-PO-CODE Element: Po Code | Alpha 4 This is the purchase order code that will default from the vendor location to the purchase order. |
|
||||||||||||
| PVL-OVEND-SHIP-VIA Element: Ship Via | Alpha 12 (Lower Case) |
|
||||||||||||
| PVL-LOADING-PORT Element: Loading Port | Alpha 5 The port where the goods are loaded, if required. The port code must be defined in IN04.1 (Port Maintenance) |
|
||||||||||||
| PVL-UNLOADING-PORT Element: Unloading Port | Alpha 5 The prot where the goods are unloaded if required. Must be defined in IN04.1 (Port Maintenance) |
|
||||||||||||
| PVL-PUNCHOUT-CHG-F Element: Punchout Chg F | Numeric 1 0 = Changes allowed 1 = Changes not allowed |
|
||||||||||||
| PVL-EMAIL-ADDRESS Element: Email Address | Alpha 60 (Lower Case) e-mail address. |
|
||||||||||||
| PVL-REORDER-SUN-FL Element: Reorder Mon Fl | Numeric 1 |
|
||||||||||||
| PVL-REORDER-MON-FL Element: Reorder Mon Fl | Numeric 1 |
|
||||||||||||
| PVL-REORDER-TUE-FL Element: Reorder Mon Fl | Numeric 1 |
|
||||||||||||
| PVL-REORDER-WED-FL Element: Reorder Mon Fl | Numeric 1 |
|
||||||||||||
| PVL-REORDER-THU-FL Element: Reorder Mon Fl | Numeric 1 |
|
||||||||||||
| PVL-REORDER-FRI-FL Element: Reorder Mon Fl | Numeric 1 |
|
||||||||||||
| PVL-REORDER-SAT-FL Element: Reorder Mon Fl | Numeric 1 |
|
||||||||||||
| PVL-LOC-ID-PRT Element: Loc Id Prt | Numeric 1 0 = No Print 1 = Print HIN on PO Line 2 = Print GLN on PO Line |
|
||||||||||||
| PVL-OSHIP-TOL-PCT Element: Cost Pct | Percent 5.3 (Percent) Cost Percent. Percent to applied to unit cost of the item to arrive at the Add on charge cost. |
|
||||||||||||
| PVL-ZERO-OSHIP-FL Element: All Flag | Alpha 1 N = No Y = Yes |
|
||||||||||||
| PVL-ZERO-USHIP-FL Element: All Flag | Alpha 1 N = No Y = Yes |
|
||||||||||||
| PVL-CANCEL-ALL-BO Element: Cancel All Bo | Alpha 1 If set to "Y", when the first receiving is processed against a purchase order for this vendor, any items that are backordered will be canceled, including items that were not shipped. Y = Cancel all backorders N = Do not cancel all backorders |
|
||||||||||||
| PVL-RMA-REQUIRED Element: All Flag | Alpha 1 N = No Y = Yes |
|
||||||||||||
| PVL-RMA-DOC-REQ Element: All Flag | Alpha 1 N = No Y = Yes |
|
||||||||||||
| PVL-UPD-PO-COST Element: Upd Po Cost | Numeric 1 Used by Pharmacy subsystem to indicate if the line item cost should be updated by programs PO122 and MA531. By setting the value to 3 the user is telling the programs to take the pricing of this item from the EDI 855 and 856 transactions an update the PO. 1 = Do not update PO cost from Rec 2 = Update PO cost from Rec or Ack |
|
||||||||||||
| PVL-OVER-AGRMT Element: Over Agrmt | Alpha 1 Enter a Y to indicate the user can manually enter a cost which will not be overridden by an existing price agreement. Y = Yes N = No |
|
||||||||||||
| PVL-OVER-LC-LP Element: Over Lc Lp | Alpha 1 Enter a Y to indicate the user can manually enter a cost which will not be overridden by a last cost or last PO created cost default. Y = Yes N = No |
|
||||||||||||
| PVL-BUYER-CODE Element: Buyer | Alpha 3 |
|
||||||||||||
| PVL-OPEN-PO-LIMIT Element: Intl Amt | Signed 18.2 |
|
||||||||||||
| PVL-OPEN-PO-AMT Element: Intl Amt | Signed 18.2 |
|||||||||||||
| PVL-MAX-ORDER-AMT Element: Intl Amt | Signed 18.2 |
|
||||||||||||
| PVL-REQ-LOC-LEVEL Element: Req Loc Level | Alpha 1 This field is used to determine how requisition lines can be combined, based on requesting location, in two different circumstances. The first circumstance is whether multiple requisition lines can be combined into one PO line. If the flag is set to "S", they can be combined regardless of requesting locations on the lines. If the flag is set to "L" or "H", the req lines can only be combined if the requesting locations are the same. The second circumstance is whether requisition lines for different requesting locations can be combined on the same PO. If the flag is set to "S" or "L", they can be combined. If the flag is set to "H", they cannot be combined. S = Combine req lines to PO line L = Comb reqs to PO line by loc H = Cannot mix req loc on PO N = Cannot combine requisitions |
|
||||||||||||
| PVL-MIN-ORD-WEIGHT Element: Min Ord Weight | Signed 9.3 |
|
||||||||||||
| PVL-ONE-SRC-ONE-PO Element: One Src One Po | Numeric 1 0 = No 1 = 1 Requisition to One PO 2 = One Sales Order to One PO 3 = Req and Sales Order to One PO |
|
||||||||||||
| PVL-MIN-PO-AMT Element: Intl Amt | Signed 18.2 |
|
||||||||||||
| PVL-GLN-NBR Element: Gln Nbr | Alpha 13 |
|
||||||||||||
| PVL-REQ-CONT-LEVEL Element: Req Cont Level | Alpha 1 |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||
|---|---|---|---|---|---|---|---|---|---|
| PVLSET1 |
VENDOR-GROUP VENDOR PURCH-FR-LOC |
|
|||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Apvenloc | APVENLOC |
Required
| |||||||||||||||||||||
| Buyer | BUYER |
Required
| |||||||||||||||||||||
| Fobcode | FOBCODE |
Not Required
| |||||||||||||||||||||
| Glnloc | GLNLOC |
Not Required
| |||||||||||||||||||||
| Glnlocdtl | GLNLOCDTL |
Not Required
| |||||||||||||||||||||
| Pofrtterm | POFRTTERM |
Not Required
| |||||||||||||||||||||
| Popvluf | POPVLUF |
Not Required
| |||||||||||||||||||||
| Procuregrp | PROCUREGRP |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.