VIEW: AR.AR_CHANGE_MATRIX#

Source

View Text - Preformatted

select CHANGE_MATRIX_ID CHANGE_MATRIX_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ACTION ACTION, CHECK_IN_INSERT_MODE_FLAG CHECK_IN_INSERT_MODE_FLAG, FORM FORM, ZONE ZONE, FIELD FIELD, APPLICATION_ID APPLICATION_ID, TRANSACTION_TYPE TRANSACTION_TYPE, ACCOUNTING_RULE_TYPE ACCOUNTING_RULE_TYPE, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, PROHIBIT_ALL_CHANGES_FLAG PROHIBIT_ALL_CHANGES_FLAG, CHANGE_COMPLETE_FLAG CHANGE_COMPLETE_FLAG, CHANGE_RULES_FLAG CHANGE_RULES_FLAG, CHANGE_PRINTED_FLAG CHANGE_PRINTED_FLAG, CHANGE_ACTIVITY_FLAG CHANGE_ACTIVITY_FLAG, CHANGE_POSTED_FLAG CHANGE_POSTED_FLAG, CHANGE_AUTORULE_FLAG CHANGE_AUTORULE_FLAG, CHANGE_REV_BASED_ON_SREP_FLAG CHANGE_REV_BASED_ON_SREP_FLAG, CHANGE_CHANGE_CUST_ON_TRX_FLAG CHANGE_CHANGE_CUST_ON_TRX_FLAG, CHG_CHANGE_PRINTED_INV_FLAG CHG_CHANGE_PRINTED_INV_FLAG, CHANGE_TAX_UPDATE_FLAG CHANGE_TAX_UPDATE_FLAG, CHG_USE_INV_ACCT_FOR_CM_FLAG CHG_USE_INV_ACCT_FOR_CM_FLAG, CHANGE_INVOICE_DELETION_FLAG CHANGE_INVOICE_DELETION_FLAG, CHANGE_AR_UPDATE_DUE_DATE_FLAG CHANGE_AR_UPDATE_DUE_DATE_FLAG, CHANGE_CHANGE_CUST_NAME_FLAG CHANGE_CHANGE_CUST_NAME_FLAG, COMPLETE_MESSAGE_NAME COMPLETE_MESSAGE_NAME, RULES_MESSAGE_NAME RULES_MESSAGE_NAME, PRINTED_MESSAGE_NAME PRINTED_MESSAGE_NAME, ACTIVITY_MESSAGE_NAME ACTIVITY_MESSAGE_NAME, POSTED_MESSAGE_NAME POSTED_MESSAGE_NAME, AUTORULE_MESSAGE_NAME AUTORULE_MESSAGE_NAME, CHANGE_CUST_ON_TRX_MSG_NAME CHANGE_CUST_ON_TRX_MSG_NAME, CHANGES_AFTER_PRINT_MSG_NAME CHANGES_AFTER_PRINT_MSG_NAME, TAX_UPDATE_MESSAGE_NAME TAX_UPDATE_MESSAGE_NAME, USE_INV_ACCT_FOR_CM_MSG_NAME USE_INV_ACCT_FOR_CM_MSG_NAME, INVOICE_DELETION_MESSAGE_NAME INVOICE_DELETION_MESSAGE_NAME, AR_UPDATE_DUE_DATE_MSG_NAME AR_UPDATE_DUE_DATE_MSG_NAME, CHANGE_CUST_NAME_MESSAGE_NAME CHANGE_CUST_NAME_MESSAGE_NAME, REV_BASED_ON_SREP_MSG_NAME REV_BASED_ON_SREP_MSG_NAME, PROHIBIT_ALL_CHANGES_MSG_NAME PROHIBIT_ALL_CHANGES_MSG_NAME, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, 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, CHANGE_UNCONFIRMED_INV_FLAG CHANGE_UNCONFIRMED_INV_FLAG, CHANGE_UNCONF_INV_MSG_NAME CHANGE_UNCONF_INV_MSG_NAME, BATCH_SOURCE_TYPE BATCH_SOURCE_TYPE, CHANGE_AUTOTAX_FLAG CHANGE_AUTOTAX_FLAG, AUTOTAX_MSG_NAME AUTOTAX_MSG_NAME, ACCOUNTING_METHOD ACCOUNTING_METHOD, CREATED_FROM CREATED_FROM, CANVAS CANVAS, CANVAS_TO_CHANGE CANVAS_TO_CHANGE, CHANGE_USSGL_FLAG CHANGE_USSGL_FLAG, CHANGE_FUNCTION1_FLAG CHANGE_FUNCTION1_FLAG, CHANGE_FUNCTION2_FLAG CHANGE_FUNCTION2_FLAG, CHANGE_FUNCTION3_FLAG CHANGE_FUNCTION3_FLAG, CHANGE_FUNCTION4_FLAG CHANGE_FUNCTION4_FLAG, CHANGE_FUNCTION5_FLAG CHANGE_FUNCTION5_FLAG, CHANGE_FUNCTION6_FLAG CHANGE_FUNCTION6_FLAG, CHANGE_FUNCTION7_FLAG CHANGE_FUNCTION7_FLAG, CHANGE_FUNCTION8_FLAG CHANGE_FUNCTION8_FLAG, CHANGE_FUNCTION9_FLAG CHANGE_FUNCTION9_FLAG, CHANGE_FUNCTION10_FLAG CHANGE_FUNCTION10_FLAG, CHANGE_FUNCTION11_FLAG CHANGE_FUNCTION11_FLAG, CHANGE_FUNCTION12_FLAG CHANGE_FUNCTION12_FLAG, CHANGE_FUNCTION13_FLAG CHANGE_FUNCTION13_FLAG, CHANGE_FUNCTION14_FLAG CHANGE_FUNCTION14_FLAG, CHANGE_FUNCTION15_FLAG CHANGE_FUNCTION15_FLAG, CHANGE_FUNCTION16_FLAG CHANGE_FUNCTION16_FLAG, CHANGE_FUNCTION17_FLAG CHANGE_FUNCTION17_FLAG, CHANGE_FUNCTION18_FLAG CHANGE_FUNCTION18_FLAG, CHANGE_FUNCTION19_FLAG CHANGE_FUNCTION19_FLAG, CHANGE_FUNCTION20_FLAG CHANGE_FUNCTION20_FLAG, USSGL_MSG_NAME USSGL_MSG_NAME, FUNCTION1_MSG_NAME FUNCTION1_MSG_NAME, FUNCTION2_MSG_NAME FUNCTION2_MSG_NAME, FUNCTION3_MSG_NAME FUNCTION3_MSG_NAME, FUNCTION4_MSG_NAME FUNCTION4_MSG_NAME, FUNCTION5_MSG_NAME FUNCTION5_MSG_NAME, FUNCTION6_MSG_NAME FUNCTION6_MSG_NAME, FUNCTION7_MSG_NAME FUNCTION7_MSG_NAME, FUNCTION8_MSG_NAME FUNCTION8_MSG_NAME, FUNCTION9_MSG_NAME FUNCTION9_MSG_NAME, FUNCTION10_MSG_NAME FUNCTION10_MSG_NAME, FUNCTION11_MSG_NAME FUNCTION11_MSG_NAME, FUNCTION12_MSG_NAME FUNCTION12_MSG_NAME, FUNCTION13_MSG_NAME FUNCTION13_MSG_NAME, FUNCTION14_MSG_NAME FUNCTION14_MSG_NAME, FUNCTION15_MSG_NAME FUNCTION15_MSG_NAME, FUNCTION16_MSG_NAME FUNCTION16_MSG_NAME, FUNCTION17_MSG_NAME FUNCTION17_MSG_NAME, FUNCTION18_MSG_NAME FUNCTION18_MSG_NAME, FUNCTION19_MSG_NAME FUNCTION19_MSG_NAME, FUNCTION20_MSG_NAME FUNCTION20_MSG_NAME, COMPLETE_PROPERTY COMPLETE_PROPERTY, RULES_PROPERTY RULES_PROPERTY, PRINTED_PROPERTY PRINTED_PROPERTY, ACTIVITY_PROPERTY ACTIVITY_PROPERTY, POSTED_PROPERTY POSTED_PROPERTY, AUTORULE_PROPERTY AUTORULE_PROPERTY, CHANGE_CUST_ON_TRX_PROPERTY CHANGE_CUST_ON_TRX_PROPERTY, CHANGES_AFTER_PRINT_PROPERTY CHANGES_AFTER_PRINT_PROPERTY, TAX_UPDATE_PROPERTY TAX_UPDATE_PROPERTY, USE_INV_ACCT_FOR_CM_PROPERTY USE_INV_ACCT_FOR_CM_PROPERTY, INVOICE_DELETION_PROPERTY INVOICE_DELETION_PROPERTY, AR_UPDATE_DUE_DATE_PROPERTY AR_UPDATE_DUE_DATE_PROPERTY, CHANGE_CUST_NAME_PROPERTY CHANGE_CUST_NAME_PROPERTY, REV_BASED_ON_SREP_PROPERTY REV_BASED_ON_SREP_PROPERTY, PROHIBIT_ALL_CHANGES_PROPERTY PROHIBIT_ALL_CHANGES_PROPERTY, CHANGE_UNCONF_INV_PROPERTY CHANGE_UNCONF_INV_PROPERTY, USSGL_PROPERTY USSGL_PROPERTY, AUTOTAX_PROPERTY AUTOTAX_PROPERTY, FUNCTION1_PROPERTY FUNCTION1_PROPERTY, FUNCTION2_PROPERTY FUNCTION2_PROPERTY, FUNCTION3_PROPERTY FUNCTION3_PROPERTY, FUNCTION4_PROPERTY FUNCTION4_PROPERTY, FUNCTION5_PROPERTY FUNCTION5_PROPERTY, FUNCTION6_PROPERTY FUNCTION6_PROPERTY, FUNCTION7_PROPERTY FUNCTION7_PROPERTY, FUNCTION8_PROPERTY FUNCTION8_PROPERTY, FUNCTION9_PROPERTY FUNCTION9_PROPERTY, FUNCTION10_PROPERTY FUNCTION10_PROPERTY, FUNCTION11_PROPERTY FUNCTION11_PROPERTY, FUNCTION12_PROPERTY FUNCTION12_PROPERTY, FUNCTION13_PROPERTY FUNCTION13_PROPERTY, FUNCTION14_PROPERTY FUNCTION14_PROPERTY, FUNCTION15_PROPERTY FUNCTION15_PROPERTY, FUNCTION16_PROPERTY FUNCTION16_PROPERTY, FUNCTION17_PROPERTY FUNCTION17_PROPERTY, FUNCTION18_PROPERTY FUNCTION18_PROPERTY, FUNCTION19_PROPERTY FUNCTION19_PROPERTY, FUNCTION20_PROPERTY FUNCTION20_PROPERTY, FIELD_MIRROR FIELD_MIRROR from "AR"."AR_CHANGE_MATRIX"

View Text - HTML Formatted

SELECT CHANGE_MATRIX_ID CHANGE_MATRIX_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ACTION ACTION
, CHECK_IN_INSERT_MODE_FLAG CHECK_IN_INSERT_MODE_FLAG
, FORM FORM
, ZONE ZONE
, FIELD FIELD
, APPLICATION_ID APPLICATION_ID
, TRANSACTION_TYPE TRANSACTION_TYPE
, ACCOUNTING_RULE_TYPE ACCOUNTING_RULE_TYPE
, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, PROHIBIT_ALL_CHANGES_FLAG PROHIBIT_ALL_CHANGES_FLAG
, CHANGE_COMPLETE_FLAG CHANGE_COMPLETE_FLAG
, CHANGE_RULES_FLAG CHANGE_RULES_FLAG
, CHANGE_PRINTED_FLAG CHANGE_PRINTED_FLAG
, CHANGE_ACTIVITY_FLAG CHANGE_ACTIVITY_FLAG
, CHANGE_POSTED_FLAG CHANGE_POSTED_FLAG
, CHANGE_AUTORULE_FLAG CHANGE_AUTORULE_FLAG
, CHANGE_REV_BASED_ON_SREP_FLAG CHANGE_REV_BASED_ON_SREP_FLAG
, CHANGE_CHANGE_CUST_ON_TRX_FLAG CHANGE_CHANGE_CUST_ON_TRX_FLAG
, CHG_CHANGE_PRINTED_INV_FLAG CHG_CHANGE_PRINTED_INV_FLAG
, CHANGE_TAX_UPDATE_FLAG CHANGE_TAX_UPDATE_FLAG
, CHG_USE_INV_ACCT_FOR_CM_FLAG CHG_USE_INV_ACCT_FOR_CM_FLAG
, CHANGE_INVOICE_DELETION_FLAG CHANGE_INVOICE_DELETION_FLAG
, CHANGE_AR_UPDATE_DUE_DATE_FLAG CHANGE_AR_UPDATE_DUE_DATE_FLAG
, CHANGE_CHANGE_CUST_NAME_FLAG CHANGE_CHANGE_CUST_NAME_FLAG
, COMPLETE_MESSAGE_NAME COMPLETE_MESSAGE_NAME
, RULES_MESSAGE_NAME RULES_MESSAGE_NAME
, PRINTED_MESSAGE_NAME PRINTED_MESSAGE_NAME
, ACTIVITY_MESSAGE_NAME ACTIVITY_MESSAGE_NAME
, POSTED_MESSAGE_NAME POSTED_MESSAGE_NAME
, AUTORULE_MESSAGE_NAME AUTORULE_MESSAGE_NAME
, CHANGE_CUST_ON_TRX_MSG_NAME CHANGE_CUST_ON_TRX_MSG_NAME
, CHANGES_AFTER_PRINT_MSG_NAME CHANGES_AFTER_PRINT_MSG_NAME
, TAX_UPDATE_MESSAGE_NAME TAX_UPDATE_MESSAGE_NAME
, USE_INV_ACCT_FOR_CM_MSG_NAME USE_INV_ACCT_FOR_CM_MSG_NAME
, INVOICE_DELETION_MESSAGE_NAME INVOICE_DELETION_MESSAGE_NAME
, AR_UPDATE_DUE_DATE_MSG_NAME AR_UPDATE_DUE_DATE_MSG_NAME
, CHANGE_CUST_NAME_MESSAGE_NAME CHANGE_CUST_NAME_MESSAGE_NAME
, REV_BASED_ON_SREP_MSG_NAME REV_BASED_ON_SREP_MSG_NAME
, PROHIBIT_ALL_CHANGES_MSG_NAME PROHIBIT_ALL_CHANGES_MSG_NAME
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, 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
, CHANGE_UNCONFIRMED_INV_FLAG CHANGE_UNCONFIRMED_INV_FLAG
, CHANGE_UNCONF_INV_MSG_NAME CHANGE_UNCONF_INV_MSG_NAME
, BATCH_SOURCE_TYPE BATCH_SOURCE_TYPE
, CHANGE_AUTOTAX_FLAG CHANGE_AUTOTAX_FLAG
, AUTOTAX_MSG_NAME AUTOTAX_MSG_NAME
, ACCOUNTING_METHOD ACCOUNTING_METHOD
, CREATED_FROM CREATED_FROM
, CANVAS CANVAS
, CANVAS_TO_CHANGE CANVAS_TO_CHANGE
, CHANGE_USSGL_FLAG CHANGE_USSGL_FLAG
, CHANGE_FUNCTION1_FLAG CHANGE_FUNCTION1_FLAG
, CHANGE_FUNCTION2_FLAG CHANGE_FUNCTION2_FLAG
, CHANGE_FUNCTION3_FLAG CHANGE_FUNCTION3_FLAG
, CHANGE_FUNCTION4_FLAG CHANGE_FUNCTION4_FLAG
, CHANGE_FUNCTION5_FLAG CHANGE_FUNCTION5_FLAG
, CHANGE_FUNCTION6_FLAG CHANGE_FUNCTION6_FLAG
, CHANGE_FUNCTION7_FLAG CHANGE_FUNCTION7_FLAG
, CHANGE_FUNCTION8_FLAG CHANGE_FUNCTION8_FLAG
, CHANGE_FUNCTION9_FLAG CHANGE_FUNCTION9_FLAG
, CHANGE_FUNCTION10_FLAG CHANGE_FUNCTION10_FLAG
, CHANGE_FUNCTION11_FLAG CHANGE_FUNCTION11_FLAG
, CHANGE_FUNCTION12_FLAG CHANGE_FUNCTION12_FLAG
, CHANGE_FUNCTION13_FLAG CHANGE_FUNCTION13_FLAG
, CHANGE_FUNCTION14_FLAG CHANGE_FUNCTION14_FLAG
, CHANGE_FUNCTION15_FLAG CHANGE_FUNCTION15_FLAG
, CHANGE_FUNCTION16_FLAG CHANGE_FUNCTION16_FLAG
, CHANGE_FUNCTION17_FLAG CHANGE_FUNCTION17_FLAG
, CHANGE_FUNCTION18_FLAG CHANGE_FUNCTION18_FLAG
, CHANGE_FUNCTION19_FLAG CHANGE_FUNCTION19_FLAG
, CHANGE_FUNCTION20_FLAG CHANGE_FUNCTION20_FLAG
, USSGL_MSG_NAME USSGL_MSG_NAME
, FUNCTION1_MSG_NAME FUNCTION1_MSG_NAME
, FUNCTION2_MSG_NAME FUNCTION2_MSG_NAME
, FUNCTION3_MSG_NAME FUNCTION3_MSG_NAME
, FUNCTION4_MSG_NAME FUNCTION4_MSG_NAME
, FUNCTION5_MSG_NAME FUNCTION5_MSG_NAME
, FUNCTION6_MSG_NAME FUNCTION6_MSG_NAME
, FUNCTION7_MSG_NAME FUNCTION7_MSG_NAME
, FUNCTION8_MSG_NAME FUNCTION8_MSG_NAME
, FUNCTION9_MSG_NAME FUNCTION9_MSG_NAME
, FUNCTION10_MSG_NAME FUNCTION10_MSG_NAME
, FUNCTION11_MSG_NAME FUNCTION11_MSG_NAME
, FUNCTION12_MSG_NAME FUNCTION12_MSG_NAME
, FUNCTION13_MSG_NAME FUNCTION13_MSG_NAME
, FUNCTION14_MSG_NAME FUNCTION14_MSG_NAME
, FUNCTION15_MSG_NAME FUNCTION15_MSG_NAME
, FUNCTION16_MSG_NAME FUNCTION16_MSG_NAME
, FUNCTION17_MSG_NAME FUNCTION17_MSG_NAME
, FUNCTION18_MSG_NAME FUNCTION18_MSG_NAME
, FUNCTION19_MSG_NAME FUNCTION19_MSG_NAME
, FUNCTION20_MSG_NAME FUNCTION20_MSG_NAME
, COMPLETE_PROPERTY COMPLETE_PROPERTY
, RULES_PROPERTY RULES_PROPERTY
, PRINTED_PROPERTY PRINTED_PROPERTY
, ACTIVITY_PROPERTY ACTIVITY_PROPERTY
, POSTED_PROPERTY POSTED_PROPERTY
, AUTORULE_PROPERTY AUTORULE_PROPERTY
, CHANGE_CUST_ON_TRX_PROPERTY CHANGE_CUST_ON_TRX_PROPERTY
, CHANGES_AFTER_PRINT_PROPERTY CHANGES_AFTER_PRINT_PROPERTY
, TAX_UPDATE_PROPERTY TAX_UPDATE_PROPERTY
, USE_INV_ACCT_FOR_CM_PROPERTY USE_INV_ACCT_FOR_CM_PROPERTY
, INVOICE_DELETION_PROPERTY INVOICE_DELETION_PROPERTY
, AR_UPDATE_DUE_DATE_PROPERTY AR_UPDATE_DUE_DATE_PROPERTY
, CHANGE_CUST_NAME_PROPERTY CHANGE_CUST_NAME_PROPERTY
, REV_BASED_ON_SREP_PROPERTY REV_BASED_ON_SREP_PROPERTY
, PROHIBIT_ALL_CHANGES_PROPERTY PROHIBIT_ALL_CHANGES_PROPERTY
, CHANGE_UNCONF_INV_PROPERTY CHANGE_UNCONF_INV_PROPERTY
, USSGL_PROPERTY USSGL_PROPERTY
, AUTOTAX_PROPERTY AUTOTAX_PROPERTY
, FUNCTION1_PROPERTY FUNCTION1_PROPERTY
, FUNCTION2_PROPERTY FUNCTION2_PROPERTY
, FUNCTION3_PROPERTY FUNCTION3_PROPERTY
, FUNCTION4_PROPERTY FUNCTION4_PROPERTY
, FUNCTION5_PROPERTY FUNCTION5_PROPERTY
, FUNCTION6_PROPERTY FUNCTION6_PROPERTY
, FUNCTION7_PROPERTY FUNCTION7_PROPERTY
, FUNCTION8_PROPERTY FUNCTION8_PROPERTY
, FUNCTION9_PROPERTY FUNCTION9_PROPERTY
, FUNCTION10_PROPERTY FUNCTION10_PROPERTY
, FUNCTION11_PROPERTY FUNCTION11_PROPERTY
, FUNCTION12_PROPERTY FUNCTION12_PROPERTY
, FUNCTION13_PROPERTY FUNCTION13_PROPERTY
, FUNCTION14_PROPERTY FUNCTION14_PROPERTY
, FUNCTION15_PROPERTY FUNCTION15_PROPERTY
, FUNCTION16_PROPERTY FUNCTION16_PROPERTY
, FUNCTION17_PROPERTY FUNCTION17_PROPERTY
, FUNCTION18_PROPERTY FUNCTION18_PROPERTY
, FUNCTION19_PROPERTY FUNCTION19_PROPERTY
, FUNCTION20_PROPERTY FUNCTION20_PROPERTY
, FIELD_MIRROR FIELD_MIRROR
FROM "AR"."AR_CHANGE_MATRIX"