KK_LED_CFLDS_VW

(SQL View)
 Index Back

KK Ldgr CFs w/ edittables


SELECT DISTINCT A.SETID , A.LEDGER_GROUP , B.FIELD_SEQUENCE - 1 , B.CHARTFIELD , B.RECNAME , B.RECNAME_NO_EFFDT FROM PS_LED_GRP_LED_TBL A , PS_LED_FLDS_TBL B WHERE A.SETID = B.SETID AND A.LEDGER = B.LEDGER AND A.LEDGER_TYPE_KK > ' ' AND (B.CHARTFIELD = 'ACCOUNT' OR B.CHARTFIELD = 'DEPTID' OR B.CHARTFIELD = 'STATISTICS_CODE' OR EXISTS ( SELECT 'X' FROM PSRECFIELD D WHERE D.RECNAME IN ('CFCC1_AN_SBR', 'CF9A_AK_SBR') AND D.FIELDNAME = B.CHARTFIELD))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
3 FIELD_SEQUENCE Number(3,0) SMALLINT NOT NULL Field Sequence Number
4 CHARTFIELD Character(18) VARCHAR2(18) NOT NULL ChartField
5 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
6 RECNAME_NO_EFFDT Character(15) VARCHAR2(15) NOT NULL View - No Effective Date