Lawson Insight Technical Documentation |
|
APVENMAST
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
AC210 AM18.1 AP00.1 AP00.3 AP109 AP111
AP12.1 AP13.2 AP130 AP135 AP136 AP14.1
AP14.2 AP14.3 AP14.4 AP141 AP145 AP146
AP150 AP151 AP155 AP156 AP16.1 AP16.2
AP161 AP162 AP166 AP175 AP176 AP178
AP180 AP181 AP185 AP190 AP191 AP193
AP195 AP197 AP200 AP211 AP212 AP213
AP221 AP230 AP235 AP236 AP237 AP240
AP245 AP250 AP251 AP252 AP266 AP270
AP272 AP275 AP28.1 AP28.2 AP282 AP284
AP290 AP295 AP32.1 AP35.1 AP36.2 AP41.1
AP45.1 AP51.2 AP51.3 AP52.7 AP54.1 AP55.1
AP55.2 AP56.1 AP56.2 AP62.1 AP80.1 AP810
AP92.1 AP92.2 AP92.3 AP92.4 AP93.1 AP93.2
AP93.3 AP93.4 AP95.1 AP95.2 AP95.3 AP96.1
CB06.2 CB50.1 CB500 CB54.1 CB55.1 CB554
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 ET175 GL284
GL285 IAVO.1 MA00.1 MA167 MA168 MA236
MA278 MA540 MA64.1 MA64.4 MA64.6 MA90.1
MA90.2 MA90.3 MA90.5 MA91.1 MA95.1 MA95.2
PD21.1 PO132 PO150 PO204 PO226 PO227
PO231 PO53.4 PO58.2 PR198 MM280 MM80.2
RQ11.1 RQ12.1 RQ13.1 RQ13.2 RQ35.1 RQ500
RQIB.1 RQIC.1 RQID.1 RQIF.1 RQIG.1 RQIJ.1
IN120 IN20.1 WH30.4 WH31.4 WH32.4 WH38.1
WH40.1 WH40.2 MX223 ET700 AP02.3 AP202
MA05.1 MA05.2
UPDATED BY
AC160 AM115 AM117 AM15.1 AM15.2 AM15.3
AM15.4 AM19.1 AM19.2 AM20.1 AM20.3 AM21.1
AM21.3 AM500 AM51.1 AM551 AM97.1 AP03.3
AP10.3 AP10.7 AP100 AP102 AP11.1 AP110
AP115 AP125 AP126 AP131 AP15.1 AP160
AP170 AP20.1 AP20.2 AP20.3 AP20.4 AP20.5
AP20.7 AP21.1 AP210 AP220 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.2 AP30.4 AP300
AP305 AP40.2 AP510 AP520 AP90.1 AP91.1
API1.1 API2.1 API3.1 API4.1 AR09.1 BL120
BL122 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL520 BL820 BL92.1 MX123
MX500 MA180 MA279 MA41.1 MA41.2 MA41.4
MA41.7 MA43.1 MA43.2 MA43.3 MA43.4 MA43.6
MA43.7 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA63.1 MA65.1 MA66.2 MA66.3 MA67.2
MA67.3 MA67.1 MA68.2 MA68.3 MA68.5 MA70.1
MA75.1 MA80.1 MAI1.1 PD10.1 PD10.2 PD130
PD20.1 PD20.2 PD20.3 PD235 PO10.1 PO100
PO101 PO120 PO122 PO131 PO20.1 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO220
PO223 PO23.1 PO233 PO24.1 PO25.1 PO25.5
PO25.6 PO25.7 PO253 PO254 PO27.2 PO278
PO29.1 PO30.1 PO30.2 PO30.3 PO300 PO31.1
PO31.2 PO32.2 PO32.4 PO33.1 PO34.1 PO35.1
PO36.1 PO36.2 PO38.1 PO39.1 PO39.2 PO44.1
PO50.1 PO52.1 PO520 PO536 PO54.1 PO54.2
PO54.3 PO54.4 POI3.1 POID.1 POII.1 POIJ.1
PR05.1 PR05.3 PR226 PR247 PR26.1 PR47.1
PR514 UK47.1 RQ10.1 RQ10.2 TX140 WH20.2
WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
VEN-VENDOR-GROUP Alpha 4 AC160 AM115
Element: Vendor Group The vendor group to which the vendor AM117 AM15.1
belongs. Must be a valid record in the AM15.2 AM15.3
Vendor Group file. AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP10.3 AP100
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
...
VEN-VENDOR Alpha 9 (Right Justified) AC160 AM115
Element: Vendor The identification number assigned to AM117 AM15.1
the vendor. AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP10.3 AP100
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
...
VEN-VEN-CLASS Alpha 3 AC160 AM115
Element: Vendor Class The vendor class the vendor is assigned AM117 AM15.1
to. Represents a group of vendors that AM15.2 AM15.3
share common characteristics within a AM15.4 AM19.1
vendor group. Must be a valid record in AM19.2 AM20.1
the Vendor Class file. AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP10.3 AP100
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
...
VEN-VENDOR-VNAME Alpha 30 (Lower Case) AC160 AM115
Element: Vendor Name The vendor name or description. AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP10.3 AP100
AP110 AP115
AP125 AP126
AP131 AP166
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
...
VEN-VENDOR-SNAME Alpha 30 AC160 AM115
Element: Search Name The search name for the vendor. AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP10.3 AP100
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
...
VEN-VENDOR-CONTCT Alpha 30 AC160 AM115
Element: Contact The name of the main contact for the AM117 AM15.1
vendor. AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-REMIT-TO-CODE Alpha 4 AC160 AM115
Normal Remit-To The normal remittance location for the AM117 AM15.1
Location vendor, if defined. Must be a valid AM15.2 AM15.3
record in the Vendor Location file. If AM15.4 AM19.1
present, the address defined for the AM19.2 AM20.1
location overrides the vendor address on AM20.3 AM21.1
vendor payments when invoices are added. AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-PURCH-FR-LOC Alpha 4 AC160 AM115
Normal The normal purchasing location for the AM117 AM15.1
Purchase-From Location vendor, if defined. Must be a valid AM15.2 AM15.3
record in the Vendor Location file. If AM15.4 AM19.1
present, the address defined for the AM19.2 AM20.1
location overrides the vendor address AM20.3 AM21.1
for storing vendor purchase activity AM21.3 AM500
balances. AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-PAY-VENDOR Alpha 9 (Right Justified) AC160 AM115
Element: Pay Vendor The pay vendor for the vendor, if AM117 AM15.1
applicable. Used to send invoice AM15.2 AM15.3
payments to another vendor within the AM15.4 AM19.1
same vendor group. If present, the pay AM19.2 AM20.1
vendor relationship overrides the normal AM20.3 AM21.1
remit-to information for the vendor, AM21.3 AM500
including remit-to name and address, AM51.1 AM551
cash code, and payment code. Must be a AM97.1 AP03.3
valid record in the Vendor file. AP10.3 AP100
AP11.1 AP110
Although payments are remitted to the AP115 AP125
pay vendor, the invoiced vendor AP126 AP131
accumulates the payment balance. If more AP20.1 AP20.2
than one vendor shares the same pay AP20.3 AP20.4
vendor, the system creates a single AP20.5 AP20.7
payment for the pay vendor and lists AP21.1 AP210
individual invoiced vendors and invoice AP220 AP23.1
numbers that are included in the payment AP25.1 AP25.2
on the remittance. AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
...
VEN-VENDOR-STATUS Alpha 1 AC160 AM115
Element: Status The vendor status. Invoices cannot be AM117 AM15.1
entered for a vendor with an Inactive AM15.2 AM15.3
status. Valid values are: AM15.4 AM19.1
AM19.2 AM20.1
A = Active. AM20.3 AM21.1
I = Inactive. AM21.3 AM500
D = Inactive for PO additions AM51.1 AM551
AM97.1 AP03.3
AP10.3 AP100
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
...
VEN-VEN-PRIORITY Numeric 2 AC160 AM115
Element: Priority The payment priority assigned to the AM117 AM15.1
vendor. Valid values are 1 (highest AM15.2 AM15.3
priority) through 99 (lowest priority). AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
...
VEN-PHONE-PREFIX Alpha 6 AC160 AM115
Element: Phone Prefix The country code for the vendor AM117 AM15.1
telephone number. AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-PHONE-NUM Alpha 15 AC160 AM115
Element: Phone The telephone number for the vendor. AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-PHONE-EXT Alpha 5 AC160 AM115
Element: Phone Ext The telephone extension number for the AM117 AM15.1
vendor. AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-FAX-PREFIX Alpha 6 AC160 AM115
Element: Phone Prefix The country code for the fax machine AM117 AM15.1
telephone number. AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-FAX-NUM Alpha 15 AC160 AM115
Element: Phone The fax machine telephone number. AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-FAX-EXT Alpha 5 AC160 AM115
Element: Phone Ext The fax machine telephone number AM117 AM15.1
extension. AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-TELEX-NUM Alpha 15 AC160 AM115
Element: Telex The telex number for the vendor. AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-TERM-CODE Alpha 5 AC160 AM115
Element: Payment Terms The payment terms code assigned to the AM117 AM15.1
vendor. Used to automatically calculate AM15.2 AM15.3
invoice due date and discount AM15.4 AM19.1
information for the vendor's invoices. AM19.2 AM20.1
Must be a valid record in the Terms Code AM20.3 AM21.1
file. AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-INV-CURRENCY Alpha 5 AC160 AM115
Element: Invoice CurrenThe currency used to add invoices for AM117 AM15.1
the vendor. The currency code defaults AM15.2 AM15.3
on the vendor's invoices during entry. AM15.4 AM19.1
Must be a valid record in the Currency AM19.2 AM20.1
Code file. If left blank, the vendor AM20.3 AM21.1
uses the invoice currency assigned to AM21.3 AM500
the vendor class, if assigned, or the AM51.1 AM551
company base currency. AM97.1 AP03.3
AP100 AP110
If the Balance Currency field contains AP115 AP125
a non-base currency, the Invoice AP126 AP131
Currency must be either the same AP20.1 AP20.2
non-base currency or the company base AP20.3 AP20.4
currency. If the Balance Currency field AP20.5 AP20.7
contains the company base currency, the AP21.1 AP210
Invoice Currency can be a non-base AP220 AP23.1
currency. AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-BAL-CURRENCY Alpha 5 AC160 AM115
Element: Vendor BalanceThe currency used to store vendor AM117 AM15.1
balance information. Must be a valid AM15.2 AM15.3
record in the Currency Code file. If AM15.4 AM19.1
left blank, the company base currency is AM19.2 AM20.1
used. AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-CURR-RECALC Alpha 1 AC160 AM115
Currency If the Invoice Currency is different AM117 AM15.1
Recalculation from the company base currency, this AM15.2 AM15.3
field indicates whether the system will AM15.4 AM19.1
recalculate the invoice currency when AM19.2 AM20.1
the invoice is paid to account for AM20.3 AM21.1
exchange rate fluctuations. If Yes is AM21.3 AM500
selected in this field, the system AM51.1 AM551
compares the exchange rate in effect AM97.1 AP03.3
when the invoice was entered to the AP10.3 AP100
exchange rate in effect when the invoice AP110 AP115
is scheduled for payment by AP150 (Cash AP125 AP126
Requirements). If a difference exists, AP131 AP20.1
AP170 (Payment Closing) creates a AP20.2 AP20.3
currency gain or loss transaction. Valid AP20.4 AP20.5
values are: AP20.7 AP21.1
AP210 AP220
N = No. AP23.1 AP25.1
Y = Yes. AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
...
VEN-SEP-CHK-FLAG Alpha 1 AC160 AM115
Element: Separate PaymeIndicates whether to create a separate AM117 AM15.1
payment for each invoice entered for the AM15.2 AM15.3
vendor. Valid values are: AM15.4 AM19.1
AM19.2 AM20.1
N = No. AM20.3 AM21.1
Y = Yes. AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP10.3 AP100
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
...
VEN-TAX-ID Alpha 20 AC160 AM115
Element: Tax Id The tax identification number for the AM117 AM15.1
vendor. Used for reporting reportable AM15.2 AM15.3
vendor income. AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP10.3 AP100
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
...
VEN-TAX-EXEMPT-CD Alpha 1 AC160 AM115
Element: Tax Exempt Cd Code indicating the taxing status. E - AM117 AM15.1
Exempt, T - Taxable. AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
VEN-TAX-CODE Alpha 10 AC160 AM115
Element: Tax Code The tax code assigned to the vendor. AM117 AM15.1
Used to automatically calculate invoice AM15.2 AM15.3
tax information. Must be a valid record AM15.4 AM19.1
in the Tax Code file. If left blank, the AM19.2 AM20.1
tax code assigned to the vendor class AM20.3 AM21.1
defaults. AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-HOLD-FLAG Alpha 1 AC160 AM115
Element: Hold Code This field enables this entire lot to AM117 AM15.1
be put on hold, not allowing any issues AM15.2 AM15.3
or transfers to be made for this lot. AM15.4 AM19.1
Y = Yes AM19.2 AM20.1
" " AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP170 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP40.2 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
...
VEN-DIST-CODE Alpha 9 AC160 AM115
Element: Distribution CThe distribution code assigned to the AM117 AM15.1
vendor. Used to automatically create AM15.2 AM15.3
distribution lines for the vendor's AM15.4 AM19.1
invoices. Must be a valid record in the AM19.2 AM20.1
Distribution Code file. If left blank, AM20.3 AM21.1
the distribution code assigned to the AM21.3 AM500
vendor class, if assigned, defaults. AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-ACCR-CODE Alpha 4 AC160 AM115
Element: Invoice AccruaThe invoice accrual code assigned to AM117 AM15.1
the vendor. Used to default a general AM15.2 AM15.3
ledger accrual account to the vendor's AM15.4 AM19.1
invoices during entry. Must be a valid AM19.2 AM20.1
record in the Invoice Accrual Code file. AM20.3 AM21.1
If left blank, the invoice accrual code AM21.3 AM500
assigned to the vendor class, if AM51.1 AM551
assigned, or the company defaults. AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-BANK-INST-CODE Alpha 3 AC160 AM115
Element: Payment Code The payment code assigned to the AM117 AM15.1
vendor. Represents a type of cash AM15.2 AM15.3
payment, such as a check or payment AM15.4 AM19.1
tape, or a bill of exchange payment. AM19.2 AM20.1
Must be a valid cash or bill of exchange AM20.3 AM21.1
payment transaction code record in the AM21.3 AM500
Bank Transaction Code file. AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-CASH-CODE Alpha 4 AC160 AM115
Element: Cash Code The cash code assigned to the vendor. AM117 AM15.1
Represents a bank account. Must be a AM15.2 AM15.3
valid record in the Cash Code file. If AM15.4 AM19.1
left blank, the cash code assigned to AM19.2 AM20.1
the vendor class, if assigned, defaults, AM20.3 AM21.1
or the vendor uses the cash code AM21.3 AM500
assigned to the company or the pay AM51.1 AM551
group. AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP151 AP156
AP180 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP20.8
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP510
AP56.1 AP56.2
AP80.1 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
...
VEN-BANK-ENTITY Alpha 15 AC160 AM115
Element: Bank The bank identification used to deposit AM117 AM15.1
electronic payments for the vendor. This AM15.2 AM15.3
field is required for ACH or BACS AM15.4 AM19.1
payment types. AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-BANK-CURRENCY Alpha 5 AC160 AM115
Element: Currency Code This field contains the bank currency AM117 AM15.1
code AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
VEN-VBANK-ACCT-NO Alpha 35 AC160 AM115
Element: Bank Acct Nbr The bank account number used to deposit AM117 AM15.1
electronic payments for the vendor. This AM15.2 AM15.3
field is required for ACH or BACS AM15.4 AM19.1
payment types. AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-VBANK-ACCT-TP Alpha 1 AC160 AM115
Element: Vbank Acct Tp Indicates the type of bank account used AM117 AM15.1
to deposit electronic payments for the AM15.2 AM15.3
vendor. Valid values are: AM15.4 AM19.1
AM19.2 AM20.1
C = Current/Checking Account. AM20.3 AM21.1
S = Savings Account. AM21.3 AM500
Blank = Electronic payment type not AM51.1 AM551
selected. AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-VBANK-IDENT Alpha 1 AC160 AM115
Element: Vbank Ident This field indicates if the account AM117 AM15.1
number is an IBAN number that requires AM15.2 AM15.3
an account validation check. AM15.4 AM19.1
Y = Yes AM19.2 AM20.1
N = No AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
VEN-CROSS-IDENT Alpha 1 AP510
Element: Cross Ident This field is used to distinguish
between SWIFT ID numbers and Routing
numbers.
S = SWIFT
R = Routing Number
VEN-INCOME-CODE Alpha 4 AC160 AM115
Element: Income Code The income code assigned to the vendor. AM117 AM15.1
Used to track reportable income for the AM15.2 AM15.3
vendor. Must be a valid record in the AM15.4 AM19.1
Income Code file. AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP10.3 AP100
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
...
VEN-INCOME-WH-FLG Alpha 1 AC160 AM115
Element: Income WithholIndicates whether invoices for the AM117 AM15.1
vendor are subject to reportable income AM15.2 AM15.3
withholding. Valid values are: AM15.4 AM19.1
AM19.2 AM20.1
N = No. AM20.3 AM21.1
Y = Yes. AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP10.3 AP100
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
...
VEN-EDI-NBR Alpha 15 AC160 AM115
Element: EDI Number The vendor's electronic data AM117 AM15.1
interchange (EDI) number. Used for AM15.2 AM15.3
reference. AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-ACH-PRENOT Alpha 1 AC160 AM115
Element: Ach Prenot Used in conjunction with ACH payments AM117 AM15.1
created for the vendor. Indicates the AM15.2 AM15.3
status of the electronic payment between AM15.4 AM19.1
the vendor and the processing bank. AM19.2 AM20.1
Valid values are: AM20.3 AM21.1
AM21.3 AM500
N = Notified. Payment Tape Creation AM51.1 AM551
(AP160) automatically changes the status AM97.1 AP03.3
from Prenotified to Notified to indicate AP100 AP110
that the processing bank has been AP115 AP125
notified but has not yet accepted the AP126 AP131
electronic payment tape. AP160 AP20.1
AP20.2 AP20.3
P = Prenotified. Select this status AP20.4 AP20.5
when first entering ACH information to AP20.7 AP21.1
prenotify the processing bank. AP210 AP220
AP23.1 AP25.1
A = Accepted. Change the status to AP25.2 AP26.1
Accepted once the processing bank AP27.1 AP30.2
accepts the electronic payment tape. AP30.4 AP305
AP510 AP90.1
Blank = ACH payment type not selected. AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
...
VEN-MAX-INV-AMT Signed 18.2 AC160 AM115
Maximum Invoice The maximum single invoice amount that AM117 AM15.1
Amount can be entered for the vendor. AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-CREATE-DATE Numeric 8 (yyyymmdd) AC160 AM115
Element: Create Date The date the vendor record was created AM117 AM15.1
in Accounts Payable. AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP10.3 AP100
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
...
VEN-ORIGIN-DATE Numeric 8 (yyyymmdd) AC160 AM115
Element: Date The origin date for the vendor. Can be AM117 AM15.1
used record additional information, such AM15.2 AM15.3
as the date the vendor relationship AM15.4 AM19.1
began. If left blank, the system date AM19.2 AM20.1
defaults. AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP10.3 AP100
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
...
VEN-OPERATOR Alpha 10 AC160 AM115
Element: Operator The operator associated with AM117 AM15.1
maintaining the vendor record. AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP10.3 AP100
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
...
VEN-USER-NAME-01 Alpha 20 AC160 AM115
Element: User Defined FThe value of the information being AM117 AM15.1
tracked for the vendor in the first AM15.2 AM15.3
vendor group user field. AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-USER-NAME-02 Alpha 20 AC160 AM115
Element: User Defined FThe value of the information being AM117 AM15.1
tracked for the vendor in the second AM15.2 AM15.3
vendor group user field. AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-USER-NAME-03 Alpha 20 AC160 AM115
Element: User Defined FThe value of the information being AM117 AM15.1
tracked for the vendor in the third AM15.2 AM15.3
vendor group user field. AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-USER-NAME-04 Alpha 20 AC160 AM115
Element: User Defined FThe value of the information being AM117 AM15.1
tracked for the vendor in the fourth AM15.2 AM15.3
vendor group user field. AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-USER-NAME-05 Alpha 20 AC160 AM115
Element: User Defined FThe value of the information being AM117 AM15.1
tracked for the vendor in the fifth AM15.2 AM15.3
vendor group user field. AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-USER-NAME-06 Alpha 20 AC160 AM115
Element: User Defined FThe value of the information being AM117 AM15.1
tracked for the vendor in the sixth AM15.2 AM15.3
vendor group user field. AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-CUST-GROUP Alpha 5 AC160 AM115
Element: Customer GroupIf the accounts payable vendor is also AM117 AM15.1
a customer in the Lawson Accounts AM15.2 AM15.3
Receivable system, this field can be AM15.4 AM19.1
used to identify the customer group AM19.2 AM20.1
associated with the corresponding AM20.3 AM21.1
accounts receivable customer. Used to AM21.3 AM500
update the accounts receivable customer AM51.1 AM551
record. AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
AR09.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
...
VEN-CUSTOMER Alpha 9 (Right Justified) AC160 AM115
Element: Customer If the accounts payable vendor is also AM117 AM15.1
a customer in the Lawson Accounts AM15.2 AM15.3
Receivable system, this field can be AM15.4 AM19.1
used to identify the corresponding AM19.2 AM20.1
accounts receivable customer number. AM20.3 AM21.1
Used to update the accounts receivable AM21.3 AM500
customer record. AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
AR09.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
...
VEN-LEGAL-NAME Alpha 80 (Lower Case) AC160 AM115
Element: Legal Name The legal name for the vendor. Used for AM117 AM15.1
reporting reportable vendor income. If AM15.2 AM15.3
left blank, the Vendor Name defaults. AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP10.3 AP100
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
...
VEN-PRIME-RATE Signed 7.5 AC160 AM115
Anticipation The percentage used to calculate AM117 AM15.1
Discount Rate anticipation discount invoices; most AM15.2 AM15.3
often the prime rate plus one percent. AM15.4 AM19.1
To calculate the discount for an AM19.2 AM20.1
anticipation invoice, the system AM20.3 AM21.1
subtracts the invoice payment date from AM21.3 AM500
the invoice due date to calculate the AM51.1 AM551
number of days paid early, multiplies AM97.1 AP03.3
the number of days paid early by 365 AP100 AP110
days, multiplies the result by the AP115 AP125
anticipation discount rate, and AP126 AP131
multiplies the result by the payment AP20.1 AP20.2
amount to calculate the discount amount. AP20.3 AP20.4
AP20.5 AP20.7
Anticipation discount terms codes are AP21.1 AP210
defined in Terms. AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-INVOICE-GROUP Alpha 4 AC160 AM115
Element: Invoice Group A user-defined invoice group assigned AM117 AM15.1
to the vendor. This value defaults on AM15.2 AM15.3
invoices entered for the vendor. Can be AM15.4 AM19.1
used to select invoices for payment in AM19.2 AM20.1
AP150 (Cash Requirements). AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-DISCOUNT-CODE Alpha 10 AC160 AM115
Element: Discount Code The discount code assigned to the AM117 AM15.1
vendor. Used to default a general ledger AM15.2 AM15.3
discount account on the vendor's AM15.4 AM19.1
invoices during entry. Must be a valid AM19.2 AM20.1
record in the Discount Code file. AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-ERS-CAPABLE Alpha 1 AC160 AM115
Element: ERS Capable Indicates whether the vendor location AM117 AM15.1
has the capability to process ERS. Valid AM15.2 AM15.3
values are: AM15.4 AM19.1
AM19.2 AM20.1
N = No. AM20.3 AM21.1
Y = Yes. AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-INVC-REF-TYPE Alpha 2 AC160 AM115
ERS Invoice Indicates the type of number the vendor AM117 AM15.1
Reference is providing to reference the invoice. AM15.2 AM15.3
Valid values are: AM15.4 AM19.1
AM19.2 AM20.1
BM = Bill of Lading Number. AM20.3 AM21.1
IN = Invoice Number. AM21.3 AM500
OW = Service Order Number. AM51.1 AM551
PL = Packing List Number. AM97.1 AP03.3
PO = PO Number. AP100 AP110
VN = Vendor Order Number. AP115 AP125
WO = Production Order Number. AP126 AP131
WP = Warehouse Pick Ticket Number. AP20.1 AP20.2
ZZ = Mutually Defined Number. AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-EDI-AUTO-REL Alpha 1 AC160 AM115
EDI Invoice Auto Indicates whether the company AM117 AM15.1
Release automatically releases EDI invoices. AM15.2 AM15.3
Valid values are: AM15.4 AM19.1
AM19.2 AM20.1
N = No. AM20.3 AM21.1
Y = Yes. AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-AUTH-CODE Alpha 3 AC160 AM115
Element: Authority CodeThe authority code assigned to the AM117 AM15.1
vendor, if assigned. Represents a person AM15.2 AM15.3
or department responsible for approving AM15.4 AM19.1
registered invoices for the vendor. This AM19.2 AM20.1
code defaults on the vendor's invoices AM20.3 AM21.1
during entry. Must be a valid authority AM21.3 AM500
code in the Authority Code file. AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-APPRVL-EXISTS Alpha 1 AC160 AM115
Approval Indicates whether approval criteria is AM117 AM15.1
Information Exists defined for the vendor. If Yes, one or AM15.2 AM15.3
more associated approval records exist AM15.4 AM19.1
for the vendor in the Invoice Approval AM19.2 AM20.1
file. Valid values are: AM20.3 AM21.1
AM21.3 AM500
N = No. AM51.1 AM551
Y = Yes. AM97.1 AP03.3
AP10.7 AP100
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
...
VEN-ACTIVITY Alpha 15 AC160 AM115
Element: Activity The activity assigned to the vendor, if AM117 AM15.1
assigned. Activities are the tasks that AM15.2 AM15.3
make up an activity group. Activities AM15.4 AM19.1
identify work being done, such as work AM19.2 AM20.1
orders, phases, products, and so on. AM20.3 AM21.1
Must be a valid record in the Activity AM21.3 AM500
file. AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-ACCT-CATEGORY Alpha 5 AC160 AM115
Element: Account CategoThe account category assigned to the AM117 AM15.1
vendor. Account categories are the AM15.2 AM15.3
Activity Management accounts by which AM15.4 AM19.1
activity transactions are grouped for AM19.2 AM20.1
budgeting and reporting. Must be a valid AM20.3 AM21.1
record in the Activity Account Category AM21.3 AM500
file. AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-CHARGE-CODE Alpha 1 AC160 AM115
Element: Charge Code Indicates who pays service charges or AM117 AM15.1
fees associated with a SWIFT payment. AM15.2 AM15.3
Valid values are: AM15.4 AM19.1
AM19.2 AM20.1
I = Issuer. AM20.3 AM21.1
R = Receiver. AM21.3 AM500
Blank = Not defined for the vendor. AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-PMT-CAT-CODE Alpha 6 AC160 AM115
Payment Category Indicates the payment category of the AM117 AM15.1
Code SWIFT payment. Valid values are: AM15.2 AM15.3
AM15.4 AM19.1
G = Goods. AM19.2 AM20.1
T = Transit Trade. AM20.3 AM21.1
S = Service and Capital. AM21.3 AM500
X = Transfer. AM51.1 AM551
O = Other. AM97.1 AP03.3
Blank = Not defined for the vendor. AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-NORM-EXP-CODE Alpha 1 AC160 AM115
Normal or Express Indicates whether the SWIFT payment is AM117 AM15.1
Code a normal or express payment. Valid AM15.2 AM15.3
values are: AM15.4 AM19.1
AM19.2 AM20.1
N = Normal. AM20.3 AM21.1
E = Express. AM21.3 AM500
Blank = Not defined for the vendor. AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-PMT-FORM Alpha 2 AC160 AM115
Element: Payment Form Indicates how the SWIFT payment is AM117 AM15.1
made. Valid values are: AM15.2 AM15.3
AM15.4 AM19.1
C = Check. AM19.2 AM20.1
B = Foreign Bank. AM20.3 AM21.1
Blank = Not defined for the vendor. AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-SWIFT-ID Alpha 12 AC160 AM115
Element: Swift ID The SWIFT identification number AM117 AM15.1
assigned to the vendor. AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-PROC-GRP Alpha 4 (Lower Case) AC160 AM115
Element: Process Group A process group is an identifier used AM117 AM15.1
for separating vendors into different AM15.2 AM15.3
groups to enable concurrent processing AM15.4 AM19.1
within the cash payment cycle. AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP102
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
...
VEN-MATCH-TABLE Alpha 10 AC160 AM115
Element: Match Table A code representing a match table. A AM117 AM15.1
match table contains the processing AM15.2 AM15.3
rules that will be used during matching. AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-DISC-CALC-DATE Alpha 1 AC160 AM115
Discount Indicates which date to use when AM117 AM15.1
Calculation Date calculating discounts. AM15.2 AM15.3
AM15.4 AM19.1
You can use the invoice date, receipt AM19.2 AM20.1
date, or the date the invoice was AM20.3 AM21.1
received. AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
" " AP100 AP110
D = Receipt of Invoice Date AP115 AP125
I = Invoice Date AP126 AP131
R = Latest Receipt Date AP20.1 AP20.2
E = Earliest Receipt Date AP20.3 AP20.4
S = Ship To Arrive Date AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-CREATE-POD-FL Alpha 1 AC160 AM115
Proof of Delivery Indicates whether to create a proof of AM117 AM15.1
Created delivery. AM15.2 AM15.3
AM15.4 AM19.1
Valid values are: AM19.2 AM20.1
AM20.3 AM21.1
N = No AM21.3 AM500
Y = Yes AM51.1 AM551
" " AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-HANDLING-CODE Alpha 4 AC160 AM115
Invoice Handling Invoice handling code. Determines the AM117 AM15.1
Code processing rules that will be used AM15.2 AM15.3
during matching. AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-ENCLOSURE Alpha 1 AC160 AM115
Element: Enclosure Indicates whether the invoice requires AM117 AM15.1
an enclosure with its payment. AM15.2 AM15.3
Y = Yes AM15.4 AM19.1
N = No AM19.2 AM20.1
" " AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-REQ-MATCH-REF Alpha 1 AC160 AM115
Match Reference Indicates whether a match reference AM117 AM15.1
Required number is required for invoices for this AM15.2 AM15.3
vendor. AM15.4 AM19.1
Y = Yes AM19.2 AM20.1
N = No AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-POOL-OPTION Numeric 1 AC160 AM115
Element: Au Flag 1 = Company Vendor AM117 AM15.1
2 = Company Vendor PO AM15.2 AM15.3
3 = Company Vendor PO ShipTo AM15.4 AM19.1
0 = MA Company Default AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-HOLD-INSP-FLAG Alpha 1 AC160 AM115
Element: Hold Insp FlagIf set to "Y", this flag will keep AM117 AM15.1
receiving lines requiring inspection AM15.2 AM15.3
from being matched until they have been AM15.4 AM19.1
inspected. AM19.2 AM20.1
Y = Yes AM20.3 AM21.1
N = No AM21.3 AM500
" " = Use Company AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-WRITE-OFF-AMT Signed 18.2 AC160 AM115
Element: Intl Amt AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-VEN-CLAIM-TYPE Alpha 2 AC160 AM115
Element: Vendor Claim TCB = Chargeback AM117 AM15.1
CM = Credit Memo AM15.2 AM15.3
N = None AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-CLAIM-HOLD-CD Alpha 4 AC160 AM115
Element: Hold Code The hold code. AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-CB-HOLD-CODE Alpha 4 AC160 AM115
Vendor Claims The hold code. AM117 AM15.1
Chargeback Hold AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-CB-MINIMUM-AMT Signed 18.2 AC160 AM115
Element: Minimum Claim Amount AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-REPLACE-GOODS Alpha 1 AC160 AM115
Element: Replace Goods Y = Yes AM117 AM15.1
N = No AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-SHIP-OR-HOLD Alpha 1 AC160 AM115
Element: Ship or Hold GS = Ship AM117 AM15.1
H = Hold AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-ERS-HANDLING Alpha 4 AC160 AM115
Element: Handling Code AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-E-MAIL-ADDRESS Alpha 60 (Lower Case) AC160 AM115
Element: Email Address e-mail address. AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-URL-ADDR Alpha 60 (Lower Case) AC160 AM115
Element: Url Addr AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-VEND-ACCT Alpha 30 AC160 AM115
Element: Vend Acct The customer number the vendor has AM117 AM15.1
assigned to you. AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-LANGUAGE-CODE Alpha 10 AC160 AM115
Element: Language Code Language Code (LOCALE). AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-TAX-USAGE-CD Alpha 10 AC160 AM115
Element: Tax Usage Cd The tax usage coe for the vendor. This AM117 AM15.1
filed is required if the AP Company AM15.2 AM15.3
inidcates that VAT reporting required. AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-VAT-REG-CTRY Alpha 2 AC160 AM115
Element: Vat Reg Ctry The country component of the VAT AM117 AM15.1
Registration Number. This field, AM15.2 AM15.3
together with the Registration Number AM15.4 AM19.1
for the company on the tax transaction. AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP10.3 AP100
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
...
VEN-VAT-REG-NBR Alpha 12 AC160 AM115
Element: Vat Reg Nbr The number component of the VAT AM117 AM15.1
Registration Number. This field together AM15.2 AM15.3
with the Registration Country field make AM15.4 AM19.1
up the VAT Registration Number. AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP10.3 AP100
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
...
VEN-VALIDATE-PO Alpha 1 AC160 AM115
Element: Validate Po " " = MA Company Default AM117 AM15.1
Y = Yes AM15.2 AM15.3
N = No AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-REQUIRE-PO Alpha 1 AC160 AM115
Element: Require Po " " = MA Company Default AM117 AM15.1
Y = Yes AM15.2 AM15.3
N = No AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-LOC-INDICATOR Derived
Element: Locations ExisWhen selecting a vendor from a list of
available vendors, an asterisk (*)
displays if alternate locations exist
for a vendor.
VEN-SHORT-VNAME Derived
Element: Short Vendor NA 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-VDR-ADDR1 Derived
Element: Vdr Addr1 Vendor address line 1.
VEN-VDR-ADDR2 Derived
Element: Vdr Addr2 Vendor address line 2.
VEN-VDR-ADDR3 Derived
Element: Vdr Addr3 Vendor address line 3.
VEN-VDR-ADDR4 Derived
Element: Vdr Addr4 Vendor address line 4.
VEN-VDR-CITY-ADDR5 Derived
Element: Vdr City Addr5Vendor city or address line 5.
VEN-VDR-STATE Derived
Element: Vdr State Vendor state or province.
VEN-VDR-POSTAL Derived
Element: Vdr Postal Vendor postal code.
VEN-VDR-COUNTY Derived
Element: Vdr County Vendor county.
VEN-VDR-COUNTRY Derived
Element: Vdr Country Vendor country.
VEN-VAT-NBR Derived
Element: Vat Nbr The concatenation of the VAT-REG-CTRY
and VAT-REG-NBR fields, used as VAT
reporting ID.
VEN-WORKFLOW-GROUP Alpha 20 AC160 AM115
Element: Workflow Group AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
VEN-MBL-INT-PREFIX Alpha 6 AC160 AM115
Element: Mbl Int PrefixThis field contains the country code of AM117 AM15.1
the mobile phone number. AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
VEN-MOBILE-NUM Alpha 15 AC160 AM115
Element: Mobile Num This field contains the mobile phone AM117 AM15.1
number. AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
VEN-MOBILE-EXT Alpha 5 AC160 AM115
Element: Mobile Ext This field contains the mobile phone AM117 AM15.1
extension number. AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
VEN-PAY-IMM-FLAG Alpha 1 AC160 AM115
Element: All Flag AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
VEN-DIVERSE-CODE Alpha 5 AC160 AM115
Element: Diverse Code Diversity Code for Account Payable AM117 AM15.1
Vendors AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
VEN-INTM-BANK-ENT Alpha 15 AC160 AM115
Element: Bank Entity Type the intermediary bank AM117 AM15.1
identification used to deposit AM15.2 AM15.3
electronic payments for the vendor. AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
VEN-INTM-BANK-ACCT Alpha 35 AC160 AM115
Element: Bank Acct Nbr Type the intermediary bank account AM117 AM15.1
number used to deposit electronic AM15.2 AM15.3
payments for the vendor. AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
VEN-INTM-BANK-IDNT Alpha 1 AC160 AM115
Element: Intm Bank IdntThis field indicates if the account AM117 AM15.1
number is and IBAN number that requires AM15.2 AM15.3
an account validation check. AM15.4 AM19.1
Y = Yes AM19.2 AM20.1
N = No AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
VEN-INTM-BANK-CURR Alpha 5 AC160 AM115
Element: Currency Code This field contains the intermediary AM117 AM15.1
bank currency code. AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
VEN-INTM-PRENOT Alpha 1 AC160 AM115
Element: Ach Prenot If you create intermediary ACH payments AM117 AM15.1
for the vendor, select the AM15.2 AM15.3
prenotification status. Indicates the AM15.4 AM19.1
status of the electronic payment between AM19.2 AM20.1
the vendor and the processing bank. AM20.3 AM21.1
A = Accepted AM21.3 AM500
N = Not prenotified AM51.1 AM551
P = Prenotified AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
VEN-INTM-SWIFT-ID Alpha 12 AC160 AM115
Element: Patient Id Use SWIFT Payment Options (AP10.8) to AM117 AM15.1
define SWIFT payment options if you AM15.2 AM15.3
create Intermediary SWIFT payments for AM15.4 AM19.1
the vendor. AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
VEN-INTM-PMT-CAT Alpha 6 AC160 AM115
Element: Pmt Cat Code Select the Intermediary SWIFT payment AM117 AM15.1
category. AM15.2 AM15.3
G = Goods AM15.4 AM19.1
T = Transit Trade AM19.2 AM20.1
S = Service and Capital AM20.3 AM21.1
X = Transfer AM21.3 AM500
O = Other AM51.1 AM551
AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
VEN-INTM-NORM-EXP Alpha 1 AC160 AM115
Element: Charge Code Indicates whether the SWIFT payment is a AM117 AM15.1
normal or express payment. AM15.2 AM15.3
N = Normal AM15.4 AM19.1
E = Express AM19.2 AM20.1
" " = Not defined for the vendor AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
VEN-INTM-PMT-FORM Alpha 2 AC160 AM115
Element: Pmt Form Indicates how the Intermediary SWIFT AM117 AM15.1
payment is made. AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
VEN-INTM-CHRG-CD Alpha 1 AC160 AM115
Element: Charge Code Indicates who pays service charges or AM117 AM15.1
fees associated with a Intermediary AM15.2 AM15.3
SWIFT payment. AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
VEN-INTM-CRS-IDENT Alpha 1 AC160 AM115
Element: Intm Crs IdentThis field is used to distiguish between AM117 AM15.1
SWIFT ID numbers and Routing numbers AM15.2 AM15.3
S = Swift AM15.4 AM19.1
R = Routing Number AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
VEN-RULE-GROUP Alpha 10 AC160 AM115
Element: Rule Group AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
VEN-FLOAT-DAYS Numeric 3 AC160 AM115
Element: Float Days This is the number of days to add to the AM117 AM15.1
best terms calculation if the vendor AM15.2 AM15.3
will allow a specific number of days for AM15.4 AM19.1
the payment to reach them and still AM19.2 AM20.1
receive the discount. AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
VEN-MTCH-PREPAY-FL Alpha 1 AC160 AM115
Element: Mtch Prepay FlFlag that notes if the invoice will be AM117 AM15.1
prepaid. This is for match invoices. AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
VEN-MTCH-PREPAY-MT Numeric 1 AC160 AM115
Element: Mtch Prepay MtFlag denotes the method of match AM117 AM15.1
prepayment. AM15.2 AM15.3
AM15.4 AM19.1
0 = No AM19.2 AM20.1
1 = Prepay from Invoice AM20.3 AM21.1
2 = Eligible for Prepayment AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
VEN-BUILD-SOC-REF Alpha 18 AC160 AM115
Element: Build Soc Ref This field holds an individual account AM117 AM15.1
number reference for the Building AM15.2 AM15.3
Society AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
VEN-BUILD-ACCT-NM Alpha 18 AC160 AM115
Element: Account Name AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
VEN-XREF-FLAG Alpha 1 AP15.1
Element: Xref Flag Use a cross reference table for this
vendor
0 = Xref Vendor does not exist
1 = Xref record exist
VEN-GIRO-NUMBER Alpha 15 AC160 AM115
Element: Giro Number This field is the Bankgiro or Postgiro AM117 AM15.1
account number AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
VEN-CR-CARD-NUMBER Alpha 16 AC160 AM115
Element: Cr Card NumberThis field contains the credit card AM117 AM15.1
number. AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
VEN-BANK-INSTRUCT1 Alpha 35 AC160 AM115
Element: Bank Instruct1This field contains bank instructions. AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
VEN-BANK-INSTRUCT2 Alpha 35 AC160 AM115
Element: Bank Instruct2This field contains bank instructions. AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
VEN-BANK-INSTRUCT3 Alpha 35 AC160 AM115
Element: Bank Instruct3This field contains bank instructions. AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
VEN-BANK-INSTRUCT4 Alpha 35 AC160 AM115
Element: Bank Instruct4This field contains bank instructions. AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
VEN-AP-OBJ-ID Numeric 12 AC160 AM115
Element: Obj Id This is the object identifier. It is AM117 AM15.1
used to relate commitments or posted AM15.2 AM15.3
transactions back to the originating AM15.4 AM19.1
subsystems. Each subsystem record that AM19.2 AM20.1
is updated as a commitment or posted AM20.3 AM21.1
transaction is assigned an object AM21.3 AM500
identifier. The object identifier is AM51.1 AM551
maintained in the subsystem files and in AM97.1 AP03.3
the Activity Commitments Detail and AP10.3 AP110
Activity Transaction files. The object AP115 AP125
identifier is a unique key used to drill AP126 AP131
back from Activity Management to the AP20.1 AP20.2
subsystems. AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
...
VEN-P-CARD-FLAG Numeric 1 AC160 AM115
Element: Flag Num 0 = No AM117 AM15.1
1 = Yes AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
VEN-PCARD-NBR Alpha 16 AC160 AM115
Element: Pcard Nbr AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
VEN-VAL-DIV-DATE Alpha 1 AC160 AM115
Element: All Flag Determines on invoice entry if the AM117 AM15.1
invoice date is within the certification AM15.2 AM15.3
dates for the diversity code setup for AM15.4 AM19.1
the vendor on AP14.4 AM19.2 AM20.1
" " = No AM20.3 AM21.1
Y = Yes AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
APVENMAST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
VENSET1 VENDOR-GROUP AC160 AC210
VENDOR AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM18.1 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.1
AP03.1 AP03.2
AP03.3 AP03.4
AP10.1 AP10.2
AP10.3 AP10.5
AP10.6 AP10.7
...
VENSET10 VENDOR-GROUP KeyChange AP130
CREATE-POD-FL
VENDOR
VENSET11 AP-OBJ-ID Subset AC160 AM115
Where AP-OBJ-ID != Zeroes AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP03.4 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
...
VENSET2 VENDOR-GROUP KeyChange AC160 AM115
VEN-CLASS AM117 AM15.1
VENDOR AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP03.3 AP100
AP102 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
...
VENSET3 VENDOR-GROUP KeyChange
USER-NAME-01
VENDOR-SNAME
VENDOR
VENSET4 VENDOR-GROUP KeyChange
VEN-CLASS
VENDOR-SNAME
VENDOR
VENSET5 VENDOR-GROUP KeyChange AC160 AM115
VENDOR-SNAME AM117 AM15.1
VENDOR AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP10.1 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
...
VENSET6 PROC-GRP KeyChange AP02.3 AP202
VENDOR-GROUP
VENDOR
VENSET7 VENDOR-GROUP KeyChange AC160 AC210
EDI-NBR AM115 AM117
VENDOR AM15.1 AM15.2
AM15.3 AM15.4
AM18.1 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
...
VENSET8 VENDOR-GROUP Subset AP160
VENDOR Where ACH-PRENOT = "N"
Or ACH-PRENOT = "P"
VENSET9 HANDLING-CODE KeyChange AP102 MA05.1
VENDOR-GROUP MA05.2
VENDOR
APVENMAST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Address1 APVENADDR Required
VEN-VENDOR-GROUP -> VDR-VENDOR-GROUP
VEN-VENDOR -> VDR-VENDOR
Spaces -> VDR-LOCATION-CODE
Spaces -> VDR-RESP-CODE
Zeroes -> VDR-CONTACT-LVL
"Y" -> VDR-CUR-ADDR
Approcgrp APPROCGRP Not Required
VEN-PROC-GRP -> APQ-PROC-GRP
Apvengroup APVENGROUP Required
VEN-VENDOR-GROUP -> VGP-VENDOR-GROUP
Mamtchrule MAMTCHRULE Required
VEN-RULE-GROUP -> MAU-MATCH-RULE
Procuregrp PROCUREGRP Required
VEN-VENDOR-GROUP -> PCG-VENDOR-GROUP
APVENMAST FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apapihist APAPIHIST
VEN-VENDOR-GROUP -> AH1-VENDOR-GROUP
VEN-VENDOR -> AH1-VENDOR
AH1-INVOICE
AH1-SUFFIX
AH1-CANCEL-SEQ
AH1-COMPANY
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-SEQ-NBR
Apcontacts APCONTACT Delete Cascades
VEN-VENDOR-GROUP -> VCT-VENDOR-GROUP
VEN-VENDOR -> VCT-VENDOR
VCT-RESP-CODE
VCT-CONTACT-LVL
VCT-LOCATION-CODE
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-SEQ-NBR
Apvenaddr APVENADDR
VEN-VENDOR-GROUP -> VDR-VENDOR-GROUP
VEN-VENDOR -> VDR-VENDOR
Spaces -> VDR-LOCATION-CODE
Spaces -> VDR-RESP-CODE
Zeroes -> VDR-CONTACT-LVL
VDR-EFFECTIVE-DATE
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
Apvencert APVENCERT
VEN-VENDOR-GROUP -> AVT-VENDOR-GROUP
VEN-VENDOR -> AVT-VENDOR
AVT-LOCATION-CODE
AVT-CERTIF-CODE
AVT-CERTIF-EFF-DT
Apvendiv APVENDIV
VEN-VENDOR-GROUP -> VDC-VENDOR-GROUP
VEN-VENDOR -> VDC-VENDOR
VDC-LOCATION-CODE
VDC-DIVERSE-CODE
VDC-DCERT-DATE
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
Apvenpay APVENPAY
VEN-VENDOR-GROUP -> VPY-VENDOR-GROUP
VEN-VENDOR -> VPY-VENDOR
VPY-PAY-VENDOR
Apvnmxval APVNMXVAL Delete Cascades
VEN-AP-OBJ-ID -> VMX-AP-OBJ-ID
VMX-MATRIX-CAT
Cbcheck CBCHECK
VEN-VENDOR-GROUP -> CHK-VENDOR-GROUP
VEN-VENDOR -> CHK-PAID-VENDOR
CHK-COMPANY
CHK-CHECK-DATE
CHK-BANK-INST-CODE
CHK-CASH-CODE
CHK-TRANS-IDENT
Povagrmthd POVAGRMTHD
PCG-PROCURE-GROUP -> PVH-PROCURE-GROUP
VEN-VENDOR -> PVH-VENDOR
PVH-PURCH-FR-LOC
PVH-VEN-AGRMT-REF
Vnmxconv VNMXCONV
VEN-VENDOR-GROUP -> VNC-VENDOR-GROUP
VEN-VENDOR -> VNC-VENDOR
VNC-MATRIX-CAT
|