AP_PE_DEL_VW (SQL View)	Index Back
Payables PE Delete View

AP_PE_DEL_VW

(SQL View)

Payables PE Delete View

SELECT BUSINESS_UNIT , VOUCHER_ID , UNPOST_SEQ , APPL_JRNL_ID , PYMNT_CNT , DST_ACCT_TYPE , LEDGER , ACCOUNTING_DT , GL_DISTRIB_STATUS , MIN(BUDGET_HDR_STATUS) , BUSINESS_UNIT_GL , PRIMARY_LEDGER FROM %Table(VCHR_ACCTG_LINE) WHERE POSTING_PROCESS = 'ACAV' AND DST_ACCT_TYPE IN ('DST', 'ENR') GROUP BY BUSINESS_UNIT , VOUCHER_ID , UNPOST_SEQ , APPL_JRNL_ID , PYMNT_CNT , DST_ACCT_TYPE, LEDGER , ACCOUNTING_DT , GL_DISTRIB_STATUS , BUSINESS_UNIT_GL, PRIMARY_LEDGER

# 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 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".

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

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

6 DST_ACCT_TYPE Character(4) VARCHAR2(4) NOT NULL 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment

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

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

9 GL_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL Distribution Status
C=Available to Contracts
D=Distributed
G=Generated
H=Hold
I=Ignored
J=Creating Journals
M=Modified
N=None
P=To be processed
X=Waiting for Reversal

10 BUDGET_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Checking Header Status
E=Error in Budget Check
I=Document In Processing
N=Not Budget Checked
P=Provisionally Valid
V=Valid

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

12 PRIMARY_LEDGER Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) a ledger is designated as the primary ledger in a ledger group.

#	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	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".
4	APPL_JRNL_ID	Character(10)	VARCHAR2(10) NOT NULL	Journal Template
5	PYMNT_CNT	Number(5,0)	INTEGER NOT NULL	Payments
6	DST_ACCT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment
7	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
8	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
9	GL_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Distribution Status C=Available to Contracts D=Distributed G=Generated H=Hold I=Ignored J=Creating Journals M=Modified N=None P=To be processed X=Waiting for Reversal
10	BUDGET_HDR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Budget Checking Header Status E=Error in Budget Check I=Document In Processing N=Not Budget Checked P=Provisionally Valid V=Valid
11	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
12	PRIMARY_LEDGER	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not (Y or N) a ledger is designated as the primary ledger in a ledger group.