RTBL_USER_PRNLZ(SQL Table) |
Index Back |
---|---|
Container Personalization |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPERATOR_VW |
2 | RTBL_CONTAINER_NBR | Number(5,0) | INTEGER NOT NULL | Container Number |
3 | RTBL_CURR_SCENARIO | Character(10) | VARCHAR2(10) NOT NULL | Current Scenario |
4 | RTBL_PAGELET_ID | Character(30) | VARCHAR2(30) NOT NULL |
Pagelet ID
Prompt Table: PTPPB_PAGELET |
5 | RTBL_REPORT_TYPE | Character(30) | VARCHAR2(30) NOT NULL |
Report Type
Prompt Table: PTPPB_DATATYPE |
6 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_GL_NONVW |
7 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL |
Ledger
Prompt Table:
SP_BUL_SD_NONVW
|
8 | FISCAL_YEAR_FROM | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
9 | FISCAL_YEAR_TO | Number(4,0) | SMALLINT NOT NULL | Range To Fiscal Year |
10 | FROM_PERIOD | Number(3,0) | SMALLINT NOT NULL | From Period |
11 | TO_PERIOD | Number(3,0) | SMALLINT NOT NULL | To Period |
12 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
13 | LOCK_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
12/26/01 EGS (CN#PL900-1): Added
Y/N Table Edit Default Value: N |
14 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |