SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
SUB_RULE_IDTEST_ATTRIBUTEPrompt Table: %EDIT_ATTRIBUTE
SET_CFPrompt Table: TRA_CF_VW
SUB_RULE_FIELDS(SQL Table) |
Index Back |
|---|---|
Substitution Rule FieldsSubstitution Rule Fields specifies the attribute to be tested and the ChartField to be overriden. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | SUB_RULE_ID |
Character(20) | VARCHAR2(20) NOT NULL | The unique key identifier for a given accounting template substitution rule. |
| 3 | TEST_ATTRIBUTE |
Character(18) | VARCHAR2(18) NOT NULL |
Represents the treasury deal transaction attribute that is subject to a predefined accounting template
Prompt Table: %EDIT_ATTRIBUTE |
| 4 | SET_CF |
Character(18) | VARCHAR2(18) NOT NULL |
Represents a treasury accounting template substitution rule that determines which General Ledger chartfield is
Prompt Table: TRA_CF_VW |