SEQ_NBR_MAN_VW (SQL View)	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_VW

(SQL View)

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.

SELECT A.BUSINESS_UNIT , A.LEDGER_GROUP , C.LED_GRP_DEFAULT , B.LEDGER , A.JRNL_CODE , A.DOC_TYPE , A.BEGIN_DT , A.DOC_SEQ_NBR FROM PS_SEQ_NBR_MAN_TBL A , PS_BU_LED_TBL B , PS_BUS_UNIT_TBL_GL C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.LEDGER_GROUP = B.LEDGER_GROUP AND A.BUSINESS_UNIT = C.BUSINESS_UNIT

# 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 LED_GRP_DEFAULT Character(10) VARCHAR2(10) NOT NULL Default Journal Generator Ledger Group of a Business Unit

4 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger

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

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

7 BEGIN_DT Date(10) DATE Begin Date

8 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	LED_GRP_DEFAULT	Character(10)	VARCHAR2(10) NOT NULL	Default Journal Generator Ledger Group of a Business Unit
4	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
5	JRNL_CODE	Character(8)	VARCHAR2(8) NOT NULL	Journal Code
6	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.
7	BEGIN_DT	Date(10)	DATE	Begin Date
8	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.