BUSINESS_UNITA=Active
I=Inactive
Default Value: A
BUS_UNIT_TBL_HR(SQL Table) |
Index Back |
|---|---|
HR Business Unit TableHuman Resources Business Unit Setup |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | ACTIVE_INACTIVE | Character(1) | VARCHAR2(1) NOT NULL |
Definition Active or Inactive?
A=Active I=Inactive Default Value: A |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 5 | BUSINESS_UNIT_DUP | Character(5) | VARCHAR2(5) NOT NULL | Clone from Business Unit |
| 6 | DEFAULT_SETID | Character(5) | VARCHAR2(5) NOT NULL | Default SetID |
| 7 | BUSINESS_UNIT_AM | Character(5) | VARCHAR2(5) NOT NULL | AM Business Unit |
| 8 | BUSINESS_UNIT_AP | Character(5) | VARCHAR2(5) NOT NULL | AP Business Unit |
| 9 | BUSINESS_UNIT_AR | Character(5) | VARCHAR2(5) NOT NULL | AR Business Unit |
| 10 | BUSINESS_UNIT_BAL | Character(5) | VARCHAR2(5) NOT NULL | Specifies the business unit associated with the control totals for a journal. There may be multiple sets of control totals for a single journal. For example, an interunit journal between two business units will specify two balancing business units and maintain control totals for each. |
| 11 | BUSINESS_UNIT_BD | Character(5) | VARCHAR2(5) NOT NULL | Budgeting Business Unit |
| 12 | BUSINESS_UNIT_BI | Character(5) | VARCHAR2(5) NOT NULL | Billing Business Unit |
| 13 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 14 | BUSINESS_UNIT_IN | Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
| 15 | BUSINESS_UNIT_OM | Character(5) | VARCHAR2(5) NOT NULL | Order Management Business Unit |
| 16 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 17 | BUSINESS_UNIT_PO | Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |