PeopleSoft 9.0 Cash Management |
Table Name | VAT_CALC_WS |
Table Description |
VAT_CALC_WS |
Columns |
Name | Datatype | Is PK | Is FK |
VAT_CALC_TXN_ID | char(22) | Yes | No |
VAT_CALC_LINE_NUM | int | Yes | No |
TXN_CURRENCY_CD | char(3) | No | No |
BASE_CURRENCY | char(3) | No | No |
RATE_MULT | decimal(15,8) | No | No |
RATE_DIV | decimal(15,8) | No | No |
TAX_CD_VAT | char(8) | No | No |
VAT_RECOVERY_PCT | decimal(5,2) | No | No |
VAT_REBATE_PCT | decimal(5,2) | No | No |
VAT_CALC_LINE_AMT | decimal(26,3) | No | No |
DSCNT_PCT | decimal(6,3) | No | No |
FREIGHT_AMT | decimal(26,3) | No | No |
MISC_AMT | decimal(26,3) | No | No |
VAT_BASIS_AMT | decimal(26,3) | No | No |
VAT_BASIS_AMT_BSE | decimal(26,3) | No | No |
VAT_TRANS_AMT | decimal(26,3) | No | No |
VAT_TRANS_AMT_BSE | decimal(26,3) | No | No |
VAT_CALC_AMT | decimal(26,3) | No | No |
VAT_CALC_AMT_BSE | decimal(26,3) | No | No |
VAT_RCVRY_AMT | decimal(26,3) | No | No |
VAT_RCVRY_AMT_BSE | decimal(26,3) | No | No |
VAT_REBATE_AMT | decimal(26,3) | No | No |
VAT_REBATE_AMT_BSE | decimal(26,3) | No | No |
VAT_DSCNT_ADJ | decimal(26,3) | No | No |
VAT_DSCNT_ADJ_BSE | decimal(26,3) | No | No |
VAT_DSCNT_RCVRY | decimal(26,3) | No | No |
VAT_DSCNT_RCVR_BSE | decimal(26,3) | No | No |
TAX_CD_VAT_PCT | decimal(7,4) | No | No |
DSCNT_AMT | decimal(26,3) | No | No |
VAT_NRCVR_AMT | decimal(26,3) | No | No |
VAT_NRCVR_AMT_BSE | decimal(26,3) | No | No |
VAT_CALC_AMT_TMP | decimal(28,5) | No | No |
VAT_RCVRY_AMT_TMP | decimal(28,5) | No | No |
Index |
Name | Type | Unique | Member |
PS_VAT_CALC_WS | PK | Yes |
![]() |
Member(s) of "PS_VAT_CALC_WS" Index |
VAT_CALC_TXN_ID |
VAT_CALC_LINE_NUM |
Published April 30, 2007 |