PC_FND_DIST_LN

(SQL Table)
 Index Back

Multiple Funding Source Detail

This record stores the target detail for multiple funding sources rules. The user must select a rate amount, target activity ID and target analysis type, and may choose to additionally override the resource type, resource category and resource subcategory.

  • Related Language Record: PC_FND_DST_L_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_PC_NONVW

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

    Prompt Table: PROJECT_VW

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

    Prompt Table: PROJ_ACT_FND_VW

    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 DETAIL_NO Number(3,0) SMALLINT NOT NULL Detail Number

    Default Value: 1

    6 SEQ_NO Number(15,0) DECIMAL(15) NOT NULL Sequence Number

    Default Value: 1

    7 LINE_NO Number(3,0) SMALLINT NOT NULL Line Number

    Default Value: 1

    8 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    9 DIST_TRANS_ID Number(15,0) DECIMAL(15) NOT NULL Distribution Transaction ID
    10 TARGET_GROUP_ID Character(10) VARCHAR2(10) NOT NULL Target Group ID
    11 RATE_AMOUNT Number(11,4) DECIMAL(10,4) NOT NULL Rate Amount
    12 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    13 OVERRIDE_SRC Character(1) VARCHAR2(1) NOT NULL Override Source

    Y/N Table Edit

    Default Value: N

    14 TGT_ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Target Activity ID

    Prompt Table: PROJ_ACT_VW

    15 TGT_AN_TYPE Character(3) VARCHAR2(3) NOT NULL Target Analysis Type

    Prompt Table: PROJ_ANTYPE_TBL

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

    Prompt Table: PROJ_RES_TYPE

    17 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category

    Prompt Table: %EDITTABLE

    18 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory

    Prompt Table: %EDITTABLE2

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

    Prompt Table: SP_BU_GL_NONVW

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

    Prompt Table: %EDIT_ACCOUNT

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

    Prompt Table: %EDIT_ALTACCT

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

    Prompt Table: %EDIT_DEPT

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

    Prompt Table: %EDIT_OPER_UNIT

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

    Prompt Table: %EDIT_PRODUCT

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

    Prompt Table: %EDIT_FUND_CODE

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

    Prompt Table: %EDIT_CLASS_FLD

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

    Prompt Table: %EDIT_PROG_CODE

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

    Prompt Table: %EDIT_BUD_REF

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

    Prompt Table: AFFILIATE_VW

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

    Prompt Table: %EDIT_INTRA01

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

    Prompt Table: %EDIT_INTRA02

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

    Prompt Table: %EDIT_CHARTFLD1

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

    Prompt Table: %EDIT_CHARTFLD2

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

    Prompt Table: %EDIT_CHARTFLD3

    35 THRESHOLD_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Threshold Amount
    36 DISTRIB_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Distributed amount
    37 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: BUS_UNIT_TBL_PC.CURRENCY_CD

    38 BUDGET_CHECK Character(1) VARCHAR2(1) NOT NULL Budget Checked
    N=No
    Y=Yes

    Default Value: N

    39 ALLOW_REVERSAL Character(1) VARCHAR2(1) NOT NULL Allow Reversals
    N=No
    Y=Yes

    Default Value: N

    40 BALANCING_FLG Character(1) VARCHAR2(1) NOT NULL Balancing
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N