CA_WTH_TERMS

(SQL Table)
 Index Back

Contracts Withholding Terms

Contracts Withholding Terms Table

  • Related Language Record: CA_WTH_TRM_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
    2 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num
    3 WTHD_PERCENT Signed Number(13,8) DECIMAL(11,8) NOT NULL Withholding Rate
    4 MAX_APPL_FLG Character(1) VARCHAR2(1) NOT NULL Maximum Withholding Applicable Flag

    Y/N Table Edit

    5 WTHD_MAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Maximum Withholding Amount
    6 WTHD_START_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Withholding Start Amount
    7 WTHD_SOURCE_OPT Character(1) VARCHAR2(1) NOT NULL Withholding Source Option
    A=All Costs
    F=Fees
    S=Specific
    8 WTHD_TRANS_ID Character(10) VARCHAR2(10) NOT NULL Withholding Transaction Identifier

    Prompt Table: PC_TRANS_ID

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

    Prompt Table: CA_WTHPRJ_NONVW

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

    Prompt Table: %EDITTABLE3

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

    Prompt Table: PROJ_RES_TYPE
    Set Control Field: BUSINESS_UNIT_PC

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

    Prompt Table: %EDIT_RES_CAT
    Set Control Field: BUSINESS_UNIT_PC

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

    Prompt Table: %EDIT_RES_SUB
    Set Control Field: BUSINESS_UNIT_PC

    14 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    15 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: BUS_UNIT_TBL_CA

    16 CHG_ID Character(10) VARCHAR2(10) NOT NULL Change Package Identifier. This is sequenced from 1 to N for each contract.
    17 CHG_STATUS Character(1) VARCHAR2(1) NOT NULL Change Status indicates if this change package is open for further edit: pending, ready for processing by the app. engine component of contract change management (ready) or complete, meaning that no further edit is possible and all changes have been aplied.
    C=Complete
    P=Pending
    R=Ready
    X=Cancelled