SHEETDIST1_TEO3(SQL Table) |
Index Back |
|---|---|
CCU TEO temp tableCCU temporary table for EX_SHEET_DIST |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EO_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | SHEET_ID | Character(10) | VARCHAR2(10) NOT NULL | Report ID |
| 3 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 4 | DISTRIB_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 5 | 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 |
| 6 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 7 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL | Account |
| 8 | ALTACCT | Character(10) | VARCHAR2(10) NOT NULL | Alternate Account |
| 9 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 10 | OPERATING_UNIT | Character(8) | VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table: OPERUNT_BUGL_VW |
| 11 | PRODUCT | Character(6) | VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table: PRODUCT_BUGL_VW |
| 12 | FUND_CODE | Character(5) | VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table: FUND_BUGL_VW |
| 13 | CLASS_FLD | Character(5) | VARCHAR2(5) NOT NULL |
Class Field
Prompt Table: CLASSCF_BUGL_VW |
| 14 | PROGRAM_CODE | Character(5) | VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table: PROGRAM_BUGL_VW |
| 15 | BUDGET_REF | Character(8) | VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table: BUD_REF_BUGL_VW |
| 16 | AFFILIATE | Character(5) | VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table: AFFILIATE_VW |
| 17 | AFFILIATE_INTRA1 | Character(10) | VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table: %EDIT_INTRA01 |
| 18 | AFFILIATE_INTRA2 | Character(10) | VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table: %EDIT_INTRA02 |
| 19 | CHARTFIELD1 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table: CF1_BUGL_VW |
| 20 | CHARTFIELD2 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table: CF2_BUGL_VW |
| 21 | CHARTFIELD3 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table: CF3_BUGL_VW |
| 22 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 23 | MONETARY_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account. |
| 24 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 25 | TXN_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Transaction Amount |
| 26 | TXN_AMOUNT_LINE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Transaction Amount |
| 27 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
| 28 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 29 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 30 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. |
| 31 | GL_DISTRIB_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Distribution Status
C=Available to Contracts D=Distributed G=Generated H=Hold I=Ignored J=Creating Journals M=Modified N=None P=To be processed X=Waiting for Reversal |
| 32 | BI_DISTRIB_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Billing Distribution Status
D=Distributed I=Ignore N=Not Distributed P=Priced U=Unbillable/Non-billable W=Billing Worksheet |
| 33 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 34 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 35 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | Category |
| 36 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Source Type |
| 37 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL | Subcategory |
| 38 | ANALYSIS_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Analysis Type |
| 39 | VAT_BASIS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the amount on a sale (receivables item) or purchase (Payables voucher) transaction that is subject to VAT taxation. Depending on other parameters this amount may represent the gross or net amount of the transaction and may or may not include freight charges. |
| 40 | VAT_BASIS_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Basis Amt in Base Curr |
| 41 | VAT_CALC_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Calculated Amount |
| 42 | VAT_CALC_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Calculated Amount Base Cur |
| 43 | VAT_RCVRY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Recovery Amt |
| 44 | VAT_RCVRY_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Recovery Amt in Base Curr |
| 45 | VAT_REBATE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Rebate Amt |
| 46 | VAT_REBATE_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Rebate Amt in Base Curr |
| 47 | VAT_TRANS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents the sale or purchase amount against which the VAT is applicable. |
| 48 | VAT_TRANS_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents the sale or purchase amount in base currency against which the VAT is applicable |
| 49 | VAT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. In PeopleSoft Receivables this field is populated when the VAT declaration point is set to Invoice. |
| 50 | VAT_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Amount in Base Curr |
| 51 | VAT_RCLM_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Reclaim Amount |
| 52 | VAT_RCLM_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base VAT Reclaim Amount |
| 53 | TXN_CURRENCY_CD1 | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency Display |
| 54 | CURRENCY_CD1 | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 55 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 56 | BUDGET_DT | Date(10) | DATE | Budget Date |
| 57 | BUDGET_LINE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
->
SL - 15-AUG-2002
MISC_CRITERIA label has been added
<-
B=Bypass E=Error N=Not Chk'd V=Valid W=Warning |
| 58 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 59 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 60 | KK_PROCESS_PRIOR | Character(1) | VARCHAR2(1) NOT NULL | Process Prior Document |
| 61 | KK_CLOSE_PRIOR | Character(1) | VARCHAR2(1) NOT NULL | Close Prior Transaction |
| 62 | TRAVEL_AUTH_ID | Character(10) | VARCHAR2(10) NOT NULL | Travel Authorization Identification. Number used to define travel authorizations. Key field on most travel authorization records and exists at level 0 for travel authorization panels. |
| 63 | VAT_APORT_CNTRL | Character(1) | VARCHAR2(1) NOT NULL |
VAT Apportionment Control
D=Distribution GL Business Unit G=Transaction GL Business Unit T=Transaction Business Unit |
| 64 | VAT_AMT_GL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Amount in GL Business Unit |
| 65 | VAT_RCVRY_AMT_GL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Recovery Amt Base Sum |
| 66 | VAT_REBATE_AMT_GL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Rebate Amt Base Sum |
| 67 | VAT_TRANS_AMT_GL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents the sale or purchase amount against which the VAT is applicable. |
| 68 | VAT_RCVRY_PCT_SRC | Character(1) | VARCHAR2(1) NOT NULL |
VAT Recovery Percent Source
A=Automatically calculated M=Manual Entry |
| 69 | VAT_REBATE_PCT_SRC | Character(1) | VARCHAR2(1) NOT NULL |
VAT Rebate Percent Source
A=Automatically calculated M=Manual Entry |
| 70 | VAT_RECOVERY_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | VAT Recovery Percent |
| 71 | VAT_REBATE_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | VAT Rebate Percent |
| 72 | VAT_RECLAIM_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | VAT Reclaim Percent |
| 73 | VAT_DFLT_DONE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
VAT Defaulting Done
N=Awaiting Defaulting X=Do not default Y=Defaulting Done |
| 74 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |