Friday, December 14, 2018
FeOffice Field Export Descriptions
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
Return    


Copyright 2009 by Lynx Media, Inc.