CA_RULES_DEFNFM(SQL Table) |
Index Back |
|---|---|
TBP Accouting Rule Mapping |
| # | 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 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: RECFLDDB_VW |
| 3 | CRIT_WEIGHT | Number(15,0) | DECIMAL(15) NOT NULL | Criteria Weight |
| 4 | LABEL_ID | Character(18) | VARCHAR2(18) NOT NULL | LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG. |
| 5 | PROMPT_TBL | Character(15) | VARCHAR2(15) NOT NULL |
Prompt Table
Prompt Table: PSRECDEFNPVW |
| 6 | CA_RULE_CRIT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Flag indicating if the field is to be used as TBP Accounting Rules header criteria
Y/N Table Edit Default Value: N |
| 7 | REQUIRED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Required Flag
N=No Y=Yes Y/N Table Edit Default Value: N |
| 8 | CA_ADD_DIALOG | Character(1) | VARCHAR2(1) NOT NULL |
Contracts TBP Accounting Rules defintion
Y/N Table Edit Default Value: N |
| 9 | CA_XLAT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Contracts TBP Accounting Rules defintion
Y/N Table Edit Default Value: N |
| 10 | FIELDNAME_TO | Character(18) | VARCHAR2(18) NOT NULL | Destination Field |