Database Columns
These tables list each column name as it is displayed in the report output columns lists in SimplyReports, the database table that contains the column, and the column name in the database. The SimplyReports administrator can specify different names for these report output columns. See Edit a report output column. Once the names are changed, they do not revert to the original name.
Note: For information on selecting and sorting columns, see Create a list, count, or summary report.
When a report is generated, the column headings on the report usually match the database column name. You can change the column headings on the report in an Excel or a text file after a report is generated.
Tip: For more information on database tables and columns, see the Polaris Database Repository on the Innovative Customer Supportal.
The following types of database columns are available to create the report columns:
Patron Columns for Patron Count Reports Only
Patron Account Columns for Patron Account List Reports Only
Patron Account Columns for Patron Account Count Reports Only
Item Columns for Item Count Reports Only
Bib Columns for Bib Count Reports Only
Fund Columns for Fund Summary Reports Only
Invoice Columns for Invoice Summary Reports Only
Purchase Order Columns for Order Summary Reports Only
Patron Columns
Patron columns for Patron, Patron Account, Item, and Holds reports. The available patron columns depend on the type of report.
| List Box Text | Database Table | Database Column |
|---|---|---|
|
Patron acct charges |
PolarisPatrons |
ChargesAmount |
|
Patron acct credits |
Polaris.Patrons |
CreditsAmount |
|
Patron addr check date |
Polaris.PatronRegistration |
AddrCheckDate |
|
Patron address ID |
Polaris.PatronAdresses |
AddressID |
|
Patron alt email address |
Polaris.PatronRegistration |
AltEmailAdress |
|
Patron barcode |
Polaris.Patrons |
Barcode |
|
Patron birth date |
Polaris.PatronRegistration |
Birthdate |
|
Patron block |
Polaris.PatronStopDescriptions |
Description |
|
Patron block creation date |
Polaris.PatronStops |
CreationDate |
|
Patron blocking note |
Polaris.PatronNotes |
BlockingStatusNotes |
|
Patron blocking note date |
Polaris.PatronNotes |
BlockingStatusNoteDate |
|
Patron branch abbreviation |
Polaris.Organizations |
Abbreviation |
|
Patron branch name |
Polaris.Organizations |
Name |
|
Patron city |
Polaris.PostalCodes |
City |
|
Patron claim count |
Polaris.Patrons |
ClaimCount |
|
Patron code |
Polaris.PatronCodes |
Description |
|
Patron code ID |
Polaris.Patrons |
PatronCodeID |
|
Patron collection exempt |
Polaris.PatronRegistration |
CollectionExempt |
|
Patron county |
Polaris.PostalCodes |
County |
|
Patron deletion exempt |
Polaris.PatronRegistration |
DeletionExempt |
|
Patron delivery option ID |
Polaris.PatronRegistration |
DeliveryOptionID |
|
Patron e-mail address |
Polaris.PatronRegistration |
EmailAddress |
|
Patron entry date |
Polaris.PatronRegistration |
EntryDate |
| Patron exclude from almost overdue/auto-renewals | Polaris.PatronRegistration | ExcludeFromAlmostOverdueAutoRenew |
|
Patron exclude from bills |
Polaris.PatronRegistration |
ExcludeFromBills |
|
Patron exclude from holds |
Polaris.PatronRegistration |
ExcludeFromHolds |
| Patron exclude from inactive patrons | Polaris.PatronRegistration | ExcludeFromInactivePatron |
|
Patron exclude from overdues |
Polaris.PatronRegistration |
ExcludeFromOverdues |
| Patron exclude from patron record expiration | Polaris.PatronRegistration | ExcludeFromPatronRecExpiration |
|
Patron expiration date |
Polaris.PatronRegistration |
ExpirationDate |
|
Patron fax |
Polaris.PatronRegistration |
PhoneFAX |
|
Patron first name |
Polaris.PatronRegistration |
NameFirst |
|
Patron former barcode |
Polaris.PatronRegistration |
FormerID |
|
Patron free text block |
Polaris.PatronFreeTextBlocks |
FreeTextBlocks |
|
Patron free text block date |
Polaris.PatronFreeTextBlocks |
FreeTextBlockDate |
|
Patron free text message |
Polaris.PAC_PatronFreeTextMessages |
FreeTextMessage |
|
Patron free text message date |
Polaris.PAC_PatronFreeTextMessages |
CreationDate |
|
Patron full name |
Polaris.PatronRegistration |
PatronFullName |
|
Patron gender |
Polaris.PatronRegistration |
Gender |
|
Patron language |
Polaris.Languages |
LanguageDesc |
|
Patron language ID |
Polaris.PatronRegistration |
LanguageID |
|
Patron last activity date |
Polaris.Patrons |
LastActivityDate |
|
Patron last name |
Polaris.PatronRegistration |
NameLast |
|
Patron legal first name |
Polaris.PatronRegistration |
LegalNameFirst |
|
Patron legal full name |
Polaris.PatronRegistration |
LegalFullName |
|
Patron legal last name |
Polaris.PatronRegistration |
LegalNameLast |
|
Patron legal middle name |
Polaris.PatronRegistration |
LegalNameMiddle |
|
Patron lifetime circ count |
Polaris.Patrons |
LifetimeCircCount |
|
Patron lost item count |
Polaris.Patrons |
LostItemCount |
|
Patron maintain permanent reading history |
Polaris.PatronRegistration |
ReadingList |
|
Patron message |
Polaris.SA_PatronMessageLanguageStrings |
MessageValue |
|
Patron message date |
Polaris.PAC_PatronMessages |
CreationDate |
|
Patron middle name |
Polaris.PatronRegistration |
NameMiddle |
|
Patron name suffix |
Polaris.PatronRegistration |
NameSuffix |
|
Patron non-blocking note |
Polaris.PatronNotes |
NonBlockingStatusNotes |
|
Patron postal code |
Polaris.PostalCodes |
PostalCode |
|
Patron password |
Polaris.PatronRegistration |
Password |
|
Patron postal code |
Polaris.PostalCodes |
PostalCode |
|
Patron previous year circ count |
Polaris.PrevYearPatronsCirc |
YTDCircCount |
|
Patron registration date |
Polaris.PatronRegistration |
RegistrationDate |
|
Patron state |
Polaris.PostalCodes |
State |
|
Patron statistical class |
Polaris.PatronRegistration |
StatisticalClassID |
|
Patron statistical class description |
Polaris.PatronStatClassCodes |
Description |
|
Patron street one |
Polaris.Addresses |
StreetOne |
|
Patron street two |
Polaris.Addresses |
StreetTwo |
|
Patron telephone 1 |
Polaris.PatronRegistration |
PhoneVoice1 |
|
Patron telephone 2 |
Polaris.PatronRegistration |
PhoneVoice2 |
|
Patron telephone 3 |
Polaris.PatronRegistration |
PhoneVoice3 |
|
Patron user 1 |
Polaris.PatronRegistration |
User1 |
|
Patron user 2 |
Polaris.PatronRegistration |
User2 |
|
Patron user 3 |
Polaris.PatronRegistration |
User3 |
|
Patron user 4 |
Polaris.PatronRegistration |
User4 |
|
Patron user 5 |
Polaris.PatronRegistration |
User5 |
|
Patron update date |
Polaris.PatronRegistration |
UpdateDate |
|
Patron YTD circ count |
Polaris.Patrons |
YTDCircCount |
|
Patron zip + 4 |
Polaris.Addresses |
ZipPlusFour |
| Resource group description | polaris.SA_ResourceGroups | Description |
| Resource group name | polaris.SA_ResourceGroups | Name |
| Use patron legal name on print/phone notices | Polaris.PatronRegistration | UseLegalNameOnNotices |
| Vendor account description | polaris.VendorAccounts | VendorAccountDescription |
| Vendor account name | polaris.VendorAccounts | VendorAccountName |
| Vendor contract ID | polaris.VendorAccounts | VendorContractID |
Patron Columns for Patron Count Reports Only
| List Box Text | Database Table | Database Column |
|---|---|---|
|
Sum patron charges amount |
Polaris.Patrons |
ChargesAmount |
|
Sum patron claim count |
Polaris.Patrons |
ClaimCount |
|
Sum patron credits amount |
Polaris.Patrons |
CreditsAmount |
|
Sum patron lifetime circ count |
Polaris.Patrons |
LifetimeCircCount |
|
Sum patron lost item Count |
Polaris.Patrons |
LostItemCount |
|
Sum patron YTD circ count |
Polaris.Patrons |
YTDCircCount |
|
Sum prev year patron circ count |
Polaris.PrevYearPatronsCirc |
YTDCircCount |
Patron Account Columns
Patron Account columns for Patron Account List and Count reports:
| List Box Text | Database Table | Database Column |
|---|---|---|
|
Acct fee reason code description |
Polaris.FeeReasonCodes |
FeeDescription |
|
Acct fee reason code ID |
Polaris.PatronAccount |
FeeReasonCodeID |
|
Acct payment method description |
Polaris.PatronPaymentMethods |
Description |
|
Acct payment method ID |
Polaris.PatronAccount |
PaymentMethodID |
|
Acct transaction branch abbreviation |
Polaris.Organizations |
Abbreviation |
|
Acct transaction branch ID |
Polaris.PatronAccount |
OrganizationID |
|
Acct transaction branch name |
Polaris.Organizations |
Name |
|
Acct transaction creator ID |
Polaris.PatronAccount |
CreatorID |
|
Acct transaction creator name |
Polaris.PolarisUsers |
Name |
|
Acct transaction type |
Polaris.PatronAccTxnCodes |
AlternateName |
|
Acct transaction type ID |
Polaris.PatronAccount |
TxnCodeID |
|
Acct transaction workstation |
Polaris.PatronAccount |
WorkStationID |
|
Acct transaction workstation computer name |
Polaris.Workstations |
ComputerName |
|
Acct transaction workstation display name |
Polaris.Workstations |
DisplayName |
Patron Account Columns for Patron Account List Reports Only
| List Box Text | Database Table | Database Column |
|---|---|---|
|
Acct trans. balance - outstanding charges only |
Polaris.PatronAccount |
OutstandingAmount |
|
Acct transaction amount - history items only |
Polaris.PatronAccount |
TxnAmount |
Patron Account Columns for Patron Account Count Reports Only
| List Box Text | Database Table | Database Column |
|---|---|---|
|
Sum - balance (outstanding balance only) |
Polaris.PatronAccount |
OutstandingAmount |
|
Sum - item price |
Polaris.ItemRecordDetails |
Price |
|
Sum - patron charges amount |
Polaris.Patrons |
ChargesAmount |
|
Sum - patron credits amount |
Polaris.Patrons |
CreditsAmount |
|
Sum - transaction amount (history only) |
Polaris.PatronAccount |
TxnAmount |
Holds Columns
Holds columns for Holds List and Count reports:
| List Box Text | Database Table | Database Column |
|---|---|---|
|
Hold activation date |
Polaris.SysHoldRequests |
ActivationDate |
|
Hold borrow by mail request |
Polaris.RWRITERCodeTranslations |
BorrowByMailRequest |
|
Hold creation date |
Polaris.SysHoldRequests |
CreationDate |
|
Hold creator ID (if staff) |
Polaris.SysHoldRequests |
CreatorID |
|
Hold creator name (if staff) |
Polaris.PolarisUsers |
Name |
|
Hold expiration date |
Polaris.SysHoldRequests |
ExpirationDate |
|
Hold last status transition date |
Polaris.SysHoldRequests |
LastStatusTransitionDate |
|
Hold modification date |
Polaris.SysHoldRequests |
ModificationDate |
|
Hold modifier ID (if staff) |
Polaris.SysHoldRequests |
ModifierID |
|
Hold modifier name (if staff) |
Polaris.PolarisUsers |
Name |
|
Hold non-public note |
Polaris.SysHoldRequests |
NonPublicNotes |
|
Hold notification date |
Polaris.SysHoldRequests |
HoldNotificationDate |
|
Hold notification option |
Polaris.DeliveryOptions |
DeliveryOption |
|
Hold notification option ID |
Polaris.SysHoldRequests |
DeliveryOptionID |
|
Hold origin of request ID |
Polaris.SysHoldRequests |
Origin |
|
Hold origin of request |
Polaris.RWRITERCodeTranslations |
Description |
|
Hold PAC display note |
Polaris.SysHoldRequests |
PACDisplayNotes |
|
Hold patron note |
Polaris.SysHoldRequests |
PatronNotes |
|
Hold pickup branch abbreviation |
Polaris.Organizations |
Abbreviation |
|
Hold pickup branch ID |
Polaris.SysHoldRequests |
PickupBranchID |
|
Hold pickup branch name |
Polaris.Organizations |
Name |
|
Hold request ID |
Polaris.SysHoldRequests |
SysHoldRequestID |
|
Hold staff display note |
Polaris.SysHoldRequests |
StaffNotes2 |
|
Hold status |
Polaris.SysHoldStatuses |
Description |
|
Hold status ID |
Polaris.SysHoldRequests |
SysHoldStatusID |
|
Hold till date |
Polaris.SysHoldRequests |
HoldTillDate |
|
Hold tracking info |
Polaris.SysHoldRequests |
TrackingInfo |
Item Columns
Item columns for Item, Patron Account, Holds, Items, Authority, Serials, Fund, Order and Invoice reports. The available item columns depend on the report type.
Note:
The item columns in Order and Invoice reports are derived from the PolarisRwriterLineItemtoItemsView table.
| List Box Text | Database Table | Database Column |
|---|---|---|
|
Item acquisitions date |
Polaris.ItemRecordDetails |
AcquisitionDate |
|
Item assigned branch abbreviation |
Polaris.Organizations |
Abbreviation |
|
Item assigned branch ID |
Polaris.CircItemRecords |
AssignedBranchID |
|
Item assigned branch name |
Polaris.Organizations |
Name |
|
Item assigned collection abbreviation |
Polaris.Collections |
Abbreviation |
|
Item assigned collection ID |
Polaris.CircItemRecords |
AssignedCollectionID |
|
Item assigned collection name |
Polaris.Collections |
Name |
|
Item barcode |
Polaris.CircItemRecords |
Barcode |
|
Item call number |
Polaris.ItemRecordDetails |
CallNumber |
|
Item call number prefix |
Polaris.ItemRecordDetails |
CallNumberPrefix |
|
Item call number suffix |
Polaris.ItemRecordDetails |
CallNumberSuffix |
|
Item check in branch abbreviation |
Polaris.Organizations |
CheckInBranchAbbr |
|
Item check in branch name |
Polaris.Organizations |
CheckInBranchName |
|
Item check in user |
Polaris.PolarisUsers |
CKIUser |
|
Item check in workstation |
Polaris.Workstations |
CKIWorkstation |
|
Item check out branch abbreviation |
Polaris.Organizations |
CheckOutBranchAbbr |
|
Item check out branch name |
Polaris.Organizations |
CheckOutBranchName |
|
Item checkout date |
Polaris.ItemCheckouts |
CheckOutDate |
|
Item circ status description |
Polaris.ItemStatuses |
Description |
|
Item circ status ID |
Polaris.CircItemRecords |
ItemStatusID |
|
Item claimed date |
Polaris.PatronClaims |
ClaimDate |
|
Item classification number |
Polaris.ItemRecordDetails |
ClassificationNumber |
|
Item creation date |
Polaris.ItemRecordDetails |
ItemCreationDate |
|
Item creator ID |
Polaris.ItemRecordDetails |
ItemCreatorID |
|
Item creator name |
Polaris.ItemRecordDetails |
ItemCreatorName |
|
Item copy number |
Polaris.ItemRecordDetails |
CopyNumber |
|
Item cutter number |
Polaris.ItemRecordDetails |
CutterNumber |
|
Item delayed holds enabled |
Polaris.CircItemRecords |
DelayedHoldsFlag |
|
Item designation |
Polaris.SysHoldRequests |
Designation |
|
Item donor corporate name |
Polaris.Donors |
CorporateName |
|
Item donor email |
Polaris.Donors |
|
|
Item donor first name |
Polaris.Donors |
FirstName |
|
Item donor ID |
Polaris.ItemRecordDetails |
DonorID |
|
Item donor last name |
Polaris.Donors |
LastName |
|
Item donor middle name |
Polaris.Donors |
MiddleName |
|
Item donor renewal date |
Polaris.Donors |
RenewalDate |
|
Item due date |
Polaris.ItemCheckouts |
DueDate |
|
Item fine code |
Polaris.FineCodes |
Description |
|
Item fine code ID |
Polaris.CircItemRecords |
FineCodeID |
|
Item fine code description |
Polaris.FineCodes |
Description |
|
Item first available date |
Polaris.CircItemRecords |
FirstAvailableDate |
|
Item free text block |
PolarisCircItemRecords |
FreeTextBlock |
|
Item funding source |
Polaris.ItemRecordDetails |
FundingSource |
|
Item home branch abbr |
Polaris.Organizations |
Abbreviation |
|
Item home branch ID |
Polaris.CircItemRecords |
HomeBranchID |
|
Item home branch name |
Polaris.Organizations |
Name |
|
Item Imported date |
Polaris.ItemRecordDetails |
ImportedDate |
|
Item last check in date |
Polaris.CircItemRecords |
CheckInDate |
|
Item last circ activity date |
Polaris.CircItemRecords |
LastCircTransactionDate |
|
Item last circ status change date |
Polaris.CircItemRecords |
ItemStatusDate |
|
Item last checkout/renewal date |
Polaris.CircItemRecords |
LastCheckOutRenewDate |
|
Item last in transit date |
Polaris.CircItemRecords |
InTransitSentDate |
|
Item last inventory date |
Polaris.ItemRecordDetails |
LastInventoryDate |
|
Item lifetime circ count |
Polaris.CircItemRecords |
LifetimeCircCount |
|
Item lifetime in house use count |
Polaris.CircItemRecords |
LifeTimeInHouseUsecount |
|
Item loan period code description |
Polaris.LoanPeriodCodes |
Description |
|
Item loan period code ID |
Polaris.CircItemRecords |
LoanPeriodCodeID |
|
Item lost date |
Polaris.PatronLostItems |
LostDate |
|
Item material type description |
Polaris.MaterialTypes |
Description |
|
Item material type ID |
Polaris.CircItemRecords |
MaterialTypeID |
|
Item modification date |
Polaris.ItemRecordDetails |
ModificationDate |
|
Item modifier ID |
Polaris.ItemRecordDetails |
ModifierID |
|
Item modifier name |
Polaris.PolarisUsers |
Name |
|
Item nonpublic note |
Polaris.ItemRecordDetails |
NonPublicNote |
|
Item number of days delayed |
Polaris.CircItemRecords |
DelayedNumberOfDays |
|
Item original check out date |
Polaris.CircItemRecords |
OriginalCheckOutDate |
|
Item original due date |
Polaris.CircItemRecords |
OriginalDueDate |
|
Item overdue notice date |
Polaris.ItemCheckouts |
OVDNoticeDate |
|
Item owning organization abbreviation |
Polaris.Organizations |
Abbreviation |
|
Item owning organization ID |
Polaris.ItemRecordDetails |
OwningBranchID |
|
Item owning organization name |
Polaris.Organizations |
Name |
|
Item physical condition |
Polaris.ItemRecordDetails |
PhysicalCondition |
|
Item prev year circ count |
Polaris.PrevYearItemsCirc |
YTDCircCount |
|
Item prev year inhouse use count |
Polaris.PrevYearItemsCirc |
YTDInHouseUseCount |
|
Item price |
Polaris.ItemRecordDetails |
Price |
|
Item public note |
Polaris.ItemRecordDetails |
PublicNote |
|
Item received from in transit date |
Polaris.CircItemRecords |
InTransitRecvdDate |
|
Item receiving branch abbreviation |
Polaris.Organizations |
Abbreviation |
|
Item receiving branch name |
Polaris.Organizations |
Name |
|
Item record history action |
Polaris.ItemRecordHistoryActions |
ActionTakenDesc |
|
Item record history transaction date |
Polaris.ItemRecordHistory |
TransactionDate |
|
Item record ID |
Polaris.CircItemRecords |
ItemRecordID |
|
Item record status date |
Polaris.CircItemRecords |
RecordStatusDate |
|
Item record status ID |
Polaris.CircItemRecords |
RecordStatusID |
|
Item record status name |
Polaris.RecordStatuses |
RecordStatusName |
|
Item renewal limit |
Polaris.CircItemRecords |
RenewalLimit |
|
Item shelf location description |
Polaris.ShelfLocations |
Description |
|
Item shelf location ID |
Polaris.CircItemRecords |
ShelfLocationID |
|
Item shelving scheme description |
Polaris.ShelvingSchemes |
Description |
|
Item shelving scheme ID |
Polaris.ItemRecordDetails |
ShelvingSchemeID |
|
Item statistical code description |
Polaris.StatisticalCodes |
Description |
|
Item statistical code ID |
Polaris.CircItemRecords |
StatisticalCodeID |
|
Item volume number |
Polaris.ItemRecordDetails |
VolumeNumber |
|
Item YTD circ count |
Polaris.CircItemRecords |
YTDCircCount |
|
Item YTD inhouse use count |
Polaris.CircItemRecords |
YTDInHouseUseCount |
| Resource group description | polaris.SA_ResourceGroups | Description |
| Resource group name | polaris.SA_ResourceGroups | Name |
| Vendor account description | polaris.VendorAccounts | VendorAccountDescription |
| Vendor account name | polaris.VendorAccounts | VendorAccountName |
| Vendor contract ID | polaris.VendorAccounts | VendorContractID |
| Vendor object identifier | polaris.ResourceEntities | VendorObjectIdentifier |
| Vendor object link text | polaris.ResourceEntities | LinkText |
| Vendor object URL | polaris.ResourceEntities | URL |
Item Columns for Item Count Reports Only
| List Box Text | Database Table | Database Column |
|---|---|---|
|
Sum item lifetime circ count |
Polaris.CircItemRecords |
LifetimeCircCount |
|
Sum item lifetime in house use count |
Polaris.CircItemRecords |
LifetimeInHouseUseCount |
|
Sum item price |
Polaris.ItemRecordDetails |
Price |
|
Sum item YTD circ count |
Polaris.CircItemRecords |
YTDCircCount |
|
Sum item YTD inhouse use count |
Polaris.CircItemRecords |
YTDInHouseUseCount |
|
Sum prev year circ count |
Polaris.PrevYearItemsCirc |
YTDCircCount |
|
Sum prev year inhouse use count |
Polaris.PrevYearItemsCirc |
YTDInHouseUseCount |
Bibliographic Columns
Bibliographic columns for Bibliographic, Patron Account, Holds, Item, Authority, Fund, Purchase Order and Invoice reports. The available bibliographic columns depend on the report type.
Note:
The bibliographic columns in Order reports are derived from the PolarisRwriterPOlineView table.
The bibliographic columns in Invoice reports are derived from the PolarisRwriterInvlineView table.
| List Box Text | Database Table | Database Column |
|---|---|---|
|
Bib creation date |
Polaris.BibliographicRecords |
CreationDate |
|
Bib creator ID |
Polaris.BibliographicRecords |
CreatorID |
|
Bib creator name |
Polaris.PolarisUsers |
Name |
|
Bib first available date |
Polaris.BibliographicRecords |
FirstAvailableDate |
|
Bib imported date |
Polaris.BibliographicRecords |
ImportedDate |
|
Bib lifetime circ count |
Polaris.BibliographicRecords |
LifetimeCircCount |
|
Bib lifetime in house use |
Polaris.BibliographicRecords |
LifetimeInHouseUseCount |
|
Bib modification date |
Polaris.BibliographicRecords |
ModificationDate |
|
Bib modifier ID |
Polaris.BibliographicRecords |
ModifierID |
|
Bib modifier name |
Polaris.PolarisUsers |
Name |
|
Bib number of active holds |
Polaris.RWRITER_BibDeriveDataView |
NumberActiveHolds |
|
Bib number of claim returned items |
Polaris.RWRITER_BibDeriveDataView |
NumberClaimRetItems |
|
Bib number of items |
Polaris.RWRITER_BibDeriveDataView |
NumberofItems |
|
Bib number of lost items |
Polaris.RWRITER_BibDeriveDataView |
NumberLostItems |
|
Bib number of missing items |
Polaris.RWRITER_BibDeriveDataView |
NumberMissingItems |
|
Bib number of received serial holdings issues |
Polaris.RWRITER_BibDeriveDataView |
ReceivedIssues |
|
Bib number of serial holdings copies |
Polaris.RWRITER_BibDeriveDataView |
NumberSHRCopies |
|
Bib number of withdrawn items |
Polaris.RWRITER_BibDeriveDataView |
NumberWithdrawnItems |
|
Bib owner abbreviation |
Polaris.Organizations |
Abbreviation |
|
Bib owner ID |
Polaris.BibliographicRecords |
RecordOwnerID |
|
Bib owner name |
Polaris.Organizations |
Name |
|
Bib record status date |
Polaris.BibliographicRecords |
RecordStatusDate |
|
Bib record status ID |
Polaris.BibliographicRecords |
RecordStatusID |
|
Bib record status name |
Polaris.RecordStatuses |
RecordStatusName |
|
Bib YTD circ count |
Polaris.RWRITER_BibDeriveDataView |
BibYTDCircCount |
|
Bib YTD in house use count |
Polaris.RWRITER_BibDeriveDataView |
BibYTDInHouseUseCount |
|
MARC author |
Polaris.BibliographicRecords |
BrowseAuthor |
|
MARC bib level |
Polaris.BibliographicRecords |
MARCBibLevel |
|
MARC bib type |
Polaris.BibliographicRecords |
MARCBibType |
|
MARC bibliographic record ID |
Polaris.BibliographicRecords |
BibliographicRecordID |
|
MARC call number |
Polaris.BibliographicRecords |
BrowseCallNo |
|
MARC char coding scheme |
Polaris.BibliographicRecords |
MARCCharCodingScheme |
|
MARC descriptive cataloging form |
Polaris.BibliographicRecords |
MARCDescCatalogingForm |
|
MARC encoding level description |
Polaris.RWRITERCodeTranslations |
Description |
|
MARC encoding level ID |
Polaris.BibliographicRecords |
MARCBibEncodingLevel |
|
MARC ISBN |
Polaris.RWRITERBibCtrlNumView |
ISBN |
|
MARC ISSN |
Polaris.RWRITERBibCtrlNumView |
ISSN |
|
MARC language |
Polaris.BibliographicRecords |
MARCLanguage |
|
MARC language description |
Polaris.MARCLanguageCodes |
Language |
|
MARC LCCN |
Polaris.BibliographicRecords |
MARCLCCN |
|
MARC literary form description |
Polaris.RWRITERCodeTranslations |
Description |
|
MARC literary form ID |
Polaris.BibliographicRecords |
LiteraryForm |
|
MARC medium (245 $h) |
Polaris.BibliographicRecords |
MARCMedium |
|
MARC OCLC number |
Polaris.RWRITERBibCtrlNumView |
OCLCNumber |
|
MARC publication date one |
Polaris.BibliographicRecords |
MARCPubDateOne |
|
MARC publication date two |
Polaris.BibliographicRecords |
MARCPubDateTwo |
|
MARC publication place |
Polaris.BibliographicRecords |
MARCPubPlace |
|
MARC publication status |
Polaris.BibliographicRecords |
MARCPublicationStatus |
|
MARC publication year |
Polaris.BibliographicRecords |
PublicationYear |
|
MARC publisher number |
Polaris.RWRITERBibCtrlNumView |
PublisherNumber |
|
MARC sort author |
Polaris.BibliographicRecords |
SortAuthor |
|
MARC sort ISBN |
Polaris.RWRITERBibCtrlNumView |
SortISBN |
|
MARC sort title |
Polaris.BibliographicRecords |
SortTitle |
|
MARC target audience description |
Polaris.RWRITERCodeTranslations |
Description |
|
MARC target audience ID |
Polaris.BibliographicRecords |
MARCTargetAudience |
|
MARC title |
Polaris.BibliographicRecords |
BrowseTitle |
|
MARC type of control |
Polaris.BibliographicRecords |
MARCTypeControl |
|
MARC type of material description |
Polaris.MARCTypeOfMaterial |
Description |
|
MARC type of material ID |
Polaris.BibliographicRecord |
PrimaryMARCTOMID |
|
MARC URL |
Polaris.RWriter_BibURLView |
URL |
| Resource group description | polaris.SA_ResourceGroups | Description |
| Resource group name | polaris.SA_ResourceGroups | Name |
| Vendor account description | polaris.VendorAccounts | VendorAccountDescription |
| Vendor account name | polaris.VendorAccounts | VendorAccountName |
| Vendor contract ID | polaris.VendorAccounts | VendorContractID |
| Vendor object identifier | polaris.ResourceEntities | VendorObjectIdentifier |
| Vendor object link text | polaris.ResourceEntities | LinkText |
| Vendor object URL | polaris.ResourceEntities | URL |
Bib Columns for Bib Count Reports Only
| List Box Text | Database Table | Database Column |
|---|---|---|
|
Sum bib lifetime circ count |
Polaris.RWRITER_BibDerivedDataView |
BibLifetimeCircCount |
|
Sum bib lifetime in house use count |
Polaris.RWRITER_BibDerivedDataView |
BibLifetimeInHouseUseCount |
|
Sum bib number of active holds |
Polaris.RWRITER_BibDerivedDataView |
NumberActiveHolds |
|
Sum bib number of claim returned items |
Polaris.RWRITER_BibDerivedDataView |
NumberClaimRetItems |
|
Sum bib number of items |
Polaris.RWRITER_BibDerivedDataView |
NumberofItems |
|
Sum bib number of lost items |
Polaris.RWRITER_BibDerivedDataView |
NumberLostItems |
|
Sum bib number of missing items |
Polaris.RWRITER_BibDerivedDataView |
NumberMissingItems |
|
Sum bib number of received serials holdings issues |
Polaris.RWRITER_BibDerivedDataView |
ReceivedIssues |
|
Sum bib number of serial holdings copies |
Polaris.RWRITER_BibDerivedDataView |
NumberSHRCopies |
|
Sum bib number of withdrawn items |
Polaris.RWRITER_BibDerivedDataView |
NumberWithdrawnItems |
|
Sum bib YTD circ count |
Polaris.RWRITER_BibDerivedDataView |
BibYTDCircCount |
|
Sum bib YTD in house use count |
Polaris.RWRITER_BibDerivedDataView |
BibYTDInHouseUseCount |
Authority Columns
Authority columns for Authority reports:
| List Box Text | Database Table | Database Column |
|---|---|---|
|
Authority creation date |
Polaris.AuthorityRecords |
CreationDate |
|
Authority creator ID |
Polaris.AuthorityRecords |
CreatorID |
|
Authority creator name |
Polaris.PolarisUsers |
Name |
|
Authority first use date |
Polaris.AuthorityRecords |
FirstUseDate |
|
Authority heading |
Polaris.AuthorityRecords |
BrowseHeading |
|
Authority imported date |
Polaris.AuthorityRecords |
ImportedDate |
|
Authority LCCN |
Polaris.AuthorityRecords |
MARCLCCN |
|
Authority MARC creation date |
Polaris.AuthorityRecords |
MARCCreaionDate |
|
Authority MARC modification date |
Polaris.AuthorityRecords |
MARCModificationDate |
|
Authority modification date |
Polaris.AuthorityRecords |
ModificationDate |
|
Authority modifier ID |
Polaris.AuthorityRecords |
ModifierID |
|
Authority modifier name |
Polaris.PolarisUsers |
Name |
|
Authority record ID |
Polaris.AuthorityRecords |
AuthorityRecordID |
|
Authority record status date |
Polaris.AuthorityRecords |
RecordStatusDate |
|
Authority record status ID |
Polaris.AuthorityRecords |
RecordStatusID |
|
Authority record status name |
Polaris.RecordStatuses |
RecordStatusName |
|
Authority sort heading |
Polaris.AuthorityRecords |
Heading |
|
Number of linked authority records |
PolarisRWriter_HeadingCountView |
AuthorityLinks |
|
Number of linked bibliographic records |
PolarisRWriter_HeadingCountView |
BibliographicLinks |
|
Subject heading system/thesaurus |
PolarisRWriter_CodeTranslations |
Description |
Serials Columns
Serials columns for Serials reports:
| List Box Text | Database Table | Database Column |
|---|---|---|
|
Compressed holdings statement |
Polaris.RWRITERReportTables |
SHRHoldings |
|
Holdings record bibliographic record ID |
Polaris.SHRCopies |
BibRecordID |
|
Holdings record call no prefix |
Polaris.SHRCopies |
CallNoPrefix |
|
Holdings record classification no |
Polaris.SHRCopies |
ClassificationNo |
|
Holdings record completeness code |
Polaris.SHRCopies |
CompletenessCodeH |
|
Holdings record completeness description |
Polaris.MfhdCompleteness |
Description |
|
Holdings record copy number |
Polaris.SHRCopies |
CopyNumber |
|
Holdings record creation date |
Polaris.SHRCopies |
CreationDate |
|
Holdings record creator ID |
Polaris.SHRCopies |
CreatorID |
|
Holdings record creator name |
Polaris.PolarisUsers |
Name |
|
Holdings record cutter no |
Polaris.SHRCopies |
CutterNo |
|
Holdings record destination collection abbreviation |
Polaris.Collections |
Abbreviation |
|
Holdings record destination collection ID |
Polaris.SHRCopies |
DestinationCollectionID |
|
Holdings record destination collection name |
Polaris.Collections |
Name |
|
Holdings record destination organization abbreviation |
Polaris.Organizations |
Abbreviation |
|
Holdings record destination organization ID |
Polaris.SHRCopies |
DestinationOrgID |
|
Holdings record destination organization name |
Polaris.Organizations |
Name |
|
Holdings record ID |
Polaris.SHRCopies |
CopyID |
|
Holdings record imported bib control number |
Polaris.SHRCopies |
ImportedBibCN |
|
Holdings record imported holdings copy number |
Polaris.SHRCopies |
ImportedHoldingsCN |
|
Holdings record imported record source |
Polaris.SHRCopies |
ImportedRecordSource |
|
Holdings record intent to cancel |
Polaris.SHRCopies |
IntentToCancel |
|
Holdings record list server address |
Polaris.SHRCopies |
ListServerAddr |
|
Holdings record material type description |
Polaris.MaterialTypes |
Description |
|
Holdings record material type ID |
Polaris.SHRCopies |
MaterialTypeID |
|
Holdings record max claims |
Polaris.SHRCopies |
MaxClaims |
|
Holdings record member name |
Polaris.SHRCopies |
MemberName |
|
Holdings record member organization name |
Polaris.SHRCopies |
MemberOrgName |
|
Holdings record membership designation |
Polaris.SHRCopies |
MembershipDesignation |
|
Holdings record modifier name |
Polaris.PolarisUsers |
Name |
|
Holdings record modification date |
Polaris.SHRCopies |
LastTransaction |
|
Holdings record modifier ID |
Polaris.SHRCopies |
ModifierID |
|
Holdings record note non public |
Polaris.SHRCopies |
NoteNonPub |
|
Holdings record note staff |
Polaris.SHRCopies |
NoteStaff |
|
Holdings record order type description |
Polaris.OrderTypes |
OrderType |
|
Holdings record order type ID |
Polaris.SHRCopies |
OrderType |
|
Holdings record ordering organization abbreviation |
Polaris.Organizations |
Abbreviation |
|
Holdings record ordering organization ID |
Polaris.SHRCopies |
OrganizationID |
|
Holdings record ordering organization name |
Polaris.Organizations |
Name |
|
Holdings record plan description |
Polaris.SHRCopies |
PlanDescr |
|
Holdings record plan name |
Polaris.SHRCopies |
PlanName |
|
Holdings record public note |
Polaris.RWRITERReportTables |
SHRPublicNote |
|
Holdings record retention note |
Polaris.RWRITERReportTables |
SHRRetentionNote |
|
Holdings record shelving scheme description |
Polaris.ShelvingSchemes |
Description |
|
Holdings record shelving scheme ID |
Polaris.SHRCopies |
ShelvingSchemeID |
|
Holdings record start date |
Polaris.SHRCopies |
StartDate |
|
Holdings record start number |
Polaris.SHRCopies |
StartNumber |
|
Holdings record subscription status description |
Polaris.CopySubsStatuses |
Description |
|
Holdings record subscription status ID |
Polaris.SHRCopies |
SubscrStatusH |
|
Issue/Part note non public |
Polaris.MfhdIssues |
NoteNonPub |
|
Issue/Part chronology date |
Polaris.MfhdIssues |
ChronologyDate |
|
Issue/Part claim creation date |
Polaris.Claims |
ClaimDate |
|
Issue/Part claim note |
Polaris.Claims |
ClmNote |
|
Issue/Part claim reason |
Polaris.Claims |
ClaimReason |
|
Issue/Part designation |
Polaris.Claims |
Designation |
|
Issue/Part expected arrival date |
Polaris.Claims |
ExpectArrivalDate |
|
Issue/Part ID |
Polaris.MfhdIssues |
IssueID |
|
Issue/Part note public |
Polaris.MfhdIssues |
NotePub |
|
Issue/Part note non public |
Polaris.MfhdIssues |
NoteNonPub |
|
Issue/Part note non public warning |
Polaris.MfhdIssues |
NoteStaff |
|
Issue/Part status ID |
Polaris.MfhdIssues |
IssueStatusID |
|
Issue/Part status date |
Polaris.MfhdIssues |
IssueStatusDate |
|
Issue/Part status description |
Polaris.MfhdIssueStatuses |
StatusDesc |
|
Publication pattern category description |
Polaris.MfhdCategories |
Description |
|
Publication pattern category ID |
Polaris.MfhdPublicationPatterns |
CategoryID |
|
Publication pattern ID |
Polaris.MfhdPublicationPatterns |
PubPatternID |
|
Subscription ID |
Polaris.SHRCopies |
SubsID |
|
Subscription fund ID |
Polaris.Subscriptions |
FundID |
|
Subscription fund name |
Polaris.Funds |
name |
|
Subscription identifier |
Polaris.Subscriptions |
Identifier |
|
Subscription note |
Polaris.Subscriptions |
Note |
|
Subscription payment method description |
Polaris.PaymentMethods |
PaymentMethod |
|
Subscription payment method ID |
Polaris.Subscriptions |
PaymentMethodID |
|
Subscription renew instruction |
Polaris.Subscriptions |
RenewInstruction |
|
Subscription status |
Polaris.Subscriptions |
Status |
|
Subscription term |
Polaris.Subscriptions |
SubscriptionTerm |
Supplier Columns
Supplier columns for Serials, Order, and Invoice reports. The available supplier columns depend on the report type.
Note:
The supplier columns for order reports are derived from the Polaris.RwriterPurchseOrderFiscalYears table.
The supplier columns for invoice reports are derived from the Polaris.RwriterInvoiceFiscalYears table.
| List Box Text | Database Table | Database Column |
|---|---|---|
|
Supplier ID |
Polaris.Subscriptions |
SupplierID |
|
Supplier alternative name |
Polaris.Suppliers |
SupplierRecordName |
|
Supplier library account number |
Polaris.RwriterPurchseOrderFiscalYears |
SupplierLBAccountNumber |
|
Supplier name |
Polaris.Suppliers |
SupplierName |
|
Supplier note |
Polaris.Suppliers |
Note |
|
Supplier organization abbreviation |
Polaris.RwriterPurchseOrderFiscalYears |
SupplierOrganizationAbbr |
|
Supplier organization name |
Polaris.RwriterPurchseOrderFiscalYears |
SupplierOrganizationName |
|
Supplier plan note |
Polaris.RwriterPurchseOrderFiscalYears |
SupplierPlanNote |
|
Supplier record name |
Polaris.Suppliers |
RecordName |
|
Supplier SAN |
Polaris.Suppliers |
SupplierSAN |
|
Supplier SAN prefix |
Polaris.Suppliers |
SupplierSANPre |
|
Supplier SAN suffix |
Polaris.Suppliers |
SupplierSANSuf |
Fund Columns
Fund columns for Fund, Order, and Invoice reports. The available fund columns depend on the report type.
Note:
The fiscal year and fund currency columns for order reports are derived from the Polaris.RwriterPurchseOrderFiscalYears table.
The fiscal year and fund currency columns for invoice reports are derived from the Polaris.RwriterInvoiceFiscalYears table.
Other fund columns for order reports are derived from the Polaris.RwriterPOlineSegmentView table.
Other fund columns for invoice reports are derived from the Polaris.RwriterInvlineSegmentView table.
| List Box Text | Database Table | Database Column |
|---|---|---|
|
Fiscal year creation date |
Polaris.FiscalYears |
CreationDate |
|
Fiscal year end date |
Polaris.FiscalYears |
FYEndDate |
|
Fiscal year owner ID |
Polaris.FiscalYears |
OrganizationID |
|
Fiscal year ID |
Polaris.Funds |
FiscalYearID |
|
Fiscal year name |
Polaris.FiscalYears |
Name |
|
Fiscal year notes |
Polaris.FiscalYears |
Notes |
|
Fiscal year owner abbreviation |
Polaris.Organizations |
Abbreviation |
|
Fiscal year owner name |
Polaris.Organizations |
Name |
|
Fiscal year start date |
Polaris.FiscalYears |
FYStartDate |
|
Fiscal year status |
Polaris.FiscalYearStatus |
Status |
|
Fiscal year status date |
Polaris.FiscalYears |
StatusDate |
|
Fiscal year status ID |
Polaris.FiscalYears |
FiscalYearStatusID |
|
Fund alternative name |
Polaris.Funds |
AlternativeName |
|
Fund amount expended year-to-date |
Polaris.Funds |
AmtExpYTD |
|
Fund begining allocation |
Polaris.Funds |
BegAllocation |
|
Fund carry-over allocation |
Polaris.Funds |
CarryOverAlloc |
|
Fund cash balance |
Polaris.Funds |
CashBalance |
|
Fund category |
Polaris.FundCategories |
Category |
|
Fund category ID |
Polaris.Funds |
CategoryID |
|
Fund creation date |
Polaris.Funds |
CreationDate |
|
Fund creator ID |
Polaris.Funds |
CreatorID |
|
Fund creator name |
Polaris.PolarisUsers |
Name |
|
Fund deposit funds used |
Polaris.Funds |
DepFundsUsed |
|
Fund donor corporate name |
Polaris.Donors |
CorporateName |
|
Fund donor description note |
Polaris.Donors |
DescriptionNote |
|
Fund donor Email |
Polaris.Donors |
|
|
Fund donor Fax |
Polaris.Donors |
Fax |
|
Fund donor first name |
Polaris.Donors |
FirstName |
|
Fund donor last name |
Polaris.Donors |
LastName |
|
Fund donor memorial note |
Polaris.Donors |
MemorialNote |
|
Fund donor middle name |
Polaris.Donors |
MiddleName |
|
Fund donor phone |
Polaris.Donors |
Phone |
|
Fund donor renewal date |
Polaris.Donors |
RenewalDate |
|
Fund donor restriction note |
Polaris.Donors |
RestrictionNote |
|
Fund external name |
Polaris.Funds |
ExtName |
|
Fund free balance |
Polaris.Funds |
FreeBal |
|
Fund ID |
Polaris.Funds |
FundID |
|
Fund last status update date |
Polaris.Funds |
StatusDate |
|
Fund modification date |
Polaris.Funds |
ModificationDate |
|
Fund modifier ID |
Polaris.Funds |
ModifierID |
|
Fund modifier name |
Polaris.PolarisUsers |
Name |
|
Fund name |
Polaris.Funds |
Name |
|
Fund note |
Polaris.Funds |
Note |
|
Fund or encumbrance or expenditure option |
Polaris.FundEncExpOptions |
FundEncExpOption |
|
Fund or encumbrance or expenditure option ID |
Polaris.Funds |
FundEncExpOptionID |
|
Fund owning organization abbreviation |
Polaris.Organizations |
Abbreviation |
|
Fund owning organization name |
Polaris.Organizations |
Name |
|
Fund parent fund fiscal year ID |
Polaris.Funds |
ParentFundFiscalYearID |
|
Fund parent fund ID |
Polaris.Funds |
ParentFundID |
|
Fund status |
Polaris.FundStatus |
Status |
|
Fund status ID |
Polaris.Funds |
FundStatusID |
|
Fund total amount allocated |
Polaris.Funds |
TotAlloc |
|
Fund total amount encumbered |
Polaris.Funds |
TotCurrEnc |
|
Fund total amount expended |
Polaris.Funds |
TotExp |
|
Fund total percent expended |
Polaris.Funds |
PercentExpYTD |
|
Fund transaction history creator ID |
Polaris.FundTransactionHistories |
UserID |
|
Fund transaction history creator name |
Polaris.PolarisUsers |
Name |
|
Fund transaction history ID |
Polaris.FundTransactionHistories |
FundTransactionHistID |
|
Fund transaction history invoice line item number |
Polaris.FundTransactionHistories |
OrdInvLINumber |
|
Fund transaction history invoice number |
Polaris.FundTransactionHistories |
OrdInvNumber |
|
Fund transaction history invoice number suffix |
Polaris.FundTransactionHistories |
OrdInvNumberSuf |
|
Fund transaction history note |
Polaris.FundTransactionHistories |
FundTransNote |
|
Fund transaction history source |
Polaris.FundTransactionHistories |
FundTransSource |
|
Fund transaction history transaction type ID |
Polaris.FundTransactionHistories |
FundTransactionTypeID |
|
Fund transaction history type |
Polaris.FundTransactionTypes |
FundTransType |
|
Fund type |
Polaris.FundTypes |
Type |
|
Fund type ID |
Polaris.Funds |
TypeID |
|
Funding source |
Polaris.Funds |
FundingSource |
Fund Columns for Fund Summary Reports Only
| List Box Text | Database Table | Database Column |
|---|---|---|
|
Sum amount expended year-to-date |
Polaris.Funds |
ParentFundID |
|
Sum begining allocation |
Polaris.Funds |
TotAlloc |
|
Sum carry-over allocation |
Polaris.Funds |
StatusDate |
|
Sum deposit funds used |
Polaris.Funds |
TotExp |
|
Sum free balance |
Polaris.Funds |
CategoryID |
|
Sum item price |
Polaris.Funds |
CreatorID |
|
Sum total amount allocated |
Polaris.BibliographicRecords |
PublicationYear |
|
Sum total amount deposited |
Polaris.BibliographicRecords |
PrimaryMARCTOMID |
|
Sum total amount encumbered |
Polaris.BibliographicRecords |
FirstAvailableDate |
|
Sum total amount expended |
Polaris.BibliographicRecords |
CreationDate |
|
Sum transaction history amount |
Polaris.Organizations |
Abbreviation |
Invoice Columns
Invoice columns for Invoice List and Summary reports:
| List Box Text | Database Table | Database Column |
|---|---|---|
|
Invoice creation date |
Polaris.RwriterInvHeaderView |
InvCreationDate |
|
Invoice creator name |
Polaris.RwriterInvHeaderView |
InvCreatorName |
|
Invoice credit memo number |
Polaris.RwriterInvHeaderView |
InvoiceCreditMemoNumber |
|
Invoice date |
Polaris.RwriterInvHeaderView |
InvDate |
|
Invoice EDI file name |
Polaris.RwriterInvHeaderView |
InvoiceEDIFileName |
|
Invoice header exchange rate |
Polaris.RwriterInvHeaderView |
InvoiceExchangeRate |
|
Invoice header grand total |
Polaris.RwriterInvHeaderView |
InvHeaderInvGrandTotalBase |
|
Invoice header material subtotal |
Polaris.RwriterInvHeaderView |
InvHeaderInvMaterialSubtotalBase |
|
Invoice header sales tax rate |
Polaris.RwriterInvHeaderView |
InvHeaderSalesTaxRate1 |
|
Invoice header sales tax |
Polaris.RwriterInvHeaderView |
InvHeaderSalesTax1Base |
|
Invoice ID |
Polaris.RwriterInvoiceFiscalYears |
InvoiceID |
|
Invoice line amount |
Polaris.RwriterInvlineView |
InvoiceLineAmount |
|
Invoice line item ID |
Polaris.RwriterInvlineView |
InvLineItemID |
|
Invoice line material type |
Polaris.RwriterInvlineView |
InvoiceLineMaterialType |
|
Invoice line number |
Polaris.RwriterInvlineView |
InvoiceLineNumber |
|
Invoice line payment status |
Polaris.RwriterInvlineView |
InvoiceLinePaymentStatus |
|
Invoice line quantity paid |
Polaris.RwriterInvlineView |
InvoiceLineQtyPaid |
|
Invoice line quantity received |
Polaris.RwriterInvlineView |
InvoiceLineQtyRec |
|
Invoice modification date |
Polaris.RwriterInvHeaderView |
InvModificationDate |
|
Invoice modifier |
Polaris.RwriterInvHeaderView |
InvModifier |
|
Invoice note |
Polaris.RwriterInvHeaderView |
InvNote |
|
Invoice number |
Polaris.RwriterInvHeaderView |
InvNumber |
|
Invoice number of lines |
Polaris.RwriterInvHeaderView |
NumberOfLines |
|
Invoice number suffix |
Polaris.RwriterInvHeaderView |
InvNumberSuffix |
|
Invoice organization abbr |
Polaris.RwriterInvHeaderView |
InvOrganizationAbbr |
|
Invoice organization name |
Polaris.RwriterInvHeaderView |
InvOrganizationName |
|
Invoice payment method |
Polaris.RwriterInvHeaderView |
PaymentMethod |
|
Invoice quantity paid |
Polaris.RwriterInvoiceChargeAggregates |
InvoiceTotalQtyPaid |
|
Invoice quantity received |
Polaris.RwriterInvoiceChargeAggregates |
InvoiceTotalQtyRec |
|
Invoice receive date |
Polaris.RwriterInvHeaderView |
InvReceiptDate |
|
Invoice status |
Polaris.RwriterInvHeaderView |
InvoiceStatus |
|
Invoice status date |
Polaris.RwriterInvHeaderView |
InvStatusDate |
|
Invoice type |
Polaris.RwriterInvHeaderView |
InvoiceType |
|
Payment status date |
Polaris.RwriterPaymentHistories |
InvoicePaymentStatusDate |
|
Plan name |
Polaris.RwriterInvHeaderView |
PlanName |
|
PO number |
Polaris.RwriterlineView |
PONumber |
|
Segment amount credited |
Polaris.RwriterInvLineSegmentView |
SegmentAmountCreditedBase |
|
Segment destination collection abbr |
Polaris.RwriterInvLineSegmentView |
SegmentDestinationCollectionAbbr |
|
Segment destination collection name |
Polaris.RwriterInvLineSegmentView |
SegmentDestinationCollectionName |
|
Segment destination organization abbreviation |
Polaris.RwriterInvLineSegmentView |
SegmentDestinationOrganizationAbbr |
|
Segment destination organization name |
Polaris.RwriterInvLineSegmentView |
SegmentDestinationOrganizationName |
|
Segment grand total |
Polaris.RwriterInvLineSegmentView |
SegmentGrandTotalBase |
|
Segment payment status |
Polaris.RwriterInvLineSegmentView |
SegmentPaymentStatus |
|
Segment quantity rec |
Polaris.RwriterInvLineSegmentView |
SegmentQuantityRec |
|
Segment sales tax1 |
Polaris.RwriterInvLineSegmentView |
SegmentSalesTax1Base |
|
Segment sales tax2 |
Polaris.RwriterInvLineSegmentView |
SegmentSalesTax2Base |
|
Segment total discount price |
Polaris.RwriterInvLineSegmentView |
SegmentTotalDiscountPriceBase |
|
Shipped date |
Polaris.RwriterInvHeaderView |
ShippedDate |
|
Supplier library account number |
Polaris.RwriterInvoiceFiscalYears |
SupplierLBAcctNumber |
|
Supplier name |
Polaris.RwriterInvoiceFiscalYears |
SupplierName |
|
Supplier organization abbreviation |
Polaris.RwriterInvoiceFiscalYears |
SupplierOrganizationAbbr |
|
Supplier organization name |
Polaris.RwriterInvoiceFiscalYears |
SupplierOrganizationName |
|
Supplier plan note |
Polaris.RwriterInvoiceFiscalYears |
SupplierPlanNote |
|
Supplier record name |
Polaris.RwriterInvoiceFiscalYears |
SupplierRecordName |
|
Supplier SAN |
Polaris.RwriterInvoiceFiscalYears |
SupplierSAN |
|
Sum invoice quantity paid |
Polaris.RwriterInvoiceChargeAggregates |
InvoiceTotalQtyPaid |
|
Sum invoice quantity received |
Polaris.RwriterInvoiceChargeAggregates |
InvoiceTotalQtyRec |
|
Total (Sum) cat service charges |
Polaris.RwriterInvoiceChargeAggregates |
TotalCatServChargeBase |
|
Total (Sum) other charges |
Polaris.RwriterInvoiceChargeAggregates |
TotalOtherChargeBase |
|
Total (Sum) service charge |
Polaris.RwriterInvoiceChargeAggregates |
TotalServiceChargeBase |
|
Total (Sum) ship charge |
Polaris.RwriterInvoiceChargeAggregates |
TotalShipChargeBase |
|
Total (Sum) special handling charge |
Polaris.RwriterInvoiceChargeAggregates |
TotalSpecialHandlingChargeBase |
|
Voucher check date |
Polaris.RwriterInvHeaderView |
VoucherCheckDate |
|
Voucher date |
Polaris.RwriterInvHeaderView |
VoucherDate |
|
Voucher number |
Polaris.RwriterInvHeaderView |
VoucherNumber |
Invoice Columns for Invoice Summary Reports Only
| List Box Text | Database Table | Database Column |
|---|---|---|
|
Sum segment binding charges |
Polaris.RwriterInvLineSegmentView |
SegmentBindFormatChargeBase |
|
Sum segment cataloging service charges |
Polaris.RwriterInvLineSegmentView |
SegmentCatServChargeBase |
|
Sum segment other charges |
Polaris.RwriterInvLineSegmentView |
SegmentOtherChargeBase |
|
Sum segment service charges |
Polaris.RwriterInvLineSegmentView |
SegmentServChargeBase |
|
Sum segment shipping charges |
Polaris.RwriterInvLineSegmentView |
SegmentShipChargeBase |
Purchase Order Columns
| List Box Text | Database Table | Database Column |
|---|---|---|
| Original purchase order number | Polaris.PurchaseOrders | OriginalPONumber |
| Original purchase order number suffix | Polaris.PurchaseOrders | OriginalPONumberSuf |
|
Polaris.RwriterPOHeaderView |
POCreationDate |
|
|
Polaris.RwriterPOHeaderView |
POCreatorName |
|
|
Polaris.RwriterPOHeaderView |
POExternalID |
|
|
Polaris.RwriterPurchseOrderFiscalYears |
PurchaseOrderID |
|
|
Polaris.RwriterPOlineView |
POLineAmount |
|
|
Polaris.RwriterPOHeaderView |
POHeaderDiscountRate |
|
|
Polaris.RwriterPOHeaderView |
POHeaderExchangeRate |
|
|
Polaris.RwriterPOlineView |
PoLineNoteSupplier |
|
|
Polaris.RwriterPOlineView |
POLineNotePub |
|
|
Polaris.RwriterPOlineView |
POLineNoteStaff |
|
|
Polaris.RwriterPOlineView |
POLineNumber |
|
|
Polaris.RwriterPOlineView |
POLineRentalReturnDate |
|
|
Polaris.RwriterPOlineView |
POLineStatus |
|
|
Polaris.RwriterPOHeaderView |
POModificationDate |
|
|
Polaris.RwriterPOHeaderView |
POModifierName |
|
|
Polaris.RwriterPOHeaderView |
PONumber |
|
|
Polaris.RwriterPOHeaderView |
PONumberofLines |
|
|
Polaris.RwriterPOHeaderView |
PONumberSuffix |
|
|
Polaris.RwriterPOHeaderView |
POOrderType |
|
|
Polaris.RwriterPOHeaderView |
POOrganizationAbbr |
|
|
Polaris.RwriterPOHeaderView |
POOrganizationName |
|
|
Polaris.RwriterPOHeaderView |
POHeaderPaymentMethod |
|
|
Polaris.RwriterPOHeaderView |
POPlanName |
|
|
Polaris.RwriterPOHeaderView |
POReleaseDate |
|
|
Polaris.RwriterPOHeaderView |
PORentalReturnDate |
|
|
Polaris.RwriterPOHeaderView |
POShipDate |
|
|
Polaris.RwriterPOHeaderView |
POShippingMethod |
|
|
Polaris.RwriterPOHeaderView |
POHeaderOrderStatus |
|
|
Polaris.RwriterPOHeaderView |
POStatusDate |
Purchase Order Columns for Order Summary Reports Only
| List Box Text | Database Table | Database Column |
|---|---|---|
|
Polaris.RwriterPolineSegmentView |
SegmentBindFormatChargeBase |
|
|
Polaris.RwriterPolineSegmentView |
SegmentCatServChargeBase |
|
|
Polaris.RwriterPolineSegmentView |
SegmentGrandTotalSegmentBase |
|
|
Polaris.RwriterPolineSegmentView |
SegmentOtherChargeBase |
|
|
Polaris.RwriterPolineSegmentView |
SegmentQuantOrd |
|
|
Polaris.RwriterPolineSegmentView |
SegmentQuantRec |
|
|
Polaris.RwriterPolineSegmentView |
SegmentServChargeBase |
|
|
Polaris.RwriterPolineSegmentView |
SegmentShipChargeBase |
|
|
Polaris.RwriterPOHeaderView |
POHeaderCatServChargeBase |
|
|
Polaris.RwriterPOHeaderView |
POHeaderDiscountRate |
|
|
Polaris.RwriterPOHeaderView |
POHeaderGrandTotBase |
|
|
Polaris.RwriterPOHeaderView |
POHeaderSalesTax1Base |
|
|
Polaris.RwriterPOHeaderView |
POHeaderServiceChargeBase |
|
|
Polaris.RwriterPOHeaderView |
POHeaderShippingChargeBase |
|
|
Polaris.RwriterPOHeaderView |
POHeaderSpecialHandChargeBase |
|
|
Polaris.RwriterPOAggregates |
POnLines |
|
|
Polaris.RwriterPOAggregates |
POQtyCancelled |
|
|
Polaris.RwriterPOAggregates |
POQtyClaimed |
|
|
Polaris.RwriterPOAggregates |
POQtyInv |
|
|
Polaris.RwriterPOAggregates |
POQtyOrdered |
|
|
Polaris.RwriterPOAggregates |
POQtyReceived |
|
|
Polaris.RwriterPolineSegmentView |
SegmentAmountEncumbered |
|
|
Polaris.RwriterPolineSegmentView |
SegmentAmountExpended |