WTHD_ENTITY_DTL(SQL Table) |
Index Back |
---|---|
Withholding Entity Detail |
# | 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_TYPE_TBL.WTHD_TYPE Prompt Table: WTHD_TYPE_TBL |
4 | WTHD_JUR_CD | Character(5) | VARCHAR2(5) NOT NULL |
Withholding Jurisdiction
Default Value: WTHD_JUR_TBL.WTHD_JUR_CD Prompt Table: WTHD_JUR_TBL |
5 | WTHD_CLASS | 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 |