VCHR_ACT_LN_VW

(SQL View)
Index Back

Line View of Accounting Line


SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.UNPOST_SEQ , A.APPL_JRNL_ID , A.PYMNT_CNT , A.VOUCHER_LINE_NUM , A.DISTRIB_LINE_NUM , A.DST_ACCT_TYPE , 'DST' , A.CF_BAL_LINE_NUM , A.LEDGER , A.LEDGER_GROUP , A.ACCOUNTING_DT , A.GL_DISTRIB_STATUS , A.BUDGET_LINE_STATUS , A.CLOSE_STATUS , A.BUDGET_DT , A.KK_TRAN_OVER_FLAG , A.KK_TRAN_OVER_OPRID , A.KK_TRAN_OVER_DTTM , A.BUSINESS_UNIT_GL , A.CURRENCY_CD , A.MONETARY_AMOUNT , A.FOREIGN_CURRENCY , A.FOREIGN_AMOUNT , A.QTY_VCHR , A.ACCOUNT , A.ALTACCT , A.DEPTID , %subrec(CF15_AN_SBR, A) , A.PROJECT_ID , A.ACTIVITY_ID , A.RESOURCE_TYPE , A.BUSINESS_UNIT_PC , A.BUSINESS_UNIT_PO , A.PO_ID , A.LINE_NBR , A.SCHED_NBR , A.PO_DIST_LINE_NUM , A.KK_PROCESS_PRIOR , A.QTY_VCHR_STD , A.ENTRY_EVENT FROM PS_VCHR_ACCTG_LINE A WHERE A.BUDGET_HDR_STATUS <> 'V' AND A.BUDGET_LINE_STATUS IN ('N', 'E') AND A.DST_ACCT_TYPE NOT IN ('APA','IUP','DSE') AND A.PRIMARY_LEDGER = 'Y' AND A.POSTING_PROCESS <> 'ACAV'

# 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 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
7 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
8 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
9 DST_ACCT_TYPE2 Character(4) VARCHAR2(4) NOT NULL 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
10 CF_BAL_LINE_NUM Number(10,0) DECIMAL(10) NOT NULL Chart Field Balancing Line Num
11 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
12 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
13 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
14 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
15 BUDGET_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL -> SL - 15-AUG-2002 MISC_CRITERIA label has been added <-
B=Bypass
E=Error
N=Not Chk'd
V=Valid
W=Warning
16 CLOSE_STATUS Character(1) VARCHAR2(1) NOT NULL Close Status Indicator
C=Closed
O=Open
17 BUDGET_DT Date(10) DATE Budget Date
18 KK_TRAN_OVER_FLAG Character(1) VARCHAR2(1) NOT NULL Commitment Control source transaction override flag
N=No
Y=Yes
19 KK_TRAN_OVER_OPRID Character(30) VARCHAR2(30) NOT NULL Commitment Control source transaction override operator
20 KK_TRAN_OVER_DTTM DateTime(26) TIMESTAMP Commitment Control source transaction override datetime
21 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
22 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
23 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.
24 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code
25 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.
26 QTY_VCHR Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Vouchered
27 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
28 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
29 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPTID_BUGL_VW

30 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPERUNT_BUGL_VW

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

Prompt Table: PRODUCT_BUGL_VW

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

Prompt Table: FUND_BUGL_VW

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

Prompt Table: CLASSCF_BUGL_VW

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

Prompt Table: PROGRAM_BUGL_VW

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

Prompt Table: BUD_REF_BUGL_VW

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

Prompt Table: AFFILIATE_VW

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

Prompt Table: %EDIT_INTRA01

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

Prompt Table: %EDIT_INTRA02

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

Prompt Table: CF1_BUGL_VW

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

Prompt Table: CF2_BUGL_VW

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

Prompt Table: CF3_BUGL_VW

42 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
43 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
44 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
45 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
46 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
47 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
48 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
49 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
50 PO_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL PO Distribution Line Number
51 KK_PROCESS_PRIOR Character(1) VARCHAR2(1) NOT NULL Process Prior Document
52 QTY_VCHR_STD Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Vouchered in STD UOM
53 ENTRY_EVENT Character(10) VARCHAR2(10) NOT NULL Entry Event