ACCT_CD_NA_VW

(SQL View)
 Index Back

Combo Code Prompt

Combo Code Prompt Table for NA Payroll

SELECT A.ACCT_CD , A.DESCR , A.DESCRSHORT , A.ACCOUNT , A.DEPTID_CF , A.PROJECT_ID , A.PRODUCT , A.FUND_CODE , A.PROGRAM_CODE , A.CLASS_FLD , A.AFFILIATE , A.OPERATING_UNIT , A.ALTACCT , A.BUDGET_REF , A.CHARTFIELD1 , A.CHARTFIELD2 , A.CHARTFIELD3 , A.AFFILIATE_INTRA1 , A.AFFILIATE_INTRA2 , A.BUSINESS_UNIT_PC , A.ACTIVITY_ID , A.RESOURCE_TYPE , A.RESOURCE_CATEGORY , A.RESOURCE_SUB_CAT FROM %Table(ACCT_CD_TBL) A WHERE NOT EXISTS ( SELECT 'X' FROM PS_FS_CF_TMPLT_IMG F WHERE (F.ORIG_CF_NAME = 'CHARTFIELD3' AND F.CF_ACTIVE_STATUS = 'I' AND A.CHARTFIELD3 <> ' ' ) OR (F.ORIG_CF_NAME = 'CHARTFIELD2' AND F.CF_ACTIVE_STATUS = 'I' AND A.CHARTFIELD2 <> ' ' ) OR (F.ORIG_CF_NAME = 'CHARTFIELD1' AND F.CF_ACTIVE_STATUS = 'I' AND A.CHARTFIELD1 <> ' ' ) OR (F.ORIG_CF_NAME = 'AFFILIATE_INTRA1' AND F.CF_ACTIVE_STATUS = 'I' AND A.AFFILIATE_INTRA1 <> ' ' ) OR (F.ORIG_CF_NAME = 'AFFILIATE_INTRA2' AND F.CF_ACTIVE_STATUS = 'I' AND A.AFFILIATE_INTRA2 <> ' ' ) OR (F.ORIG_CF_NAME = 'BUDGET_REF' AND F.CF_ACTIVE_STATUS = 'I' AND A.BUDGET_REF <> ' ' ) OR (F.ORIG_CF_NAME = 'ALTACCT' AND F.CF_ACTIVE_STATUS = 'I' AND A.ALTACCT <> ' ' ) OR (F.ORIG_CF_NAME = 'OPERATING_UNIT' AND F.CF_ACTIVE_STATUS = 'I' AND A.OPERATING_UNIT <> ' ' ) OR (F.ORIG_CF_NAME = 'AFFILIATE' AND F.CF_ACTIVE_STATUS = 'I' AND A.AFFILIATE <> ' ' ) OR (F.ORIG_CF_NAME = 'CLASS_FLD' AND F.CF_ACTIVE_STATUS = 'I' AND A.CLASS_FLD <> ' ' ) OR (F.ORIG_CF_NAME = 'PROGRAM_CODE' AND F.CF_ACTIVE_STATUS = 'I' AND A.PROGRAM_CODE <> ' ' ) OR (F.ORIG_CF_NAME = 'FUND_CODE' AND F.CF_ACTIVE_STATUS = 'I' AND A.FUND_CODE <> ' ' ) OR (F.ORIG_CF_NAME = 'PRODUCT' AND F.CF_ACTIVE_STATUS = 'I' AND A.PRODUCT <> ' ' ) OR (F.ORIG_CF_NAME = 'PROJECT_ID' AND F.CF_ACTIVE_STATUS = 'I' AND A.PROJECT_ID <> ' ' ) OR (F.ORIG_CF_NAME = 'DEPTID_CF' AND F.CF_ACTIVE_STATUS = 'I' AND A.DEPTID_CF <> ' ' ))

  • Related Language Record: ACCT_CD_NA_L_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code

    Prompt Table: ACCT_CD_TBL

    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    4 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
    5 DEPTID_CF Character(10) VARCHAR2(10) NOT NULL Department
    6 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project/Grant
    7 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product
    8 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
    9 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code
    10 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Public Sector Financials Chart Field.
    11 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Public Sector Financials Chart Field
    12 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit
    13 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
    14 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference Chartfield
    15 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield number 1
    16 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
    17 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
    18 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
    19 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate2
    20 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL Project Costing Business Unit
    21 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
    22 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Project Costing Resource Type
    23 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Project Costing Resource Category
    24 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Project Costing Resource Sub Category