VAT_SUMMD_AP_WS(SQL Table) |
Index Back |
|---|---|
AP VAT Summary Work Scroll |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 3 | VOUCHER_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Voucher Line Number |
| 4 | DISTRIB_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 5 | VAT_BASIS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the amount on a sale (receivables item) or purchase (Payables voucher) transaction that is subject to VAT taxation. Depending on other parameters this amount may represent the gross or net amount of the transaction and may or may not include freight charges. |
| 6 | VAT_CALC_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Calculated Amount |
| 7 | VAT_INV_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Invoice Amount |
| 8 | VAT_RCVRY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Recovery Amt |
| 9 | VAT_REBATE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Rebate Amt |
| 10 | VAT_NRCVR_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Non Recoverable |
| 11 | VAT_RECOVERY_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | VAT Recovery Percent |
| 12 | VAT_REBATE_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | VAT Rebate Percent |