VCHR_DOCSEQ_VW (SQL View)	Index Back
Voucher Doc Seq VW /* New View Created to Fetch data from Voucher Document Sequence Records */

VCHR_DOCSEQ_VW

(SQL View)

Voucher Doc Seq VW

/* New View Created to Fetch data from Voucher Document Sequence Records */

SELECT BUSINESS_UNIT ,VOUCHER_ID ,AP_TRANS_TYPE ,UNPOST_SEQ ,APPL_JRNL_ID ,PYMNT_CNT ,BUSINESS_UNIT_GL ,ACCOUNTING_DT ,DOC_TYPE ,DOC_SEQ_NBR ,DOC_SEQ_DATE ,DOC_SEQ_STATUS ,PROCESS_INSTANCE FROM PS_VCHR_DOCSEQ_HDR WHERE AP_TRANS_TYPE <> 'R' UNION SELECT BUSINESS_UNIT ,VOUCHER_ID ,AP_TRANS_TYPE ,UNPOST_SEQ ,APPL_JRNL_ID ,PYMNT_CNT ,BUSINESS_UNIT_GL ,ACCOUNTING_DT ,DOC_TYPE ,DOC_SEQ_NBR ,DOC_SEQ_DATE ,DOC_SEQ_STATUS ,PROCESS_INSTANCE FROM PS_VRVL_DOCSEQ_HDR WHERE AP_TRANS_TYPE = 'R'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

3 AP_TRANS_TYPE Character(1) VARCHAR2(1) NOT NULL Payables Transaction Type
A=Voucher Accrual
C=Cash Clearing
D=Drafts Due
F=Drafts Write Off
P=Payment
R=Revaluation
U=Unpost
V=Void Payment
W=Voucher Close

4 UNPOST_SEQ Number(2,0) SMALLINT NOT NULL Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1".

5 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template

6 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments

7 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

8 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

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

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

11 DOC_SEQ_DATE Date(10) DATE Specifies the date that a document sequence number is assigned to a document or the date the document was created.

12 DOC_SEQ_STATUS Character(1) VARCHAR2(1) NOT NULL A flag that indicates a document sequencing error. If there is no error the field is blank and document is considered valid for posting.
1=Document Sequencing Disabled
A=GL BU Undefined
B=GL BU Blank
C=Accounting Date blank
D=Doc Type Blank
E=Jrnl Type, Code, Doc Undefine
F=Sequence Range Undefine
G=Max. Sequence Number Reached
H=Manual Nbr for Auto Doc Type
I=No Manual Number Entered
J=Duplicate Manual Number
K=Invalid Ledger
L=Invalid Ledger Group
N=No Status

13 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
3	AP_TRANS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Payables Transaction Type A=Voucher Accrual C=Cash Clearing D=Drafts Due F=Drafts Write Off P=Payment R=Revaluation U=Unpost V=Void Payment W=Voucher Close
4	UNPOST_SEQ	Number(2,0)	SMALLINT NOT NULL	Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1".
5	APPL_JRNL_ID	Character(10)	VARCHAR2(10) NOT NULL	Journal Template
6	PYMNT_CNT	Number(5,0)	INTEGER NOT NULL	Payments
7	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
8	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
9	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.
10	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.
11	DOC_SEQ_DATE	Date(10)	DATE	Specifies the date that a document sequence number is assigned to a document or the date the document was created.
12	DOC_SEQ_STATUS	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates a document sequencing error. If there is no error the field is blank and document is considered valid for posting. 1=Document Sequencing Disabled A=GL BU Undefined B=GL BU Blank C=Accounting Date blank D=Doc Type Blank E=Jrnl Type, Code, Doc Undefine F=Sequence Range Undefine G=Max. Sequence Number Reached H=Manual Nbr for Auto Doc Type I=No Manual Number Entered J=Duplicate Manual Number K=Invalid Ledger L=Invalid Ledger Group N=No Status
13	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance