RSEC_FUNC_DEFN(SQL Table) |
Index Back |
|---|---|
Functional Option DefinitionFunctional Option Definition. This record contains the information about the conflict resolution mechanism for 'revoke' and 'maximum amount'. This record also contains the information if the function privilege is associated to amount and the base currency used for amount resolution. The message set number is used as default message set number that will be used for messages related to this function privilege. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  RSEC_FUNC_CD |
Character(30) | VARCHAR2(30) NOT NULL | Security privilege code. Used by CRM self-service to define security privileges |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | DESCRLONG | Long Character | CLOB | Long Description |
| 4 | RSEC_REVOKE_OVRIDE | Character(1) | VARCHAR2(1) NOT NULL |
Flag used to determine the revoke over ride winner.
Y/N Table Edit Default Value: Y |
| 5 | RSEC_AMT_OVRIDE | Character(1) | VARCHAR2(1) NOT NULL |
Maximum Amount Over ride winner.
Y/N Table Edit Default Value: N |
| 6 | RSEC_FP_USE_AMT | Character(1) | VARCHAR2(1) NOT NULL |
Currency Related Function Privilege.
Y/N Table Edit Default Value: N |
| 7 | RSEC_FP_USE_OPR | Character(1) | VARCHAR2(1) NOT NULL |
Currency Related Function Privilege.
Y/N Table Edit Default Value: N |
| 8 | BASE_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL |
"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
Prompt Table: CURRENCY_CD_TBL |
| 9 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
Prompt Table: PSMSGSETDEFN |
| 10 | APPCLASSID | Character(30) | VARCHAR2(30) NOT NULL |
Application Class ID
Prompt Table: RBC_APPCLASS_VW |
| 11 | APPCLASS_PATH | Character(254) | VARCHAR2(254) NOT NULL |
Application Class Full Path
Prompt Table: RBC_APPRTPATH_V |
| 12 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: PSXLATDEFN |
| 13 | RSEC_MAINT_OWNER | Character(1) | VARCHAR2(1) NOT NULL |
Field used to determine owner data information.
0=PeopleSoft 1=PeopleSoft / Customer Modified 2=Customer 3=PeopleSoft Sample Data Default Value: 2 |
| 14 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 15 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 16 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 17 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
| 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 |