Vendor

user_defined_vcode1_myuser

Each row of user_defined_vcode1_myuser identifies a user-defined fixed-length field for vendor 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_vcode2_myuser

Each row of user_defined_vcode2_myuser identifies a user-defined fixed-length field for vendor 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_vcode3_myuser

Each row of user_defined_vcode3_myuser identifies a user-defined fixed-length field for vendor 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.

vendor_record

Each row of vendor_record contains data fields for a specific vendor 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.

code

varchar

false

A code that uniquely identifies the vendor.

claim_cycle_code

char

false

Code representing the number of days to wait until system selects order as overdue and ready to be claimed.

vcode1

char

false

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

vcode2

char

false

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

vcode3

char

false

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

order_cnt

int

false

Total number of orders sent to this vendor.

claim_cnt

int

false

Total number of claims sent to this vendor.

cancel_cnt

int

false

Total number of orders to this vendor that were cancelled.

receipt_cnt

int

false

Total number of orders this vendor filled.

invoice_cnt

int

false

Total number of invoices paid to this vendor.

orders_claimed_cnt

int

false

Total number of orders with claims against them.

copies_received_cnt

int

false

Total number of copies received.

order_total_amt

numeric

false

Total amount encumbered for all orders.

invoice_total_amt

numeric

false

Total payments (monetary amount) to this vendor.

estimated_received_price_amt

numeric

false

Total encumbrance for orders that have been received.

estimated_cancelled_price_amt

numeric

false

Total encumbrance for cancelled orders.

average_weeks

int

false

Average delivery time in weeks.

discount

int

false

Percent discount off list price for all orders to this vendor.

vendor_message_code

varchar

false

Code identifying brief messages associated with the vendor that appear on purchase orders and claims.

language_code

varchar

false

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

gir_code

int

false

Code used in EDIFACT ordering to determine what information is sent to the vendor in the GIR segment of the electronic order.

CODE

DEFINITION

0

no GIR

1

GIR, no address

2

GIR with address

3

GIR with call number, no address

4

GIR with call number and address

 

is_suppressed

boolean

false

Specifies whether the record is suppressed from public display.

vendor_record_address

Each row of vendor_record_address contains the address components from a vendor record.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

vendor_record_id

bigint

false

Foreign key to vendor_record.

vendor_record_address_type_id

bigint

false

Foreign key to vendor_record_address_type.

display_order

int

false

Integer to manage the display order of a list.

addr1

varchar

false

Vendor address line 1.

addr2

varchar

false

Vendor address line 2.

addr3

varchar

false

Vendor address line 3.

village

varchar

false

Vendor address village. (Used only at UK sites.)

city

varchar

false

Vendor address city.

region

varchar

false

Vendor address region. (US State or Canadian Province)

postal_code

varchar

false

Vendor address postal code.

country

varchar

false

Vendor address country.

vendor_record_address_type

Each row of vendor_record_address_type identifies a vendor 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.

vendor_view

Each row of holdings_view includes metadata and data for one vendor record. The contents include identifying and descriptive 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., 'v'.

record_num

int

false

Record number.

accounting_unit_code_num

int

false

Accounting unit code number.

code

varchar

false

A code that uniquely identifies the vendor.

claim_cycle_code

char

false

Code representing the number of days to wait until system selects order as overdue and ready to be claimed.

vcode1

char

false

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

vcode2

char

false

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

vcode3

char

false

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

order_cnt

int

false

Total number of orders sent to this vendor.

claim_cnt

int

false

Total number of claims sent to this vendor.

cancel_cnt

int

false

Total number of orders to this vendor that were cancelled.

receipt_cnt

int

false

Total number of orders this vendor filled.

invoice_cnt

int

false

Total number of invoices paid to this vendor.

orders_claimed_cnt

int

false

Total number of orders with claims against them.

copies_received_cnt

int

false

Total number of copies received.

order_total_amt

numeric

false

Total amount encumbered for all orders.

invoice_total_amt

numeric

false

Total payments (monetary amount) to this vendor.

estimated_received_price_amt

numeric

false

Total encumbrance for orders that have been received.

estimated_cancelled_price_amt

numeric

false

Total encumbrance for cancelled orders.

average_weeks

int

false

Average delivery time in weeks.

discount

int

false

Percent discount off list price for all orders to this vendor.

vendor_message_code

varchar

false

Code identifying brief messages associated with the vendor that appear on purchase orders and claims.

language_code

varchar

false

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

gir_code

int

false

Code used in EDIFACT ordering to determine what information is sent to the vendor in the GIR segment of the electronic order.

CODE

DEFINITION

0

no GIR

1

GIR, no address

2

GIR with address

3

GIR with call number, no address

4

GIR with call number and address

 

is_suppressed

boolean

false

Specifies whether the record is suppressed from public display.

record_creation_date_gmt

timestamptz

false

Record creation date.