WTHDENTDTL_TEO2(SQL Table) |
Index Back |
---|---|
CCU TEO temp tableCCU 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 |