| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BU_AM_NONVW
|
| 2 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
|
| 3 |
PYMNT_DT |
Date(10) |
DATE |
Payment Date
|
| 4 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
Default Value: 0
|
| 5 |
INTEREST_EXPENSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Interest Expense
|
| 6 |
OBLIGATION_REDUCE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Obligation Reduction
|
| 7 |
PYMNT_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Frequency
A=Annually
M=Monthly
Q=Quarterly
S=Semi-Annually
|
| 8 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: CURR_CD_AM_VW.CURRENCY_CD
|
| 9 |
SCHED_PYMNT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Lease Payment Type
C=Capital Interim Rent
I=Interim Rent
N=Normal Rent
R=Reversal Payment
S=Reversal Interim
T=Reversal Capital Interim
X=Payment Reverted
Y=Interim Reverted
Z=Capital Interim Reverted
|
| 10 |
LEASE_INTFC_AP_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Payables Integration
Y/N Table Edit
|
| 11 |
BUSINESS_UNIT_AP |
Character(5) |
VARCHAR2(5) NOT NULL |
AP Business Unit
Prompt Table:
SP_BU_AP_NONVW
|
| 12 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
|
| 13 |
INVOICE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Invoice Number
|
| 14 |
LEASE_INTFC_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Status
APP=Pending Approval
APR=Approved
CAN=Canceled
DON=Processed
ERR=Error
HLD=On Hold
INP=In Process
NEW=Approved-Auto
STA=Sent To AP
|
| 15 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|