VCHR_LN_EXS_D_C(SQL Table) |
Index Back |
|---|---|
BTF Vchr Line India Tax Dets- Voucher Line Tax Details : Excise Duty, Sales Tax and Custom Duty. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  TEST_CASE |
Character(30) | VARCHAR2(30) NOT NULL | BTF Test Case |
| 2 | COMPARE_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Compare report type
1=Delta (Results v.s Expected) 2=Expected data not in Results 3=Unexpected data in Results |
| 3 | COMPARE_SOURCE |
Character(1) | VARCHAR2(1) NOT NULL |
Compare data source (Actuals or Expected results).
A=Actuals E=Expected |
| 4 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 5 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 6 | VOUCHER_LINE_NUM |
Number(5,0) | INTEGER NOT NULL |
Voucher Line Number
Default Value: VOUCHER_LINE.VOUCHER_LINE_NUM |
| 7 | EXS_TAX_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Tax Type
C=Custom Duty E=Excise Duty G=Goods and Services Tax S=Sales Tax / VAT |
| 8 | EXS_TAX_RATE_SEQ |
Number(3,0) | SMALLINT NOT NULL | Tax Rate Sequence |
| 9 | EXS_TAX_CMPNT_CD | Character(10) | VARCHAR2(10) NOT NULL |
Tax Component Code
Prompt Table: %EDITTABLE |
| 10 | EXS_TAX_DEP_CD | Character(10) | VARCHAR2(10) NOT NULL | Tax Dependency Code |
| 11 | EXS_CALC_SCHEME | Character(1) | VARCHAR2(1) NOT NULL |
Calculation Scheme
A=Amount P=Percentage Q=Quantity |
| 12 | EXS_TAX_RATE_PCT | Number(8,4) | DECIMAL(7,4) NOT NULL | Tax Rate Percentage |
| 13 | EXS_TXRTAMT_TRC | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Rate Currency |
| 14 | EXS_CURRENCY_TRC | Character(3) | VARCHAR2(3) NOT NULL | Curreny Tax Rate |
| 15 | EXS_TAX_RATE_UOM | Character(3) | VARCHAR2(3) NOT NULL | Excise Unit Of Measure |
| 16 | EXS_RCVRY_PCT | Number(8,4) | DECIMAL(7,4) NOT NULL | Tax Percentage |
| 17 | EXS_CALC_BASE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Calculation Base Flag |
| 18 | EXS_CALC_FRGHT_FLG | Character(1) | VARCHAR2(1) NOT NULL | Calculation Freight Flag |
| 19 | EXS_CALC_MISC_FLG | Character(1) | VARCHAR2(1) NOT NULL | Calculation Miscellaneous Flag |
| 20 | EXS_TAX_RATE_CD | Character(10) | VARCHAR2(10) NOT NULL | Tax Rate Code |
| 21 | MISC_CHARGE_CODE | Character(10) | VARCHAR2(10) NOT NULL | 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement |
| 22 | EXS_TAX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Sales Tax Amount |
| 23 | EXS_TAX_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Sales Tax Amount Base Currency |
| 24 | EXS_TAX_AMT_RPT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Sales Tax Amount Reporting Currency |
| 25 | EXS_BASIS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Sales Tax Basis Amount |
| 26 | EXS_BASIS_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Sales Tax Basis Amount Base Currency |
| 27 | EXS_BASIS_AMT_RPT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Sales Tax Basis Amount Reporting Currency |
| 28 | EXS_RCVRY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Recovery Amount |
| 29 | EXS_RCVRY_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Recovery Amount |
| 30 | EXS_RCVRY_AMT_RPT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Reporting Recovery Amount |
| 31 | EXS_NRCVRY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Non Recovery Amount |
| 32 | EXS_NRCVRY_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Non Base Recovery Amount |
| 33 | EXS_NRCVRY_AMT_RPT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Non Recovery Reporting Amount |
| 34 | EXS_CURRENCY_RPTG | Character(3) | VARCHAR2(3) NOT NULL | Excise Currency Reporting |
| 35 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Transaction Currency
Prompt Table: CURR_TXN_VW |
| 36 | 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. " |
| 37 | EXS_TAXRT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Rate Amount |
| 38 | EXS_TAXRT_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Rate Amount |
| 39 | EXS_TAXRT_AMT_RPT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Rate Amount |
| 40 | LC_COMP_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
Y/N Table Edit Default Value: N |
| 41 | DST_ACCT_TYPE | Character(4) | VARCHAR2(4) NOT NULL | 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment |
| 42 | LC_EXTRCT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Landed Cost Extract Status
Y/N Table Edit Default Value: N |