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: IGI.IGI_RPI_STANDING_CHARGES_ALL#

Source

View Text - Preformatted


select STANDING_CHARGE_ID STANDING_CHARGE_ID, CHARGE_REFERENCE CHARGE_REFERENCE, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, STANDING_CHARGE_DATE STANDING_CHARGE_DATE, STATUS STATUS, BILL_TO_CUSTOMER_ID BILL_TO_CUSTOMER_ID, BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID, BATCH_SOURCE_ID BATCH_SOURCE_ID, CUST_TRX_TYPE_ID CUST_TRX_TYPE_ID, SALESREP_ID SALESREP_ID, ADVANCE_ARREARS_IND ADVANCE_ARREARS_IND, PERIOD_NAME PERIOD_NAME, START_DATE START_DATE, NEXT_DUE_DATE NEXT_DUE_DATE, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, BILL_TO_CONTACT_ID BILL_TO_CONTACT_ID, SHIP_TO_CUSTOMER_ID SHIP_TO_CUSTOMER_ID, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID, SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID, REMINDER_DAYS REMINDER_DAYS, RECEIPT_METHOD_ID RECEIPT_METHOD_ID, BANK_ACCOUNT_ID BANK_ACCOUNT_ID, GENERATE_SEQUENCE GENERATE_SEQUENCE, TERM_ID TERM_ID, CURRENCY_CODE CURRENCY_CODE, ORG_ID ORG_ID, END_DATE END_DATE, REVIEW_DATE REVIEW_DATE, PREVIOUS_DUE_DATE PREVIOUS_DUE_DATE, SUPPRESS_INV_PRINT SUPPRESS_INV_PRINT, COMMENTS COMMENTS, DESCRIPTION DESCRIPTION, SHIP_TO_ADDRESS_ID SHIP_TO_ADDRESS_ID, BILL_TO_ADDRESS_ID BILL_TO_ADDRESS_ID, DATE_SYNCHRONIZED_FLAG DATE_SYNCHRONIZED_FLAG, DEFAULT_INVOICING_RULE DEFAULT_INVOICING_RULE, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, PAYMENT_TRXN_EXTENSION_ID PAYMENT_TRXN_EXTENSION_ID from "IGI"."IGI_RPI_STANDING_CHARGES_ALL"

View Text - HTML Formatted

SELECT STANDING_CHARGE_ID STANDING_CHARGE_ID
, CHARGE_REFERENCE CHARGE_REFERENCE
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, STANDING_CHARGE_DATE STANDING_CHARGE_DATE
, STATUS STATUS
, BILL_TO_CUSTOMER_ID BILL_TO_CUSTOMER_ID
, BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID
, BATCH_SOURCE_ID BATCH_SOURCE_ID
, CUST_TRX_TYPE_ID CUST_TRX_TYPE_ID
, SALESREP_ID SALESREP_ID
, ADVANCE_ARREARS_IND ADVANCE_ARREARS_IND
, PERIOD_NAME PERIOD_NAME
, START_DATE START_DATE
, NEXT_DUE_DATE NEXT_DUE_DATE
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, BILL_TO_CONTACT_ID BILL_TO_CONTACT_ID
, SHIP_TO_CUSTOMER_ID SHIP_TO_CUSTOMER_ID
, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
, SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID
, REMINDER_DAYS REMINDER_DAYS
, RECEIPT_METHOD_ID RECEIPT_METHOD_ID
, BANK_ACCOUNT_ID BANK_ACCOUNT_ID
, GENERATE_SEQUENCE GENERATE_SEQUENCE
, TERM_ID TERM_ID
, CURRENCY_CODE CURRENCY_CODE
, ORG_ID ORG_ID
, END_DATE END_DATE
, REVIEW_DATE REVIEW_DATE
, PREVIOUS_DUE_DATE PREVIOUS_DUE_DATE
, SUPPRESS_INV_PRINT SUPPRESS_INV_PRINT
, COMMENTS COMMENTS
, DESCRIPTION DESCRIPTION
, SHIP_TO_ADDRESS_ID SHIP_TO_ADDRESS_ID
, BILL_TO_ADDRESS_ID BILL_TO_ADDRESS_ID
, DATE_SYNCHRONIZED_FLAG DATE_SYNCHRONIZED_FLAG
, DEFAULT_INVOICING_RULE DEFAULT_INVOICING_RULE
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, PAYMENT_TRXN_EXTENSION_ID PAYMENT_TRXN_EXTENSION_ID
FROM "IGI"."IGI_RPI_STANDING_CHARGES_ALL"