APCVENMAST

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
Element: Vendor Group
Alpha 4
Required. The vendor group. Must be a valid record in the Vendor Group file.
AP51.1 AP51.2
AP51.4 AP51.5
AP58.1
CVV-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The vendor number. Required if defining a vendor or alternate vendor location 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.
AP51.1 AP51.2
AP51.4 AP51.5
AP510 AP58.1
CVV-OLD-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The vendor's number before conversion to Accounts Payable. Required if using automatic vendor numbering.
AP51.1 AP51.2
AP51.4 AP51.5
CVV-LOCATION-CODE
Element: Location Code
Alpha 4
Required if defining an alternate vendor location record. A user-defined 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.
AP51.1 AP51.2
AP51.4 AP51.5
AP58.1
CVV-LOC-TYPE
Element: Loc Type
Alpha 1
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.
AP51.2
CVV-VEN-CLASS
Element: Ven Class
Alpha 3
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.
AP51.1
CVV-VENDOR-VNAME
Element: Name
Alpha 30 (Lower Case)
Required. The vendor name or description. This field accepts both upper and lower case entries.
AP51.1 AP51.2
CVV-VENDOR-SNAME
Element: Search Name
Alpha 30
The search name for the vendor. If left blank, the Vendor Name defaults.
AP51.1
CVV-VENDOR-CONTCT
Element: Contact
Alpha 30
The requester can enter the recommended vendor's name for the requested items.
AP51.1 AP51.2
CVV-ADDR1
Element: Address 1
Alpha 30 (Lower Case)
Required. The first line of address information for the vendor. This field accepts both upper and lower case entries.
AP51.1 AP51.2
CVV-ADDR2
Element: Address 2
Alpha 30 (Lower Case)
The second line of address information for the vendor. This field accepts both upper and lower case entries.
AP51.1 AP51.2
CVV-ADDR3
Element: Address 3
Alpha 30 (Lower Case)
The third line of address information for the vendor. This field accepts both upper and lower case entries.
AP51.1 AP51.2
CVV-ADDR4
Element: Address 4
Alpha 30 (Lower Case)
The fourth line of address information for the vendor. This field accepts both upper and lower case entries.
AP51.1 AP51.2
CVV-CITY-ADDR5
Element: City or Address 5
Alpha 18 (Lower Case)
The city or fifth line of address information for the vendor. This field accepts both upper and lower case entries.
AP51.1 AP51.2
CVV-STATE-PROV
Element: State or Province
Alpha 2
The state or province for the vendor address.
AP51.1 AP51.2
CVV-POSTAL-CODE
Element: Postal Code
Alpha 10 (Lower Case)
The postal code for the vendor address.
AP51.1 AP51.2
CVV-COUNTY
Element: County
Alpha 25 (Lower Case)
The county for the company address.
AP51.1 AP51.2
CVV-COUNTRY
Element: Country
Alpha 30 (Lower Case)
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.
AP51.1 AP51.2
CVV-REGION
Element: Region
Alpha 2
The region code, if applicable for the country. Used by Intrastat. Must be defined in IN02.1 (Region Maintenance)
AP51.1 AP51.2
CVV-COUNTRY-CODE
Element: Country Code
Alpha 2
The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
AP51.1 AP51.2
CVV-NORM-REMIT
Normal Remittance
Location
Alpha 1
If defining an alternate vendor 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.
AP51.2
CVV-NORM-PURCH
Normal Purchasing
Location
Alpha 1
If defining an alternate vendor 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.
AP51.2
CVV-REMIT-TO-CODE
Element: Remit To Code
Alpha 4
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.
AP51.2
CVV-PURCH-FR-LOC
Element: Purch Fr Loc
Alpha 4
THIS FIELD IS NOT CURRENTLY USED.
CVV-PAY-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
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.
AP51.1
CVV-VENDOR-STATUS
Element: Active Flag
Alpha 1
The vendor status. You cannot enter invoices for a vendor with an Inactive status. Valid values are: A = Active. I = Inactive.
AP51.1 AP51.2
CVV-VEN-PRIORITY
Element: Ven Priority
Numeric 2
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.
AP51.1
CVV-PHONE-PREFIX
Element: Phone Prefix
Alpha 6
The telephone number prefix for the vendor.
AP51.1 AP51.2
CVV-PHONE-NUM
Element: Phone
Alpha 15
The telephone number for the vendor.
AP51.1 AP51.2
CVV-PHONE-EXT
Element: Phone Ext
Alpha 5
The telephone extension number for the vendor.
AP51.1 AP51.2
CVV-FAX-PREFIX
Element: Phone Prefix
Alpha 6
The fax telephone number prefix for the vendor.
AP51.1 AP51.2
CVV-FAX-NUM
Element: Phone
Alpha 15
The fax telephone number for the vendor.
AP51.1 AP51.2
CVV-FAX-EXT
Element: Phone Ext
Alpha 5
The fax telephone number extension for the vendor.
AP51.1 AP51.2
CVV-TELEX-NUM
Element: Phone
Alpha 15
The telex number for the vendor.
AP51.1 AP51.2
CVV-TERM-CODE
Element: Term Code
Alpha 5
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.
AP51.1 AP51.2
CVV-INV-CURRENCY
Element: To Base Curr
Alpha 5
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.
AP51.1 AP51.2
CVV-BAL-CURRENCY
Element: To Base Curr
Alpha 5
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.
AP51.1
CVV-BANK-CURRENCY
Element: Currency Code
Alpha 5
This field contains the bank currency code.
AP58.1
CVV-CURR-RECALC
Currency
Recalculation
Alpha 1
If the Invoice Currency is different 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.
AP51.1 AP51.2
CVV-SEP-CHK-FLAG
Element: Separate Payment
Alpha 1
Indicates whether to create a separate payment for each invoice entered for the vendor. Valid values are: N = No. Y = Yes.
AP51.1 AP51.2
CVV-TAX-ID
Element: Tax ID
Alpha 20
If tracking reportable income for the vendor, this field contains the vendor's tax identification number.
AP51.1
CVV-TAX-CODE
Element: Tax Code
Alpha 10
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.
AP51.1 AP51.2
CVV-HLD-CODE
Element: Hold Code
Alpha 4
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.
AP51.1
CVV-DIST-CODE
Element: Dist Code
Alpha 9
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.
AP51.1
CVV-ACCR-CODE
Element: Invoice Accrual Code
Alpha 4
The 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.
AP51.1
CVV-BANK-INST-CODE
Element: Payment Code
Alpha 3
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.
AP51.1 AP51.2
CVV-CASH-CODE
Element: Cash Code
Alpha 4
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.
AP51.1 AP51.2
CVV-BANK-ENTITY
Element: Bank
Alpha 15
The bank identification used to deposit electronic payments for the vendor. This field is required for ACH or BACS payment types.
AP58.1
CVV-VBANK-ACCT-NO
Element: Bank Acct Nbr
Alpha 35
The bank account number used to deposit electronic payments for the vendor. Required if a value is present in the Bank field.
AP58.1
CVV-VBANK-IDENT
Element: Vbank Ident
Alpha 1
This field indicates if the account number is an IBAN number that requires an account validation check.
Y = Yes
N = No
AP58.1
CVV-RIBKEY
Element: Ribkey
Numeric 2
CVV-VBANK-ACCT-TP
Element: Vbank Acct Tp
Alpha 1
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.
AP58.1
CVV-INCOME-CODE
Element: Income Code
Alpha 4
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.
AP51.1
CVV-INCOME-WH-FLG
Income Withholding
Flag
Alpha 1
Indicates whether invoices for the vendor are subject to reportable income withholding. Valid values are: N = No. Default value. Y = Yes.
AP51.1
CVV-EDI-NBR
Element: Edi Nbr
Alpha 15
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.
AP58.1
CVV-ACH-PRENOT
Element: Ach Prenot
Alpha 1
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.
AP58.1
CVV-MAX-INV-AMT
Maximum Invoice
Amount
Signed 18.2
The maximum single invoice amount that can be entered for the vendor.
AP51.1
CVV-ORIGIN-DATE
Element: Date
Numeric 8 (yyyymmdd)
The origin date for the vendor. Provides additional information such as the date the vendor relationship began. If left blank, the system date defaults.
AP51.1
CVV-USER-NAME-01
Element: Vendor User Field 1
Alpha 20
The value of the information being tracked for the vendor in the first vendor group user field.
AP51.1 AP51.2
CVV-USER-NAME-02
Element: Vendor User Field 2
Alpha 20
The value of the information being tracked for the vendor in the second vendor group user field.
AP51.1 AP51.2
CVV-USER-NAME-03
Element: Vendor User Field 3
Alpha 20
The value of the information being tracked for the vendor in the third vendor group user field.
AP51.1 AP51.2
CVV-USER-NAME-04
Element: Vendor User Field 4
Alpha 20
The value of the information being tracked for the vendor in the fourth vendor group user field.
AP51.1 AP51.2
CVV-USER-NAME-05
Element: Vendor User Field 5
Alpha 20
The value of the information being tracked for the vendor in the fifth vendor group user field.
AP51.1 AP51.2
CVV-USER-NAME-06
Element: Vendor User Field 6
Alpha 20
The value of the information being tracked for the vendor in the sixth vendor group user field.
AP51.1 AP51.2
CVV-CUST-GROUP
Element: Cust Group
Alpha 5
Customer group. Used to identify a group of customer associated with one or more companies.
AP51.1
CVV-CUSTOMER
Element: Customer
Alpha 9 (Right Justified)
This field contains the number that represents a customer.
AP51.1
CVV-LEGAL-NAME
Element: Legal Name
Alpha 80 (Lower Case)
The legal name for the vendor. Used for reporting reportable vendor income. If left blank, the vendor name defaults.
AP51.1
CVV-ACTIVITY
Element: Activity
Alpha 15
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.
AP51.1
CVV-ACCT-CATEGORY
Element: Acct Category
Alpha 5
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.
AP51.1
CVV-DISCOUNT-CODE
Element: Discount Code
Alpha 10
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.
AP51.1 AP51.2
CVV-PRIME-RATE
Anticipation
Discount Rate
Signed 7.5
The percentage used to calculate 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.
AP51.1
CVV-INVOICE-GROUP
Element: Invoice Group
Alpha 4
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.
AP51.1 AP51.2
CVV-ERS-CAPABLE
Element: All Flag
Alpha 1
Indicates whether the vendor location can process ERS. Valid values are Y = Yes N = No
AP58.1
CVV-INVC-REF-TYPE
Element: Invc Ref Type
Alpha 2
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
AP58.1
CVV-EDI-AUTO-REL
Element: EDI Auto Release
Alpha 1
Indicates whether the company automatically releases EDI invoices. Valid values are Y = Yes N = No
AP58.1
CVV-AUTH-CODE
Element: Auth Code
Alpha 3
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.
AP51.1
CVV-CHARGE-CODE
Element: Charge Code
Alpha 1
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.
AP58.1
CVV-PMT-CAT-CODE
Payment Category
Code
Alpha 6
The SWIFT payment category code assigned to the vendor. Valid values are: G = Goods. S = Service & Capital. T = Transit Trade. X = Transfer. O = Other.
AP58.1
CVV-NORM-EXP-CODE
Normal or Express
Code
Alpha 1
The normal or express SWIFT payment option assigned to the vendor. Valid values are: N = Normal. E = Express.
AP58.1
CVV-PMT-FORM
Element: Payment Form
Alpha 2
The SWIFT payment form assigned to the vendor. Indicates how the payment is made. Valid values are: C = Check. F = Foreign Bank.
AP58.1
CVV-SWIFT-ID
Element: Swift ID
Alpha 12
The SWIFT identification number assigned to the vendor.
AP58.1
CVV-PROC-GRP
Element: Proc Grp
Alpha 4 (Lower Case)
A process group is an identifier used for separating vendors into different groups to enable concurrent processing within the cash payment cycle.
AP51.1
CVV-MATCH-TABLE
Element: Match Table
Alpha 10
AP51.1
CVV-HANDLING-CODE
Element: Handling Code
Alpha 4
AP51.1
CVV-DISC-CALC-DATE
Element: Disc Calc Date
Alpha 1

" "
R = Receipt Date
D = Receipt of Invoice Date
I = Invoice Date
S = Ship To Arrive Date
E = Earliest Receipt Date
AP51.1
CVV-ENCLOSURE
Element: All Flag
Alpha 1

N = No
Y = Yes
" "
AP51.1
CVV-CREATE-POD-FL
Element: Create Pod Fl
Alpha 1

Y = Yes
N = No
AP51.1
CVV-REQ-MATCH-REF
Element: Match Ref Processing
Alpha 1

Y = Yes
N = No
AP51.1
CVV-POOL-OPTION
Element: Pool Option
Numeric 1
AP51.1
CVV-HOLD-INSP-FLAG
Element: Hold Insp Flag
Alpha 1
If set to "Y", this flag will keep receiving lines requiring inspection from being matched until they have been inspected.
AP51.1
CVV-WRITE-OFF-AMT
Element: Intl Amt
Signed 18.2
AP51.1 AP51.2
CVV-VEN-CLAIM-TYPE
Element: Vendor Claim Type
Alpha 2
AP51.1 AP51.2
CVV-CLAIM-HOLD-CD
Element: Hold Code
Alpha 4
The hold code.
AP51.1 AP51.2
CVV-CB-HOLD-CODE
Element: Hold Code
Alpha 4
The hold code.
AP51.1
CVV-CB-MINIMUM-AMT
Element: Minimum Claim Amount
Signed 18.2
AP51.1
CVV-REPLACE-GOODS
Element: Replace Goods
Alpha 1
AP51.1 AP51.2
CVV-SHIP-OR-HOLD
Element: Ship or Hold Goods
Alpha 1
AP51.1 AP51.2
CVV-ERS-HANDLING
Element: Handling Code
Alpha 4
AP58.1
CVV-E-MAIL-ADDRESS
Element: Email Address
Alpha 60 (Lower Case)
e-mail address.
AP51.1 AP51.2
CVV-URL-ADDR
Element: Url Addr
Alpha 60 (Lower Case)
AP51.1
CVV-VEND-ACCT
Element: Vend Acct
Alpha 30
The customer number the vendor has assigned to you.
AP51.1 AP51.2
CVV-LANGUAGE-CODE
Element: Language Code
Alpha 10
Language Code (LOCALE).
AP51.1
CVV-TAX-USAGE-CD
Element: Tax Usage Cd
Alpha 10
The tax usage coe for the vendor. This filed is required if the AP Company inidcates that VAT reporting required.
AP51.1 AP51.2
CVV-VAT-REG-CTRY
Element: Vat Reg Ctry
Alpha 2
The country component of the VAT Registration Number. This field, together with the Registration Number for the company on the tax transaction.
AP51.1 AP51.2
CVV-VAT-REG-NBR
Element: Vat Reg Nbr
Alpha 12
The number component of the VAT Registration Number. This field together with the Registration Country field make up the VAT Registration Number.
AP51.1 AP51.2
CVV-VALIDATE-PO
Element: Validate Po
Alpha 1

" " = Use Default
Y = Yes
N = No
AP51.1
CVV-REQUIRE-PO
Element: Require Po
Alpha 1

" " = Use Default
Y = Yes
N = No
AP51.1
CVV-POV-BUYER-CODE
Element: Buyer
Alpha 3
The user defined buyer identifier for the PO side of the vendor.
AP51.4 AP51.5
CVV-POV-OPEN-PO-LM
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. For the PO side of vendor.
AP51.4 AP51.5
CVV-POV-OPEN-PO-AM
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. This is for the PO side of vendor.
AP51.4 AP51.5
CVV-POV-LEADTIME
Element: Leadtime Days
Numeric 3
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.
AP51.4 AP51.5
CVV-POV-EDI-NUMBER
Element: Edi Nbr
Alpha 15
EDI number for the PO side of the Vendor.
AP51.4 AP51.5
CVV-POV-FAX-PREFIX
Element: Phone Prefix
Alpha 6
The fax number prefix for the PO side of the vendor.
AP51.4 AP51.5
CVV-POV-FAX-EXT
Element: Phone Ext
Alpha 5
This field contains the fax number extension for the PO side of the vendor.
AP51.4 AP51.5
CVV-POV-FAX-NUMBER
Element: Phone
Alpha 15
This field contains the fax number for the PO side of the vendor.
AP51.4 AP51.5
CVV-POV-MAX-ORD-AM
Element: Intl Amt
Signed 18.2
The maximum open purchase order amount for the PO side of the vendor.
AP51.4 AP51.5
CVV-POV-FREIGHT-TR
Element: Pov Freight Tr
Alpha 1
The Vendor's default freight term for the PO side of the vendor.
AP51.4 AP51.5
CVV-POV-SHIP-VIA
Element: Ship Via
Alpha 12 (Lower Case)
The Vendor's default ship via narrative for the PO side of the vendor.
AP51.4 AP51.5
CVV-POV-FOB-CODE
Element: Fob Code
Alpha 3
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.
AP51.4 AP51.5
CVV-POV-NORM-DEL
Element: Norm Del Day
Alpha 3
The Vendor's normal delivery day for the PO side of the vendor. Informational only.
AP51.4 AP51.5
CVV-POV-OSHIP-TPCT
Element: Pov Oship Tpct
Percent 5.3 (Percent)
Quantity overshipment tolerance percentage for the PO side of the vendor.
AP51.4 AP51.5
CVV-POV-USHIP-TPCT
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 is for the PO side of the vendor.
AP51.4 AP51.5
CVV-POV-HIN-NBR
Element: Pov Hin Nbr
Alpha 9
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
Element: Pov Zohship Fl
Alpha 1
The Vendor default overshipment quantity tolerance flag. For the PO side of the vendor.
AP51.4 AP51.5
CVV-POV-ZUHSHIP-FL
Element: Pov Zohship Fl
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". For the PO side of Vendor.
AP51.4 AP51.5
CVV-POV-CAN-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
AP51.4
CVV-POV-RMA-REQ
Element: Pov Rma Req
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 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.
AP51.4 AP51.5
CVV-POV-RMA-DOC-RQ
Element: Pov Rma Req
Alpha 1
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.
AP51.4 AP51.5
CVV-POV-OV-SHP-VIA
Element: Ivend Ship Via
Alpha 12
This 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.
AP51.4
CVV-POV-REQ-LOCLVL
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 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.
AP51.4 AP51.5
CVV-POV-REQ-CONLVL
Element: Req Loc Level
Alpha 1
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
Element: Issue Meth
Alpha 1
Specifies the method that will be used to issue the purhase order to the vendor. For the PO side of the Vendor.
AP51.4 AP51.5
CVV-POV-REV-ISS-MT
Element: Rev Issue Meth
Alpha 1
Specifies the method that will be used to issued purchase order revisions to the vendor. For the PO side of the vendor.
AP51.4 AP51.5
CVV-POV-REV-EDI-NB
Element: Edi Nbr
Alpha 15
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.
AP51.4 AP51.5
CVV-POV-REV-EDI-TR
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). For the PO side of the vendor.
AP51.4 AP51.5
CVV-POV-REV-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). For the PO side of Vendor.
AP51.4 AP51.5
CVV-POV-VEN-CONT
Element: Tax Contact
Alpha 30
The PO side Vendor contact name.
AP51.4 AP51.5
CVV-POV-PHONE-PREF
Element: Phone Prefix
Alpha 6
The telephone number country code. For the PO side of vendor.
AP51.4 AP51.5
CVV-POV-PHONE-NUM
Element: Phone
Alpha 15
This is the main telephone number for the PO side of vendor.
AP51.4 AP51.5
CVV-POV-PHONE-EXT
Element: Phone Ext
Alpha 5
This field contains the telephone extension number for the PO side of the vendor.
AP51.4 AP51.5
CVV-POV-VEND-ACCT
Element: Vend Acct
Alpha 30
The customer number the vendor has assigned to you for the PO side of Vendor.
CVV-POV-PO-CODE
Element: Po Code
Alpha 4
This is the purchase order code that will default from the vendor to the purchase order. For the PO side of the vendor.
AP51.4 AP51.5
CVV-POV-UPD-PO-CST
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
AP51.4
CVV-POV-USR-FLD-01
Element: Pov Usr Fld 01
Alpha 20
AP51.4
CVV-POV-USR-FLD-02
Element: Pov Usr Fld 02
Alpha 20
AP51.4
CVV-POV-USR-FLD-03
Element: Pov Usr Fld 03
Alpha 20
AP51.4
CVV-POV-USR-FLD-04
Element: Pov Usr Fld 04
Alpha 20
AP51.4
CVV-POV-USR-FLD-05
Element: Pov Usr Fld 05
Alpha 20
AP51.4
CVV-MBL-INT-PREFIX
Element: Mbl Int Prefix
Alpha 6
This field contains the country code of the mobile phone number.
AP51.1 AP51.2
CVV-MOBILE-NUM
Element: Mobile Num
Alpha 15
This field contains the mobile phone number.
AP51.1 AP51.2
CVV-MOBILE-EXT
Element: Mobile Ext
Alpha 5
This field contains the mobile phone extension number.
AP51.1 AP51.2
CVV-PAY-IMM-FLAG
Element: All Flag
Alpha 1
AP51.1 AP51.2
CVV-DIVERSE-CODE
Element: Diverse Code
Alpha 5
Diversity Code for Account Payable Vendors
AP51.1 AP51.2
CVV-INTM-BANK-ENT
Element: Bank Entity
Alpha 15
Type the intermediary bank identification used to deposit electronic payments for the vendor.
AP58.1
CVV-INTM-BANK-ACCT
Element: Bank Acct Nbr
Alpha 35
Type the intermediary bank account number used to deposit electronic payments for the vendor.
AP58.1
CVV-INTM-BANK-IDNT
Element: Intm Bank Idnt
Alpha 1
This field indicate if the account number is an IBANK number that requires an account validation check.
Y = Yes
N = No or Blank
AP58.1
CVV-INTM-BANK-CURR
Element: Currency Code
Alpha 5
This field contains the intermediary bank currency code.
AP58.1
CVV-INTM-PRENOT
Element: All Flag
Alpha 1
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
AP58.1
CVV-INTM-SWIFT-ID
Element: Patient Id
Alpha 12
Use SWIFT Payment Options (AP10.8) to define SWIFT payment options if you create Intermediary SWIFT payments for the vendor.
AP58.1
CVV-INTM-PMT-CAT
Element: Pmt Cat Code
Alpha 6
Select the Intermediary SWIFT payment category.
AP58.1
CVV-INTM-NORM-EXP
Element: Charge Code
Alpha 1
Indicates whether the SWIFT payment is a normal or express payment.
N = Normal
E = Express
" " = Not defined for the vendor
AP58.1
CVV-INTM-PMT-FORM
Element: Pmt Form
Alpha 2
Indicates how the Intermediary SWIFT payment is made.
AP58.1
CVV-INTM-CHRG-CD
Element: Charge Code
Alpha 1
Indicates who pays service charges or fees associated with a Intermediary SWIFT payment.
AP58.1
CVV-INTM-RIBKEY
Element: Ribkey
Numeric 2
CVV-INTM-CRS-IDENT
Element: Intm Crs Ident
Alpha 1

S = SWIFT
R = Routing Number
AP58.1
CVV-FLOAT-DAYS
Element: Float Days
Numeric 3
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.
AP51.1
CVV-VN-BLD-SOC-REF
Element: Build Soc Ref
Alpha 18
This field holds an individual account number reference for the Building Society
CVV-VN-BLD-ACCT-NM
Element: Account Name
Alpha 18
CVV-IN-BLD-SOC-REF
Element: Build Soc Ref
Alpha 18
This field holds an individual account number reference for the Building Society
CVV-IN-BLD-ACCT-NM
Element: Account Name
Alpha 18
CVV-MTCH-PREPAY-FL
Element: Mtch Prepay Fl
Alpha 1
Flag notes that the invoice will be prepaid. This is for match invoices.
CVV-MTCH-PREPAY-MT
Element: Mtch Prepay Mt
Numeric 1
Flag denotes the method of match prepayment.
0 = No
1 = Prepay from Invoice
2 = Eligible for Prepayment
CVV-BUILD-SOC-REF
Element: Build Soc Ref
Alpha 18
This field holds an individual account number reference for the Building Society
AP58.1
CVV-BUILD-ACCT-NM
Element: Account Name
Alpha 18
AP58.1
CVV-MIN-ORD-WEIGHT
Element: Min Ord Weight
Signed 9.3
AP51.4
CVV-UNLOADING-PORT
Element: Unloading Port
Alpha 5
The prot where the goods are unloaded if required. Must be defined in IN04.1 (Port Maintenance)
AP51.4
CVV-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)
AP51.4
CVV-WORKFLOW-GROUP
Element: Workflow Group
Alpha 20
AP51.1
CVV-RULE-GROUP
Element: Rule Group
Alpha 10
AP51.1
CVV-CROSS-IDENT
Element: Cross Ident
Alpha 1
This field is used to distinguish between SWIFT ID numbers and Routing numbers.
S = SWIFT
R = Routing Number
AP58.1
CVV-GIRO-NUMBER
Element: Giro Number
Alpha 15
This field is the Bankgiro or Postgiro account number
AP58.1
CVV-CR-CARD-NUMBER
Element: Cr Card Number
Alpha 16
This field contains the credit card number.
AP58.1
CVV-BANK-INSTRUCT1
Element: Bank Instruct1
Alpha 35
This field contains bank instructions.
AP58.1
CVV-BANK-INSTRUCT2
Element: Bank Instruct2
Alpha 35
This field contains bank instructions.
AP58.1
CVV-BANK-INSTRUCT3
Element: Bank Instruct3
Alpha 35
This field contains bank instructions.
AP58.1
CVV-BANK-INSTRUCT4
Element: Bank Instruct4
Alpha 35
This field contains bank instructions.
AP58.1
CVV-LOC-ID-PRT
Element: Loc Id Prt
Numeric 1
AP51.4 AP51.5
CVV-PUNCHOUT-CHG-F
Element: Punchout Chg F
Numeric 1
AP51.4 AP51.5
CVV-EMAIL-ADDRESS
Element: Email Address
Alpha 60 (Lower Case)
e-mail address.
AP51.4 AP51.5
CVV-REORDER-SUN-FL
Element: Reorder Mon Fl
Numeric 1
AP51.4 AP51.5
CVV-REORDER-MON-FL
Element: Reorder Mon Fl
Numeric 1
AP51.4 AP51.5
CVV-REORDER-TUE-FL
Element: Reorder Mon Fl
Numeric 1
AP51.4 AP51.5
CVV-REORDER-WED-FL
Element: Reorder Mon Fl
Numeric 1
AP51.4 AP51.5
CVV-REORDER-THU-FL
Element: Reorder Mon Fl
Numeric 1
AP51.4 AP51.5
CVV-REORDER-FRI-FL
Element: Reorder Mon Fl
Numeric 1
AP51.4 AP51.5
CVV-REORDER-SAT-FL
Element: Reorder Mon Fl
Numeric 1
AP51.4 AP51.5
CVV-DIVERSE-CODE5
Element: Diverse Code
Alpha 5
Diversity Code for Account Payable Vendors
CVV-P-CARD-FLAG
Element: Flag Num
Numeric 1

0 = No
1 = Yes
AP51.1
CVV-PCARD-NBR
Element: Pcard Nbr
Alpha 16
AP51.1
CVV-VAL-DIV-DATE
Element: All Flag
Alpha 1
Determines on invoice entry if the invoice date is within the certification dates for the diversity code setup for the vendor on AP14.4
AP51.1
CVV-POV-GTIN-USED
Element: Boolean
Numeric 1

0 = No
1 = Yes
AP51.4
CVV-GTIN-ITEM-SYNC
Element: Boolean
Numeric 1

0 = No
1 = Yes
AP51.4
CVV-AP-GLN-NBR
Element: Gln Nbr
Alpha 13
AP51.1 AP51.2
CVV-PO-GLN-NBR
Element: Gln Nbr
Alpha 13
AP51.4 AP51.5


APCVENMAST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CVVSET1 VENDOR-GROUP
VENDOR
OLD-VENDOR
LOCATION-CODE
AP51.1 AP51.2
AP51.4 AP51.5
AP51.8 AP510
AP58.1


APCVENMAST FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED 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


File created: Wed Jun 08 20:47:29 2016

Home
Contact Us



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