VIEW: FV.FV_IPAC_TRX_ALL#

Source

View Text - Preformatted

select CUSTOMER_TRX_ID CUSTOMER_TRX_ID, CUSTOMER_ID CUSTOMER_ID, ADJUSTMENT_ID ADJUSTMENT_ID, CUSTOMER_NAME CUSTOMER_NAME, TAXPAYER_NUMBER TAXPAYER_NUMBER, TRX_NUMBER TRX_NUMBER, TRX_DATE TRX_DATE, TRX_LINE_NO TRX_LINE_NO, AMOUNT AMOUNT, PO_NUMBER PO_NUMBER, CONTRACT_NO CONTRACT_NO, CLIN CLIN, SENDER_ALC SENDER_ALC, SENDER_DO_SYM SENDER_DO_SYM, TRN_SET_ID TRN_SET_ID, ORG_DCM_RFR ORG_DCM_RFR, ORG_DO_SYM ORG_DO_SYM, ORG_ACC_DT ORG_ACC_DT, DPR_CD DPR_CD, DSC DSC, OBL_DCM_NR OBL_DCM_NR, PAY_FLG PAY_FLG, QTY QTY, SND_APP_SYM SND_APP_SYM, UNT_ISS UNT_ISS, UNT_PRC UNT_PRC, ORG_LN_ITM ORG_LN_ITM, EXCLUDE_FLAG EXCLUDE_FLAG, PROCESSED_FLAG PROCESSED_FLAG, RUN_DATE RUN_DATE, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, EXCEPTION_CATEGORY EXCEPTION_CATEGORY, ORG_ID ORG_ID, CNT_NM CNT_NM, CNT_PHN_NR CNT_PHN_NR, 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, REPORT_FLAG REPORT_FLAG, 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, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, ATTRIBUTE21 ATTRIBUTE21, ATTRIBUTE22 ATTRIBUTE22, ATTRIBUTE23 ATTRIBUTE23, ATTRIBUTE24 ATTRIBUTE24, ATTRIBUTE25 ATTRIBUTE25, ATTRIBUTE26 ATTRIBUTE26, ATTRIBUTE27 ATTRIBUTE27, ATTRIBUTE28 ATTRIBUTE28, ATTRIBUTE29 ATTRIBUTE29, ATTRIBUTE30 ATTRIBUTE30, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, IPAC_BILLING_ID IPAC_BILLING_ID, SGL_ACCT_NUM SGL_ACCT_NUM, CR_DR_FLAG CR_DR_FLAG, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, CUST_DUNS_NUM CUST_DUNS_NUM, ACCOUNT_CLASS ACCOUNT_CLASS, CASH_RECEIPT_ID CASH_RECEIPT_ID, RECEIPT_FLAG RECEIPT_FLAG, BULK_EXCEPTION BULK_EXCEPTION, ACCOUNTED_FLAG ACCOUNTED_FLAG from "FV"."FV_IPAC_TRX_ALL"

View Text - HTML Formatted

SELECT CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, CUSTOMER_ID CUSTOMER_ID
, ADJUSTMENT_ID ADJUSTMENT_ID
, CUSTOMER_NAME CUSTOMER_NAME
, TAXPAYER_NUMBER TAXPAYER_NUMBER
, TRX_NUMBER TRX_NUMBER
, TRX_DATE TRX_DATE
, TRX_LINE_NO TRX_LINE_NO
, AMOUNT AMOUNT
, PO_NUMBER PO_NUMBER
, CONTRACT_NO CONTRACT_NO
, CLIN CLIN
, SENDER_ALC SENDER_ALC
, SENDER_DO_SYM SENDER_DO_SYM
, TRN_SET_ID TRN_SET_ID
, ORG_DCM_RFR ORG_DCM_RFR
, ORG_DO_SYM ORG_DO_SYM
, ORG_ACC_DT ORG_ACC_DT
, DPR_CD DPR_CD
, DSC DSC
, OBL_DCM_NR OBL_DCM_NR
, PAY_FLG PAY_FLG
, QTY QTY
, SND_APP_SYM SND_APP_SYM
, UNT_ISS UNT_ISS
, UNT_PRC UNT_PRC
, ORG_LN_ITM ORG_LN_ITM
, EXCLUDE_FLAG EXCLUDE_FLAG
, PROCESSED_FLAG PROCESSED_FLAG
, RUN_DATE RUN_DATE
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, EXCEPTION_CATEGORY EXCEPTION_CATEGORY
, ORG_ID ORG_ID
, CNT_NM CNT_NM
, CNT_PHN_NR CNT_PHN_NR
, 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
, REPORT_FLAG REPORT_FLAG
, 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
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, ATTRIBUTE21 ATTRIBUTE21
, ATTRIBUTE22 ATTRIBUTE22
, ATTRIBUTE23 ATTRIBUTE23
, ATTRIBUTE24 ATTRIBUTE24
, ATTRIBUTE25 ATTRIBUTE25
, ATTRIBUTE26 ATTRIBUTE26
, ATTRIBUTE27 ATTRIBUTE27
, ATTRIBUTE28 ATTRIBUTE28
, ATTRIBUTE29 ATTRIBUTE29
, ATTRIBUTE30 ATTRIBUTE30
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, IPAC_BILLING_ID IPAC_BILLING_ID
, SGL_ACCT_NUM SGL_ACCT_NUM
, CR_DR_FLAG CR_DR_FLAG
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, CUST_DUNS_NUM CUST_DUNS_NUM
, ACCOUNT_CLASS ACCOUNT_CLASS
, CASH_RECEIPT_ID CASH_RECEIPT_ID
, RECEIPT_FLAG RECEIPT_FLAG
, BULK_EXCEPTION BULK_EXCEPTION
, ACCOUNTED_FLAG ACCOUNTED_FLAG
FROM "FV"."FV_IPAC_TRX_ALL"