EXS_POB_TMP_SH

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
4	PO_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Purchase Order Line Number
5	PO_SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	PO Schedule Number
6	ORG_BU_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Business Unit Type. This field will have six translate values representing the various BUs AP=Payables AR=Receivables BI=Billing IN=Inventory OM=Order Management PO=Purchasing
7	BUSINESS_UNIT_EXS	Character(5)	VARCHAR2(5) NOT NULL	Excise Business Unit
8	ORG_SETID	Character(5)	VARCHAR2(5) NOT NULL	Organization SetID.
9	ORG_CODE	Character(6)	VARCHAR2(6) NOT NULL	Organization Code. This will be unique to an Organization.
10	ORG_TAX_LOC_CD	Character(10)	VARCHAR2(10) NOT NULL	Tax Location Code. An Organization can have multiple Tax Location Codes.
11	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
12	EXS_UOM_STD	Character(3)	VARCHAR2(3) NOT NULL	Standard Unit of Measure
13	EXS_QTY_STD	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity Standard
14	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.
15	EXD_TAX_ITEM_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Tax Item Type C=Capital Goods F=Finished Goods R=Raw Material S=Service
16	EXD_ITM_CATG_CD	Character(10)	VARCHAR2(10) NOT NULL	Excise Item Category Code
17	EXD_TAX_RATE_CD	Character(10)	VARCHAR2(10) NOT NULL	Excise Tax Calculation Code
18	EXD_USE_AV_FLG	Character(1)	VARCHAR2(1) NOT NULL	Excise Use Av Flag Y/N Table Edit Default Value: N
19	EXD_UOM	Character(3)	VARCHAR2(3) NOT NULL	Excise Unit Of Measure
20	EXD_CONVERSION_RT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Conversion Rate
21	EXD_ASSESS_VALUE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Excise Assessable Value
22	EXD_ASSESS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Assessable Amount - Transactio
23	EXD_ASSESS_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Assessable Value - Base
24	EXD_ASSESS_AMT_RPT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Assessable Value - Reporting
25	STX_APPL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Sales Tax Applicability.
26	STX_ITM_CATG_CD	Character(10)	VARCHAR2(10) NOT NULL	Sales Item Category Code
27	STX_TAX_RATE_CD	Character(10)	VARCHAR2(10) NOT NULL	Sales Tax Calculation Code
28	STX_TAX_AUTH_RATE	Character(8)	VARCHAR2(8) NOT NULL	Tax Authority Rate (India Sales Tax)
29	STX_TAX_AUTH_RPT	Character(8)	VARCHAR2(8) NOT NULL	Reporting Authority (India Sales Tax)
30	STX_FORM_CD	Character(8)	VARCHAR2(8) NOT NULL	Form Code
31	COUNTRY_SHIP_TO	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country to which the invoice contents were shipped (for VAT processing only). Prompt Table: COUNTRY_TBL
32	COUNTRY_SHIP_FROM	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country from which the invoice contents were shipped (for VAT processing only). Prompt Table: COUNTRY_TBL
33	STATE_SHIP_TO	Character(6)	VARCHAR2(6) NOT NULL	Ship To State
34	STATE_SHIP_FROM	Character(6)	VARCHAR2(6) NOT NULL	Ship From State
35	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
36	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
37	EXS_CURRENCY_RPTG	Character(3)	VARCHAR2(3) NOT NULL	Excise Currency Reporting
38	EXS_SERV_TAX_FLG	Character(1)	VARCHAR2(1) NOT NULL	Service Tax Indicator N=Not Service Tax Y=Service Tax