BI_INSTALL_TEO2

(SQL Table)
Index Back

CCU TEO temp table

CCU temporary table for BI_INSTALL_SCHE

# 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

Prompt Table: SP_BU_BI_NONVW

3 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice

Prompt Table: BI_HDR

4 EVENT_OCCURRENCE Number(3,0) SMALLINT NOT NULL Identifies a user-defined event on a schedule for automatically creating standard and recurring journal entries. Event Occurrence is a number associated with a date for creation of the journal.

Default Value: 1

5 INSTALL_NBR Number(3,0) SMALLINT NOT NULL Installment Number
6 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
7 INSTALLMENT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Installment Amount
8 INSTALLMENT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Installment Amount
9 INSTALLMENT_XEU Signed Number(28,3) DECIMAL(26,3) NOT NULL Installment Amount
10 SERVICE_CHRG_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Service Charge Amount
11 SERVICE_CHRG_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Service Charge Amount
12 SERVICE_CHRG_XEU Signed Number(28,3) DECIMAL(26,3) NOT NULL Service Charge Amount
13 BI_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Billing Currency Code

Default Value: BI_HDR.BI_CURRENCY_CD

14 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. "

Default Value: BI_HDR.BASE_CURRENCY

15 CURRENCY_CD_XEU Character(3) VARCHAR2(3) NOT NULL Euro Currency

Default Value: BI_HDR.CURRENCY_CD_XEU

16 EVENT_DT Date(10) DATE The date upon which an accounting event is scheduled to be processed and converted into corresponding accounting
17 INVOICE_DT Date(10) DATE Invoice Date
18 BI_HDR_FROM_DT Date(10) DATE Bill Header From Date
19 BI_HDR_TO_DT Date(10) DATE Bill Header To Date
20 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
21 GENERATED_FLAG Character(1) VARCHAR2(1) NOT NULL Recurring Bill Generated Flag

Y/N Table Edit

Default Value: N

22 GENERATED_INVOICE Character(22) VARCHAR2(22) NOT NULL Generated Invoice

Default Value: NEXT

23 GENERATED_DATE Date(10) DATE Generated Date
24 CPY_STATUS Character(3) VARCHAR2(3) NOT NULL Copy Status
25 PRIOR_CPY_INVOICE Character(22) VARCHAR2(22) NOT NULL Prior Copy Invoice Id
26 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
27 ADD_DTTM DateTime(26) TIMESTAMP Date Time Added
28 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
29 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
30 EO_FROM_CURRENCY Character(3) VARCHAR2(3) NOT NULL Currency Code