RFM_BU_CONF_VW(SQL View) |
Index Back |
|---|---|
Field Service Mobile DefaultsRecord for Field Service Mobile User defaults implementation, which includes user preferences, Business Unit Setup and Service Order Configuration. |
| SELECT B.BUSINESS_UNIT , S.SETID , B.RECEIPT_FLAG , B.AUTOCALC , B.PM_APPLICABLE , B.RF_VT_OPT_SITE , B.CURRENCY_CD , B.MATL_BILLABLE , B.EXPENSE_BILLABLE , C.AGREEMENT_FLAG , C.ALLOW_ANUSER_FLAG , C.BILLING_FLAG , C.BILLING_MY_SO , C.RF_VT_OPT_INCDADDR , C.RF_VT_OPT_INSTPRDS , C.ALLOW_EXPENSE , C.ALLOW_PRIORITY , B.SYNCID , B.SYNCDTTM FROM PS_BUS_UNIT_TBL_RF B , PS_RF_INDUSTRY_CFG C , PS_SET_CNTRL_TBL S WHERE B.BU_STATUS = '1' AND B.INDUSTRY_TEMPL = C.INDUSTRY_TEMPL AND B.BUSINESS_UNIT = S.SETCNTRLVALUE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | SETID | Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 3 | RECEIPT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Flag to indicate whether receiving is automatic or manual.
N=Manual Receiving Y=Automatic Receiving Y/N Table Edit |
| 4 | 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 |
| 5 | PM_APPLICABLE | Character(1) | VARCHAR2(1) NOT NULL |
This flag indicates whether or not it is applicable to preventive maintenance.
Y/N Table Edit |
| 6 | 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 |
| 7 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | This field stores the Currency Code value. |
| 8 | MATL_BILLABLE | Character(1) | VARCHAR2(1) NOT NULL |
Flag to identify if the material is billable for this Business Unit.
Y/N Table Edit |
| 9 | EXPENSE_BILLABLE | Character(1) | VARCHAR2(1) NOT NULL |
Flag to identify if the Expense is billable for this Business Unit.
Y/N Table Edit |
| 10 | AGREEMENT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Indicates whether or not the service can be used on an agreement.
N=No Y=Yes Y/N Table Edit |
| 11 | ALLOW_ANUSER_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Allow Anonymous User
N=No Y=Yes Y/N Table Edit |
| 12 | BILLING_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Show Billing Information
N=No Y=Yes Y/N Table Edit |
| 13 | BILLING_MY_SO | Character(1) | VARCHAR2(1) NOT NULL |
Used to control the display of the billable flag on My Service Order.
Y/N Table Edit |
| 14 | RF_VT_OPT_INCDADDR | Character(1) | VARCHAR2(1) NOT NULL |
Used to display the Address Display Options on the service order configuration.
Y/N Table Edit |
| 15 | RF_VT_OPT_INSTPRDS | Character(1) | VARCHAR2(1) NOT NULL |
Used to display the Product Display Options on the service order configuration.
A=Show Product & Serial # I=Show Installed Prod & Serial # N=Hide All Product Information P=Show Product Only |
| 16 | ALLOW_EXPENSE | Character(1) | VARCHAR2(1) NOT NULL |
This flag is used to control the display of expense information on service orders.
Y/N Table Edit |
| 17 | ALLOW_PRIORITY | Character(1) | VARCHAR2(1) NOT NULL |
This flag controls the display of priority on the service order line. If it is 'No', then the service order line priority is not displayed.
Y/N Table Edit |
| 18 | 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. |
| 19 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |