BUS_UNIT_TBL_RF

(SQL Table)
Index Back

Field Service BU table

Stores Field Service Business Unit information.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_RB.BUSINESS_UNIT

2 BU_STATUS Character(1) VARCHAR2(1) NOT NULL Open or Closed Status of the Business Unit.
1=Facility Open
2=Facility Closed

Default Value: 2

3 BOM_VERIFICATION Character(1) VARCHAR2(1) NOT NULL Online bill of materials verification.
N=Never Verify Online
O=Prompt User
Y=Always Verify Online
4 RECEIPT_FLAG Character(1) VARCHAR2(1) NOT NULL Flag to indicate whether receiving is automatic or manual.
N=Manual Receiving
Y=Automatic Receiving

Default Value: N

5 AUTOCALC Character(1) VARCHAR2(1) NOT NULL The auto-calc field is used to signify whether auto-calculation of service order dates is off or on.

Y/N Table Edit

Default Value: N

6 INDUSTRY_TEMPL Character(4) VARCHAR2(4) NOT NULL This field stores the Template values.

Prompt Table: RF_INDUSTRY_CFG

7 PM_APPLICABLE Character(1) VARCHAR2(1) NOT NULL This flag indicates whether or not it is applicable to preventive maintenance.

Y/N Table Edit

Default Value: N

8 RF_VT_OPT_SITE Character(1) VARCHAR2(1) NOT NULL Allow a case to be created for a site, no representative etcetera.

Y/N Table Edit

Default Value: N

9 RF_AUTO_ASSIGN Character(1) VARCHAR2(1) NOT NULL Business unit flag indicating that automatic assignment of service orders should happen when the service order is saved.

Y/N Table Edit

Default Value: N

10 RF_AUTO_ASSIGN_AVL Character(1) VARCHAR2(1) NOT NULL Business unit flag indicating that only available candidates should be returned by the assignment engine.

Y/N Table Edit

Default Value: N

11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.

Prompt Table: CURRENCY_CD_TBL

12 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.

Default Value: INSTALLATION.DEF_CUR_RT_TYPE

Prompt Table: RT_TYPE_TBL

13 MATL_BILLABLE Character(1) VARCHAR2(1) NOT NULL Flag to identify if the material is billable for this Business Unit.

Y/N Table Edit

Default Value: Y

14 EXPENSE_BILLABLE Character(1) VARCHAR2(1) NOT NULL Flag to identify if the Expense is billable for this Business Unit.

Y/N Table Edit

Default Value: Y

15 SERVICE_LVL_CD Character(4) VARCHAR2(4) NOT NULL This field stores the Service Level Code.
7X24=7X24
ENH=Enhanced
PREF=Preferred
PREM=Premium
STD=Standard

Prompt Table: RF_SERVICE_LVL
Set Control Field: BUSINESS_UNIT

16 BUSINESS_UNIT_CA Character(5) VARCHAR2(5) NOT NULL This field stores the values for Contracts Business Unit.

Prompt Table: SP_BU_FS_NONVW

17 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL This field stores the General Ledger Business Unit. Used for the Integration with Contracts/Billing from CRM.

Prompt Table: SP_BU_FS_NONVW

18 LOCATION Character(15) VARCHAR2(15) NOT NULL This field stores the Location Code.

Prompt Table: LOCATION_TBL
Set Control Field: BUSINESS_UNIT

19 BILL_TYPE_ID Character(3) VARCHAR2(3) NOT NULL This field stores the Bill Type Identifier.

Prompt Table: BI_TYPE_EF_VW
Set Control Field: BUSINESS_UNIT

20 BILL_SOURCE_ID Character(10) VARCHAR2(10) NOT NULL Bill Source ID - used on the Field Service Business Unit table. Value obtained from SCM.

Prompt Table: BI_SRC_EF_VW
Set Control Field: BUSINESS_UNIT

21 ORD_ORIGIN_LOC Character(10) VARCHAR2(10) NOT NULL This field stores the Order Origin Location.

Prompt Table: LOCATION_VW1

22 ORD_ACCEPT_LOC Character(10) VARCHAR2(10) NOT NULL This field stores the value for Order Acceptance Location

Prompt Table: LOCATION_VW1

23 STORE_LOC Character(10) VARCHAR2(10) NOT NULL This field stores the value for Store Location
24 CR_CARD_VENDOR Character(16) VARCHAR2(16) NOT NULL Vendor name for credit card processing

Prompt Table: EOEC_CCI_INSTAL

25 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
26 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
27 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
28 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
29 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.
30 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time