PO_LN_DIST_EXSA(SQL Table) |
Index Back |
---|---|
Excise/Sales PO DistributionsExcise/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 |