POVENDOR

PO Vendor Master

This file contains default values for the vendor used by the Purchase Order system when creating purchase orders, as well as vendor purchasing contact information.

REFERENCED BY
AP10.1


UPDATED BY
AM115 AM117 AM15.1 AM15.2 AM15.3 AM15.4
AM19.1 AM19.2 AM20.1 AM20.3 AM21.1 AM21.3
AM500 AM51.1 AM551 AM97.1 AP03.3 AP110
AP115 AP125 AP126 AP131 AP150 AP20.1
AP20.2 AP20.3 AP20.4 AP20.5 AP20.7 AP21.1
AP210 AP220 AP23.1 AP25.1 AP25.2 AP26.1
AP27.1 AP30.2 AP30.4 AP300 AP305 AP510
AP90.1 AP91.1 API1.1 API2.1 API3.1 API4.1
MX123 MX500 MA41.1 MA41.2 MA41.4 MA41.7
MA43.1 MA43.2 MA43.3 MA43.4 MA43.6 MA43.7
MAI1.1 PO10.1 PO10.2 PO136 PO190 PO300
PO520 POCP.1 POI3.1 POII.1 POIJ.1 PR05.1
PR05.3 PR226 PR247 PR26.1 PR47.1 PR514
UK47.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
POV-VENDOR-GROUP
Element: Vendor Group
Alpha 4
A vendor group represents a group of vendors that can be shared by one or more companies.
AP510 PO10.1
POV-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The vendor's identification code.
AP510 PO10.1
POV-BUYER-CODE
Element: Buyer
Alpha 3
AP510 PO10.1
POV-OPEN-PO-LIMIT
Element: Intl Amt
Signed 18.2
The maximum open purchase order amount that is allowed for the vendor. A purchase order may not be released if it will cause the Open PO Amount to exceed this value.
AP510 PO10.1
POV-OPEN-PO-AMT
Element: Intl Amt
Signed 18.2
The total open amount (not cancelled and not paid) for the Vendor. This total includes only product costs (add on costs and taxes are not included) and is stated in base currency.
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
AP510 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
PO10.1 PO10.2
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
POV-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.
AP510 PO10.1
POV-EDI-NUMBER
Element: Edi Nbr
Alpha 15
AP510 PO10.1
POV-FAX-PREFIX
Element: Phone Prefix
Alpha 6
The telephone number country code.
AP510 PO10.1
POV-FAX-EXT
Element: Phone Ext
Alpha 5
This field contains the telephone extension number.
AP510 PO10.1
POV-FAX-NUMBER
Element: Phone
Alpha 15
Phone number.
AP510 PO10.1
POV-MAX-ORDER-AMT
Element: Intl Amt
Signed 18.2
The maximum open purchase order amount for this vendor.
AP510 PO10.1
POV-FREIGHT-TERMS
Element: Freight Terms
Alpha 1
The vendor's default freight term.
AP510 PO10.1
POV-SHIP-VIA
Element: Ship Via
Alpha 12 (Lower Case)
The vendor's default ship via narrative.
AP510 PO10.1
POV-FOB-CODE
Element: Fob Code
Alpha 3
The vendor's user-defined ship term code is used as a default at purchase order entry time.
AP510 PO10.1
POV-NORM-DEL-DAY
Element: Norm Del Day
Alpha 3
The vendor's normal delivery day. Information only.
FRI = Friday
MON = Monday
SAT = Saturday
SUN = Sunday
THU = Thursday
TUE = Tuesday
WED = Wednesday
AP510 PO10.1
POV-OSHIP-TOL-PCT
Element: Oship Tol Pct
Percent 5.3 (Percent)
Quantity overshipment tolerance percentage.
AP510 PO10.1
POV-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.
AP510 PO10.1
POV-ZERO-OSHIP-FL
Element: All Flag
Alpha 1
The vendor default overshipment quantity tolerance flag.
N = No
Y = Yes
AP510 PO10.1
POV-ZERO-USHIP-FL
Element: All Flag
Alpha 1
Set this flag to "Y" to indicate that the undershipment tolerance percent should be set to "zero" at this level. This means that no backorders will be canceled. The undershipment tolerance percent must be blank to set this flag to "Y".
N = No
Y = Yes
AP510 PO10.1
POV-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
AP510 PO10.1
POV-RMA-REQUIRED
Element: All Flag
Alpha 1
Enter a Y to indicate that the vendor requires return material authorization numbers when returns are made to them. The RMA number will then be required to be entered on any returns to that vendor, and vendor RMA documents can be printed to send to the vendor with the return goods.
N = No
Y = Yes
AP510 PO10.1
POV-RMA-DOC-REQ
Element: All Flag
Alpha 1

N = No
Y = Yes
AP510 PO10.1
POV-OVEND-SHIP-VIA
Element: Ship Via
Alpha 12 (Lower Case)
AP510 PO10.1
POV-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 purchase order 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 requisition 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 purchase order. 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
AP510 PO10.1
POV-REQ-CONT-LEVEL
Element: Req Cont Level
Alpha 1
This field is used to determine whether requisition lines with different agreement references can be combined onto a single purchase order. If the flag is set to "L", different contracts can be combined. If the flag is set to "H", they cannot be combined. This file contains header information for each purchase order.
L = Can Mix Contracts On PO
H = Cannot Mix Contracts On PO
PO10.1
POV-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
AP510 PO10.1
POV-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
AP510 PO10.1
POV-REV-EDI-NUMBER
Element: Edi Nbr
Alpha 15
AP510 PO10.1
POV-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).
" " = Not Applicable
P = PO Transaction
C = Change Transaction
AP510 PO10.1
POV-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
N = Not applicable
AP510 PO10.1
POV-VENDOR-CONTCT
Element: Vendor Name
Alpha 30
The requester can enter the recommended vendor's name for the requested items.
AP510 PO10.1
POV-PHONE-PREFIX
Element: Phone Prefix
Alpha 6
The telephone number country code.
AP510 PO10.1
POV-PHONE-NUM
Element: Phone
Alpha 15
Phone number.
AP510 PO10.1
POV-PHONE-EXT
Element: Phone Ext
Alpha 5
This field contains the telephone extension number.
AP510 PO10.1
POV-PO-CODE
Element: Po Code
Alpha 4
This is the purchase order code that will default from the vendor to the purchase order.
AP510 PO10.1
POV-MIN-ORD-WEIGHT
Element: Min Ord Weight
Signed 9.3
AP510 PO10.1
POV-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
AP510 PO10.1
POV-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)
AP510 PO10.1
POV-UNLOADING-PORT
Element: Unloading Port
Alpha 5
The prot where the goods are unloaded if required. Must be defined in IN04.1 (Port Maintenance)
AP510 PO10.1
POV-PUNCHOUT-CHG-F
Element: Punchout Chg F
Numeric 1

0 = Changes allowed
1 = Changes not allowed
AP510 PO10.1
POV-EMAIL-ADDRESS
Element: Email Address
Alpha 60 (Lower Case)
e-mail address.
AP510 PO10.1
POV-REORDER-SUN-FL
Element: Reorder Mon Fl
Numeric 1
AP510 PO10.1
POV-REORDER-MON-FL
Element: Reorder Mon Fl
Numeric 1
AP510 PO10.1
POV-REORDER-TUE-FL
Element: Reorder Mon Fl
Numeric 1
AP510 PO10.1
POV-REORDER-WED-FL
Element: Reorder Mon Fl
Numeric 1
AP510 PO10.1
POV-REORDER-THU-FL
Element: Reorder Mon Fl
Numeric 1
AP510 PO10.1
POV-REORDER-FRI-FL
Element: Reorder Mon Fl
Numeric 1
AP510 PO10.1
POV-REORDER-SAT-FL
Element: Reorder Mon Fl
Numeric 1
AP510 PO10.1
POV-LOC-ID-PRT
Element: Loc Id Prt
Numeric 1

0 = No Print
1 = Print HIN on PO Line
2 = Print GLN on PO Line
AP510 PO10.1
POV-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
PO10.1
POV-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
PO10.1
POV-ONE-SRC-ONE-PO
Element: One Src One Po
Numeric 1

0 = No
1 = One Requisition to One PO
2 = One Sales Order to One PO
3 = Req and Sales Order to One PO
PO10.1
POV-MIN-PO-AMT
Element: Intl Amt
Signed 18.2
PO10.1
POV-GLN-NBR
Element: Gln Nbr
Alpha 13
AP510 PO10.1
POV-GTIN-USED
Element: Boolean
Numeric 1

0 = No
1 = Yes
AP510 PO10.1
POV-GTIN-ITEM-SYNC
Element: Boolean
Numeric 1

0 = No
1 = Yes
AP510 PO10.1
POV-LOC-INDICATOR
Element: Loc Indicator
Derived


POVENDOR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
POVSET1 VENDOR-GROUP
VENDOR
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP03.3 AP10.1
AP110 AP115
AP125 AP126
AP131 AP150
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7


POVENDOR FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Apvenmast APVENMAST Required
POV-VENDOR-GROUP->VEN-VENDOR-GROUP
POV-VENDOR->VEN-VENDOR
Buyer BUYER Required
PCG-PROCURE-GROUP->BUY-PROCURE-GROUP
POV-BUYER-CODE->BUY-BUYER-CODE
Fobcode FOBCODE Not Required
PCG-PROCURE-GROUP->FOB-PROCURE-GROUP
POV-FOB-CODE->FOB-FOB-CODE
Glnloc GLNLOC Not Required
Valid When POV-GLN-NBR !=Spaces
PCG-ITEM-GROUP->GLO-ITEM-GROUP
POV-GLN-NBR->GLO-GLN-NBR
Glnlocdtl GLNLOCDTL Not Required
Valid When POV-GLN-NBR !=Spaces
PCG-ITEM-GROUP->GLX-ITEM-GROUP
9->GLX-GLN-TYPE
POV-VENDOR->GLX-VENDOR
Spaces->GLX-LOCATION-CODE
POV-GLN-NBR->GLX-GLN-NBR
Pofrtterm POFRTTERM Not Required
PCG-PROCURE-GROUP->POF-PROCURE-GROUP
POV-FREIGHT-TERMS->POF-FREIGHT-TERMS
Popovuf POPOVUF Not Required
POV-VENDOR-GROUP->UFV-VENDOR-GROUP
POV-VENDOR->UFV-VENDOR
Procuregrp PROCUREGRP Required
POV-VENDOR-GROUP->PCG-VENDOR-GROUP


POVENDOR FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Povendloc POVENDLOC
POV-VENDOR-GROUP->PVL-VENDOR-GROUP
POV-VENDOR->PVL-VENDOR
  PVL-PURCH-FR-LOC


File created: Wed Jun 08 20:50:58 2016

Home
Contact Us



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