WTHDENTDTL_TEO2

(SQL Table)
Index Back

CCU TEO temp table

CCU temporary table for WTHD_ENTITY_DTL

# 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_TYPE_TBL.WTHD_TYPE

Prompt Table: WTHD_TYPE_TBL

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

Default Value: WTHD_JUR_TBL.WTHD_JUR_CD

Prompt Table: WTHD_JUR_TBL

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

Default Value: WTHD_CLASS_TBL.WTHD_CLASS

Prompt Table: WTHD_CLASS_TBL

7 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
8 MINIMUM_AMT Signed Number(19,2) DECIMAL(17,2) NOT NULL Minimum Amount to Report
9 WTHD_VAT_FLG Character(1) VARCHAR2(1) NOT NULL Apply VAT

Default Value: N

10 FREIGHT_APPL_FLG Character(1) VARCHAR2(1) NOT NULL Apply Freight

Default Value: N

11 WTHD_SUT_APPL Character(1) VARCHAR2(1) NOT NULL Apply Sales/Use Tax

Default Value: N

12 WHTD_DSCNT_APPL Character(1) VARCHAR2(1) NOT NULL Apply Discount

Default Value: N

13 NETAMT_APPL_FLG Character(1) VARCHAR2(1) NOT NULL Apply Net Amount

Default Value: Y

14 MISC_CHG_APPL_FLG Character(1) VARCHAR2(1) NOT NULL Apply Miscellaneous Charges

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

16 EO_FROM_CURRENCY Character(3) VARCHAR2(3) NOT NULL Currency Code