| # |
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:
SP_BU_RE_NONVW
|
| 3 |
LS_KEY |
Number(15,0) |
DECIMAL(15) NOT NULL |
Lease Key, Unique Key
Prompt Table:
RE_LS
|
| 4 |
TERM_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Financial Term ID
|
| 5 |
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
|
| 6 |
PRINCIPAL_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Landlord/Tenant
|
| 7 |
SHIPTO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship To Location
|
| 8 |
MANUAL_SHIPTO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship To Location
|
| 9 |
LS_TXN_SRC_ID |
Number(30,0) |
DECIMAL(30) NOT NULL |
Lease Transaction Source ID
|
| 10 |
SCHED_DATE |
Date(10) |
DATE |
Schedule Date
|
| 11 |
LEASE_OBLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Lease Obligation either Payables or Receivables Lease
1=Payables
2=Receivables
|
| 12 |
LS_TXN_ORIG |
Character(1) |
VARCHAR2(1) NOT NULL |
Lease Transaction Origin , Recurring or Manual
1=Recurring
2=Manual
|
| 13 |
LS_TXN_TGT |
Character(1) |
VARCHAR2(1) NOT NULL |
Lease Transaction Target
1=Payables
2=Billing
|
| 14 |
SCHED_NUM |
Number(5,0) |
INTEGER NOT NULL |
Team sequence number
|
| 15 |
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
|
| 16 |
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
|
| 17 |
FROM_DATE |
Date(10) |
DATE |
From Date
|
| 18 |
TO_DATE |
Date(10) |
DATE |
To Date
|
| 19 |
PRIOR_PER_DIF |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Prior Period Difference for Opex Audit
|
| 20 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 21 |
DST_ALLOC_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Distribution Allocation Method
1=Percentage
2=Amount
3=Area
4=None
5=Quantity
Default Value: 4
|
| 22 |
INVOICE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Invoice Number
|
| 23 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
|
| 24 |
FMS_DTTM_STAMP |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the original entry.
|
| 25 |
FMS_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the original entry.
|
| 26 |
FMS_LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry.
|
| 27 |
FMS_LASTUPDOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the last update to an entry.
|
| 28 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|