FeOffice Field Export Descriptions

In the event the following error occurs during the exporting of bills or renewals in FeOffice, the field can be deselected followed by re-running the export. Reference the table below to find out which field belongs to the field number shown in the error message:

 

 

In this example, field number 425 is the Premium Description. Deselect the Premium Description field from exporting:

 

 

Re-run the FeOffice export, the error message will not appear.

 

Following are the field numbers and their descriptions:

 

101: Matchcode (Customer)

102: Customer ID

103: Name

104: First Name

105: Last Name

106: Mr/Ms

107: Title

108: Company

109: Street

110: Address2

111: City State Zip

112: City

113: State

114: Zip

115: Country

116: Phone1

117: Phone2

118: Original Date

119: KeyDate

120: Tag

121: Group

122: Select

123: Type

124: Source

125: Dear

126: SIC Codes

127: FIPS

128: Credit Card Number

129: Credit Card Expire Date

130: Credit Card Type

131: Date of Form - 01/01/97

132: Donor Name

133: Bill To Name

134: Customer Change Date

135: Forever Amount

136: Discount Amount

137: Outstanding Amount

138: Last Sale Date

139: Number of Sales

140: Tax Exempt

141: Name & Address

142: Tabbed Name & Address

144: Email Address

146: User Def 1

147: User Def 2

148: User Def 3

149: User Def 4

150: User Def 5

151: User Def 6

152: User Def 7

153: User Def 8

201: Sub ID

202: Sub Org Srce

203: Renew Srce

204: User

205: Price

206: Rate

207: Add On

208: Tax

209: Total Price

210: Paid

211: Subtotal Due

212: Billing Amount

213: Subr Type

214: Copies

215: Strt Dte

216: Exp Dte

217: Term

218: Term(Months)

219: Ord Date

220: Qual Date

221: Chk Number

222: Pur Order

223: Status

224: Bill Offer

225: Renew Offer

226: Bill10MOD

227: Chnge Date (Subscriber)

228: Pay Date

229: Sub Orig Date

230: Greeting

231: Bill Effort

232: Renew Effort

235: Last Paid

236: Exp-Date Replace

237: Exp-New Replace

238: Exp Date - New

245: Start Date - Date Replace

246: Start Date - New Date Replace

247: Start Date - New

257: Price Tax

258: Price + Add-On Tax

259: Rate Tax

260: Rate + Add-On Tax

261: Add-On Tax

263: Earned Income

264: Refund

265: Renewals

266: Renewal Copies

267: Memo

268: Remaining Issues

269: Last Issue Sent

270: Category

271: Publication Name

272: Standing Order

273: Series-Bulk1 Price+Tax

274: Series-Bulk2 Price+Tax

275: Ship To Address

276: Series - Price 1

277: Series - Price 2

278: Series - Price 3

279: Series - Price 4

280: Series - TPrice 1

281: Series - TPrice 2

282: Series - TPrice 3

283: Series - TPrice 4

284: Series - Price 1 - Tax

285: Series - Price 2 - Tax

286: Series - Price 3 - Tax

287: Series - Price 4 - Tax

288: Offer Code

289: Description Code

290: Edition

291: Unique Invoice

293: Audit Qualified

294: Bill To Address

295: Audit Paid

296: Audit Source

297: Audit Address

298: Audit Title

299: Audit Industry

300: Audit Base

301: Agency

302: Audit Premium Type

303: Reserved

304: Audit Channel

305: Forever Amount (Subscription)

306: Multi-Renew

307: Cardholder

308: Audit Category

309: Premium

310: Write-Off Amount

311: Payment Type

312: Last Billing Effort Issue

313: Last Renewel Effort Issue

314: Write Off Date

315: Publication Code

316: Billing Type

317: Audit Circulation Type

318: Restart Issue

319: Vacation Start

320: Backstart Description

321: Suspend Status

323: Last Status

324: Carrier Route

325: Subscription Customer ID

326: Original Price

327: Postal Code

328: Renewal Schedule

329: Billing Schedule

330: Last Renewal Cycle

331: Last Billing Cycle

332: First/Last Issue

333: Bulk Type

334: Country Code

335: Presort Postage

336: Postage

337: Original Term

338: Write-Off

339: Sent

340: Backstarts

341: Hold Bills

342: Hold Renewals

343: Premium Sent

344: Start Cycle

345: Message

346: Multi-Bill

347: Amount Due

348: Dear Subscriber

350: Rate - Paid

351: Total Due

352: Matchcode (Subscriber)

353: Date

354: Series Bulk Price1

355: Series Bulk Price2

356: Prev Balance

357: Term in Years

358: Serie Tax1

359: Series Tax2

360: USPS Check Digit

361: Strt Dte-Renew

362: Exp Dte-Renew

363: Strt Dte- Renew Repl

364: Exp Dte -Renew Repl

365: Zip+4 Bar Code-Name

366: Zip+4 Bar Code-Ship to

367: Zip+4 Bar Code-Bill to

368: Offer

369: Renewl Bill To

370: New Exp-1 Yr-Dte Rpl

371: New Exp-1 Yr

375: Series Addon1

376: Series Addon2

377: Series Term1 Desc

378: Series Term2 Desc

379: Agency Address

404: Ack#

405: Demo1

406: Demo2

407: Demo3

408: Demo4

409: Demo5

410: Demo6

411: Demo7

412: Demo8

413: Demo9

414: Demo10

415: Tax Desc

416: Post prem ID

417: Post prem Desc

418: Post prem Qty

419: User Table Value 1

420: Salesperson

421: C/S Remarks

422: Start Date - Date Replace (YYYY)

423: Start Date - New Date Replace (YYYY)

424: Premium code

425: Premium desc

426: Premium addon

427: Premium memo/comment

434: User Table Value 2

435: User Table Value 3

436: User Table Value 4

437: User Table Value 5

444: Renewal Price

445: User Table Value 6

446: User Table Value 7

447: User Table Value 8

448: User Table Value 9

449: User Table Value 1


Posted on Wednesday, November 5, 2008 (Archive on Monday, January 1, 0001)
Posted by dave  Contributed by