PROCESS_INSTANCEBUSINESS_UNITDefault Value: PO_HDR.BUSINESS_UNIT
PO_IDLINE_NBRSCHED_NBRDST_ACCT_TYPEDefault Value: DST
DISTRIB_LINE_NUMDefault Value: 1
PO_LN_DIST_EXSB(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 |