APVENMAST

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
AP109 AP111 AP12.1 AP133 AP135 AP136
AP141 AP145 AP146 AP151 AP155 AP156
AP161 AP175 AP176 AP178 AP180 AP181
AP190 AP191 AP193 AP195 AP197 AP211
AP212 AP213 AP221 AP230 AP233 AP240
AP245 AP250 AP251 AP252 AP270 AP272
AP282 AP284 AP290 AP295 AP32.1 AP33.1
AP35.1 AP36.2 AP41.1 AP45.1 AP45.3 AP45.4
AP51.2 AP51.3 AP52.7 AP54.1 AP55.1 AP55.2
AP56.1 AP56.2 AP80.1 AP92.1 AP92.2 AP92.3
AP92.4 AP93.1 AP93.2 AP93.3 AP93.4 AP96.1
ZA161 ZA586 CB06.2 CB50.1 CB500 CB54.1
CB55.1 CB554 EE11.1 EE135 EE175 EE20.1
EE20.2 EE20.3 EE20.4 EE220 EE230 EE235
EE30.1 EE35.1 EE35.2 EE520 EE90.1 EE90.2
IC141 IC266 IC282 IC522 IC526 IC527
IC81.1 ZC522 EX12.1 EX14.1 EX14.2 EX175
MX202 MX223 MA168 MA236 MA26.1 MA278
MA310 MA540 MA64.1 MA64.4 MA64.6 MA64.9
MA90.1 MA90.2 MA90.3 MA90.5 MA90.6 MA91.1
MAED.1 PD21.1 PO132 PO135 PO204 PO222
PO227 PO231 PO26.2 PO26.3 PO26.4 PO26.5
PO26.6 PO26.7 PO26.9 PO53.4 PO58.2 MM280
MM80.2 RQ11.1 RQIB.1 RQIC.1 RQID.1 RQIG.1
RQIJ.1 AM18.1 AP13.2 AP162 AP166 AP185
AP200 AP235 AP236 AP237 AP266 AP275
AP62.1 AP810 AP98.1 AP98.2 EE275 GL284
GL285 IAVO.1 IC258 IC58.1 IC58.2 IC58.3
MA00.1 MA167 PO226 IN120 IN20.1 WH38.1
AP202 MA05.1 MA05.2


UPDATED BY
AC160 AC210 AC297 AM115 AM117 AM15.1
AM15.2 AM15.3 AM15.4 AM19.1 AM19.2 AM20.1
AM20.3 AM21.1 AM21.3 AM22.1 AM500 AM51.1
AM551 AM97.1 AP00.1 AP00.3 AP02.3 AP03.2
AP03.3 AP10.1 AP10.2 AP10.3 AP10.7 AP100
AP102 AP11.1 AP110 AP115 AP125 AP126
AP130 AP131 AP14.5 AP144 AP15.1 AP150
AP16.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 AP271
AP28.1 AP30.2 AP30.4 AP300 AP305 AP40.2
AP510 AP520 AP590 AP90.1 AP91.1 AP91.5
AP91.6 AP95.1 API1.1 API2.1 API3.1 API4.1
ZA585 AR09.1 CX100 CX20.1 CX20.2 CX20.4
CX20.5 CX220 CX30.1 CX300 CX506 CXCP.1
DR100 IC140 IC142 IC64.1 IC64.2 IC64.3
IC64.4 IC64.5 IC64.6 IC64.7 IC64.8 IC64.9
IC66.1 IC83.1 IC840 MX123 MX500 MA180
MA279 MA41.1 MA41.2 MA41.4 MA41.7 MA42.1
MA42.2 MA43.1 MA43.2 MA43.3 MA43.4 MA43.6
MA43.7 MA44.1 MA44.2 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA63.1 MA65.1 MA66.2
MA67.1 MA67.2 MA67.3 MA68.2 MA68.3 MA68.5
MA69.1 MA70.1 MA75.1 MA80.1 MA95.1 MA95.2
MAI1.1 PD10.1 PD10.2 PD130 PD20.1 PD20.2
PD20.3 PD235 PO10.1 PO100 PO101 PO120
PO122 PO131 PO136 PO150 PO190 PO20.1
PO20.6 PO20.9 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO22.2 PO22.3 PO22.4 PO22.5
PO220 PO223 PO23.1 PO233 PO24.1 PO25.1
PO25.5 PO25.6 PO25.7 PO253 PO254 PO27.2
PO278 PO28.2 PO29.1 PO30.1 PO30.2 PO30.3
PO30.4 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 PO54.5
POCP.1 POI3.1 POID.1 POII.1 POIJ.1 PR05.1
PR05.3 PR198 PR226 PR247 PR26.1 PR47.1
PR514 UK47.1 RQ10.1 RQ10.2 RQ10.4 RQ12.1
RQ13.1 RQ13.2 RQ260 RQ35.1 RQ500 RQIF.1
TX140 WH130 WH132 WH190 WH20.2 WH20.7
WH222 WH30.1 WH30.2 WH30.3 WH30.4 WH31.1
WH31.2 WH31.3 WH31.4 WH32.1 WH32.2 WH32.3
WH32.4 WH32.5 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830
ZW130

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
VEN-VENDOR-GROUP
Element: Vendor Group
Alpha 4
The vendor group to which the vendor belongs. Must be a valid record in the Vendor Group file.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP10.3
AP100 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
VEN-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The identification number assigned to the vendor.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP10.3
AP100 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
VEN-VEN-CLASS
Element: Vendor Class
Alpha 3
The vendor class the vendor is assigned to. Represents a group of vendors that share common characteristics within a vendor group. Must be a valid record in the Vendor Class file.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP10.3
AP100 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
VEN-VENDOR-VNAME
Element: Vendor Name
Alpha 30 (Lower Case)
The vendor name or description.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP10.3
AP100 AP110
AP115 AP125
AP126 AP131
AP150 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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
VEN-VENDOR-SNAME
Element: Search Name
Alpha 30
The search name for the vendor.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP10.3
AP100 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
VEN-VENDOR-CONTCT
Element: Contact
Alpha 30
The name of the main contact for the vendor.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-REMIT-TO-CODE
Normal Remit-To
Location
Alpha 4
The normal remittance location for the vendor, if defined. Must be a valid record in the Vendor Location file. If present, the address defined for the location overrides the vendor address on vendor payments when invoices are added.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-PURCH-FR-LOC
Normal
Purchase-From Location
Alpha 4
The normal purchasing location for the vendor, if defined. Must be a valid record in the Vendor Location file. If present, the address defined for the location overrides the vendor address for storing vendor purchase activity balances.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP10.2
AP100 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
VEN-PAY-VENDOR
Element: Pay Vendor
Alpha 9 (Right Justified)
The pay vendor for the vendor, if applicable. Used to send invoice payments to another vendor within the same vendor group. If present, the pay vendor relationship overrides the normal remit-to information for the vendor, including remit-to name and address, cash code, and payment code. Must be a valid record in the Vendor file. Although payments are remitted to the pay vendor, the invoiced vendor accumulates the payment balance. If more than one vendor shares the same pay vendor, the system creates a single payment for the pay vendor and lists individual invoiced vendors and invoice numbers that are included in the payment on the remittance.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP10.3
AP100 AP11.1
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
VEN-VENDOR-STATUS
Element: Status
Alpha 1
The vendor status. Invoices cannot be entered for a vendor with an Inactive status. Valid values are: A = Active. I = Inactive.
D = Inactive for PO additions
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP10.3
AP100 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
VEN-VEN-PRIORITY
Element: Priority
Numeric 2
The payment priority assigned to the vendor. Valid values are 1 (highest priority) through 99 (lowest priority).
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
VEN-PHONE-PREFIX
Element: Phone Prefix
Alpha 6
The country code for the vendor telephone number.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-PHONE-NUM
Element: Phone
Alpha 15
The telephone number for the vendor.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-PHONE-EXT
Element: Phone Ext
Alpha 5
The telephone extension number for the vendor.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-FAX-PREFIX
Element: Phone Prefix
Alpha 6
The country code for the fax machine telephone number.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-FAX-NUM
Element: Phone
Alpha 15
The fax machine telephone number.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-FAX-EXT
Element: Phone Ext
Alpha 5
The fax machine telephone number extension.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-TELEX-NUM
Element: Telex
Alpha 15
The telex number for the vendor.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-TERM-CODE
Element: Payment Terms
Alpha 5
The payment terms code assigned to the vendor. Used to automatically calculate invoice due date and discount information for the vendor's invoices. Must be a valid record in the Terms Code file.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-INV-CURRENCY
Element: Invoice Currency
Alpha 5
The currency used to add invoices for the vendor. The currency code defaults on the vendor's invoices during entry. Must be a valid record in the Currency Code file. If left blank, the vendor uses the invoice currency assigned to the vendor class, if assigned, or the company base currency. If the Balance Currency field contains a non-base currency, the Invoice Currency must be either the same non-base currency or the company base currency. If the Balance Currency field contains the company base currency, the Invoice Currency can be a non-base currency.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-BAL-CURRENCY
Element: Vendor Balance
Alpha 5
The currency used to store vendor balance information. Must be a valid record in the Currency Code file. If left blank, the company base currency is used.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-CURR-RECALC
Currency
Recalculation
Alpha 1
If the Invoice Currency is different from the company base currency, this field indicates whether the system will recalculate the invoice currency when the invoice is paid to account for exchange rate fluctuations. If Yes is selected in this field, the system compares the exchange rate in effect when the invoice was entered to the exchange rate in effect when the invoice is scheduled for payment by AP150 (Cash Requirements). If a difference exists, AP170 (Payment Closing) creates a currency gain or loss transaction. Valid values are: N = No. Y = Yes.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP10.3
AP100 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
VEN-SEP-CHK-FLAG
Element: Separate Payment
Alpha 1
Indicates whether to create a separate payment for each invoice entered for the vendor. Valid values are: N = No. Y = Yes.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP10.3
AP100 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
VEN-TAX-ID
Element: Tax Id
Alpha 20
The tax identification number for the vendor. Used for reporting reportable vendor income.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP10.3
AP100 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
VEN-TAX-EXEMPT-CD
Element: Tax Exempt Cd
Alpha 1
Code indicating the taxing status. E - Exempt, T - Taxable.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
VEN-TAX-CODE
Element: Tax Code
Alpha 10
The tax code assigned to the vendor. Used to automatically calculate invoice tax information. Must be a valid record in the Tax Code file. If left blank, the tax code assigned to the vendor class defaults.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-HOLD-FLAG
Element: Hold Code
Alpha 1
This field enables this entire lot to be put on hold, not allowing any issues or transfers to be made for this lot.
Y = Yes
" "
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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 AP271
AP30.2 AP30.4
AP300 AP305
AP40.2 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
VEN-DIST-CODE
Element: Distribution Code
Alpha 9
The distribution code assigned to the vendor. Used to automatically create distribution lines for the vendor's invoices. Must be a valid record in the Distribution Code file. If left blank, the distribution code assigned to the vendor class, if assigned, defaults.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-ACCR-CODE
Element: Invoice Accrual Code
Alpha 4
The invoice accrual code assigned to the vendor. Used to default a general ledger accrual account to the vendor's invoices during entry. Must be a valid record in the Invoice Accrual Code file. If left blank, the invoice accrual code assigned to the vendor class, if assigned, or the company defaults.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-BANK-INST-CODE
Element: Payment Code
Alpha 3
The payment code assigned to the vendor. Represents a type of cash payment, such as a check or payment tape, or a bill of exchange payment. Must be a valid cash or bill of exchange payment transaction code record in the Bank Transaction Code file.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-CASH-CODE
Element: Cash Code
Alpha 4
The cash code assigned to the vendor. Represents a bank account. Must be a valid record in the Cash Code file. If left blank, the cash code assigned to the vendor class, if assigned, defaults, or the vendor uses the cash code assigned to the company or the pay group.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP28.1
AP28.2 AP30.2
AP30.4 AP300
AP305 AP510
AP56.1 AP56.2
AP80.1 AP90.1
AP91.1 API1.1
API2.1 API3.1
VEN-BANK-ENTITY
Element: Bank
Alpha 15
The bank identification used to deposit electronic payments for the vendor. This field is required for ACH or BACS payment types.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-BANK-CURRENCY
Element: Currency Code
Alpha 5
This field contains the bank currency code
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
VEN-VBANK-ACCT-NO
Element: Bank Acct Nbr
Alpha 35
The bank account number used to deposit electronic payments for the vendor. This field is required for ACH or BACS payment types.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-VBANK-ACCT-TP
Element: Vbank Acct Tp
Alpha 1
Indicates the type of bank account used to deposit electronic payments for the vendor. Valid values are: C = Current/Checking Account. S = Savings Account. Blank = Electronic payment type not selected.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-VBANK-IDENT
Element: Vbank Ident
Alpha 1
This field indicates if the account number is an IBAN number that requires an account validation check.
Y = Yes
N = No
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
VEN-CROSS-IDENT
Element: Cross Ident
Alpha 1
This field is used to distinguish between SWIFT ID numbers and Routing numbers.
S = SWIFT
R = Routing Number
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
VEN-INCOME-CODE
Element: Income Code
Alpha 4
The income code assigned to the vendor. Used to track reportable income for the vendor. Must be a valid record in the Income Code file.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP10.3
AP100 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
VEN-INCOME-WH-FLG
Element: Income Withholding
Alpha 1
Indicates whether invoices for the vendor are subject to reportable income withholding. Valid values are: N = No. Y = Yes.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP10.3
AP100 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
VEN-EDI-NBR
Element: EDI Number
Alpha 15
The vendor's electronic data interchange (EDI) number. Used for reference.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-ACH-PRENOT
Element: Ach Prenot
Alpha 1
Used in conjunction with ACH payments created for the vendor. Indicates the status of the electronic payment between the vendor and the processing bank. Valid values are: N = Notified. Payment Tape Creation (AP160) automatically changes the status from Prenotified to Notified to indicate that the processing bank has been notified but has not yet accepted the electronic payment tape. P = Prenotified. Select this status when first entering ACH information to prenotify the processing bank. A = Accepted. Change the status to Accepted once the processing bank accepts the electronic payment tape. Blank = ACH payment type not selected.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
AP160 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
VEN-MAX-INV-AMT
Maximum Invoice
Amount
Signed 18.2
The maximum single invoice amount that can be entered for the vendor.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-CREATE-DATE
Element: Create Date
Numeric 8 (yyyymmdd)
The date the vendor record was created in Accounts Payable.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP10.3
AP100 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
VEN-ORIGIN-DATE
Element: Date
Numeric 8 (yyyymmdd)
The origin date for the vendor. Can be used record additional information, such as the date the vendor relationship began. If left blank, the system date defaults.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP10.3
AP100 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
VEN-OPERATOR
Element: Operator
Alpha 10
The operator associated with maintaining the vendor record.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP10.3
AP100 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
VEN-USER-NAME-01
Element: User Defined Field 1
Alpha 20
The value of the information being tracked for the vendor in the first vendor group user field.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-USER-NAME-02
Element: User Defined Field 2
Alpha 20
The value of the information being tracked for the vendor in the second vendor group user field.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-USER-NAME-03
Element: User Defined Field 3
Alpha 20
The value of the information being tracked for the vendor in the third vendor group user field.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-USER-NAME-04
Element: User Defined Field 4
Alpha 20
The value of the information being tracked for the vendor in the fourth vendor group user field.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-USER-NAME-05
Element: User Defined Field 5
Alpha 20
The value of the information being tracked for the vendor in the fifth vendor group user field.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-USER-NAME-06
Element: User Defined Field 6
Alpha 20
The value of the information being tracked for the vendor in the sixth vendor group user field.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-CUST-GROUP
Element: Customer Group
Alpha 5
If the accounts payable vendor is also a customer in the Lawson Accounts Receivable system, this field can be used to identify the customer group associated with the corresponding accounts receivable customer. Used to update the accounts receivable customer record.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
AR09.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
VEN-CUSTOMER
Element: Customer
Alpha 9 (Right Justified)
If the accounts payable vendor is also a customer in the Lawson Accounts Receivable system, this field can be used to identify the corresponding accounts receivable customer number. Used to update the accounts receivable customer record.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
AR09.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
VEN-LEGAL-NAME
Element: Legal Name
Alpha 80 (Lower Case)
The legal name for the vendor. Used for reporting reportable vendor income. If left blank, the Vendor Name defaults.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP10.3
AP100 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP520
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
VEN-PRIME-RATE
Anticipation
Discount Rate
Signed 7.5
The percentage used to calculate anticipation discount invoices; most often the prime rate plus one percent. To calculate the discount for an anticipation invoice, the system subtracts the invoice payment date from the invoice due date to calculate the number of days paid early, multiplies the number of days paid early by 365 days, multiplies the result by the anticipation discount rate, and multiplies the result by the payment amount to calculate the discount amount. Anticipation discount terms codes are defined in Terms.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-INVOICE-GROUP
Element: Invoice Group
Alpha 4
A user-defined invoice group assigned to the vendor. This value defaults on invoices entered for the vendor. Can be used to select invoices for payment in AP150 (Cash Requirements).
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-DISCOUNT-CODE
Element: Discount Code
Alpha 10
The discount code assigned to the vendor. Used to default a general ledger discount account on the vendor's invoices during entry. Must be a valid record in the Discount Code file.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-ERS-CAPABLE
Element: ERS Capable
Alpha 1
Indicates whether the vendor location has the capability to process ERS. Valid values are: N = No. Y = Yes.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-INVC-REF-TYPE
ERS Invoice
Reference
Alpha 2
Indicates the type of number the vendor is providing to reference the invoice. Valid values are: BM = Bill of Lading Number. IN = Invoice Number. OW = Service Order Number. PL = Packing List Number. PO = PO Number. VN = Vendor Order Number. WO = Production Order Number. WP = Warehouse Pick Ticket Number. ZZ = Mutually Defined Number.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-EDI-AUTO-REL
EDI Invoice Auto
Release
Alpha 1
Indicates whether the company automatically releases EDI invoices. Valid values are: N = No. Y = Yes.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-AUTH-CODE
Element: Authority Code
Alpha 3
The authority code assigned to the vendor, if assigned. Represents a person or department responsible for approving registered invoices for the vendor. This code defaults on the vendor's invoices during entry. Must be a valid authority code in the Authority Code file.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-APPRVL-EXISTS
Approval
Information Exists
Alpha 1
Indicates whether approval criteria is defined for the vendor. If Yes, one or more associated approval records exist for the vendor in the Invoice Approval file. Valid values are: N = No. Y = Yes.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP10.7
AP100 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
VEN-ACTIVITY
Element: Activity
Alpha 15
The activity assigned to the vendor, if assigned. Activities are the tasks that make up an activity group. Activities identify work being done, such as work orders, phases, products, and so on. Must be a valid record in the Activity file.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-ACCT-CATEGORY
Element: Account Category
Alpha 5
The account category assigned to the vendor. Account categories are the Activity Management accounts by which activity transactions are grouped for budgeting and reporting. Must be a valid record in the Activity Account Category file.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-CHARGE-CODE
Element: Charge Code
Alpha 1
Indicates who pays service charges or fees associated with a SWIFT payment. Valid values are: I = Issuer. R = Receiver. Blank = Not defined for the vendor.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-PMT-CAT-CODE
Payment Category
Code
Alpha 6
Indicates the payment category of the SWIFT payment. Valid values are: G = Goods. T = Transit Trade. S = Service and Capital. X = Transfer. O = Other. Blank = Not defined for the vendor.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-NORM-EXP-CODE
Normal or Express
Code
Alpha 1
Indicates whether the SWIFT payment is a normal or express payment. Valid values are: N = Normal. E = Express. Blank = Not defined for the vendor.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-PMT-FORM
Element: Payment Form
Alpha 2
Indicates how the SWIFT payment is made. Valid values are: C = Check. B = Foreign Bank. Blank = Not defined for the vendor.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-SWIFT-ID
Element: Swift ID
Alpha 12
The SWIFT identification number assigned to the vendor.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-PROC-GRP
Element: Process Group
Alpha 4 (Lower Case)
A process group is an identifier used for separating vendors into different groups to enable concurrent processing within the cash payment cycle.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP102 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
VEN-MATCH-TABLE
Element: Match Table
Alpha 10
A code representing a match table. A match table contains the processing rules that will be used during matching.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-DISC-CALC-DATE
Discount
Calculation Date
Alpha 1
Indicates which date to use when calculating discounts. You can use the invoice date, receipt date, or the date the invoice was received.
" "
D = Receipt of Invoice Date
I = Invoice Date
R = Latest Receipt Date
E = Earliest Receipt Date
S = Ship To Arrive Date
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-CREATE-POD-FL
Proof of Delivery
Created
Alpha 1
Indicates whether to create a proof of delivery. Valid values are: N = No Y = Yes
" "
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-HANDLING-CODE
Invoice Handling
Code
Alpha 4
Invoice handling code. Determines the processing rules that will be used during matching.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-ENCLOSURE
Element: Enclosure
Alpha 1
Indicates whether the invoice requires an enclosure with its payment.
Y = Yes
N = No
" "
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-REQ-MATCH-REF
Match Reference
Required
Alpha 1
Indicates whether a match reference number is required for invoices for this vendor.
Y = Yes
N = No
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-POOL-OPTION
Element: Au Flag
Numeric 1

1 = Company Vendor
2 = Company Vendor PO
3 = Company Vendor PO ShipTo
0 = MA Company Default
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-HOLD-INSP-FLAG
Element: Hold Insp Flag
Alpha 1
If set to "Y", this flag will keep receiving lines requiring inspection from being matched until they have been inspected.
Y = Yes
N = No
" " = Use Company
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-WRITE-OFF-AMT
Element: Intl Amt
Signed 18.2
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-VEN-CLAIM-TYPE
Element: Vendor Claim Type
Alpha 2

CB = Chargeback
CM = Credit Memo
N = None
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-CLAIM-HOLD-CD
Element: Hold Code
Alpha 4
The hold code.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-CB-HOLD-CODE
Vendor Claims
Chargeback Hold
Alpha 4
The hold code.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-CB-MINIMUM-AMT
Element: Minimum Claim Amount
Signed 18.2
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-REPLACE-GOODS
Element: Replace Goods
Alpha 1

Y = Yes
N = No
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-SHIP-OR-HOLD
Element: Ship or Hold Goods
Alpha 1

S = Ship
H = Hold
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-ERS-HANDLING
Element: Handling Code
Alpha 4
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-E-MAIL-ADDRESS
Element: Email Address
Alpha 60 (Lower Case)
e-mail address.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-URL-ADDR
Element: Url Addr
Alpha 60 (Lower Case)
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-VEND-ACCT
Element: Vend Acct
Alpha 30
The customer number the vendor has assigned to you.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-LANGUAGE-CODE
Element: Language Code
Alpha 10
Language Code (LOCALE).
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-TAX-USAGE-CD
Element: Tax Usage Cd
Alpha 10
The tax usage coe for the vendor. This filed is required if the AP Company inidcates that VAT reporting required.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-VAT-REG-CTRY
Element: Vat Reg Ctry
Alpha 2
The country component of the VAT Registration Number. This field, together with the Registration Number for the company on the tax transaction.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP10.3
AP100 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
VEN-VAT-REG-NBR
Element: Vat Reg Nbr
Alpha 12
The number component of the VAT Registration Number. This field together with the Registration Country field make up the VAT Registration Number.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP10.3
AP100 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
VEN-VALIDATE-PO
Element: Validate Po
Alpha 1

" " = MA Company Default
Y = Yes
N = No
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-REQUIRE-PO
Element: Require Po
Alpha 1

" " = MA Company Default
Y = Yes
N = No
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-LOC-INDICATOR
Element: Locations Exist
Derived
When selecting a vendor from a list of available vendors, an asterisk (*) displays if alternate locations exist for a vendor.
VEN-SHORT-VNAME
Element: Short Vendor Name
Derived
A short name for the vendor. Used for display purposes.
VEN-VCOMMENT-EXIST
Vendor Comments
Exist
Derived
When selecting a vendor from a list of available vendors, an asterisk (*) displays if comments exist for a vendor.
VEN-VDR-ADDR1
Element: Vdr Addr1
Derived
Vendor address line 1.
VEN-VDR-ADDR2
Element: Vdr Addr2
Derived
Vendor address line 2.
VEN-VDR-ADDR3
Element: Vdr Addr3
Derived
Vendor address line 3.
VEN-VDR-ADDR4
Element: Vdr Addr4
Derived
Vendor address line 4.
VEN-VDR-CITY-ADDR5
Element: Vdr City Addr5
Derived
Vendor city or address line 5.
VEN-VDR-STATE
Element: Vdr State
Derived
Vendor state or province.
VEN-VDR-POSTAL
Element: Vdr Postal
Derived
Vendor postal code.
VEN-VDR-COUNTY
Element: Vdr County
Derived
Vendor county.
VEN-VDR-COUNTRY
Element: Vdr Country
Derived
Vendor country.
VEN-VAT-NBR
Element: Vat Nbr
Derived
The concatenation of the VAT-REG-CTRY and VAT-REG-NBR fields, used as VAT reporting ID.
VEN-WORKFLOW-GROUP
Element: Workflow Group
Alpha 20
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
VEN-MBL-INT-PREFIX
Element: Mbl Int Prefix
Alpha 6
This field contains the country code of the mobile phone number.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
VEN-MOBILE-NUM
Element: Mobile Num
Alpha 15
This field contains the mobile phone number.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
VEN-MOBILE-EXT
Element: Mobile Ext
Alpha 5
This field contains the mobile phone extension number.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
VEN-PAY-IMM-FLAG
Element: All Flag
Alpha 1
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
VEN-DIVERSE-CODE
Element: Diverse Code
Alpha 5
Diversity Code for Account Payable Vendors
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
VEN-INTM-BANK-ENT
Element: Bank Entity
Alpha 15
Type the intermediary bank identification used to deposit electronic payments for the vendor.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
VEN-INTM-BANK-ACCT
Element: Bank Acct Nbr
Alpha 35
Type the intermediary bank account number used to deposit electronic payments for the vendor.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
VEN-INTM-BANK-IDNT
Element: Intm Bank Idnt
Alpha 1
This field indicates if the account number is and IBAN number that requires an account validation check.
Y = Yes
N = No
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
VEN-INTM-BANK-CURR
Element: Currency Code
Alpha 5
This field contains the intermediary bank currency code.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
VEN-INTM-PRENOT
Element: Ach Prenot
Alpha 1
If you create intermediary ACH payments for the vendor, select the prenotification status. Indicates the status of the electronic payment between the vendor and the processing bank.
A = Accepted
N = Not prenotified
P = Prenotified
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
VEN-INTM-SWIFT-ID
Element: Patient Id
Alpha 12
Use SWIFT Payment Options (AP10.8) to define SWIFT payment options if you create Intermediary SWIFT payments for the vendor.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
VEN-INTM-PMT-CAT
Element: Pmt Cat Code
Alpha 6
Select the Intermediary SWIFT payment category.
G = Goods
T = Transit Trade
S = Service and Capital
X = Transfer
O = Other
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
VEN-INTM-NORM-EXP
Element: Charge Code
Alpha 1
Indicates whether the SWIFT payment is a normal or express payment.
N = Normal
E = Express
" " = Not defined for the vendor
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
VEN-INTM-PMT-FORM
Element: Pmt Form
Alpha 2
Indicates how the Intermediary SWIFT payment is made.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
VEN-INTM-CHRG-CD
Element: Charge Code
Alpha 1
Indicates who pays service charges or fees associated with a Intermediary SWIFT payment.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
VEN-INTM-CRS-IDENT
Element: Intm Crs Ident
Alpha 1
This field is used to distiguish between SWIFT ID numbers and Routing numbers
S = Swift
R = Routing Number
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
VEN-RULE-GROUP
Element: Rule Group
Alpha 10
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VEN-FLOAT-DAYS
Element: Float Days
Numeric 3
This is the number of days to add to the best terms calculation if the vendor will allow a specific number of days for the payment to reach them and still receive the discount.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
VEN-MTCH-PREPAY-FL
Element: Mtch Prepay Fl
Alpha 1
Flag that notes if the invoice will be prepaid. This is for match invoices.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
VEN-MTCH-PREPAY-MT
Element: Mtch Prepay Mt
Numeric 1
Flag denotes the method of match prepayment.
0 = No
1 = Prepay from Invoice
2 = Eligible for Prepayment
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
VEN-BUILD-SOC-REF
Element: Build Soc Ref
Alpha 18
This field holds an individual account number reference for the Building Society
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
VEN-BUILD-ACCT-NM
Element: Account Name
Alpha 18
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
VEN-XREF-FLAG
Element: Xref Flag
Alpha 1
Use a cross reference table for this vendor
0 = Xref Vendor does not exist
1 = Xref record exist
AP15.1
VEN-GIRO-NUMBER
Element: Giro Number
Alpha 15
This field is the Bankgiro or Postgiro account number
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
VEN-CR-CARD-NUMBER
Element: Cr Card Number
Alpha 16
This field contains the credit card number.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
VEN-BANK-INSTRUCT1
Element: Bank Instruct1
Alpha 35
This field contains bank instructions.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
VEN-BANK-INSTRUCT2
Element: Bank Instruct2
Alpha 35
This field contains bank instructions.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
VEN-BANK-INSTRUCT3
Element: Bank Instruct3
Alpha 35
This field contains bank instructions.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
VEN-BANK-INSTRUCT4
Element: Bank Instruct4
Alpha 35
This field contains bank instructions.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
VEN-AP-OBJ-ID
Element: Obj Id
Numeric 12
This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP10.3
AP110 AP115
AP125 AP126
AP131 AP150
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
VEN-P-CARD-FLAG
Element: Flag Num
Numeric 1

0 = No
1 = Yes
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
VEN-PCARD-NBR
Element: Pcard Nbr
Alpha 16
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
VEN-VAL-DIV-DATE
Element: All Flag
Alpha 1
Determines on invoice entry if the invoice date is within the certification dates for the diversity code setup for the vendor on AP14.4
" " = No
Y = Yes
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
VEN-RET-ACCR-CODE
Element: Accr Code
Alpha 4
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
VEN-GLN-NBR
Element: Gln Nbr
Alpha 13
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
VEN-TIN-TYPE
Element: Flag Num
Numeric 1
AP14.5
VEN-TIN-NOT
Element: Flag Num
Numeric 1
AP14.5
VEN-TIN-VERIFIED
Element: Flag Num
Numeric 1
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP10.1
AP110 AP115
AP125 AP126
AP131 AP144
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1


APVENMAST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
VENSET1 VENDOR-GROUP
VENDOR
...
AC160 AC210
AC297 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM18.1
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM22.1 AM500
AM51.1 AM551
AM97.1 AP00.1
AP03.1 AP03.2
AP03.3 AP03.4
AP10.1 AP10.2
AP10.3 AP10.5
VENSET10 VENDOR-GROUP
CREATE-POD-FL
VENDOR
KeyChange
AP130
VENSET11 AP-OBJ-ID
Subset
WhereAP-OBJ-ID !=Zeroes
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP03.4
AP110 AP115
AP125 AP126
AP131 AP150
AP20.1 AP20.2
AP20.3 AP20.4
VENSET2 VENDOR-GROUP
VEN-CLASS
VENDOR
KeyChange
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP00.3 AP03.3
AP10.1 AP10.2
AP100 AP102
AP110 AP111
AP115 AP125
AP126 AP131
VENSET3 VENDOR-GROUP
USER-NAME-01
VENDOR-SNAME
VENDOR
KeyChange
VENSET4 VENDOR-GROUP
VEN-CLASS
VENDOR-SNAME
VENDOR
KeyChange
VENSET5 VENDOR-GROUP
VENDOR-SNAME
VENDOR
KeyChange
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP10.1
AP110 AP115
AP125 AP126
AP131 AP150
AP20.1 AP20.2
AP20.3 AP20.4
VENSET6 PROC-GRP
VENDOR-GROUP
VENDOR
KeyChange
AP02.3 AP202
VENSET7 VENDOR-GROUP
EDI-NBR
VENDOR
KeyChange
...
AC160 AC210
AC297 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM18.1
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM22.1 AM500
AM51.1 AM551
AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP150
AP20.1 AP20.2
VENSET8 VENDOR-GROUP
VENDOR
Subset
WhereACH-PRENOT ="N"
OrACH-PRENOT ="P"
AP160
VENSET9 HANDLING-CODE
VENDOR-GROUP
VENDOR
KeyChange
AP102 MA05.1
MA05.2


APVENMAST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
Glnloc GLNLOC Not Required
Valid When VEN-GLN-NBR !=Spaces
PCG-ITEM-GROUP->GLO-ITEM-GROUP
VEN-GLN-NBR->GLO-GLN-NBR
Glnlocdtl GLNLOCDTL Not Required
Valid When VEN-GLN-NBR !=Spaces
PCG-ITEM-GROUP->GLX-ITEM-GROUP
7->GLX-GLN-TYPE
VEN-VENDOR->GLX-VENDOR
Spaces->GLX-LOCATION-CODE
VEN-GLN-NBR->GLX-GLN-NBR
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
NAME
RELATED 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
  APA-LOCATION-CODE
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


File created: Thu Jun 09 11:07:57 2016

Home
Contact Us



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