VCHR_ACT_LN4_VW (SQL View)	Index Back
Line View of Accounting Line

VCHR_ACT_LN4_VW

(SQL View)

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 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 = 'DSE' AND A.PRIMARY_LEDGER = 'Y' AND A.PO_ID != ' ' AND NOT EXISTS ( SELECT 'X' FROM PS_PO_LINE_DISTRIB B WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT_PO AND B.PO_ID = A.PO_ID AND B.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 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

#	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