| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 VAT_CALC_TXN_ID |
Character(22) |
VARCHAR2(22) NOT NULL |
VAT Calculation Transaction ID
|
| 2 |
VAT_AMT_RVC |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Reverse Charge VAT Amount
|
| 3 |
VAT_AMT_RVC_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Reverse Charge Amount in Base Currency
|
| 4 |
VAT_CALC_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
VAT Calculation Line Number
|
| 5 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
|
| 6 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
|
| 7 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 8 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 9 |
TAX_CD_VAT |
Character(8) |
VARCHAR2(8) NOT NULL |
Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.
|
| 10 |
VAT_RECOVERY_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
VAT Recovery Percent
|
| 11 |
VAT_REBATE_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
VAT Rebate Percent
|
| 12 |
VAT_CALC_LINE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Calculation Line Amount
|
| 13 |
DSCNT_PCT |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Discount Percentage
|
| 14 |
FREIGHT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Freight Amount
|
| 15 |
MISC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Misc. Amount
|
| 16 |
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.
|
| 17 |
VAT_BASIS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Basis Amt in Base Curr
|
| 18 |
VAT_TRANS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Represents the sale or purchase amount against which the VAT is applicable.
|
| 19 |
VAT_TRANS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Represents the sale or purchase amount in base currency against which the VAT is applicable
|
| 20 |
VAT_CALC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Calculated Amount
|
| 21 |
VAT_CALC_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Calculated Amount Base Cur
|
| 22 |
VAT_RCVRY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Recovery Amt
|
| 23 |
VAT_RCVRY_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Recovery Amt in Base Curr
|
| 24 |
VAT_REBATE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Rebate Amt
|
| 25 |
VAT_REBATE_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Rebate Amt in Base Curr
|
| 26 |
VAT_DSCNT_ADJ |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Dscnt Adj
|
| 27 |
VAT_DSCNT_ADJ_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Discount Adjust Base Curr
|
| 28 |
VAT_DSCNT_RCVRY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Dscnt Adj Rcvr
|
| 29 |
VAT_DSCNT_RCVR_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Discnt Recovery Base Curr
|
| 30 |
TAX_CD_VAT_PCT |
Signed Number(9,4) |
DECIMAL(7,4) NOT NULL |
Specifies the tax percentage that corresponds to the VAT code. If more than one VAT authority is linked to a VAT code this will represent an aggregate percentage.
|
| 31 |
DSCNT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount Amount
|
| 32 |
VAT_NRCVR_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Non Recoverable
|
| 33 |
VAT_NRCVR_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT NonRecoverable Amount
|
| 34 |
VAT_CALC_AMT_TMP |
Signed Number(30,5) |
DECIMAL(28,5) NOT NULL |
VAT Calculated Amount Temp
|
| 35 |
VAT_RCVRY_AMT_TMP |
Signed Number(30,5) |
DECIMAL(28,5) NOT NULL |
VAT Recovery Amount Temp
|
| 36 |
TAX_CD_VAT_RVC |
Character(8) |
VARCHAR2(8) NOT NULL |
Reverse Charge VAT Code
|
| 37 |
TAX_CD_VAT_RVC_PCT |
Signed Number(9,4) |
DECIMAL(7,4) NOT NULL |
Customer VAT Rate
|
| 38 |
VAT_RVRSE_CHG_GDS |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Reverse Charge goods flag
|