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