RE_LS_TXN_DISP

(SQL View)
 Index Back

Lease Transactions for Dispute

Lease Transaction details for use by a lease that is in dispute.

SELECT A.LS_TXN_ID , A.BUSINESS_UNIT , A.LS_KEY , A.TXN_GRP , A.LS_TXN_SRC_ID , A.SCHED_DATE , A.LEASE_OBLG , A.LS_TXN_ORIG , A.LS_TXN_TGT , A.SCHED_NUM , A.LS_TXN_STATUS , A.PREV_TXN_STATUS , A.FROM_DATE , A.TO_DATE , A.PRIOR_PER_DIF , A.PROCESS_INSTANCE ,%subrec(FMS_WHO_SBR, A) , 'Y' FROM PS_RE_LS_TXN A WHERE (A.LS_TXN_STATUS = '1' OR A.LS_TXN_STATUS = '2')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LS_TXN_ID Number(25,0) DECIMAL(25) NOT NULL Lease Transaction ID
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: BUS_UNIT_TBL_FS

3 LS_KEY Number(15,0) DECIMAL(15) NOT NULL Lease Key, Unique Key
4 TXN_GRP Character(1) VARCHAR2(1) NOT NULL Transaction Group
1=Base Rent
2=Security Deposit
3=Straightline Accounting
4=Operating Expense
5=Percent Rent
6=Miscellaneous Rent
7=Manual Fee
8=Lease Obligation
9=Lease Interest Expense
A=Prior Period Lease Obligation
B=Prior Period Lease Interest
C=Rent Expense
D=Lease Incentive
5 LS_TXN_SRC_ID Number(30,0) DECIMAL(30) NOT NULL Lease Transaction Source ID
6 SCHED_DATE Date(10) DATE Schedule Date
7 LEASE_OBLG Character(1) VARCHAR2(1) NOT NULL Lease Obligation either Payables or Receivables Lease
1=Payables
2=Receivables
8 LS_TXN_ORIG Character(1) VARCHAR2(1) NOT NULL Lease Transaction Origin , Recurring or Manual
1=Recurring
2=Manual
9 LS_TXN_TGT Character(1) VARCHAR2(1) NOT NULL Lease Transaction Target
1=Payables
2=Billing
10 SCHED_NUM Number(5,0) INTEGER NOT NULL Team sequence number
11 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
12 PREV_TXN_STATUS Character(1) VARCHAR2(1) NOT NULL Transaction Status before the transaction was put on hold.
1=Pending
2=Approved
3=Canceled
4=Hold
5=Processed
6=Errors
13 FROM_DATE Date(10) DATE From Date
14 TO_DATE Date(10) DATE To Date
15 PRIOR_PER_DIF Signed Number(13,2) DECIMAL(11,2) NOT NULL Prior Period Difference for Opex Audit
16 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
17 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
18 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
19 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
20 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.
21 SELECT_CHKBOX Character(1) VARCHAR2(1) NOT NULL Check Box Selection