RE_AM_LSDEF_TBL(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT_AM |
Character(5) | VARCHAR2(5) NOT NULL | AM Business Unit |
| 2 | ASSET_ID |
Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | ASSET_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Asset Status
A=Received (Not in Service) B=Budgeted C=Commitment D=Disposed I=In Service M=Suspended R=Requisitioned T=Transferred W=Work In Progress |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | EXPIRATION_DT | Date(10) | DATE | Expiration Date |
| 7 | LSE_TYPE_CD | Character(10) | VARCHAR2(10) NOT NULL |
This field contains the code for the Lease Types
Prompt Table: RE_LSETYPE_SRCH |
| 8 | REGION_CD | Character(10) | VARCHAR2(10) NOT NULL |
Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
Prompt Table: RE_REGION_NAME |
| 9 | LS_ADMIN | Number(10,0) | DECIMAL(10) NOT NULL |
Lease Administrator
Prompt Table: RE_PTY_LA |
| 10 | PRTFL_MGR | Number(10,0) | DECIMAL(10) NOT NULL |
Portfolio Manager
Prompt Table: RE_PTY_PM |
| 11 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: RE_VNDR_NAM_DVW |
| 12 | UPDATE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Update Flag
0=No Modification 1=Add 2=Change 3=Delete |