Fund

accounting_unit

Each row of accounting_unit holds an accounting unit code.

Column

Data Type

Not NULL?

Comment

id

int

false

System-generated sequential ID.

code_num

int

false

Accounting unit code.

accounting_unit_myuser

Each row of accounting_unit_myuser identifies an accounting unit, with the name presented in the language associated with the user's login account. Each library maintains its own accounting unit names.

Column

Data Type

Not NULL?

Comment

code

int

false

Accounting unit code.

name

varchar

false

Accounting unit name.

accounting_unit_name

Each row of accounting_unit_name identifies an accounting unit name.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

iii_language_id

bigint

false

Foreign key to iii_language.

accounting_unit_id

bigint

false

Foreign key to accounting_unit.

name

varchar

false

Accounting unit name.

external_fund_property

Each row of external_fund_property identifies an external fund code.

Column

Data Type

Not NULL?

Comment

id

int

false

System-generated sequential ID.

accounting_unit_id

int

false

Foreign key to accounting_unit.

code_num

int

false

External fund code.

external_fund_property_myuser

Each row of external_fund_property_myuser identifies an external fund source, with the name presented in the language associated with the user's login account. Each library maintains its own list of external fund sources.

Column

Data Type

Not NULL?

Comment

code

int

false

External fund code.

accounting_unit_id

int

false

Foreign key to accounting_unit.

name

varchar

false

External fund name.

external_fund_property_name

Each row of external_fund_property_name identifies an external fund name.

Column

Data Type

Not NULL?

Comment

external_fund_property_id

int

false

Foreign key to external_fund_property.

iii_language_id

int

false

Foreign key to iii_language.

name

varchar

false

External fund name.

fund

Each row of fund describes a fund within an accounting unit.

Column

Data Type

Not NULL?

Comment

acct_unit

int

false

The code number of the accounting unit to which the fund belongs.

fund_type

varchar

false

Code that determines the fund property.

CODE 

DEFINITION

fbal

The linked data is for a current fund.

oldfbal

The linked data is for a fund from last year.

fprevbal

The linked data is for a Fund Activity Report.

 

fund_code

varchar

false

A fund code entered by the user during fund creation. The value for this column cannot repeat within the same accounting unit.

external_fund

int

false

Numeric code identifying the source fund (parent agency fund) for this library fund. These codes are maintained by library staff.

appropriation

int

false

Integer representing the monetary amount appropriated to the fund. Note that this value does not include any currency separators. The default value is "NULL".

expenditure

int

false

Integer representing the total amount spent from the fund. Note that this value does not include any currency separators. The default value is "NULL".

encumbrance

int

false

Integer representing the amount currently encumbered for this fund. Note that this value does not include any currency separators. The default value is "NULL".

num_orders

int

false

Integer representing the running total of the number of orders on this fund year-to-date. The default value is "NULL".

num_payments

int

false

Integer representing the running total of the number of payments on this fund year-to-date. The default value is "NULL".

warning_percent

int

false

Integer representing the percent of the fund that can be spent before spending warnings appear when creating or modifying order records. Entered by library staff. The default value for this column is "NULL".

discount_percent

int

false

Integer representing the percentage by which the library wants the system to discount the EPRICE (when computing the encumbrance) of all items purchased using this fund. Entered by library staff. The default value for this column is "NULL".

fund_myuser

Each row of fund_myuser identifies a fund, with the name presented in the language associated with the user's login account.

Column

Data Type

Not NULL?

Comment

acct_unit

int

false

The code number of the accounting unit to which the fund belongs.

fund_type

varchar

false

Code that determines the fund property.

CODE 

DEFINITION

fbal

The linked data is for a current fund.

oldfbal

The linked data is for a fund from last year.

fprevbal

The linked data is for a Fund Activity Report.

 

fund_master_id

int

false

Foreign key to fund_master.

fund_code

varchar

false

A fund code entered by the user during fund creation. The value for this column cannot repeat within the same accounting unit.

external_fund_code_num

int

false

Numerical code of the parent agency fund that is a library funding source.

appropriation

int

false

Integer representing the monetary amount appropriated to the fund. Note that this value does not include any currency separators. The default value is "NULL".

expenditure

int

false

Integer representing the total amount spent from the fund. Note that this value does not include any currency separators. The default value is "NULL".

encumbrance

int

false

Integer representing the amount currently encumbered for this fund. Note that this value does not include any currency separators. The default value is "NULL".

num_orders

int

false

Integer representing the running total of the number of orders on this fund year-to-date. The default value is "NULL".

num_payments

int

false

Integer representing the running total of the number of payments on this fund year-to-date. The default value is "NULL".

warning_percent

int

false

Integer representing the percent of the fund that can be spent before spending warnings appear when creating or modifying order records. Entered by library staff. The default value for this column is "NULL".

discount_percent

int

false

Integer representing the percentage by which the library wants the system to discount the EPRICE (when computing the encumbrance) of all items purchased using this fund. Entered by library staff. The default value for this column is "NULL".

name

varchar

false

Fund name.

note1

varchar

false

Free-text note entered by the user.

note2

varchar

false

Free-text note entered by the user.

fund_property_name

Each row of fund_property_name identifies a fund name.

Column

Data Type

Not NULL?

Comment

fund_property_id

int

false

Foreign key to fund_property.

iii_language_id

int

false

Foreign key to iii_language.

name

varchar

false

Fund name.

note1

varchar

false

Free-text note entered by the user.

note2

varchar

false

Free-text note entered by the user.

fund_summary_subfund

Each row of fund_summary_subfund describes a subfund. If the site does not use subfunds, this table is empty.

Column

Data Type

Not NULL?

Comment

fund_summary_id

int

false

Foreign key to fund_summary.

code

varchar

false

The fixcode value corresponding to the subfund.

value

int

false

The running total of the expenditures for the subfund specified by the code column.

fund_type_summary

Each row of fund_type_summary a fund's last lien number and last voucher number used during posting.

Column

Data Type

Not NULL?

Comment

accounting_unit_id

int

false

Foreign key to accounting_unit.

fund_type_id

int

false

Foreign key to fund_type.

last_lien_num

int

false

The last lien number used by the system during posting. The default value for this column is "NULL".

last_voucher_num

int

false

The last voucher number used by the system during posting. The default value for this column is "NULL".