| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 WTHD_ENTITY |
Character(5) |
VARCHAR2(5) NOT NULL |
Withholding Entity
Default Value: WTHD_ENTITY_DFN.WTHD_ENTITY
Prompt Table:
WTHD_ENTITY_DFN
|
| 2 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: WTHD_ENTITY_HDR.EFFDT
|
| 3 |
WTHD_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Withholding Type
Default Value: WTHD_ENTITY_DTL.WTHD_TYPE
Prompt Table:
WTHD_TYPE_TBL
|
| 4 |
WTHD_JUR_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Withholding Jurisdiction
Default Value: WTHD_ENTITY_DTL.WTHD_JUR_CD
Prompt Table:
WTHD_JUR_TBL
|
| 5 |
WTHD_CLASS |
Character(5) |
VARCHAR2(5) NOT NULL |
Withholding Class
Default Value: WTHD_ENTITY_DTL.WTHD_CLASS
Prompt Table:
WTHD_CLASS_TBL
|
| 6 |
BU_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit Category
Default Value: WTHD_BU_CATVW.BU_CATEGORY
Prompt Table:
WTHD_BU_CAT
|
| 7 |
VENDOR_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor Category
Prompt Table:
WTHD_VNDR_CAT
|
| 8 |
CREATE_PAY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Withholding Payment
Y/N Table Edit
Default Value: Y
|
| 9 |
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
|
| 10 |
CALENDAR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Calendar SetID
Prompt Table:
SP_SETID_NONVW
|
| 11 |
CALENDAR_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Calendar ID
Prompt Table:
WTHD_CAL_VW3
|
| 12 |
BASE_MIN |
Signed Number(19,2) |
DECIMAL(17,2) NOT NULL |
Minimum Basis Amount
|
| 13 |
WTHD_MIN |
Signed Number(19,2) |
DECIMAL(17,2) NOT NULL |
Minimum Withhold Amount
|
| 14 |
APPL_ON_FIRST_PAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Applicable to First Payment
Y/N Table Edit
Default Value: N
|
| 15 |
ADDTL_WTHD_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Additional Withhold Percent
|
| 16 |
WTHD_RULE |
Character(5) |
VARCHAR2(5) NOT NULL |
Withholding Rule
Prompt Table:
WTHD_RULE_HDR
|
| 17 |
WTHD_CUMUL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Withhold Cumulative Flag
Y/N Table Edit
Default Value: N
|
| 18 |
PYMNT_TRMS_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Payment Terms SetID
Prompt Table:
SP_SETID_NONVW
|
| 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.
Prompt Table:
PYMT_TRMS_CD_VW
|