OI_TAX_HDR_VW

(SQL View)
 Index Back

Tax Header

OTBI Tax Header View

SELECT A.SETID , A.TAX_CD , A.DESCR , A.DESCRSHORT , A.TAX_VAT_FLG , A.TAX_FRGHT_FLG , A.TAX_DSCNT_FLG , A.TAX_MISC_FLG , XLI1.DESCR DESCR1 , A.DISTRIB_LINE_NUM FROM %Table(TAX_HEADER_TBL) A LEFT OUTER JOIN PS_OI_COMMON_VW XLI1 ON XLI1.CODESETNAME = A.TAX_CD_TYPE AND XLI1.CODESETGROUPNAME ='TAX_CD_TYPE' UNION SELECT B.SETID , ' ' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , 0 FROM %Table(SETID_TBL) B UNION SELECT ' ' , ' ' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , 0 FROM %Table(INSTALLATION) C

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 TAX_CD Character(8) VARCHAR2(8) NOT NULL Tax Code
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
5 TAX_VAT_FLG Character(1) VARCHAR2(1) NOT NULL Include VAT
N=No
Y=Yes
6 TAX_FRGHT_FLG Character(1) VARCHAR2(1) NOT NULL Include Freight
7 TAX_DSCNT_FLG Character(1) VARCHAR2(1) NOT NULL Include Discount
8 TAX_MISC_FLG Character(1) VARCHAR2(1) NOT NULL Include Misc Charges
9 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
10 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line