PC_BU_TBL_TEO3(SQL Table) |
Index Back |
|---|---|
CCU TEO temp tableCCU temporary table for BUS_UNIT_TBL_PC |
| # | 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 | LAST_INTFC_ID | Number(8,0) | INTEGER NOT NULL | Last Interface ID |
| 4 | LAST_CONT_NUM_PC | Number(8,0) | INTEGER NOT NULL | Last Contract Number PC |
| 5 | IN_USE_SW | Character(1) | VARCHAR2(1) NOT NULL | Table in use switch |
| 6 | CAT_EDIT_OPTION | Character(3) | VARCHAR2(3) NOT NULL |
Category Edit Option
IND=Independent OVR=Override REL=Related |
| 7 | SUB_EDIT_OPTION | Character(3) | VARCHAR2(3) NOT NULL |
SubCategory Edit Option
IND=Independent OVR=Override REL=Related |
| 8 | CATEGORY_EDIT | Character(15) | VARCHAR2(15) NOT NULL | Category Edit Table |
| 9 | SUBCATEGORY_EDIT | Character(15) | VARCHAR2(15) NOT NULL | SubCategory Edit Table |
| 10 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 11 | 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. |
| 12 | CUR_EFFDT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Currency Eff. Date Default
A=Accounting Date C=Current Date T=Transaction Date |
| 13 | CALENDAR_ID | Character(2) | VARCHAR2(2) NOT NULL | Calendar ID |
| 14 | FLEX_TEMPLATE_ID | Character(15) | VARCHAR2(15) NOT NULL | Flexible Analysis Template |
| 15 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 16 | UOM_HOURS | Character(3) | VARCHAR2(3) NOT NULL | The Unit of Measure that represents Hours. |
| 17 | DAYS_UOM | Character(3) | VARCHAR2(3) NOT NULL | the unit of measure for days |
| 18 | PC_RT_TYPE_TRN_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Indicator to determine which rate type to use in Multi-currency for transactions coming into Projects. Default will be the PCBU rate type.
P=Projects BU S=Source |
| 19 | CRIT_SEQ | Number(8,0) | INTEGER NOT NULL | Criteria Sequence |
| 20 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |