PO_LN_DIST_EXSA

(SQL Table)
Index Back

Excise/Sales PO Distributions

Excise/Sales PO Distributions

# 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

Default Value: PO_HDR.BUSINESS_UNIT

3 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
4 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
5 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
6 DST_ACCT_TYPE Character(4) VARCHAR2(4) NOT NULL 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment

Default Value: DST

7 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line

Default Value: 1

8 EXD_TAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Tax Amount
9 EXD_TAX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Duty in Base Currency
10 EXD_TAX_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Duty Amt In Rpt Curr
11 EXD_BASIS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Basis Amt
12 EXD_BASIS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Basis Amount - Base
13 EXD_BASIS_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Basis Amount
14 EXD_RCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Recovery Amount
15 EXD_RCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Recovery Amount
16 EXD_RCVRY_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Recovery Amount
17 EXD_NRCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise NonRcvry Amount
18 EXD_NRCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Non Recovery
19 EXD_NRCVRY_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Non-Recovery
20 STX_TAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Amount
21 STX_TAX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL SALES TAX IN BASE CURR
22 STX_TAX_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL SALES TAX IN REPORT CURR
23 STX_BASIS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Basis Amount
24 STX_BASIS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Basis Amt in Base Curr
25 STX_BASIS_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Basis Amt in Rpt Curr
26 STX_RCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Recovery Amount
27 STX_RCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Recovery Amt in Base Curr
28 STX_RCVRY_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Recovery Amt in Rpt Curr
29 STX_NRCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Nonrecovery
30 STX_NRCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Tx Amt NonRecovery in Bse Curr
31 STX_NRCVRY_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax NonRecovery
32 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
33 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
34 EXS_CURRENCY_RPTG Character(3) VARCHAR2(3) NOT NULL Excise Currency Reporting
35 CSD_TAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Custom Duty Tax Amount
36 CSD_TAX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Custom Duty Amount Base
37 CSD_RCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Custom Duty Recovery Amount
38 CSD_RCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Custom Duty Recovery Amount
39 CSD_NRCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Custom Duty NonRecovery Amount
40 CSD_NRCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Custom Duty NonRecovery Amount
41 EXS_TAX_AMT_TTL Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Tax Amount