WTHD_CAT_TEO1

(SQL Table)
Index Back

CCU TEO temp table

CCU temporary table for WTHD_CATEGORY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EO_PROCESS_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 WTHD_ENTITY Character(5) VARCHAR2(5) NOT NULL Withholding Entity

Default Value: WTHD_ENTITY_DFN.WTHD_ENTITY

Prompt Table: WTHD_ENTITY_DFN

3 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: WTHD_ENTITY_HDR.EFFDT

4 WTHD_TYPE Character(5) VARCHAR2(5) NOT NULL Withholding Type

Default Value: WTHD_ENTITY_DTL.WTHD_TYPE

Prompt Table: WTHD_TYPE_TBL

5 WTHD_JUR_CD Character(5) VARCHAR2(5) NOT NULL Withholding Jurisdiction

Default Value: WTHD_ENTITY_DTL.WTHD_JUR_CD

Prompt Table: WTHD_JUR_TBL

6 WTHD_CLASS Character(5) VARCHAR2(5) NOT NULL Withholding Class

Default Value: WTHD_ENTITY_DTL.WTHD_CLASS

Prompt Table: WTHD_CLASS_TBL

7 BU_CATEGORY Character(5) VARCHAR2(5) NOT NULL Business Unit Category

Default Value: WTHD_BU_CATVW.BU_CATEGORY

Prompt Table: WTHD_BU_CAT

8 VENDOR_CATEGORY Character(5) VARCHAR2(5) NOT NULL Vendor Category

Prompt Table: WTHD_VNDR_CAT

9 CREATE_PAY_FLG Character(1) VARCHAR2(1) NOT NULL Create Withholding Payment

Y/N Table Edit

Default Value: Y

10 HOLD_PAY_FLG Character(1) VARCHAR2(1) NOT NULL Hold Payment
B=Hold wthd & regular payment
N=Do Not Hold
W=Hold Withholding only

Default Value: N

11 CALENDAR_SETID Character(5) VARCHAR2(5) NOT NULL Calendar SetID

Prompt Table: SP_SETID_NONVW

12 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID

Prompt Table: WTHD_CAL_VW3

13 BASE_MIN Signed Number(19,2) DECIMAL(17,2) NOT NULL Minimum Basis Amount
14 WTHD_MIN Signed Number(19,2) DECIMAL(17,2) NOT NULL Minimum Withhold Amount
15 APPL_ON_FIRST_PAY Character(1) VARCHAR2(1) NOT NULL Applicable to First Payment

Y/N Table Edit

Default Value: N

16 ADDTL_WTHD_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Additional Withhold Percent
17 WTHD_RULE Character(5) VARCHAR2(5) NOT NULL Withholding Rule

Prompt Table: WTHD_RULE_HDR

18 WTHD_CUMUL_FLG Character(1) VARCHAR2(1) NOT NULL Withhold Cumulative Flag
19 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
20 EO_FROM_CURRENCY Character(3) VARCHAR2(3) NOT NULL Currency Code
21 PYMNT_TRMS_SETID Character(5) VARCHAR2(5) NOT NULL Payment Terms SetID