ORG_DOC_NBR_RNG

(SQL Table)
Index Back

Excise Document Num Range

# 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 ORG_CODE Character(6) VARCHAR2(6) NOT NULL Organization Code. This will be unique to an Organization.
3 ORG_TAX_LOC_CD Character(10) VARCHAR2(10) NOT NULL Tax Location Code. An Organization can have multiple Tax Location Codes.

Prompt Table: ORG_TAX_LOC

4 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.

Prompt Table: ORG_DOC_NBR_SER

5 START_DT Date(10) DATE NOT NULL Start Date
6 EXD_NBR_PREFIX Character(3) VARCHAR2(3) NOT NULL Number Prefix. This field is used in Excise number range. The combination of Excise Document Series and Excise transaction type can be chosen to specify the Number prefix.
7 EXD_MAX_LENGTH Number(3,0) SMALLINT NOT NULL Maximum Length. This field is used in Document number range.
8 EXD_LAST_NBR Number(15,0) DECIMAL(15) NOT NULL Last Number Used. This field is used in Excise document number range.