|
|
APVENMAST FILE
Vendor
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.
REFERENCED BY
AC03.4 AC115 AC440 AC50.1 AC500 AC52.1
AC520 AM18.1 AP00.1 AP00.3 AP12.1 AP12.2
AP125 AP126 AP135 AP145 AP146 AP150
AP151 AP155 AP156 AP157 AP161 AP166
AP175 AP180 AP181 AP185 AP190 AP191
AP193 AP195 AP197 AP20.1 AP20.2 AP20.5
AP20.6 AP20.7 AP20.8 AP200 AP210 AP212
AP213 AP225 AP226 AP23.1 AP230 AP236
AP239 AP240 AP245 AP25.1 AP25.2 AP25.4
AP250 AP26.1 AP260 AP265 AP266 AP270
AP275 AP28.1 AP28.2 AP282 AP284 AP285
AP290 AP30.1 AP30.2 AP30.3 AP30.4 AP32.1
AP32.2 AP35.1 AP45.1 AP51.2 AP54.1 AP54.2
AP55.1 AP55.2 AP56.1 AP56.2 AP80.1 AP90.1
AP90.2 AP90.5 AP90.6 AP90.7 AP91.1 AP92.1
AP92.2 AP92.3 AP92.4 AP95.1 AP95.2 AP95.3
AR08.1 AR10.1 AR115 AR124 AR190 AR20.1
AR21.1 AR21.2 AR21.3 AR24.1 AR29.2 AR30.1
AR30.2 AR30.4 AR42.1 AR42.2 AR42.7 AR43.1
AR501 AR550 AR560 AR570 AR575 AR580
AR82.1 BL02.1 BL122 BL140 BL141 BL202
BL240 BL340 BL41.1 BL80.1 BL802 BL902
BL92.1 CB06.2 CB10.1 CB180 CB191 CB20.1
CB30.1 CB500 CX100 CX20.1 CX20.2 CX20.4
CX20.5 CX220 CX30.1 CX300 CX506 CXCP.1
DT180 DT181 EE12.1 EE12.2 EE135 EE175
EE20.1 EE20.2 EE20.3 EE20.4 EE220 EE230
EE235 EE275 EE30.1 EE35.1 EE35.2 EE520
EE90.1 EE90.2 GL284 GL285 DR100 IC10.1
IC10.2 IC12.1 IC140 IC141 IC142 IC145
IC16.4 IC226 IC263 IC45.1 IC522 IC526
IC527 IC530 IC531 IC62.1 IC63.1 IC81.1
IC81.2 IC812 IC82.1 IC83.1 IC840 IN120
IN20.1 MA140 MA190 MA278 MA300 MA40.1
MA40.2 MA41.1 MA41.2 MA41.3 MA41.4 MA41.5
MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1
MA520 MA530 MA540 MA95.1 MA95.2 OE10.1
OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7
OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110
OE112 OE113 OE114 OE129 OE13.1 OE14.4
OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7
OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6
OE30.7 OE30.9 OE510 OE810 OE830 OE920
OE950 PBIP.1 PO10.1 PO10.2 PO100 PO115
PO120 PO121 PO122 PO123 PO13.1 PO130
PO131 PO132 PO135 PO14.1 PO15.1 PO150
PO16.1 PO16.2 PO180 PO20.1 PO21.1 PO21.2
PO21.5 PO21.6 PO210 PO213 PO214 PO216
PO22.1 PO22.2 PO22.3 PO220 PO221 PO223
PO224 PO225 PO226 PO227 PO23.1 PO23.2
PO230 PO231 PO233 PO236 PO24.1 PO25.1
PO25.2 PO25.3 PO25.4 PO26.1 PO272 PO274
PO275 PO276 PO277 PO28.3 PO28.4 PO28.5
PO28.7 PO28.8 PO280 PO29.1 PO295 PO30.1
PO31.1 PO33.1 PO34.1 PO35.1 PO50.1 PO529
PO530 PO560 PO590 PO60.1 PO61.1 PO62.1
PO63.1 PO64.1 PO66.1 PO67.1 PO68.1 PO69.1
PO72.2 PO81.1 PO813 PO820 PO821 PO94.1
POA2.1 PR05.1 PR05.3 PR150 PR195 PR199
PR226 PR26.1 PR514 PR82.1 PR85.1 RQ10.1
RQ10.3 RQ11.1 RQ125 RQ20.1 RQ20.2 RQ20.3
RQ20.4 RQ35.1 RQ500 TX04.1 TX225 TX40.1
WH130 WH132 WH140 WH190 WH20.2 WH20.7
WH222 WH30.1 WH30.2 WH30.3 WH31.1 WH31.2
WH31.3 WH32.1 WH32.2 WH32.3 WH33.1 WH33.2
WH33.3 WH33.4 WH33.5 WH33.6 WH33.8 WH33.9
WH34.1 WH34.2 WH34.3 WH34.4 WH38.1 WH40.1
WH40.2 WH520 WH830 WO132 WO140 WO235
WO252 WO30.1 WO35.1 WO40.1 AP02.3 AP202
UPDATED BY
AP10.1 AP10.2 AP10.3 AP10.7 AP100 AP102
AP110 AP160 AP170 AP300 AP40.2 AP510
AP520 AP951 AR09.1 TX140
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
VEN-VENDOR-GROUP Alpha 4 AP10.1 AP10.3
Vendor Group The vendor group to which the vendor AP100 AP510
belongs. Must be a valid record in the AP520 AP951
Vendor Group file.
VEN-VENDOR Alpha 9 AP10.1 AP10.3
Vendor ID The identification number assigned to AP100 AP510
the vendor. AP520 AP951
VEN-VEN-CLASS Alpha 3 AP10.1 AP10.3
Vendor Class The vendor class the vendor is assigned AP100 AP510
to. Represents a group of vendors that AP520 AP951
share common characteristics within a
vendor group. Must be a valid record in
the Vendor Class file.
VEN-VENDOR-VNAME Alpha 30 (Lower Case) AP10.1 AP10.3
Vendor Name The vendor name or description. AP100 AP166
AP510 AP520
AP951 BL140
BL141 BL240
BL340 IC81.1
OE112 OE114
PO274 WH30.1
WH30.3 WH31.1
WH31.3 WH32.1
WH32.3 WH38.1
WH40.1 WH40.2
VEN-VENDOR-SNAME Alpha 30 AP10.1 AP10.3
Search Name The search name for the vendor. AP100 AP510
AP520 AP951
VEN-VENDOR-CONTCT Alpha 30 AP10.1 AP100
Contact The name of the main contact for the AP510 AP951
vendor.
VEN-ADDR1 Alpha 30 (Lower Case) AP10.1 AP10.3
Address 1 The first line of address information AP100 AP510
for the vendor. AP520 AP951
VEN-ADDR2 Alpha 30 (Lower Case) AP10.1 AP10.3
Address 2 The second line of address information AP100 AP510
for the vendor. AP520 AP951
VEN-ADDR3 Alpha 30 (Lower Case) AP10.1 AP10.3
Address 3 The third line of address information AP100 AP510
for the vendor. AP520 AP951
VEN-ADDR4 Alpha 30 (Lower Case) AP10.1 AP10.3
Address 4 The fourth line of address information AP100 AP510
for the vendor. AP520 AP951
VEN-CITY-ADDR5 Alpha 18 (Lower Case) AP10.1 AP10.3
City or Address 5 The city or fifth line of address AP100 AP510
information for the vendor. AP520 AP951
VEN-STATE-PROV Alpha 2 AP10.1 AP10.3
State or Province The state or province for the vendor AP100 AP510
address. AP520 AP951
VEN-POSTAL-CODE Alpha 10 (Lower Case) AP10.1 AP10.3
Postal Code The postal code for the vendor address. AP100 AP510
AP520 AP951
VEN-COUNTRY Alpha 30 (Lower Case) AP10.1 AP10.3
Country Name The country for the vendor address. Can AP100 AP510
also be used for additional information AP520 AP951
such as an attention name.
VEN-REMIT-TO-CODE Alpha 4 AP10.2 AP100
Normal Remit-To The normal remittance location for the AP510 AP951
Location 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 Alpha 4 AP10.2 AP100
Normal The normal purchasing location for the AP510 AP951
Purchase-From Locatiovendor, 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 Alpha 9 AP10.1 AP100
Pay Vendor The pay vendor for the vendor, if AP510 AP951
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 Alpha 1 AP10.1 AP10.3
Vendor Status The vendor status. Invoices cannot be AP100 AP510
entered for a vendor with an Inactive AP520 AP951
status. Valid values are:
A = Active.
I = Inactive.
VEN-VEN-PRIORITY Numeric 2 AP10.1 AP10.3
Vendor Priority The payment priority assigned to the AP100 AP110
vendor. Valid values are 1 (highest AP510 AP520
priority) through 99 (lowest priority). AP951
VEN-PHONE-PREFIX Alpha 6 AP10.1 AP100
Telephone Country The country code for the vendor AP510 AP951
Code telephone number.
VEN-PHONE-NUM Alpha 15 AP10.1 AP100
Telephone Number The telephone number for the vendor. AP510 AP951
VEN-PHONE-EXT Alpha 5 AP10.1 AP100
Telephone Extension The telephone extension number for the AP510 AP951
vendor.
VEN-FAX-PREFIX Alpha 6 AP10.1 AP100
Fax Country Code The country code for the fax machine AP510 AP951
telephone number.
VEN-FAX-NUM Alpha 15 AP10.1 AP100
Fax Number The fax machine telephone number. AP510 AP951
VEN-FAX-EXT Alpha 5 AP10.1 AP100
Fax Extension The fax machine telephone number AP510 AP951
extension.
VEN-TELEX-NUM Alpha 15 AP10.1 AP100
Telex Number The telex number for the vendor. AP510 AP951
VEN-TERM-CODE Alpha 5 AP10.1 AP100
Payment Terms The payment terms code assigned to the AP110 AP510
vendor. Used to automatically calculate AP951
invoice due date and discount
information for the vendor's invoices.
Must be a valid record in the Terms Code
file.
VEN-INV-CURRENCY Alpha 5 AP10.1 AP100
Invoice Currency The currency used to add invoices for AP110 AP510
the vendor. The currency code defaults AP951
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 Alpha 5 AP10.1 AP100
Balance Currency The currency used to store vendor AP510 AP951
balance information. Must be a valid
record in the Currency Code file. If
left blank, the company base currency is
used.
VEN-CURR-RECALC Alpha 1 AP10.1 AP100
Currency If the Invoice Currency is different AP510 AP951
Recalculation 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 Alpha 1 AP10.1 AP10.3
Separate Payment Indicates whether to create a separate AP100 AP510
payment for each invoice entered for the AP520 AP951
vendor. Valid values are:
N = No.
Y = Yes.
VEN-TAX-ID Alpha 20 AP10.1 AP100
Tax ID The tax identification number for the AP510 AP951
vendor. Used for reporting reportable
vendor income.
VEN-TAX-CODE Alpha 10 AP10.1 AP100
Tax Code The tax code assigned to the vendor. AP110 AP510
Used to automatically calculate invoice AP951 TX140
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 Alpha 1 AP10.1 AP100
On Hold Flag This field identifies whether the AP170 AP40.2
vendor is on hold. If this field is Yes, AP510 AP951
a corresponding hold record exists for
the vendor in the Hold file. Valid
values are:
Y = Yes.
Blank = The vendor is not on hold.
VEN-DIST-CODE Alpha 9 AP10.1 AP100
Distribution Code The distribution code assigned to the AP110 AP510
vendor. Used to automatically create AP951
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 Alpha 4 AP10.1 AP100
Invoice Accrual Code The invoice accrual code assigned to AP110 AP510
the vendor. Used to default a general AP951
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 Alpha 3 AP10.1 AP100
Payment Code The payment code assigned to the AP110 AP510
vendor. Represents a type of cash AP951
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 Alpha 4 AP10.1 AP100
Cash Code The cash code assigned to the vendor. AP110 AP125
Represents a bank account. Must be a AP126 AP151
valid record in the Cash Code file. If AP156 AP180
left blank, the cash code assigned to AP20.1 AP20.2
the vendor class, if assigned, defaults, AP20.5 AP20.7
or the vendor uses the cash code AP20.8 AP23.1
assigned to the company or the pay AP25.1 AP25.2
group. AP26.1 AP28.1
AP28.2 AP510
AP56.1 AP56.2
AP80.1 AP951
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
VEN-BANK-ENTITY Alpha 15 AP10.1 AP100
Bank The bank identification used to deposit AP510 AP951
electronic payments for the vendor. This
field is required for ACH or BACS
payment types.
VEN-VBANK-ACCT-NO Alpha 17 AP10.1 AP100
Vendor Bank Account The bank account number used to deposit AP510 AP951
Number electronic payments for the vendor. This
field is required for ACH or BACS
payment types.
VEN-VBANK-ACCT-TP Alpha 1 AP10.1 AP100
Vendor Bank Account Indicates the type of bank account used AP510 AP951
Type to deposit electronic payments for the
vendor. Valid values are:
C = Current/Checking Account.
S = Savings Account.
Blank = Electronic payment type not
selected.
VEN-INCOME-CODE Alpha 4 AP10.1 AP100
Income Code The income code assigned to the vendor. AP110 AP510
Used to track reportable income for the AP951
vendor. Must be a valid record in the
Income Code file.
VEN-INCOME-WH-FLG Alpha 1 AP10.1 AP10.3
Income Withholding Indicates whether invoices for the AP100 AP510
vendor are subject to reportable income AP520 AP951
withholding. Valid values are:
N = No.
Y = Yes.
VEN-EDI-NBR Alpha 15 AP10.1 AP100
EDI Number The vendor's electronic data AP510 AP951
interchange (EDI) number. Used for
reference.
VEN-ACH-PRENOT Alpha 1 AP10.1 AP100
ACH Prenotification Used in conjunction with ACH payments AP110 AP160
Status created for the vendor. Indicates the AP510 AP951
status of the electronic payment between
the vendor and the processing bank.
Valid values are:
N = Notified. AP160 (Payment Tape
Creation) 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 Signed 15.2 AP10.1 AP100
Maximum Invoice The maximum single invoice amount that AP510 AP951
Amount can be entered for the vendor.
VEN-CREATE-DATE Numeric 8 (yyyymmdd) AP10.1 AP10.3
Creation Date The date the vendor record was created AP100 AP510
in the Lawson Accounts Payable system. AP520 AP951
VEN-ORIGIN-DATE Numeric 8 (yyyymmdd) AP10.1 AP10.3
Origin Date The origin date for the vendor. Can be AP100 AP510
used record additional information, such AP520 AP951
as the date the vendor relationship
began. If left blank, the system date
defaults.
VEN-OPERATOR Alpha 10 AP10.1 AP10.3
Operator Code The operator associated with AP100 AP510
maintaining the vendor record. AP951
VEN-USER-NAME-01 Alpha 15 AP10.1 AP100
User Defined Field 1 The value of the information being AP510 AP951
tracked for the vendor in the first
vendor group user field.
VEN-USER-NAME-02 Alpha 15 AP10.1 AP100
User Defined Field 2 The value of the information being AP510 AP951
tracked for the vendor in the second
vendor group user field.
VEN-USER-NAME-03 Alpha 15 AP10.1 AP100
User Defined Field 3 The value of the information being AP510 AP951
tracked for the vendor in the third
vendor group user field.
VEN-USER-NAME-04 Alpha 15 AP10.1 AP100
User Defined Field 4 The value of the information being AP510 AP951
tracked for the vendor in the fourth
vendor group user field.
VEN-USER-NAME-05 Alpha 15 AP10.1 AP100
User Defined Field 5 The value of the information being AP510 AP951
tracked for the vendor in the fifth
vendor group user field.
VEN-USER-NAME-06 Alpha 15 AP10.1 AP100
User Defined Field 6 The value of the information being AP510 AP951
tracked for the vendor in the sixth
vendor group user field.
VEN-CUST-GROUP Alpha 5 AP10.1 AP100
Customer Group If the accounts payable vendor is also AP951 AR09.1
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 Alpha 9 (Right Justified) AP10.1 AP100
Customer If the accounts payable vendor is also AP951 AR09.1
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 Alpha 30 (Lower Case) AP10.1 AP100
Legal Name The legal name for the vendor. Used for AP510 AP951
reporting reportable vendor income. If
left blank, the Vendor Name defaults.
VEN-PRIME-RATE Signed 7.5 AP10.1 AP100
Anticipation The percentage used to calculate AP510 AP951
Discount Rate anticipation discount invoices; most
often the prime rate plus one percent.
To calculate the discount for an
anticipation invoice, the system
subtracts the invoice payment date from
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 the Lawson Terms system.
VEN-INVOICE-GROUP Alpha 4 AP10.1 AP100
Invoice Group A user-defined invoice group assigned AP510 AP951
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 Alpha 10 AP10.1 AP100
Discount Code The discount code assigned to the AP110 AP510
vendor. Used to default a general ledger AP951
discount account on the vendor's
invoices during entry. Must be a valid
record in the Discount Code file.
VEN-RET-INV-METH Alpha 1 AP10.1 AP100
Returns Invoicing This field indicates whether a AP510 AP951
Method replacement type return is shipped at no
charge, or whether the vendor credits
the return and invoices the replacement
shipment. Valid values are:
C = Credit/Rebill.
N = No Charge.
VEN-RET-MEMO-FL Alpha 1 AP10.1 AP100
Returns Credit Memo Indicates whether to reduce the AP510 AP951
vendor's payment for an item that is
returned to the vendor. Valid values
are:
N = No.
Y = Yes.
Blank = No.
VEN-ERS-CAPABLE Alpha 1 AP10.1 AP100
ERS Capable Indicates whether the vendor location AP510 AP951
has the capability to process ERS. Valid
values are:
N = No.
Y = Yes.
VEN-INVC-REF-TYPE Alpha 2 AP10.1 AP100
ERS Invoice Indicates the type of number the vendor AP510 AP951
Reference 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 = Work Order Number.
WP = Warehouse Pick Ticket Number.
ZZ = Mutually Defined Number.
VEN-ERS-AUTO-REL Alpha 1 AP10.1 AP100
ERS Invoice Auto Indicates whether the company AP510 AP951
Release automatically releases invoices created
from receipts in the evaluated receipts
settlements process (pay on receipt).
Valid values are:
N = No.
Y = Yes.
VEN-EDI-AUTO-REL Alpha 1 AP10.1 AP100
EDI Invoice Auto If interfacing EDI invoices for the AP510 AP951
Release vendor using MA540 (EDI Line Level
Match), this field indicates whether to
interface invoices in a released status.
If this field is Yes, then invoices that
are matched or interfaced cleanly are
interfaced to Accounts Payable in a
released status. Valid values are:
N = No.
Y = Yes.
VEN-AUTH-CODE Alpha 3 AP10.1 AP100
Authority Code The authority code assigned to the AP110 AP510
vendor, if assigned. Represents a person AP951
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 Alpha 1 AP10.7 AP100
Approval Indicates whether approval criteria is AP951
Information Exists 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 Alpha 15 AP10.1 AP100
Activity The activity assigned to the vendor, if AP110 AP510
assigned. Activities are the tasks that AP951
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 Alpha 5 AP10.1 AP100
Account Category The account category assigned to the AP110 AP510
vendor. Account categories are the AP951
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 Alpha 1 AP10.1 AP100
Charge Code Indicates who pays service charges or AP510 AP951
fees associated with a SWIFT payment.
Valid values are:
I = Issuer.
R = Receiver.
Blank = Not defined for the vendor.
VEN-PMT-CAT-CODE Alpha 1 AP10.1 AP100
Payment Category Indicates the payment category of the AP510 AP951
Code 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 Alpha 1 AP10.1 AP100
Normal or Express Indicates whether the SWIFT payment is AP510 AP951
Code a normal or express payment. Valid
values are:
N = Normal.
E = Express.
Blank = Not defined for the vendor.
VEN-PMT-FORM Alpha 1 AP10.1 AP100
Payment Form Indicates how the SWIFT payment is AP510 AP951
made. Valid values are:
C = Check.
B = Foreign Bank.
Blank = Not defined for the vendor.
VEN-SWIFT-ID Alpha 12 AP10.1 AP100
Swift ID The SWIFT identification number AP510 AP951
assigned to the vendor.
VEN-PROC-GRP Alpha 4 (Lower Case) AP10.1 AP102
Process Group A process group is an identifier used
for separating vendors into different
groups to enable concurrent processing
within the cash payment cycle.
VEN-LOC-INDICATOR Derived
Locations Exist When selecting a vendor from a list of
available vendors, an asterisk (*)
displays if alternate locations exist
for a vendor.
VEN-SHORT-VNAME Derived
Short Vendor Name A short name for the vendor. Used for
display purposes.
VEN-VCOMMENT-EXIST Derived
Vendor Comments When selecting a vendor from a list of
Exist available vendors, an asterisk (*)
displays if comments exist for a vendor.
VEN-TAX-USAGE-CD Alpha 10 AP10.1
Tax Usage Code The tax usage code for the vendor.
This field is required if the AP Company
indicates that VAT reporting required
VEN-COUNTRY-CODE Alpha 2 AP10.1 AP10.3
Country Code The country code. Required for VAT and AP510 AP520
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
VEN-REGION Alpha 2 AP10.1 AP10.3
Region The region code, if applicable for the AP510 AP520
country. Used only by Intrastat. Must be
defined in IN02.1 (Region Maintenance).
VEN-VAT-REG-CTRY Alpha 2 AP10.1 AP10.3
VAT Registration The country component of the VAT AP510
Country Registration Number. This field,
together with the Registration Number
for the company on the tax transaction.
VEN-VAT-REG-NBR Alpha 12 AP10.1 AP10.3
VAT Registration The number component of the VAT AP510
Number Registration Number. This field together
with the Registration Country field make
up the VAT Registration Number.
VEN-VAT-NBR Derived
VAT Number The concatenation of the VAT-REG-CTRY
and VAT-REG-NBR fields, used as VAT
reporting ID.
VEN-LANGUAGE-CODE Alpha 10 AP10.1 AP510
Language Code The language code representing the
vendor's preferred language. Must be
defined in GL19.1 (Language Code
Maintenance) as well as in the langdef
environment. If no language code is
specified, the default language at the
site is assumed.
APVENMAST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
VENSET1 VENDOR-GROUP This index is used to access and AC03.4 AC115
VENDOR validate vendor records for a specific AC440 AC50.1
vendor group. AC500 AC52.1
AC520 AM18.1
AP00.1 AP10.1
AP10.2 AP10.3
AP10.5 AP10.6
AP10.7 AP100
AP102 AP110
AP12.1 AP12.2
AP125 AP126
AP135 AP145
AP146 AP150
AP151 AP155
AP156 AP157
...
VENSET2 VENDOR-GROUP This index is used to access vendor AP00.3 AP100
VEN-CLASS records within a specific vendor class AP102 AP110
VENDOR for a vendor group. AP300
KeyChange
VENSET3 VENDOR-GROUP This index is used to access vendor
USER-NAME-01 records by using the first vendor group
VENDOR-SNAME user-defined field.
VENDOR
KeyChange
VENSET4 VENDOR-GROUP This index is used to access vendor
VEN-CLASS records within a specific vendor class
VENDOR-SNAME in search name sequence.
VENDOR
KeyChange
VENSET5 VENDOR-GROUP This index is used to access vendor AP10.1 AP200
VENDOR-SNAME records in search name sequence.
VENDOR
KeyChange
VENSET6 PROC-GRP This index is used to access vendors AP02.3 AP202
VENDOR-GROUP not on hold or vendors assigned a
VENDOR specific hold code.
KeyChange
VENSET7 VENDOR-GROUP This index is used to access and AC03.4 AC115
EDI-NBR validate vendor records by EDI number. AC440 AC50.1
VENDOR AC500 AC52.1
KeyChange AC520 AM18.1
AP125 AP126
AP170 AP180
AP181 AP190
AP193 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 AP520
AR08.1 AR10.1
AR115 AR124
AR190 AR20.1
AR21.1 AR21.2
...
VENSET8 VENDOR-GROUP This index is used to access vendor AP160
VENDOR records set up for ACH processing that
have not been prenotified.
Subset
Where ACH-PRENOT = "N"
Or ACH-PRENOT = "P"
APVENMAST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Approcgrp APPROCGRP Not Required
VEN-PROC-GRP -> APQ-PROC-GRP
Apvengroup APVENGROUP Required
VEN-VENDOR-GROUP -> VGP-VENDOR-GROUP
APVENMAST FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apaudit APAUDIT
VEN-VENDOR-GROUP -> APA-VENDOR-GROUP
Zeroes -> APA-COMPANY
Spaces -> APA-PROC-LEVEL
VEN-VENDOR -> APA-VENDOR
Spaces -> APA-INVOICE
Zeroes -> APA-SUFFIX
Zeroes -> APA-CANCEL-SEQ
APA-SEQ-NBR
APA-TRANS-DATE
APA-TRANS-TIME
Apcomments APCOMMENTS Delete Cascades
"V" -> APC-REC-TYPE
VEN-VENDOR-GROUP -> APC-VENDOR-GROUP
VEN-VENDOR -> APC-VENDOR
APC-LOCATION-CODE
APC-COMPANY
APC-INVOICE
APC-SUFFIX
APC-SEQ-NBR
Apcompany APCOMPANY
VEN-VENDOR-GROUP -> CPY-VENDOR-GROUP
CPY-COMPANY
Apcpyvnd APCPYVND
VEN-VENDOR-GROUP -> APX-VENDOR-GROUP
VEN-VENDOR -> APX-VENDOR
Spaces -> APX-LOCATION-CODE
APX-COMPANY
Aphldinv APHLDINV Delete Cascades
Valid When (VEN-HOLD-FLAG = "Y" )
"V" -> HLI-REC-TYPE
VEN-VENDOR-GROUP -> HLI-VENDOR-GROUP
Zeroes -> HLI-COMPANY
VEN-VENDOR -> HLI-VENDOR
HLI-INVOICE
HLI-SUFFIX
HLI-CANCEL-SEQ
HLI-SEQ-NBR
HLI-VOID-SEQ
HLI-HLD-CODE
Apinvoice APINVOICE
VEN-VENDOR-GROUP -> API-VENDOR-GROUP
VEN-VENDOR -> API-VENDOR
API-INVOICE
API-SUFFIX
API-CANCEL-SEQ
API-COMPANY
Apvcomments APCOMMENTS
"V" -> APC-REC-TYPE
VEN-VENDOR-GROUP -> APC-VENDOR-GROUP
VEN-VENDOR -> APC-VENDOR
Spaces -> APC-LOCATION-CODE
APC-COMPANY
APC-INVOICE
APC-SUFFIX
APC-SEQ-NBR
Apvenbal APVENBAL Delete Cascades
VEN-VENDOR-GROUP -> VBA-VENDOR-GROUP
VEN-VENDOR -> VBA-VENDOR
VBA-COMPANY
VBA-LOCATION-CODE
Apvenbalmaster APVENBAL Delete Cascades
VEN-VENDOR-GROUP -> VBA-VENDOR-GROUP
VEN-VENDOR -> VBA-VENDOR
Spaces -> VBA-LOCATION-CODE
VBA-COMPANY
Apvendorbal APVENBAL
VEN-VENDOR-GROUP -> VBA-VENDOR-GROUP
VEN-VENDOR -> VBA-VENDOR
VBA-LOCATION-CODE
VBA-COMPANY
Apvenloc APVENLOC Delete Cascades
VEN-VENDOR-GROUP -> VLO-VENDOR-GROUP
VEN-VENDOR -> VLO-VENDOR
VLO-LOCATION-CODE
Cbcheck CBCHECK
VEN-VENDOR-GROUP -> CHK-VENDOR-GROUP
VEN-VENDOR -> CHK-PAID-VENDOR
CHK-COMPANY
CHK-CHECK-DATE
CHK-BANK-INST-CODE
CHK-TRANS-IDENT
|