EX_PE_DEL_VW

(SQL View)
 Index Back

SELECT A.BUSINESS_UNIT , A.BUSINESS_UNIT_GL , A.EX_DOC_ID , A.EX_DOC_TYPE , A.LINE_NBR , A.DISTRIB_LINE_NUM , A.DST_ACCT_TYPE , A.APPL_JRNL_ID , A.UNPOST_SEQ , A.ACCOUNTING_DT , A.BUDGET_HDR_STATUS , A.GL_DISTRIB_STATUS , A.LEDGER , A.MONETARY_AMOUNT , A.CURRENCY_CD , A.FOREIGN_AMOUNT , A.FOREIGN_CURRENCY , A.REVERSAL_DATE , A.ACCOUNT , A.ALTACCT , A.DEPTID , A.PROJECT_ID , %subrec(CF16_AN_SBR, A) , %subrec(EX_PROJFLDS_01, A) FROM PS_EX_ACCTG_LINE A WHERE A.EX_DOC_TYPE IN ('R', 'M') AND A.DST_ACCT_TYPE IN ('DST','ENR')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
3 EX_DOC_ID Character(10) VARCHAR2(10) NOT NULL Documentation ID
4 EX_DOC_TYPE Character(1) VARCHAR2(1) NOT NULL Identifies Expenses Document Type
A=Cash Advance
C=Time Report
J=Time Adjustment
M=Accrual - My Wallet
R=Accrual - Expense Report
S=Expense Report
T=Travel Authorization
5 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
6 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
7 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
8 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template
9 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".
10 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
11 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
12 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
13 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
14 MONETARY_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
15 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
16 FOREIGN_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item.
17 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code
18 REVERSAL_DATE Date(10) DATE Specifies the date for an automatic reversal journal entry. The date must be within the calendar of the target (posting) ledger. PeopleSoft General Ledger automatically creates and populates a journal entry with this date.
19 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
20 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
21 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
22 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
23 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPERUNT_BUGL_VW

24 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

Prompt Table: PRODUCT_BUGL_VW

25 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

Prompt Table: FUND_BUGL_VW

26 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

Prompt Table: CLASSCF_BUGL_VW

27 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

Prompt Table: PROGRAM_BUGL_VW

28 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

Prompt Table: BUD_REF_BUGL_VW

29 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

Prompt Table: AFFILIATE_VW

30 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

Prompt Table: %EDIT_INTRA01

31 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

Prompt Table: %EDIT_INTRA02

32 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

Prompt Table: CF1_BUGL_VW

33 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

Prompt Table: CF2_BUGL_VW

34 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

Prompt Table: CF3_BUGL_VW

35 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
36 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
37 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
38 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
39 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
40 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
41 PC_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL PC Distribution Status
B=Budget Check
D=Distributed
G=Generated
H=Hold
I=Ignore
M=Modified
N=Not Distributed
S=Staged

Default Value: N