CA_TXN_SOURCECRM=CRM Transaction
FPC=Projects Transaction
FRE=Lease Administration Trans.
Y/N Table Edit
Default Value: N
N=No
Y=Yes
Y/N Table Edit
Default Value: N
Prompt Table: SEC_VIEW_NAMES
Prompt Table: RECFLDDB_VW
Prompt Table: PSRECDEFNPVW
CA_RULES_DEFN(SQL Table) |
Index Back |
|---|---|
TBP Accounting Rule Template |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CA_TXN_SOURCE |
Character(3) | VARCHAR2(3) NOT NULL |
Contracts Transaction Source
CRM=CRM Transaction FPC=Projects Transaction FRE=Lease Administration Trans. |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | CA_RECOG_REV_FLG | Character(1) | VARCHAR2(1) NOT NULL |
CA Manages Revenue Recognition
Y/N Table Edit Default Value: N |
| 4 | INTERUNIT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
InterUnit
N=No Y=Yes Y/N Table Edit Default Value: N |
| 5 | SEARCH_TEXT | Character(15) | VARCHAR2(15) NOT NULL |
Search Text for Security Views
Prompt Table: SEC_VIEW_NAMES |
| 6 | CA_LABEL_ID_BU | Character(18) | VARCHAR2(18) NOT NULL |
LABEL_ID_BU. Field is used in TBP Accounting Rules definition.
Prompt Table: RECFLDDB_VW |
| 7 | CRIT_SEQ | Number(8,0) | INTEGER NOT NULL | Criteria Sequence |
| 8 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFNPVW |
| 9 | APP_CLASS_NAME | Character(254) | VARCHAR2(254) NOT NULL | Application Class Name |