ORG_DOC_NBR_SER

(SQL Table)
 Index Back

Excise Number Series Group

  • Related Language Record: ORG_DOC_SER_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 EXD_DOC_NBR_SER Character(6) VARCHAR2(6) NOT NULL Excise Document Number Series. Excise Document number series group will be created against each excise transaction type.
    3 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    4 EXD_TXN_TYPE Character(4) VARCHAR2(4) NOT NULL Excise Tax Transaction Type. This field will have various translate values for the transaction types.
    BOE=Bill of Entry
    DEXB=Deemed Export with Bond
    DEXP=Deemed Export
    DOMR=Domestic Receipt
    DOMS=Domestic Sales
    EXP=Export without bond
    EXPB=Export with bond
    IBUS=Inter-Unit Sale
    IUT=InterUnit Receipt
    MEIN=Manual
    STFR=Stock Transfer
    5 EXD_OVERWRITE_FLG Character(1) VARCHAR2(1) NOT NULL Overwrite Allowed. This field is used in Excise document series to specify whether the user needs to override the system option of auto numbering.

    Y/N Table Edit