QuickFill's ODBC Tables

The tables listed below are available when using ODBC to access a QuickFill database.

BPK	Billing package record
BPK_DBABPK	Billing package database address
BPK_CODE	Package code
BPK_FIXCOST	Fixed cost in pennies
BPK_VARCOST	Variable cost in pennies
BPK_CCINFO	Print credit card information block
BPK_DESC	Description
BPK_CIRC	Circular ID
BPK_LETT	Letter ID
BPK_CARD	Card ID
BPK_BUCK	Buckslip ID
BPK_ENV	Envelope ID
BPK_REPL	Reply envelope ID
BPK_FORM	Form ID
BPK_MISC1	Miscellaneous user field 1
BPK_MISC2	Miscellaneous user field 2
BPK_TYPE	Output type: S=Simple, X=Detailed, C=Mail-merge
BPK_CUSTCODE	mail-merge format code

BSR	Billing series record
BSR_DBABSR	Billing series database address
BSR_DBABPK1	Database address of billing package used for effort 1
BSR_DBABPK2	Database address of billing package used for effort 2
BSR_DBABPK3	Database address of billing package used for effort 3
BSR_DBABPK4	Database address of billing package used for effort 4
BSR_DBABPK5	Database address of billing package used for effort 5
BSR_DBABPK6	Database address of billing package used for effort 6
BSR_DBABPK7	Database address of billing package used for effort 7
BSR_DBABPK8	Database address of billing package used for effort 8
BSR_DBAMSG11	Database address of message 1 for effort 1
BSR_DBAMSG12	Database address of message 1 for effort 2
BSR_DBAMSG13	Database address of message 1 for effort 3
BSR_DBAMSG14	Database address of message 1 for effort 4
BSR_DBAMSG15	Database address of message 1 for effort 5
BSR_DBAMSG16	Database address of message 1 for effort 6
BSR_DBAMSG17	Database address of message 1 for effort 7
BSR_DBAMSG18	Database address of message 1 for effort 8
BSR_DBAMSG21	Database address of message 2 for effort 1
BSR_DBAMSG22	Database address of message 2 for effort 2
BSR_DBAMSG23	Database address of message 2 for effort 3
BSR_DBAMSG24	Database address of message 2 for effort 4
BSR_DBAMSG25	Database address of message 2 for effort 5
BSR_DBAMSG26	Database address of message 2 for effort 6
BSR_DBAMSG27	Database address of message 2 for effort 7
BSR_DBAMSG28	Database address of message 2 for effort 8
BSR_CODE	Billing series code
BSR_DESC	Description
BSR_FBILLDAYS	Days after issue for first bill
BSR_FBILLDATE	Date of first bill
BSR_FBILLPOLICY	0=use offer/pub policy, 1=immediate, 3=days after issue, 4=specified date
BSR_COMBO	True if billing series is eligible for combination billing
BSR_WHO1	Billto or Shipto for effort 1
BSR_WHO2	Billto or Shipto for effort 2
BSR_WHO3	Billto or Shipto for effort 3
BSR_WHO4	Billto or Shipto for effort 4
BSR_WHO5	Billto or Shipto for effort 5
BSR_WHO6	Billto or Shipto for effort 6
BSR_WHO7	Billto or Shipto for effort 7
BSR_WHO8	Billto or Shipto for effort 8
BSR_TIMING1	Days until next effort 1
BSR_TIMING2	Days until next effort 2
BSR_TIMING3	Days until next effort 3
BSR_TIMING4	Days until next effort 4
BSR_TIMING5	Days until next effort 5
BSR_TIMING6	Days until next effort 6
BSR_TIMING7	Days until next effort 7
BSR_TIMING8	Days until next effort 8
BSR_SUSPEND	Suspend on this effort
BSR_NUMEFFS	Number of efforts in series
BSR_PRTPUB1	Print publication name on top half of bill
BSR_PRTPUB2	Print publication name on bottom half of bill
BSR_DOCDESC1	Wording in lieu of "Subscription"
BSR_DOCDESC2	Wording in lieu of "Invoice"
BSR_DOCDESC3	Wording in lieu of "Please return this portion."
BSR_DOCDESC4	Wording in lieu of "For your"
BSR_DOCDESC5	Wording in lieu of "records"

BTA	Batch accounting record
BTA_DBABTA	Batch account record database address
BTA_DBABTH	Batch header database address
BTA_REFNUM	Reference number
BTA_ORDNUM	Order number
BTA_AMOUNT	Amount in pennies
BTA_TYPE	Transaction type
BTA_PUB	Publication code
BTA_GLACCT	General ledger account code
BTA_BASIS	Accounting basis

BTH	Batch header record
BTH_DBABTH	Batch header record database address
BTH_DATE	Batch date
BTH_NUM	Batch number
BTH_TYPE	Batch type

BTL	Batch log record
BTL_DBABTL	Batch log record database address
BTL_DBABTH	Batch header database address
BTL_REFNUM	Reference number
BTL_ORDNUM	Order number
BTL_TYPE	Transaction type
BTL_PUB	Publication code
BTL_DESC	Description

BTP	Batch payment record
BTP_DBABTP	Batch payment record database address
BTP_DBABTH	Batch header database address
BTP_ORDNUM	Order number
BTP_PUB	Publication code
BTP_PAYTYPE	Payment type
BTP_PAYNUM	Payment identification number

CHN	Channel record
CHN_DBACHN	Channel database address
CHN_CODE	Channel code
CHN_DESC	Description

CHN_ABCBUS	Channel source for ABC business publications (0=unknown source, 1=direct by mail, 2=catalog agency, 3=publishers salesperson, 4=other salesperson, 5=other sources, 6=association, 7=church/school/fraternal)
CHN_ABCMAG	Channel source for ABC magazine publications (0=unknown source, 21=direct mail, online, catalogs, 22=telemarketing, door-to-door sales, 23=fund raising, 24=membership)

CMB	Combo order record
CMB_DBACMB	Combo order database address
CMB_DBABSR	Billing series address
CMB_NUM	Combo number
CMB_DATE	Combo date
CMB_FIRSTBILLDATE	Date first bill was sent
CMB_LASTBILLDATE	Date last bill was sent
CMB_LASTBILLEFF	Last billing effort number
CMB_TOTALDUE	Total amount due
CMB_TOTALPAID	Total amount paid

CNR	Cancel reasons record
CNR_DBACNR	Cancel reason database address
CNR_CODE	Cancel reason code
CNR_DESC	Description

COM	Company record
COM_DBACOM	Company database address
COM_CODE	Company code
COM_NAME	Company name
COM_STREET1	Street address 1
COM_STREET2	Street address 2
COM_CITY	City
COM_STATE	State
COM_ZIP	Zip
COM_COUNTRY	Country
COM_PHONE	Phone number
COM_FEDID	Federal tax ID
COM_ACCTPOL	Accounting policy
COM_NAME_ON_BILL	Print company name on bill
COM_NAME_ON_REN	Print company name on renewal
COM_EXTRACT	Accounting extraction counter
COM_YEAR	Accounting year
COM_PERIOD	Accounting period
COM_GLFORMAT	File format for journal extract files
COM_GLSEPARATOR	Publication code/account code separator for journal extract files
COM_GLCREATE	Y if GL accounts should be created when pub created or modified
COM_ACCT_ID	Element Express account ID
COM_ACCT_TOKEN	Element Express account token
COM_ACCEPTOR	Element Express acceptor
COM_TERM_ID	Element Express terminal ID
COM_CCARDS	Names of credit cards that are accepted

CTY	County table record
CTY_DBACTY	County table database address
CTY_SEQ	Sequence number
CTY_DESC	County table description
CTY_FROMZIP	Low zip code
CTY_TOZIP	High zip code

CUS	Customer records
CUS_DBACUS	Customer database address
CUS_CUSTNUM	Customer number
CUS_DEMCODEA	Demographic code A
CUS_DEMCODEB	Demographic code B
CUS_DEMCODEC	Demographic code C
CUS_DEMCODED	Demographic code D
CUS_CASSDATE	Date of CASS certification
CUS_CREATION_DATE	Date customer record was created
CUS_POSTAL_DATE	Date of last postal address change
CUS_EMAIL_DATE	Date of last email address change
CUS_FAX_DATE	Date of last fax number change
CUS_PHONE_DATE	Date of last phone number change
CUS_LASTFIRST	Last name/suffix, first name
CUS_FIRSTLAST	Prefix/first name/last name/suffix
CUS_LNAME	Last name
CUS_INITIAL	First initial
CUS_FNAME	First name
CUS_PREFIX	Name prefix
CUS_SUFFIX	Name suffix
CUS_TITLE	Title
CUS_DEPARTMENT	Department
CUS_COMPANY	Company
CUS_STREET1	Street address 1
CUS_STREET2	Street address 2
CUS_CITY	City
CUS_STATE	State
CUS_ZIP	Zip/Postal code
CUS_ZIP2	Zip+2
CUS_CARRT	Carrier route
CUS_CNTRYCODE	Country code
CUS_COUNTRY	Country name
CUS_TAXJR	Tax jurisdiction
CUS_PHONE	Phone number
CUS_CELLPHONE	Cell phone number
CUS_FAX	Fax number
CUS_EMAIL	Email address
CUS_EMAIL2	Secondary email address
CUS_USERID	User ID
CUS_PASSWORD	Password
CUS_SALUTE	Salutation
CUS_SEX	Sex
CUS_TAXABLE	Taxable
CUS_RANDOM	Random number
CUS_BADSEED	Bad debt/Seed flag (B="bad debt" customer, S="seed," and space=normal customer)
CUS_RENT_POSTAL	Postal address use flag (Y=all uses allowed, I=in-house uses allowed, R=send renewal notices only, and N=no use allowed)
CUS_RENT_EMAIL	Email address use flag (Y=all uses allowed, I=in-house uses allowed, R=send renewal notices only, and N=no use allowed)
CUS_RENT_PHONE	Phone number use flag (Y=all uses allowed, I=in-house uses allowed, R=send renewal notices only, and N=no use allowed)
CUS_RENT_FAX	Fax number use flag (Y=all uses allowed, I=in-house uses allowed, R=send renewal notices only, and N=no use allowed)
CUS_POSTAL_VALID	For future use
CUS_EMAIL_VALID	For future use
CUS_PHONE_VALID	For future use
CUS_FAX_VALID	For future use
CUS_DEMDATA1	Demographic data 1
CUS_DEMDATA2	Demographic data 2
CUS_SELFLAGS	Selection flags (1 through 8)
CUS_FORMAT	Foreign postal code position
CUS_MATCH	Match code
CUS_EXTID	External customer ID

FOR (also FRN)	Foreign country record
FOR_DBAFOR	Foreign country database address
FOR_CODE	Foreign country code
FOR_COUNTRY	Foreign country name
FOR_SHIPCLASS	Default shipping class
FOR_FORMAT	Foreign postal code position
FOR_REGION	Region number

GLO	Global record
GLO_DBAGLO	Global record database address
GLO_SEQ	Sequence number
GLO_HOME	Home country code
GLO_LAST_WID	For future use

GLO_MATCHCODE_FORMAT

Sort order for match code (0=Zip/Name/Company, 1=Zip/Company/Name)

GLO_DATE_FORMAT

Date format

GLO_MATCH

Minimum match requirement (1=Country code, postal code, soundex of last name, and soundex of company name, 2=Country code, postal code, and soundex of last name, 3=country code and postal code only)

GLO_MATCH_EXACT	Exact match score
GLO_MATCH_NEAR	Near match score
GLO_SHIPDESCA-Z	Description for shipping classes A-Z
GLO_LNAME_SOUNDEX	Value for last name soundex mismatch
GLO_LNAME_ACTUAL	Value for last names mismatch
GLO_FNAME_INIT_NM	Value for first name initials mismatch
GLO_FNAME_INIT_OK	Value for full first name vs. initial
GLO_FNAME_SOUNDEX	Value for first name soundex mismatch
GLO_FNAME_ACTUAL	Value for first name mismatch
GLO_PREFIX_MISMATCH	Value for prefix mismatch
GLO_SUFFIX_MISMATCH	Value for suffix mismatch
GLO_SEX_MISMATCH	Value for sex mismatch
GLO_TITLE_MISMATCH	Value for title mismatch
GLO_DEPT_MISMATCH	Value for department mismatch
GLO_ZIP4_ONE_ONLY	Value for zip4 on one address only
GLO_ZIP4_MISMATCH	Value for zip4 mismatch
GLO_BOX_ONE_ONLY	Value for PO box on one address only
GLO_BOX_MISMATCH	Value for PO box mismatch
GLO_HOUSE_ONE_ONLY	Value for house number on one address only
GLO_HOUSE_MISMATCH	Value for house number mismatch
GLO_STREET_ONE_ONLY	Value for street1 on one address only
GLO_STREET_SOUNDEX	Value for street1 soundex mismatch
GLO_STREET_ACTUAL	Value for street1 mismatch
GLO_UNIT_ONE_ONLY	Value for unit number on one address only
GLO_UNIT_MISMATCH	Value for unit number mismatch
GLO_PDIR_ONE_ONLY	Value for prefix direction on one address only
GLO_PDIR_MISMATCH	Value for prefix direction mismatch
GLO_SDIR_ONE_ONLY	Value for suffix direction on one address only
GLO_SDIR_MISMATCH	Value for suffix direction mismatch
GLO_COMP_ONE_ONLY	Value for company on one address only
GLO_COMP_SOUNDEX	Value for company soundex mismatch
GLO_COMP_ACTUAL	Value for company mismatch
GLO_LABEL_MISMATCH	Value for label images mismatch
GLO_LIMIT_ADDRESS	Address length indicator (0 = address lines may be up to 40 characters long, 1= address lines are limited to 30 characters)
GLO_REGION1-6	Name for regions 1-6
GLO_RENT_POSTAL	Default allowed usage of postal address
GLO_RENT_EMAIL	Default allowed usage of email address
GLO_RENT_PHONE	Default allowed usage of phone number
GLO_RENT_FAX	Default allowed usage of fax number
GLO_GUID	Global unique identifier

GLX	General ledger record
GLX_DBAGLX	General ledger record database address
GLX_PUB	Publication code
GLX_ACCT	Account code
GLX_PTDAMOUNT	Period to date amount in pennies
GLX_YTDAMOUNT	Year to date amount in pennies
GLX_ITDAMOUNT	Inception to date amount in pennies
GLX_UNEXAMOUNT	Unextracted amount in pennies
GLX_PASSPUB	Publication code for accounting system
GLX_PASSACCT	Account number for accounting system
GLX_BASIS	Accounting basis (A=Accrual, B=Both, C=Cash)

HIS	Subscription history record
HIS_DBAHIS	History database address
HIS_SEQ	Sequence number
HIS_DBASUB	Subscription database address
HIS_DATE	Date of transaction
HIS_BATCH	Batch number
HIS_TRAN	Transaction type
HIS_USER	QuickFill user ID associated with the subscription history entry
HIS_CRDB	Amount credited/debited in pennies
HIS_DUE	Amount due in pennies
HIS_DESC	Description

ISS	Issue table
ISS_DBAISS	Issue record database address
ISS_DBAPUB	Publication database address
ISS_PUB	Publication code
ISS_NUM	Issue number
ISS_PAID	Non-comp copies served
ISS_COMP	Comp copies served
ISS_WEIGHT	Mailing weight
ISS_PAGES	Number of pages in issue (scaled by 1000)
ISS_ADPAGES	Number of ad pages in issue (scaled by 1000)
ISS_DATE	Issue date
ISS_CALDATE	Issue calendar date
ISS_DESC1	Issue description - part 1
ISS_DESC2	Issue description - part 2
ISS_VOLNUM	Volume number
ISS_VOLISS	Volume issue
ISS_AUDITISS	Audit issue
ISS_FREE	Free non-comp issues served
ISS_MAILED	Total copies mailed
ISS_SINGLECOPIES	Single copies sold
ISS_TRADESHOWS	Copies distributed at trade shows
ISS_LASTUPDT	Last update date and time
ISS_EIC_CURRENT	Earned income cash as current issue
ISS_EIC_BACK	Earned income cash as back issue
ISS_EIA_CURRENT	Earned income accrual as current issue
ISS_EIA_BACK	Earned income accrual as back issue

LIS	List record
LIS_DBALIS	List database address
LIS_CODE	List code
LIS_DESC	Description
LIS_CPM	Cost per thousand in pennies
LIS_DATE	Date of list

MPK	Marketing package record
MPK_DBAMPK	Package record database address
MPK_CODE	Package code
MPK_FIXCOST	Fixed cost in pennies
MPK_VARCOST	Variable cost in pennies
MPK_DESC	Description
MPK_CIRC	Circular ID
MPK_LETT	Letter ID
MPK_CARD	Card ID
MPK_BUCK	Buckslip ID
MPK_ENV	Envelope ID
MPK_REPL	Reply envelope ID
MPK_FORM	Form ID
MPK_MISC1	Miscellaneous user field 1
MPK_MISC2	Miscellaneous user field 2

MPL	Plan record
MPL_DBAMPL	Marketing plan database address
MPL_CODE	Plan code
MPL_DATE	Plan date
MPL_DESC	Description
MPL_HOUSE	Mail house

MSG	Message record
MSG_DBAMSG	Message database address
MSG_LINE1	Message line 1
MSG_LINE2	Message line 2
MSG_LINE3	Message line 3
MSG_LINE4	Message line 4

OFF	Offer record
OFF_DBAOFF	Offer record database address
OFF_DBAPRE1	1st premium database address
OFF_DBAPRE2	2nd premium database address
OFF_DBAPRE3	3rd premium database address
OFF_DBAPUB	Publication database address
OFF_PUB	Publication code
OFF_CODE	Offer code
OFF_DESC	Offer description
OFF_TERMDESC	Term description for renewal notice
OFF_PRICE1	Price for region 1 in pennies
OFF_PRICE2	Price for region 2 in pennies
OFF_PRICE3	Price for region 3 in pennies
OFF_PRICE4	Price for region 4 in pennies
OFF_PRICE5	Price for region 5 in pennies
OFF_PRICE6	Price for region 6 in pennies
OFF_FBILLDATE	First bill date
OFF_ISSUES	Number of issues
OFF_QTY	Minimum quantity
OFF_SERVICE	Service code
OFF_FREE	Free issues
OFF_PREMDEL	Deliver premium with 1st issue
OFF_FBILLDAYS	Days until first bill
OFF_FBILLPOLICY	0=use pub policy, 1=immediate, 2=with issue, 3=days after issue, 4=specified date
OFF_FREE_TIMING	Free issues are first/last
OFF_FREEQUAL	Qualifications for free issues (A=all orders, P=paid orders)
OFF_PREMQUAL	Qualifications for premium (A=all orders, W=payment with order, L=payment later)
OFF_PREMBILLTO	Send premium to bill-to

ORD	Order record
ORD_DBAORD	Order database address
ORD_DBASUB	Subscription database address
ORD_DBACMB	Combo database address
ORD_DBARSR	Renewal series database address
ORD_DBABSR	Billing series database address
ORD_DBASAG	Agency database address
ORD_NUM	Order number
ORD_COMBO	Combo number
ORD_PUB	Publication code
ORD_AGENCY	Agency code for subscription agency order
ORD_DATE	Order date
ORD_DBA_RENEWED_ORDER	Database address of the renewed order (if this order is a renewal order)
ORD_DBA_RENEWAL_ORDER	Database address of the renewal order (if this order has been renewed)
ORD_DBA_REPLACED_ORDER	Database address of the replaced order (if this order is a replacement order -- e.g., it belongs to a group subscription and was created by a change to the membership of the group)
ORD_DBA_REPLACEMENT_ORDER	Database address of the replacement order (if this order has been replaced -- e.g., it belongs to a group subscription and was replaced due to a change to the membership of the group)
ORD_FIRSTISSUESERVED	Date first issue was served (used to be ORD_FIRSTISSUEDATE)
ORD_LASTISSUESERVED	Date most recent issue was served (used to be ORD_LASTISSUEDATE)
ORD_FBILLDATE	Send first bill on or after this date
ORD_FIRSTBILLDATE	Date of the first bill
ORD_LASTBILLDATE	Date of most recent bill
ORD_LASTPAYDATE	Date of most recent payment
ORD_LASTRENDATE	Date of most recent renewal notice
ORD_PREMSENTDATE	Date premium was sent
ORD_PRICE	Price of order in pennies
ORD_TAX	Sales tax in pennies
ORD_SHIPPING	Shipping charge in pennies
ORD_FPRICEIN	Full price in pennies including tax and shipping
ORD_FPRICE	Full price in pennies after cancel adjustment
ORD_FPAY	Amount paid in pennies
ORD_REFUND	Amount refunded in pennies
ORD_REFUNDDUE	Refund amount (in pennies) not yet paid out
ORD_AR	Amount due in pennies
ORD_EIA	Earned income accrual in pennies
ORD_EIC	Earned income cash in pennies
ORD_DIA	Deferred income accrual in pennies
ORD_DIC	Deferred income cash in pennies
ORD_WOA	Writeoff accrual in pennies
ORD_DISCRATE	Discount rate used to calculate the price for a subscription agency order (e.g., 7.5% = 75)
ORD_BATCH	Batch number
ORD_TYPE	Order type (NEW=new order, REN1=first renewal, REN2=subsequent renewal)
ORD_REPLACEMENT	Replacement order flag
ORD_CONTROLLED	Controlled order flag
ORD_WEB	Web order flag
ORD_QUANTITY	Number of copies
ORD_ISSUES	Number of issues
ORD_FREE	Number of free issues
ORD_EXT	Number of extension issues
ORD_ISSREM	Number of issues remaining
ORD_SERVED	Number of issues served
ORD_EARNSRVD	Number of earned issues served
ORD_FIRSTISS	Issue number of first issue served
ORD_FIRSTISSDATE	Issue date of the first issue served
ORD_NEXTISS	Issue number of next issue to be served
ORD_NEXTISSDATE	Issue date of the next issue to be served
ORD_LASTISS	Issue number of last issue served
ORD_LASTISSDATE	Issue date of the last issue served
ORD_PREMQUAL	Qualified for premium
ORD_PREMDEL	Deliver premium with first issue
ORD_PREMBILLTO	Send premium to bill-to
ORD_PREMSRV	Premium served
ORD_FBILLDAYS	Days until first bill
ORD_LASTBILLEFF	Last billing effort number
ORD_RSPBILLNUM	Responded to billing effort
ORD_LASTRENEFF	Last renewal effort number
ORD_RSPRENUM	Responded to renewal effort
ORD_STATUS	Order status
ORD_CBILLSENT	Cancel bill sent
ORD_DELTACAN	Order canceled
ORD_DELTAADJ	Order written off
ORD_DELTAPRF	Free issue served first
ORD_SERVICE	Service code
ORD_FBILLPOLICY	1=immediate, 2=with issue, 3=days after issue, 4=specified date
ORD_GIFTCOMP	Gift/Complimentary flag
ORD_SHIPCLASS	Shipping class
ORD_PREMIUM	Premium code
ORD_PAYTYPE	Payment type
ORD_PAYNUM	Identifying number for payment account
ORD_PONUM	Purchase order number
ORD_TAXJR	Tax jurisdiction
ORD_SUBCLASS	Subscription class
ORD_REQTYPE	Request type
ORD_SOURCE	Order source
ORD_CHANNEL	Order channel
ORD_CNREASON	Cancel reason code
ORD_EXTID	External order ID

PAY	Payment transactions record

The payment transactions record contains data related to payments (including reversals of payments). It lists orders and any of the following transactions applied to those orders: new orders with an accompanying payment, renewal orders with an accompanying payment, payments processed after the original order is entered, bounced payments, refunds, cancellations that include a refund, and transfers. The fields in this record are based on the subscription history record as well as the publication, subscription, order, and customer records and are useful for computing sales commissions. For performance reasons you should use a date range to select transactions when querying this table.

The PAY table is a "virtual" table that is constructed on the fly from several different database records. The PMT table is newer, faster and more accurate than the PAY table. You can use the PMT table to get the same information as the PAY table if you join the PMT table to the ORD, SUB and CUS tables using these joins: PMT_DBAORD = ORD_DBAORD, ORD_DBASUB = SUB_DBASUB and SUB_DBACUS = CUS_DBACUS.

PAY_DBAPAY	Payment transaction record database address
PAY_DBASUB	Subscription database address
PAY_PUB	Publication code
PAY_ORDNUM	Order number
PAY_ORDTYPE	Order type (NEW=new order, REN1=first renewal, REN2=subsequent renewal)
PAY_ORDDATE	Order date
PAY_ORDPRICE	Order price in pennies (not including tax and shipping)
PAY_COPIES	Number of copies
PAY_TRANDATE	Transaction date
PAY_TRAN	Transaction type
PAY_AMOUNT	Amount of the transaction in pennies (depending on the transaction, this may be positive or negative)
PAY_TYPE	Payment type
PAY_PAYNUM	Identifying number for payment account. If there are multiple payments for the same order, all payments are listed with the most recent number entered.
PAY_SUBCHANNEL	Original subscription channel code
PAY_ORDCHANNEL	Order channel (for new and renewal orders)
PAY_CUSTNUM	Customer number for the bill-to customer
PAY_NAME	Last name/suffix, first name for the bill-to customer
PAY_COMPANY	Company name for the bill-to customer
PAY_STATE	State for the bill-to customer
PAY_ZIP	Zip/postal code for the bill-to customer
PAY_CNTRYCODE	Country code for the bill-to customer
PAY_ACTIVEP	The number of active periodical subscriptions held by the bill-to customer
PAY_ACTIVEB	The number of active book subscriptions held by the bill-to customer
PAY_ACTIVES	The number of active service subscriptions held by the bill-to customer
PAY_ACTIVEC	The number of active conference subscriptions held by the bill-to customer
PAY_ACTIVEM	The number of active membership subscriptions held by the bill-to customer
PAY_ACTIVEO	The number of active online service subscriptions held by the bill-to customer
PAY_INACTIVEP	The number of inactive periodical subscriptions held by the bill-to customer
PAY_INACTIVEB	The number of inactive book subscriptions held by the bill-to customer
PAY_INACTIVES	The number of inactive service subscriptions held by the bill-to customer
PAY_INACTIVEC	The number of inactive conference subscriptions held by the bill-to customer
PAY_INACTIVEM	The number of inactive membership subscriptions held by the bill-to customer
PAY_INACTIVEO	The number of inactive online service subscriptions held by the bill-to customer

PRE	Premium record
PRE_DBAPRE	Premium record database address
PRE_CODE	Premium code
PRE_DESC	Premium description
PRE_PICKNUM	Pick number
PRE_REPRINT	Editorial reprint flag
PRE_VALUE	Value of the premium in pennies

PMT	Payment trail record
PMT_DBAPMT	Payment database address
PMT_DBAORD	Order database address
PMT_TICKETNUM	Ticket number assigned to credit card transactions by QuickFill
PMT_DATE	Date of transaction
PMT_BATCH	QuickFill batch number of transaction
PMT_TRANS	Transaction type
PMT_AMOUNT	Amount of payment, refund, bounced payment or adjustment
PMT_ADJUSTMENT	Amount that payment has been adjusted, either up or down
PMT_ADJUSTMENT_OF	For adjustments, database address of payment that was adjusted
PMT_TRANSFER_FROM_TO	Database address of order that transfer was to or from
PMT_REFUND_STATE	1 = Refund is pending, 2 = Refund is complete
PMT_TYPE	Two character type code of payment
PMT_PAYNUM	Check number or last 4 digits of credit card number
PMT_USER	QuickFill user that entered the payment
PMT_TRANSID	Transaction ID assigned to credit card transactions by EPS
PMT_APPROVAL	Approval code for credit card transactions
PMT_AVSRESP	AVS response code for credit card transactions
PMT_HOSTBATCH	Host batch number for credit card transactions
PMT_HOSTITEM	Item number within batch for credit card transactions

PRO	Prospect record
PRO_DBAPRO	Prospect database address
PRO_DBACUS	Customer database address
PRO_DBALIS	List database address
PRO_DBAPUB	Publication database address
PRO_DATE	Prospect date
PRO_PUB	Publication code
PRO_LIST	List code
PRO_REQTYPE	Request type

PUB	Publication record
PUB_DBAPUB	Publication database address
PUB_DBACOM	Company database address
PUB_DBATAX	Tax table database address
PUB_DBASPT	Split table database address
PUB_DBAZON	Periodical class zone table database address
PUB_DBACTY	County table database address
PUB_DBASCF	SCF table database address
PUB_DBARSR	Default renewal series database address
PUB_DBABSR	Default billing series database address
PUB_CODE	Publication code
PUB_CURISS	Database address for the issue record marked with the current issue pointer
PUB_NEWISS	Database address for the issue record marked with the new orders issue pointer
PUB_EXPISS	Database address for the issue record marked with the controlled expire issue pointer
PUB_MINBILL	Minimum bill amount in pennies
PUB_MINREFUND	Minimum refund amount in pennies
PUB_OVERPAYREF	Auto refund of overpayments
PUB_ISSUES_YEAR	Issues per year
PUB_GRACEISS	Grace issues
PUB_RENEWBACK	Maximum issues to backstart renewal
PUB_REINSBACK	Maximum issues to backstart reinstate
PUB_BILLCANC	Bill unpaid balance on cancel
PUB_LABELMULT	Multiple labels for multiple copies

PUB_LABELOPT1	Label top line option 1 (O=order number, E=expire issue, C=customer number, B=publication code, P=purchase order number, Q=quantity, D=demographic data 1, S=shipping class, V=service code, R=premium code)
PUB_LABELOPT2	Label top line option 2 (see PUB_LABELOPT1 for possible values)
PUB_LABELOPT3	Label top line option 3 (see PUB_LABELOPT1 for possible values)
PUB_LABELOPT4	Label top line option 4 (see PUB_LABELOPT1 for possible values)
PUB_LABELOPT5	Label top line option 5 (see PUB_LABELOPT1 for possible values)

PUB_TYPE	Publication type
PUB_AUDITED	Is publication audited (Y or N)
PUB_AUDIT_TYPE	Type of audit (BPA_BUSINESS, BPA_CONSUMER, ABC_BUSINESS, ABC_MAGAZINE or VAC)
PUB_FBILLDAYS	Days until first bill
PUB_MINGRACE	Minimum term for gracing
PUB_DEDUCT_GRACED	Deduct graced issues from renewal
PUB_ACTIVE	Print issue labels
PUB_ORDERS	Accept orders
PUB_EXPORT	Export publication to the QFIE web server
PUB_RENUNPAID	Renew unpaid orders
PUB_FBILLPOLICY	1=immediate, 2=with issue, 3=days after issue
PUB_NAME1	Publication name part 1
PUB_NAME2	Publication name part 2
PUB_PAYTO	Checks payable to
PUB_QFMDATE	Date of qualification form
PUB_OVERRIDE_SHIP1	Shipping code override for region 1
PUB_OVERRIDE_SHIP2	Shipping code override for region 2
PUB_OVERRIDE_SHIP3	Shipping code override for region 3
PUB_OVERRIDE_SHIP4	Shipping code override for region 4
PUB_OVERRIDE_SHIP5	Shipping code override for region 5
PUB_OVERRIDE_SHIP6	Shipping code override for region 6
PUB_MINCANCEL	Minimum cancel amount in pennies
PUB_PRICING	Pricing scheme
PUB_TAX_SHIPPING	Charge tax on shipping
PUB_PREMIUM_SHIP	Premiums are shipped using order shipclass
PUB_QDTREQ	Qualification data required for paid subscriptions flag
PUB_MIN_PRESORT	Minimum label group size for presort
PUB_DELAY_RENBILL	Delay renewal bill
PUB_SHIPCOSTA-Z	Shipping cost per issue in pennies for shipping classes A-Z
PUB_PRESORT	26 Y/N flags indicating whether each shipping class should be presorted

QDT	Qualification data record
QDT_DBAQDT	Qualification data database address
QDT_SEQ	Sequence number
QDT_DBASHP	Ship-to database address
QDT_DATE	Qualification date
QDT_BATCHDATE	Batch date
QDT_BATCH	Batch number
QDT_PERSID	Personal ID
QDT_NUM	Question number
QDT_CODE	Response

QFM	Qualification form record
QFM_SEQ	Sequence number
QFM_DBAQFM	Qualification form database address
QFM_DBAPUB	Publication database address
QFM_QUEST	Question number
QFM_QUESTDESC	Question description
QFM_REQD	Question required
QFM_VALUES	Number of values that may be entered
QFM_CODE	Code value
QFM_CODEDESC	Code description
QFM_DISP_SEQ	Display sequence number for web server
QFM_TAB_ORDER	Table column order for web server
QFM_DISP_TYPE	Question display type for web server
QFM_EXQUESTDESC	Extended question description for web server
QFM_EXCODEDESC	Extended code description for web server
QFM_TAB_HEADING	Table column heading for web server

REF	Renewal effort record
REF_DBAREF	Renewal effort database address
REF_DBAPUB	Publication database address
REF_DBARPK	Renewal package database address
REF_DBAOFF1 to 9	Offer database address 1 to 9
REF_DBACHN	Channel database address
REF_PUB	Publication code
REF_CODE	Renewal effort code
REF_DESC	Description
REF_DATEMAIL	Date mailed
REF_QTYMAIL	Quantity mailed
REF_PREPAY_DOLLARS	Prepayment discount, in pennies
REF_PREPAY_PERCENT	Prepayment discount as a percentage, scaled by 100

RNL	Run log record
RNL_DBARNL	Run log database address
RNL_DATETIME	Run date and time
RNL_BUILD	QuickFill build number in which the run took place
RNL_DESC	Run description
RNL_PUB	Publication code associated with the run (for updates only)
RNL_CURRISS	Current issue associated with the run (for updates only)
RNL_NOW_LATER	Run now, run later indicator (contains "N" or "L")
RNL_USER	QuickFill user associated with the run
RNL_MACHINE	Computer name for the machine associated with the run
RNL_PARM	Run parameters (the command line options used to start QuickFill, the input file for an import, number of errors found by a database check, or the path for a backup file)

RPK	Renewal package record
RPK_DBARPK	Renewal package database address
RPK_CODE	Package code
RPK_FIXCOST	Fixed cost in pennies
RPK_VARCOST	Variable cost in pennies
RPK_CCINFO	Print credit card information block
RPK_DESC	Description
RPK_CIRC	Circular ID
RPK_LETT	Letter ID
RPK_CARD	Card ID
RPK_BUCK	Buckslip ID
RPK_ENV	Envelope ID
RPK_REPL	Reply envelope ID
RPK_FORM	Form ID
RPK_MISC1	Miscellaneous user field 1
RPK_MISC2	Miscellaneous user field 2
RPK_TYPE	Output type: S=Simple, X=Detailed, L=Label, C=Mail-merge
RPK_CUSTCODE	Mail-merge format code
RPK_DELIVERY	Delivery method: P=Postal, E=Email or Postal, O=Email only

RQS	Requalification source
RQS_DBARQS	Requalification source database address
RQS_CODE	Requalification source code
RQS_DESC	Requalification source description
RQS_DATEMAIL	Date mailed
RQS_QTYMAIL	Quantity mailed

RSR	Renewal series record (no message links)

Note: Renewal series table and Microsoft Access

Microsoft Access has a limit of 32 indexes for ODBC tables. If you are using Microsoft Access and want to use renewal series data from QuickFill, you can either use the RSR table (this table does not contain links to the messages used by a renewal series) or, if you have some technical expertise in using Access, use the RSX table (this table contains links to the messages used by a renewal series) and write SQL pass-through queries to get around this limitation.

RSR_DBARSR	Renewal series database address
RSR_DBAPUB	Publication database address
RSR_DBAREF1 to 12	Database address of renewal efforts 1 to 12
RSR_DBARSR_NEXT	Database address of next renewal series
RSR_DBARSR_NEXT_CONTR	Database address of next renewal series for controlled subscritpions (audit system)
RSR_DBARSR_NEXT_GIFT	Database address of next renewal series for gift subscriptions
RSR_DBABSR_NEXT	Database address of next billing series
RSR_DBABSR_NEXT_GIFT	Database address of next billing series for gift subscriptions
RSR_PUB	Publication code
RSR_CODE	Renewal series code
RSR_DESC	Description
RSR_TYPE	Series type
RSR_WITHISS1 to 12	With issue for efforts 1 to 12
RSR_WHO1 to 12	Billto or Shipto for efforts 1 to 12
RSR_TIMING1 to 12	Days between or issues remaining 1 to 12
RSR_NUMEFFS	Number of efforts in series
RSR_STARTISSUE	Start when issues remaining
RSR_STARTDAYS	Days delay before starting
RSR_ENDISSUE	End when issues remaining
RSR_AGENCY	Send notice for agency subscriptions to subscriber
RSR_AUTORENEW	Auto-renewal option. 0 = No auto-renewal. 1 = Auto-renew and bill amount due. 2 = Auto-renewal by credit card.
RSR_PRTPONUM	Print purchase order number
RSR_PRTPUB1	Print pub name on top half
RSR_PRTPUB2	Print pub name on bottom half
RSR_DOCDESC1	Wording in lieu of "Subscription"
RSR_DOCDESC2	Wording in lieu of "Renewal"
RSR_DOCDESC3	Wording in lieu of "Please return this portion."
RSR_DOCDESC4	Wording in lieu of "For your"
RSR_DOCDESC5	Wording in lieu of "records"
RSR_NO_GRACE	Do not send grace issues to orders linked this series

RSX	Renewal series record (with message links)

Note: Renewal series table and Microsoft Access

RSX_DBARSX	Renewal series database address
RSX_DBAPUB	Publication database address
RSX_DBAREF1 to 12	Database address of renewal efforts 1 to 12
RSX_DBAMSG1 to 12	Database address of message 1 for efforts 1 to 12
RSX_DBAMSG21 to 12	Database address of message 2 for efforts 1 to 12
RSX_DBARSX_NEXT	Database address of next renewal series
RSX_DBARSX_NEXT_CONTR	Database address of next renewal series for controlled subscritpions (audit system)
RSX_DBARSX_NEXT_GIFT	Database address of next renewal series for gift subscriptions
RSX_DBABSR_NEXT	Database address of next billing series
RSX_DBABSR_NEXT_GIFT	Database address of next billing series for gift subscriptions
RSX_PUB	Publication code
RSX_CODE	Renewal series code
RSX_DESC	Description
RSX_TYPE	Series type
RSX_WITHISS1 to 12	With issue for efforts 1 to 12
RSX_WHO1 to 12	Billto or Shipto for efforts 1 to 12
RSX_TIMING1 to 12	Days between or issues remaining 1 to 12
RSX_NUMEFFS	Number of efforts in series
RSX_STARTISSUE	Start when issues remaining
RSX_STARTDAYS	Days delay before starting
RSX_ENDISSUE	End when issues remaining
RSX_AGENCY	Send notice for agency subscriptions to subscriber
RSX_AUTORENEW	Auto-renewal option. 0 = No auto-renewal. 1 = Auto-renew and bill amount due. 2 = Auto-renewal by credit card.
RSX_PRTPONUM	Print purchase order number
RSX_PRTPUB1	Print pub name on top half
RSX_PRTPUB2	Print pub name on bottom half
RSX_DOCDESC1	Wording in lieu of "Subscription"
RSX_DOCDESC2	Wording in lieu of "Renewal"
RSX_DOCDESC3	Wording in lieu of "Please return"
RSX_DOCDESC4	Wording in lieu of "For your"
RSX_DOCDESC5	Wording in lieu of "records"
RSX_NO_GRACE	Do not send grace issues to orders linked this series

SAG	Subscription agency record
SAG_DBASAG	Agency database address
SAG_CODE	Agency code
SAG_NAME	Company name
SAG_DEPT	Department
SAG_STREET1	Street address 1
SAG_STREET2	Street address 2
SAG_CITY	City
SAG_STATE	State
SAG_ZIP	Zip
SAG_CNTRYCODE	Country code
SAG_COUNTRY	Country name
SAG_PHONE	Phone number
SAG_FAX	Fax number
SAG_EMAIL	Email address
SAG_FORMAT	Foreign postal code position
SAG_DISCTRTENEW	Discount rate new orders (scaled by 100, e.g., 7.5% = 750)
SAG_DISCTRTEREN	Discount rate renewal orders (scaled by 100, e.g., 7.5% = 750)

SCA	SCA table record
SCA_DBASCA	Scheduled address change database address
SCA_DBACUS	Customer database address
SCA_STREET1	Street address 1
SCA_STREET2	Street address 2
SCA_CITY	City
SCA_STATE	State
SCA_ZIP	Zip/Postal code
SCA_ZIP2	ZIP+2
SCA_CARRT	Carrier route
SCA_CNTRYCODE	Country code
SCA_COUNTRY	Country name
SCA_PHONE	Phone number
SCA_FAX	Fax number
SCA_BEGINDATE	Effective date
SCA_ENDDATE	Ending date
SCA_RECURRING	Recurring change

SCF	SCF table record
SCF_DBASCF	SCF table database address
SCF_SEQ	Sequence number
SCF_DESC	SCF table description
SCF_FROMZIP	Low zip
SCF_TOZIP	High zip

SHP	Ship-to record (contains data for single as well as two-party and group subscriptions)

SHP_DBASHP	Ship-to database address
SHP_DBASUB	Subscription database address
SHP_DBACUS	Ship-to customers database address
SHP_QUANTITY	Ship-to quantity
SHP_SHIPCLASS	Ship-to shipping class

SHP_RENEW_FLAG

Individually renewed flag (This field contains "I" if the customer used to be part of a group subscription and individually renewed. Click here for more information on two-party and group subscription renewals.)

SHP_CUSTNUM	Customer number
SHP_DEMCODEA	Demographic code A
SHP_DEMCODEB	Demographic code B
SHP_DEMCODEC	Demographic code C
SHP_DEMCODED	Demographic code D
SHP_CASSDATE	Date of CASS certification
SHP_CREATION_DATE	Date customer record was created
SHP_POSTAL_DATE	Date of last postal address change
SHP_EMAIL_DATE	Date of last email address change
SHP_FAX_DATE	Date of last fax number change
SHP_PHONE_DATE	Date of last phone number change
SHP_LASTFIRST	Last name/suffix, first name
SHP_FIRSTLAST	Prefix/first name/last name/suffix
SHP_LNAME	Last name
SHP_INITIAL	First initial
SHP_FNAME	First name
SHP_PREFIX	Name prefix
SHP_SUFFIX	Name suffix
SHP_TITLE	Title
SHP_DEPARTMENT	Department
SHP_COMPANY	Company
SHP_STREET1	Street address 1
SHP_STREET2	Street address 2
SHP_CITY	City
SHP_STATE	State
SHP_ZIP	Zip/Postal code
SHP_ZIP2	Zip+2
SHP_CARRT	Carrier route
SHP_CNTRYCODE	Country code
SHP_COUNTRY	Country name
SHP_TAXJR	Tax jurisdiction
SHP_PHONE	Phone number
SHP_CELLPHONE	Cell phone number
SHP_FAX	Fax number
SHP_EMAIL	Email address
SHP_EMAIL2	Secondary email address
SHP_USERID	User ID
SHP_PASSWORD	Password
SHP_SALUTE	Salutation
SHP_SEX	Sex
SHP_TAXABLE	Taxable
SHP_RANDOM	Random number
SHP_BADSEED	Bad debt/Seed flag (B="bad debt" customer, S="seed," and space=normal customer)
SHP_RENT_POSTAL	Postal address use flag (Y=all uses allowed, I=in-house uses allowed, R=send renewal notices only, and N=no use allowed)
SHP_RENT_EMAIL	Email address use flag (Y=all uses allowed, I=in-house uses allowed, R=send renewal notices only, and N=no use allowed)
SHP_RENT_PHONE	Phone number use flag (Y=all uses allowed, I=in-house uses allowed, R=send renewal notices only, and N=no use allowed)
SHP_RENT_FAX	Fax number use flag (Y=all uses allowed, I=in-house uses allowed, R=send renewal notices only, and N=no use allowed)
SHP_POSTAL_VALID	For future use
SHP_EMAIL_VALID	For future use
SHP_PHONE_VALID	For future use
SHP_FAX_VALID	For future use
SHP_DEMDATA1	Demographic data 1
SHP_DEMDATA2	Demographic data 2
SHP_SELFLAGS	Selection flags (1 through 8)
SHP_FORMAT	Foreign postal code position
SHP_MATCH	Match code
SHP_EXTID	External customer ID

SPL	Split record
SPL_DBASPL	Split code database address
SPL_CODE	Split code
SPL_DESC	Split description

SPR	Split table row
SPR_DBASPR	Split table row database address
SPR_DBASPT	Split table database address
SPR_SPLIT	Split code
SPR_FILENUM	File number
SPR_SERVICE	Service code
SPR_SORT_SERVICE	Sort by service flag
SPR_LOW_ISSREM	Low issues remaining
SPR_HIGH_ISSREM	High issues remaining
SPR_SERVED	Issues served
SPR_TERM	Term
SPR_GIFTS	Gift subs flag
SPR_COMPS	Complimentary subs flag
SPR_PAID	Paid subs flag
SPR_SUBTYPE	Subscription type flag
SPR_NEWREN	New/Renewal flag
SPR_COUNTRY	Foreign country code
SPR_LOW_ZIP	Low zip code
SPR_HIGH_ZIP	High zip code
SPR_TRACK	Tracking code
SPR_SOURCE	Order source code of the current order
SPR_BILLSERIES	Billing series
SPR_RENSERIES	Renewal series
SPR_SHIPCLASS	Shipping class
SPR_LOW_COPIES	Low number of copies
SPR_HIGH_COPIES	High number of copies
SPR_LOW_RANDOM	Low random number
SPR_HIGH_RANDOM	High random number
SPR_LOW_QUALAGE	Low qualification age
SPR_HIGH_QUALAGE	High qualification age
SPR_SUBCLASS	Sub class
SPR_REQTYPE	Request type
SPR_SELECTION	Selection flags

SPT	Split table
SPT_DBASPT	Split table database address
SPT_DESC	Split table description

SUB	Subscription record
SUB_DBASUB	Subscription database address
SUB_DBACUS	Customer database address
SUB_DBAPUB	Publication database address
SUB_DBATRK	Tracking code database address
SUB_PUB	Publication code
SUB_DATE	Subscription date
SUB_STATUSDATE	Status change date
SUB_CANCELDATE	Cancel date
SUB_TOTALAR	Total amount due in pennies
SUB_RENUM	Number of renewals
SUB_SERVICE	Service code
SUB_TOTALISSREM	Total issues remaining
SUB_STATUS	Subscription status
SUB_EXPISS	Issue number of expiration issue
SUB_EXPISSDATE	Issue date of the expiration issue
SUB_LASTISS	Issue number of the last issue served
SUB_LASTISSDATE	Issue date of the last issue served

SUB_CANCEXPFLG

Cancel at expiration flag (NULL=not set, SC=renewal series completed, CX=canceled at expiration)

SUB_FUT_PREMNEED	Future order needs premium
SUB_GIFTCOMP	Gift/Complimentary flag
SUB_TYPE	Subscription type
SUB_TRACK	Tracking code
SUB_CHANNEL	Original channel
SUB_LIST	List code
SUB_PLAN	Plan code
SUB_PACKAGE	Package code
SUB_CURR_ORDER	Database address of the current order
SUB_BILL_ORDER	Database address of the billing order
SUB_LAST_ORDER	Database address of the last order
SUB_CLASS	Subscription class
SUB_ONREASON	Reason for pending addition
SUB_OFFREASON	Reason for pending removal
SUB_CNREASON	Cancel reason code
SUB_REQTYPE	Request type
SUB_QUANTITY	Number of copies
SUB_AUTORENEW	Automatic renewal flag. 0 = none, 1 = automatic renewal, 2 = automatic renewal with reuse of credit card.
SUB_PASSID	EPS ID code for stored credit card payment account
SUB_UPDATE_PENDING	Update of stored credit card is pending

SVC	Service record
SVC_DBASVC	Service record database address
SVC_CODE	Service code
SVC_DESC	Service description
SVC_NOSHIPPING	Indicates if shipping charges apply to this service code
SVC_NOTAX	Indicates if tax should not be charged for this service

SVD	Served issues
SVD_DBASVD	Served issues record database address
SVD_DBASUB	Sub record database address
SVD_SUBCLASS	Subscription class
SVD_REQTYPE	Request type
SVD_SERVICE	Service code
SVD_ONREASON	On reason code
SVD_OFFREASON	Off reason code
SVD_CANREASON	Cancel reason
SVD_DROP	True if forced drop
SVD_QUANTITY	Number of copies
SVD_FIRSTISS	First issue served
SVD_LASTISS	Last issue served
SVD_ORDERNUM	Order number

SVN	Served names
SVN_DBASVN	Served name record database address
SVN_DBASVD	Served issue record database address
SVN_CUSTNUM	Customer number
SVN_QUANTITY	Number of copies
SVN_NAME	Name
SVN_ZIP	Zip/country code

TAX	Tax table
TAX_DBATAX	Tax table database address
TAX_SEQ	Sequence number
TAX_DESC	Tax table description
TAX_CODE	Jurisdiction code
TAX_RATE	Tax rate

TRK	Tracking code record
TRK_DBATRK	Tracking code database address
TRK_DBAPUB	Publication database address
TRK_DBAMPK	Marketing package database address
TRK_DBACHN	Channel database address
TRK_DBAMPL	Plan database address
TRK_DBALIS	List database address
TRK_DBAOFF1 to 9	Offer database address 1 through 9
TRK_DBARSR	Renewal series database address
TRK_DBABSR	Billing series database address
TRK_DBARSR_GIFT	Renewal series for gift subscriptions database address
TRK_DBABSR_GIFT	Billing series for gift subscriptions database address
TRK_PUB	Publication code
TRK_CODE	Tracking code
TRK_DATEMAIL	Date mailed
TRK_EXPDATE	Expiration date
TRK_QTYREQD	Quantity requested
TRK_QTYMAIL	Quantity mailed
TRK_CPM	Cost per thousand in pennies
TRK_PREPAY_DOLLARS	Prepayment discount, in pennies
TRK_PREPAY_PERCENT	Prepayment discount as a percentage (scaled by 100)
TRK_DESC	Description
TRK_TYPE	Gift or complimentary
TRK_PLAN	Marketing plan code
TRK_LIST	List code
TRK_PACKAGE	Package code
TRK_CHANNEL	Channel code
TRK_EXPORT	Export tracking code to the QFIE web server

TXR	Tax jurisdiction ranges record
TXR_DBATXR	Tax jurisdiction table database address
TXR_CNTRYCODE	Country code
TXR_ZIP_LOW	Low zip or postal code
TXR_ZIP_HIGH	High zip or postal code
TXR_JURCODE	Tax jurisdiction code
TXR_JURDESC	Tax jurisdiction description

ZON	Periodical class zone table record
ZON_DBAZON	Periodical class zone table database address
ZON_SEQ	Sequence number
ZON_DESC	Zone table description
ZON_FROMZIP	Low zip
ZON_TOZIP	High zip
ZON_NUM	Zone number