WTHD_ENTITY_DTL(SQL Table) | 
Index Back | 
|---|---|
Withholding Entity Detail | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(5) | VARCHAR2(5) NOT NULL | 
Withholding Entity
 Default Value: WTHD_ENTITY_DFN.WTHD_ENTITY Prompt Table: WTHD_ENTITY_DFN  | 
|
| 2 | Date(10) | DATE NOT NULL | 
Effective Date
 Default Value: WTHD_ENTITY_HDR.EFFDT  | 
|
| 3 | Character(5) | VARCHAR2(5) NOT NULL | 
Withholding Type
 Default Value: WTHD_TYPE_TBL.WTHD_TYPE Prompt Table: WTHD_TYPE_TBL  | 
|
| 4 | Character(5) | VARCHAR2(5) NOT NULL | 
Withholding Jurisdiction
 Default Value: WTHD_JUR_TBL.WTHD_JUR_CD Prompt Table: WTHD_JUR_TBL  | 
|
| 5 | Character(5) | VARCHAR2(5) NOT NULL | 
Withholding Class
 Default Value: WTHD_CLASS_TBL.WTHD_CLASS Prompt Table: WTHD_CLASS_VW1  | 
|
| 6 | DISTRIB_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Line | 
| 7 | MINIMUM_AMT | Signed Number(19,2) | DECIMAL(17,2) NOT NULL | Minimum Amount to Report | 
| 8 | WTHD_VAT_FLG | Character(1) | VARCHAR2(1) NOT NULL | 
Apply VAT
 Default Value: N  | 
| 9 | FREIGHT_APPL_FLG | Character(1) | VARCHAR2(1) NOT NULL | 
Apply Freight
 Default Value: N  | 
| 10 | WTHD_SUT_APPL | Character(1) | VARCHAR2(1) NOT NULL | 
Apply Sales/Use Tax
 Default Value: N  | 
| 11 | WHTD_DSCNT_APPL | Character(1) | VARCHAR2(1) NOT NULL | 
Apply Discount
 Default Value: N  | 
| 12 | NETAMT_APPL_FLG | Character(1) | VARCHAR2(1) NOT NULL | 
Apply Net Amount
 Default Value: Y  | 
| 13 | MISC_CHG_APPL_FLG | Character(1) | VARCHAR2(1) NOT NULL | 
Apply Miscellaneous Charges
 Default Value: N  | 
| 14 | EXCISE_APPL_FLG | Character(1) | VARCHAR2(1) NOT NULL | 
Apply Excise Tax
 Default Value: N  | 
| 15 | APPLY_BALANCE | Character(1) | VARCHAR2(1) NOT NULL | 
Specifies whether we apply withholding on the invoicing vendor
or the remit_to vendor
 I=Invoicing Supplier R=Remit to Supplier Default Value: R  |