Supported fields by List record type (Lists app)
- Kathleen Moore
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 |
|