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 |