BUS_UNIT_G_TEO2(SQL Table) |
Index Back |
|---|---|
CCU TEO temp tableCCU temporary table for BUS_UNIT_TBL_GL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EO_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | AS_OF_DATE | Date(10) | DATE | As of Date |
| 4 | 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. " |
| 5 | ELIMS_ONLY | Character(1) | VARCHAR2(1) NOT NULL | For Eliminations Only |
| 6 | JRNL_BALANCE_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Journal Balance Option
D=Default to Higher Level Value R=Recycle S=Suspend |
| 7 | JRNL_EDIT_ERR_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Journal Edit Errors Option
D=Default to Higher Level Value R=Recycle S=Suspend |
| 8 | JRNL_AMT_ERR_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
A Journal Edit option to decide if accept, error or suspense a journal line when foreign amount and monetary amount are different sign (i.e. one positive and the other negative).
A=Accept D=Default to Higher Level Value R=Recycle S=Suspend |
| 9 | JRNL_DT_ERR_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Journal Date < Open From Date
C=Change to Open From Date D=Default to Higher Level Value R=Recycle |
| 10 | JRNL_DT_ERR_OPTN2 | Character(1) | VARCHAR2(1) NOT NULL |
Journal Date > Open To Date
C=Change To Open To Date D=Default to Higher Level Value R=Recycle |
| 11 | ADJ_YEAR_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Adjustment Year Not Exist Option
O=Override R=Recycle |
| 12 | CONTROL_TOTAL_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Control Total Option
D=Default to Higher Level Value N=N/A R=Recycle |
| 13 | CURRENCY_BAL_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Currency Balancing Option
A=Balance by All Currencies B=Balance by Base Currency Only D=Default to Higher Level Value |
| 14 | EXCHANGE_RATE_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Translate Ledger Exchange Rate
D=Default to Higher Level Value N=Retain Exchange Rate Y=Inherit from Primary Ledger Default Value: Y |
| 15 | BASE_CUR_ADJ_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Base Currency Adjust Option
D=Default to Higher Level Value N=Disallow Base Curr Adjustments Y=Allow Base Curr Adjustments |
| 16 | JRNL_FOREIGN_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Foreign Currencies per Journal
D=Default to Higher Level Value M=Multiple Foreign Currencies N=No Foreign Currencies O=Only One Foreign Currency |
| 17 | ENABLE_UNPOST_DT | Character(1) | VARCHAR2(1) NOT NULL | Allow Different Unpost Date |
| 18 | JRNL_APPRVL_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Journal Approval Option
D=Default to Higher Level P=Pre-Approved S=Require Approval |
| 19 | BD_JRNL_APPR_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Budget Journal Approval Optn
D=Default to Higher Level P=Pre-Approved S=Require Approval |
| 20 | BUSPROCNAME | Character(30) | VARCHAR2(30) NOT NULL | Business Process Name (see PSBUSPROCDEFN). |
| 21 | APPR_RULE_SET | Character(30) | VARCHAR2(30) NOT NULL | Approval Rule Set |
| 22 | BUSPROCNAME_BD | Character(30) | VARCHAR2(30) NOT NULL | Business Process Name - Budget |
| 23 | APPR_RULE_SET_BD | Character(30) | VARCHAR2(30) NOT NULL | Approval Rule Set - Budgets |
| 24 | TR_RVL_RATE_INDEX | Character(10) | VARCHAR2(10) NOT NULL | The market rate index selected as applicable to mark-to-market revaluation events. |
| 25 | TR_RVL_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | The market rate type selected as applicable to mark-to-market revaluation events. |
| 26 | INT_ENTITYCD | Character(4) | VARCHAR2(4) NOT NULL | Represents the EDI Manager internal entity code associated with a given general ledger business un |
| 27 | EXT_ENTITYCD | Character(4) | VARCHAR2(4) NOT NULL | Represents the EDI Manager external entity code associated with a given general ledger business un |
| 28 | PYMNT_METHOD | Character(3) | VARCHAR2(3) NOT NULL |
Payment Method
ACH=Automated Clearing House BEF=Draft - Customer EFT BOO=Draft - Customer Initiated CHK=System Check D=Deposit DD=Direct Debit DFT=Draft - Supplier Initiated DRA=Draft EFT=Electronic Funds Transfer GE=Giro - EFT GM=Giro - Manual LC=Letter of Credit MAN=Manual Check TRW=Treasury Wire WIR=Wire Transfer |
| 29 | DOC_SEQ | Character(1) | VARCHAR2(1) NOT NULL | Enable Document Sequencing |
| 30 | DOC_TYPE | Character(8) | VARCHAR2(8) NOT NULL | Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code. |
| 31 | VAT_NRCVR_PRO_FLG | Character(1) | VARCHAR2(1) NOT NULL | Prorate Non-Recoverable VAT |
| 32 | VAT_NRCVR_ALL_FLG | Character(1) | VARCHAR2(1) NOT NULL | Allocate Non-Recoverable VAT |
| 33 | HOLIDAY_LIST_ID | Character(10) | VARCHAR2(10) NOT NULL | This is used to identify what holiday calendar to use. This is the access field for all financials groups. |
| 34 | POST_DATE_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Journal Process Date Option
C=Current Date P=Process Date |
| 35 | PROCESS_DATE | Date(10) | DATE | Process Date |
| 36 | IU_INTER_TMPLT_CD | Character(5) | VARCHAR2(5) NOT NULL | Key to the interunit template record. Assigned to a GLBU on the GL business unit table. |
| 37 | IU_INTRA_TMPLT_CD | Character(5) | VARCHAR2(5) NOT NULL | Key field for IntraUnit Template |
| 38 | IU_LEGAL_ENT_BU | Character(5) | VARCHAR2(5) NOT NULL | The business unit that represents the legal entity to which the GL Unit belongs. May have the same value as the GL Unit if it is its own legal entity. |
| 39 | BUSINESS_UNIT_AP | Character(5) | VARCHAR2(5) NOT NULL | AP Business Unit |
| 40 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL |
Vendor SetID
Prompt Table: SP_SETID_NONVW |
| 41 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 42 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 43 | BUSINESS_UNIT_BI | Character(5) | VARCHAR2(5) NOT NULL | Billing Business Unit |
| 44 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. |
| 45 | OPERATING_UNIT | Character(8) | VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table: OPER_UNIT_TBL |
| 46 | PRODUCT | Character(6) | VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table: PRODUCT_TBL |
| 47 | FUND_CODE | Character(5) | VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table: FUND_TBL |
| 48 | CLASS_FLD | Character(5) | VARCHAR2(5) NOT NULL |
Class Field
Prompt Table: CLASS_CF_TBL |
| 49 | PROGRAM_CODE | Character(5) | VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table: PROGRAM_TBL |
| 50 | BUDGET_REF | Character(8) | VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table: BUD_REF_TBL |
| 51 | AFFILIATE | Character(5) | VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table: AFFILIATE_VW |
| 52 | AFFILIATE_INTRA1 | Character(10) | VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table: %EDIT_INTRA01 |
| 53 | AFFILIATE_INTRA2 | Character(10) | VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table: %EDIT_INTRA02 |
| 54 | CHARTFIELD1 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table: CHARTFIELD1_TBL |
| 55 | CHARTFIELD2 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table: CHARTFIELD2_TBL |
| 56 | CHARTFIELD3 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table: CHARTFIELD3_TBL |
| 57 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 58 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 59 | CUST_VNDR_AFFILIAT | Character(1) | VARCHAR2(1) NOT NULL | Customer Vendor Affiliate |
| 60 | LED_GRP_DEFAULT | Character(10) | VARCHAR2(10) NOT NULL | Default Journal Generator Ledger Group of a Business Unit |
| 61 | PHYSICAL_NATURE | Character(1) | VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods S=Services Default Value: G |
| 62 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
| 63 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |
| 64 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |