VIEW: AR.RA_CUST_TRX_LINE_GL_DIST_ALL#

Source

View Text - Preformatted

select CUST_TRX_LINE_GL_DIST_ID CUST_TRX_LINE_GL_DIST_ID, CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID, CODE_COMBINATION_ID CODE_COMBINATION_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PERCENT PERCENT, AMOUNT AMOUNT, GL_DATE GL_DATE, GL_POSTED_DATE GL_POSTED_DATE, CUST_TRX_LINE_SALESREP_ID CUST_TRX_LINE_SALESREP_ID, COMMENTS COMMENTS, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, CONCATENATED_SEGMENTS CONCATENATED_SEGMENTS, ORIGINAL_GL_DATE ORIGINAL_GL_DATE, POST_REQUEST_ID POST_REQUEST_ID, POSTING_CONTROL_ID POSTING_CONTROL_ID, ACCOUNT_CLASS ACCOUNT_CLASS, RA_POST_LOOP_NUMBER RA_POST_LOOP_NUMBER, CUSTOMER_TRX_ID CUSTOMER_TRX_ID, ACCOUNT_SET_FLAG ACCOUNT_SET_FLAG, ACCTD_AMOUNT ACCTD_AMOUNT, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, USSGL_TRANSACTION_CODE_CONTEXT USSGL_TRANSACTION_CODE_CONTEXT, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, LATEST_REC_FLAG LATEST_REC_FLAG, ORG_ID ORG_ID, MRC_ACCOUNT_CLASS MRC_ACCOUNT_CLASS, MRC_CUSTOMER_TRX_ID MRC_CUSTOMER_TRX_ID, MRC_AMOUNT MRC_AMOUNT, MRC_GL_POSTED_DATE MRC_GL_POSTED_DATE, MRC_POSTING_CONTROL_ID MRC_POSTING_CONTROL_ID, MRC_ACCTD_AMOUNT MRC_ACCTD_AMOUNT, COLLECTED_TAX_CCID COLLECTED_TAX_CCID, COLLECTED_TAX_CONCAT_SEG COLLECTED_TAX_CONCAT_SEG, REVENUE_ADJUSTMENT_ID REVENUE_ADJUSTMENT_ID, REV_ADJ_CLASS_TEMP REV_ADJ_CLASS_TEMP, REC_OFFSET_FLAG REC_OFFSET_FLAG, EVENT_ID EVENT_ID, USER_GENERATED_FLAG USER_GENERATED_FLAG, ROUNDING_CORRECTION_FLAG ROUNDING_CORRECTION_FLAG, COGS_REQUEST_ID COGS_REQUEST_ID, CCID_CHANGE_FLAG CCID_CHANGE_FLAG, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20, GLOBAL_ATTRIBUTE21 GLOBAL_ATTRIBUTE21, GLOBAL_ATTRIBUTE22 GLOBAL_ATTRIBUTE22, GLOBAL_ATTRIBUTE23 GLOBAL_ATTRIBUTE23, GLOBAL_ATTRIBUTE24 GLOBAL_ATTRIBUTE24, GLOBAL_ATTRIBUTE25 GLOBAL_ATTRIBUTE25, GLOBAL_ATTRIBUTE26 GLOBAL_ATTRIBUTE26, GLOBAL_ATTRIBUTE27 GLOBAL_ATTRIBUTE27, GLOBAL_ATTRIBUTE28 GLOBAL_ATTRIBUTE28, GLOBAL_ATTRIBUTE29 GLOBAL_ATTRIBUTE29, GLOBAL_ATTRIBUTE30 GLOBAL_ATTRIBUTE30, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY from "AR"."RA_CUST_TRX_LINE_GL_DIST_ALL"

View Text - HTML Formatted

SELECT CUST_TRX_LINE_GL_DIST_ID CUST_TRX_LINE_GL_DIST_ID
, CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PERCENT PERCENT
, AMOUNT AMOUNT
, GL_DATE GL_DATE
, GL_POSTED_DATE GL_POSTED_DATE
, CUST_TRX_LINE_SALESREP_ID CUST_TRX_LINE_SALESREP_ID
, COMMENTS COMMENTS
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CONCATENATED_SEGMENTS CONCATENATED_SEGMENTS
, ORIGINAL_GL_DATE ORIGINAL_GL_DATE
, POST_REQUEST_ID POST_REQUEST_ID
, POSTING_CONTROL_ID POSTING_CONTROL_ID
, ACCOUNT_CLASS ACCOUNT_CLASS
, RA_POST_LOOP_NUMBER RA_POST_LOOP_NUMBER
, CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, ACCOUNT_SET_FLAG ACCOUNT_SET_FLAG
, ACCTD_AMOUNT ACCTD_AMOUNT
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, USSGL_TRANSACTION_CODE_CONTEXT USSGL_TRANSACTION_CODE_CONTEXT
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, LATEST_REC_FLAG LATEST_REC_FLAG
, ORG_ID ORG_ID
, MRC_ACCOUNT_CLASS MRC_ACCOUNT_CLASS
, MRC_CUSTOMER_TRX_ID MRC_CUSTOMER_TRX_ID
, MRC_AMOUNT MRC_AMOUNT
, MRC_GL_POSTED_DATE MRC_GL_POSTED_DATE
, MRC_POSTING_CONTROL_ID MRC_POSTING_CONTROL_ID
, MRC_ACCTD_AMOUNT MRC_ACCTD_AMOUNT
, COLLECTED_TAX_CCID COLLECTED_TAX_CCID
, COLLECTED_TAX_CONCAT_SEG COLLECTED_TAX_CONCAT_SEG
, REVENUE_ADJUSTMENT_ID REVENUE_ADJUSTMENT_ID
, REV_ADJ_CLASS_TEMP REV_ADJ_CLASS_TEMP
, REC_OFFSET_FLAG REC_OFFSET_FLAG
, EVENT_ID EVENT_ID
, USER_GENERATED_FLAG USER_GENERATED_FLAG
, ROUNDING_CORRECTION_FLAG ROUNDING_CORRECTION_FLAG
, COGS_REQUEST_ID COGS_REQUEST_ID
, CCID_CHANGE_FLAG CCID_CHANGE_FLAG
, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE21 GLOBAL_ATTRIBUTE21
, GLOBAL_ATTRIBUTE22 GLOBAL_ATTRIBUTE22
, GLOBAL_ATTRIBUTE23 GLOBAL_ATTRIBUTE23
, GLOBAL_ATTRIBUTE24 GLOBAL_ATTRIBUTE24
, GLOBAL_ATTRIBUTE25 GLOBAL_ATTRIBUTE25
, GLOBAL_ATTRIBUTE26 GLOBAL_ATTRIBUTE26
, GLOBAL_ATTRIBUTE27 GLOBAL_ATTRIBUTE27
, GLOBAL_ATTRIBUTE28 GLOBAL_ATTRIBUTE28
, GLOBAL_ATTRIBUTE29 GLOBAL_ATTRIBUTE29
, GLOBAL_ATTRIBUTE30 GLOBAL_ATTRIBUTE30
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
FROM "AR"."RA_CUST_TRX_LINE_GL_DIST_ALL"