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. |
|
||||||
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. |
|
||||||
CVV-OLD-VENDOR Element: Vendor | Alpha 9 (Right Justified) The vendor's number before conversion to Accounts Payable. Required if using automatic vendor numbering. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
CVV-VENDOR-VNAME Element: Name | Alpha 30 (Lower Case) Required. The vendor name or description. This field accepts both upper and lower case entries. |
|
||||||
CVV-VENDOR-SNAME Element: Search Name | Alpha 30 The search name for the vendor. If left blank, the Vendor Name defaults. |
|
||||||
CVV-VENDOR-CONTCT Element: Contact | Alpha 30 The requester can enter the recommended vendor's name for the requested items. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
CVV-STATE-PROV Element: State or Province | Alpha 2 The state or province for the vendor address. |
|
||||||
CVV-POSTAL-CODE Element: Postal Code | Alpha 10 (Lower Case) The postal code for the vendor address. |
|
||||||
CVV-COUNTY Element: County | Alpha 25 (Lower Case) The county for the company address. |
|
||||||
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. |
|
||||||
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) |
|
||||||
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). |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
CVV-PHONE-PREFIX Element: Phone Prefix | Alpha 6 The telephone number prefix for the vendor. |
|
||||||
CVV-PHONE-NUM Element: Phone | Alpha 15 The telephone number for the vendor. |
|
||||||
CVV-PHONE-EXT Element: Phone Ext | Alpha 5 The telephone extension number for the vendor. |
|
||||||
CVV-FAX-PREFIX Element: Phone Prefix | Alpha 6 The fax telephone number prefix for the vendor. |
|
||||||
CVV-FAX-NUM Element: Phone | Alpha 15 The fax telephone number for the vendor. |
|
||||||
CVV-FAX-EXT Element: Phone Ext | Alpha 5 The fax telephone number extension for the vendor. |
|
||||||
CVV-TELEX-NUM Element: Phone | Alpha 15 The telex number for the vendor. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
CVV-BANK-CURRENCY Element: Currency Code | Alpha 5 This field contains the bank currency code. |
|
||||||
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. |
|
||||||
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. |
|
||||||
CVV-TAX-ID Element: Tax ID | Alpha 20 If tracking reportable income for the vendor, this field contains the vendor's tax identification number. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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 |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
CVV-MAX-INV-AMT Maximum Invoice Amount | Signed 18.2 The maximum single invoice amount that can be entered for the vendor. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
CVV-CUST-GROUP Element: Cust Group | Alpha 5 Customer group. Used to identify a group of customer associated with one or more companies. |
|
||||||
CVV-CUSTOMER Element: Customer | Alpha 9 (Right Justified) This field contains the number that represents a customer. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
CVV-ERS-CAPABLE Element: All Flag | Alpha 1 Indicates whether the vendor location can process ERS. Valid values are Y = Yes N = No |
|
||||||
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 |
|
||||||
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 |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
CVV-SWIFT-ID Element: Swift ID | Alpha 12 The SWIFT identification number assigned to the vendor. |
|
||||||
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. |
|
||||||
CVV-MATCH-TABLE Element: Match Table | Alpha 10 |
|
||||||
CVV-HANDLING-CODE Element: Handling Code | Alpha 4 |
|
||||||
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 |
|
||||||
CVV-ENCLOSURE Element: All Flag | Alpha 1 N = No Y = Yes " " |
|
||||||
CVV-CREATE-POD-FL Element: Create Pod Fl | Alpha 1 Y = Yes N = No |
|
||||||
CVV-REQ-MATCH-REF Element: Match Ref Processing | Alpha 1 Y = Yes N = No |
|
||||||
CVV-POOL-OPTION Element: Pool Option | Numeric 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. |
|
||||||
CVV-WRITE-OFF-AMT Element: Intl Amt | Signed 18.2 |
|
||||||
CVV-VEN-CLAIM-TYPE Element: Vendor Claim Type | Alpha 2 |
|
||||||
CVV-CLAIM-HOLD-CD Element: Hold Code | Alpha 4 The hold code. |
|
||||||
CVV-CB-HOLD-CODE Element: Hold Code | Alpha 4 The hold code. |
|
||||||
CVV-CB-MINIMUM-AMT Element: Minimum Claim Amount | Signed 18.2 |
|
||||||
CVV-REPLACE-GOODS Element: Replace Goods | Alpha 1 |
|
||||||
CVV-SHIP-OR-HOLD Element: Ship or Hold Goods | Alpha 1 |
|
||||||
CVV-ERS-HANDLING Element: Handling Code | Alpha 4 |
|
||||||
CVV-E-MAIL-ADDRESS Element: Email Address | Alpha 60 (Lower Case) e-mail address. |
|
||||||
CVV-URL-ADDR Element: Url Addr | Alpha 60 (Lower Case) |
|
||||||
CVV-VEND-ACCT Element: Vend Acct | Alpha 30 The customer number the vendor has assigned to you. |
|
||||||
CVV-LANGUAGE-CODE Element: Language Code | Alpha 10 Language Code (LOCALE). |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
CVV-VALIDATE-PO Element: Validate Po | Alpha 1 " " = Use Default Y = Yes N = No |
|
||||||
CVV-REQUIRE-PO Element: Require Po | Alpha 1 " " = Use Default Y = Yes N = No |
|
||||||
CVV-POV-BUYER-CODE Element: Buyer | Alpha 3 The user defined buyer identifier for the PO side of the vendor. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
CVV-POV-EDI-NUMBER Element: Edi Nbr | Alpha 15 EDI number for the PO side of the Vendor. |
|
||||||
CVV-POV-FAX-PREFIX Element: Phone Prefix | Alpha 6 The fax number prefix for the PO side of the vendor. |
|
||||||
CVV-POV-FAX-EXT Element: Phone Ext | Alpha 5 This field contains the fax number extension for the PO side of the vendor. |
|
||||||
CVV-POV-FAX-NUMBER Element: Phone | Alpha 15 This field contains the fax number for the PO side of the vendor. |
|
||||||
CVV-POV-MAX-ORD-AM Element: Intl Amt | Signed 18.2 The maximum open purchase order amount for the PO side of the vendor. |
|
||||||
CVV-POV-FREIGHT-TR Element: Pov Freight Tr | Alpha 1 The Vendor's default freight term for the PO side of the vendor. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
CVV-POV-OSHIP-TPCT Element: Pov Oship Tpct | Percent 5.3 (Percent) Quantity overshipment tolerance percentage for the PO side of the vendor. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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 |
|
||||||
CVV-POV-RMA-REQ Element: Pov Rma Req | Alpha 1 Type or select 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 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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
CVV-POV-VEN-CONT Element: Tax Contact | Alpha 30 The PO side Vendor contact name. |
|
||||||
CVV-POV-PHONE-PREF Element: Phone Prefix | Alpha 6 The telephone number country code. For the PO side of vendor. |
|
||||||
CVV-POV-PHONE-NUM Element: Phone | Alpha 15 This is the main telephone number for the PO side of vendor. |
|
||||||
CVV-POV-PHONE-EXT Element: Phone Ext | Alpha 5 This field contains the telephone extension number for the PO side of the vendor. |
|
||||||
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. |
|
||||||
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 |
|
||||||
CVV-POV-USR-FLD-01 Element: Pov Usr Fld 01 | Alpha 20 |
|
||||||
CVV-POV-USR-FLD-02 Element: Pov Usr Fld 02 | Alpha 20 |
|
||||||
CVV-POV-USR-FLD-03 Element: Pov Usr Fld 03 | Alpha 20 |
|
||||||
CVV-POV-USR-FLD-04 Element: Pov Usr Fld 04 | Alpha 20 |
|
||||||
CVV-POV-USR-FLD-05 Element: Pov Usr Fld 05 | Alpha 20 |
|
||||||
CVV-MBL-INT-PREFIX Element: Mbl Int Prefix | Alpha 6 This field contains the country code of the mobile phone number. |
|
||||||
CVV-MOBILE-NUM Element: Mobile Num | Alpha 15 This field contains the mobile phone number. |
|
||||||
CVV-MOBILE-EXT Element: Mobile Ext | Alpha 5 This field contains the mobile phone extension number. |
|
||||||
CVV-PAY-IMM-FLAG Element: All Flag | Alpha 1 |
|
||||||
CVV-DIVERSE-CODE Element: Diverse Code | Alpha 5 Diversity Code for Account Payable Vendors |
|
||||||
CVV-INTM-BANK-ENT Element: Bank Entity | Alpha 15 Type the intermediary bank identification used to deposit electronic payments for the vendor. |
|
||||||
CVV-INTM-BANK-ACCT Element: Bank Acct Nbr | Alpha 35 Type the intermediary bank account number used to deposit electronic payments for the vendor. |
|
||||||
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 |
|
||||||
CVV-INTM-BANK-CURR Element: Currency Code | Alpha 5 This field contains the intermediary bank currency code. |
|
||||||
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 |
|
||||||
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. |
|
||||||
CVV-INTM-PMT-CAT Element: Pmt Cat Code | Alpha 6 Select the Intermediary SWIFT payment category. |
|
||||||
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 |
|
||||||
CVV-INTM-PMT-FORM Element: Pmt Form | Alpha 2 Indicates how the Intermediary SWIFT payment is made. |
|
||||||
CVV-INTM-CHRG-CD Element: Charge Code | Alpha 1 Indicates who pays service charges or fees associated with a Intermediary SWIFT payment. |
|
||||||
CVV-INTM-RIBKEY Element: Ribkey | Numeric 2 |
|
||||||
CVV-INTM-CRS-IDENT Element: Intm Crs Ident | Alpha 1 S = SWIFT R = Routing Number |
|
||||||
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. |
|
||||||
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 |
|
||||||
CVV-BUILD-ACCT-NM Element: Account Name | Alpha 18 |
|
||||||
CVV-MIN-ORD-WEIGHT Element: Min Ord Weight | Signed 9.3 |
|
||||||
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) |
|
||||||
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) |
|
||||||
CVV-WORKFLOW-GROUP Element: Workflow Group | Alpha 20 |
|
||||||
CVV-RULE-GROUP Element: Rule Group | Alpha 10 |
|
||||||
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 |
|
||||||
CVV-GIRO-NUMBER Element: Giro Number | Alpha 15 This field is the Bankgiro or Postgiro account number |
|
||||||
CVV-CR-CARD-NUMBER Element: Cr Card Number | Alpha 16 This field contains the credit card number. |
|
||||||
CVV-BANK-INSTRUCT1 Element: Bank Instruct1 | Alpha 35 This field contains bank instructions. |
|
||||||
CVV-BANK-INSTRUCT2 Element: Bank Instruct2 | Alpha 35 This field contains bank instructions. |
|
||||||
CVV-BANK-INSTRUCT3 Element: Bank Instruct3 | Alpha 35 This field contains bank instructions. |
|
||||||
CVV-BANK-INSTRUCT4 Element: Bank Instruct4 | Alpha 35 This field contains bank instructions. |
|
||||||
CVV-LOC-ID-PRT Element: Loc Id Prt | Numeric 1 |
|
||||||
CVV-PUNCHOUT-CHG-F Element: Punchout Chg F | Numeric 1 |
|
||||||
CVV-EMAIL-ADDRESS Element: Email Address | Alpha 60 (Lower Case) e-mail address. |
|
||||||
CVV-REORDER-SUN-FL Element: Reorder Mon Fl | Numeric 1 |
|
||||||
CVV-REORDER-MON-FL Element: Reorder Mon Fl | Numeric 1 |
|
||||||
CVV-REORDER-TUE-FL Element: Reorder Mon Fl | Numeric 1 |
|
||||||
CVV-REORDER-WED-FL Element: Reorder Mon Fl | Numeric 1 |
|
||||||
CVV-REORDER-THU-FL Element: Reorder Mon Fl | Numeric 1 |
|
||||||
CVV-REORDER-FRI-FL Element: Reorder Mon Fl | Numeric 1 |
|
||||||
CVV-REORDER-SAT-FL Element: Reorder Mon Fl | Numeric 1 |
|
||||||
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 |
|
||||||
CVV-PCARD-NBR Element: Pcard Nbr | Alpha 16 |
|
||||||
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 |
|
||||||
CVV-POV-GTIN-USED Element: Boolean | Numeric 1 0 = No 1 = Yes |
|
||||||
CVV-GTIN-ITEM-SYNC Element: Boolean | Numeric 1 0 = No 1 = Yes |
|
||||||
CVV-AP-GLN-NBR Element: Gln Nbr | Alpha 13 |
|
||||||
CVV-PO-GLN-NBR Element: Gln Nbr | Alpha 13 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CVVSET1 |
VENDOR-GROUP VENDOR OLD-VENDOR LOCATION-CODE |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Apcontacts | APCCONTACT |
Delete Cascades
| |||||||||||||||
Apcvenbal | APCVENBAL |
|
All trademarks and registered trademarks are the property of their
respective owners.