LS_KEYBUSINESS_UNITPrompt Table: SP_BU_RE_NONVW
LS_TXN_STATUS0=Draft
1=Pending
2=Approved
3=Cancelled
4=Hold
5=Processed
6=Errors
7=Processed Prior to Transfer
RE_TQM_XFER_VW(SQL View) |
Index Back |
|---|---|
Transaction QueueTransaction Queue Reference AWE |
| SELECT DISTINCT LS_KEY , BUSINESS_UNIT , LS_TXN_STATUS FROM PS_RE_LS_TXN |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LS_KEY |
Number(15,0) | DECIMAL(15) NOT NULL | Lease Key, Unique Key |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_RE_NONVW |
| 3 | LS_TXN_STATUS |
Character(1) | VARCHAR2(1) NOT NULL |
Lease Transaction Status
0=Draft 1=Pending 2=Approved 3=Cancelled 4=Hold 5=Processed 6=Errors 7=Processed Prior to Transfer |