DST_DETL_CNTRL

(SQL Table)
 Index Back

AP Acctg Entry Template Detail

  • Parent record: DST_CNTRL_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 DST_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Accounting Template
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 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
    5 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

    Prompt Table: %EDIT_ACCOUNT

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

    Prompt Table: %EDIT_ALTACCT

    7 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPTID_NB_VW

    8 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

    Prompt Table: OPERUNT_NB_VW

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

    Prompt Table: PRODUCT_NB_VW

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

    Prompt Table: FUND_NB_VW

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

    Prompt Table: CLASS_CF_NB_VW

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

    Prompt Table: PROGRAM_NB_VW

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

    Prompt Table: BUD_REF_NB_VW

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

    Prompt Table: AFFILIATE_VW

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

    Prompt Table: %EDIT_INTRA01

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

    Prompt Table: %EDIT_INTRA02

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

    Prompt Table: CF1_NB_VW

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

    Prompt Table: CF2_NB_VW

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

    Prompt Table: CF3_NB_VW

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

    Prompt Table: SP_PROJFS_NONVW

    21 OFFSET_ACCT_FLG Character(1) VARCHAR2(1) NOT NULL Offset Account

    Y/N Table Edit

    Default Value: N