CA_WTH_RELEAS_H

(SQL Table)
 Index Back

Contracts Withholding Release

Contracts Withholding Release Table

  • Related Language Record: CA_WTH_REL_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

    Prompt Table: CA_CNTR_SRCH_VW

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

    Prompt Table: BUS_UNIT_TBL_CA

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