Contents Show
This file contains the vendor information for each of the vendors. This is the file that the Bank will read in order to see which peer group the vendor belongs. This file contains Vendor demographic, peer group and bank information for all vendors. This is an ASCII flat file and is sent using the FTP or Dial-up Process. This process executes during the End of Day Process if the value of the EOD_BANKINGVENDORFILEEXPORT business rule equals "Y" in the STATEBUSINESSRULES table.
The vendor file name syntax will be one of the following (depending on who has the banking contract):
Covansys - stBV######.txt st - State Code
BV - Banking Vendor file prefix
###### - sequential number
Example - MOBV000001.txt
FSMC - BV######.txt BV - Banking Vendor file prefix
###### - sequential number
Example - BV000001.txt
|
Field |
From |
To |
Length |
Type |
Decimal |
|
RecordId |
1 |
3 |
3 |
Char |
"VAA" |
|
FromMachine |
4 |
9 |
6 |
Char |
"st8888" |
|
ToMachine |
10 |
15 |
6 |
Char |
"??????" |
|
FileDate |
16 |
23 |
8 |
Date |
"yyyymmdd" |
|
FileName |
24 |
33 |
10 |
Char |
"BV###### " or "stBV######" |
|
VersionID |
34 |
41 |
8 |
Char |
" ########" |
|
Field |
From |
To |
Length |
Type |
Decimal |
|
RecordID |
1 |
3 |
3 |
Char |
"VBA" |
|
VendorID |
4 |
9 |
6 |
Char |
· |
|
PeerGroupID |
10 |
11 |
2 |
Char |
· |
|
PharmacyInd |
12 |
12 |
1 |
Char |
· |
|
BankNumber |
13 |
22 |
10 |
Char |
· |
|
BankAccount |
23 |
32 |
10 |
Char |
· |
|
TradeName |
33 |
82 |
50 |
Char |
· |
|
MailAddressLine1 |
83 |
132 |
50 |
Char |
· |
|
MailAddressLine2 |
133 |
182 |
50 |
Char |
· |
|
MailCity |
183 |
212 |
30 |
Char |
· |
|
MailStateCode |
213 |
214 |
2 |
Char |
· |
|
MailZIP |
215 |
223 |
9 |
Char |
· |
|
Field |
From |
To |
Length |
Type |
Decimal |
|
RecordID |
1 |
3 |
3 |
Char |
"VA9" |
|
VBARecordCount |
4 |
8 |
5 |
Decimal |
0 |
Record ID
This is the header identifier telling the bank that this is a header record.
Characteristics
This element will be an alphanumeric field and have a value of 'VAA'. It will start in the position 1 and have a length of 3.
Edits
This is a required field.
From Machine ID
This is the identifier of the machine that sent the file to the bank.
Characteristics
This element will be an alphanumeric field and have a value of 'st8888'. It will start in the position 4 and have a length of 6. st - is the state or tribe identifier.
Edits
This is a required field.
To Machine ID
This is the identifier of the machine that the file is supposed to reach.
Characteristics
This element will be an alphanumeric field and have a value of <UNKNOWN AT THIS TIME>. It will start in the position 10 and have a length of 6.
Edits
This is a required field.
File Date
This is the date the file was sent to the bank.
Characteristics
This element will be an alphanumeric field and have a format of CCYYMMDD. It will start in the position 16 and have a length of 8. This value will be the current system date.
Edits
This is a required field.
File Name
This is the file name was sent to the bank.
Characteristics
This element will be an alphanumeric field and have a format of "stBVnnnnnn" where st is the state identifier and nnnnnn is a sequential number. It will start in the position 24 and have a length of 10.
Edits
This is a required field.
Version ID
This is the version of the file
Characteristics
This element will be an alphanumeric field that will have the version number of the file. It is not used at this time and will default to spaces. It will start in the position 34 and have a length of 8.
Edits
This is a required field.
Record ID
This is the header identifier telling the bank that this is a detail record.
Characteristics
This element will be an alphanumeric field and have a value of 'VBA'. It will start in the position 1 and have a length of 3.
Edits
This is a required field.
This is the vendor's unique identifier.
Characteristics
This element will be a numeric field if the State business rule VENDORID_NUMERIC = "Y", otherwise it will be an alphanumeric field. It will start in the position 4 and have a length of 6. This value is taken from the VendorID column of the Vendor table.
Edits
This is a required field.
Peer Group ID
This is the peer group ID for the vendor.
Characteristics
This element will be a numeric field. It will start in the position 10 and have a length of 2. This value is taken from the PeerGroup column of the Vendor table.
Edits
This is a required field.
Pharmacy Code
This is a flag telling if the vendor is a pharmacy or not.
Characteristics
This element will be an alpha field. It will be set to "Y" if it is a pharmacy and "N" if not. It will start in the position 12 and have a length of 1. This value is "Y" if the Type column of the Vendor table = 10. Otherwise, this value is "N"
Edits
This is a required field.
Bank Transit Number
This is the vendor's bank's routing number.
Characteristics
This element will be a numeric field. It will start in the position 13 and have a length of 10. This value is taken from the BankTransitNumber column of the Vendor table.
Edits
This is a required field.
Bank Account Number
This is the vendor's account number at its bank.
Characteristics
This element will be a numeric field. It will start in the position 23 and have a length of 10. This value is taken from the AccountNumber column of the Vendor table.
Edits
This is a required field.
Vendor Trade Name
This is the vendor name.
Characteristics
This element will be an alpha field. It will start in the position 33 and have a length of 50, left-justified with trailing blanks. This value is taken from the TradeName column of the Vendor table.
Edits
This is a required field.
Mailing Address Line 1
This is the first line of the mailing address for the vendor.
Characteristics
This element will be an alpha field. It will start in the position 83 and have a length of 50, left-justified with trailing blanks. This value is taken from the MailingAddress1 column of the Vendor table.
Edits
This is a required field.
Mailing Address Line 2
This is the second line of the mailing address for the vendor.
Characteristics
This element will be an alpha field. It will start in the position 133 and have a length of 50, left-justified with trailing blanks. This value is taken from the MailingAddress2 column of the Vendor table.
Edits
This is a required field.
Mailing City
This is the mailing city for the vendor.
Characteristics
This element will be an alpha field. It will start in the position 183 and have a length of 30, left-justified with trailing blanks. This value is taken from the MailingCity column of the Vendor table.
Edits
This is a required field.
Mailing State Code
This is the mailing state for the vendor.
Characteristics
This element will be an alpha field. It will start in the position 213 and have a length of 2. This value is taken from the MailingState column of the Vendor table.
Edits
This is a required field.
Mailing ZIP
This is the mailing ZIP for the vendor.
Characteristics
This element will be a numeric field. It will start in the position 215 and have a length of 9. This value is taken from the MailingZIP column of the Vendor table.
Edits
This is a required field.
Record ID
This is the header identifier telling the bank that this is a trailer record.
Characteristics
This element will be an alphanumeric field and have a value of 'VA9'. It will start in the position 1 and have a length of 3.
Edits
This is a required field.
Vendor Record Count
This is the count of Vendor detail records in the file.
Characteristics
This element will be a numeric field of the count of the number of Vendor detail ('VBA') records sent in this file. It will start in the position 4 and have a length of 5, right-justified, zero-filled, and no commas.
Edits
This is a required field.
|
Software Version: 2.40.00