Product: | OKL - Lease and Finance Management |
---|---|
Description: | A contract line level table to record vendor invoice and shipping details for the line item. |
Implementation/DBA Data: |
![]() |
SELECT SID.ROWID ROW_ID
, SID.ID ID
, SID.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SID.CLE_ID CLE_ID
, SID.FA_CLE_ID FA_CLE_ID
, SID.INVOICE_NUMBER INVOICE_NUMBER
, SID.DATE_INVOICED DATE_INVOICED
, SID.DATE_DUE DATE_DUE
, SID.SHIPPING_ADDRESS_ID1 SHIPPING_ADDRESS_ID1
, SID.SHIPPING_ADDRESS_ID2 SHIPPING_ADDRESS_ID2
, SID.SHIPPING_ADDRESS_CODE SHIPPING_ADDRESS_CODE
, SID.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, SID.ATTRIBUTE1 ATTRIBUTE1
, SID.ATTRIBUTE2 ATTRIBUTE2
, SID.ATTRIBUTE3 ATTRIBUTE3
, SID.ATTRIBUTE4 ATTRIBUTE4
, SID.ATTRIBUTE5 ATTRIBUTE5
, SID.ATTRIBUTE6 ATTRIBUTE6
, SID.ATTRIBUTE7 ATTRIBUTE7
, SID.ATTRIBUTE8 ATTRIBUTE8
, SID.ATTRIBUTE9 ATTRIBUTE9
, SID.ATTRIBUTE10 ATTRIBUTE10
, SID.ATTRIBUTE11 ATTRIBUTE11
, SID.ATTRIBUTE12 ATTRIBUTE12
, SID.ATTRIBUTE13 ATTRIBUTE13
, SID.ATTRIBUTE14 ATTRIBUTE14
, SID.ATTRIBUTE15 ATTRIBUTE15
, SID.CREATED_BY CREATED_BY
, SID.CREATION_DATE CREATION_DATE
, SID.LAST_UPDATED_BY LAST_UPDATED_BY
, SID.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SID.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKL_SUPP_INVOICE_DTLS SID