VIEW: AR.AR_ADJUSTMENTS_ALL#

Source

View Text - Preformatted

select ADJUSTMENT_ID ADJUSTMENT_ID, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, AMOUNT AMOUNT, APPLY_DATE APPLY_DATE, GL_DATE GL_DATE, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, CODE_COMBINATION_ID CODE_COMBINATION_ID, TYPE TYPE, ADJUSTMENT_TYPE ADJUSTMENT_TYPE, STATUS STATUS, LINE_ADJUSTED LINE_ADJUSTED, FREIGHT_ADJUSTED FREIGHT_ADJUSTED, TAX_ADJUSTED TAX_ADJUSTED, RECEIVABLES_CHARGES_ADJUSTED RECEIVABLES_CHARGES_ADJUSTED, ASSOCIATED_CASH_RECEIPT_ID ASSOCIATED_CASH_RECEIPT_ID, CHARGEBACK_CUSTOMER_TRX_ID CHARGEBACK_CUSTOMER_TRX_ID, BATCH_ID BATCH_ID, CUSTOMER_TRX_ID CUSTOMER_TRX_ID, CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID, SUBSEQUENT_TRX_ID SUBSEQUENT_TRX_ID, PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID, RECEIVABLES_TRX_ID RECEIVABLES_TRX_ID, DISTRIBUTION_SET_ID DISTRIBUTION_SET_ID, GL_POSTED_DATE GL_POSTED_DATE, COMMENTS COMMENTS, AUTOMATICALLY_GENERATED AUTOMATICALLY_GENERATED, CREATED_FROM CREATED_FROM, REASON_CODE REASON_CODE, POSTABLE POSTABLE, APPROVED_BY APPROVED_BY, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, POSTING_CONTROL_ID POSTING_CONTROL_ID, ACCTD_AMOUNT ACCTD_AMOUNT, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, ADJUSTMENT_NUMBER ADJUSTMENT_NUMBER, ORG_ID ORG_ID, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, USSGL_TRANSACTION_CODE_CONTEXT USSGL_TRANSACTION_CODE_CONTEXT, DOC_SEQUENCE_VALUE DOC_SEQUENCE_VALUE, DOC_SEQUENCE_ID DOC_SEQUENCE_ID, ASSOCIATED_APPLICATION_ID ASSOCIATED_APPLICATION_ID, CONS_INV_ID CONS_INV_ID, MRC_GL_POSTED_DATE MRC_GL_POSTED_DATE, MRC_POSTING_CONTROL_ID MRC_POSTING_CONTROL_ID, MRC_ACCTD_AMOUNT MRC_ACCTD_AMOUNT, ADJ_TAX_ACCT_RULE ADJ_TAX_ACCT_RULE, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, 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, LINK_TO_TRX_HIST_ID LINK_TO_TRX_HIST_ID, EVENT_ID EVENT_ID, UPGRADE_METHOD UPGRADE_METHOD, AX_ACCOUNTED_FLAG AX_ACCOUNTED_FLAG, INTEREST_HEADER_ID INTEREST_HEADER_ID, INTEREST_LINE_ID INTEREST_LINE_ID from "AR"."AR_ADJUSTMENTS_ALL"

View Text - HTML Formatted

SELECT ADJUSTMENT_ID ADJUSTMENT_ID
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, AMOUNT AMOUNT
, APPLY_DATE APPLY_DATE
, GL_DATE GL_DATE
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, TYPE TYPE
, ADJUSTMENT_TYPE ADJUSTMENT_TYPE
, STATUS STATUS
, LINE_ADJUSTED LINE_ADJUSTED
, FREIGHT_ADJUSTED FREIGHT_ADJUSTED
, TAX_ADJUSTED TAX_ADJUSTED
, RECEIVABLES_CHARGES_ADJUSTED RECEIVABLES_CHARGES_ADJUSTED
, ASSOCIATED_CASH_RECEIPT_ID ASSOCIATED_CASH_RECEIPT_ID
, CHARGEBACK_CUSTOMER_TRX_ID CHARGEBACK_CUSTOMER_TRX_ID
, BATCH_ID BATCH_ID
, CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID
, SUBSEQUENT_TRX_ID SUBSEQUENT_TRX_ID
, PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID
, RECEIVABLES_TRX_ID RECEIVABLES_TRX_ID
, DISTRIBUTION_SET_ID DISTRIBUTION_SET_ID
, GL_POSTED_DATE GL_POSTED_DATE
, COMMENTS COMMENTS
, AUTOMATICALLY_GENERATED AUTOMATICALLY_GENERATED
, CREATED_FROM CREATED_FROM
, REASON_CODE REASON_CODE
, POSTABLE POSTABLE
, APPROVED_BY APPROVED_BY
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, POSTING_CONTROL_ID POSTING_CONTROL_ID
, ACCTD_AMOUNT ACCTD_AMOUNT
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, ADJUSTMENT_NUMBER ADJUSTMENT_NUMBER
, ORG_ID ORG_ID
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, USSGL_TRANSACTION_CODE_CONTEXT USSGL_TRANSACTION_CODE_CONTEXT
, DOC_SEQUENCE_VALUE DOC_SEQUENCE_VALUE
, DOC_SEQUENCE_ID DOC_SEQUENCE_ID
, ASSOCIATED_APPLICATION_ID ASSOCIATED_APPLICATION_ID
, CONS_INV_ID CONS_INV_ID
, MRC_GL_POSTED_DATE MRC_GL_POSTED_DATE
, MRC_POSTING_CONTROL_ID MRC_POSTING_CONTROL_ID
, MRC_ACCTD_AMOUNT MRC_ACCTD_AMOUNT
, ADJ_TAX_ACCT_RULE ADJ_TAX_ACCT_RULE
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, 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
, LINK_TO_TRX_HIST_ID LINK_TO_TRX_HIST_ID
, EVENT_ID EVENT_ID
, UPGRADE_METHOD UPGRADE_METHOD
, AX_ACCOUNTED_FLAG AX_ACCOUNTED_FLAG
, INTEREST_HEADER_ID INTEREST_HEADER_ID
, INTEREST_LINE_ID INTEREST_LINE_ID
FROM "AR"."AR_ADJUSTMENTS_ALL"