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: CN.CN_TRX_ALL#

Source

View Text - Preformatted


select ORG_ID ORG_ID, STATUS STATUS, COLLECTION_RUN_ID COLLECTION_RUN_ID, LINK_RUN_ID LINK_RUN_ID, SOURCE_TRX_ID SOURCE_TRX_ID, SOURCE_PARENT_TRX_ID SOURCE_PARENT_TRX_ID, SOURCE_PAYMENT_SCHEDULE_ID SOURCE_PAYMENT_SCHEDULE_ID, ROOT_TRX_ID ROOT_TRX_ID, PARENT_TRX_ID PARENT_TRX_ID, TRX_ID TRX_ID, GL_DATE GL_DATE, GL_POSTED_DATE GL_POSTED_DATE, COLLECTED_DATE COLLECTED_DATE, NOTIFIED_DATE NOTIFIED_DATE, PROCESSED_DATE PROCESSED_DATE, COMP_PLAN_PERIOD COMP_PLAN_PERIOD, ROLLUP_PERIOD ROLLUP_PERIOD, PROCESSED_PERIOD PROCESSED_PERIOD, LINE_AMOUNT_APPLIED LINE_AMOUNT_APPLIED, PRORATED_AMOUNT PRORATED_AMOUNT, INVOICE_TOTAL INVOICE_TOTAL, BATCH_SOURCE_TYPE BATCH_SOURCE_TYPE, TRX_TYPE_ID TRX_TYPE_ID, TRX_TYPE TRX_TYPE, PURCHASE_ORDER PURCHASE_ORDER, SALE_DATE SALE_DATE, BILL_TO_CUSTOMER_NAME BILL_TO_CUSTOMER_NAME, BILL_TO_CUSTOMER_ID BILL_TO_CUSTOMER_ID, SOLD_TO_CUSTOMER_NAME SOLD_TO_CUSTOMER_NAME, SOLD_TO_CUSTOMER_ID SOLD_TO_CUSTOMER_ID, SOURCE_ORIG_TRX_NUMBER SOURCE_ORIG_TRX_NUMBER, SOURCE_ORIG_TRX_TYPE#1 SOURCE_ORIG_TRX_TYPE, SOURCE_TRX_NUMBER SOURCE_TRX_NUMBER, DATE_ORDERED DATE_ORDERED, AGREEMENT_TYPE_ID AGREEMENT_TYPE_ID, ARREARS_OR_ADVANCE_INV ARREARS_OR_ADVANCE_INV, ORIG_COMMITMENT_TRX_ID ORIG_COMMITMENT_TRX_ID, SPARE_COLUMN1 SPARE_COLUMN1, SPARE_COLUMN2 SPARE_COLUMN2, ORIG_COMMITMENT_TRX_NUMBER ORIG_COMMITMENT_TRX_NUMBER, ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE, BATCH_SOURCE_ID BATCH_SOURCE_ID, INVOICE_SOURCE INVOICE_SOURCE, TRANSFERRED_FLAG TRANSFERRED_FLAG, EXCEPTION_FLAG EXCEPTION_FLAG, EVENT_ID EVENT_ID, BATCH_ID BATCH_ID, COL_SYSTEM_ID COL_SYSTEM_ID, COL_SYSTEM_TRX_ID COL_SYSTEM_TRX_ID, SALES_ORDER#1 SALES_ORDER, TRX_DATE TRX_DATE, NOT_TRX_ID NOT_TRX_ID, TRANSFER_BATCH_ID TRANSFER_BATCH_ID, DUE_DATE DUE_DATE, BOTH_NON_ZERO_REV_ACCTS BOTH_NON_ZERO_REV_ACCTS, NOT_100_PERCENT_EXCEPTION NOT_100_PERCENT_EXCEPTION, NO_REV_ACCT_EXCEPTION NO_REV_ACCT_EXCEPTION, ROLLUP_DATE ROLLUP_DATE, TRANSFER_RUN_ID TRANSFER_RUN_ID, ADJUSTMENT_FLAG ADJUSTMENT_FLAG, ADJUSTMENT_HEADER_ID ADJUSTMENT_HEADER_ID, 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, TRANSACTION_CURRENCY_CODE TRANSACTION_CURRENCY_CODE, EXCHANGE_RATE EXCHANGE_RATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, SECURITY_GROUP_ID SECURITY_GROUP_ID, ADJ_COLLECTION_RUN_ID ADJ_COLLECTION_RUN_ID from "CN"."CN_TRX_ALL"

View Text - HTML Formatted

SELECT ORG_ID ORG_ID
, STATUS STATUS
, COLLECTION_RUN_ID COLLECTION_RUN_ID
, LINK_RUN_ID LINK_RUN_ID
, SOURCE_TRX_ID SOURCE_TRX_ID
, SOURCE_PARENT_TRX_ID SOURCE_PARENT_TRX_ID
, SOURCE_PAYMENT_SCHEDULE_ID SOURCE_PAYMENT_SCHEDULE_ID
, ROOT_TRX_ID ROOT_TRX_ID
, PARENT_TRX_ID PARENT_TRX_ID
, TRX_ID TRX_ID
, GL_DATE GL_DATE
, GL_POSTED_DATE GL_POSTED_DATE
, COLLECTED_DATE COLLECTED_DATE
, NOTIFIED_DATE NOTIFIED_DATE
, PROCESSED_DATE PROCESSED_DATE
, COMP_PLAN_PERIOD COMP_PLAN_PERIOD
, ROLLUP_PERIOD ROLLUP_PERIOD
, PROCESSED_PERIOD PROCESSED_PERIOD
, LINE_AMOUNT_APPLIED LINE_AMOUNT_APPLIED
, PRORATED_AMOUNT PRORATED_AMOUNT
, INVOICE_TOTAL INVOICE_TOTAL
, BATCH_SOURCE_TYPE BATCH_SOURCE_TYPE
, TRX_TYPE_ID TRX_TYPE_ID
, TRX_TYPE TRX_TYPE
, PURCHASE_ORDER PURCHASE_ORDER
, SALE_DATE SALE_DATE
, BILL_TO_CUSTOMER_NAME BILL_TO_CUSTOMER_NAME
, BILL_TO_CUSTOMER_ID BILL_TO_CUSTOMER_ID
, SOLD_TO_CUSTOMER_NAME SOLD_TO_CUSTOMER_NAME
, SOLD_TO_CUSTOMER_ID SOLD_TO_CUSTOMER_ID
, SOURCE_ORIG_TRX_NUMBER SOURCE_ORIG_TRX_NUMBER
, SOURCE_ORIG_TRX_TYPE#1 SOURCE_ORIG_TRX_TYPE
, SOURCE_TRX_NUMBER SOURCE_TRX_NUMBER
, DATE_ORDERED DATE_ORDERED
, AGREEMENT_TYPE_ID AGREEMENT_TYPE_ID
, ARREARS_OR_ADVANCE_INV ARREARS_OR_ADVANCE_INV
, ORIG_COMMITMENT_TRX_ID ORIG_COMMITMENT_TRX_ID
, SPARE_COLUMN1 SPARE_COLUMN1
, SPARE_COLUMN2 SPARE_COLUMN2
, ORIG_COMMITMENT_TRX_NUMBER ORIG_COMMITMENT_TRX_NUMBER
, ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE
, BATCH_SOURCE_ID BATCH_SOURCE_ID
, INVOICE_SOURCE INVOICE_SOURCE
, TRANSFERRED_FLAG TRANSFERRED_FLAG
, EXCEPTION_FLAG EXCEPTION_FLAG
, EVENT_ID EVENT_ID
, BATCH_ID BATCH_ID
, COL_SYSTEM_ID COL_SYSTEM_ID
, COL_SYSTEM_TRX_ID COL_SYSTEM_TRX_ID
, SALES_ORDER#1 SALES_ORDER
, TRX_DATE TRX_DATE
, NOT_TRX_ID NOT_TRX_ID
, TRANSFER_BATCH_ID TRANSFER_BATCH_ID
, DUE_DATE DUE_DATE
, BOTH_NON_ZERO_REV_ACCTS BOTH_NON_ZERO_REV_ACCTS
, NOT_100_PERCENT_EXCEPTION NOT_100_PERCENT_EXCEPTION
, NO_REV_ACCT_EXCEPTION NO_REV_ACCT_EXCEPTION
, ROLLUP_DATE ROLLUP_DATE
, TRANSFER_RUN_ID TRANSFER_RUN_ID
, ADJUSTMENT_FLAG ADJUSTMENT_FLAG
, ADJUSTMENT_HEADER_ID ADJUSTMENT_HEADER_ID
, 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
, TRANSACTION_CURRENCY_CODE TRANSACTION_CURRENCY_CODE
, EXCHANGE_RATE EXCHANGE_RATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, ADJ_COLLECTION_RUN_ID ADJ_COLLECTION_RUN_ID
FROM "CN"."CN_TRX_ALL"