Vendor Export

Note:

The Lawson and PeopleSoft interfaces described in this section require a separate license fee to use. Contact the Naviga Support Center for more information.

File type: Fixed length

Location: /dti/exchange/cm/secure/vendorexport.d

Note:

By default, the vendor file will be named “vendorexport.d”. The Business Rule, What is the default name for the vendor file? (Account Setup section), allows you to change this default.

Standard and Expanded Formats

The Business Rule, At what level of detail should DTI Standard vendor file be exported? (Account Setup section), allows you to indicate whether the standard, standard 2, or expanded format should be used, as well as whether new or active carriers are included in the export. The possible settings are “New Standard,” “Active Standard,” “New Standard 2,” “Active Standard 2,” “New Expanded,” and “Active Expanded.”

• The “active” options export all carriers who have a social security number or tax ID.

• The “new” options export carriers created after a date and who have a social security number, tax ID, or vendor ID.

• “Standard” means that the current DTI format will be used.

• “Expanded” means the expanded format will be used. The expanded format is given below.

• “2” means that (1) the Standard 2 format will be used, and that (2) all of the information will be exported to one file and the Business Rule, Should vendor export create separate export files by company? (Account Setup section), will not be considered.

Notes:

• To use the DTI Standard 2 format, you must also set the Business Rule— To which system should vendor information be interfaced? (Account Setup section), to “DTI Standard 2.” To use either the Standard or Expanded formats, set this Business Rule to “DTI Standard.”

• When using the DTI Standard 2 format, new vendors that appear in the export will not appear on the Vendor Change report unless the vendor's information has been modified since the create date.

• If an e-mail account notification is selected for the Business Rule— What email type notification should be used to identify email addresses to include in DTI Standard 2 export? (Account Setup section), it will be exported as in the Notification ID field in the DTI Standard 2 format. If an account has the notification and an e-mail address in the notification details, the e-mail address is exported in the Notification Details field. If the account has the notification but does not have an e-mail address in the notification details, "?" will be exported instead. If the account does not have the notification, both Notification ID and Notification Details fields will be blank. If the Business Rule is not answered, the ID and details for the first active notification found for the account will be exported.

The file formats are shown below.

DTI Standard

Field
Vendor Company ID
Vendor ID
Last Name
First Name
Area Code
Phone Number
Address Lines [1-6]
City ID
State
Zip Code
Zip Extension
Account ID/Subscriber ID

DTI Standard 2

Fields
AccountID
TaxID
Occupant Name
Occupant OtherName
Occupant Phone
Occupant Phone Number Type
Alternate Phone Number
Alternate Phone Number Type
Fax
Email
AddressLine1
AddressLine2
AddressLine3
AddressLine4
CityID
StateID
Zip Code
Zip Extension
DeliveryPointID
Bill to Name
Bill to Other Name
Bill to Phone Number
Bill to Phone Number Type
Bill to Alternate Phone Number
Bill to Alternate Phone Number Type
Bill to Fax
Bill to Email
Bill AddressLine1
Bill AddressLine2
Bill AddressLine3
Bill AddressLine4
Bill CityID
Bill StateID
Bill ZipCode
Bill Zip Extension
Bill DeliveryPointID
NotificationID
Notification Details
Billing Terms
Parent AccountID
Primary Contract Holder (setting of the Business Rule, What account demographic should be used for the Primary Contract Holder in the Vendor and Carrier Mail Exports? (Account Setup section))
Bill Source ID (if account has more than 1 bill source, “*” is exported)

DTI Expanded

Field
Account ID
Occupant Name
Occupant Other Name
Occupant Phone
Occupant Phone Number Type
Alternate Phone Number
Alternate Phone Number Type
Fax
Email
Address Line [1-5]
City ID
State ID
Zip Code
Zip Extension
Delivery Point ID
Bill to Name
Bill to Other Name
Bill to Phone Number
Bill to Phone Number Type
Bill to Alternate Phone Number
Bill to Alternate Phone Number Type
Bill to Fax
Bill to Email
Bill Address Line [1-5]
Bill City ID
Bill State ID
Bill Zip Code
Bill Zip Extension
Bill Delivery Point ID
SSN
Tax ID
Vendor ID
Vendor Company ID
Birth Date
Age Group
Notification ID
Notification Details
Billing Terms

Lawson Format

Field	Length	Field Contents
AP-Company	9(4)	Carrier’s vendor company
AP-Vendor-Number	9(9)	Carrier’s vendor ID, right-justified
AP-Vendor-Name	x(30)	Carrier’s first name plus last name
AP-Vendor-Addr1	x(30)	First line of carrier’s address
AP-Vendor-Addr2	x(30)	Second line of carrier’s address
AP-Vendor-City	x(21)	Carrier’s city
AP-Vendor-State	x(2)	Carrier’s state
AP-Zip-Code	x(9)	Carrier’s ZIP Code
AP-Phone-Number	x(15)	Carrier’s phone number including area code (no dashes)
AP-Phone-Extension	x(5)	Spaces
AP-Vendor-Legal-Name	x(30)	Spaces
AP-Vendor-Tax-ID	x(15)	Carrier Social Security # or Tax ID if the Social Security # is blank. Numbers should include the dashes.
AP-Income-Code	x(2)	Spaces
AP-Invoice-Group	x(4)	Spaces

PeopleSoft II Format

PeopleSoft Field	Length	Required?	Value
TRANSACTION_TYPE	x(3)	Yes	Transaction type
BUSINESS_UNIT	x(5)	Yes	Newspaper business unit
XX_CIRC_TYPE	x(1)	Yes	Circulation type
XX_CIRC_ID1	x(15)	Yes	Circulation ID 1
XX_CIRC_ID2	x(10)	Yes	Circulation ID 2
NAME1	x(40)	Yes	Name
ADDRESS1	x(55)	Yes	Address Line 1
ADDRESS2	x(55)		Address Line 2
ADDRESS3	x(55)		Address Line 3
ADDRESS4	x(55)		Address Line 4
CITY	x(30)	Yes	City
STATE	x(6)	Yes	State
POSTAL	x(12)	Yes	Postal
COUNTRY	x(3)	Yes	Country
BIRTHDATE	date (10)	Yes	Birth date
TIN_TYPE	x(1)	Yes	TIN type
TIN_TYPE	x(20)	Yes	TIN/Social Security Number
BNK_ID_NBR	x(20)		Bank Routing Number
BANK_ACCOUNT_NBR	x(17)		Bank Account Number
BANK_ACCT_TYPE	x(2)		Bank Account Type
Withholding Switch	x(1)	No	Yes/no. Taken from the Print1099 flag in the account record.
Filler	x(1)	No	Blank
Phone	x(24)	No	Phone number with no spaces, dashes, or parenthesis.
Trailer Record
TRANSACTION_TYPE	x(3)	Yes	Transaction type
BUSINESS_UNIT	x(5)	Yes	Newspaper business unit
REC_COUNT_SUM	9(5)	Yes	Total record count