WTHD_CALC1_AET

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 ACCUM_BASIS1 Signed Number(28,3) DECIMAL(26,3) NOT NULL This accumulated basis field will be stored in the currency of the withholding entity.
3 ACCUM_WTHD1 Signed Number(28,3) DECIMAL(26,3) NOT NULL This field will store the accumulated withholdings in the currency of the withholding entity.
4 ACCUM_SURCHRG1 Signed Number(28,3) DECIMAL(26,3) NOT NULL Accumulated Surcharge
5 ACCUM_ADDSRCHRG1 Signed Number(28,3) DECIMAL(26,3) NOT NULL Accumulated Add'l Surcharge
6 ACCUM_WTHDCESSAMT1 Signed Number(28,3) DECIMAL(26,3) NOT NULL Accumulated Additional Cess
7 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
8 PAYMENT_DT Date(10) DATE Payment Date
9 WTHD_DECL_DATE Date(10) DATE withholding declaration date
10 WHERE_CLAUSE Character(254) VARCHAR2(254) NOT NULL Where Clause
11 WTHD_RULE_EFFDT Date(10) DATE Effective Date