ITEM_B_EXS_TEO1

(SQL Table)
Index Back

CCU TEO temp table

CCU temporary table for ITEM_BU_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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item 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 CSD_APPL_FLG Character(1) VARCHAR2(1) NOT NULL Customs Duty applicable flag
16 CSD_TAX_CATG_CD Character(10) VARCHAR2(10) NOT NULL Custom Tax Category
17 EO_FROM_CURRENCY Character(3) VARCHAR2(3) NOT NULL Currency Code