CA_WTH_RELEASE

(SQL Table)
 Index Back

Contracts Withholding Release

Contracts Withholding Release Table

  • Related Language Record: CA_WTH_REL_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

    Prompt Table: CA_CNTR_SRCH_VW

    2 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num
    3 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
    4 WTHD_RELEASE_OPT Character(1) VARCHAR2(1) NOT NULL Withholding Release Option
    B=Bill
    W=Write-Off
    5 WTHD_RELEASE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Withholding Release Amount
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    8 WTHD_REL_STATUS Character(1) VARCHAR2(1) NOT NULL Withholding Release Status
    C=Complete
    I=In Process
    P=Pending
    R=Ready
    9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: BUS_UNIT_TBL_CA

    10 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
    11 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
    12 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
    13 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.