CA_AP_DFR_VW

(SQL View)

SELECT DISTINCT A.CONTRACT_NUM , A.ACCT_PLAN_ID , A.EVENT_NUM , A.CONTRACT_LINE_NUM , A.DST_SEQ_NUM , A.DST_USE , A.DISC_SUR_ID , A.POST_SEQ_NUM , A.ACCOUNTING_DT , A.BUSINESS_UNIT_GL , A.BUSINESS_UNIT_TO , A.CURRENCY_CD , A.BASE_CURRENCY , A.AMOUNT_BSE , A.AMOUNT , A.DST_ID , A.ACCOUNT , A.ALTACCT , A.DEPTID , %subrec(CF14_AN_SBR, A) , %subrec(PC_CF1_N_SBR, A) , A.STATISTICS_CODE , A.MOVEMENT_FLAG , A.RVSL_LINE_FLG FROM PS_CA_AP_DFR A , PS_CA_ACCTPLAN B , PS_CA_AP_EVENT C WHERE A.CONTRACT_NUM=B.CONTRACT_NUM AND A.ACCT_PLAN_ID=B.ACCT_PLAN_ID AND B.AP_STATUS IN ('DON', 'PRG') AND B.CONTRACT_NUM=C.CONTRACT_NUM AND B.ACCT_PLAN_ID=C.ACCT_PLAN_ID AND C.AP_EVENT_STATUS<>'RVS'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

2 ACCT_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Revenue Recognition Plan

3 EVENT_NUM Number(3,0) SMALLINT NOT NULL Event Number

4 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num

5 DST_SEQ_NUM Number(6,0) INTEGER NOT NULL Distribution Sequence

6 DST_USE Character(3) VARCHAR2(3) NOT NULL Added the following inactive translates for Contracts 8.4: AP Accounts Payable Liability AS Fixed Asset CA Contra Asset CG Cost of Goods Sold CL Contra Liability EX Expense IN Inventory WP Work In Progress

7 DISC_SUR_ID Character(15) VARCHAR2(15) NOT NULL Identifier

8 POST_SEQ_NUM Number(3,0) SMALLINT NOT NULL POSTING SEQUENCE NUMBER

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

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

11 BUSINESS_UNIT_TO Character(5) VARCHAR2(5) NOT NULL 04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT

12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

13 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "

14 AMOUNT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount

15 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount

16 DST_ID Character(10) VARCHAR2(10) NOT NULL Distribution Code

17 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

18 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account

19 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Prompt Table: DEPTID_NB_VW

20 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
Prompt Table: OPERUNT_NB_VW

21 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
Prompt Table: PRODUCT_NB_VW

22 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
Prompt Table: FUND_NB_VW

23 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
Prompt Table: CLASS_CF_NB_VW

24 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
Prompt Table: PROGRAM_NB_VW

25 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
Prompt Table: BUD_REF_NB_VW

26 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate
Prompt Table: AFFILIATE_VW

27 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
Prompt Table: %EDIT_INTRA01

28 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
Prompt Table: %EDIT_INTRA02

29 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
Prompt Table: CF1_NB_VW

30 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
Prompt Table: CF2_NB_VW

31 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
Prompt Table: CF3_NB_VW

32 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
Prompt Table: %EDIT_BU_PC

33 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
Prompt Table: %EDIT_PROJECT

34 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
Prompt Table: %EDIT_ACTIVITY

35 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
Prompt Table: PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC

36 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
Prompt Table: %EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC

37 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
Prompt Table: %EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC

38 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
Prompt Table: %EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC

39 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code

40 MOVEMENT_FLAG Character(1) VARCHAR2(1) NOT NULL A flag associated with a journal line that indicates whether its amount is in the natural sign or the reversal sign.
N=Natural
R=Reversal

41 RVSL_LINE_FLG Character(1) VARCHAR2(1) NOT NULL Reversing Entry
0=Not Reversed (Reversible)
0=Not Reversed (Reversible)
1=Reversed Line
1=Reversed Line
2=Reversing Line (Not Rvsible)
2=Reversing Line (Not Rvsible)

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
2	ACCT_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	Revenue Recognition Plan
3	EVENT_NUM	Number(3,0)	SMALLINT NOT NULL	Event Number
4	CONTRACT_LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Contract Line Num
5	DST_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Distribution Sequence
6	DST_USE	Character(3)	VARCHAR2(3) NOT NULL	Added the following inactive translates for Contracts 8.4: AP Accounts Payable Liability AS Fixed Asset CA Contra Asset CG Cost of Goods Sold CL Contra Liability EX Expense IN Inventory WP Work In Progress
7	DISC_SUR_ID	Character(15)	VARCHAR2(15) NOT NULL	Identifier
8	POST_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	POSTING SEQUENCE NUMBER
9	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
10	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
11	BUSINESS_UNIT_TO	Character(5)	VARCHAR2(5) NOT NULL	04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT
12	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
13	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
14	AMOUNT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
15	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
16	DST_ID	Character(10)	VARCHAR2(10) NOT NULL	Distribution Code
17	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
18	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
19	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPTID_NB_VW
20	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPERUNT_NB_VW
21	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_NB_VW
22	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_NB_VW
23	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASS_CF_NB_VW
24	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_NB_VW
25	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_NB_VW
26	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
27	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
28	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
29	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CF1_NB_VW
30	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CF2_NB_VW
31	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CF3_NB_VW
32	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit Prompt Table: %EDIT_BU_PC
33	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: %EDIT_PROJECT
34	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: %EDIT_ACTIVITY
35	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type Prompt Table: PROJ_RESTYPE_FS Set Control Field: BUSINESS_UNIT_PC
36	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category Prompt Table: %EDIT_RES_CAT Set Control Field: BUSINESS_UNIT_PC
37	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory Prompt Table: %EDIT_RES_SUB Set Control Field: BUSINESS_UNIT_PC
38	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type Prompt Table: %EDIT_ANALYSIS Set Control Field: BUSINESS_UNIT_PC
39	STATISTICS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Statistics Code
40	MOVEMENT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	A flag associated with a journal line that indicates whether its amount is in the natural sign or the reversal sign. N=Natural R=Reversal
41	RVSL_LINE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Reversing Entry 0=Not Reversed (Reversible) 0=Not Reversed (Reversible) 1=Reversed Line 1=Reversed Line 2=Reversing Line (Not Rvsible) 2=Reversing Line (Not Rvsible)