VIEW: OTA.OTA_FINANCE_HEADERS#

Source

View Text - Preformatted

select FINANCE_HEADER_ID FINANCE_HEADER_ID, SUPERCEDING_HEADER_ID SUPERCEDING_HEADER_ID, AUTHORIZER_PERSON_ID AUTHORIZER_PERSON_ID, ORGANIZATION_ID ORGANIZATION_ID, ADMINISTRATOR ADMINISTRATOR, CANCELLED_FLAG CANCELLED_FLAG, CURRENCY_CODE CURRENCY_CODE, DATE_RAISED DATE_RAISED, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PAYMENT_STATUS_FLAG PAYMENT_STATUS_FLAG, TRANSFER_STATUS TRANSFER_STATUS, TYPE TYPE, COMMENTS COMMENTS, EXTERNAL_REFERENCE EXTERNAL_REFERENCE, INVOICE_ADDRESS INVOICE_ADDRESS, INVOICE_CONTACT INVOICE_CONTACT, PAYMENT_METHOD PAYMENT_METHOD, PYM_ATTRIBUTE1 PYM_ATTRIBUTE1, PYM_ATTRIBUTE10 PYM_ATTRIBUTE10, PYM_ATTRIBUTE11 PYM_ATTRIBUTE11, PYM_ATTRIBUTE12 PYM_ATTRIBUTE12, PYM_ATTRIBUTE13 PYM_ATTRIBUTE13, PYM_ATTRIBUTE14 PYM_ATTRIBUTE14, PYM_ATTRIBUTE15 PYM_ATTRIBUTE15, PYM_ATTRIBUTE16 PYM_ATTRIBUTE16, PYM_ATTRIBUTE17 PYM_ATTRIBUTE17, PYM_ATTRIBUTE18 PYM_ATTRIBUTE18, PYM_ATTRIBUTE19 PYM_ATTRIBUTE19, PYM_ATTRIBUTE2 PYM_ATTRIBUTE2, PYM_ATTRIBUTE20 PYM_ATTRIBUTE20, PYM_ATTRIBUTE3 PYM_ATTRIBUTE3, PYM_ATTRIBUTE4 PYM_ATTRIBUTE4, PYM_ATTRIBUTE5 PYM_ATTRIBUTE5, PYM_ATTRIBUTE6 PYM_ATTRIBUTE6, PYM_ATTRIBUTE7 PYM_ATTRIBUTE7, PYM_ATTRIBUTE8 PYM_ATTRIBUTE8, PYM_ATTRIBUTE9 PYM_ATTRIBUTE9, PYM_INFORMATION_CATEGORY PYM_INFORMATION_CATEGORY, RECEIVABLE_TYPE RECEIVABLE_TYPE, TRANSFER_DATE TRANSFER_DATE, TRANSFER_MESSAGE TRANSFER_MESSAGE, VENDOR_ID VENDOR_ID, CONTACT_ID CONTACT_ID, ADDRESS_ID ADDRESS_ID, CUSTOMER_ID CUSTOMER_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, TFH_INFORMATION_CATEGORY TFH_INFORMATION_CATEGORY, TFH_INFORMATION1 TFH_INFORMATION1, TFH_INFORMATION2 TFH_INFORMATION2, TFH_INFORMATION3 TFH_INFORMATION3, TFH_INFORMATION4 TFH_INFORMATION4, TFH_INFORMATION5 TFH_INFORMATION5, TFH_INFORMATION6 TFH_INFORMATION6, TFH_INFORMATION7 TFH_INFORMATION7, TFH_INFORMATION8 TFH_INFORMATION8, TFH_INFORMATION9 TFH_INFORMATION9, TFH_INFORMATION10 TFH_INFORMATION10, TFH_INFORMATION11 TFH_INFORMATION11, TFH_INFORMATION12 TFH_INFORMATION12, TFH_INFORMATION13 TFH_INFORMATION13, TFH_INFORMATION14 TFH_INFORMATION14, TFH_INFORMATION15 TFH_INFORMATION15, TFH_INFORMATION16 TFH_INFORMATION16, TFH_INFORMATION17 TFH_INFORMATION17, TFH_INFORMATION18 TFH_INFORMATION18, TFH_INFORMATION19 TFH_INFORMATION19, TFH_INFORMATION20 TFH_INFORMATION20, RECEIVING_COST_CENTER RECEIVING_COST_CENTER, PAYING_COST_CENTER PAYING_COST_CENTER, TRANSFER_FROM_SET_OF_BOOKS_ID TRANSFER_FROM_SET_OF_BOOKS_ID, TRANSFER_TO_SET_OF_BOOKS_ID TRANSFER_TO_SET_OF_BOOKS_ID, FROM_SEGMENT1 FROM_SEGMENT1, FROM_SEGMENT2 FROM_SEGMENT2, FROM_SEGMENT3 FROM_SEGMENT3, FROM_SEGMENT4 FROM_SEGMENT4, FROM_SEGMENT5 FROM_SEGMENT5, FROM_SEGMENT6 FROM_SEGMENT6, FROM_SEGMENT7 FROM_SEGMENT7, FROM_SEGMENT8 FROM_SEGMENT8, FROM_SEGMENT9 FROM_SEGMENT9, FROM_SEGMENT10 FROM_SEGMENT10, FROM_SEGMENT11 FROM_SEGMENT11, FROM_SEGMENT12 FROM_SEGMENT12, FROM_SEGMENT13 FROM_SEGMENT13, FROM_SEGMENT14 FROM_SEGMENT14, FROM_SEGMENT15 FROM_SEGMENT15, FROM_SEGMENT16 FROM_SEGMENT16, FROM_SEGMENT17 FROM_SEGMENT17, FROM_SEGMENT18 FROM_SEGMENT18, FROM_SEGMENT19 FROM_SEGMENT19, FROM_SEGMENT20 FROM_SEGMENT20, FROM_SEGMENT21 FROM_SEGMENT21, FROM_SEGMENT22 FROM_SEGMENT22, FROM_SEGMENT23 FROM_SEGMENT23, FROM_SEGMENT24 FROM_SEGMENT24, FROM_SEGMENT25 FROM_SEGMENT25, FROM_SEGMENT26 FROM_SEGMENT26, FROM_SEGMENT27 FROM_SEGMENT27, FROM_SEGMENT28 FROM_SEGMENT28, FROM_SEGMENT29 FROM_SEGMENT29, FROM_SEGMENT30 FROM_SEGMENT30, TO_SEGMENT1 TO_SEGMENT1, TO_SEGMENT2 TO_SEGMENT2, TO_SEGMENT3 TO_SEGMENT3, TO_SEGMENT4 TO_SEGMENT4, TO_SEGMENT5 TO_SEGMENT5, TO_SEGMENT6 TO_SEGMENT6, TO_SEGMENT7 TO_SEGMENT7, TO_SEGMENT8 TO_SEGMENT8, TO_SEGMENT9 TO_SEGMENT9, TO_SEGMENT10 TO_SEGMENT10, TO_SEGMENT11 TO_SEGMENT11, TO_SEGMENT12 TO_SEGMENT12, TO_SEGMENT13 TO_SEGMENT13, TO_SEGMENT14 TO_SEGMENT14, TO_SEGMENT15 TO_SEGMENT15, TO_SEGMENT16 TO_SEGMENT16, TO_SEGMENT17 TO_SEGMENT17, TO_SEGMENT18 TO_SEGMENT18, TO_SEGMENT19 TO_SEGMENT19, TO_SEGMENT20 TO_SEGMENT20, TO_SEGMENT21 TO_SEGMENT21, TO_SEGMENT22 TO_SEGMENT22, TO_SEGMENT23 TO_SEGMENT23, TO_SEGMENT24 TO_SEGMENT24, TO_SEGMENT25 TO_SEGMENT25, TO_SEGMENT26 TO_SEGMENT26, TO_SEGMENT27 TO_SEGMENT27, TO_SEGMENT28 TO_SEGMENT28, TO_SEGMENT29 TO_SEGMENT29, TO_SEGMENT30 TO_SEGMENT30, TRANSFER_FROM_CC_ID TRANSFER_FROM_CC_ID, TRANSFER_TO_CC_ID TRANSFER_TO_CC_ID from "OTA"."OTA_FINANCE_HEADERS"

View Text - HTML Formatted

SELECT FINANCE_HEADER_ID FINANCE_HEADER_ID
, SUPERCEDING_HEADER_ID SUPERCEDING_HEADER_ID
, AUTHORIZER_PERSON_ID AUTHORIZER_PERSON_ID
, ORGANIZATION_ID ORGANIZATION_ID
, ADMINISTRATOR ADMINISTRATOR
, CANCELLED_FLAG CANCELLED_FLAG
, CURRENCY_CODE CURRENCY_CODE
, DATE_RAISED DATE_RAISED
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PAYMENT_STATUS_FLAG PAYMENT_STATUS_FLAG
, TRANSFER_STATUS TRANSFER_STATUS
, TYPE TYPE
, COMMENTS COMMENTS
, EXTERNAL_REFERENCE EXTERNAL_REFERENCE
, INVOICE_ADDRESS INVOICE_ADDRESS
, INVOICE_CONTACT INVOICE_CONTACT
, PAYMENT_METHOD PAYMENT_METHOD
, PYM_ATTRIBUTE1 PYM_ATTRIBUTE1
, PYM_ATTRIBUTE10 PYM_ATTRIBUTE10
, PYM_ATTRIBUTE11 PYM_ATTRIBUTE11
, PYM_ATTRIBUTE12 PYM_ATTRIBUTE12
, PYM_ATTRIBUTE13 PYM_ATTRIBUTE13
, PYM_ATTRIBUTE14 PYM_ATTRIBUTE14
, PYM_ATTRIBUTE15 PYM_ATTRIBUTE15
, PYM_ATTRIBUTE16 PYM_ATTRIBUTE16
, PYM_ATTRIBUTE17 PYM_ATTRIBUTE17
, PYM_ATTRIBUTE18 PYM_ATTRIBUTE18
, PYM_ATTRIBUTE19 PYM_ATTRIBUTE19
, PYM_ATTRIBUTE2 PYM_ATTRIBUTE2
, PYM_ATTRIBUTE20 PYM_ATTRIBUTE20
, PYM_ATTRIBUTE3 PYM_ATTRIBUTE3
, PYM_ATTRIBUTE4 PYM_ATTRIBUTE4
, PYM_ATTRIBUTE5 PYM_ATTRIBUTE5
, PYM_ATTRIBUTE6 PYM_ATTRIBUTE6
, PYM_ATTRIBUTE7 PYM_ATTRIBUTE7
, PYM_ATTRIBUTE8 PYM_ATTRIBUTE8
, PYM_ATTRIBUTE9 PYM_ATTRIBUTE9
, PYM_INFORMATION_CATEGORY PYM_INFORMATION_CATEGORY
, RECEIVABLE_TYPE RECEIVABLE_TYPE
, TRANSFER_DATE TRANSFER_DATE
, TRANSFER_MESSAGE TRANSFER_MESSAGE
, VENDOR_ID VENDOR_ID
, CONTACT_ID CONTACT_ID
, ADDRESS_ID ADDRESS_ID
, CUSTOMER_ID CUSTOMER_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, TFH_INFORMATION_CATEGORY TFH_INFORMATION_CATEGORY
, TFH_INFORMATION1 TFH_INFORMATION1
, TFH_INFORMATION2 TFH_INFORMATION2
, TFH_INFORMATION3 TFH_INFORMATION3
, TFH_INFORMATION4 TFH_INFORMATION4
, TFH_INFORMATION5 TFH_INFORMATION5
, TFH_INFORMATION6 TFH_INFORMATION6
, TFH_INFORMATION7 TFH_INFORMATION7
, TFH_INFORMATION8 TFH_INFORMATION8
, TFH_INFORMATION9 TFH_INFORMATION9
, TFH_INFORMATION10 TFH_INFORMATION10
, TFH_INFORMATION11 TFH_INFORMATION11
, TFH_INFORMATION12 TFH_INFORMATION12
, TFH_INFORMATION13 TFH_INFORMATION13
, TFH_INFORMATION14 TFH_INFORMATION14
, TFH_INFORMATION15 TFH_INFORMATION15
, TFH_INFORMATION16 TFH_INFORMATION16
, TFH_INFORMATION17 TFH_INFORMATION17
, TFH_INFORMATION18 TFH_INFORMATION18
, TFH_INFORMATION19 TFH_INFORMATION19
, TFH_INFORMATION20 TFH_INFORMATION20
, RECEIVING_COST_CENTER RECEIVING_COST_CENTER
, PAYING_COST_CENTER PAYING_COST_CENTER
, TRANSFER_FROM_SET_OF_BOOKS_ID TRANSFER_FROM_SET_OF_BOOKS_ID
, TRANSFER_TO_SET_OF_BOOKS_ID TRANSFER_TO_SET_OF_BOOKS_ID
, FROM_SEGMENT1 FROM_SEGMENT1
, FROM_SEGMENT2 FROM_SEGMENT2
, FROM_SEGMENT3 FROM_SEGMENT3
, FROM_SEGMENT4 FROM_SEGMENT4
, FROM_SEGMENT5 FROM_SEGMENT5
, FROM_SEGMENT6 FROM_SEGMENT6
, FROM_SEGMENT7 FROM_SEGMENT7
, FROM_SEGMENT8 FROM_SEGMENT8
, FROM_SEGMENT9 FROM_SEGMENT9
, FROM_SEGMENT10 FROM_SEGMENT10
, FROM_SEGMENT11 FROM_SEGMENT11
, FROM_SEGMENT12 FROM_SEGMENT12
, FROM_SEGMENT13 FROM_SEGMENT13
, FROM_SEGMENT14 FROM_SEGMENT14
, FROM_SEGMENT15 FROM_SEGMENT15
, FROM_SEGMENT16 FROM_SEGMENT16
, FROM_SEGMENT17 FROM_SEGMENT17
, FROM_SEGMENT18 FROM_SEGMENT18
, FROM_SEGMENT19 FROM_SEGMENT19
, FROM_SEGMENT20 FROM_SEGMENT20
, FROM_SEGMENT21 FROM_SEGMENT21
, FROM_SEGMENT22 FROM_SEGMENT22
, FROM_SEGMENT23 FROM_SEGMENT23
, FROM_SEGMENT24 FROM_SEGMENT24
, FROM_SEGMENT25 FROM_SEGMENT25
, FROM_SEGMENT26 FROM_SEGMENT26
, FROM_SEGMENT27 FROM_SEGMENT27
, FROM_SEGMENT28 FROM_SEGMENT28
, FROM_SEGMENT29 FROM_SEGMENT29
, FROM_SEGMENT30 FROM_SEGMENT30
, TO_SEGMENT1 TO_SEGMENT1
, TO_SEGMENT2 TO_SEGMENT2
, TO_SEGMENT3 TO_SEGMENT3
, TO_SEGMENT4 TO_SEGMENT4
, TO_SEGMENT5 TO_SEGMENT5
, TO_SEGMENT6 TO_SEGMENT6
, TO_SEGMENT7 TO_SEGMENT7
, TO_SEGMENT8 TO_SEGMENT8
, TO_SEGMENT9 TO_SEGMENT9
, TO_SEGMENT10 TO_SEGMENT10
, TO_SEGMENT11 TO_SEGMENT11
, TO_SEGMENT12 TO_SEGMENT12
, TO_SEGMENT13 TO_SEGMENT13
, TO_SEGMENT14 TO_SEGMENT14
, TO_SEGMENT15 TO_SEGMENT15
, TO_SEGMENT16 TO_SEGMENT16
, TO_SEGMENT17 TO_SEGMENT17
, TO_SEGMENT18 TO_SEGMENT18
, TO_SEGMENT19 TO_SEGMENT19
, TO_SEGMENT20 TO_SEGMENT20
, TO_SEGMENT21 TO_SEGMENT21
, TO_SEGMENT22 TO_SEGMENT22
, TO_SEGMENT23 TO_SEGMENT23
, TO_SEGMENT24 TO_SEGMENT24
, TO_SEGMENT25 TO_SEGMENT25
, TO_SEGMENT26 TO_SEGMENT26
, TO_SEGMENT27 TO_SEGMENT27
, TO_SEGMENT28 TO_SEGMENT28
, TO_SEGMENT29 TO_SEGMENT29
, TO_SEGMENT30 TO_SEGMENT30
, TRANSFER_FROM_CC_ID TRANSFER_FROM_CC_ID
, TRANSFER_TO_CC_ID TRANSFER_TO_CC_ID
FROM "OTA"."OTA_FINANCE_HEADERS"