IEX_DISPUTES_V

Details

• Schema: FUSION

• Object owner: IEX

• Object type: VIEW

Columns

Name

REQUEST_ID CUSTOMER_TRX_ID CM_CUSTOMER_TRX_ID URL LINE_CREDITS_FLAG LINE_AMOUNT TAX_AMOUNT FREIGHT_AMOUNT CM_REASON_CODE COMMENTS STATUS APPROVAL_DATE ORG_ID LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN TOTAL_AMOUNT TERMS_SEQUENCE_NUMBER TRANSACTION_URL ACTIVITIES_URL ORIG_TRX_NUMBER TAX_EX_CERT_NUM INTERFACE_HEADER_CONTEXT INTERFACE_HEADER_ATTRIBUTE1 INTERFACE_HEADER_ATTRIBUTE2 INTERFACE_HEADER_ATTRIBUTE3 INTERFACE_HEADER_ATTRIBUTE4 INTERFACE_HEADER_ATTRIBUTE5 INTERFACE_HEADER_ATTRIBUTE6 INTERFACE_HEADER_ATTRIBUTE7 INTERFACE_HEADER_ATTRIBUTE8 INTERFACE_HEADER_ATTRIBUTE9 INTERFACE_HEADER_ATTRIBUTE10 INTERFACE_HEADER_ATTRIBUTE11 INTERFACE_HEADER_ATTRIBUTE12 INTERFACE_HEADER_ATTRIBUTE13 INTERFACE_HEADER_ATTRIBUTE14 INTERFACE_HEADER_ATTRIBUTE15 ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE21 GLOBAL_ATTRIBUTE22 GLOBAL_ATTRIBUTE23 GLOBAL_ATTRIBUTE24 GLOBAL_ATTRIBUTE25 GLOBAL_ATTRIBUTE26 GLOBAL_ATTRIBUTE27 GLOBAL_ATTRIBUTE28 GLOBAL_ATTRIBUTE29 GLOBAL_ATTRIBUTE30 OBJECT_VERSION_NUMBER DISPUTE_TYPE_CODE DISPUTE_SECTION_CODE

Query

SQL_Statement

SELECT REQUEST_ID , CM.CUSTOMER_TRX_ID , CM.CM_CUSTOMER_TRX_ID , CM.URL , CM.LINE_CREDITS_FLAG , CM.LINE_AMOUNT , CM.TAX_AMOUNT , CM.FREIGHT_AMOUNT , CM.CM_REASON_CODE , CM.COMMENTS , CM.STATUS , CM.APPROVAL_DATE , CM.ORG_ID , CM.LAST_UPDATE_DATE , CM.LAST_UPDATED_BY , CM.CREATION_DATE , CM.CREATED_BY , CM.LAST_UPDATE_LOGIN , CM.TOTAL_AMOUNT , CM.TERMS_SEQUENCE_NUMBER , CM.TRANSACTION_URL , CM.ACTIVITIES_URL , CM.ORIG_TRX_NUMBER , CM.TAX_EX_CERT_NUM , CM.INTERFACE_HEADER_CONTEXT , CM.INTERFACE_HEADER_ATTRIBUTE1 , CM.INTERFACE_HEADER_ATTRIBUTE2 , CM.INTERFACE_HEADER_ATTRIBUTE3 , CM.INTERFACE_HEADER_ATTRIBUTE4 , CM.INTERFACE_HEADER_ATTRIBUTE5 , CM.INTERFACE_HEADER_ATTRIBUTE6 , CM.INTERFACE_HEADER_ATTRIBUTE7 , CM.INTERFACE_HEADER_ATTRIBUTE8 , CM.INTERFACE_HEADER_ATTRIBUTE9 , CM.INTERFACE_HEADER_ATTRIBUTE10 , CM.INTERFACE_HEADER_ATTRIBUTE11 , CM.INTERFACE_HEADER_ATTRIBUTE12 , CM.INTERFACE_HEADER_ATTRIBUTE13 , CM.INTERFACE_HEADER_ATTRIBUTE14 , CM.INTERFACE_HEADER_ATTRIBUTE15 , CM.ATTRIBUTE_CATEGORY , CM.ATTRIBUTE1 , CM.ATTRIBUTE2 , CM.ATTRIBUTE3 , CM.ATTRIBUTE4 , CM.ATTRIBUTE5 , CM.ATTRIBUTE6 , CM.ATTRIBUTE7 , CM.ATTRIBUTE8 , CM.ATTRIBUTE9 , CM.ATTRIBUTE10 , CM.ATTRIBUTE11 , CM.ATTRIBUTE12 , CM.ATTRIBUTE13 , CM.ATTRIBUTE14 , CM.ATTRIBUTE15 , CM.GLOBAL_ATTRIBUTE_CATEGORY , CM.GLOBAL_ATTRIBUTE1 , CM.GLOBAL_ATTRIBUTE2 , CM.GLOBAL_ATTRIBUTE3 , CM.GLOBAL_ATTRIBUTE4 , CM.GLOBAL_ATTRIBUTE5 , CM.GLOBAL_ATTRIBUTE6 , CM.GLOBAL_ATTRIBUTE7 , CM.GLOBAL_ATTRIBUTE8 , CM.GLOBAL_ATTRIBUTE9 , CM.GLOBAL_ATTRIBUTE10 , CM.GLOBAL_ATTRIBUTE11 , CM.GLOBAL_ATTRIBUTE12 , CM.GLOBAL_ATTRIBUTE13 , CM.GLOBAL_ATTRIBUTE14 , CM.GLOBAL_ATTRIBUTE15 , CM.GLOBAL_ATTRIBUTE16 , CM.GLOBAL_ATTRIBUTE17 , CM.GLOBAL_ATTRIBUTE18 , CM.GLOBAL_ATTRIBUTE19 , CM.GLOBAL_ATTRIBUTE20 , CM.GLOBAL_ATTRIBUTE21 , CM.GLOBAL_ATTRIBUTE22 , CM.GLOBAL_ATTRIBUTE23 , CM.GLOBAL_ATTRIBUTE24 , CM.GLOBAL_ATTRIBUTE25 , CM.GLOBAL_ATTRIBUTE26 , CM.GLOBAL_ATTRIBUTE27 , CM.GLOBAL_ATTRIBUTE28 , CM.GLOBAL_ATTRIBUTE29 , CM.GLOBAL_ATTRIBUTE30 , CM.OBJECT_VERSION_NUMBER , CM.DISPUTE_TYPE_CODE , CM.DISPUTE_SECTION_CODE FROM RA_CM_REQUESTS_ALL CM