VCHR_ACT_DSE_VW

(SQL View)
 Index Back

Hdr view for DSE acctg entries


SELECT DISTINCT BUSINESS_UNIT , VOUCHER_ID , PYMNT_CNT , APPL_JRNL_ID , UNPOST_SEQ , ACCOUNTING_DT , BUDGET_HDR_STATUS , KK_TRAN_OVER_FLAG , KK_TRAN_OVER_OPRID , KK_TRAN_OVER_DTTM FROM PS_VCHR_ACCTG_LINE A WHERE BUDGET_HDR_STATUS <> 'V' AND DST_ACCT_TYPE = 'DSE' AND PRIMARY_LEDGER = 'Y' AND POSTING_PROCESS <> 'ACAV' AND (A.PO_ID = ' ' OR EXISTS ( SELECT 'X' FROM PS_PO_LINE_DISTRIB C WHERE C.BUSINESS_UNIT = A.BUSINESS_UNIT_PO AND C.PO_ID = A.PO_ID AND C.KK_CLOSE_FLAG = 'N'))

# 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 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments
4 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template
5 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".
6 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
7 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
8 KK_TRAN_OVER_FLAG Character(1) VARCHAR2(1) NOT NULL Commitment Control source transaction override flag
N=No
Y=Yes
9 KK_TRAN_OVER_OPRID Character(30) VARCHAR2(30) NOT NULL Commitment Control source transaction override operator
10 KK_TRAN_OVER_DTTM DateTime(26) TIMESTAMP Commitment Control source transaction override datetime