Miscellaneous Tables

This section contains information about miscellaneous tables:

Field or Control Description

BI_IVC_NUM_PRE (BUSINESS_UNIT, INVOICE)

Contains one record for each invoice number that has been preassigned in a batch process, such as bill copy group or bill interface, to avoid a duplicate key assignment.

SETID_TBL (SETID)

Contains one record for each SetID created in PeopleSoft.

SET_CNTRL_TBL (SETCNTRLVALUE)

Contains one record for each set control value and its default SetID.

SET_CNTRL_GROUP (SETCNTRLVALUE, REC_GROUP_ID)

Contains one record for each record group and the pointers between a set control value and a SetID.

SET_CNTRL_REC (SETCNTRLVALUE, REC_GROUP_ID, RECNAME)

Contains one record for each record and the record group to which it belongs. The table also contains the pointers between a set control value and a SetID.