SEQ_NBR_MAN_TBL (SQL Table)	Index Back
Manual sequence numbers table This table contains all manually entered document sequence numbers. This table will be used by the sequence number generator function to determine if a manual number has been entered before to avoid duplicates.

SEQ_NBR_MAN_TBL

(SQL Table)

Manual sequence numbers table

This table contains all manually entered document sequence numbers. This table will be used by the sequence number generator function to determine if a manual number has been entered before to avoid duplicates.

# 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 DOC_SEQ_NBR Character(12) VARCHAR2(12) NOT NULL Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.

#	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	DOC_SEQ_NBR	Character(12)	VARCHAR2(12) NOT NULL	Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.