KK_RPT_LED_VW

(SQL View)
Index Back

SELECT A.BUSINESS_UNIT , B.LEDGER_GROUP , A.LEDGER , A.ACCOUNT , A.DEPTID , %subrec(CF9A_AK_SBR, A) , %subrec(CFCC1_AK_SBR, A) , A.CURRENCY_CD , A.STATISTICS_CODE , -SUM( A.POSTED_TOTAL_AMT) , A.BASE_CURRENCY , C.LEDGER_GROUP_TYPE , B.LEDGER_TYPE_KK , B.AFFECT_SPEND_OPTN , ' ' FROM PS_LEDGER_KK A , PS_LED_GRP_LED_TBL B , PS_LED_GRP_TBL C , PS_SET_CNTRL_REC F WHERE A.LEDGER = B.LEDGER AND A.CURRENCY_CD = A.BASE_CURRENCY AND B.LEDGER_GROUP = C.LEDGER_GROUP AND B.SETID = C.SETID AND B.SETID = F.SETID AND F.SETCNTRLVALUE = A.BUSINESS_UNIT AND F.RECNAME = 'LED_GRP_LED_TBL' GROUP BY A.BUSINESS_UNIT, B.LEDGER_GROUP, A.LEDGER, A.ACCOUNT, A.DEPTID, %subrec(CF9A_AK_SBR, A), %subrec(CFCC1_AK_SBR, A), A.CURRENCY_CD, A.STATISTICS_CODE, A.BASE_CURRENCY, B.LEDGER_TYPE_KK, C.LEDGER_GROUP_TYPE, B.AFFECT_SPEND_OPTN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
3 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
4 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
5 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
6 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPER_UNIT_TBL

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

Prompt Table: PRODUCT_TBL

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

Prompt Table: FUND_TBL

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

Prompt Table: CLASS_CF_TBL

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

Prompt Table: PROGRAM_TBL

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

Prompt Table: BUD_REF_TBL

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

Prompt Table: AFFILIATE_VW

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

Prompt Table: %EDIT_INTRA01

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

Prompt Table: %EDIT_INTRA02

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

Prompt Table: CHARTFIELD1_TBL

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

Prompt Table: CHARTFIELD2_TBL

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

Prompt Table: CHARTFIELD3_TBL

18 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

Prompt Table: PC_BU_GL_VW

19 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: KK_PROJ_ID_VW

20 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

Prompt Table: PROJ_ACT_FVW2

21 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type

Prompt Table: PROJ_RESTYPE_FS

22 BUDGET_PERIOD Character(8) VARCHAR2(8) NOT NULL Budget Period

Prompt Table: KK_BP_ALL_VW

23 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
24 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code
25 POSTED_TOTAL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the net balance of debit and credit amounts that have been posted to a particular ChartField combination.
26 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. "
27 LEDGER_GROUP_TYPE Character(1) VARCHAR2(1) NOT NULL Ledger Group Type
A=Average Daily Balance
B=Budget
E=Commitment Control Expense
R=Commitment Control Revenue
S=Standard
T=Translation
28 LEDGER_TYPE_KK Character(1) VARCHAR2(1) NOT NULL Commitment Control Ledger Type
0=Budget
1=Expense or Recognized Revenue
2=Encumbrance
3=Pre-Encumbrance
4=Collected Revenue
5=Planned
29 AFFECT_SPEND_OPTN Character(1) VARCHAR2(1) NOT NULL Affect Spending Authority
30 ASSOC_REV_BD Character(10) VARCHAR2(10) NOT NULL Assc. Rev. Ledger Group