BUSINESS_UNITWTHD_ENTITYTDS_CERT_NUMN=Inactive
Y=Active
Default Value: 0
Default Value: 0
Default Value: 0
Default Value: 0
Default Value: 0
Default Value: 0
Default Value: 0
Default Value: 0
Default Value: 0
TDS_CERT_TBL(SQL Table) |
Index Back |
|---|---|
TDS Certificate Header |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | WTHD_ENTITY |
Character(5) | VARCHAR2(5) NOT NULL | Withholding Entity |
| 3 | TDS_CERT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | India Withholding Certificate |
| 4 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 5 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 6 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 7 | CALENDAR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Calendar SetID |
| 8 | CALENDAR_ID | Character(2) | VARCHAR2(2) NOT NULL | Calendar ID |
| 9 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 10 | PERIOD | Number(3,0) | SMALLINT NOT NULL | Period |
| 11 | WTHD_CLASS | Character(5) | VARCHAR2(5) NOT NULL | Withholding Class |
| 12 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 13 | FROM_DT | Date(10) | DATE | From Date |
| 14 | THRU_DATE | Date(10) | DATE | Through Date |
| 15 | DUP_CHK | Character(1) | VARCHAR2(1) NOT NULL | Duplicate Check |
| 16 | ORG_SETID | Character(5) | VARCHAR2(5) NOT NULL | Organization SetID. |
| 17 | ORG_CODE | Character(6) | VARCHAR2(6) NOT NULL | Organization Code. This will be unique to an Organization. |
| 18 | ORG_NAME | Character(50) | VARCHAR2(50) NOT NULL | Organization Name. |
| 19 | ORG_TAN | Character(20) | VARCHAR2(20) NOT NULL | Tax Deduction Account Number. A number allotted by the Income Tax Authority to identify an Organization for withholding payments. |
| 20 | ORG_TAN_CIRCLE | Character(30) | VARCHAR2(30) NOT NULL | Income Tax Circle. This code denotes the location of the Income Tax offices where an organization's taxes are dealt and is given by the Tax authority. |
| 21 | ORG_TAN_WARD | Character(30) | VARCHAR2(30) NOT NULL | Income Tax Ward. This code denotes the location of the Income Tax offices where an organization's taxes are dealt and is given by the Tax authority. |
| 22 | ORG_PAN | Character(20) | VARCHAR2(20) NOT NULL | Personal Account Number. This is allotted by the Income Tax Authority to identify an organization in their tax returns. |
| 23 | ORG_PAN_CIRCLE | Character(30) | VARCHAR2(30) NOT NULL | PAN Circle. This code denotes the location of the Income Tax offices where an organization's taxes are dealt and is given by the Tax authority. |
| 24 | ORG_PAN_WARD | Character(30) | VARCHAR2(30) NOT NULL | PAN Ward. This code denotes the location of the Income Tax offices where an organization's taxes are dealt and is given by the Tax authority. |
| 25 | ORG_TAX_LOC_CD | Character(10) | VARCHAR2(10) NOT NULL | Tax Location Code. An Organization can have multiple Tax Location Codes. |
| 26 | LOCATION_SETID | Character(5) | VARCHAR2(5) NOT NULL | Location Set ID |
| 27 | ORG_TAX_LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Organization Tax Location |
| 28 | REMIT_ADDR_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Remitting Location |
| 29 | NAME1_VNDR | Character(40) | VARCHAR2(40) NOT NULL | Vendor Name |
| 30 | WTHD_PAN_NUM | Character(15) | VARCHAR2(15) NOT NULL | PAN No. |
| 31 | WTHD_PAN_WARD | Character(30) | VARCHAR2(30) NOT NULL | PAN Ward |
| 32 | WTHD_RPT_ID | Character(10) | VARCHAR2(10) NOT NULL | Withholding Report ID |
| 33 | ACTIVE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Event Status
N=Inactive Y=Active |
| 34 | RPT_DT | Date(10) | DATE | Report Date |
| 35 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 36 | WTHD_CNTL_ID | Character(10) | VARCHAR2(10) NOT NULL | Control ID |
| 37 | Q1_ACK_NUM | Character(20) | VARCHAR2(20) NOT NULL | Field to store the acknowledgement number for first quarter |
| 38 | Q2_ACK_NUM | Character(20) | VARCHAR2(20) NOT NULL | Field to store the acknowledgement number for 2nd quarter |
| 39 | Q3_ACK_NUM | Character(20) | VARCHAR2(20) NOT NULL | Field to store acknowledgement number for third quarter |
| 40 | Q4_ACK_NUM | Character(20) | VARCHAR2(20) NOT NULL | Field to Store acknowledgement number for fourth quarter |
| 41 | Q1_TAX_DED | Signed Number(28,3) | DECIMAL(26,3) NOT NULL |
Field to store the TDS amount deducted in Quarter 1.
Default Value: 0 |
| 42 | Q1_TAX_DEP | Signed Number(28,3) | DECIMAL(26,3) NOT NULL |
Field to store the TDS amount deposited in Quarter 1.
Default Value: 0 |
| 43 | Q2_TAX_DED | Signed Number(28,3) | DECIMAL(26,3) NOT NULL |
Field to store the TDS amount deducted in Quarter 2.
Default Value: 0 |
| 44 | Q2_TAX_DEP | Signed Number(28,3) | DECIMAL(26,3) NOT NULL |
Field to store the TDS amount depositedin Quarter 2.
Default Value: 0 |
| 45 | Q3_TAX_DED | Signed Number(28,3) | DECIMAL(26,3) NOT NULL |
Field to store the TDS amount deducted in Quarter 3.
Default Value: 0 |
| 46 | Q3_TAX_DEP | Signed Number(28,3) | DECIMAL(26,3) NOT NULL |
Field to store the TDS amount deposited in Quarter 3.
Default Value: 0 |
| 47 | Q4_TAX_DED | Signed Number(28,3) | DECIMAL(26,3) NOT NULL |
Field to store the TDS amount deducted in Quarter 4.
Default Value: 0 |
| 48 | Q4_TAX_DEP | Signed Number(28,3) | DECIMAL(26,3) NOT NULL |
Field to store the TDS amount deposited in Quarter 4.
Default Value: 0 |
| 49 | GROSS_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL |
Base Gross Amount
Default Value: 0 |
| 50 | REMIT_SETID | Character(5) | VARCHAR2(5) NOT NULL | Remit SetID |
| 51 | REMIT_VENDOR | Character(10) | VARCHAR2(10) NOT NULL | Remit Vendor |
| 52 | REMIT_LOC | Character(10) | VARCHAR2(10) NOT NULL | Remit to Location |