PeopleSoft 9.0 Cash Management |
Table Name | VAT_CALCS_WS |
Table Description |
VAT_CALCS_WS |
Columns |
Name | Datatype | Is PK | Is FK |
VAT_CALC_TXN_ID | char(22) | Yes | Yes |
VAT_CALC_LINE_NUM | int | Yes | Yes |
VAT_CALC_SCHED_NUM | int | Yes | No |
EMPLID | char(11) | Yes | No |
CREDIT_CARD_VENDOR | char(5) | Yes | No |
CRDMEM_ACCT_NBR | CHAR(44) | Yes | No |
TRANS_NBR | char(24) | Yes | No |
SEQUENCENO | int | Yes | No |
TRANS_DT | datetime | Yes | No |
DTTM_STAMP | PSDATETIME | Yes | No |
VAT_CALC_DISTRIB | 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_CALCS_WS | PK | Yes |
![]() |
Member(s) of "PS_VAT_CALCS_WS" Index |
VAT_CALC_TXN_ID |
VAT_CALC_LINE_NUM |
VAT_CALC_SCHED_NUM |
EMPLID |
CREDIT_CARD_VENDOR |
CRDMEM_ACCT_NBR |
TRANS_NBR |
SEQUENCENO |
TRANS_DT |
DTTM_STAMP |
VAT_CALC_DISTRIB |
Published April 30, 2007 |