CA_LMT_PROC_RC(SQL Table) |
Index Back |
|---|---|
Limits Run Control |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | REQUEST_NBR |
Number(4,0) | SMALLINT NOT NULL | Request Number |
| 4 | CA_PRC_BILLING | Character(1) | VARCHAR2(1) NOT NULL |
Process Billing - Checkbox
Used in Contracts Limits Run Control page.
Y/N Table Edit Default Value: Y |
| 5 | CA_PRC_REVENUE | Character(1) | VARCHAR2(1) NOT NULL |
Process Revenue - Checkbox
Used in Contracts Limits Run Control page.
Y/N Table Edit Default Value: N |
| 6 | CA_RECALC_TOT | Character(1) | VARCHAR2(1) NOT NULL |
Recalculate Totals Only - Checkbox
Used in Contracts Limits Run Control page.
Y/N Table Edit Default Value: N |
| 7 | CA_LMT_CALL | Character(1) | VARCHAR2(1) NOT NULL |
Limits Process Calling Program
O=Online P=PC Pricing R=Billing Interface - Retainage S=Standalone Default Value: S |
| 8 | CA_LMT_PRCS_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Process for Paid Vouchers
R=Run for Paid Vouchers S=Standard Limits Processing Default Value: S |