CA_WTH_TERMS_H

(SQL Table)
 Index Back

Contracts Withholding Terms

Contracts Withholding Terms Table

  • Related Language Record: CA_WTH_TRM_LA_H

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
    2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
    3 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
    4 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num
    5 WTHD_PERCENT Signed Number(13,8) DECIMAL(11,8) NOT NULL Withholding Rate
    6 MAX_APPL_FLG Character(1) VARCHAR2(1) NOT NULL Maximum Withholding Applicable Flag

    Y/N Table Edit

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

    Prompt Table: PC_TRANS_ID

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

    Prompt Table: CA_WTHPRJ_NONVW

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

    Prompt Table: %EDITTABLE3

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

    Prompt Table: PROJ_RES_TYPE
    Set Control Field: BUSINESS_UNIT_PC

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

    Prompt Table: %EDIT_RES_CAT
    Set Control Field: BUSINESS_UNIT_PC

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

    Prompt Table: %EDIT_RES_SUB
    Set Control Field: BUSINESS_UNIT_PC

    16 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    17 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: BUS_UNIT_TBL_CA

    18 CHG_ID Character(10) VARCHAR2(10) NOT NULL Change Package Identifier. This is sequenced from 1 to N for each contract.
    19 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