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 AP590 IC258 IC266 IC58.1 IC58.2
IC58.3 PO13.1 PO13.3 PO196 PO197 PO210
PO61.3 POI7.1 POIT.1 RQIC.1 RQID.1 RQIG.1
RQIH.1


UPDATED BY
AC160 AM115 AM117 AM15.1 AM15.2 AM15.3
AM15.4 AM19.1 AM19.2 AM20.1 AM20.3 AM21.1
AM21.3 AM22.1 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 AP271 AP30.2 AP30.4
AP300 AP305 AP510 AP90.1 AP91.1 API1.1
API2.1 API3.1 API4.1 CX100 CX20.1 CX20.2
CX20.4 CX20.5 CX220 CX30.1 CX300 CX506
CXCP.1 DR100 IC12.1 IC140 IC141 IC142
IC145 IC243 IC330 IC64.1 IC64.2 IC64.3
IC64.4 IC64.5 IC64.6 IC64.7 IC64.8 IC64.9
IC66.1 IC83.1 IC840 MX123 MX500 MA126
MA180 MA278 MA279 MA41.1 MA41.2 MA41.4
MA41.7 MA42.1 MA42.2 MA43.1 MA43.2 MA43.3
MA43.4 MA43.6 MA43.7 MA44.1 MA44.2 MA53.1
MA530 MA531 MA540 MA60.2 MA60.3 MA60.5
MA61.1 MA63.1 MA65.1 MA66.2 MA67.2 MA67.3
MA68.2 MA68.3 MA68.5 MA69.1 MA70.1 MA75.1
MA80.1 MAI1.1 PD10.1 PD10.2 PD130 PD20.1
PD20.2 PD20.3 PD235 PD570 PO04.1 PO04.2
PO10.1 PO10.2 PO100 PO101 PO115 PO120
PO122 PO131 PO132 PO136 PO15.1 PO15.2
PO15.4 PO150 PO17.1 PO190 PO192 PO195
PO20.1 PO20.6 PO20.9 PO204 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO22.2 PO22.3
PO22.4 PO22.5 PO220 PO222 PO223 PO224
PO225 PO229 PO23.1 PO230 PO233 PO234
PO24.1 PO25.1 PO25.5 PO25.6 PO25.7 PO251
PO253 PO254 PO26.3 PO26.7 PO26.9 PO27.2
PO27.3 PO27.4 PO275 PO276 PO277 PO278
PO28.2 PO280 PO29.1 PO30.1 PO30.2 PO30.3
PO30.4 PO300 PO31.1 PO31.2 PO32.2 PO32.4
PO33.1 PO34.1 PO35.1 PO36.1 PO36.2 PO38.1
PO39.1 PO39.2 PO44.1 PO50.1 PO52.1 PO520
PO529 PO536 PO54.1 PO54.2 PO54.3 PO54.4
PO54.5 POCP.1 POI3.1 POID.1 POII.1 POIJ.1
PR05.1 PR05.3 PR226 PR247 PR26.1 PR47.1
PR514 RQ01.1 RQ10.1 RQ10.2 RQ10.3 RQ10.4
RQ10.5 RQ11.1 RQ12.1 RQ13.1 RQ13.2 RQ260
RQ35.1 RQ44.1 RQ500 RQ810 RQIB.1 RQIF.1
RQII.1 RQIJ.1 WH130 WH132 WH190 WH20.2
WH20.7 WH222 WH30.1 WH30.2 WH30.3 WH30.4
WH31.1 WH31.2 WH31.3 WH31.4 WH32.1 WH32.2
WH32.3 WH32.4 WH32.5 WH33.1 WH33.2 WH33.3
WH33.4 WH33.5 WH33.6 WH33.8 WH33.9 WH34.1
WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520
WH830

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
PO22.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 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA53.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
PO220
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 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
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
POV-DSP-PAT-ID
Element: Flag
Alpha 1
PO10.1
POV-EDI-PAT-ID
Element: Flag
Alpha 1
PO10.1
POV-MSK-PAT-ID
Element: Flag
Alpha 1
PO10.1
POV-DSP-VISIT-NBR
Element: Flag
Alpha 1
PO10.1
POV-EDI-VISIT-NBR
Element: Flag
Alpha 1
PO10.1
POV-MSK-VISIT-NBR
Element: Flag
Alpha 1
PO10.1
POV-DSP-CASE-NBR
Element: Flag
Alpha 1
PO10.1
POV-EDI-CASE-NBR
Element: Flag
Alpha 1
PO10.1
POV-MSK-CASE-NBR
Element: Flag
Alpha 1
PO10.1
POV-DSP-PROC
Element: Flag
Alpha 1
PO10.1
POV-EDI-PROC
Element: Flag
Alpha 1
PO10.1
POV-DSP-PROC-DT
Element: Flag
Alpha 1
PO10.1
POV-EDI-PROC-DT
Element: Flag
Alpha 1
PO10.1
POV-DSP-PHYS-NAME
Element: Flag
Alpha 1
PO10.1
POV-EDI-PHYS-NAME
Element: Flag
Alpha 1
PO10.1
POV-DSP-NRS-COORD
Element: Flag
Alpha 1
PO10.1
POV-EDI-NRS-COORD
Element: Flag
Alpha 1
PO10.1
POV-DSP-SALES-REP
Element: Flag
Alpha 1
PO10.1
POV-EDI-SALES-REP
Element: Flag
Alpha 1
PO10.1
POV-DSP-ORD-NBR
Element: Flag
Alpha 1
PO10.1
POV-EDI-ORD-NBR
Element: Flag
Alpha 1
PO10.1
POV-DSP-REQUESTOR
Element: Flag
Alpha 1
PO10.1
POV-EDI-REQUESTOR
Element: Flag
Alpha 1
PO10.1
POV-DSP-LOT
Element: Flag
Alpha 1
PO10.1
POV-EDI-LOT
Element: Flag
Alpha 1
PO10.1
POV-DSP-SER-NBR
Element: Flag
Alpha 1
PO10.1
POV-EDI-SER-NBR
Element: Flag
Alpha 1
PO10.1
POV-DSP-USERDEF1
Element: Flag
Alpha 1
PO10.1
POV-EDI-USERDEF1
Element: Flag
Alpha 1
PO10.1
POV-DSP-USERDEF2
Element: Flag
Alpha 1
PO10.1
POV-EDI-USERDEF2
Element: Flag
Alpha 1
PO10.1
POV-ALLOW-VI-UPDT
Element: All Flag
Alpha 1

N = No
Y = Yes
PO10.1
POV-DSP-PAT-NAME
Element: Flag
Alpha 1
PO10.1
POV-EDI-PAT-NAME
Element: Flag
Alpha 1
PO10.1
POV-DSP-BIRTHDATE
Element: Flag
Alpha 1
PO10.1
POV-EDI-BIRTHDATE
Element: Flag
Alpha 1
PO10.1
POV-DSP-GENDER
Element: Flag
Alpha 1
PO10.1
POV-EDI-GENDER
Element: Flag
Alpha 1
PO10.1
POV-DSP-SSN
Element: Flag
Alpha 1
PO10.1
POV-EDI-SSN
Element: Flag
Alpha 1
PO10.1
POV-DSP-PROC-MOD
Element: Flag
Alpha 1
PO10.1
POV-EDI-PROC-MOD
Element: Flag
Alpha 1
PO10.1
POV-ORDER-MIN-EDIT
Element: Flag Num
Numeric 1

0 = Purchase Orders
1 = Purchase Orders & Requisitions
PO10.1


POVENDOR FILE INDEX

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


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: Thu Jun 09 02:28:09 2016

Home
Contact Us



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