PeopleSoft 9.0 Cash Management |
Table Name | VAT_CALC_TSTDST |
Table Description |
VAT_CALC_TSTDST |
Columns |
Name | Datatype | Is PK | Is FK |
BUSINESS_UNIT | char(5) | Yes | Yes |
VOUCHER_ID | char(8) | Yes | Yes |
VOUCHER_LINE_NUM | int | Yes | Yes |
DISTRIB_LINE_NUM | int | Yes | 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 |
MERCHANDISE_AMT | decimal(26,3) | No | No |
DSCNT_AMT | decimal(26,3) | No | No |
FREIGHT_AMT | decimal(26,3) | No | No |
TAX_CD_VAT_PCT | decimal(7,4) | No | No |
VAT_BASIS_AMT | decimal(26,3) | No | No |
VAT_BASIS_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_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 |
VAT_REBATE_AMT | decimal(26,3) | No | No |
VAT_REBATE_AMT_BSE | decimal(26,3) | No | No |
BASE_CURRENCY | char(3) | No | No |
RATE_MULT | decimal(15,8) | No | No |
RATE_DIV | decimal(15,8) | No | No |
Index |
Name | Type | Unique | Member |
PS_VAT_CALC_TSTDST | PK | Yes |
![]() |
Member(s) of "PS_VAT_CALC_TSTDST" Index |
BUSINESS_UNIT |
VOUCHER_ID |
VOUCHER_LINE_NUM |
DISTRIB_LINE_NUM |
Published April 30, 2007 |