[Home] [Help]
| Product: | OKL - Leasing and Finance Management |
|---|---|
| Description: | A top level transaction table to group all the transactions for creation of Asset lines for a Lease/Loan contract |
| Implementation/DBA Data: | Not implemented in this database |
SELECT TASB.ROWID ROW_ID
, TASB.ID ID
, TASB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TASB.ICA_ID ICA_ID
, TASB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, TASB.ATTRIBUTE1 ATTRIBUTE1
, TASB.ATTRIBUTE2 ATTRIBUTE2
, TASB.ATTRIBUTE3 ATTRIBUTE3
, TASB.ATTRIBUTE4 ATTRIBUTE4
, TASB.ATTRIBUTE5 ATTRIBUTE5
, TASB.ATTRIBUTE6 ATTRIBUTE6
, TASB.ATTRIBUTE7 ATTRIBUTE7
, TASB.ATTRIBUTE8 ATTRIBUTE8
, TASB.ATTRIBUTE9 ATTRIBUTE9
, TASB.ATTRIBUTE10 ATTRIBUTE10
, TASB.ATTRIBUTE11 ATTRIBUTE11
, TASB.ATTRIBUTE12 ATTRIBUTE12
, TASB.ATTRIBUTE13 ATTRIBUTE13
, TASB.ATTRIBUTE14 ATTRIBUTE14
, TASB.ATTRIBUTE15 ATTRIBUTE15
, TASB.TAS_TYPE TAS_TYPE
, TASB.CREATED_BY CREATED_BY
, TASB.CREATION_DATE CREATION_DATE
, TASB.LAST_UPDATED_BY LAST_UPDATED_BY
, TASB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TASB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TASB.TSU_CODE TSU_CODE
, TASB.TRY_ID TRY_ID
, TASB.DATE_TRANS_OCCURRED DATE_TRANS_OCCURRED
, TASB.TRANS_NUMBER TRANS_NUMBER
, TASB.COMMENTS COMMENTS
, TASB.REQ_ASSET_ID REQ_ASSET_ID
, TASB.TOTAL_MATCH_AMOUNT TOTAL_MATCH_AMOUNT
, TASB.ORG_ID ORG_ID
FROM OKL_TRX_ASSETS TASB