Acquisitions

Detailed View

accounting_transaction

Each row of accounting_transaction contains data fields for a specific accounting transaction.

Column	Data Type	Not NULL?	Comment
id	int	false	System-generated sequential ID.
accounting_unit_id	int	false	Foreign key to accounting_unit.
fund_master_id	int	false	Foreign key to fund_master.
voucher_num	int	false	System-generated voucher number of the transaction.
voucher_seq_num	int	false	System-generated number identifying line items by each fund and location combination.
posted_date	timestamp	false	The date the invoice was posted.
amt_type	int	false	[Not in use.]
amt	numeric	false	Amount of the transaction.
note	varchar	false	Free text note or message associated with the transaction.
source_name	varchar	false	The library's name.
last_updated_gmt	timestamptz	false	Last updated date.

accounting_transaction_ill_expenditure

Each row of accttrans_ill_expenditure identifies an inter-library loan expenditure.

Column	Data Type	Not NULL?	Comment
id	int	false	System-generated sequential ID.
accounting_transaction_id	int	false	Foreign key to accounting_transaction.

accounting_transaction_invoice_encumbrance

Each row of accttrans_invoice_encumberance contains data describing an invoice encumbrance transaction.

Column	Data Type	Not NULL?	Comment
id	int	false	System-generated sequential ID.
accounting_transaction_id	int	false	Foreign key to accounting_transaction.
invoice_record_metadata_id	bigint	false	Foreign key to invoice_record_metadata.
invoice_date	timestamp	false	The date from the vendor's invoice entered by the user.
order_record_metadata_id	bigint	false	Foreign key to order_record_metadata.
bib_record_metadata_id	bigint	false	Foreign key to bib_record_metadata.
location_code	varchar	false	Order location code.
copies	int	false	Number of copies.
foreign_currency_code	varchar	false	Specifies the foreign currency code.
foreign_currency_amt	numeric	false	Specifies the foreign currency amount of the encumbrance.
xy_note	varchar	false	Descriptive note accompanying 'x' and 'y' transactions.
subscription_from_date	timestamp	false	Subscription start date.
subscription_to_date	timestamp	false	Subscription end date.
invoice_record_line_item_num	int	false	Line item number from the invoice record.
vendor_record_metadata_id	bigint	false	Foreign key to vendor_record_metadata.

accounting_transaction_invoice_expenditure

Each row of accttrans_invoice_expenditure contains data describing an invoice expenditure transaction.

Column	Data Type	Not NULL?	Comment
id	int	false	System-generated sequential ID.
accounting_transaction_id	int	false	Foreign key to accounting_transaction.
invoice_record_metadata_id	bigint	false	Foreign key to invoice_record_metadata.
invoice_date	timestamp	false	The date from the vendor's invoice entered by the user.
order_record_metadata_id	bigint	false	Foreign key to order_record_metadata.
bib_record_metadata_id	bigint	false	Foreign key to bib_record_metadata.
subfund_code	varchar	false	Subfund code.
location_code	varchar	false	Order location code.
copies	int	false	Number of copies.
tax_amt	numeric	false	Tax amount for the transaction.
foreign_currency_code	varchar	false	Specifies the foreign currency code.
foreign_currency_amt	numeric	false	Specifies the foreign currency amount.
foreign_currency_tax_amt	numeric	false	Specifies the foreign currency tax amount.
xy_note	varchar	false	Descriptive note accompanying 'x' and 'y' transactions.
use_tax_amt	numeric	false	Use tax amount for the transaction.
ship_amt	numeric	false	Shipping cost applied to the transaction.
discount_amt	numeric	false	Discount amount applied to the transaction.
service_charge_amt	numeric	false	Service charge applied to the transaction.
subscription_from_date	timestamp	false	Subscription start date.
subscription_to_date	timestamp	false	Subscription end date.
invoice_record_line_item_num	int	false	The invoice record line item number associated with the transaction.
vendor_record_metadata_id	bigint	false	Foreign key to vendor_record_metadata.

accounting_transaction_manual_appropriation

Each row of accttrans_manual_appropriation identifies a manual appropriation transaction.

Column	Data Type	Not NULL?	Comment
id	int	false	System-generated sequential ID.
accounting_transaction_id	int	false	Foreign key to accounting_transaction.

accounting_transaction_manual_encumbrance

Each row of accttrans_manual_appropriation identifies a manual encumbrance transaction.

Column	Data Type	Not NULL?	Comment
id	int	false	System-generated sequential ID.
accounting_transaction_id	int	false	Foreign key to accounting_transaction.

accounting_transaction_manual_expenditure

Each row of acctrans_manual_appropriation identifies a manual expenditure transaction.

Column	Data Type	Not NULL?	Comment
id	int	false	System-generated sequential ID.
accounting_transaction_id	int	false	Foreign key to accounting_transaction.

accounting_transaction_order_cancellation

Each row of accttrans_order_cancellation identifies an order cancellation transaction.

Column	Data Type	Not NULL?	Comment
id	int	false	System-generated sequential ID.
accounting_transaction_id	int	false	Foreign key to accounting_transaction.
order_record_metadata_id	bigint	false	Foreign key to order_record_metadata.
bib_record_metadata_id	bigint	false	Foreign key to bib_record_metadata.
location_code	varchar	false	Order location code.
copies	int	false	Number of copies.
foreign_currency_code	varchar	false	Specifies the foreign currency code.
foreign_currency_amt	numeric	false	Specifies the foreign currency amount.
subscription_from_date	timestamp	false	Subscription start date.
subscription_to_date	timestamp	false	Subscription end date.
vendor_record_metadata_id	bigint	false	Foreign key to vendor_record_metadata.

accounting_transaction_order_encumbrance

Each row of accounting_transaction_order_encumbrance identifies an order encumbrance transaction.

Column	Data Type	Not NULL?	Comment
id	int	false	System-generated sequential ID.
accounting_transaction_id	int	false	Foreign key to accounting_transaction.
order_record_metadata_id	bigint	false	Foreign key to order_record_metadata.
bib_record_metadata_id	bigint	false	Foreign key to bib_record_metadata.
location_code	varchar	false	Order location code.
copies	int	false	Number of copies.
foreign_currency_code	varchar	false	Specifies the foreign currency code.
foreign_currency_amt	numeric	false	Specifies the foreign currency amount.
subscription_from_date	timestamp	false	Subscription start date.
subscription_to_date	timestamp	false	Subscription end date.
vendor_record_metadata_id	bigint	false	Foreign key to vendor_record_metadata.

fund_master

Each row of fund_master uniquely identifies a fund within an accounting unit.

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	System-assigned fund code number.
code	varchar	false	A fund code up to 15 characters long. Entered by the user during fund creation. The value for this column cannot repeat within the same accounting unit.

fund_property

Each row of fund_property contains information about the associated fund.

Column

Data Type

Not NULL?

Comment

int

false

System-generated sequential ID.

fund_master_id

int

false

Foreign key to fund_master.

fund_type_id

int

false

Foreign key to fund_type.

external_fund_property_id

int

false

Foreign key to external_fund_property.

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 in NULL.

user_code1

varchar

false

Single character code defined by the library. The default value for this column in NULL.

user_code2

varchar

false

Single character code defined by the library. The default value for this column in NULL.

user_code3

varchar

false

Single character code defined by the library. The default value for this column in NULL.

is_active

boolean

false

A Boolean value specifying whether the fund is active or has been deleted. Possible values are:

Value	Meaning
TRUE	The fund is active.
FALSE	The fund has been deleted.

fund_summary

Each row of fund_summary provides the year-to-date appropriation, expenditure, and encumbrance amounts, as well as the number of orders and payments for the associated fund.

Column	Data Type	Not NULL?	Comment
id	int	false	System-generated sequential ID.
fund_property_id	int	false	Foreign key to fund_property.
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".

fund_type

Each row of fund_type identifies a fund type.

Column

Data Type

Not NULL?

Comment

int

false

System-generated sequential ID.

code

varchar

false

Code that determines whether the associated data is for a current fund, a fund from last year, or fund data for the Fund Activity Report.

Value	Description
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.