RF_AGR_OPTIONS

(SQL Table)
Index Back

Agreement options.

To define SetID options for agreement which is new of 8.9 release.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

Prompt Table: SP_SETID_NONVW

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

Prompt Table: SP_BU_FS_NONVW

3 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

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

Prompt Table: LOCATION_VW1
Set Control Field: SETID

5 SCHEDULE Character(10) VARCHAR2(10) NOT NULL Schedule for integration with Contracts.

Prompt Table: RF_SCHED_TBL_VW
Set Control Field: SETID

6 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: SETID

7 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: SETID

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

Prompt Table: LOCATION_VW1
Set Control Field: SETID

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

Prompt Table: LOCATION_VW1
Set Control Field: SETID

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

Prompt Table: EOEC_CCI_INSTAL

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