AUTO_NUM_BU_LNG

(SQL Table)
Index Back

Auto numbering by Doc by BU

This table stores detail information about the automatically assigned numbers, i.e. the beginning sequence, the maximum length of the auto-assigned numbers, and more.

  • Related Language Record for AUTO_NUM_TBL_BU
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    2 NUM_TYPE Character(4) VARCHAR2(4) NOT NULL AUTO_NUM_INSTAL. To enable a value in the Auto NUmber by Installation you need to add the value to the Record SearchInit Peoplecode in record AUTO_NUM_INSTAL

    Default Value: PORQ

    3 BEG_SEQ Character(3) VARCHAR2(3) NOT NULL Beginning Sequence
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description