RE_LS_AST_AATRF

(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 ASSET_SEQ_NBR Number(5,0) INTEGER NOT NULL Asset Sequence Number
4 TRF_KEY Number(3,0) SMALLINT NOT NULL Transfer Key
5 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
6 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
7 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name
8 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.
9 TRANS_IN_OUT Character(1) VARCHAR2(1) NOT NULL Transaction In/Out
I=In
M=IUT Proceeds Markup
O=Out
10 IU_MAP_KEY Number(7,0) INTEGER NOT NULL InterUnit transfer map key
11 CF_SEQNO Number(6,0) INTEGER NOT NULL Chartfield Sequence Number
12 TRANS_DT Date(10) DATE Transaction Date
13 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
14 TRF_UPDATE_FLG Character(1) VARCHAR2(1) NOT NULL Transfer Update Status

Default Value: N

15 TRF_TYPE Character(2) VARCHAR2(2) NOT NULL Transfer Type
LN=Lease Incentive
LO=Lease Obligation
RE=Rent Expense
16 COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type
17 PRORATION_RATE Number(14,10) DECIMAL(13,10) NOT NULL Proration Rate
18 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
19 AMOUNT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount