|
|
POVENDOR FILE
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
AP03.3 AP10.1 AP210 CXCP.1 DR100 IC140
IC141 IC142 IC531 IC83.1 PO150 PO210
PO220 PO223 PO25.5 PO27.2 POCP.1 POID.1
POIT.1 RQ11.1 RQ12.1 RQ13.1 RQ13.2 RQ140
RQ300 RQ35.1 RQ40.1 RQ41.1 RQ42.1 RQ44.1
RQ44.2 RQ500 RQIC.1 RQID.1 RQIF.1 RQIG.1
RQIJ.1 WH130 WH132 WH190 WH222 WH25.1
WH25.2 WH30.1 WH30.2 WH30.3 WH30.4 WH31.1
WH31.2 WH31.3 WH31.4 WH32.1 WH32.2 WH32.3
WH32.4 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 WO132
WO140
UPDATED BY
AM115 AM117 AM15.1 AM15.2 AM15.3 AM15.4
AM20.1 AM20.3 AM21.1 AM21.3 AM500 AM51.1
AM551 AM97.1 AP125 AP126 AP131 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 AP510 API3.1
API4.1 BL120 BL122 BL130 BL20.1 BL20.3
BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820
BL92.1 IC28.1 IC840 MA180 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA66.2 MA66.3
MA67.1 MA67.2 MA70.1 MA75.1 MA80.1 MAI1.1
OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6
OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9
OE110 OE111 OE113 OE114 OE116 OE129
OE13.2 OE13.3 OE13.5 OE13.6 OE14.4 OE30.1
OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7
OE30.9 OE510 OE530 OE81.1 OE810 OE830
OE90.1 OE90.2 PO10.1 PO100 PO101 PO122
PO131 PO20.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO23.1 PO29.1 PO30.1 PO30.2 PO30.3
PO300 PO31.1 PO31.2 PO32.2 PO33.1 PO34.1
PO35.1 PO38.1 PO39.1 PO39.2 PO44.1 PO50.1
PO52.1 PO520 POI3.1 POIE.1 POII.1 POIJ.1
PR05.1 PR05.3 PR226 PR247 PR26.1 PR47.1
UK47.1 RQ10.1 RQ10.2 WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
POV-VENDOR-GROUP Alpha 4 AP510 PO10.1
Element: Vendor Group A vendor group represents a group of
vendors that can be shared by one or
more companies.
POV-VENDOR Alpha 9 (Right Justified) AP510 PO10.1
Element: Vendor ID The vendor's identification code.
POV-BUYER-CODE Alpha 3 AP510 PO10.1
Element: Buyer The user defined buyer identifier.
POV-OPEN-PO-LIMIT Signed 18.2 AP510 PO10.1
Element: Intl Amt The maximum open purchase order amount PO22.1
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.
POV-OPEN-PO-AMT Signed 18.2 AP125 AP126
Element: Intl Amt The total open amount (not cancelled and AP131 AP25.1
not paid) for the Vendor. This total AP25.2 AP26.1
includes only product costs (add on AP27.1 AP30.4
costs and taxes are not included) and is AP510 BL120
stated in base currency. BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
POV-LEADTIME-DAYS Numeric 3 AP510 PO10.1
Leadtime Number of This field contains the average
Days lead-time days. The average of the last
and the previous lead-time days if
system calculated.
POV-EDI-NUMBER Alpha 15 AP510 PO10.1
Element: EDI Number EDI number. PO220
POV-FAX-PREFIX Alpha 6 AP510 PO10.1
Telephone Country The fax number prefix.
Code
POV-FAX-EXT Alpha 5 AP510 PO10.1
Element: Telephone ExteThis field contains the fax number
extension.
POV-FAX-NUMBER Alpha 15 AP510 PO10.1
Element: Telephone NumbThis field contains the fax number.
POV-MAX-ORDER-AMT Signed 18.2 AP510 PO10.1
Element: Intl Amt The maximum open purchase order amount
for this vendor.
POV-FREIGHT-TERMS Alpha 1 AP510 PO10.1
Element: Freight Terms The vendor's default freight term.
POV-SHIP-VIA Alpha 12 (Lower Case) AP510 PO10.1
Element: Ship Via DescrThe vendor's default ship via narrative.
POV-FOB-CODE Alpha 3 AP510 PO10.1
Element: Shipping Term The vendor's user-defined ship term
code is used as a default at purchase
order entry time.
POV-NORM-DEL-DAY Alpha 3 AP510 PO10.1
Element: Normal DeliverThe vendor's normal delivery day.
Information only.
FRI = Friday
MON = Monday
SAT = Saturday
SUN = Sunday
THU = Thursday
TUE = Tuesday
WED = Wednesday
POV-OSHIP-TOL-PCT Percent 5.3 (Percent) AP510 PO10.1
Overshipment Quantity overshipment tolerance
Tolerance Percent percentage.
POV-USHIP-TOL-PCT Percent 6.3 (Percent) AP510 PO10.1
Cancel Backorder This is the quantity undership
Percent 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.
POV-ZERO-OSHIP-FL Alpha 1 AP510 PO10.1
Element: All Flag The vendor default overshipment
quantity tolerance flag.
N = No
Y = Yes
POV-ZERO-USHIP-FL Alpha 1 AP510 PO10.1
Element: All Flag 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
POV-CANCEL-ALL-BO Alpha 1 AP510 PO10.1
Element: Cancel All Bo 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
POV-RMA-REQUIRED Alpha 1 AP510 PO10.1
Element: All Flag 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
POV-RMA-DOC-REQ Alpha 1 AP510 PO10.1
Element: All Flag Set to Yes to indicate that Return
Material Authorization documents
provided by the vendor must be sent with
any goods returned to this vendor. RMA
documents can also be printed internally
and sent to the vendor, but this flag
does not pertain to those documents.
N = No
Y = Yes
POV-OVEND-SHIP-VIA Alpha 12 (Lower Case) AP510 PO10.1
Element: Ship Via DescrThis is the shipping method to be used
for the shipment of return goods to the
vendor. This may be defaulted from the
vendor.
POV-REQ-LOC-LEVEL Alpha 1 AP510 PO10.1
Element: Req Loc Level 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
POV-REQ-CONT-LEVEL Alpha 1
Element: Req Cont LevelThis 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
POV-ISSUE-METH Alpha 1 AP510 PO10.1
Element: Issue Meth 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
POV-REV-ISSUE-METH Alpha 1 AP510 PO10.1
Element: Rev Issue MethSpecifies 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
POV-REV-EDI-NUMBER Alpha 15 AP510 PO10.1
Element: EDI Number Enter the number used to identify the
trading partner in the EDI translation
software for purchase order revisions.
If you do not specify a value, the
vendor's EDI Number will be used on
purchase order revisions.
POV-REV-EDI-TRANS Alpha 1 AP510 PO10.1
Element: Rev Edi Trans 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
POV-REVISIONS-INCL Alpha 1 AP510 PO10.1
Element: Revisions InclSpecifies 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
POV-VENDOR-CONTCT Alpha 30 AP510 PO10.1
Element: Vendor Name The vendor contact name.
POV-PHONE-PREFIX Alpha 6 AP510 PO10.1
Telephone Country The telephone number country code.
Code
POV-PHONE-NUM Alpha 15 AP510 PO10.1
Element: Telephone NumbThis is the main telephone number.
POV-PHONE-EXT Alpha 5 AP510 PO10.1
Element: Telephone ExteThis field contains the telephone
extension number.
POV-PO-CODE Alpha 4 AP510 PO10.1
Element: Po Code This is the purchase order code that
will default from the vendor to the
purchase order.
POV-MIN-ORD-WEIGHT Signed 9.3 AP510 PO10.1
Element: Min Ord Weight
POV-UPD-PO-COST Numeric 1 AP510 PO10.1
Element: Upd Po Cost 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
POV-LOADING-PORT Alpha 5 AP510 PO10.1
Element: Loading Port The port where the goods are loaded, if
required. The port code must be defined
in IN04.1 (Port Maintenance)
POV-UNLOADING-PORT Alpha 5 AP510 PO10.1
Element: Unloading PortThe prot where the goods are unloaded if
required. Must be defined in IN04.1
(Port Maintenance)
POV-PUNCHOUT-CHG-F Numeric 1 PO10.1
Element: Punchout Chg F0 = Changes allowed
1 = Changes not allowed
POV-EMAIL-ADDRESS Alpha 60 (Lower Case) PO10.1
Element: Email Address e-mail address.
POV-REORDER-SUN-FL Numeric 1
Element: Reorder Mon Fl
POV-REORDER-MON-FL Numeric 1
Element: Reorder Mon Fl
POV-REORDER-TUE-FL Numeric 1
Element: Reorder Mon Fl
POV-REORDER-WED-FL Numeric 1
Element: Reorder Mon Fl
POV-REORDER-THU-FL Numeric 1
Element: Reorder Mon Fl
POV-REORDER-FRI-FL Numeric 1
Element: Reorder Mon Fl
POV-REORDER-SAT-FL Numeric 1
Element: Reorder Mon Fl
POV-LOC-ID-PRT Alpha 1
Element: Print Flag G = Print GLN on PO Line
H = Print HIN on PO Line
" " = No print
POV-LOC-INDICATOR Derived
Element: Loc Indicator
POVENDOR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
POVSET1 VENDOR-GROUP AM115 AM117
VENDOR AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP03.3 AP10.1
AP125 AP126
AP131 AP210
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 AP510
API3.1 API4.1
BL120 BL122
...
POVENDOR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
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 RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Povendloc POVENDLOC
POV-VENDOR-GROUP -> PVL-VENDOR-GROUP
POV-VENDOR -> PVL-VENDOR
PVL-PURCH-FR-LOC
|
