PROD_M_EXS_TEO3(SQL Table) |
Index Back |
|---|---|
CCU TEO temp tableCCU temporary table for PROD_MASTER_EXS |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EO_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 3 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 4 | 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. |
| 5 | STX_APPL_FLG | Character(1) | VARCHAR2(1) NOT NULL | Sales Tax Applicability. |
| 6 | EXD_UOM | Character(3) | VARCHAR2(3) NOT NULL | Excise Unit Of Measure |
| 7 | EXD_TAX_ITEM_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Tax Item Type
C=Capital Goods F=Finished Goods R=Raw Material S=Service |
| 8 | 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 |
| 9 | 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 |
| 10 | EXD_CHAPTER_ID | Character(7) | VARCHAR2(7) NOT NULL | Excise Chapter ID |
| 11 | EXD_ASSESS_VALUE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Assessable Value |
| 12 | EXD_CONVERSION_RT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Conversion Rate |
| 13 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 14 | CUR_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Currency Rate Type |
| 15 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |