EXS_POB_TMP_DWK

(SQL Table)
Index Back

PO_CMBLDDST Excise&Sales

# 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
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 DISTRIB_PCT Number(8,4) DECIMAL(7,4) NOT NULL Distribution Percentage
9 BAL_STATUS Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not the control totals for a deposit match the entered totals. A deposit is considered "balanced" when the two sets of totals are equal.
I=Balanced
O=Not Balanced

Default Value: I

10 EXS_CURRENCY_RPTG Character(3) VARCHAR2(3) NOT NULL Excise Currency Reporting
11 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
12 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. "
13 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
14 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
15 EXD_TAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Tax Amount
16 EXD_TAX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Duty in Base Currency
17 EXD_TAX_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Duty Amt In Rpt Curr
18 EXD_BASIS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Basis Amt
19 EXD_BASIS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Basis Amount - Base
20 EXD_BASIS_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Basis Amount
21 EXD_RCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Recovery Amount
22 EXD_RCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Recovery Amount
23 EXD_RCVRY_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Recovery Amount
24 EXD_NRCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise NonRcvry Amount
25 EXD_NRCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Non Recovery
26 EXD_NRCVRY_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Non-Recovery
27 STX_TAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Amount
28 STX_TAX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL SALES TAX IN BASE CURR
29 STX_TAX_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL SALES TAX IN REPORT CURR
30 STX_BASIS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Basis Amount
31 STX_BASIS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Basis Amt in Base Curr
32 STX_BASIS_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Basis Amt in Rpt Curr
33 STX_RCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Recovery Amount
34 STX_RCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Recovery Amt in Base Curr
35 STX_RCVRY_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Recovery Amt in Rpt Curr
36 STX_NRCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Nonrecovery
37 STX_NRCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Tx Amt NonRecovery in Bse Curr
38 STX_NRCVRY_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax NonRecovery
39 CSD_TAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Custom Duty Tax Amount
40 CSD_TAX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Custom Duty Amount Base
41 CSD_RCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Custom Duty Recovery Amount
42 CSD_RCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Custom Duty Recovery Amount
43 CSD_RCVRY_AMT_NP Signed Number(28,3) DECIMAL(26,3) NOT NULL Custom Duty Recvery NonProrate
44 CSD_RCVRY_NP_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Custom Duty Recovery Amount
45 CSD_NRCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Custom Duty NonRecovery Amount
46 CSD_NRCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Custom Duty NonRecovery Amount
47 CSD_NRCVRY_AMT_NP Signed Number(28,3) DECIMAL(26,3) NOT NULL Custom Duty NRcvry NonProrate
48 CSD_NRCVRY_NP_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Custom Duty NRcvry NP Base