The Vendor file contains accounts payable vendor records, including one-time
vendors defined during invoice entry. If the vendor has default codes defined
at a company level, the vendor record has one or more associated records in
the Vendor Company Codes file.
| FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
VEN-VENDOR-GROUP
Element: Vendor Group | Alpha 4
The vendor group to which the vendor
belongs. Must be a valid record in the
Vendor Group file.
|
|
VEN-VENDOR
Element: Vendor | Alpha 9 (Right Justified)
The identification number assigned to
the vendor.
|
|
VEN-VEN-CLASS
Element: Vendor Class | Alpha 3
The vendor class the vendor is assigned
to. Represents a group of vendors that
share common characteristics within a
vendor group. Must be a valid record in
the Vendor Class file.
|
|
VEN-VENDOR-VNAME
Element: Vendor Name | Alpha 30 (Lower Case)
The vendor name or description.
|
|
VEN-VENDOR-SNAME
Element: Search Name | Alpha 30
The search name for the vendor.
|
|
VEN-VENDOR-CONTCT
Element: Contact | Alpha 30
The name of the main contact for the
vendor.
|
|
VEN-REMIT-TO-CODE
Normal Remit-To
Location | Alpha 4
The normal remittance location for the
vendor, if defined. Must be a valid
record in the Vendor Location file. If
present, the address defined for the
location overrides the vendor address on
vendor payments when invoices are added.
|
|
VEN-PURCH-FR-LOC
Normal
Purchase-From Location | Alpha 4
The normal purchasing location for the
vendor, if defined. Must be a valid
record in the Vendor Location file. If
present, the address defined for the
location overrides the vendor address
for storing vendor purchase activity
balances.
|
|
VEN-PAY-VENDOR
Element: Pay Vendor | Alpha 9 (Right Justified)
The pay vendor for the vendor, if
applicable. Used to send invoice
payments to another vendor within the
same vendor group. If present, the pay
vendor relationship overrides the normal
remit-to information for the vendor,
including remit-to name and address,
cash code, and payment code. Must be a
valid record in the Vendor file.
Although payments are remitted to the
pay vendor, the invoiced vendor
accumulates the payment balance. If more
than one vendor shares the same pay
vendor, the system creates a single
payment for the pay vendor and lists
individual invoiced vendors and invoice
numbers that are included in the payment
on the remittance.
|
|
VEN-VENDOR-STATUS
Element: Status | Alpha 1
The vendor status. Invoices cannot be
entered for a vendor with an Inactive
status. Valid values are:
A = Active.
I = Inactive.
D = Inactive for PO additions |
|
VEN-VEN-PRIORITY
Element: Priority | Numeric 2
The payment priority assigned to the
vendor. Valid values are 1 (highest
priority) through 99 (lowest priority).
|
|
VEN-PHONE-PREFIX
Element: Phone Prefix | Alpha 6
The country code for the vendor
telephone number.
|
|
VEN-PHONE-NUM
Element: Phone | Alpha 15
The telephone number for the vendor.
|
|
VEN-PHONE-EXT
Element: Phone Ext | Alpha 5
The telephone extension number for the
vendor.
|
|
VEN-FAX-PREFIX
Element: Phone Prefix | Alpha 6
The country code for the fax machine
telephone number.
|
|
VEN-FAX-NUM
Element: Phone | Alpha 15
The fax machine telephone number.
|
|
VEN-FAX-EXT
Element: Phone Ext | Alpha 5
The fax machine telephone number
extension.
|
|
VEN-TELEX-NUM
Element: Telex | Alpha 15
The telex number for the vendor.
|
|
VEN-TERM-CODE
Element: Payment Terms | Alpha 5
The payment terms code assigned to the
vendor. Used to automatically calculate
invoice due date and discount
information for the vendor's invoices.
Must be a valid record in the Terms Code
file.
|
|
VEN-INV-CURRENCY
Element: Invoice Currency | Alpha 5
The currency used to add invoices for
the vendor. The currency code defaults
on the vendor's invoices during 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.
|
|
VEN-BAL-CURRENCY
Element: Vendor Balance | 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 is
used.
|
|
VEN-CURR-RECALC
Currency
Recalculation | Alpha 1
If the Invoice Currency is different
from the company base currency, this
field indicates whether the system will
recalculate the invoice currency when
the invoice is paid to account for
exchange rate fluctuations. If Yes is
selected in this field, 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 AP150 (Cash
Requirements). If a difference exists,
AP170 (Payment Closing) creates a
currency gain or loss transaction. Valid
values are:
N = No.
Y = Yes.
|
|
VEN-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.
|
|
VEN-TAX-ID
Element: Tax Id | Alpha 20
The tax identification number for the
vendor. Used for reporting reportable
vendor income.
|
|
VEN-TAX-EXEMPT-CD
Element: Tax Exempt Cd | Alpha 1
Code indicating the taxing status. E -
Exempt, T - Taxable.
|
|
VEN-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.
|
|
VEN-HOLD-FLAG
Element: Hold Code | Alpha 1
This field enables this entire lot to
be put on hold, not allowing any issues
or transfers to be made for this lot.
Y = Yes
" " |
|
VEN-DIST-CODE
Element: Distribution Code | Alpha 9
The distribution code assigned to the
vendor. Used to automatically create
distribution lines for the 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.
|
|
VEN-ACCR-CODE
Element: Invoice Accrual Code | Alpha 4
The invoice accrual code assigned to
the vendor. Used to default a general
ledger accrual account to the vendor's
invoices during entry. Must be a valid
record in the Invoice Accrual Code file.
If left blank, the invoice accrual code
assigned to the vendor class, if
assigned, or the company defaults.
|
|
VEN-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 or bill of exchange
payment transaction code record in the
Bank Transaction Code file.
|
|
VEN-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 or the pay
group.
|
|
VEN-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.
|
|
VEN-BANK-CURRENCY
Element: Currency Code | Alpha 5
This field contains the bank currency
code
|
|
VEN-VBANK-ACCT-NO
Element: Bank Acct Nbr | Alpha 35
The bank account number used to deposit
electronic payments for the vendor. This
field is required for ACH or BACS
payment types.
|
|
VEN-VBANK-ACCT-TP
Element: Vbank Acct Tp | Alpha 1
Indicates the type of bank account used
to deposit electronic payments for the
vendor. Valid values are:
C = Current/Checking Account.
S = Savings Account.
Blank = Electronic payment type not
selected.
|
|
VEN-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 |
|
VEN-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 |
|
VEN-INCOME-CODE
Element: Income Code | Alpha 4
The income code assigned to the vendor.
Used to track reportable income for the
vendor. Must be a valid record in the
Income Code file.
|
|
VEN-INCOME-WH-FLG
Element: Income Withholding | Alpha 1
Indicates whether invoices for the
vendor are subject to reportable income
withholding. Valid values are:
N = No.
Y = Yes.
|
|
VEN-EDI-NBR
Element: EDI Number | Alpha 15
The vendor's electronic data
interchange (EDI) number. Used for
reference.
|
|
VEN-ACH-PRENOT
Element: Ach Prenot | Alpha 1
Used in conjunction with ACH payments
created for the vendor. Indicates the
status of the electronic payment between
the vendor and the processing bank.
Valid values are:
N = Notified. Payment Tape Creation
(AP160) automatically changes the status
from Prenotified to Notified to indicate
that the processing bank has been
notified but has not yet accepted the
electronic payment tape.
P = Prenotified. Select this status
when first entering ACH information to
prenotify the processing bank.
A = Accepted. Change the status to
Accepted once the processing bank
accepts the electronic payment tape.
Blank = ACH payment type not selected.
|
|
VEN-MAX-INV-AMT
Maximum Invoice
Amount | Signed 18.2
The maximum single invoice amount that
can be entered for the vendor.
|
|
VEN-CREATE-DATE
Element: Create Date | Numeric 8 (yyyymmdd)
The date the vendor record was created
in Accounts Payable.
|
|
VEN-ORIGIN-DATE
Element: Date | Numeric 8 (yyyymmdd)
The origin date for the vendor. Can be
used record additional information, such
as the date the vendor relationship
began. If left blank, the system date
defaults.
|
|
VEN-OPERATOR
Element: Operator | Alpha 10
The operator associated with
maintaining the vendor record.
|
|
VEN-USER-NAME-01
Element: User Defined Field 1 | Alpha 20
The value of the information being
tracked for the vendor in the first
vendor group user field.
|
|
VEN-USER-NAME-02
Element: User Defined Field 2 | Alpha 20
The value of the information being
tracked for the vendor in the second
vendor group user field.
|
|
VEN-USER-NAME-03
Element: User Defined Field 3 | Alpha 20
The value of the information being
tracked for the vendor in the third
vendor group user field.
|
|
VEN-USER-NAME-04
Element: User Defined Field 4 | Alpha 20
The value of the information being
tracked for the vendor in the fourth
vendor group user field.
|
|
VEN-USER-NAME-05
Element: User Defined Field 5 | Alpha 20
The value of the information being
tracked for the vendor in the fifth
vendor group user field.
|
|
VEN-USER-NAME-06
Element: User Defined Field 6 | Alpha 20
The value of the information being
tracked for the vendor in the sixth
vendor group user field.
|
|
VEN-CUST-GROUP
Element: Customer Group | Alpha 5
If the accounts payable vendor is also
a customer in the Lawson Accounts
Receivable system, this field can be
used to identify the customer group
associated with the corresponding
accounts receivable customer. Used to
update the accounts receivable customer
record.
|
|
VEN-CUSTOMER
Element: Customer | Alpha 9 (Right Justified)
If the accounts payable vendor is also
a customer in the Lawson Accounts
Receivable system, this field can be
used to identify the corresponding
accounts receivable customer number.
Used to update the accounts receivable
customer record.
|
|
VEN-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.
|
|
VEN-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
the 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.
Anticipation discount terms codes are
defined in Terms.
|
|
VEN-INVOICE-GROUP
Element: Invoice Group | Alpha 4
A user-defined invoice group assigned
to the vendor. This value defaults on
invoices entered for the vendor. Can be
used to select invoices for payment in
AP150 (Cash Requirements).
|
|
VEN-DISCOUNT-CODE
Element: Discount Code | Alpha 10
The discount code assigned to the
vendor. Used to default a general ledger
discount account on the vendor's
invoices during entry. Must be a valid
record in the Discount Code file.
|
|
VEN-ERS-CAPABLE
Element: ERS Capable | Alpha 1
Indicates whether the vendor location
has the capability to process ERS. Valid
values are:
N = No.
Y = Yes.
|
|
VEN-INVC-REF-TYPE
ERS Invoice
Reference | Alpha 2
Indicates the type of number the vendor
is providing to reference the invoice.
Valid values are:
BM = Bill of Lading Number.
IN = Invoice Number.
OW = Service Order Number.
PL = Packing List Number.
PO = PO Number.
VN = Vendor Order Number.
WO = Production Order Number.
WP = Warehouse Pick Ticket Number.
ZZ = Mutually Defined Number.
|
|
VEN-EDI-AUTO-REL
EDI Invoice Auto
Release | Alpha 1
Indicates whether the company
automatically releases EDI invoices.
Valid values are:
N = No.
Y = Yes.
|
|
VEN-AUTH-CODE
Element: Authority Code | Alpha 3
The authority code assigned to the
vendor, if assigned. Represents a person
or department responsible for approving
registered invoices for the vendor. This
code defaults on the vendor's invoices
during entry. Must be a valid authority
code in the Authority Code file.
|
|
VEN-APPRVL-EXISTS
Approval
Information Exists | Alpha 1
Indicates whether approval criteria is
defined for the vendor. If Yes, one or
more associated approval records exist
for the vendor in the Invoice Approval
file. Valid values are:
N = No.
Y = Yes.
|
|
VEN-ACTIVITY
Element: Activity | Alpha 15
The activity assigned to the vendor, if
assigned. Activities are the tasks that
make up an activity group. Activities
identify work being done, such as work
orders, phases, products, and so on.
Must be a valid record in the Activity
file.
|
|
VEN-ACCT-CATEGORY
Element: Account Category | Alpha 5
The account category assigned to the
vendor. Account categories are the
Activity Management accounts by which
activity transactions are grouped for
budgeting and reporting. Must be a valid
record in the Activity Account Category
file.
|
|
VEN-CHARGE-CODE
Element: Charge Code | Alpha 1
Indicates who pays service charges or
fees associated with a SWIFT payment.
Valid values are:
I = Issuer.
R = Receiver.
Blank = Not defined for the vendor.
|
|
VEN-PMT-CAT-CODE
Payment Category
Code | Alpha 6
Indicates the payment category of the
SWIFT payment. Valid values are:
G = Goods.
T = Transit Trade.
S = Service and Capital.
X = Transfer.
O = Other.
Blank = Not defined for the vendor.
|
|
VEN-NORM-EXP-CODE
Normal or Express
Code | Alpha 1
Indicates whether the SWIFT payment is
a normal or express payment. Valid
values are:
N = Normal.
E = Express.
Blank = Not defined for the vendor.
|
|
VEN-PMT-FORM
Element: Payment Form | Alpha 2
Indicates how the SWIFT payment is
made. Valid values are:
C = Check.
B = Foreign Bank.
Blank = Not defined for the vendor.
|
|
VEN-SWIFT-ID
Element: Swift ID | Alpha 12
The SWIFT identification number
assigned to the vendor.
|
|
VEN-PROC-GRP
Element: Process Group | 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.
|
|
VEN-MATCH-TABLE
Element: Match Table | Alpha 10
A code representing a match table. A
match table contains the processing
rules that will be used during matching.
|
|
VEN-DISC-CALC-DATE
Discount
Calculation Date | Alpha 1
Select which date to use when
calculating discounts.
You can use the invoice date, receipt
date, or the date the invoice was
received.
" "
D = Receipt of Invoice Date
I = Invoice Date
R = Latest Receipt Date
E = Earliest Receipt Date
S = Ship To Arrive Date |
|
VEN-CREATE-POD-FL
Proof of Delivery
Created | Alpha 1
Indicates whether to create a proof of
delivery.
Valid values are:
N = No
Y = Yes
" " |
|
VEN-HANDLING-CODE
Invoice Handling
Code | Alpha 4
Invoice handling code. Determines the
processing rules that will be used
during matching.
|
|
VEN-ENCLOSURE
Element: Enclosure | Alpha 1
Indicates whether the invoice requires
an enclosure with its payment.
Y = Yes
N = No
" " |
|
VEN-REQ-MATCH-REF
Match Reference
Required | Alpha 1
Indicates whether a match reference
number is required for invoices for this
vendor.
Y = Yes
N = No |
|
VEN-POOL-OPTION
Element: Au Flag | Numeric 1
1 = Company Vendor
2 = Company Vendor PO
3 = Company Vendor PO ShipTo
0 = MA Company Default |
|
VEN-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.
Y = Yes
N = No
" " = Use Company |
|
VEN-WRITE-OFF-AMT
Element: Intl Amt | Signed 18.2
|
|
VEN-VEN-CLAIM-TYPE
Element: Vendor Claim Type | Alpha 2
CB = Chargeback
CM = Credit Memo
N = None |
|
VEN-CLAIM-HOLD-CD
Element: Hold Code | Alpha 4
The hold code.
|
|
VEN-CB-HOLD-CODE
Vendor Claims
Chargeback Hold | Alpha 4
The hold code.
|
|
VEN-CB-MINIMUM-AMT
Element: Minimum Claim Amount | Signed 18.2
|
|
VEN-REPLACE-GOODS
Element: Replace Goods | Alpha 1
Y = Yes
N = No |
|
VEN-SHIP-OR-HOLD
Element: Ship or Hold Goods | Alpha 1
S = Ship
H = Hold |
|
VEN-ERS-HANDLING
Element: Handling Code | Alpha 4
|
|
VEN-E-MAIL-ADDRESS
Element: Email Address | Alpha 60 (Lower Case)
e-mail address.
|
|
VEN-URL-ADDR
Element: Url Addr | Alpha 60 (Lower Case)
|
|
VEN-VEND-ACCT
Element: Vend Acct | Alpha 30
The customer number the vendor has
assigned to you.
|
|
VEN-LANGUAGE-CODE
Element: Language Code | Alpha 10
Language Code (LOCALE).
|
|
VEN-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.
|
|
VEN-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.
|
|
VEN-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.
|
|
VEN-VALIDATE-PO
Element: Validate Po | Alpha 1
" " = MA Company Default
Y = Yes
N = No |
|
VEN-REQUIRE-PO
Element: Require Po | Alpha 1
" " = MA Company Default
Y = Yes
N = No |
|
VEN-LOC-INDICATOR
Element: Locations Exist | Derived
When selecting a vendor from a list of
available vendors, an asterisk (*)
displays if alternate locations exist
for a vendor.
|
|
VEN-SHORT-VNAME
Element: Short Vendor Name | Derived
A short name for the vendor. Used for
display purposes.
|
|
VEN-VCOMMENT-EXIST
Vendor Comments
Exist | Derived
When selecting a vendor from a list of
available vendors, an asterisk (*)
displays if comments exist for a vendor.
|
|
VEN-VDR-ADDR1
Element: Vdr Addr1 | Derived
Vendor address line 1.
|
|
VEN-VDR-ADDR2
Element: Vdr Addr2 | Derived
Vendor address line 2.
|
|
VEN-VDR-ADDR3
Element: Vdr Addr3 | Derived
Vendor address line 3.
|
|
VEN-VDR-ADDR4
Element: Vdr Addr4 | Derived
Vendor address line 4.
|
|
VEN-VDR-CITY-ADDR5
Element: Vdr City Addr5 | Derived
Vendor city or address line 5.
|
|
VEN-VDR-STATE
Element: Vdr State | Derived
Vendor state or province.
|
|
VEN-VDR-POSTAL
Element: Vdr Postal | Derived
Vendor postal code.
|
|
VEN-VDR-COUNTY
Element: Vdr County | Derived
Vendor county.
|
|
VEN-VDR-COUNTRY
Element: Vdr Country | Derived
Vendor country.
|
|
VEN-VAT-NBR
Element: Vat Nbr | Derived
The concatenation of the VAT-REG-CTRY
and VAT-REG-NBR fields, used as VAT
reporting ID.
|
|
VEN-WORKFLOW-GROUP
Element: Workflow Group | Alpha 20
|
|
VEN-MBL-INT-PREFIX
Element: Mbl Int Prefix | Alpha 6
This field contains the country code of
the mobile phone number.
|
|
VEN-MOBILE-NUM
Element: Mobile Num | Alpha 15
This field contains the mobile phone
number.
|
|
VEN-MOBILE-EXT
Element: Mobile Ext | Alpha 5
This field contains the mobile phone
extension number.
|
|
VEN-PAY-IMM-FLAG
Element: All Flag | Alpha 1
|
|
VEN-DIVERSE-CODE
Element: Diverse Code | Alpha 5
Diversity Code for Account Payable
Vendors
|
|
VEN-INTM-BANK-ENT
Element: Bank Entity | Alpha 15
Type the intermediary bank
identification used to deposit
electronic payments for the vendor.
|
|
VEN-INTM-BANK-ACCT
Element: Bank Acct Nbr | Alpha 35
Type the intermediary bank account
number used to deposit electronic
payments for the vendor.
|
|
VEN-INTM-BANK-IDNT
Element: Intm Bank Idnt | Alpha 1
This field indicates if the account
number is and IBAN number that requires
an account validation check.
Y = Yes
N = No |
|
VEN-INTM-BANK-CURR
Element: Currency Code | Alpha 5
This field contains the intermediary
bank currency code.
|
|
VEN-INTM-PRENOT
Element: Ach Prenot | 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 |
|
VEN-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.
|
|
VEN-INTM-PMT-CAT
Element: Pmt Cat Code | Alpha 6
Select the Intermediary SWIFT payment
category.
G = Goods
T = Transit Trade
S = Service and Capital
X = Transfer
O = Other |
|
VEN-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 |
|
VEN-INTM-PMT-FORM
Element: Pmt Form | Alpha 2
Indicates how the Intermediary SWIFT
payment is made.
|
|
VEN-INTM-CHRG-CD
Element: Charge Code | Alpha 1
Indicates who pays service charges or
fees associated with a Intermediary
SWIFT payment.
|
|
VEN-INTM-CRS-IDENT
Element: Intm Crs Ident | Alpha 1
This field is used to distiguish between
SWIFT ID numbers and Routing numbers
S = Swift
R = Routing Number |
|
VEN-RULE-GROUP
Element: Rule Group | Alpha 10
|
|
VEN-FLOAT-DAYS
Element: Float Days | Numeric 3
This is the number of days to add to the
best terms calculation if the vendor
will allow a specific number of days for
the payment to reach them and still
receive the discount.
|
|
VEN-MTCH-PREPAY-FL
Element: Mtch Prepay Fl | Alpha 1
Flag that notes if the invoice will be
prepaid. This is for match invoices.
|
|
VEN-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 |
|
VEN-BUILD-SOC-REF
Element: Build Soc Ref | Alpha 18
This field holds an individual account
number reference for the Building
Society
|
|
VEN-BUILD-ACCT-NM
Element: Account Name | Alpha 18
|
|
VEN-XREF-FLAG
Element: Xref Flag | Alpha 1
Use a cross reference table for this
vendor
0 = Xref Vendor does not exist
1 = Xref record exist |
|
VEN-GIRO-NUMBER
Element: Giro Number | Alpha 15
This field is the Bankgiro or Postgiro
account number
|
|
VEN-CR-CARD-NUMBER
Element: Cr Card Number | Alpha 16
This field contains the credit card
number.
|
|
VEN-BANK-INSTRUCT1
Element: Bank Instruct1 | Alpha 35
This field contains bank instructions.
|
|
VEN-BANK-INSTRUCT2
Element: Bank Instruct2 | Alpha 35
This field contains bank instructions.
|
|
VEN-BANK-INSTRUCT3
Element: Bank Instruct3 | Alpha 35
This field contains bank instructions.
|
|
VEN-BANK-INSTRUCT4
Element: Bank Instruct4 | Alpha 35
This field contains bank instructions.
|
|
VEN-AP-OBJ-ID
Element: Obj Id | Numeric 12
This is the object identifier. It is
used to relate commitments or posted
transactions back to the originating
subsystems. Each subsystem record that
is updated as a commitment or posted
transaction is assigned an object
identifier. The object identifier is
maintained in the subsystem files and in
the Activity Commitments Detail and
Activity Transaction files. The object
identifier is a unique key used to drill
back from Activity Management to the
subsystems.
|
|
VEN-P-CARD-FLAG
Element: Flag Num | Numeric 1
0 = No
1 = Yes |
|
VEN-PCARD-NBR
Element: Pcard Nbr | Alpha 16
|
|
VEN-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
" " = No
Y = Yes |
|
VEN-RET-ACCR-CODE
Element: Accr Code | Alpha 4
|
|
VEN-GLN-NBR
Element: Gln Nbr | Alpha 13
|
|
VEN-TIN-TYPE
Element: Flag Num | Numeric 1
|
|
VEN-TIN-NOT
Element: Flag Num | Numeric 1
|
|
VEN-TIN-VERIFIED
Element: Flag Num | Numeric 1
|
|
VEN-SEC-WTH-EXEMPT
Element: Sec Wth Exempt | Alpha 1
Y = Yes
N = No |
|
VEN-SEC-WTH-CODE1
Element: Sec Wth Code | Alpha 10
|
|
VEN-SEC-WTH-CODE2
Element: Sec Wth Code | Alpha 10
|
|
VEN-SEC-WTH-CODE3
Element: Sec Wth Code | Alpha 10
|
|
VEN-CREATED-BY
Element: Operator | Alpha 10
|
|
VEN-LAST-UPDT-DATE
Element: Date | Numeric 8 (yyyymmdd)
|
|
VEN-LAST-UPDT-TIME
Element: Time | Numeric 8
|
|
VEN-LAST-UPDATE-BY
Element: Operator | Alpha 10
|
|
VEN-VALID-CERT-DT
Element: Flag | Alpha 1
|
|
VEN-FOR-ECON-CODE
Element: Code | Alpha 10
|
|
VEN-SOCIAL-ID1
Element: Social Id1 | Alpha 80 (Lower Case)
|
|
VEN-SOCIAL-ID2
Element: Social Id2 | Alpha 80 (Lower Case)
|
|
VEN-SOCIAL-ID3
Element: Social Id3 | Alpha 80 (Lower Case)
|
|
VEN-SOCIAL-ID4
Element: Social Id4 | Alpha 80 (Lower Case)
|
|
VEN-SOCIAL-ID5
Element: Social Id5 | Alpha 80 (Lower Case)
|
|
VEN-CARRIER-FLAG
Element: All Flag | Alpha 1
|
|
VEN-BANK-CODE
Element: Bank Code 2 | Alpha 2
|
|
VEN-BANK-ID
Element: Category | Alpha 9
|
|
VEN-ASSIGNMENT-NBR
Element: Assign Nbr | Alpha 14
|
|
VEN-DEBITING-SIGN
Element: Debiting Sign | Alpha 1
|
|
VEN-INTM-BANK-CODE
Element: Bank Code 2 | Alpha 2
|
|
VEN-INTM-BANK-ID
Element: Category | Alpha 9
|
|
VEN-INTM-ASSIGN-NO
Element: Assign Nbr | Alpha 14
|
|
VEN-INTM-DEBITING
Element: Debiting Sign | Alpha 1
|
|
VEN-CHK-DIG-TYPE
Element: Alpha 10 | Alpha 10
|
|
VEN-SEPA-FLAG
Element: Flag | Alpha 1
|
|
VEN-W8-VERIFIED
Element: Flag | Alpha 1
|
|
VEN-FATCA-ID
Element: Comp Pre | Alpha 6
|
|
VEN-FIN-INST-TYPE
Element: Contact Code | Alpha 5
|
|
VEN-GIIN-CAT-CODE
Element: Cont Status | Alpha 2
|
|
VEN-ISO-CTRY-NBR
Element: Iso Ctry Nbr | Numeric 3
|
|
VEN-FATCA-WITHOLD
Element: Percentile | Signed 7.4
|
|
VEN-FATCA-INC-CODE
Element: Income Code | Alpha 4
|
|
VEN-FATCA-AU
Element: Acct Unit | Alpha 15
|
|
VEN-FATCA-ACCOUNT
Element: Account | Numeric 6
|
|
VEN-FATCA-SUB-ACCT
Element: Sub Acct | Numeric 4
|
|
VEN-OPEN-ZERO-COST
Element: All Flag | Alpha 1
Use this field to indicate whether or
not the AP vendor will allow a zero-cost
invoice line to be left open up through
the matching process.
N = No
Y = Yes |
|
