| Table of Contents | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Instances
Field name in Lists app | Added in release | Can use to build query in UI? | Option in 'show column' in UI? | Notes |
|---|---|---|---|---|
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 |
|---|---|---|---|---|
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 |
|---|---|---|---|---|
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 |
|---|---|---|---|---|
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 |
|---|---|---|---|---|
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 |
|---|---|---|---|---|
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 |
|---|---|---|---|---|
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 |
|---|---|---|---|---|
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 |