|
|
APCVENMAST FILE
Vendor Conversion
The Vendor Conversion file is used by the Vendor Conversion program to
convert vendor and alternate vendor location records to the Lawson Accounts
Payable system. When you run AP510 (Vendor Conversion), the system reads
records in this file for conversion into the Accounts Payable Vendor and
Vendor Location files. When Vendor Conversion file records are successfully
converted, they are purged from this file. You can use AP51.1 (Vendor
Conversion) and AP51.2 (Vendor Location Conversion) to add records to this
file or maintain records previously loaded into this file for conversion to
the Lawson Accounts Payable system.
UPDATED BY
AP51.1 AP51.2 AP51.4 AP51.5 AP510 AP58.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CVV-VENDOR-GROUP Alpha 4 AP51.1 AP51.2
Element: Vendor Group Required. The vendor group. Must be a AP51.4 AP51.5
valid record in the Vendor Group file. AP58.1
CVV-VENDOR Alpha 9 (Right Justified) AP51.1 AP51.2
Element: Vendor The vendor number. Required if defining AP51.4 AP51.5
a vendor or alternate vendor location AP510 AP58.1
record and not using automatic vendor
numbering.
If defining an alternate vendor location
record, must be a valid record in the
Vendor Conversion or Vendor file.
CVV-OLD-VENDOR Alpha 9 (Right Justified) AP51.1 AP51.2
Element: Vendor The vendor's number before conversion AP51.4 AP51.5
to Accounts Payable. Required if using
automatic vendor numbering.
CVV-LOCATION-CODE Alpha 4 AP51.1 AP51.2
Element: Location Code Required if defining an alternate AP51.4 AP51.5
vendor location record. A user-defined AP58.1
code representing an alternate
remittance or purchasing location for
the vendor. If present, the Vendor must
be a valid record in the Vendor
Conversion or Vendor file.
CVV-LOC-TYPE Alpha 1 AP51.2
Element: Loc Type If defining an alternate vendor
location record, this field indicates
the type of alternate location for the
vendor. Valid values are:
P = Purchase-From. Represents an
alternate purchasing location for the
vendor.
R = Remit-To. Represents an alternate
remittance location for the vendor.
B = Both. Can be used as both an
alternate purchasing and remittance
location for the vendor.
Blank = An alternate vendor location
record is not being defined.
CVV-VEN-CLASS Alpha 3 AP51.1
Element: Ven Class Required. The vendor class the vendor
is assigned to. Represents a group of
vendors within a vendor group that share
common characteristics. Must be a valid
record in the Vendor Class file.
CVV-VENDOR-VNAME Alpha 30 (Lower Case) AP51.1 AP51.2
Element: Name Required. The vendor name or
description. This field accepts both
upper and lower case entries.
CVV-VENDOR-SNAME Alpha 30 AP51.1
Element: Search Name The search name for the vendor. If left
blank, the Vendor Name defaults.
CVV-VENDOR-CONTCT Alpha 30 AP51.1 AP51.2
Element: Contact The requester can enter the recommended
vendor's name for the requested items.
CVV-ADDR1 Alpha 30 (Lower Case) AP51.1 AP51.2
Element: Address 1 Required. The first line of address
information for the vendor. This field
accepts both upper and lower case
entries.
CVV-ADDR2 Alpha 30 (Lower Case) AP51.1 AP51.2
Element: Address 2 The second line of address information
for the vendor. This field accepts both
upper and lower case entries.
CVV-ADDR3 Alpha 30 (Lower Case) AP51.1 AP51.2
Element: Address 3 The third line of address information
for the vendor. This field accepts both
upper and lower case entries.
CVV-ADDR4 Alpha 30 (Lower Case) AP51.1 AP51.2
Element: Address 4 The fourth line of address information
for the vendor. This field accepts both
upper and lower case entries.
CVV-CITY-ADDR5 Alpha 18 (Lower Case) AP51.1 AP51.2
Element: City or AddresThe city or fifth line of address
information for the vendor. This field
accepts both upper and lower case
entries.
CVV-STATE-PROV Alpha 2 AP51.1 AP51.2
Element: State or ProviThe state or province for the vendor
address.
CVV-POSTAL-CODE Alpha 10 (Lower Case) AP51.1 AP51.2
Element: Postal Code The postal code for the vendor address.
CVV-COUNTY Alpha 25 (Lower Case) AP51.1 AP51.2
Element: County The county for the company address.
CVV-COUNTRY Alpha 30 (Lower Case) AP51.1 AP51.2
Element: Country The country for the vendor address. Can
also be used for additional information
such as attention name. This field
accepts both upper and lower case
entries.
CVV-REGION Alpha 2 AP51.1 AP51.2
Element: Region The region code, if applicable for the
country. Used by Intrastat. Must be
defined in IN02.1 (Region Maintenance)
CVV-COUNTRY-CODE Alpha 2 AP51.1 AP51.2
Element: Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
CVV-NORM-REMIT Alpha 1 AP51.2
Normal Remittance If defining an alternate vendor
Location location and the Location Type field = R
or B, this field indicates whether the
location represents the normal
remittance location for the vendor. A
vendor can have only one normal
remittance location. Valid values are:
N = No. Default value.
Y = Yes.
CVV-NORM-PURCH Alpha 1 AP51.2
Normal Purchasing If defining an alternate vendor
Location location and the Location Type field = P
or B, this field indicates whether the
location represents the normal
purchasing location for the vendor. A
vendor can have only one normal
purchasing location. Valid values are:
N = No. Default value.
Y = Yes.
CVV-REMIT-TO-CODE Alpha 4 AP51.2
Element: Remit To Code The normal remittance location for an
alternate vendor location, if defined.
If present, the address defined for the
location overrides the vendor address on
vendor payments when invoices are added.
Must be a valid record in the Vendor
Location file and the Vendor Conversion
file.
CVV-PURCH-FR-LOC Alpha 4
Element: Purch Fr Loc THIS FIELD IS NOT CURRENTLY USED.
CVV-PAY-VENDOR Alpha 9 (Right Justified) AP51.1
Element: Vendor The vendor number of the vendor to be
paid for invoices entered for this
vendor. If left blank, the Vendor
defaults.
If entered, make sure the value is a
valid record in the Vendor Conversion or
Vendor file.
CVV-VENDOR-STATUS Alpha 1 AP51.1 AP51.2
Element: Active Flag The vendor status. You cannot enter
invoices for a vendor with an Inactive
status. Valid values are:
A = Active.
I = Inactive.
CVV-VEN-PRIORITY Numeric 2 AP51.1
Element: Ven Priority The payment priority of the vendor.
Valid values are 1 (highest priority)
through 99 (lowest priority). If left
blank, the payment priority defined for
vendor class will be used.
CVV-PHONE-PREFIX Alpha 6 AP51.1 AP51.2
Element: Phone Prefix The telephone number prefix for the
vendor.
CVV-PHONE-NUM Alpha 15 AP51.1 AP51.2
Element: Phone The telephone number for the vendor.
CVV-PHONE-EXT Alpha 5 AP51.1 AP51.2
Element: Phone Ext The telephone extension number for the
vendor.
CVV-FAX-PREFIX Alpha 6 AP51.1 AP51.2
Element: Phone Prefix The fax telephone number prefix for the
vendor.
CVV-FAX-NUM Alpha 15 AP51.1 AP51.2
Element: Phone The fax telephone number for the vendor.
CVV-FAX-EXT Alpha 5 AP51.1 AP51.2
Element: Phone Ext The fax telephone number extension for
the vendor.
CVV-TELEX-NUM Alpha 15 AP51.1 AP51.2
Element: Phone The telex number for the vendor.
CVV-TERM-CODE Alpha 5 AP51.1 AP51.2
Element: Term Code The payment terms code assigned to the
vendor. Used to automatically calculate
due date and discount information for
the vendor's invoices during entry. Must
be a valid record in the Terms Code
file.
CVV-INV-CURRENCY Alpha 5 AP51.1 AP51.2
Element: To Base Curr The currency used to add invoices for
the vendor. The currency code defaults
on the vendor's invoices during invoice
entry. Must be a valid record in the
Currency Code file. If left blank, the
vendor uses the invoice currency
assigned to the vendor class, if
assigned, or the company base currency.
If the Balance Currency field contains a
non-base currency, the Invoice Currency
must be either the same non-base
currency or the company base currency.
If the Balance Currency field contains
the company base currency, the Invoice
Currency can be a non-base currency.
CVV-BAL-CURRENCY Alpha 5 AP51.1
Element: To Base Curr The currency used to store vendor
balance information. Must be a valid
record in the Currency Code file. If
left blank, the company base currency
will be used.
CVV-BANK-CURRENCY Alpha 5 AP58.1
Element: Currency Code This field contains the bank currency
code.
CVV-CURR-RECALC Alpha 1 AP51.1 AP51.2
Currency If the Invoice Currency is different
Recalculation from the company base currency, this
field indicates whether the system
should recalculate the invoice currency
when the invoice is paid to account for
exchange rate fluctuations. If this
field = Yes, the system compares the
exchange rate in effect when the invoice
was entered to the exchange rate in
effect when the invoice is scheduled for
payment by Cash Requirements (AP150). If
a difference exists, Payment Closing
(AP170) creates a currency gain or loss
transaction. Valid values are:
Y = Yes. Default value.
N = No.
CVV-SEP-CHK-FLAG Alpha 1 AP51.1 AP51.2
Element: Separate PaymeIndicates whether to create a separate
payment for each invoice entered for the
vendor. Valid values are:
N = No.
Y = Yes.
CVV-TAX-ID Alpha 20 AP51.1
Element: Tax ID If tracking reportable income for the
vendor, this field contains the vendor's
tax identification number.
CVV-TAX-CODE Alpha 10 AP51.1 AP51.2
Element: Tax Code The tax code assigned to the vendor.
Used to automatically calculate invoice
tax information. Must be a valid record
in the Tax Code file. If left blank, the
tax code assigned to the vendor class
defaults.
CVV-HLD-CODE Alpha 4 AP51.1
Element: Hold Code The hold code assigned to the vendor.
If present, invoices for the vendor will
not be scheduled for payment. Must be a
valid vendor type hold code record in
the Hold Code file.
CVV-DIST-CODE Alpha 9 AP51.1
Element: Dist Code The distribution code assigned to the
vendor. Used to automatically create
expense distribution lines for this
vendor's invoices. Must be a valid
record in the Distribution Code file. If
left blank, the distribution code
assigned to the vendor class, if
assigned, defaults.
CVV-ACCR-CODE Alpha 4 AP51.1
Element: Invoice AccruaThe invoice accrual code assigned to
the vendor. Used to default general
ledger accrual account to the vendor's
invoices during invoice entry. Must be a
valid record in the Invoice Accrual Code
file.
CVV-BANK-INST-CODE Alpha 3 AP51.1 AP51.2
Element: Payment Code The payment code assigned to the
vendor. Represents a type of cash
payment, such as a check or payment
tape, or a bill of exchange payment.
Must be a valid cash payment or bill of
exchange payment type transaction code
record in the Bank Transaction Code
file.
CVV-CASH-CODE Alpha 4 AP51.1 AP51.2
Element: Cash Code The cash code assigned to the vendor.
Represents a bank account. Must be a
valid record in the Cash Code file. If
left blank, the cash code assigned to
the vendor class, if assigned, defaults,
or the vendor uses the cash code
assigned to the company.
CVV-BANK-ENTITY Alpha 15 AP58.1
Element: Bank The bank identification used to deposit
electronic payments for the vendor. This
field is required for ACH or BACS
payment types.
CVV-VBANK-ACCT-NO Alpha 35 AP58.1
Element: Bank Acct Nbr The bank account number used to deposit
electronic payments for the vendor.
Required if a value is present in the
Bank field.
CVV-VBANK-IDENT Alpha 1 AP58.1
Element: Vbank Ident This field indicates if the account
number is an IBAN number that requires
an account validation check.
Y = Yes
N = No
CVV-RIBKEY Numeric 2
Element: Ribkey
CVV-VBANK-ACCT-TP Alpha 1 AP58.1
Element: Vbank Acct Tp Indicates the type of bank account
where electronic payments for the vendor
will be deposited. Required if a value
is present in the Bank field. Valid
values are:
C = Current/Checking Account.
S = Savings Account.
Blank = Electronic payment type was not
selected.
CVV-INCOME-CODE Alpha 4 AP51.1
Element: Income Code The income code assigned to the vendor.
Represents a type of reportable income
for the vendor. Must be a valid record
in the Income Code file.
CVV-INCOME-WH-FLG Alpha 1 AP51.1
Income Withholding Indicates whether invoices for the
Flag vendor are subject to reportable income
withholding. Valid values are:
N = No. Default value.
Y = Yes.
CVV-EDI-NBR Alpha 15 AP58.1
Element: Edi Nbr The vendor's electronic data
interchange (EDI) number. Used for
reference. Can also be used to look up a
vendor if the vendor receives electronic
invoices.
CVV-ACH-PRENOT Alpha 1 AP58.1
Element: Ach Prenot Used in conjunction with ACH payments
made for the vendor. Indicates the
status of the electronic payment between
the vendor and the processing bank.
Valid values are:
N = Not Prenotified. Default value if
values are present in the Bank and
Vendor Bank Account Number fields. AP160
(Payment Tape Creation) automatically
changes the status from Not Prenotified
to Prenotified to indicate that the
processing bank has been notified but
has not yet accepted the electronic
payment tape.
P = Prenotified. Indicates that the
processing bank has been notified but
has not yet accepted the electronic
payment tape.
A = Accepted. Change the status to
Accepted once the processing bank
accepts the electronic payment tape.
Blank = ACH payment type not selected.
CVV-MAX-INV-AMT Signed 18.2 AP51.1
Maximum Invoice The maximum single invoice amount that
Amount can be entered for the vendor.
CVV-ORIGIN-DATE Numeric 8 (yyyymmdd) AP51.1
Element: Date The origin date for the vendor.
Provides additional information such as
the date the vendor relationship began.
If left blank, the system date defaults.
CVV-USER-NAME-01 Alpha 20 AP51.1 AP51.2
Element: Vendor User FiThe value of the information being
tracked for the vendor in the first
vendor group user field.
CVV-USER-NAME-02 Alpha 20 AP51.1 AP51.2
Element: Vendor User FiThe value of the information being
tracked for the vendor in the second
vendor group user field.
CVV-USER-NAME-03 Alpha 20 AP51.1 AP51.2
Element: Vendor User FiThe value of the information being
tracked for the vendor in the third
vendor group user field.
CVV-USER-NAME-04 Alpha 20 AP51.1 AP51.2
Element: Vendor User FiThe value of the information being
tracked for the vendor in the fourth
vendor group user field.
CVV-USER-NAME-05 Alpha 20 AP51.1 AP51.2
Element: Vendor User FiThe value of the information being
tracked for the vendor in the fifth
vendor group user field.
CVV-USER-NAME-06 Alpha 20 AP51.1 AP51.2
Element: Vendor User FiThe value of the information being
tracked for the vendor in the sixth
vendor group user field.
CVV-CUST-GROUP Alpha 5 AP51.1
Element: Cust Group Customer group. Used to identify a
group of customer associated with one or
more companies.
CVV-CUSTOMER Alpha 9 (Right Justified) AP51.1
Element: Customer This field contains the number that
represents a customer.
CVV-LEGAL-NAME Alpha 80 (Lower Case) AP51.1
Element: Legal Name The legal name for the vendor. Used for
reporting reportable vendor income. If
left blank, the vendor name defaults.
CVV-ACTIVITY Alpha 15 AP51.1
Element: Activity The activity assigned to the vendor.
Activities are the processes or
procedures that produce work. If
assigned, the activity defaults on all
invoices for the vendor and associated
locations unless you override it during
invoice entry. Must be a valid record in
the Lawson Activity Management system.
CVV-ACCT-CATEGORY Alpha 5 AP51.1
Element: Acct Category The account category assigned to the
vendor. Used to group activity
transactions for budgeting and
reporting. If assigned, the account
category defaults on all invoices for
the vendor and associated locations
unless you override it during invoice
entry.
CVV-DISCOUNT-CODE Alpha 10 AP51.1 AP51.2
Element: Discount Code The discount code assigned to the
vendor. Used to default a general ledger
discount account to the vendor's
invoices during invoice entry. Must be a
valid record in the Discount Code file.
CVV-PRIME-RATE Signed 7.5 AP51.1
Anticipation The percentage used to calculate
Discount Rate anticipation discount invoices; most
often the prime rate plus one percent.
To calculate the discount for an
anticipation invoice, the system
subtracts the invoice payment date from
invoice due date to calculate the number
of days paid early, multiplies the
number of days paid early by 365 days,
multiplies the result by the
anticipation discount rate, and
multiplies the result by the payment
amount to calculate the discount amount.
CVV-INVOICE-GROUP Alpha 4 AP51.1 AP51.2
Element: Invoice Group A user-defined character expression. An
invoice group can be assigned to one
more invoices. AP150 (Cash Requirements)
has an option to select all invoices
assigned the same invoice group.
CVV-ERS-CAPABLE Alpha 1 AP58.1
Element: All Flag Indicates whether the vendor location
can process ERS.
Valid values are
Y = Yes
N = No
CVV-INVC-REF-TYPE Alpha 2 AP58.1
Element: Invc Ref Type Indicates the type of number the vendor
is providing to reference the invoice.
BM = Bill of Lading
IN = Invoice
OW = Service Order Number
PL = Packing List Number
PO = PO Number
VN = Vendor Order Number
WO = Work Order
WP = Warehouse Pick Ticket Number
ZZ = Mutually Defined
CVV-EDI-AUTO-REL Alpha 1 AP58.1
Element: EDI Auto ReleaIndicates whether the company
automatically releases EDI invoices.
Valid values are
Y = Yes
N = No
CVV-AUTH-CODE Alpha 3 AP51.1
Element: Auth Code A user-defined code representing a
person or department responsible for
approving a registered invoice. Used
only if using the invoice approval entry
option. Must be a valid record in the
Authority Code file. If assigned, the
code defaults on invoices for the vendor
unless you override the code for a
specific company or override the code
during invoice entry.
CVV-CHARGE-CODE Alpha 1 AP58.1
Element: Charge Code The charge code assigned to the vendor.
Indicates who pays service charges or
fees associated with a SWIFT payment.
Valid values are:
I = Issuer.
R = Receiver.
CVV-PMT-CAT-CODE Alpha 6 AP58.1
Payment Category The SWIFT payment category code
Code assigned to the vendor. Valid values
are:
G = Goods.
S = Service & Capital.
T = Transit Trade.
X = Transfer.
O = Other.
CVV-NORM-EXP-CODE Alpha 1 AP58.1
Normal or Express The normal or express SWIFT payment
Code option assigned to the vendor. Valid
values are:
N = Normal.
E = Express.
CVV-PMT-FORM Alpha 2 AP58.1
Element: Payment Form The SWIFT payment form assigned to the
vendor. Indicates how the payment is
made. Valid values are:
C = Check.
F = Foreign Bank.
CVV-SWIFT-ID Alpha 12 AP58.1
Element: Swift ID The SWIFT identification number
assigned to the vendor.
CVV-PROC-GRP Alpha 4 (Lower Case) AP51.1
Element: Proc Grp A process group is an identifier used
for separating vendors into different
groups to enable concurrent processing
within the cash payment cycle.
CVV-MATCH-TABLE Alpha 10 AP51.1
Element: Match Table
CVV-HANDLING-CODE Alpha 4 AP51.1
Element: Handling Code
CVV-DISC-CALC-DATE Alpha 1 AP51.1
Element: Disc Calc Date" "
R = Receipt Date
D = Receipt of Invoice Date
I = Invoice Date
S = Ship To Arrive Date
E = Earliest Receipt Date
CVV-ENCLOSURE Alpha 1 AP51.1
Element: All Flag N = No
Y = Yes
" "
CVV-CREATE-POD-FL Alpha 1 AP51.1
Element: Create Pod Fl Y = Yes
N = No
CVV-REQ-MATCH-REF Alpha 1 AP51.1
Element: Match Ref ProcY = Yes
N = No
CVV-POOL-OPTION Numeric 1 AP51.1
Element: Pool Option
CVV-HOLD-INSP-FLAG Alpha 1 AP51.1
Element: Hold Insp FlagIf set to "Y", this flag will keep
receiving lines requiring inspection
from being matched until they have been
inspected.
CVV-WRITE-OFF-AMT Signed 18.2 AP51.1 AP51.2
Element: Intl Amt
CVV-VEN-CLAIM-TYPE Alpha 2 AP51.1 AP51.2
Element: Vendor Claim Type
CVV-CLAIM-HOLD-CD Alpha 4 AP51.1 AP51.2
Element: Hold Code The hold code.
CVV-CB-HOLD-CODE Alpha 4 AP51.1
Element: Hold Code The hold code.
CVV-CB-MINIMUM-AMT Signed 18.2 AP51.1
Element: Minimum Claim Amount
CVV-REPLACE-GOODS Alpha 1 AP51.1 AP51.2
Element: Replace Goods
CVV-SHIP-OR-HOLD Alpha 1 AP51.1 AP51.2
Element: Ship or Hold Goods
CVV-ERS-HANDLING Alpha 4 AP58.1
Element: Handling Code
CVV-E-MAIL-ADDRESS Alpha 60 (Lower Case) AP51.1 AP51.2
Element: Email Address e-mail address.
CVV-URL-ADDR Alpha 60 (Lower Case) AP51.1
Element: Url Addr
CVV-VEND-ACCT Alpha 30 AP51.1 AP51.2
Element: Vend Acct The customer number the vendor has
assigned to you.
CVV-LANGUAGE-CODE Alpha 10 AP51.1
Element: Language Code Language Code (LOCALE).
CVV-TAX-USAGE-CD Alpha 10 AP51.1 AP51.2
Element: Tax Usage Cd The tax usage coe for the vendor. This
filed is required if the AP Company
inidcates that VAT reporting required.
CVV-VAT-REG-CTRY Alpha 2 AP51.1 AP51.2
Element: Vat Reg Ctry The country component of the VAT
Registration Number. This field,
together with the Registration Number
for the company on the tax transaction.
CVV-VAT-REG-NBR Alpha 12 AP51.1 AP51.2
Element: Vat Reg Nbr The number component of the VAT
Registration Number. This field together
with the Registration Country field make
up the VAT Registration Number.
CVV-VALIDATE-PO Alpha 1 AP51.1
Element: Validate Po " " = Use Default
Y = Yes
N = No
CVV-REQUIRE-PO Alpha 1 AP51.1
Element: Require Po " " = Use Default
Y = Yes
N = No
CVV-POV-BUYER-CODE Alpha 3 AP51.4 AP51.5
Element: Buyer The user defined buyer identifier for
the PO side of the vendor.
CVV-POV-OPEN-PO-LM Signed 18.2 AP51.4 AP51.5
Element: Intl Amt 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. For the PO side of vendor.
CVV-POV-OPEN-PO-AM Signed 18.2 AP51.4 AP51.5
Element: Intl Amt 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. This is for
the PO side of vendor.
CVV-POV-LEADTIME Numeric 3 AP51.4 AP51.5
Element: Leadtime Days This field contains the average
lead-time date. The average of the last
and the previous lead-time days if
system calculated. This is for the PO
side of vendor.
CVV-POV-EDI-NUMBER Alpha 15 AP51.4 AP51.5
Element: Edi Nbr EDI number for the PO side of the
Vendor.
CVV-POV-FAX-PREFIX Alpha 6 AP51.4 AP51.5
Element: Phone Prefix The fax number prefix for the PO side
of the vendor.
CVV-POV-FAX-EXT Alpha 5 AP51.4 AP51.5
Element: Phone Ext This field contains the fax number
extension for the PO side of the vendor.
CVV-POV-FAX-NUMBER Alpha 15 AP51.4 AP51.5
Element: Phone This field contains the fax number for
the PO side of the vendor.
CVV-POV-MAX-ORD-AM Signed 18.2 AP51.4 AP51.5
Element: Intl Amt The maximum open purchase order amount
for the PO side of the vendor.
CVV-POV-FREIGHT-TR Alpha 1 AP51.4 AP51.5
Element: Pov Freight TrThe Vendor's default freight term for
the PO side of the vendor.
CVV-POV-SHIP-VIA Alpha 12 (Lower Case) AP51.4 AP51.5
Element: Ship Via The Vendor's default ship via narrative
for the PO side of the vendor.
CVV-POV-FOB-CODE Alpha 3 AP51.4 AP51.5
Element: Fob Code The vendor's user-defined ship term
code that is used as a default at
purchase order entry time for the PO
side of the vendor.
CVV-POV-NORM-DEL Alpha 3 AP51.4 AP51.5
Element: Norm Del Day The Vendor's normal delivery day for
the PO side of the vendor. Informational
only.
CVV-POV-OSHIP-TPCT Percent 5.3 (Percent) AP51.4 AP51.5
Element: Pov Oship TpctQuantity overshipment tolerance
percentage for the PO side of the
vendor.
CVV-POV-USHIP-TPCT Percent 6.3 (Percent) AP51.4 AP51.5
Element: Uship Tol Pct 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 is for the PO side of the vendor.
CVV-POV-HIN-NBR Alpha 9
Element: Pov 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). This is
for the PO side of the Vendor.
CVV-POV-ZOHSHIP-FL Alpha 1 AP51.4 AP51.5
Element: Pov Zohship FlThe Vendor default overshipment
quantity tolerance flag. For the PO
side of the vendor.
CVV-POV-ZUHSHIP-FL Alpha 1 AP51.4 AP51.5
Element: Pov Zohship FlSet 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".
For the PO side of Vendor.
CVV-POV-CAN-ALL-BO Alpha 1 AP51.4
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
CVV-POV-RMA-REQ Alpha 1 AP51.4 AP51.5
Element: Pov Rma Req Enter a "Y" to indicate that the vendor
requires return material authorization
numbers when returns are made to them.
The RMA number will than 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. For the PO side of
vendor.
CVV-POV-RMA-DOC-RQ Alpha 1 AP51.4 AP51.5
Element: Pov Rma Req 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. For
the PO side of vendor.
CVV-POV-OV-SHP-VIA Alpha 12 AP51.4
Element: Ivend Ship ViaThis is the shipping method to be used
for the shipment of return goods to the
vendor. This may be defaulted from the
vendor. For the PO side of the vendor.
CVV-POV-REQ-LOCLVL Alpha 1 AP51.4 AP51.5
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 requisitions 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.
For the PO side of the vendor.
CVV-POV-REQ-CONLVL Alpha 1
Element: Req Loc Level This field is used to determine whether
requisition lines with different
contract numbers can be combined onto a
single purchase order. For the PO side
of the Vendor.
CVV-POV-ISSUE-MTHD Alpha 1 AP51.4 AP51.5
Element: Issue Meth Specifies the method that will be used
to issue the purhase order to the
vendor. For the PO side of the Vendor.
CVV-POV-REV-ISS-MT Alpha 1 AP51.4 AP51.5
Element: Rev Issue MethSpecifies the method that will be used
to issued purchase order revisions to
the vendor. For the PO side of the
vendor.
CVV-POV-REV-EDI-NB Alpha 15 AP51.4 AP51.5
Element: Edi Nbr 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 PO
Vendor's EDI Number will be used on
purchase order revision.
For the PO side of Vendor.
CVV-POV-REV-EDI-TR Alpha 1 AP51.4 AP51.5
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). For the PO side of
the vendor.
CVV-POV-REV-INCL Alpha 1 AP51.4 AP51.5
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).
For the PO side of Vendor.
CVV-POV-VEN-CONT Alpha 30 AP51.4 AP51.5
Element: Tax Contact The PO side Vendor contact name.
CVV-POV-PHONE-PREF Alpha 6 AP51.4 AP51.5
Element: Phone Prefix The telephone number country code. For
the PO side of vendor.
CVV-POV-PHONE-NUM Alpha 15 AP51.4 AP51.5
Element: Phone This is the main telephone number for
the PO side of vendor.
CVV-POV-PHONE-EXT Alpha 5 AP51.4 AP51.5
Element: Phone Ext This field contains the telephone
extension number for the PO side of the
vendor.
CVV-POV-VEND-ACCT Alpha 30
Element: Vend Acct The customer number the vendor has
assigned to you for the PO side of
Vendor.
CVV-POV-PO-CODE Alpha 4 AP51.4 AP51.5
Element: Po Code This is the purchase order code that
will default from the vendor to the
purchase order. For the PO side of the
vendor.
CVV-POV-UPD-PO-CST Numeric 1 AP51.4
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
CVV-POV-USR-FLD-01 Alpha 20 AP51.4
Element: Pov Usr Fld 01
CVV-POV-USR-FLD-02 Alpha 20 AP51.4
Element: Pov Usr Fld 02
CVV-POV-USR-FLD-03 Alpha 20 AP51.4
Element: Pov Usr Fld 03
CVV-POV-USR-FLD-04 Alpha 20 AP51.4
Element: Pov Usr Fld 04
CVV-POV-USR-FLD-05 Alpha 20 AP51.4
Element: Pov Usr Fld 05
CVV-MBL-INT-PREFIX Alpha 6 AP51.1 AP51.2
Element: Mbl Int PrefixThis field contains the country code of
the mobile phone number.
CVV-MOBILE-NUM Alpha 15 AP51.1 AP51.2
Element: Mobile Num This field contains the mobile phone
number.
CVV-MOBILE-EXT Alpha 5 AP51.1 AP51.2
Element: Mobile Ext This field contains the mobile phone
extension number.
CVV-PAY-IMM-FLAG Alpha 1 AP51.1 AP51.2
Element: All Flag
CVV-DIVERSE-CODE Alpha 5 AP51.1 AP51.2
Element: Diverse Code Diversity Code for Account Payable
Vendors
CVV-INTM-BANK-ENT Alpha 15 AP58.1
Element: Bank Entity Type the intermediary bank
identification used to deposit
electronic payments for the vendor.
CVV-INTM-BANK-ACCT Alpha 35 AP58.1
Element: Bank Acct Nbr Type the intermediary bank account
number used to deposit electronic
payments for the vendor.
CVV-INTM-BANK-IDNT Alpha 1 AP58.1
Element: Intm Bank IdntThis field indicate if the account
number is an IBANK number that requires
an account validation check.
Y = Yes
N = No or Blank
CVV-INTM-BANK-CURR Alpha 5 AP58.1
Element: Currency Code This field contains the intermediary
bank currency code.
CVV-INTM-PRENOT Alpha 1 AP58.1
Element: All Flag If you create Intermediary ACH payments
for the vendor, select the
prenotification status. Indicates the
status of the electronic payment between
the vendor and the processing bank.
A = Accepted
N = Not Prenotified
P = Prenotified
CVV-INTM-SWIFT-ID Alpha 12 AP58.1
Element: Patient Id Use SWIFT Payment Options (AP10.8) to
define SWIFT payment options if you
create Intermediary SWIFT payments for
the vendor.
CVV-INTM-PMT-CAT Alpha 6 AP58.1
Element: Pmt Cat Code Select the Intermediary SWIFT payment
category.
CVV-INTM-NORM-EXP Alpha 1 AP58.1
Element: Charge Code Indicates whether the SWIFT payment is a
normal or express payment.
N = Normal
E = Express
" " = Not defined for the vendor
CVV-INTM-PMT-FORM Alpha 2 AP58.1
Element: Pmt Form Indicates how the Intermediary SWIFT
payment is made.
CVV-INTM-CHRG-CD Alpha 1 AP58.1
Element: Charge Code Indicates who pays service charges or
fees associated with a Intermediary
SWIFT payment.
CVV-INTM-RIBKEY Numeric 2
Element: Ribkey
CVV-INTM-CRS-IDENT Alpha 1 AP58.1
Element: Intm Crs IdentS = SWIFT
R = Routing Number
CVV-FLOAT-DAYS Numeric 3 AP51.1
Element: Float Days THis is a number of days to add to best
terms calculation if the vendor will
allow a specific number of days for
payment to reach them and still receive
the discount.
CVV-VN-BLD-SOC-REF Alpha 18
Element: Build Soc Ref This field holds an individual account
number reference for the Building
Society
CVV-VN-BLD-ACCT-NM Alpha 18
Element: Account Name
CVV-IN-BLD-SOC-REF Alpha 18
Element: Build Soc Ref This field holds an individual account
number reference for the Building
Society
CVV-IN-BLD-ACCT-NM Alpha 18
Element: Account Name
CVV-MTCH-PREPAY-FL Alpha 1
Element: Mtch Prepay FlFlag notes that the invoice will be
prepaid. This is for match invoices.
CVV-MTCH-PREPAY-MT Numeric 1
Element: Mtch Prepay MtFlag denotes the method of match
prepayment.
0 = No
1 = Prepay from Invoice
2 = Eligible for Prepayment
CVV-BUILD-SOC-REF Alpha 18 AP58.1
Element: Build Soc Ref This field holds an individual account
number reference for the Building
Society
CVV-BUILD-ACCT-NM Alpha 18 AP58.1
Element: Account Name
CVV-MIN-ORD-WEIGHT Signed 9.3 AP51.4
Element: Min Ord Weight
CVV-UNLOADING-PORT Alpha 5 AP51.4
Element: Unloading PortThe prot where the goods are unloaded
if required. Must be defined in IN04.1
(Port Maintenance)
CVV-LOADING-PORT Alpha 5 AP51.4
Element: Loading Port The port where the goods are loaded, if
required. The port code must be defined
in IN04.1 (Port Maintenance)
CVV-WORKFLOW-GROUP Alpha 20 AP51.1
Element: Workflow Group
CVV-RULE-GROUP Alpha 10 AP51.1
Element: Rule Group
CVV-CROSS-IDENT Alpha 1 AP58.1
Element: Cross Ident This field is used to distinguish
between SWIFT ID numbers and Routing
numbers.
S = SWIFT
R = Routing Number
CVV-GIRO-NUMBER Alpha 15 AP58.1
Element: Giro Number This field is the Bankgiro or Postgiro
account number
CVV-CR-CARD-NUMBER Alpha 16 AP58.1
Element: Cr Card NumberThis field contains the credit card
number.
CVV-BANK-INSTRUCT1 Alpha 35 AP58.1
Element: Bank Instruct1This field contains bank instructions.
CVV-BANK-INSTRUCT2 Alpha 35 AP58.1
Element: Bank Instruct2This field contains bank instructions.
CVV-BANK-INSTRUCT3 Alpha 35 AP58.1
Element: Bank Instruct3This field contains bank instructions.
CVV-BANK-INSTRUCT4 Alpha 35 AP58.1
Element: Bank Instruct4This field contains bank instructions.
CVV-LOC-ID-PRT Numeric 1 AP51.4 AP51.5
Element: Loc Id Prt
CVV-PUNCHOUT-CHG-F Numeric 1 AP51.4 AP51.5
Element: Punchout Chg F
CVV-EMAIL-ADDRESS Alpha 60 (Lower Case) AP51.4 AP51.5
Element: Email Address e-mail address.
CVV-REORDER-SUN-FL Numeric 1 AP51.4 AP51.5
Element: Reorder Mon Fl
CVV-REORDER-MON-FL Numeric 1 AP51.4 AP51.5
Element: Reorder Mon Fl
CVV-REORDER-TUE-FL Numeric 1 AP51.4 AP51.5
Element: Reorder Mon Fl
CVV-REORDER-WED-FL Numeric 1 AP51.4 AP51.5
Element: Reorder Mon Fl
CVV-REORDER-THU-FL Numeric 1 AP51.4 AP51.5
Element: Reorder Mon Fl
CVV-REORDER-FRI-FL Numeric 1 AP51.4 AP51.5
Element: Reorder Mon Fl
CVV-REORDER-SAT-FL Numeric 1 AP51.4 AP51.5
Element: Reorder Mon Fl
CVV-DIVERSE-CODE5 Alpha 5
Element: Diverse Code Diversity Code for Account Payable
Vendors
CVV-P-CARD-FLAG Numeric 1 AP51.1
Element: Flag Num 0 = No
1 = Yes
CVV-PCARD-NBR Alpha 16 AP51.1
Element: Pcard Nbr
CVV-VAL-DIV-DATE Alpha 1 AP51.1
Element: All Flag Determines on invoice entry if the
invoice date is within the certification
dates for the diversity code setup for
the vendor on AP14.4
APCVENMAST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CVVSET1 VENDOR-GROUP AP51.1 AP51.2
VENDOR AP51.4 AP51.5
OLD-VENDOR AP51.8 AP510
LOCATION-CODE AP58.1
APCVENMAST FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcontacts APCCONTACT Delete Cascades
CVV-VENDOR-GROUP -> CVH-VENDOR-GROUP
CVV-VENDOR -> CVH-VENDOR
CVV-LOCATION-CODE -> CVH-LOCATION-CODE
CVH-RESP-CODE
CVH-CONTACT-LVL
Apcvenbal APCVENBAL
CVV-VENDOR-GROUP -> CVB-VENDOR-GROUP
CVV-VENDOR -> CVB-VENDOR
CVV-OLD-VENDOR -> CVB-OLD-VENDOR
CVV-LOCATION-CODE -> CVB-LOCATION-CODE
CVB-COMPANY
|
