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: AMS_AR_TRANSACTION_V

Product:	AMS - Marketing
Description:	Receivables Transactions
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT TRX.CUSTOMER_TRX_ID
, TRX.TRX_NUMBER
, TRX.TRX_DATE
, TRX.CUST_TRX_TYPE_ID
, TTY.NAME
, TRX.COMPLETE_FLAG
, TRX.BATCH_SOURCE_ID
, TRX.REASON_CODE
, TRX.CUSTOMER_REFERENCE
, TRX.CUSTOMER_REFERENCE_DATE
, TRX.SOLD_TO_CUSTOMER_ID
, HCC.ACCOUNT_NAME
, TRX.SOLD_TO_SITE_USE_ID
, HSC.SITE_USE_CODE
, TRX.SOLD_TO_CONTACT_ID
, TRX.BILL_TO_CUSTOMER_ID
, HCB.ACCOUNT_NAME
, TRX.BILL_TO_SITE_USE_ID
, HSB.SITE_USE_CODE
, TRX.BILL_TO_CONTACT_ID
, TRX.SHIP_TO_CUSTOMER_ID
, HCS.ACCOUNT_NAME
, TRX.SHIP_TO_SITE_USE_ID
, HSS.SITE_USE_CODE
, TRX.SHIP_TO_CONTACT_ID
, TRX.PREVIOUS_CUSTOMER_TRX_ID
, PTX.TRX_NUMBER
, TRX.PRIMARY_SALESREP_ID
, TRX.INVOICE_CURRENCY_CODE
, TRX.SHIP_DATE_ACTUAL
, TRX.WAYBILL_NUMBER
, TRX.TERM_ID
, TRM.NAME TERM_NAME
, TRX.TERM_DUE_DATE
, TRX.STATUS_TRX
, PAY.PAYMENT_SCHEDULE_ID
, PAY.DUE_DATE
, PAY.AMOUNT_DUE_ORIGINAL
, PAY.AMOUNT_DUE_REMAINING
, PAY.NUMBER_OF_DUE_DATES
, PAY.STATUS
, PAY.CLASS
, PAY.CASH_RECEIPT_ID
, PAY.TERMS_SEQUENCE_NUMBER
, PAY.AMOUNT_APPLIED
, PAY.AMOUNT_ADJUSTED
, PAY.AMOUNT_IN_DISPUTE
, PAY.AMOUNT_CREDITED
, PAY.RECEIVABLES_CHARGES_CHARGED
, PAY.RECEIVABLES_CHARGES_REMAINING
, PAY.FREIGHT_ORIGINAL
, PAY.FREIGHT_REMAINING
, PAY.TAX_ORIGINAL
, PAY.TAX_REMAINING
, PAY.DISCOUNT_ORIGINAL
, PAY.DISCOUNT_REMAINING
, PAY.DISCOUNT_TAKEN_EARNED
, PAY.DISCOUNT_TAKEN_UNEARNED
, PAY.IN_COLLECTION
, PAY.CONS_INV_ID FROM RA_CUSTOMER_TRX TRX
, RA_CUSTOMER_TRX PTX
, AR_PAYMENT_SCHEDULES PAY
, RA_CUST_TRX_TYPES TTY
, RA_TERMS TRM
, HZ_CUST_ACCOUNTS HCC
, HZ_CUST_ACCOUNTS HCB
, HZ_CUST_ACCOUNTS HCS
, HZ_CUST_SITE_USES HSC
, HZ_CUST_SITE_USES HSB
, HZ_CUST_SITE_USES HSS
WHERE TRX.CUSTOMER_TRX_ID = PAY.CUSTOMER_TRX_ID (+) AND TRX.CUST_TRX_TYPE_ID = TTY.CUST_TRX_TYPE_ID AND TRX.TERM_ID = TRM.TERM_ID AND TRX.CUSTOMER_TRX_ID = PTX.CUSTOMER_TRX_ID (+)
AND TRX.SOLD_TO_CUSTOMER_ID = HCC.CUST_ACCOUNT_ID
AND TRX.BILL_TO_CUSTOMER_ID = HCB.CUST_ACCOUNT_ID
AND TRX.SHIP_TO_CUSTOMER_ID = HCS.CUST_ACCOUNT_ID
AND TRX.SOLD_TO_SITE_USE_ID = HSC.SITE_USE_ID
AND TRX.BILL_TO_SITE_USE_ID = HSB.SITE_USE_ID
AND TRX.SHIP_TO_SITE_USE_ID = HSS.SITE_USE_ID

Columns

Name
CUSTOMER_TRX_ID
TRX_NUMBER
TRX_DATE
CUST_TRX_TYPE_ID
CUST_TRX_TYPE_NAME
COMPLETE_FLAG
BATCH_SOURCE_ID
REASON_CODE
CUSTOMER_REFERENCE
CUSTOMER_REFERENCE_DATE
SOLD_TO_CUSTOMER_ID
SOLD_ACCOUNT_NAME
SOLD_TO_SITE_USE_ID
SOLD_SITE_USE_CODE
SOLD_TO_CONTACT_ID
BILL_TO_CUSTOMER_ID
BILL_ACCOUNT_NAME
BILL_TO_SITE_USE_ID
BILL_SITE_USE_CODE
BILL_TO_CONTACT_ID
SHIP_TO_CUSTOMER_ID
SHIP_ACCOUNT_NAME
SHIP_TO_SITE_USE_ID
SHIP_SITE_USE_CODE
SHIP_TO_CONTACT_ID
PREVIOUS_CUSTOMER_TRX_ID
PERVIOUS_TRX_NUMBER
PRIMARY_SALESREP_ID
INVOICE_CURRENCY_CODE
SHIP_DATE_ACTUAL
WAYBILL_NUMBER
TERM_ID
TERM_NAME
TERM_DUE_DATE
STATUS_TRX
PAYMENT_SCHEDULE_ID
DUE_DATE
AMOUNT_DUE_ORIGINAL
AMOUNT_DUE_REMAINING
NUMBER_OF_DUE_DATES
STATUS
CLASS
CASH_RECEIPT_ID
TERMS_SEQUENCE_NUMBER
AMOUNT_APPLIED
AMOUNT_ADJUSTED
AMOUNT_IN_DISPUTE
AMOUNT_CREDITED
RECEIVABLES_CHARGES_CHARGED
RECEIVABLES_CHARGES_REMAINING
FREIGHT_ORIGINAL
FREIGHT_REMAINING
TAX_ORIGINAL
TAX_REMAINING
DISCOUNT_ORIGINAL
DISCOUNT_REMAINING
DISCOUNT_TAKEN_EARNED
DISCOUNT_TAKEN_UNEARNED
IN_COLLECTION
CONS_INV_ID