AV_ACCTG_LN_VW2 (SQL View)	Index Back
AV Accounting Line View. This record is used as a prompt table for Seqnum on Accounting line.

AV_ACCTG_LN_VW2

(SQL View)

AV Accounting Line View.

This record is used as a prompt table for Seqnum on Accounting line.

SELECT DISTINCT AV_BUSINESS_UNIT ,RUN_DT ,SEQNUM FROM PS_AV_ACCTG_LN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 RUN_DT Date(10) DATE Run Date

3 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	RUN_DT	Date(10)	DATE	Run Date
3	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number