The tables listed below are available when using ODBC to access a QuickFill database.
|
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 |
|
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" |
|
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 |
|
Batch header record | |
|
BTH_DBABTH |
Batch header record database address |
|
BTH_DATE |
Batch date |
|
BTH_NUM |
Batch number |
|
BTH_TYPE |
Batch type |
|
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 |
|
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_CCNUM |
Credit card number |
|
BTP_CCEXPDT |
Credit card expiration date |
|
BTP_CCAUTH |
Credit card authorization |
|
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) |
|
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 |
|
Cancel reasons record | |
|
CNR_DBACNR |
Cancel reason database address |
|
CNR_CODE |
Cancel reason code |
|
CNR_DESC |
Description |
|
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_AMEXM_MID |
American Express merchant ID (mail orders) |
|
COM_AMEXI_MID |
American Express merchant ID (internet orders) |
|
COM_VISAM_MID |
Visa merchant ID (mail orders) |
|
COM_VISAI_MID |
Visa merchant ID (internet orders) |
|
COM_MASTM_MID |
Mastercard merchant ID (mail orders) |
|
COM_MASTI_MID |
Mastercard merchant ID (internet orders) |
|
COM_DISCM_MID |
Discover merchant ID (mail orders) |
|
COM_DISCI_MID |
Discover merchant ID (internet orders) |
|
COM_DINERSM_MID |
Diners Club merchant ID (mail orders) |
|
COM_DINERSI_MID |
Diners Club merchant ID (internet orders) |
|
COM_CCFORMATM |
Credit card output format (mail orders) |
|
COM_CCFORMATI |
Credit card output format (internet orders) |
|
COM_CLIENTIDM |
Credit card client ID (mail orders) |
|
COM_CLIENTIDI |
Credit card client ID (internet orders) |
|
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 |
|
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 |
|
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_FAX |
Fax number |
|
CUS_EMAIL |
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_FORMAT |
Foreign postal code position |
|
CUS_MATCH |
Match code |
|
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 |
|
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 |
|
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) |
|
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 |
|
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 |
|
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 |
|
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 |
|
Plan record | |
|
MPL_DBAMPL |
Marketing plan database address |
|
MPL_CODE |
Plan code |
|
MPL_DATE |
Plan date |
|
MPL_DESC |
Description |
|
MPL_HOUSE |
Mail house |
|
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 |
|
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_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_PUB |
Publication code |
|
OFF_DESC |
Description |
|
OFF_TERMDESC |
Term description for renewal |
|
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 |
|
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_CCAMT |
Unprocessed credit card amount 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_CCNUM |
Credit card number |
|
ORD_CCEXPDT |
Credit card expiration date |
|
ORD_CCAUTH |
Credit card authorization |
|
ORD_CVV2 |
Credit card verification value |
|
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 |
|
Payment transactions record |
Note: Data in the payment transaction 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.
|
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_CCNUM |
Credit card number or check number (if there are multiple payments for the same order, all payments are listed with the most recent credit card/check 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 |
|
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 |
|
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 |
|
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 |