SEQ_NBR_LST_TBL (SQL Table)	Index Back
Last sequence numbers table This table contains the last assigned sequence numbers for all automatically generated document sequence numbers. This table will be used by the sequence number generator function to determine the next sequence number to be assigned.

SEQ_NBR_LST_TBL

(SQL Table)

Last sequence numbers table

This table contains the last assigned sequence numbers for all automatically generated document sequence numbers. This table will be used by the sequence number generator function to determine the next sequence number to be assigned.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group

3 JRNL_CODE Character(8) VARCHAR2(8) NOT NULL Journal Code

4 DOC_TYPE Character(8) VARCHAR2(8) NOT NULL Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.

5 BEGIN_DT Date(10) DATE Begin Date

6 SEQ_NBR_PREFIX Character(4) VARCHAR2(4) NOT NULL Sequence Number Prefix

7 SEQ_NBR_LAST Number(12,0) DECIMAL(12) NOT NULL Last sequence number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
3	JRNL_CODE	Character(8)	VARCHAR2(8) NOT NULL	Journal Code
4	DOC_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
5	BEGIN_DT	Date(10)	DATE	Begin Date
6	SEQ_NBR_PREFIX	Character(4)	VARCHAR2(4) NOT NULL	Sequence Number Prefix
7	SEQ_NBR_LAST	Number(12,0)	DECIMAL(12) NOT NULL	Last sequence number