TDS_QRETURN_TAO(SQL Table) |
Index Back |
|---|---|
TDS Quarterly Return TempTDS Quarterly Return Temp |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | WTHD_ENTITY | Character(5) | VARCHAR2(5) NOT NULL | Withholding Entity |
| 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 | WTHD_CLASS | Character(5) | VARCHAR2(5) NOT NULL | Withholding Class |
| 8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 9 | WTHD_RULE | Character(5) | VARCHAR2(5) NOT NULL | Withholding Rule |
| 10 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 11 | WTHD_CONT_REF | Character(15) | VARCHAR2(15) NOT NULL | Contract Reference |
| 12 | PYMNT_CNT | Number(5,0) | INTEGER NOT NULL | Payments |
| 13 | TDS_QRETURN_NUM | Character(25) | VARCHAR2(25) NOT NULL | TDS Quarterly Return No |
| 14 | CALENDAR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Calendar SetID |
| 15 | CALENDAR_ID | Character(2) | VARCHAR2(2) NOT NULL | Calendar ID |
| 16 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 17 | PERIOD | Number(3,0) | SMALLINT NOT NULL | Period |
| 18 | FROM_DT | Date(10) | DATE | From Date |
| 19 | THRU_DATE | Date(10) | DATE | Through Date |
| 20 | INVOICE_ID | Character(30) | VARCHAR2(30) NOT NULL | Invoice Number |
| 21 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 22 | GROSS_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Gross Amount |
| 23 | PAY_AMT_BASE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Payment Amt - Base Curr |
| 24 | WTHD_BASIS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Basis Amount |
| 25 | WTHD_LIABILITY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Liability Amount |
| 26 | WTHD_SURCHRG_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withhold Surcharge Amount |
| 27 | ADDL_SRCHRG_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Additional Surcharge Amount |
| 28 | LATE_CHRG_PAID_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Late Charge Paid Base |
| 29 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 30 | PAID_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Paid Amount |
| 31 | PYMNT_ID | Character(10) | VARCHAR2(10) NOT NULL | Payment Number |
| 32 | PYMNT_DT | Date(10) | DATE | Payment Date |
| 33 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID associated with a given bank/counterparty. |
| 34 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 35 | BANK_ACCT_KEY | Character(4) | VARCHAR2(4) NOT NULL | A user defined unique identifier that facilitates the identification of a given account with a given bank |
| 36 | CHALLAN_IDENT_NO | Character(18) | VARCHAR2(18) NOT NULL | TDS Challan Identification Number |
| 37 | TDS_CREDIT_DATE | Date(10) | DATE | TDS Credit Date |
| 38 | PYMNT_METHOD | Character(3) | VARCHAR2(3) NOT NULL |
Payment Method
ACH=Automated Clearing House BEF=Draft - Customer EFT BOO=Draft - Customer Initiated CHK=System Check D=Deposit DD=Direct Debit DFT=Draft - Supplier Initiated DRA=Draft EFT=Electronic Funds Transfer GE=Giro - EFT GM=Giro - Manual LC=Letter of Credit MAN=Manual Check TRW=Treasury Wire WIR=Wire Transfer |
| 39 | WTHD_CESS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Field to hold the amount value for Wihtholding Cess amount |