|
|
POVENDOR FILE
PO Vendor Master
This file contains purchase order specific information for purchase order
vendor defaulting.
REFERENCED BY
AP10.1 AP10.2 AP300 DR100 IC141 IC142
IC83.1 MA00.1 MA140 MA40.1 MA41.1 MA41.2
MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 PO120
PO121 PO123 PO14.1 PO150 PO210 PO220
PO223 PO25.1 PO26.1 PO34.1 PO820 RQ10.1
RQ10.3 RQ11.1 RQ125 RQ35.1 RQ500
UPDATED BY
AP125 AP126 AP225 AP226 AP25.1 AP25.2
AP26.1 BL92.1 IN20.1 MA530 MA540 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
OE113 OE114 OE129 OE14.4 OE15.1 OE15.2
OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810
OE920 PO10.1 PO100 PO20.1 PO21.1 PO21.2
PO21.6 PO22.2 PO22.3 PO30.1 PO31.1 PO33.1
PO35.1 PO530 PO821 RQ20.4 WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
POV-COMPANY Numeric 4 PO10.1
Company The company number.
POV-VENDOR Alpha 9 PO10.1
Vendor ID The vendor's identification code.
POV-BUYER-CODE Alpha 3 PO10.1
Buyer Code The user defined buyer identifier.
POV-OPEN-PO-LIMIT Signed 15.2 PO10.1 PO22.1
Open PO Limit Vendor open purchase order amount limit.
POV-OPEN-PO-AMT Signed 15.2 AP25.1 AP25.2
Open PO Amount Vendor to-date open purchase order BL92.1 IN20.1
amount. 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 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO10.1 PO100
PO20.1 PO21.1
PO21.6 PO22.1
PO22.2 PO22.3
PO30.1 PO33.1
RQ20.1 RQ20.4
WH20.2 WH20.7
POV-LEADTIME-DAYS Numeric 3 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-PO-FLAG Alpha 1 PO10.1
Fax/EDI Flag If the vendor's EDI flag is set to "E",
then the EDI entry is required. The
purchase order created for this vendor
is also coded for EDI transmission.
If the flag is set to "F", a fax number
is required for this vendor. When a
purchase order is created for this
vendor it is flagged for fax
transmission.
N = No
E = EDI
F = Fax
POV-EDI-NUMBER Alpha 15 PO10.1 PO220
EDI Number EDI number.
POV-FAX-PREFIX Alpha 6 PO10.1
Fax Country Code The fax number prefix.
POV-FAX-EXT Alpha 5 PO10.1
Fax Extension This field contains the fax number
extension.
POV-FAX-NUMBER Alpha 15 PO10.1
Fax Number This field contains the fax number.
POV-MAX-ORDER-AMT Signed 15.2 PO10.1
Maximum Order Amount The maximum open purchase order amount
for this vendor.
POV-FREIGHT-TERMS Alpha 1 PO10.1
Freight Terms The vendor's default freight term.
POV-SHIP-VIA Alpha 12 (Lower Case) PO10.1
Ship Via Description The vendor's default ship via narrative.
POV-FOB-CODE Alpha 2 PO10.1
Shipping Term Code The vendor's user-defined ship term
code is used as a default at purchase
order entry time.
POV-NORM-DEL-DAY Alpha 3 PO10.1
Normal Delivery Day The 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) PO10.1 PO30.1
Overshipment Quantity overshipment tolerance PO30.2
Tolerance Percent percentage.
POV-USHIP-TOL-PCT Percent 6.3 (Percent) PO10.1 PO30.1
Cancel Backorder This is the quantity undership PO30.2
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-COST-TOL-PCT Percent 5.3 (Percent) PO10.1
Unit Cost Tolerance Enter a percent if you want to override
Percent the cost tolerance percent defined at
company level for this vendor.
See the cost tolerance percent field in
MA00.4 (GL and Invoicing Setup) for a
description of how this field is used in
determining if an invoice is within
tolerance at that level, or if a line
approval is outside of tolerance and a
buyer message must be created.
POV-HIN-NBR Alpha 9
Hin Nbr The Health Industry Number is a unique
number assigned to any company or
facility doing business in the health
industry. This number is assigned by the
Health Industry Business Communications
Council (HIBCC).
POV-ZERO-OSHIP-FL Alpha 1 PO10.1 PO30.1
Zero Overshipment The vendor default overshipment PO30.2
Flag quantity tolerance flag.
N = No
Y = Yes
POV-ZERO-USHIP-FL Alpha 1 PO10.1 PO30.1
Zero Undershipment Set this flag to "Y" to indicate that PO30.2
Flag 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-ZERO-COST-FL Alpha 1 PO10.1
Zero Cost Flag Zero unit cost line tolerance flag.
N = No
Y = Yes
POV-RMA-REQUIRED Alpha 1 PO10.1
RMA Required Flag Enter a Y (Yes) to indicate that the
vendor requires return material
authorization (RMA) 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 PO10.1
RMA Document Set to Yes to indicate that Return
Required Flag Material Authorization (RMA) 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 PO10.1
Return To Vendor This is the shipping method to be used
Ship Via for the shipment of return goods to the
vendor. This may be defaulted from the
vendor.
POV-REQ-LOC-LEVEL Alpha 1 PO10.1
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 PO10.1
Req Cont Level This field is used to determine whether
requisition lines with different
contract numbers 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
N = Cannot mix contracts on PO
POVENDOR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
POVSET1 COMPANY AP10.1 AP10.2
VENDOR AP125 AP126
AP225 AP226
AP25.1 AP25.2
AP26.1 AP300
BL92.1 DR100
IC141 IC142
IC83.1 IN20.1
MA00.1 MA140
MA40.1 MA41.1
MA41.2 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA530 MA540
OE10.1 OE10.2
...
POVENDOR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
POV-COMPANY -> CPY-COMPANY
Buyer BUYER Required
When POV-BUYER-CODE != Spaces
POV-COMPANY -> BUY-COMPANY
POV-BUYER-CODE -> BUY-BUYER-CODE
Fob Code FOBCODE Required
When POV-FOB-CODE != Spaces
POV-COMPANY -> FOB-COMPANY
POV-FOB-CODE -> FOB-FOB-CODE
Pocompany POCOMPANY Required
POV-COMPANY -> PCY-COMPANY
Pofrtterm POFRTTERM Required
When POV-FREIGHT-TERMS != Spaces
POV-COMPANY -> POF-COMPANY
POV-FREIGHT-TERMS -> POF-FREIGHT-TERMS
Vendor APVENMAST Required
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
POV-VENDOR -> VEN-VENDOR
POVENDOR FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Povendloc POVENDLOC Delete Restricted
POV-COMPANY -> PVL-COMPANY
POV-VENDOR -> PVL-VENDOR
PVL-PURCH-FR-LOC
Purchorder PURCHORDER Delete Restricted
POV-COMPANY -> PCR-COMPANY
POV-VENDOR -> PCR-VENDOR
PCR-PURCH-FR-LOC
PCR-PO-NUMBER
PCR-PO-RELEASE
PCR-PO-DATE
|