VIEW: JMF.JMF_GTA_TRX_HEADERS_ALL_OBS#

Source

View Text - Preformatted

select RA_GL_DATE RA_GL_DATE, RA_GL_PERIOD RA_GL_PERIOD, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, BILL_TO_CUSTOMER_ID BILL_TO_CUSTOMER_ID, BILL_TO_CUSTOMER_NUMBER BILL_TO_CUSTOMER_NUMBER, BILL_TO_CUSTOMER_NAME BILL_TO_CUSTOMER_NAME, SOURCE SOURCE, ORG_ID ORG_ID, RULE_HEADER_ID RULE_HEADER_ID, GTA_TRX_HEADER_ID GTA_TRX_HEADER_ID, GTA_TRX_NUMBER GTA_TRX_NUMBER, GROUP_NUMBER GROUP_NUMBER, VERSION VERSION, LATEST_VERSION_FLAG LATEST_VERSION_FLAG, TRANSACTION_DATE TRANSACTION_DATE, RA_TRX_ID RA_TRX_ID, RA_TRX_NUMBER RA_TRX_NUMBER, DESCRIPTION DESCRIPTION, CUSTOMER_ADDRESS CUSTOMER_ADDRESS, CUSTOMER_PHONE CUSTOMER_PHONE, CUSTOMER_ADDRESS_PHONE CUSTOMER_ADDRESS_PHONE, BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME, BANK_ACCOUNT_NUMBER BANK_ACCOUNT_NUMBER, BANK_ACCOUNT_NAME_NUMBER BANK_ACCOUNT_NAME_NUMBER, RA_CURRENCY_CODE RA_CURRENCY_CODE, CONVERSION_TYPE CONVERSION_TYPE, CONVERSION_DATE CONVERSION_DATE, CONVERSION_RATE CONVERSION_RATE, GTA_BATCH_NUMBER GTA_BATCH_NUMBER, GT_INVOICE_NUMBER GT_INVOICE_NUMBER, GT_INVOICE_DATE GT_INVOICE_DATE, GT_INVOICE_NET_AMOUNT GT_INVOICE_NET_AMOUNT, GT_INVOICE_TAX_AMOUNT GT_INVOICE_TAX_AMOUNT, STATUS STATUS, SALES_LIST_FLAG SALES_LIST_FLAG, CANCEL_FLAG CANCEL_FLAG, GT_INVOICE_TYPE GT_INVOICE_TYPE, GT_INVOICE_CLASS GT_INVOICE_CLASS, GT_TAX_MONTH GT_TAX_MONTH, ISSUER_NAME ISSUER_NAME, REVIEWER_NAME REVIEWER_NAME, PAYEE_NAME PAYEE_NAME, TAX_CODE TAX_CODE, TAX_RATE TAX_RATE, GENERATOR_ID GENERATOR_ID, EXPORT_REQUEST_ID EXPORT_REQUEST_ID, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, FP_TAX_REGISTRATION_NUMBER FP_TAX_REGISTRATION_NUMBER, TP_TAX_REGISTRATION_NUMBER TP_TAX_REGISTRATION_NUMBER, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_ID PROGRAM_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, INVOICE_TYPE INVOICE_TYPE, CONSOLIDATION_FLAG CONSOLIDATION_FLAG, CONSOLIDATION_ID CONSOLIDATION_ID, CONSOLIDATION_TRX_NUM CONSOLIDATION_TRX_NUM, CONSOLIDATION_REQUEST_ID CONSOLIDATION_REQUEST_ID from "JMF"."JMF_GTA_TRX_HEADERS_ALL_OBS"

View Text - HTML Formatted

SELECT RA_GL_DATE RA_GL_DATE
, RA_GL_PERIOD RA_GL_PERIOD
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, BILL_TO_CUSTOMER_ID BILL_TO_CUSTOMER_ID
, BILL_TO_CUSTOMER_NUMBER BILL_TO_CUSTOMER_NUMBER
, BILL_TO_CUSTOMER_NAME BILL_TO_CUSTOMER_NAME
, SOURCE SOURCE
, ORG_ID ORG_ID
, RULE_HEADER_ID RULE_HEADER_ID
, GTA_TRX_HEADER_ID GTA_TRX_HEADER_ID
, GTA_TRX_NUMBER GTA_TRX_NUMBER
, GROUP_NUMBER GROUP_NUMBER
, VERSION VERSION
, LATEST_VERSION_FLAG LATEST_VERSION_FLAG
, TRANSACTION_DATE TRANSACTION_DATE
, RA_TRX_ID RA_TRX_ID
, RA_TRX_NUMBER RA_TRX_NUMBER
, DESCRIPTION DESCRIPTION
, CUSTOMER_ADDRESS CUSTOMER_ADDRESS
, CUSTOMER_PHONE CUSTOMER_PHONE
, CUSTOMER_ADDRESS_PHONE CUSTOMER_ADDRESS_PHONE
, BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME
, BANK_ACCOUNT_NUMBER BANK_ACCOUNT_NUMBER
, BANK_ACCOUNT_NAME_NUMBER BANK_ACCOUNT_NAME_NUMBER
, RA_CURRENCY_CODE RA_CURRENCY_CODE
, CONVERSION_TYPE CONVERSION_TYPE
, CONVERSION_DATE CONVERSION_DATE
, CONVERSION_RATE CONVERSION_RATE
, GTA_BATCH_NUMBER GTA_BATCH_NUMBER
, GT_INVOICE_NUMBER GT_INVOICE_NUMBER
, GT_INVOICE_DATE GT_INVOICE_DATE
, GT_INVOICE_NET_AMOUNT GT_INVOICE_NET_AMOUNT
, GT_INVOICE_TAX_AMOUNT GT_INVOICE_TAX_AMOUNT
, STATUS STATUS
, SALES_LIST_FLAG SALES_LIST_FLAG
, CANCEL_FLAG CANCEL_FLAG
, GT_INVOICE_TYPE GT_INVOICE_TYPE
, GT_INVOICE_CLASS GT_INVOICE_CLASS
, GT_TAX_MONTH GT_TAX_MONTH
, ISSUER_NAME ISSUER_NAME
, REVIEWER_NAME REVIEWER_NAME
, PAYEE_NAME PAYEE_NAME
, TAX_CODE TAX_CODE
, TAX_RATE TAX_RATE
, GENERATOR_ID GENERATOR_ID
, EXPORT_REQUEST_ID EXPORT_REQUEST_ID
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, FP_TAX_REGISTRATION_NUMBER FP_TAX_REGISTRATION_NUMBER
, TP_TAX_REGISTRATION_NUMBER TP_TAX_REGISTRATION_NUMBER
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_ID PROGRAM_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, INVOICE_TYPE INVOICE_TYPE
, CONSOLIDATION_FLAG CONSOLIDATION_FLAG
, CONSOLIDATION_ID CONSOLIDATION_ID
, CONSOLIDATION_TRX_NUM CONSOLIDATION_TRX_NUM
, CONSOLIDATION_REQUEST_ID CONSOLIDATION_REQUEST_ID
FROM "JMF"."JMF_GTA_TRX_HEADERS_ALL_OBS"