[Home] [Help] [Dependency Information]
Object Name: | AR_CHANGE_MATRIX# |
---|---|
Object Type: | VIEW |
Owner: | AR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CHANGE_MATRIX_ID | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
ACTION | VARCHAR2 | (1) | Yes | |
CHECK_IN_INSERT_MODE_FLAG | VARCHAR2 | (1) | ||
FORM | VARCHAR2 | (30) | Yes | |
ZONE | VARCHAR2 | (30) | ||
FIELD | VARCHAR2 | (30) | ||
APPLICATION_ID | NUMBER | (15) | ||
TRANSACTION_TYPE | VARCHAR2 | (20) | ||
ACCOUNTING_RULE_TYPE | VARCHAR2 | (10) | ||
EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | ||
PROHIBIT_ALL_CHANGES_FLAG | VARCHAR2 | (1) | ||
CHANGE_COMPLETE_FLAG | VARCHAR2 | (1) | ||
CHANGE_RULES_FLAG | VARCHAR2 | (1) | ||
CHANGE_PRINTED_FLAG | VARCHAR2 | (1) | ||
CHANGE_ACTIVITY_FLAG | VARCHAR2 | (1) | ||
CHANGE_POSTED_FLAG | VARCHAR2 | (1) | ||
CHANGE_AUTORULE_FLAG | VARCHAR2 | (1) | ||
CHANGE_REV_BASED_ON_SREP_FLAG | VARCHAR2 | (1) | ||
CHANGE_CHANGE_CUST_ON_TRX_FLAG | VARCHAR2 | (1) | ||
CHG_CHANGE_PRINTED_INV_FLAG | VARCHAR2 | (1) | ||
CHANGE_TAX_UPDATE_FLAG | VARCHAR2 | (1) | ||
CHG_USE_INV_ACCT_FOR_CM_FLAG | VARCHAR2 | (1) | ||
CHANGE_INVOICE_DELETION_FLAG | VARCHAR2 | (1) | ||
CHANGE_AR_UPDATE_DUE_DATE_FLAG | VARCHAR2 | (1) | ||
CHANGE_CHANGE_CUST_NAME_FLAG | VARCHAR2 | (1) | ||
COMPLETE_MESSAGE_NAME | VARCHAR2 | (30) | ||
RULES_MESSAGE_NAME | VARCHAR2 | (30) | ||
PRINTED_MESSAGE_NAME | VARCHAR2 | (30) | ||
ACTIVITY_MESSAGE_NAME | VARCHAR2 | (30) | ||
POSTED_MESSAGE_NAME | VARCHAR2 | (30) | ||
AUTORULE_MESSAGE_NAME | VARCHAR2 | (30) | ||
CHANGE_CUST_ON_TRX_MSG_NAME | VARCHAR2 | (30) | ||
CHANGES_AFTER_PRINT_MSG_NAME | VARCHAR2 | (30) | ||
TAX_UPDATE_MESSAGE_NAME | VARCHAR2 | (30) | ||
USE_INV_ACCT_FOR_CM_MSG_NAME | VARCHAR2 | (30) | ||
INVOICE_DELETION_MESSAGE_NAME | VARCHAR2 | (30) | ||
AR_UPDATE_DUE_DATE_MSG_NAME | VARCHAR2 | (30) | ||
CHANGE_CUST_NAME_MESSAGE_NAME | VARCHAR2 | (30) | ||
REV_BASED_ON_SREP_MSG_NAME | VARCHAR2 | (30) | ||
PROHIBIT_ALL_CHANGES_MSG_NAME | VARCHAR2 | (30) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
CHANGE_UNCONFIRMED_INV_FLAG | VARCHAR2 | (1) | ||
CHANGE_UNCONF_INV_MSG_NAME | VARCHAR2 | (30) | ||
BATCH_SOURCE_TYPE | VARCHAR2 | (30) | ||
CHANGE_AUTOTAX_FLAG | VARCHAR2 | (1) | ||
AUTOTAX_MSG_NAME | VARCHAR2 | (30) | ||
ACCOUNTING_METHOD | VARCHAR2 | (30) | ||
CREATED_FROM | VARCHAR2 | (30) | ||
CANVAS | VARCHAR2 | (30) | ||
CANVAS_TO_CHANGE | VARCHAR2 | (30) | ||
CHANGE_USSGL_FLAG | VARCHAR2 | (1) | ||
CHANGE_FUNCTION1_FLAG | VARCHAR2 | (1) | ||
CHANGE_FUNCTION2_FLAG | VARCHAR2 | (1) | ||
CHANGE_FUNCTION3_FLAG | VARCHAR2 | (1) | ||
CHANGE_FUNCTION4_FLAG | VARCHAR2 | (1) | ||
CHANGE_FUNCTION5_FLAG | VARCHAR2 | (1) | ||
CHANGE_FUNCTION6_FLAG | VARCHAR2 | (1) | ||
CHANGE_FUNCTION7_FLAG | VARCHAR2 | (1) | ||
CHANGE_FUNCTION8_FLAG | VARCHAR2 | (1) | ||
CHANGE_FUNCTION9_FLAG | VARCHAR2 | (1) | ||
CHANGE_FUNCTION10_FLAG | VARCHAR2 | (1) | ||
CHANGE_FUNCTION11_FLAG | VARCHAR2 | (1) | ||
CHANGE_FUNCTION12_FLAG | VARCHAR2 | (1) | ||
CHANGE_FUNCTION13_FLAG | VARCHAR2 | (1) | ||
CHANGE_FUNCTION14_FLAG | VARCHAR2 | (1) | ||
CHANGE_FUNCTION15_FLAG | VARCHAR2 | (1) | ||
CHANGE_FUNCTION16_FLAG | VARCHAR2 | (1) | ||
CHANGE_FUNCTION17_FLAG | VARCHAR2 | (1) | ||
CHANGE_FUNCTION18_FLAG | VARCHAR2 | (1) | ||
CHANGE_FUNCTION19_FLAG | VARCHAR2 | (1) | ||
CHANGE_FUNCTION20_FLAG | VARCHAR2 | (1) | ||
USSGL_MSG_NAME | VARCHAR2 | (30) | ||
FUNCTION1_MSG_NAME | VARCHAR2 | (30) | ||
FUNCTION2_MSG_NAME | VARCHAR2 | (30) | ||
FUNCTION3_MSG_NAME | VARCHAR2 | (30) | ||
FUNCTION4_MSG_NAME | VARCHAR2 | (30) | ||
FUNCTION5_MSG_NAME | VARCHAR2 | (30) | ||
FUNCTION6_MSG_NAME | VARCHAR2 | (30) | ||
FUNCTION7_MSG_NAME | VARCHAR2 | (30) | ||
FUNCTION8_MSG_NAME | VARCHAR2 | (30) | ||
FUNCTION9_MSG_NAME | VARCHAR2 | (30) | ||
FUNCTION10_MSG_NAME | VARCHAR2 | (30) | ||
FUNCTION11_MSG_NAME | VARCHAR2 | (30) | ||
FUNCTION12_MSG_NAME | VARCHAR2 | (30) | ||
FUNCTION13_MSG_NAME | VARCHAR2 | (30) | ||
FUNCTION14_MSG_NAME | VARCHAR2 | (30) | ||
FUNCTION15_MSG_NAME | VARCHAR2 | (30) | ||
FUNCTION16_MSG_NAME | VARCHAR2 | (30) | ||
FUNCTION17_MSG_NAME | VARCHAR2 | (30) | ||
FUNCTION18_MSG_NAME | VARCHAR2 | (30) | ||
FUNCTION19_MSG_NAME | VARCHAR2 | (30) | ||
FUNCTION20_MSG_NAME | VARCHAR2 | (30) | ||
COMPLETE_PROPERTY | VARCHAR2 | (20) | ||
RULES_PROPERTY | VARCHAR2 | (20) | ||
PRINTED_PROPERTY | VARCHAR2 | (20) | ||
ACTIVITY_PROPERTY | VARCHAR2 | (20) | ||
POSTED_PROPERTY | VARCHAR2 | (20) | ||
AUTORULE_PROPERTY | VARCHAR2 | (20) | ||
CHANGE_CUST_ON_TRX_PROPERTY | VARCHAR2 | (20) | ||
CHANGES_AFTER_PRINT_PROPERTY | VARCHAR2 | (20) | ||
TAX_UPDATE_PROPERTY | VARCHAR2 | (20) | ||
USE_INV_ACCT_FOR_CM_PROPERTY | VARCHAR2 | (20) | ||
INVOICE_DELETION_PROPERTY | VARCHAR2 | (20) | ||
AR_UPDATE_DUE_DATE_PROPERTY | VARCHAR2 | (20) | ||
CHANGE_CUST_NAME_PROPERTY | VARCHAR2 | (20) | ||
REV_BASED_ON_SREP_PROPERTY | VARCHAR2 | (20) | ||
PROHIBIT_ALL_CHANGES_PROPERTY | VARCHAR2 | (20) | ||
CHANGE_UNCONF_INV_PROPERTY | VARCHAR2 | (20) | ||
USSGL_PROPERTY | VARCHAR2 | (20) | ||
AUTOTAX_PROPERTY | VARCHAR2 | (20) | ||
FUNCTION1_PROPERTY | VARCHAR2 | (20) | ||
FUNCTION2_PROPERTY | VARCHAR2 | (20) | ||
FUNCTION3_PROPERTY | VARCHAR2 | (20) | ||
FUNCTION4_PROPERTY | VARCHAR2 | (20) | ||
FUNCTION5_PROPERTY | VARCHAR2 | (20) | ||
FUNCTION6_PROPERTY | VARCHAR2 | (20) | ||
FUNCTION7_PROPERTY | VARCHAR2 | (20) | ||
FUNCTION8_PROPERTY | VARCHAR2 | (20) | ||
FUNCTION9_PROPERTY | VARCHAR2 | (20) | ||
FUNCTION10_PROPERTY | VARCHAR2 | (20) | ||
FUNCTION11_PROPERTY | VARCHAR2 | (20) | ||
FUNCTION12_PROPERTY | VARCHAR2 | (20) | ||
FUNCTION13_PROPERTY | VARCHAR2 | (20) | ||
FUNCTION14_PROPERTY | VARCHAR2 | (20) | ||
FUNCTION15_PROPERTY | VARCHAR2 | (20) | ||
FUNCTION16_PROPERTY | VARCHAR2 | (20) | ||
FUNCTION17_PROPERTY | VARCHAR2 | (20) | ||
FUNCTION18_PROPERTY | VARCHAR2 | (20) | ||
FUNCTION19_PROPERTY | VARCHAR2 | (20) | ||
FUNCTION20_PROPERTY | VARCHAR2 | (20) | ||
FIELD_MIRROR | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT CHANGE_MATRIX_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, ACTION
, CHECK_IN_INSERT_MODE_FLAG
, FORM
, ZONE
, FIELD
, APPLICATION_ID
, TRANSACTION_TYPE
, ACCOUNTING_RULE_TYPE
, EXCHANGE_RATE_TYPE
, PROHIBIT_ALL_CHANGES_FLAG
, CHANGE_COMPLETE_FLAG
, CHANGE_RULES_FLAG
, CHANGE_PRINTED_FLAG
, CHANGE_ACTIVITY_FLAG
, CHANGE_POSTED_FLAG
, CHANGE_AUTORULE_FLAG
, CHANGE_REV_BASED_ON_SREP_FLAG
, CHANGE_CHANGE_CUST_ON_TRX_FLAG
, CHG_CHANGE_PRINTED_INV_FLAG
, CHANGE_TAX_UPDATE_FLAG
, CHG_USE_INV_ACCT_FOR_CM_FLAG
, CHANGE_INVOICE_DELETION_FLAG
, CHANGE_AR_UPDATE_DUE_DATE_FLAG
, CHANGE_CHANGE_CUST_NAME_FLAG
, COMPLETE_MESSAGE_NAME
, RULES_MESSAGE_NAME
, PRINTED_MESSAGE_NAME
, ACTIVITY_MESSAGE_NAME
, POSTED_MESSAGE_NAME
, AUTORULE_MESSAGE_NAME
, CHANGE_CUST_ON_TRX_MSG_NAME
, CHANGES_AFTER_PRINT_MSG_NAME
, TAX_UPDATE_MESSAGE_NAME
, USE_INV_ACCT_FOR_CM_MSG_NAME
, INVOICE_DELETION_MESSAGE_NAME
, AR_UPDATE_DUE_DATE_MSG_NAME
, CHANGE_CUST_NAME_MESSAGE_NAME
, REV_BASED_ON_SREP_MSG_NAME
, PROHIBIT_ALL_CHANGES_MSG_NAME
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CHANGE_UNCONFIRMED_INV_FLAG
, CHANGE_UNCONF_INV_MSG_NAME
, BATCH_SOURCE_TYPE
, CHANGE_AUTOTAX_FLAG
, AUTOTAX_MSG_NAME
, ACCOUNTING_METHOD
, CREATED_FROM
, CANVAS
, CANVAS_TO_CHANGE
, CHANGE_USSGL_FLAG
, CHANGE_FUNCTION1_FLAG
, CHANGE_FUNCTION2_FLAG
, CHANGE_FUNCTION3_FLAG
, CHANGE_FUNCTION4_FLAG
, CHANGE_FUNCTION5_FLAG
, CHANGE_FUNCTION6_FLAG
, CHANGE_FUNCTION7_FLAG
, CHANGE_FUNCTION8_FLAG
, CHANGE_FUNCTION9_FLAG
, CHANGE_FUNCTION10_FLAG
, CHANGE_FUNCTION11_FLAG
, CHANGE_FUNCTION12_FLAG
, CHANGE_FUNCTION13_FLAG
, CHANGE_FUNCTION14_FLAG
, CHANGE_FUNCTION15_FLAG
, CHANGE_FUNCTION16_FLAG
, CHANGE_FUNCTION17_FLAG
, CHANGE_FUNCTION18_FLAG
, CHANGE_FUNCTION19_FLAG
, CHANGE_FUNCTION20_FLAG
, USSGL_MSG_NAME
, FUNCTION1_MSG_NAME
, FUNCTION2_MSG_NAME
, FUNCTION3_MSG_NAME
, FUNCTION4_MSG_NAME
, FUNCTION5_MSG_NAME
, FUNCTION6_MSG_NAME
, FUNCTION7_MSG_NAME
, FUNCTION8_MSG_NAME
, FUNCTION9_MSG_NAME
, FUNCTION10_MSG_NAME
, FUNCTION11_MSG_NAME
, FUNCTION12_MSG_NAME
, FUNCTION13_MSG_NAME
, FUNCTION14_MSG_NAME
, FUNCTION15_MSG_NAME
, FUNCTION16_MSG_NAME
, FUNCTION17_MSG_NAME
, FUNCTION18_MSG_NAME
, FUNCTION19_MSG_NAME
, FUNCTION20_MSG_NAME
, COMPLETE_PROPERTY
, RULES_PROPERTY
, PRINTED_PROPERTY
, ACTIVITY_PROPERTY
, POSTED_PROPERTY
, AUTORULE_PROPERTY
, CHANGE_CUST_ON_TRX_PROPERTY
, CHANGES_AFTER_PRINT_PROPERTY
, TAX_UPDATE_PROPERTY
, USE_INV_ACCT_FOR_CM_PROPERTY
, INVOICE_DELETION_PROPERTY
, AR_UPDATE_DUE_DATE_PROPERTY
, CHANGE_CUST_NAME_PROPERTY
, REV_BASED_ON_SREP_PROPERTY
, PROHIBIT_ALL_CHANGES_PROPERTY
, CHANGE_UNCONF_INV_PROPERTY
, USSGL_PROPERTY
, AUTOTAX_PROPERTY
, FUNCTION1_PROPERTY
, FUNCTION2_PROPERTY
, FUNCTION3_PROPERTY
, FUNCTION4_PROPERTY
, FUNCTION5_PROPERTY
, FUNCTION6_PROPERTY
, FUNCTION7_PROPERTY
, FUNCTION8_PROPERTY
, FUNCTION9_PROPERTY
, FUNCTION10_PROPERTY
, FUNCTION11_PROPERTY
, FUNCTION12_PROPERTY
, FUNCTION13_PROPERTY
, FUNCTION14_PROPERTY
, FUNCTION15_PROPERTY
, FUNCTION16_PROPERTY
, FUNCTION17_PROPERTY
, FUNCTION18_PROPERTY
, FUNCTION19_PROPERTY
, FUNCTION20_PROPERTY
, FIELD_MIRROR
FROM AR.AR_CHANGE_MATRIX#;
|
|
|