VAT_CALC_TXN_IDVAT_CALC_LINE_NUMVAT_CALC_SCHED_NUMEMPLIDPrompt Table: PERSONAL_DATA
CREDIT_CARD_VENDORCRDMEM_ACCT_NBRTRANS_NBRSEQUENCENOTRANS_DTDTTM_STAMPDefault Value: %DATE
VAT_CALC_DISTRIBVAT_CALCS_WS(SQL Table) |
Index Back |
|---|---|
VAT Calculation Work Scroll |
| # | 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_CALC_LINE_NUM |
Number(5,0) | INTEGER NOT NULL | VAT Calculation Line Number |
| 3 | VAT_CALC_SCHED_NUM |
Number(6,0) | INTEGER NOT NULL | Schedule Number |
| 4 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSONAL_DATA |
| 5 | CREDIT_CARD_VENDOR |
Character(5) | VARCHAR2(5) NOT NULL | Corporate Card Vendor |
| 6 | CRDMEM_ACCT_NBR |
Character(44) | VARCHAR2(44) NOT NULL | Cardmember Number |
| 7 | TRANS_NBR |
Character(24) | VARCHAR2(24) NOT NULL | Transaction Number |
| 8 | SEQUENCENO |
Number(10,0) | DECIMAL(10) NOT NULL | Sequence Number |
| 9 | TRANS_DT |
Date(10) | DATE NOT NULL | Transaction Date |
| 10 | DTTM_STAMP |
DateTime(26) | TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
Default Value: %DATE |
| 11 | VAT_CALC_DISTRIB |
Number(5,0) | INTEGER NOT NULL | VAT Distribution Line |
| 12 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
| 13 | 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. " |
| 14 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 15 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 16 | 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. |
| 17 | VAT_RECOVERY_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | VAT Recovery Percent |
| 18 | VAT_REBATE_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | VAT Rebate Percent |
| 19 | VAT_CALC_LINE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Calculation Line Amount |
| 20 | DSCNT_PCT | Number(7,3) | DECIMAL(6,3) NOT NULL | Discount Percentage |
| 21 | FREIGHT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Freight Amount |
| 22 | MISC_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Misc. Amount |
| 23 | 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. |
| 24 | VAT_BASIS_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Basis Amt in Base Curr |
| 25 | VAT_TRANS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents the sale or purchase amount against which the VAT is applicable. |
| 26 | 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 |
| 27 | VAT_CALC_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Calculated Amount |
| 28 | VAT_CALC_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Calculated Amount Base Cur |
| 29 | VAT_RCVRY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Recovery Amt |
| 30 | VAT_RCVRY_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Recovery Amt in Base Curr |
| 31 | VAT_REBATE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Rebate Amt |
| 32 | VAT_REBATE_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Rebate Amt in Base Curr |
| 33 | VAT_DSCNT_ADJ | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Dscnt Adj |
| 34 | VAT_DSCNT_ADJ_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Discount Adjust Base Curr |
| 35 | VAT_DSCNT_RCVRY | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Dscnt Adj Rcvr |
| 36 | VAT_DSCNT_RCVR_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Discnt Recovery Base Curr |
| 37 | 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. |
| 38 | DSCNT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Discount Amount |
| 39 | VAT_NRCVR_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Non Recoverable |
| 40 | VAT_NRCVR_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT NonRecoverable Amount |
| 41 | VAT_CALC_AMT_TMP | Signed Number(30,5) | DECIMAL(28,5) NOT NULL | VAT Calculated Amount Temp |
| 42 | VAT_RCVRY_AMT_TMP | Signed Number(30,5) | DECIMAL(28,5) NOT NULL | VAT Recovery Amount Temp |