VIEW: AR.AR_TRANSACTIONS_REP_ITF#

Source

View Text - Preformatted

select REQUEST_ID REQUEST_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ORGANIZATION_NAME ORGANIZATION_NAME, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE, CUSTOMER_TRX_ID CUSTOMER_TRX_ID, TRX_NUMBER TRX_NUMBER, CONS_BILL_NUMBER CONS_BILL_NUMBER, REC_CUST_TRX_LINE_GL_DIST_ID REC_CUST_TRX_LINE_GL_DIST_ID, REC_ACCOUNT REC_ACCOUNT, REC_ACCOUNT_DESC REC_ACCOUNT_DESC, REC_BALANCE REC_BALANCE, REC_BALANCE_DESC REC_BALANCE_DESC, REC_NATACCT REC_NATACCT, REC_NATACCT_DESC REC_NATACCT_DESC, REC_POSTABLE_FLAG REC_POSTABLE_FLAG, TRX_LAST_UPDATED_BY TRX_LAST_UPDATED_BY, TRX_LAST_UPDATE_DATE TRX_LAST_UPDATE_DATE, CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID, LINK_TO_CUST_TRX_LINE_ID LINK_TO_CUST_TRX_LINE_ID, INVENTORY_ITEM INVENTORY_ITEM, CUST_TRX_LINE_GL_DIST_ID CUST_TRX_LINE_GL_DIST_ID, ACCOUNT ACCOUNT, ACCOUNT_DESC ACCOUNT_DESC, BALANCE BALANCE, BALANCE_DESC BALANCE_DESC, NATACCT NATACCT, NATACCT_DESC NATACCT_DESC, TRX_PAYMENT_SCHEDULE_ID TRX_PAYMENT_SCHEDULE_ID, ITEM_DESCRIPTION ITEM_DESCRIPTION, TRX_DATE TRX_DATE, TRX_CURRENCY TRX_CURRENCY, EXCHANGE_RATE EXCHANGE_RATE, EXCHANGE_DATE EXCHANGE_DATE, EXCHANGE_TYPE EXCHANGE_TYPE, RECEIVABLES_GL_DATE RECEIVABLES_GL_DATE, TRX_DUE_DATE TRX_DUE_DATE, TAX_HEADER_LEVEL_FLAG TAX_HEADER_LEVEL_FLAG, DOC_SEQUENCE_VALUE DOC_SEQUENCE_VALUE, TRX_AMOUNT TRX_AMOUNT, TRX_ACCTD_AMOUNT TRX_ACCTD_AMOUNT, SHIP_TO_CUSTOMER_ID SHIP_TO_CUSTOMER_ID, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID, BILL_TO_CUSTOMER_ID BILL_TO_CUSTOMER_ID, BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID, CUST_TRX_TYPE_ID CUST_TRX_TYPE_ID, TERM_ID TERM_ID, DOC_SEQUENCE_ID DOC_SEQUENCE_ID, RECEIPT_METHOD_ID RECEIPT_METHOD_ID, ORG_ID ORG_ID, BATCH_ID BATCH_ID, BATCH_SOURCE_ID BATCH_SOURCE_ID from "AR"."AR_TRANSACTIONS_REP_ITF"

View Text - HTML Formatted

SELECT REQUEST_ID REQUEST_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ORGANIZATION_NAME ORGANIZATION_NAME
, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE
, CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, TRX_NUMBER TRX_NUMBER
, CONS_BILL_NUMBER CONS_BILL_NUMBER
, REC_CUST_TRX_LINE_GL_DIST_ID REC_CUST_TRX_LINE_GL_DIST_ID
, REC_ACCOUNT REC_ACCOUNT
, REC_ACCOUNT_DESC REC_ACCOUNT_DESC
, REC_BALANCE REC_BALANCE
, REC_BALANCE_DESC REC_BALANCE_DESC
, REC_NATACCT REC_NATACCT
, REC_NATACCT_DESC REC_NATACCT_DESC
, REC_POSTABLE_FLAG REC_POSTABLE_FLAG
, TRX_LAST_UPDATED_BY TRX_LAST_UPDATED_BY
, TRX_LAST_UPDATE_DATE TRX_LAST_UPDATE_DATE
, CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID
, LINK_TO_CUST_TRX_LINE_ID LINK_TO_CUST_TRX_LINE_ID
, INVENTORY_ITEM INVENTORY_ITEM
, CUST_TRX_LINE_GL_DIST_ID CUST_TRX_LINE_GL_DIST_ID
, ACCOUNT ACCOUNT
, ACCOUNT_DESC ACCOUNT_DESC
, BALANCE BALANCE
, BALANCE_DESC BALANCE_DESC
, NATACCT NATACCT
, NATACCT_DESC NATACCT_DESC
, TRX_PAYMENT_SCHEDULE_ID TRX_PAYMENT_SCHEDULE_ID
, ITEM_DESCRIPTION ITEM_DESCRIPTION
, TRX_DATE TRX_DATE
, TRX_CURRENCY TRX_CURRENCY
, EXCHANGE_RATE EXCHANGE_RATE
, EXCHANGE_DATE EXCHANGE_DATE
, EXCHANGE_TYPE EXCHANGE_TYPE
, RECEIVABLES_GL_DATE RECEIVABLES_GL_DATE
, TRX_DUE_DATE TRX_DUE_DATE
, TAX_HEADER_LEVEL_FLAG TAX_HEADER_LEVEL_FLAG
, DOC_SEQUENCE_VALUE DOC_SEQUENCE_VALUE
, TRX_AMOUNT TRX_AMOUNT
, TRX_ACCTD_AMOUNT TRX_ACCTD_AMOUNT
, SHIP_TO_CUSTOMER_ID SHIP_TO_CUSTOMER_ID
, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
, BILL_TO_CUSTOMER_ID BILL_TO_CUSTOMER_ID
, BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID
, CUST_TRX_TYPE_ID CUST_TRX_TYPE_ID
, TERM_ID TERM_ID
, DOC_SEQUENCE_ID DOC_SEQUENCE_ID
, RECEIPT_METHOD_ID RECEIPT_METHOD_ID
, ORG_ID ORG_ID
, BATCH_ID BATCH_ID
, BATCH_SOURCE_ID BATCH_SOURCE_ID
FROM "AR"."AR_TRANSACTIONS_REP_ITF"