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.

[Home] [Help]

VIEW: JA.JAI_FBT_PAYMENT#

Source

View Text - Preformatted


select FBT_PAYMENT_ID FBT_PAYMENT_ID, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, FBT_YEAR FBT_YEAR, STATUS_DATE STATUS_DATE, INVOICE_REFERENCE INVOICE_REFERENCE, INVOICE_DATE INVOICE_DATE, INV_SUPPLIER_ID INV_SUPPLIER_ID, INV_SUPPLIER_SITE_ID INV_SUPPLIER_SITE_ID, INV_OU_ID INV_OU_ID, FBT_TAX_AMOUNT FBT_TAX_AMOUNT, FBT_SURCHARGE_AMOUNT FBT_SURCHARGE_AMOUNT, FBT_EDU_CESS_AMOUNT FBT_EDU_CESS_AMOUNT, FBT_SH_CESS_AMOUNT FBT_SH_CESS_AMOUNT, IT_CHALLAN IT_CHALLAN, BANK_NAME BANK_NAME, BRANCH_NAME BRANCH_NAME, DEPOSIT_DATE DEPOSIT_DATE, BSR_CODE BSR_CODE, 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 from "JA"."JAI_FBT_PAYMENT"

View Text - HTML Formatted

SELECT FBT_PAYMENT_ID FBT_PAYMENT_ID
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, FBT_YEAR FBT_YEAR
, STATUS_DATE STATUS_DATE
, INVOICE_REFERENCE INVOICE_REFERENCE
, INVOICE_DATE INVOICE_DATE
, INV_SUPPLIER_ID INV_SUPPLIER_ID
, INV_SUPPLIER_SITE_ID INV_SUPPLIER_SITE_ID
, INV_OU_ID INV_OU_ID
, FBT_TAX_AMOUNT FBT_TAX_AMOUNT
, FBT_SURCHARGE_AMOUNT FBT_SURCHARGE_AMOUNT
, FBT_EDU_CESS_AMOUNT FBT_EDU_CESS_AMOUNT
, FBT_SH_CESS_AMOUNT FBT_SH_CESS_AMOUNT
, IT_CHALLAN IT_CHALLAN
, BANK_NAME BANK_NAME
, BRANCH_NAME BRANCH_NAME
, DEPOSIT_DATE DEPOSIT_DATE
, BSR_CODE BSR_CODE
, 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
FROM "JA"."JAI_FBT_PAYMENT"