eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: JA.JAI_AR_TRXS#

Source

View Text - Preformatted


select CUSTOMER_TRX_ID CUSTOMER_TRX_ID, ORGANIZATION_ID ORGANIZATION_ID, LOCATION_ID LOCATION_ID, UPDATE_RG_FLAG UPDATE_RG_FLAG, ONCE_COMPLETED_FLAG ONCE_COMPLETED_FLAG, TOTAL_AMOUNT TOTAL_AMOUNT, LINE_AMOUNT LINE_AMOUNT, TAX_AMOUNT TAX_AMOUNT, TRX_NUMBER TRX_NUMBER, BATCH_SOURCE_ID BATCH_SOURCE_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, PRIMARY_SALESREP_ID PRIMARY_SALESREP_ID, INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, EXCHANGE_DATE EXCHANGE_DATE, EXCHANGE_RATE EXCHANGE_RATE, CREATED_FROM CREATED_FROM, UPDATE_RG23D_FLAG UPDATE_RG23D_FLAG, TAX_INVOICE_NO TAX_INVOICE_NO, VAT_INVOICE_NO VAT_INVOICE_NO, VAT_INVOICE_DATE VAT_INVOICE_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, ST_INV_NUMBER ST_INV_NUMBER, GST_INVOICE_NO GST_INVOICE_NO, GST_INVOICE_DATE GST_INVOICE_DATE, COMPLETE_FLAG COMPLETE_FLAG, SHIP_TO_CUSTOMER_ID SHIP_TO_CUSTOMER_ID, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID from "JA"."JAI_AR_TRXS"

View Text - HTML Formatted

SELECT CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, ORGANIZATION_ID ORGANIZATION_ID
, LOCATION_ID LOCATION_ID
, UPDATE_RG_FLAG UPDATE_RG_FLAG
, ONCE_COMPLETED_FLAG ONCE_COMPLETED_FLAG
, TOTAL_AMOUNT TOTAL_AMOUNT
, LINE_AMOUNT LINE_AMOUNT
, TAX_AMOUNT TAX_AMOUNT
, TRX_NUMBER TRX_NUMBER
, BATCH_SOURCE_ID BATCH_SOURCE_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, PRIMARY_SALESREP_ID PRIMARY_SALESREP_ID
, INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE
, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, EXCHANGE_DATE EXCHANGE_DATE
, EXCHANGE_RATE EXCHANGE_RATE
, CREATED_FROM CREATED_FROM
, UPDATE_RG23D_FLAG UPDATE_RG23D_FLAG
, TAX_INVOICE_NO TAX_INVOICE_NO
, VAT_INVOICE_NO VAT_INVOICE_NO
, VAT_INVOICE_DATE VAT_INVOICE_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, ST_INV_NUMBER ST_INV_NUMBER
, GST_INVOICE_NO GST_INVOICE_NO
, GST_INVOICE_DATE GST_INVOICE_DATE
, COMPLETE_FLAG COMPLETE_FLAG
, SHIP_TO_CUSTOMER_ID SHIP_TO_CUSTOMER_ID
, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
FROM "JA"."JAI_AR_TRXS"