The following table lists database field names associated with archiving.
|
Field name |
Description |
|---|---|
|
ArchiveDate |
Date and time when a message was archived. |
|
COUNT_PAGES_RECEIVED |
Total number of pages in the inbound message, including cover pages if applicable. |
|
COUNT_PAGES_SENT |
Total number of pages in the outbound message, including cover pages if applicable. |
|
FAXCENTER_ROUTED_BY |
FaxCenter operator the Fax was routed by |
|
FAXCENTER_ROUTED_TO |
Name of the final recipient when an inbound message was routed from the server to FaxCenter and then to the final recipient. |
|
MessageContents |
Contents of the inbound message. Company message will be compressed in a ZIP file and stored as binary data in the database. This field is required in the database associated with the Maintenance component if you are storing the files directly into the database. It is not required if you are storing the documents in a folder share. |
|
MessageBodyPath |
Path to the folder where the inbound message has been stored. (Company message will be compressed in a ZIP file.) This field is required in databases associated with the Database connector and the Maintenance component. |
|
PAGES |
Pages that were routed by the FaxCenter Operator |
|
prAccessCode |
Access code associated with an outbound message. |
|
prBillingCode |
Billing code associated with an outbound message. |
|
prConceptuallyInbound |
Indicates whether the message is inbound or outbound. |
|
prDateDelivered |
Date when the server delivered the message to the recipient. |
|
prDateRouted |
Date the fax was routed by FaxCenter |
|
prDateSendAfter |
Date when the server attempts to deliver the message. This value is significant when the sender of the message requested a delay in delivery. |
|
prDateSubmitted |
Date the message was submitted to the server for processing and delivery. |
|
prDestination |
Recipient address specified by the sender. |
|
prDestinationLocalized |
Destination of the message after the address was "localized" by the Dispatch component. |
|
prFinalFormCode |
Format of the final document: G4.TIF, G3.TIF, TEXT.PDF, or PDF |
|
prFinalState |
Numerical code that represents the final state of a message. |
|
prFinalStateError |
Numerical code that represents the error causing the message to fail. |
|
prFinalStateText |
Final state of the message. For example: Delivery |
|
prFinalStatus |
Numerical code that represents the final status of a message. |
|
prFinalStatusText |
Final status of a message within its final state. Company final status might be: Successful or Failed |
|
prJobID |
Job ID number of the message on the server. |
|
prLanguageIdentifier |
Language of the message. This value will be represented by the appropriate country code. |
|
prOmtoolServerVersion |
Version of the server that processed the message. |
|
prOriginator |
Identity of the sender. Company value in this field might be an e-mail address, fax address, or other identification. |
|
prOriginatorANI |
Caller ID of the original message sender. |
|
prOriginatorCSI |
Identity of the fax board channel that received the inbound fax. |
|
prOriginatorType |
Numerical code that represents the type of originator. (e-mail, fax, etc.) |
|
prPriority |
Priority of the message as specified by the sender. This value can be High, Normal, or Low. |
|
prProviderTSI |
Identity of the fax device that sent the inbound fax. |
|
prRecipientID |
Job ID number of the message delivered to a recipient. |
|
prRoutingParentRecipientID |
When an inbound fax gets routed to FaxCenter and then to a recipient, this is the job ID number of the original inbound message. |
|
prRecipientType |
Numerical code that represents the type of recipient. (e-mail, fax, etc.) |
|
prTemplateFilename |
Filename of the cover page template that was sent with this message. |
|
prViewedByWebSite |
Integer field that indicates whether a message was routed from FaxCenter. Possible values are 1 if the message was routed from FaxCenter or 0. |
|
RECIP_ASSISTANT_NAME |
Name of the recipient's assistant. |
|
RECIP_ASSISTANT_PHONE |
Telephone number of the recipient's assistant. |
|
RECIP_BUSINESS_ADDRESS |
Address of the recipient's business. |
|
RECIP_BUSINESS_CITY |
City of the recipient's business. |
|
RECIP_BUSINESS_COUNTRY |
Country of the recipient's business. |
|
RECIP_BUSINESS_FAX_PHONE |
Telephone number of the recipient's fax machine. |
|
RECIP_BUSINESS_NAME |
Name of the recipient's business. |
|
RECIP_BUSINESS_PHONE |
Business telephone number of the recipient. |
|
RECIP_BUSINESS_PHONE2 |
Secondary business telephone number of the recipient. |
|
RECIP_BUSINESS_STATE |
State where the recipient's business is located. |
|
RECIP_BUSINESS_STREET |
Street address of the recipient's business. |
|
RECIP_BUSINESS_ZIPCODE |
Zip code of the recipient's business address. |
|
RECIP_COMPANY |
Company name associated with the recipient. |
|
RECIP_CUSTOM1 RECIP_CUSTOM2 RECIP_CUSTOM3 RECIP_CUSTOM4 RECIP_CUSTOM5 RECIP_CUSTOM6 RECIP_CUSTOM7 RECIP_CUSTOM8 RECIP_CUSTOM9 RECIP_CUSTOM10 |
Custom variables associated with the recipient. |
|
RECIP_DEPARTMENT |
Department associated with the recipient. |
|
RECIP_EMAIL |
E-mail address of the recipient. |
|
RECIP_EMAIL2 |
Secondary e-mail address of the recipient. |
|
RECIP_EMAIL3 |
Tertiary e-mail address of the recipient. |
|
RECIP_HOME_ADDRESS |
Home address of the recipient. |
|
RECIP_HOME_CITY |
City of the recipient's home address. |
|
RECIP_HOME_COUNTRY |
Country of the recipients home address. |
|
RECIP_HOME_FAX_PHONE |
Telephone number of the recipient's home fax machine. |
|
RECIP_HOME_PHONE |
Number of the recipient's home telephone. |
|
RECIP_HOME_PHONE2 |
Number of the recipient's secondary home telephone. |
|
RECIP_HOME_STATE |
State of the recipient's home address. |
|
RECIP_HOME_STREET |
Street address of the recipient's home. |
|
RECIP_HOME_ZIPCODE |
Zip code of the recipient's home address. |
|
RECIP_INITIALS |
Initials of the recipient. |
|
RECIP_JOB_TITLE |
Job title of the recipient. |
|
RECIP_MAILING_ADDRESS |
Mailing address of the recipient. |
|
RECIP_MAILING_CITY |
City of the recipient's mailing address. |
|
RECIP_MAILING_STATE |
State of the recipient's mailing address. |
|
RECIP_MAILING_STREET |
Street of the recipient's mailing address. |
|
RECIP_MAILING_ZIPCODE |
Zip code of the recipient's mailing address. |
|
RECIP_MANAGER |
Name of the recipient's manager. |
|
RECIP_MOBILE_PHONE |
Telephone number of the recipient's mobile telephone. |
|
RECIP_NAME |
Name of the recipient. |
|
RECIP_NETMEETING_ALIAS |
Alias of the recipient's NetMeeting account. |
|
RECIP_NETMEETING_SERVER |
Server of the recipient's NetMeeting account. |
|
RECIP_NICKNAME |
Nickname of the recipient. |
|
RECIP_OFFICE |
Office of the recipient. |
|
RECIP_OFFICE_LOCATION |
Location of the recipient's office. |
|
RECIP_OTHER_FAX_PHONE |
Telephone number for the recipient's alternate fax machine. |
|
RECIP_OTHER_PHONE |
Alternate telephone number for the recipient. |
|
RECIP_OTHER_ADDRESS |
Recipient's alternate address. |
|
RECIP_OTHER_CITY |
City of the recipient's alternate address. |
|
RECIP_OTHER_STATE |
State of the recipient's alternate address. |
|
RECIP_OTHER_STREET |
Street address of the recipient's alternate address. |
|
RECIP_PAGE_PHONE |
Telephone number of the recipient's pager. |
|
RECIP_PROFESSION |
Profession of the recipient. |
|
RECIP_TITLE |
Formal title that precedes the recipient's name. |
|
RECIP_WEBADDRESS |
Web site address of the recipient. |
|
SENDER_ASSISTANT_NAME |
Name of the sender's assistant. |
|
SENDER_ASSISTANT_PHONE |
Telephone number of the sender's assistant. |
|
SENDER_BUSINESS_ADDRESS |
Address of the sender's business address. |
|
SENDER_BUSINESS_CITY |
City of the sender's business address. |
|
SENDER_BUSINESS_COUNTRY |
Country of the sender's business address. |
|
SENDER_BUSINESS_FAX_PHONE |
Telephone number of the sender's fax machine. |
|
SENDER_BUSINESS_NAME |
Name of the sender's business. |
|
SENDER_BUSINESS_PHONE |
Telephone number of the sender's business phone. |
|
SENDER_BUSINESS_PHONE2 |
Telephone number of the sender's secondary business phone. |
|
SENDER_BUSINESS_STATE |
State of the sender's business address. |
|
SENDER_BUSINESS_STREET |
Street address of the sender's business address. |
|
SENDER_BUSINESS_ZIPCODE |
Zip code of the sender's business address. |
|
SENDER_COMPANY |
Company name of the sender. |
|
SENDER_CUSTOM1 SENDER_CUSTOM2 SENDER_CUSTOM3 SENDER_CUSTOM4 SENDER_CUSTOM5 SENDER_CUSTOM6 SENDER_CUSTOM7 SENDER_CUSTOM8 SENDER_CUSTOM9 SENDER_CUSTOM10 |
Custom fields pertaining to the sender. |
|
SENDER_DEPARTMENT |
Department of the sender. |
|
SENDER_EMAIL |
E-mail address of the sender. |
|
SENDER_EMAIL2 |
Secondary e-mail address of the sender. |
|
SENDER_EMAIL3 |
Tertiary e-mail address of the sender. |
|
SENDER_HOME_ADDRESS |
Home address of the sender. |
|
SENDER_HOME_CITY |
City of the sender's home address. |
|
SENDER_HOME_COUNTRY |
Country in the sender's home address. |
|
SENDER_HOME_FAX_PHONE |
Fax number of the sender's home fax machine. |
|
SENDER_HOME_PHONE |
Number of the sender's home telephone. |
|
SENDER_HOME_PHONE2 |
Number of the sender's secondary home telephone. |
|
SENDER_HOME_STATE |
State of the sender's home address. |
|
SENDER_HOME_STREET |
Home street address of the sender. |
|
SENDER_HOME_ZIPCODE |
Home zip code of the sender. |
|
SENDER_INITIALS |
Initials of the sender. |
|
SENDER_JOB_TITLE |
Job title of the sender. |
|
SENDER_MAILING_ADDRESS |
Company mailing address of the sender. |
|
SENDER_MAILING_CITY |
City associated with the sender's mailing address. |
|
SENDER_MAILING_STATE |
State associated with the sender's mailing address. |
|
SENDER_MAILING_STREET |
Street address of the sender. |
|
SENDER_MAILING_ZIPCODE |
Zip codes of the sender's mailing address. |
|
SENDER_MANAGER |
Name of the sender's manager. |
|
SENDER_MOBILE_PHONE |
Telephone number of the sender's mobile phone. |
|
SENDER_NAME |
Name of the sender. |
|
SENDER_NETMEETING_ALIAS |
NetMeeting alias of the sender. |
|
SENDER_NETMEETING_SERVER |
NetMeeting server of the sender. |
|
SENDER_NICKNAME |
Nickname, or alias, of the sender. |
|
SENDER_OFFICE |
Office of the sender. |
|
SENDER_OFFICE_LOCATION |
Location of the sender's office. |
|
SENDER_OTHER_ADDRESS |
Secondary address of the sender. |
|
SENDER_OTHER_CITY |
City of the sender's secondary address. |
|
SENDER_OTHER_FAX_PHONE |
Telephone number of the sender's secondary fax machine. |
|
SENDER_OTHER_PHONE |
Secondary telephone number of the sender. |
|
SENDER_OTHER_STATE |
State of the sender's secondary address. |
|
SENDER_OTHER_STREET |
Street address of the sender's secondary address. |
|
SENDER_OTHER_ZIPCODE |
Zip code of the sender's secondary address. |
|
SENDER_PAGE_PHONE |
Telephone number of the sender's pager. |
|
SENDER_PROFESSION |
Profession or job title of the sender. |
|
SENDER_TITLE |
Title of the sender. (Mr., Ms., etc.) |
|
SENDER_WEBADDRESS |
Web site address of the sender. |
|
SUBJECT |
Subject of the message being archived. |
|
TIME_CONNECT |
Time elapsed while a fax was being transmitted over a telephone line. |
See also