OPRIDDefault Value: PRCSRUNCNTL.OPRID
RUN_CNTL_IDDefault Value: PRCSRUNCNTL.RUN_CNTL_ID
Prompt Table: SP_BU_RE_NONVW
1=Payables
2=Receivables
Default Value: 1
Prompt Table: %EDITTABLE
N=No
Y=Yes
RE_RUN_RENT_VAR(SQL Table) |
Index Back |
|---|---|
Run Rent Variance |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: PRCSRUNCNTL.OPRID |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Run Control ID
Default Value: PRCSRUNCNTL.RUN_CNTL_ID |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_RE_NONVW |
| 4 | START_DT | Date(10) | DATE NOT NULL | Start Date |
| 5 | END_DT | Date(10) | DATE NOT NULL | End Date |
| 6 | LEASE_OBLG | Character(1) | VARCHAR2(1) NOT NULL |
Lease Obligation either Payables or Receivables Lease
1=Payables 2=Receivables Default Value: 1 |
| 7 | PRINCIPAL_ID | Character(15) | VARCHAR2(15) NOT NULL |
Landlord/Tenant
Prompt Table: %EDITTABLE |
| 8 | EXCLUDE | Character(1) | VARCHAR2(1) NOT NULL |
Exclude
N=No Y=Yes |
| 9 | UOM_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Unit of measure description |