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_SETTLEMENT#

Source

View Text - Preformatted


select LEGAL_ENTITY_ID LEGAL_ENTITY_ID, PERIOD_START_DATE PERIOD_START_DATE, PERIOD_END_DATE PERIOD_END_DATE, CONSOLIDATED_AMOUNT CONSOLIDATED_AMOUNT, PROJECTED_AMOUNT PROJECTED_AMOUNT, SETTLEMENT_DATE SETTLEMENT_DATE, INV_SUPPLIER_ID INV_SUPPLIER_ID, INV_SUPPLIER_SITE_ID INV_SUPPLIER_SITE_ID, INV_OU_ID INV_OU_ID, IT_CHALLAN IT_CHALLAN, RETURN_GENERATE_FLAG RETURN_GENERATE_FLAG, 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, DEPOSIT_DATE DEPOSIT_DATE, BANK_NAME BANK_NAME, BRANCH_NAME BRANCH_NAME, SETTLEMENT_ID SETTLEMENT_ID from "JA"."JAI_FBT_SETTLEMENT"

View Text - HTML Formatted

SELECT LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, PERIOD_START_DATE PERIOD_START_DATE
, PERIOD_END_DATE PERIOD_END_DATE
, CONSOLIDATED_AMOUNT CONSOLIDATED_AMOUNT
, PROJECTED_AMOUNT PROJECTED_AMOUNT
, SETTLEMENT_DATE SETTLEMENT_DATE
, INV_SUPPLIER_ID INV_SUPPLIER_ID
, INV_SUPPLIER_SITE_ID INV_SUPPLIER_SITE_ID
, INV_OU_ID INV_OU_ID
, IT_CHALLAN IT_CHALLAN
, RETURN_GENERATE_FLAG RETURN_GENERATE_FLAG
, 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
, DEPOSIT_DATE DEPOSIT_DATE
, BANK_NAME BANK_NAME
, BRANCH_NAME BRANCH_NAME
, SETTLEMENT_ID SETTLEMENT_ID
FROM "JA"."JAI_FBT_SETTLEMENT"