ITEM_ACTTAX(SQL Table) |
Index Back |
|---|---|
Item Activity Tax |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. |
| 3 | ITEM |
Character(30) | VARCHAR2(30) NOT NULL | Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number. |
| 4 | ITEM_LINE |
Number(6,0) | INTEGER NOT NULL | Item Line |
| 5 | ITEM_SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Item Sequence Number |
| 6 | TAX_RATE_SEQ |
Number(3,0) | SMALLINT NOT NULL | Tax Rate Sequence |
| 7 | EXD_APPL_FLG | Character(1) | VARCHAR2(1) NOT NULL | Excise Applicablity Flag. This field is used to indicate the applicability of Excise duty with respect to a vendor, customer, item or product. It will have Yes or No values. |
| 8 | STX_APPL_FLG | Character(1) | VARCHAR2(1) NOT NULL | Sales Tax Applicability. |
| 9 | EXS_TAX_TXN_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Tax Transaction Type. This field will be used in the Tax determination and calculation of taxes.
DEB=Direct Export With Bond DEWB=Direct Export Without Bond DIMP=Direct Import DOM=Domestic LEB=Local Export With Bond LEWB=Local Export Without Bond LIMP=Local Import |
| 10 | STX_TAX_AUTH_RPT | Character(8) | VARCHAR2(8) NOT NULL | Reporting Authority (India Sales Tax) |
| 11 | STATE_SHIP_TO | Character(6) | VARCHAR2(6) NOT NULL | Ship To State |
| 12 | STATE_SHIP_FROM | Character(6) | VARCHAR2(6) NOT NULL | Ship From State |
| 13 | EXS_TXN_LINE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Transaction Line Amount |
| 14 | EXD_TAX_CATG_CD | Character(10) | VARCHAR2(10) NOT NULL | Excise Tax Category. This field is used to capture vendor, customer, item and product categories |
| 15 | STX_TAX_CATG_CD | Character(10) | VARCHAR2(10) NOT NULL | Sales Tax Category. This field is used to capture vendor, customer, item and product categories |
| 16 | EXD_TAX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Tax Amount |
| 17 | EXD_TAX_RATE_CD | Character(10) | VARCHAR2(10) NOT NULL | Excise Tax Calculation Code |
| 18 | EXD_TAX_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Duty in Base Currency |
| 19 | EXD_TAX_AMT_RPT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Duty Amt In Rpt Curr |
| 20 | STX_TAX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Sales Tax Amount |
| 21 | STX_TAX_RATE_CD | Character(10) | VARCHAR2(10) NOT NULL | Sales Tax Calculation Code |
| 22 | STX_TAX_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | SALES TAX IN BASE CURR |
| 23 | STX_TAX_AMT_RPT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | SALES TAX IN REPORT CURR |
| 24 | EXS_CURRENCY_RPTG | Character(3) | VARCHAR2(3) NOT NULL | Excise Currency Reporting |
| 25 | STX_FORM_CD | Character(8) | VARCHAR2(8) NOT NULL | Form Code |
| 26 | BU_APPL_FLG | Character(1) | VARCHAR2(1) NOT NULL | BU Aplicability Flag |
| 27 | SUM_TOT_EXD_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Excise Duty |
| 28 | SUM_TOT_EXD_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Excise Duty |
| 29 | SUM_TOT_STX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Sales Tax/VAT |
| 30 | SUM_TOT_STX_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Sales Tax/VAT |
| 31 | SUM_TOT_TAX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Sum of Total Amount |
| 32 | RATE_DIV_RPT | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Div Report |
| 33 | RATE_MULT_RPT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Mult Report |
| 34 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. |
| 35 | EXD_TAX_RATE_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Excise Tax Rate Source
1=System Defined 2=Manually Entered |
| 36 | STX_TAX_RATE_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Tax Rate Source
1=System Defined 2=Manually Entered |
| 37 | ORG_SETID | Character(5) | VARCHAR2(5) NOT NULL | Organization SetID. |
| 38 | ORG_CODE | Character(6) | VARCHAR2(6) NOT NULL | Organization Code. This will be unique to an Organization. |
| 39 | ORG_TAX_LOC_CD | Character(10) | VARCHAR2(10) NOT NULL | Tax Location Code. An Organization can have multiple Tax Location Codes. |
| 40 | EXS_TXC_LN_STATUS | Character(2) | VARCHAR2(2) NOT NULL | |
| 41 | EXD_UOM | Character(3) | VARCHAR2(3) NOT NULL | Excise Unit Of Measure |
| 42 | RATE_MULT_EXS | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Excise Rt Multiplier |
| 43 | RATE_DIV_EXS | Number(16,8) | DECIMAL(15,8) NOT NULL | Excise Rt Divider |
| 44 | COUNTRY_SHIP_FROM | Character(3) | VARCHAR2(3) NOT NULL | Specifies the country from which the invoice contents were shipped (for VAT processing only). |
| 45 | COUNTRY_SHIP_TO | Character(3) | VARCHAR2(3) NOT NULL | Specifies the country to which the invoice contents were shipped (for VAT processing only). |
| 46 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 47 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 48 | FORM_DISTRIB_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Used for Sales Tax Forms tracking
D=Distributed I=Ignore N=Not Distributed U=Undefined Default Value: N |