Supported fields by List record type (Lists app)

1 Instances
2 Holdings
3 Items
4 Users
5 Loans
6 Organizations - Contact info
7 Organizations - Vendor info
8 Purchase order lines

Instances

Field name in Lists app	Added in release	Can use to build query in UI?	Option in 'show column' in UI?	Notes

Field name in Lists app	Added in release	Can use to build query in UI?	Option in 'show column' in UI?
Instance statistical code list	Quesnelia (R1 2024)	FALSE	TRUE
Instance cataloged date	Quesnelia (R1 2024)	TRUE	TRUE
Instance contributor name type ID list	Quesnelia (R1 2024)	FALSE	TRUE
Instance contributor name type list	Quesnelia (R1 2024)	FALSE	TRUE
Instance contributor type ID list	Quesnelia (R1 2024)	FALSE	TRUE
Instance contributor type list	Quesnelia (R1 2024)	FALSE	TRUE
Instance created date	Quesnelia (R1 2024)	TRUE	TRUE
Instance HRID	Quesnelia (R1 2024)	TRUE	TRUE
Instance language	Quesnelia (R1 2024)	FALSE	TRUE
Instance mode of issuance	Quesnelia (R1 2024)	TRUE	TRUE
Instance mode of issuance ID	Quesnelia (R1 2024)	FALSE	TRUE
Instance resource title	Quesnelia (R1 2024)	TRUE	TRUE
Instance source	Quesnelia (R1 2024)	TRUE	TRUE
Instance statistical code ID list	Quesnelia (R1 2024)	FALSE	TRUE
Instance status	Quesnelia (R1 2024)	TRUE	TRUE
Instance status ID	Quesnelia (R1 2024)	FALSE	TRUE
Instance suppress from discovery	Quesnelia (R1 2024)	TRUE	TRUE
Instance updated date	Quesnelia (R1 2024)	TRUE	TRUE
Instance UUID	Quesnelia (R1 2024)	TRUE	TRUE

Holdings

Field name in Lists app	Added in release	Can use to build query in UI?	Option in 'show column' in UI?	Notes

Field name in Lists app	Added in release	Can use to build query in UI?	Option in 'show column' in UI?
Holdings effective library code	Quesnelia (R1 2024)	TRUE	TRUE
Holdings effective library ID	Quesnelia (R1 2024)	FALSE	TRUE
Holdings effective library name	Quesnelia (R1 2024)	TRUE	TRUE
Holdings effective location	Quesnelia (R1 2024)	TRUE	TRUE
Holdings effective location ID	Quesnelia (R1 2024)	FALSE	TRUE
Holdings HRID	Quesnelia (R1 2024)	TRUE	TRUE
Holdings ID	Quesnelia (R1 2024)	TRUE	TRUE
Holdings permanent location	Quesnelia (R1 2024)	TRUE	TRUE
Holdings permanent location ID	Quesnelia (R1 2024)	FALSE	TRUE
Holdings statistical code ID list	Quesnelia (R1 2024)	FALSE	TRUE
Holdings statistical code list	Quesnelia (R1 2024)	FALSE	TRUE
Holdings suppress from discovery	Quesnelia (R1 2024)	TRUE	TRUE
Holdings temporary location	Quesnelia (R1 2024)	TRUE	TRUE
Holdings temporary location ID	Quesnelia (R1 2024)	FALSE	TRUE
Instance UUID	Quesnelia (R1 2024)	TRUE	TRUE

Items

Field name in Lists app	Added in release	Can use to build query in UI?	Option in 'show column' in UI?	Notes

Field name in Lists app	Added in release	Can use to build query in UI?	Option in 'show column' in UI?
Holdings ID	Poppy (R2 2023)	TRUE	TRUE
Instance created date	Poppy (R2 2023)	TRUE	TRUE
Instance ID	Poppy (R2 2023)	TRUE	TRUE
Instance primary contributor	Poppy (R2 2023)	TRUE	TRUE
Instance title	Poppy (R2 2023)	TRUE	TRUE
Instance updated date	Poppy (R2 2023)	TRUE	TRUE
Item barcode	Poppy (R2 2023)	TRUE	TRUE
Item call number	Poppy (R2 2023)	TRUE	TRUE
Item call number type ID	Poppy (R2 2023)	FALSE	TRUE
Item call number type name	Poppy (R2 2023)	TRUE	TRUE
Item copy number	Poppy (R2 2023)	TRUE	TRUE
Item created date	Poppy (R2 2023)	TRUE	TRUE
Item effective call number	Poppy (R2 2023)	TRUE	TRUE
Item effective call number type ID	Poppy (R2 2023)	FALSE	TRUE
Item effective call number type name	Poppy (R2 2023)	TRUE	TRUE
Item effective library code	Poppy (R2 2023)	TRUE	TRUE
Item effective library ID	Poppy (R2 2023)	FALSE	TRUE
Item effective library name	Poppy (R2 2023)	TRUE	TRUE
Item effective location ID	Poppy (R2 2023)	FALSE	TRUE
Item effective location name	Poppy (R2 2023)	TRUE	TRUE
Item hrid	Poppy (R2 2023)	TRUE	TRUE
Item ID	Poppy (R2 2023)	TRUE	TRUE
Item material ID	Poppy (R2 2023)	FALSE	TRUE
Item material type	Poppy (R2 2023)	TRUE	TRUE
Item permanent ID	Poppy (R2 2023)	FALSE	TRUE
Item permanent location name	Poppy (R2 2023)	TRUE	TRUE
Item statistical code ID list	Quesnelia (R1 2024)	FALSE	TRUE
Item statistical code list	Quesnelia (R1 2024)	FALSE	TRUE
Item status	Poppy (R2 2023)	TRUE	TRUE
Item temporary ID	Poppy (R2 2023)	FALSE	TRUE
Item temporary location name	Poppy (R2 2023)	TRUE	TRUE
Item updated date	Poppy (R2 2023)	TRUE	TRUE

Users

Field name in Lists app	Added in release	Can use to build query in UI?	Option in 'show column' in UI?	Notes

Field name in Lists app	Added in release	Can use to build query in UI?	Option in 'show column' in UI?	Notes
User active	Poppy (R2 2023)	TRUE	TRUE
User address ID list	Quesnelia (R1 2024)	FALSE	TRUE
User address list (line 1)	Quesnelia (R1 2024)	FALSE	TRUE
User address list (line 2)	Quesnelia (R1 2024)	FALSE	TRUE
User address type list	Quesnelia (R1 2024)	FALSE	TRUE
User barcode	Poppy (R2 2023)	TRUE	TRUE
User city list	Quesnelia (R1 2024)	FALSE	TRUE
User country ID list	Quesnelia (R1 2024)	FALSE	TRUE
User created date	Poppy (R2 2023)	TRUE	TRUE
User custom field	Quesnelia (R1 2024)	TRUE	TRUE	initial support is only for ‘Checkbox’ type custom fields
User date of birth	Poppy (R2 2023)	TRUE	TRUE
User department ID list	Quesnelia (R1 2024)	FALSE	TRUE
User department list	Quesnelia (R1 2024)	FALSE	TRUE
User email	Poppy (R2 2023)	TRUE	TRUE
User enrollment date	Poppy (R2 2023)	TRUE	TRUE
User expiration date	Poppy (R2 2023)	TRUE	TRUE
User external system ID	Poppy (R2 2023)	TRUE	TRUE
User first name	Poppy (R2 2023)	TRUE	TRUE
User ID	Poppy (R2 2023)	TRUE	TRUE
User last name	Poppy (R2 2023)	TRUE	TRUE
User middle name	Poppy (R2 2023)	TRUE	TRUE
User mobile phone	Poppy (R2 2023)	TRUE	TRUE
User patron group	Poppy (R2 2023)	TRUE	TRUE
User patron group ID	Poppy (R2 2023)	FALSE	TRUE
User phone	Poppy (R2 2023)	TRUE	TRUE
User postal code list	Quesnelia (R1 2024)	FALSE	TRUE
User preferred contact type	Poppy (R2 2023)	TRUE	TRUE
User preferred first name	Poppy (R2 2023)	TRUE	TRUE
User primary address	Poppy (R2 2023)	TRUE	TRUE
User region list	Quesnelia (R1 2024)	FALSE	TRUE
User updated date	Poppy (R2 2023)	TRUE	TRUE
Username	Poppy (R2 2023)	TRUE	TRUE

Loans

Field name in Lists app	Added in release	Can use to build query in UI?	Option in 'show column' in UI?	Notes

Field name in Lists app	Added in release	Can use to build query in UI?	Option in 'show column' in UI?
Holdings ID	Poppy (R2 2023)	TRUE	TRUE
Instance ID	Poppy (R2 2023)	TRUE	TRUE
Instance primary contributor	Poppy (R2 2023)	TRUE	TRUE
Instance title	Poppy (R2 2023)	TRUE	TRUE
Item barcode	Poppy (R2 2023)	TRUE	TRUE
Item call number	Poppy (R2 2023)	TRUE	TRUE
Item ID	Poppy (R2 2023)	TRUE	TRUE
Item material type	Poppy (R2 2023)	TRUE	TRUE
Item material type ID	Poppy (R2 2023)	FALSE	TRUE
Item status	Poppy (R2 2023)	TRUE	TRUE
Loan checkin service point ID	Poppy (R2 2023)	FALSE	TRUE
Loan checkin service point name	Poppy (R2 2023)	TRUE	TRUE
Loan checkout date	Poppy (R2 2023)	TRUE	TRUE
Loan checkout service point ID	Poppy (R2 2023)	FALSE	TRUE
Loan checkout service point name	Poppy (R2 2023)	TRUE	TRUE
Loan due date	Poppy (R2 2023)	TRUE	TRUE
Loan ID	Poppy (R2 2023)	TRUE	TRUE
Loan policy ID	Poppy (R2 2023)	FALSE	TRUE
Loan policy name	Poppy (R2 2023)	TRUE	TRUE
Loan return date	Poppy (R2 2023)	TRUE	TRUE
Loan status	Poppy (R2 2023)	TRUE	TRUE
User active	Poppy (R2 2023)	TRUE	TRUE
User barcode	Poppy (R2 2023)	TRUE	TRUE
User expiration date	Poppy (R2 2023)	TRUE	TRUE
User first name	Poppy (R2 2023)	TRUE	TRUE
User full name	Poppy (R2 2023)	TRUE	TRUE
User ID	Poppy (R2 2023)	TRUE	TRUE
User last name	Poppy (R2 2023)	TRUE	TRUE
User patron group	Poppy (R2 2023)	TRUE	TRUE
User patron group ID	Poppy (R2 2023)	FALSE	TRUE

Organizations - Contact info

Field name in Lists app	Added in release	Can use to build query in UI?	Option in 'show column' in UI?	Notes

Field name in Lists app	Added in release	Can use to build query in UI?	Option in 'show column' in UI?	Notes
Acquisition unit IDs	Quesnelia (R1 2024)	FALSE	TRUE
Acquisition units	Quesnelia (R1 2024)	FALSE	TRUE
Categories	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Contact addresses
Categories	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Contact email addresses
Categories	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Contact phone number
Categories	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Contact URLs
Category IDs	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Contact addresses
Category IDs	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Contact email addresses
Category IDs	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Contact phone number
Category IDs	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Contact URLs
City	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Contact addresses
Contact addresses	Quesnelia (R1 2024)	FALSE	TRUE	Nested heading
Contact email addresses	Quesnelia (R1 2024)	FALSE	TRUE	Nested heading
Contact phone numbers	Quesnelia (R1 2024)	FALSE	TRUE	Nested heading
Contact URLs	Quesnelia (R1 2024)	FALSE	TRUE	Nested heading
Country	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Contact addresses
Description	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Contact email addresses
Description	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Contact URLs
Description	Quesnelia (R1 2024)	TRUE	FALSE	Nested under Organization alias
Email address	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Contact email addresses
Line 1	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Contact addresses
Line 2	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Contact addresses
Organization accounting code	Quesnelia (R1 2024)	TRUE	TRUE
Organization alias	Quesnelia (R1 2024)	FALSE	TRUE	Nested heading
Organization code	Quesnelia (R1 2024)	TRUE	TRUE
Organization description	Quesnelia (R1 2024)	FALSE	TRUE
Organization ID	Quesnelia (R1 2024)	TRUE	TRUE
Organization last updated	Quesnelia (R1 2024)	TRUE	TRUE
Organization name	Quesnelia (R1 2024)	TRUE	TRUE
Organization status	Quesnelia (R1 2024)	TRUE	TRUE
Organization type IDs	Quesnelia (R1 2024)	FALSE	TRUE
Organization type names	Quesnelia (R1 2024)	FALSE	TRUE
Phone number	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Contact phone number
Postal code	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Contact addresses
State/province	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Contact addresses
Type	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Contact phone number
URL	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Contact URLs
Value	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Organization alias

Organizations - Vendor info

Field name in Lists app	Added in release	Can use to build query in UI?	Option in 'show column' in UI?	Notes

Field name in Lists app	Added in release	Can use to build query in UI?	Option in 'show column' in UI?	Notes
Account number	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Organization account
Account status	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Organization account
Accounting code	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Organization account
Acquisition unit ID list	Quesnelia (R1 2024)	FALSE	TRUE
Acquisition unit ID list	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Organization account
Acquisition unit list	Quesnelia (R1 2024)	FALSE	TRUE
Acquisition unit list	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Organization account
Contact Info	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Organization account
Description	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Organization account
Description	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Organization alias
Discount percentage	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Organization agreements
Library code	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Organization account
Library EDI code	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Organization account
Name	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Organization account
Notes	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Organization account
Notes	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Organization agreements
Organization account	Quesnelia (R1 2024)	FALSE	TRUE	Nested heading
Organization accounting code	Quesnelia (R1 2024)	TRUE	TRUE
Organization agreements	Quesnelia (R1 2024)	FALSE	TRUE	Nested heading
Organization alias	Quesnelia (R1 2024)	FALSE	TRUE	Nested heading
Organization claiming interval	Quesnelia (R1 2024)	TRUE	TRUE
Organization code	Quesnelia (R1 2024)	TRUE	TRUE
Organization description	Quesnelia (R1 2024)	TRUE	TRUE
Organization discount percent	Quesnelia (R1 2024)	TRUE	TRUE
Organization expected activation interval	Quesnelia (R1 2024)	TRUE	TRUE
Organization expected invoice interval	Quesnelia (R1 2024)	TRUE	TRUE
Organization expected receipt interval	Quesnelia (R1 2024)	TRUE	TRUE
Organization export to accounting	Quesnelia (R1 2024)	TRUE	TRUE
Organization ID	Quesnelia (R1 2024)	TRUE	TRUE
Organization last updated	Quesnelia (R1 2024)	TRUE	TRUE
Organization name	Quesnelia (R1 2024)	TRUE	TRUE
Organization payment method	Quesnelia (R1 2024)	TRUE	TRUE
Organization renewal activation interval	Quesnelia (R1 2024)	TRUE	TRUE
Organization status	Quesnelia (R1 2024)	TRUE	TRUE
Organization subscription interval	Quesnelia (R1 2024)	TRUE	TRUE
Organization tax ID	Quesnelia (R1 2024)	TRUE	TRUE
Organization tax percentage	Quesnelia (R1 2024)	TRUE	TRUE
Organization type IDs	Quesnelia (R1 2024)	FALSE	TRUE
Organization type names	Quesnelia (R1 2024)	FALSE	TRUE
Organization vendor currencies	Quesnelia (R1 2024)	FALSE	TRUE
Payment method	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Organization account
Reference URL	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Organization agreements
Value	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Organization alias
Vendor terms name	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Organization agreements

Purchase order lines

Field name in Lists app	Added in release	Can use to build query in UI?	Option in 'show column' in UI?	Notes

Field name in Lists app	Added in release	Can use to build query in UI?	Option in 'show column' in UI?	Notes
Acquisition unit ID list	Quesnelia (R1 2024)	FALSE	TRUE
Acquisition unit list	Quesnelia (R1 2024)	FALSE	TRUE
Code	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Fund distribution
Distribution type	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Fund distribution
Encumbrance	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Fund distribution
Fund distributions	Quesnelia (R1 2024)	FALSE	TRUE	Nested heading
Fund ID	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Fund distribution
PO approved	Quesnelia (R1 2024)	TRUE	TRUE
PO assigned to	Quesnelia (R1 2024)	TRUE	TRUE
PO assigned to ID	Quesnelia (R1 2024)	TRUE	TRUE
PO created by	Quesnelia (R1 2024)	TRUE	TRUE
PO created by ID	Quesnelia (R1 2024)	TRUE	TRUE
PO created date	Quesnelia (R1 2024)	TRUE	TRUE
PO ID	Quesnelia (R1 2024)	TRUE	TRUE
PO note list	Quesnelia (R1 2024)	FALSE	TRUE
PO number	Quesnelia (R1 2024)	TRUE	TRUE
PO type	Quesnelia (R1 2024)	TRUE	TRUE
PO updated by	Quesnelia (R1 2024)	TRUE	TRUE
PO updated by ID	Quesnelia (R1 2024)	TRUE	TRUE
PO updated date	Quesnelia (R1 2024)	TRUE	TRUE
PO workflow status	Quesnelia (R1 2024)	TRUE	TRUE
POL created by	Quesnelia (R1 2024)	TRUE	TRUE
POL created by ID	Quesnelia (R1 2024)	TRUE	TRUE
POL created date	Quesnelia (R1 2024)	TRUE	TRUE
POL currency	Quesnelia (R1 2024)	TRUE	TRUE
POL description	Quesnelia (R1 2024)	TRUE	TRUE
POL estimated price	Quesnelia (R1 2024)	TRUE	TRUE
POL exchange rate	Quesnelia (R1 2024)	TRUE	TRUE
POL ID	Quesnelia (R1 2024)	TRUE	TRUE
POL number	Quesnelia (R1 2024)	TRUE	TRUE
POL payment status	Quesnelia (R1 2024)	TRUE	TRUE
POL receipt status	Quesnelia (R1 2024)	TRUE	TRUE
POL updated by	Quesnelia (R1 2024)	TRUE	TRUE
POL updated by ID	Quesnelia (R1 2024)	TRUE	TRUE
POL updated date	Quesnelia (R1 2024)	TRUE	TRUE
Value	Quesnelia (R1 2024)	FALSE	FALSE	Nested under Fund distribution
Vendor code	Quesnelia (R1 2024)	TRUE	TRUE
Vendor ID	Quesnelia (R1 2024)	FALSE	TRUE
Vendor name	Quesnelia (R1 2024)	TRUE	TRUE