PO_LNSH_EXSD_FS

(SQL View)
 Index Back

India PO Schedule Tax Details

India Excise tax , Sales tax, and Customs Duty tax details for the purchase order schedule.

SELECT A.BUSINESS_UNIT , A.PO_ID , A.LINE_NBR , A.SCHED_NBR ,%subrec(EXS_TAX_DTL_SBR,A) ,%subrec(EXS_TXRTAMT_SBR,A) ,%subrec(EXS_TAX_AMT_SBR,A) ,%subrec(EXS_TAXC_DT_SBR,A) FROM PS_PO_LN_SHIP_EXSD A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
4 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number

Default Value: 1

5 EXS_TAX_TYPE Character(1) VARCHAR2(1) NOT NULL Tax Type
C=Custom Duty
E=Excise Duty
G=Goods and Services Tax
S=Sales Tax / VAT
6 EXS_TAX_RATE_SEQ Number(3,0) SMALLINT NOT NULL Tax Rate Sequence
7 EXS_TAX_CMPNT_CD Character(10) VARCHAR2(10) NOT NULL Tax Component Code
8 EXS_TAX_DEP_CD Character(10) VARCHAR2(10) NOT NULL Tax Dependency Code
9 EXS_CALC_SCHEME Character(1) VARCHAR2(1) NOT NULL Calculation Scheme
A=Amount
P=Percentage
Q=Quantity
10 EXS_TAX_RATE_PCT Number(8,4) DECIMAL(7,4) NOT NULL Tax Rate Percentage
11 EXS_TXRTAMT_TRC Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Rate Currency
12 EXS_CURRENCY_TRC Character(3) VARCHAR2(3) NOT NULL Curreny Tax Rate
13 EXS_TAX_RATE_UOM Character(3) VARCHAR2(3) NOT NULL Excise Unit Of Measure
14 EXS_RCVRY_PCT Number(8,4) DECIMAL(7,4) NOT NULL Tax Percentage
15 EXS_CALC_BASE_FLG Character(1) VARCHAR2(1) NOT NULL Calculation Base Flag
16 EXS_CALC_FRGHT_FLG Character(1) VARCHAR2(1) NOT NULL Calculation Freight Flag
17 EXS_CALC_MISC_FLG Character(1) VARCHAR2(1) NOT NULL Calculation Miscellaneous Flag
18 EXS_TAXRT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Rate Amount
19 EXS_TAXRT_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Rate Amount
20 EXS_TAXRT_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Rate Amount
21 EXS_TAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Sales Tax Amount
22 EXS_TAX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Sales Tax Amount Base Currency
23 EXS_TAX_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Sales Tax Amount Reporting Currency
24 EXS_BASIS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Sales Tax Basis Amount
25 EXS_BASIS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Sales Tax Basis Amount Base Currency
26 EXS_BASIS_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Sales Tax Basis Amount Reporting Currency
27 EXS_RCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Recovery Amount
28 EXS_RCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Recovery Amount
29 EXS_RCVRY_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL Reporting Recovery Amount
30 EXS_NRCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Non Recovery Amount
31 EXS_NRCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Non Base Recovery Amount
32 EXS_NRCVRY_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL Non Recovery Reporting Amount
33 EXS_CURRENCY_RPTG Character(3) VARCHAR2(3) NOT NULL Excise Currency Reporting
34 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
35 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
36 EXS_TAX_RATE_CD Character(10) VARCHAR2(10) NOT NULL Tax Rate Code
37 EXS_TXC_DTL_STATUS Character(2) VARCHAR2(2) NOT NULL