RE_LS_AST_PRET

(SQL Table)
Index Back

# 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 AMND_NBR Number(3,0) SMALLINT NOT NULL Amendment Number
3 TRANS_DT Date(10) DATE Transaction Date
4 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
5 ASSET_SEQ_NBR Number(5,0) INTEGER NOT NULL Asset Sequence Number
6 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
7 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
8 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name
9 DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
10 CF_SEQNO Number(6,0) INTEGER NOT NULL Chartfield Sequence Number
11 TRF_TYPE Character(2) VARCHAR2(2) NOT NULL Transfer Type
LN=Lease Incentive
LO=Lease Obligation
RE=Rent Expense
12 COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type
13 PRORATION_RATE Number(14,10) DECIMAL(13,10) NOT NULL Proration Rate
14 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
15 AMOUNT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount