Page Comparison

Name

Max

Len

Data

Type

Default Value

Input

Type

Action

Event

Validation

Type

Tab Index

Remarks

SER_

9,0

decimal

0

RCV_REC_ID

40

varchar

System Generated

INV_RQST_STAT_CD

4

ACTN_DATE

DATETIME

FDOC_NBR

The action date is reset every time an issue is received by adding the action interval (see below) to today's date; a batch program finds reads action dates to determine when the record should be listed for review because the prescribed period of time has passed with any receipt action. Operators may manually change the action date to a future date at any time.

ACTN_INTRVL

40

varchar

INV_PD_DT

datetime

INV_DT

datetimeThe estimated number of days between receipt of each
issue, e.g., a quarterly serial might have an action interval of 100 (90
days for the quarter + 10 days to account for delivery or sorting
delays). Added to today's date following a receipt to establish the action date.

BIB_ID

40

varchar

invoice date

INV_NBR

Identifies the linked bib which has the descriptive metadata for the serial title being received.

BOUND_LOC

40

varchar

invoice number

VNDR_INV_AMT

19,2

Identifies the shelving location where bound volumes of the serial title are physically stored; used for display in the library's user interface

CALL_NUM

40

varchar

vendor invoice amount

INV_RQST_PAY_DT

Displays the call number from the linked instance record

RCV_REC_TYP

40

varchar

INV_RQST_CST_SRC_CD 

Identifies whether the receiving record is for the main title, supplement, or index

CHRON_CAPTN_LVL1

40

varchar

VNDR_HDR_GNRTD_ID

10,0

Records the text of the caption used for this level.

CHRON_CAPTN_LVL2

40

varchar

VNDR_DTL_ASND_ID

10,0

Records the text of the caption used for this level.

CHRON_CAPTN_LVL3

40

varchar

VNDR_NM

Records the text of the caption used for this level.

CHRON_CAPTN_LVL4

40

varchar

OLE_VNDR_CURR_ID

10,0

Records the text of the caption used for this level.

CLAIM

1

varchar

Determines whether or not a batch program looking for claims-eligible titles ignores the record or not. 

CLAIM_

19,2

ITRVL_INFO

100

varchar

OLE_INV_TYP_ID

10,0

Free text note providing misc. information about claiming unique to this title that may be of staff interest/concern 

COPY_NUM

40

varchar

OLE_INV_SUB_TYP_ID

10,0

The copy number is used to distinguish multiple subscriptions which may or may not be shelved in the same location. It should be inherited from the instance. Each subscription requires its own instance. 

CORPORATE_AUTH

40

varchar

Displays the 100/110/111 |ab b from the linekd bib record for the serial title 

OLE_INV_MTHD_ID

10,0

CREATE_ITEM

1

varchar

Indicates whether or not an item also is created when a serial issue is received 

ENUM_

CAPTN_

LVL1

40

varchar

Records the text of the caption used for this level. 

ENUM_

CAPTN_

LVL2

40

varchar

Records the text of the caption used for this level. 

ENUM_

CAPTN_

LVL3

40

varchar

Records the text of the caption used for this level. 

ENUM_

CAPTN_LVL4

40

varchar

Records the text of the caption used for this level. 

ENUM_

CAPTN_LVL5

40

varchar

Records the text of the caption used for this level. 

ENUM_

CAPTN_LVL6

40

varchar

Records the text of the caption used for this level. 

Name

Length

Data type

Default Value

Input type

Action event

Validation type

Tab Index

Remarks

INV_PO_ITM_ID

9,0

decimal

0

GEN_RCVNG_NOTE

100

varchar

INV_RQST_ID

9,0

decimal

0

PO_ID

9,0

Free text information displayed to operators accessing the record. 

INSTANCE_ID

40

varchar

PO_ENCUM_FSCL_YR

4,0

Identifies the linked instance record for the serial title. 

ISSN

40

varchar

To identify the purchase order number

AP_PUR_DOC_LNK_ID

10,0

Displays the 022 |a from the linked bib record for the serial title.

PO_ID

50

varchar

Identifies the PO on which the title has been ordered/renewed 

PRINT_

LBL

1

varchar

Indicates whether a serial issue label is printed upon receipt or not 

PUBLIC_

DISPLAY

1

varchar

NULL

PO_LN_NBR

3,0

decimal

NULL

ITM_TYP_CD

4

Determines whether or not ANY of the serials receipt history information displays to public users or not. 

PUBLISHER

40

varchar

ITM_LN_NBR

3,0

Publisher from 260 |b of  linked bib

SER_RCPT_LOC

40

varchar

Identifies the work area at which issue receipts are recorded. 

SER_RCV_

REC

40

varchar

System-assigned unique ID 

SUBSCR_

STAT

40

varchar

Describes the present receipt status of the serial title. 

SERIAL_

RCVNG_

RECOD_ID

40

varchar

ITM_UOM_CD

Foreign Key of Serial Receiving Record

TREATMENT_INSTR_NOTE

100

varchar

Text that identifies any special processing steps that need to be followed when an issue of this serial is received. 

UNBOUND_

11,2

LOC

40

varchar

Identifies the shelving location where unbound issues of the serial title are physically stored; used for display in the library's user interface 

URGENT_

19,4

NOTE

100

varchar

PO_ITM_UNIT_PRC

19,4

Text that identifies any special situation/instruction that the operator needs to be follow BEFORE receiving an issue of this serial. 

VENDOR

3

varchar

ITM_OSTND_INV_QTY

11,2

decimal

ITM_OSTND_INV_AMT

19,2

decimal

Automatically inherits the vendor from a linked PO; if no PO, selected from the OLE vendors by operator creating/updating the record. This vendor is the one to which claims are sent. 

CREATE_DATE

DATETIME

ITM_TAX_AMT

19,

decimal

ITM_EXTND_PRC

19,2

Date on which the record entered the system 

OPTR_ID

40

varchar

OLE_ITM_OSTND_INV_PRTS

11,2

decimal

OLE_ITM_INV_PRTS

11,2

decimal

OLE_PO_ITM_ID

10,0

 decimal

OLE_LST_PRC

19,4

decimal

OLE_DOCUMENT_UUID

50

Name of the person creating/updating the record 

MACH_ID

100

varchar

Desktop at which the record was created/updated 

SUBSCR_

STAT_

1

varchar

N

DT

DATETIME

ITM_ASND_TO_TRADE_IN_IND

1

varchar

OLE_DISCNT

19,4

decimal

OLE_DISCNT_TYP

1

varchar

Name

Length

Date on which the subscription status was changed

Name

Max

Len

DataType

DefaultValue

Input

Type

Action

Event

Validation

Type

TabIndex

Remarks

SER_RCPT_HIS_REC_ID

40

varchar

System Generated

SER_

RCV_

REC_ID

40

varchar

FIN_COA_CD

Foreign Key of Serial Receiving Record

RCV_REC_TYP

40

varchar

ACCOUNT_NBR

Three hard-coded values that determines whether the serials receiving record was created for the main title; a supplement to the title; or an index for the title. The receipt lines that follow show the issues received for each type.

CHRON_LVL_1

40

varchar

Records the caption and value for this level as entered during the receipt transaction. 

CHRON_

LVL_

2

40

varchar

Records the caption and value for this level as entered during the receipt transaction. 

CHRON_

LVL_

3

40

varchar

Records the caption and value for this level as entered during the receipt transaction. 

CHRON_

LVL_

4

40

varchar

Records the caption and value for this level as entered during the receipt transaction. 

ITM_ACCT_TOT_AMT

19,2

CLAIM_COUNT

40

NUMERIC

Indicates the number of claims made for the issue on this line. 

DISENC_AMT`

19,2

CLAIM_DATE

DATETIME

Name

Length

Data type

Default Value

Input type

Action event

Validation type

Tab Index

Remarks

SUM_ACCT_ID

10,0

decimal

INV_RQST_ID

9,0

decimal

FIN_COA_CD

2

Indicates the date on which the last claim was generated. 

CLAIM_NOTE

100

varchar

Free text that can be added to a claim notice specific to the situation and would be in addition to the claim text (see below). 

CLAIM_

RESP

40

varchar

Text as returned by the vendor in response to the claim 

ENUM_

LVL_

1

40

varchar

Records the caption and value for this level as entered during the receipt transaction. 

ENUM_

LVL_

2

40

varchar

Records the caption and value for this level as entered during the receipt transaction. 

ENUM_

LVL_

3

40

varchar

Records the caption and value for this level as entered during the receipt transaction. 

ENUM_

LVL_

19,2

4

40

varchar

Records the caption and value for this level as entered during the receipt transaction. 

ENUM_

LVL_

5

40

varchar

Name

Length

Data type

Default Value

Input type

Action event

Validation type

Tab Index

Remarks

INV_PO_ITM_USE_TAX_ID

10,0

decimal

Records the caption and value for this level as entered during the receipt transaction. 

ENUM_LVL_6

40

varchar

Records the caption and value for this level as entered during the receipt transaction. 

INV_PO_ITM_ID

10,0

PUBLIC_DISPLAY

1

varchar

Determines whether or not this information displays to public users or not. 

SER_

RCPT_

NOTE

100

varchar

Information to display only to staff for this specific issue. 

OPTR_

ID

40

varchar

FIN_OBJECT_CD

Name of the person adding the issue to the receipt history.

MACH_ID

100

varchar

RATE_CD

10

varchar

TAX_AMT

19,4

decimal

Desktop at which the issue was added to the receipt history.