Order

acq_type_property

Each row of acq_type_property identifies an acquisitions type code.

Column

Data Type

Not NULL?

Comment

id

int

false

System-generated sequential ID.

code

varchar

false

Acquisitions type code.

display_order

int

false

Integer to manage the display order of a list.

acq_type_property_myuser

Each row of acq_type_property_myuser identifies an acquisition type (or method of paying for the material, with the definition presented in the language associated with the user's login account. Each library maintains its own acquisition types. Standard (English) codes and definitions include:

STD CODE

DEFINITION

p

purchase

x

exchange

d

prepaid

r

recharge

g

gift

 

Column

Data Type

Not NULL?

Comment

code

varchar

false

Acquisition type code.

display_order

int

false

Integer to manage the display order of a list.

name

varchar

false

Acquisition type name.

acq_type_property_name

Each row of acq_type_property_name identifies an acquisitions type name.

Column

Data Type

Not NULL?

Comment

acq_type_property_id

int

false

Foreign key to acq_type_property.

iii_language_id

int

false

Foreign key to iii_language.

name

varchar

false

Acquisitions type name.

bib_record_order_record_link

Each row of bib_record_order_record_link identifies a linked bibliographic and order record pair.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

bib_record_id

bigint

false

Foreign key to bib_record.

order_record_id

bigint

false

Foreign key to order_record.

orders_display_order

int

false

Integer to manage the display order of an orders list.

billing_location_property

Each row of billing_location_property identifies a billing location (bill to address) code.

Column

Data Type

Not NULL?

Comment

id

int

false

System-generated sequential ID.

code

char

false

Billing location code.

display_order

int

false

Integer to manage the display order of a list.

billing_location_property_myuser

Each row of billing_location_property_myuser identifies a billing location (bill to address), with the name presented in the language associated with the user's login account. Each library maintains its own billing location names.

Column

Data Type

Not NULL?

Comment

code

char

false

Billing location code.

display_order

int

false

Integer to manage the display order of a list.

name

varchar

false

Billing location name.

billing_location_property_name

Each row of billing_location_property_name identifies a billing location name.

Column

Data Type

Not NULL?

Comment

billing_location_property_id

int

false

Foreign key to billing_location_property.

iii_language_id

int

false

Foreign key to iii_language.

name

varchar

false

Billing location name.

claim_action_property

Each row of claim_action_property identifies a claim action code.

Column

Data Type

Not NULL?

Comment

id

int

false

System-generated sequential ID.

code

varchar

false

Claim action code.

display_order

int

false

Integer to manage the display order of a list.

claim_action_property_myuser

Each row of claim_action_property_myuser identifies a claim action and presents the description in the language associated with the user's login account. Some codes are input by the library and some are automatically assigned by the system as claiming activity takes place. Standard (English) codes and names include:

CODE

NAME

-

no activity

n

do not claim

z

must claim

r

Rush claim decision made

a

Claim 1 decision made

b

Claim 2 decision made

c

Claim 3 decision made

d

Claim 4 decision made

e

Claim 5 decision made

f

Claim 6 decision made

 

Column

Data Type

Not NULL?

Comment

code

varchar

false

Claim action code.

display_order

int

false

Integer to manage the display order of a list.

name

varchar

false

Claim action description.

claim_action_property_name

Each row of claim_action_property_name identifies a claim action name/description.

Column

Data Type

Not NULL?

Comment

claim_action_property_id

int

false

Foreign key to claim_action_property.

iii_language_id

int

false

Foreign key to iii_language.

name

varchar

false

Claim action name/description.

form_property

Each row of form_property identifies a physical form code.

Column

Data Type

Not NULL?

Comment

id

int

false

System-generated sequential ID.

code

varchar

false

Physical form code.

display_order

int

false

Integer to manage the display order of a list.

form_property_myuser

Each row of form_property_myuser identifies a physical form for materials, with the name presented in the language associated with the user's login account. Each library can define its own codes and definitions. Standard (English) codes and definitions include:

STD CODE

DEFINITION

b

book

p

periodical

s

series

m

microform

c

cassette

r

phone rec.

u

map

f

film

 

Column

Data Type

Not NULL?

Comment

code

varchar

false

Physical form code.

display_order

int

false

Integer to manage the display order of a list.

name

varchar

false

Physical form name.

form_property_name

Each row of form_property_name identifies a physical form name.

Column

Data Type

Not NULL?

Comment

form_property_id

int

false

Foreign key to form_property.

iii_language_id

int

false

Foreign key to iii_language.

name

varchar

false

Physical form name.

order_note_property

Each row of order_note_property identifies an order note code.

Column

Data Type

Not NULL?

Comment

id

int

false

System-generated sequential ID.

code

varchar

false

Order note code.

display_order

int

false

Integer to manage the display order of a list.

order_note_property_myuser

Each row of order_note_property_myuser identifies an order note to print on purchase order forms, with the name presented in the language associated with the user's login account.

Column

Data Type

Not NULL?

Comment

code

varchar

false

Order note code.

display_order

int

false

Integer to manage the display order of a list.

name

varchar

false

Order note name.

Each library defines its own list of order notes. Standard (English) order notes include:

STD CODE

NAME 

DEFINITION

-

NO MESSAGE

default

r

RUSH

Generates a rush claim in the claiming module; prints a RUSH message on the order, and uses the RUSH claim cycle.

c

CONFIRMING

For printed orders that follow up on an initial phone order. Does not shorten the claim cycle.

f

RUSH-CONF

For printed orders that follow up on an initial phone order. Prints a rush message on the claim, but does not shorten the claim cycle.

order_note_property_name

Each row of order_note_property_name identifies an order note name.

Column

Data Type

Not NULL?

Comment

order_note_property_id

int

false

Foreign key to order_note_property.

iii_language_id

int

false

Foreign key to iii_language.

name

varchar

false

Order note name.

order_record

Each row of order_record contains data fields for a specific order record.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

record_id

bigint

false

Foreign key to record.

accounting_unit_code_num

int

false

Accounting unit code number.

acq_type_code

char

false

The library-defined acquisition type code, or the method of paying for the material. For example:

STD CODE

DEFINITION

p

purchase

x

exchange

d

prepaid

r

recharge

g

gift

 

catalog_date_gmt

timestamptz

false

Cataloging date.

claim_action_code

char

false

Code that controls or reports claiming activity.

CODE

NAME

-

no activity

n

do not claim

z

must claim

r

Rush claim decision made

a

Claim 1 decision made

b

Claim 2 decision made

c

Claim 3 decision made

d

Claim 4 decision made

e

Claim 5 decision made

f

Claim 6 decision made

 

ocode1

char

false

The library determines the name and purpose of this code and the code's definition.

ocode2

char

false

The library determines the name and purpose of this code and the code's definition.

ocode3

char

false

The library determines the name and purpose of this code and the code's definition.

ocode4

char

false

The library determines the name and purpose of this code and the code's definition.

estimated_price

numeric

false

Estimated price for one copy of the ordered item.

form_code

char

false

Code specifying the physical form of the material. For example:

STD CODE

DEFINITION

b

book

p

periodical

s

series

m

microform

c

cassette

r

phone rec.

u

map

f

film

 

order_date_gmt

timestamptz

false

The date the material was ordered.

order_note_code

char

false

Code for the note that prints on purchase order form. For example:

STD CODE

NAME 

DEFINITION

-

NO MESSAGE

default

r

RUSH

Generates a rush claim in the claiming module; prints a RUSH message on the order, and uses the RUSH claim cycle.

c

CONFIRMING

For printed orders that follow up on an initial phone order. Does not shorten the claim cycle.

f

RUSH-CONF

For printed orders that follow up on an initial phone order. Prints a rush message on the claim, but does not shorten the claim cycle.

 

order_type_code

char

false

Code specifying the way the material is acquired. For example:

STD CODE

NAME

f

firm order

a

approval

o

stand ord

s

subscrip.

i

item stand ord

r

replace

 

receiving_action_code

char

false

Receiving action code, usually indicating special handling. For example:

CODE

NAME

-

NO RACTION (default)

a

Attention

n

Notify

 

received_date_gmt

timestamptz

false

The date of receipt. The date in this field indicates when, and if, an order has been completely received. If there is neither an RDATE nor an ODATE, the item will be selected for claiming.

receiving_location_code

varchar

false

The receiving location (ship to address) code.

billing_location_code

varchar

false

Billing location (bill to address) code.

order_status_code

char

false

Financial encumbering/disencumbering status of record.

STD CODE

DEFINITION

o

On order (encumbered monograph)

a

Fully paid (fully disencumbered monograph)

q

Partially paid (partially disencumbered monograph)

z

Canceled (fully disencumbered)

1

On hold (not yet encumbered)

2

Approval rejection (not encumbered)

c

Serial on order (encumbered new serial)

d

Serial paid (fully paid and disencumbered serial)

e

Serial partially paid (partially paid, partially disencumbered serial)

f

Serial no encumbering (but can make payments - for continuation orders)

g

Serial encumbered (re-encumber fund for renewal)

 

temporary_location_code

char

false

Library-defined codes for temporary shelving location. For example:

CODE

DEFINITION

-

no value (default)

c

CAT. DEPT.

b

BINDERY

s

SERIALS

p

PO REQUESTED

 

vendor_record_code

varchar

false

Library-defined code for the vendor who handles the order.

language_code

varchar

false

Language of the material. LANG is based on the MARC 21 Code List for Languages (also used by UNIMARC format).

blanket_purchase_order_num

varchar

false

Blanket purchase order number used by the system to group together order records with the same blanket order number during purchase order printing and invoicing.

country_code

varchar

false

The country of publication. COUNTRY is based on the MARC 21 Code List of Countries, or ISO 3166/MA standard for UNIMARC systems.

volume_count

int

false

The number of volumes for a title.

fund_allocation_rule_code

char

false

Code identifying the rule that specifies how funds are allocated for the order.

reopen_text

varchar

false

Record status "paid" or "on order".

list_price

numeric

false

List price.

list_price_foreign_amt

numeric

false

List price in foreign currency.

list_price_discount_amt

numeric

false

Discount deducted from list price.

list_price_service_charge

numeric

false

Service charge added to list price.

is_suppressed

boolean

false

Specifies whether the record is suppressed from public display.

fund_copies_paid

int

false

The number of copies that have been paid for this order.

order_record_address_type

Each row of order_record_address_type identifies an order record address type.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

code

char

false

Code that disambiguates the field group tag.

order_record_cmf

Each row of order_record_cmf contains multi-field data for an order record.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

order_record_id

bigint

false

Foreign key to order_record.

display_order

int

false

Integer to manage the display order of a list.

fund_code

varchar

false

Fund code to be charged for the ordered items.

copies

int

false

Number of copies.

location_code

varchar

false

Location code that corresponds to the physical location of the item ordered (up to five characters).

order_record_edifact_response

Each row of order_record_edifact_response contains an EDIFACT response regarding an order record.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

order_record_id

bigint

false

Foreign key to order_record.

code

varchar

false

EDIFACT action request code from the LIN segment.

message

varchar

false

Order response message corresponding to the code number.

event_date_gmt

timestamptz

false

Date when the order response was processed.

order_record_paid

Each row of order_record_paid contains payment data for an order record.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

order_record_id

bigint

false

Foreign key to order_record.

display_order

int

false

Integer to manage the display order of a list.

paid_date_gmt

timestamptz

false

Date paid.

paid_amount

numeric

false

Amount paid.

foreign_paid_amount

numeric

false

Amount paid in foreign currency.

foreign_code

varchar

false

Foreign currency code.

voucher_num

int

false

Voucher number.

invoice_code

varchar

false

Invoice number.

invoice_date_gmt

timestamptz

false

Date of the invoice.

from_date_gmt

timestamptz

false

Subscription "from" date.

to_date_gmt

timestamptz

false

Subscription "to" date.

copies

int

false

Number of copies paid for.

note

varchar

false

Optional payment text note field.

order_record_received

Each row of order_record_received identifies a received order record.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

order_record_id

bigint

false

Foreign key to order_record.

location_code

varchar

false

Location code that corresponds to the physical location of the item ordered (up to five characters).

fund_code

varchar

false

Fund code to be charged for the ordered items.

copy_num

int

false

Copy number.

volume_num

int

false

Volume number.

item_record_metadata_id

bigint

false

Foreign key to item_record_metadata.

received_date_gmt

timestamptz

false

Date the copies were received.

display_order

int

false

Integer to manage the display order of a list.

order_status_property

Each row of order_status_property identifies an order status code.

Column

Data Type

Not NULL?

Comment

id

int

false

System-generated sequential ID.

code

varchar

false

Order status code.

display_order

int

false

Integer to manage the display order of a list.

order_status_property_myuser

Each row of order_status_property_myuser identifies a financial encumbering/disencumbering status, with the status name presented in the language associated with the user's login account. The system-generated (English) codes and definitions include:

STD CODE     

DEFINITION

o

On order (encumbered monograph)

a

Fully paid (fully disencumbered monograph)

q

Partially paid (partially disencumbered monograph)

z

Canceled (fully disencumbered)

1

On hold (not yet encumbered)

2

Approval rejection (not encumbered)

c

Serial on order (encumbered new serial)

d

Serial paid (fully paid and disencumbered serial)

e

Serial partially paid (partially paid, partially disencumbered serial)

f

Serial no encumbering (but can make payments - for continuation orders)

g

Serial encumbered (re-encumber fund for renewal)

 

Column

Data Type

Not NULL?

Comment

code

varchar

false

Order status code.

display_order

int

false

Integer to manage the display order of a list.

name

varchar

false

Order status name.

order_status_property_name

Each row of order_status_property_name identifies an order status name.

Column

Data Type

Not NULL?

Comment

order_status_property_id

int

false

Foreign key to order_status_property.

iii_language_id

int

false

Foreign key to iii_language.

name

varchar

false

Order status name.

order_type_property

Each row of order_type_property identifies an order type code.

Column

Data Type

Not NULL?

Comment

id

int

false

System-generated sequential ID.

code

varchar

false

Order type code.

display_order

int

false

Integer to manage the display order of a list.

order_type_property_myuser

Each row of order_type_property_myuser identifies an order type, with the order type name presented in the language associated with the user's login account. Each library determines its own order type names. Standard (English) codes and names include:

STD CODE     

NAME

f

firm order

a

approval

o

stand ord

s

subscrip.

i

item stand ord

r

replace

 

Column

Data Type

Not NULL?

Comment

code

varchar

false

Order type code.

display_order

int

false

Integer to manage the display order of a list.

name

varchar

false

Order type name.

order_type_property_name

Each row of order_type_property_name identifies an order type name.

Column

Data Type

Not NULL?

Comment

order_type_property_id

int

false

Foreign key to order_type_property.

iii_language_id

int

false

Foreign key to iii_language.

name

varchar

false

Order type name.

order_view

Each row of order_view includes metadata and data for one order record. The contents include identification and acquisitions information, as well as data that determines how the system handles the record.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

record_type_code

char

false

Record type code, i.e., 'o'.

record_num

int

false

Record number.

record_id

bigint

false

Foreign key to record.

accounting_unit_code_num

int

false

Accounting unit code number.

acq_type_code

char

false

The library-defined acquisition type code, or the method of paying for the material. For example:

STD CODE

DEFINITION

p

purchase

x

exchange

d

prepaid

r

recharge

g

gift

 

catalog_date_gmt

timestamptz

false

Cataloging date.

claim_action_code

char

false

Code that controls or reports claiming activity.

CODE

NAME

-

no activity

n

do not claim

z

must claim

r

Rush claim decision made

a

Claim 1 decision made

b

Claim 2 decision made

c

Claim 3 decision made

d

Claim 4 decision made

e

Claim 5 decision made

f

Claim 6 decision made

 

ocode1

char

false

The library determines the name and purpose of this code and the code's definition.

ocode2

char

false

The library determines the name and purpose of this code and the code's definition.

ocode3

char

false

The library determines the name and purpose of this code and the code's definition.

ocode4

char

false

The library determines the name and purpose of this code and the code's definition.

estimated_price

numeric

false

Estimated price for one copy of the ordered item.

material_type_code

char

false

Code specifying the physical form of the material. For example:

STD CODE

DEFINITION

b

book

p

periodical

s

series

m

microform

c

cassette

r

phone rec.

u

map

f

film

 

order_date_gmt

timestamptz

false

The date the material was ordered.

order_note_code

char

false

Code for the note that prints on purchase order form. For example:

STD CODE

NAME

DEFINITION

-

NO MESSAGE

default

r

RUSH

Generates a rush claim in the claiming module; prints a RUSH message on the order, and uses the RUSH claim cycle.

c

CONFIRMING

For printed orders that follow up on an initial phone order. Does not shorten the claim cycle.

f

RUSH-CONF

For printed orders that follow up on an initial phone order. Prints a rush message on the claim, but does not shorten the claim cycle.

 

order_type_code

char

false

Code specifying the way the material is acquired. For example:

STD CODE

NAME

f

firm order

a

approval

o

stand ord

s

subscrip.

i

item stand ord

r

replace

 

receiving_action_code

char

false

Receiving action code, usually indicating special handling. For example:

CODE 

NAME

-

NO RACTION (default)

a

Attention

n

Notify

 

received_date_gmt

timestamptz

false

The date of receipt. The date in this field indicates when, and if, an order has been completely received. If there is neither an RDATE nor an ODATE, the item will be selected for claiming.

receiving_location_code

varchar

false

The receiving location (ship to address) code.

billing_location_code

varchar

false

Billing location (bill to address) code.

order_status_code

char

false

Financial encumbering/disencumbering status of record.

STD CODE

DEFINITION

o

On order (encumbered monograph)

a

Fully paid (fully disencumbered monograph)

q

Partially paid (partially disencumbered monograph)

z

Canceled (fully disencumbered)

1

On hold (not yet encumbered)

2

Approval rejection (not encumbered)

c

Serial on order (encumbered new serial)

d

Serial paid (fully paid and disencumbered serial)

e

Serial partially paid (partially paid, partially disencumbered serial)

f

Serial no encumbering (but can make payments - for continuation orders)

g

Serial encumbered (re-encumber fund for renewal)

 

temporary_location_code

char

false

Library-defined codes for temporary shelving location. For example:

CODE 

DEFINITION

-

no value (default)

c

CAT. DEPT.

b

BINDERY

s

SERIALS

p

PO REQUESTED

 

vendor_record_code

varchar

false

Library-defined code for the vendor who handles the order.

language_code

varchar

false

Language of the material. LANG is based on the MARC 21 Code List for Languages (also used by UNIMARC format).

blanket_purchase_order_num

varchar

false

Blanket purchase order number used by the system to group together order records with the same blanket order number during purchase order printing and invoicing.

country_code

varchar

false

The country of publication. COUNTRY is based on the MARC 21 Code List of Countries, or ISO 3166/MA standard for UNIMARC systems.

volume_count

int

false

The number of volumes for a title.

fund_allocation_rule_code

char

false

Code indicating the rule that specifies how funds are allocated for the order.

reopen_text

varchar

false

Record status "paid" or "on order".

list_price

numeric

false

List price.

list_price_foreign_amt

numeric

false

List price in foreign currency.

list_price_discount_amt

numeric

false

Discount deducted from list price.

list_price_service_charge

numeric

false

Service charge added to list price.

is_suppressed

boolean

false

Specifies whether the record is suppressed from public display.

record_creation_date_gmt

timestamptz

false

Record creation date.

receiving_action_property

Each row of receiving_action_property identifies a receiving action code.

Column

Data Type

Not NULL?

Comment

id

int

false

System-generated sequential ID.

code

varchar

false

Receiving action code.

display_order

int

false

Integer to manage the display order of a list.

receiving_action_property_myuser

Each row of receiving_action_property_myuser identifies a receiving action, with the name/description in the language associated with the user's login account.

Column

Data Type

Not NULL?

Comment

code

varchar

false

Receiving action code.

display_order

int

false

Integer to manage the display order of a list.

name

varchar

false

Receiving action name/description.

Standard (English) codes and names include:

CODE

NAME

-

NO RACTION (default)

a

Attention

n

Notify

receiving_action_property_name

Each row of receiving_action_property_name identifies a receiving action name/description.

Column

Data Type

Not NULL?

Comment

receiving_action_property_id

int

false

Foreign key to receiving_action_property.

iii_language_id

int

false

Foreign key to iii_language.

name

varchar

false

Receiving action name/description.

record_lock

Each row of record_lock identifies an invoice or order record that is locked for editing.

Column

Data Type

Not NULL?

Comment

id

bigint

false

ID of an invoice or order record that is locked for editing.

resource_record_order_record_link

Each row of resource_record_order_record_link identifies a linked resource and order record pair.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

resource_record_id

bigint

false

Foreign key to resource_record.

order_record_id

bigint

false

Foreign key to order_record.

orders_display_order

int

false

Integer to manage the display order of an order list.

resources_display_order

int

false

Integer to manage the display order of a resource list.

resource_record_order_record_related_link

Each row of resource_record_order_record_related_link identifies a linked resource and license record pair.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

resource_record_id

bigint

false

Foreign key to resource_record.

order_record_id

bigint

false

Foreign key to order_record.

resources_display_order

int

false

Integer to manage the display order of a resource list.

temp_location_property

Each row of temp_location_property identifies a temporary location code.

Column

Data Type

Not NULL?

Comment

id

int

false

System-generated sequential ID.

code

varchar

false

Temporary location code.

display_order

int

false

Integer to manage the display order of a list.

temp_location_property_myuser

Each row of temp_location_property_myuser identifies a temporary location, with the name presented in the language associated with the user's login account. The library maintains its temporary location codes and names. Common (English) codes and names include:

STD CODE 

DEFINITION

-

no value (default)

c

CATALOG DEPT

b

BINDERY

s

SERIALS

p

PO REQUESTED

 

Column

Data Type

Not NULL?

Comment

code

varchar

false

Temporary location code.

display_order

int

false

Integer to manage the display order of a list.

name

varchar

false

Temporary location name.

temp_location_property_name

Each row of temp_location_property_name identifies a temporary location name.

Column

Data Type

Not NULL?

Comment

temp_location_property_id

int

false

Foreign key to temp_location_property.

iii_language_id

int

false

Foreign key to iii_language.

name

varchar

false

Temporary location name.

user_defined_ocode1_myuser

Each row of user_defined_code1_myuser identifies a user-defined fixed-length field for order records.

Column

Data Type

Not NULL?

Comment

code

varchar

false

User-defined code to represent the user-defined field.

user_defined_category_id

int

false

Foreign key to user_defined_category.

display_order

int

false

Integer to manage the display order of a list.

name

varchar

false

The user-defined name assigned to the user-defined field.

user_defined_ocode2_myuser

Each row of user_defined_code2_myuser identifies a user-defined fixed-length field for order records.

Column

Data Type

Not NULL?

Comment

code

varchar

false

User-defined code to represent the user-defined field.

user_defined_category_id

int

false

Foreign key to user_defined_category.

display_order

int

false

Integer to manage the display order of a list.

name

varchar

false

The user-defined name assigned to the user-defined field.

user_defined_ocode3_myuser

Each row of user_defined_code3_myuser identifies a user-defined fixed-length field for order records.

Column

Data Type

Not NULL?

Comment

code

varchar

false

User-defined code to represent the user-defined field.

user_defined_category_id

int

false

Foreign key to user_defined_category.

display_order

int

false

Integer to manage the display order of a list.

name

varchar

false

The user-defined name assigned to the user-defined field.

user_defined_ocode4_myuser

Each row of user_defined_code4_myuser identifies a user-defined fixed-length field for order records.

Column

Data Type

Not NULL?

Comment

code

varchar

false

User-defined code to represent the user-defined field.

user_defined_category_id

int

false

Foreign key to user_defined_category.

display_order

int

false

Integer to manage the display order of a list.

name

varchar

false

The user-defined name assigned to the user-defined field.