EXD_VND_INV_TAX(SQL Table) |
Index Back |
|---|---|
Excise Invoice Tax Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | EXD_DOC_NBR_SER |
Character(6) | VARCHAR2(6) NOT NULL |
Excise Document Number Series. Excise Document number series group will be created against each excise transaction type.
Prompt Table:
ORG_DOC_NBR_SER
|
| 3 | EXD_INVOICE_NO |
Character(10) | VARCHAR2(10) NOT NULL |
Excise Invoice Number
Default Value: NEXT |
| 4 | EXD_INVOICE_LINE |
Number(5,0) | INTEGER NOT NULL | Excise Invoice Line Number |
| 5 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 6 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |
| 7 | CURRENCY_CD_RPT | Character(3) | VARCHAR2(3) NOT NULL | Currency Code - Reporting |
| 8 | MISC_CHARGE_CODE | Character(10) | VARCHAR2(10) NOT NULL | 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement |
| 9 | 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 |
| 10 | EXS_TAX_RATE_SEQ |
Number(3,0) | SMALLINT NOT NULL | Tax Rate Sequence |
| 11 | EXS_TAX_CMPNT_CD | Character(10) | VARCHAR2(10) NOT NULL | Tax Component Code |
| 12 | EXS_TAX_DEP_CD | Character(10) | VARCHAR2(10) NOT NULL | Tax Dependency Code |
| 13 | EXS_CALC_SCHEME | Character(1) | VARCHAR2(1) NOT NULL |
Calculation Scheme
A=Amount P=Percentage Q=Quantity |
| 14 | EXS_TAX_RATE_PCT | Number(8,4) | DECIMAL(7,4) NOT NULL | Tax Rate Percentage |
| 15 | EXS_TXRTAMT_TRC | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Rate Currency |
| 16 | EXS_CURRENCY_TRC | Character(3) | VARCHAR2(3) NOT NULL | Curreny Tax Rate |
| 17 | EXS_TAX_RATE_UOM | Character(3) | VARCHAR2(3) NOT NULL | Excise Unit Of Measure |
| 18 | EXS_RCVRY_PCT | Number(8,4) | DECIMAL(7,4) NOT NULL | Tax Percentage |
| 19 | EXS_CALC_BASE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Calculation Base Flag |
| 20 | EXS_CALC_FRGHT_FLG | Character(1) | VARCHAR2(1) NOT NULL | Calculation Freight Flag |
| 21 | EXS_CALC_MISC_FLG | Character(1) | VARCHAR2(1) NOT NULL | Calculation Miscellaneous Flag |
| 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 |
| 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 | EXD_ASSESS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Assessable Amount - Transactio |
| 41 | EXD_ASSESS_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Assessable Value - Base |
| 42 | EXD_ASSESS_AMT_RPT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Assessable Value - Reporting |
| 43 | EXS_TAX_RATE_CD | Character(10) | VARCHAR2(10) NOT NULL | Tax Rate Code |
| 44 | EXS_TXC_DTL_STATUS | Character(2) | VARCHAR2(2) NOT NULL |