[Home] [Help] [Dependency Information]
Object Name: | AR_CHANGE_MATRIX |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.AR_CHANGE_MATRIX |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AR_CHANGE_MATRIX_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | CHANGE_MATRIX_ID |
AR_CHANGE_MATRIX_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
FORM
ZONE FIELD |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CHANGE_MATRIX_ID | NUMBER | (15) | Yes | Unique identifier for ar_change_matrix |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
ACTION | VARCHAR2 | (1) | Yes | Action this record is for; can be I (insert), U (update), D (delete) |
CHECK_IN_INSERT_MODE_FLAG | VARCHAR2 | (1) | Y or N flag if permission checking should be done in insert mode | |
FORM | VARCHAR2 | (30) | Yes | Form name |
ZONE | VARCHAR2 | (30) | Zone name | |
FIELD | VARCHAR2 | (30) | Field name | |
APPLICATION_ID | NUMBER | (15) | Application identifier | |
TRANSACTION_TYPE | VARCHAR2 | (20) | Lookup code for INV/CM | |
ACCOUNTING_RULE_TYPE | VARCHAR2 | (10) | Lookup code for RULE_TYPE | |
EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Exchange rate type | |
PROHIBIT_ALL_CHANGES_FLAG | VARCHAR2 | (1) | Y or N flag indicates whether all changes are prohibited | |
CHANGE_COMPLETE_FLAG | VARCHAR2 | (1) | Y or N flag indicates whether changes can be made when the transaction is incomplete | |
CHANGE_RULES_FLAG | VARCHAR2 | (1) | Y or N flag indicates whether changes can be made if the transaction uses invoicing rules | |
CHANGE_PRINTED_FLAG | VARCHAR2 | (1) | Y or N flag indicates whether changes can be made after printing | |
CHANGE_ACTIVITY_FLAG | VARCHAR2 | (1) | Y or N flag indicates whether changes can be made after activity has occurred | |
CHANGE_POSTED_FLAG | VARCHAR2 | (1) | Y or N flag indicates whether changes can be made after the transaction has been posted | |
CHANGE_AUTORULE_FLAG | VARCHAR2 | (1) | Y or N flag indicates whether changes can be made after AutoRule has been run for this transaction | |
CHANGE_REV_BASED_ON_SREP_FLAG | VARCHAR2 | (1) | Y or N flag indicates whether changes can be made when the CHANGE_CUST_ON_TRX option is set | |
CHANGE_CHANGE_CUST_ON_TRX_FLAG | VARCHAR2 | (1) | Y or N flag indicates whether changes can be made when the CHANGE_CUST_ON_TRX option has been set | |
CHG_CHANGE_PRINTED_INV_FLAG | VARCHAR2 | (1) | Yes/No flag if changes can be made after the transaction has been printed. | |
CHANGE_TAX_UPDATE_FLAG | VARCHAR2 | (1) | Yes/No flag if changes can be made when the TAX_UPDATE_FLAG is set. | |
CHG_USE_INV_ACCT_FOR_CM_FLAG | VARCHAR2 | (1) | Yes/No flag if changes can be made when the USE_INV_ACCT_FOR_CM_FLAG option has been set. | |
CHANGE_INVOICE_DELETION_FLAG | VARCHAR2 | (1) | Yes/No flag if changes can be made when the INVOICE_DELETION_FLAG has been set. | |
CHANGE_AR_UPDATE_DUE_DATE_FLAG | VARCHAR2 | (1) | Yes/No flag if changes can be made when the AR_UPDATE_DUE_DATE_FLAG has been set. | |
CHANGE_CHANGE_CUST_NAME_FLAG | VARCHAR2 | (1) | Yes/No flag if changes can be made when the CHANGE_CUST_NAME_FLAG has been set. | |
COMPLETE_MESSAGE_NAME | VARCHAR2 | (30) | Message dictionary message name that is displayed when the complete constraint is violated. | |
RULES_MESSAGE_NAME | VARCHAR2 | (30) | Message dictionary message name that is displayed when the rules constraint is violated. | |
PRINTED_MESSAGE_NAME | VARCHAR2 | (30) | Message dictionary message name that is displayed when the printed constraint is violated. | |
ACTIVITY_MESSAGE_NAME | VARCHAR2 | (30) | Message dictionary message name that is displayed when the activity constraint is violated. | |
POSTED_MESSAGE_NAME | VARCHAR2 | (30) | Message dictionary message name that is displayed when the posted constraint is violated. | |
AUTORULE_MESSAGE_NAME | VARCHAR2 | (30) | Message dictionary message name that is displayed when the AutoRule constraint is violated. | |
CHANGE_CUST_ON_TRX_MSG_NAME | VARCHAR2 | (30) | Message dictionary message name that is displayed when the CHANGE_CUST_ON_TRX constraint is violated. | |
CHANGES_AFTER_PRINT_MSG_NAME | VARCHAR2 | (30) | Message dictionary message name that is displayed when the CHANGES_AFTER_PRINTING constraint is violated. | |
TAX_UPDATE_MESSAGE_NAME | VARCHAR2 | (30) | Message dictionary message name that is displayed when the TAX_UPDATE constraint is violated. | |
USE_INV_ACCT_FOR_CM_MSG_NAME | VARCHAR2 | (30) | Message dictionary message name that is displayed when the USE_INV_ACCT_FOR_CM constraint is violated. | |
INVOICE_DELETION_MESSAGE_NAME | VARCHAR2 | (30) | Message dictionary message name that is displayed when the INVOICE_DELETION constraint is violated. | |
AR_UPDATE_DUE_DATE_MSG_NAME | VARCHAR2 | (30) | Message dictionary message name that is displayed when the AR_UPDATE_DUE_DATE constraint is violated. | |
CHANGE_CUST_NAME_MESSAGE_NAME | VARCHAR2 | (30) | Message dictionary message name that is displayed when the CHANGE_CUST_NAME constraint is violated. | |
REV_BASED_ON_SREP_MSG_NAME | VARCHAR2 | (30) | Message dictionary message name that is displayed when the REV_BASED_ON_SREP constraint is violated. | |
PROHIBIT_ALL_CHANGES_MSG_NAME | VARCHAR2 | (30) | Message dictionary message name that is displayed when the PROHIBIT_ALL_CHANGES constraint is violated. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CHANGE_UNCONFIRMED_INV_FLAG | VARCHAR2 | (1) | Yes/No flag if changes can be made when the CHANGE_UNCONFIRMED_INV_FLAG has been set. | |
CHANGE_UNCONF_INV_MSG_NAME | VARCHAR2 | (30) | Message dictionary message name that is displayed when the CHANGE_CUST_NAME_FLAG constraint has been violated. | |
BATCH_SOURCE_TYPE | VARCHAR2 | (30) | Foreign key to ra_batch_Sources.batch_source_type. Imported if the batch source is used by AutoInvoice; Manual otherwise | |
CHANGE_AUTOTAX_FLAG | VARCHAR2 | (1) | Yes/No flag if changes can be made when the CHANGE_AUTOTAX_FLAG has been set. | |
AUTOTAX_MSG_NAME | VARCHAR2 | (30) | Message dictionary message name that is displayed when the AutoTax constraint has been violated. | |
ACCOUNTING_METHOD | VARCHAR2 | (30) | The accounting method that is being used. May be CASH or ACCRUAL. | |
CREATED_FROM | VARCHAR2 | (30) | Short name of the form to which this constraint applies. | |
CANVAS | VARCHAR2 | (30) | For internal use only | |
CANVAS_TO_CHANGE | VARCHAR2 | (30) | For internal use only | |
CHANGE_USSGL_FLAG | VARCHAR2 | (1) | For internal use only | |
CHANGE_FUNCTION1_FLAG | VARCHAR2 | (1) | For internal use only | |
CHANGE_FUNCTION2_FLAG | VARCHAR2 | (1) | For internal use only | |
CHANGE_FUNCTION3_FLAG | VARCHAR2 | (1) | For internal use only | |
CHANGE_FUNCTION4_FLAG | VARCHAR2 | (1) | For internal use only | |
CHANGE_FUNCTION5_FLAG | VARCHAR2 | (1) | For internal use only | |
CHANGE_FUNCTION6_FLAG | VARCHAR2 | (1) | For internal use only | |
CHANGE_FUNCTION7_FLAG | VARCHAR2 | (1) | For internal use only | |
CHANGE_FUNCTION8_FLAG | VARCHAR2 | (1) | For internal use only | |
CHANGE_FUNCTION9_FLAG | VARCHAR2 | (1) | For internal use only | |
CHANGE_FUNCTION10_FLAG | VARCHAR2 | (1) | For internal use only | |
CHANGE_FUNCTION11_FLAG | VARCHAR2 | (1) | For internal use only | |
CHANGE_FUNCTION12_FLAG | VARCHAR2 | (1) | For internal use only | |
CHANGE_FUNCTION13_FLAG | VARCHAR2 | (1) | For internal use only | |
CHANGE_FUNCTION14_FLAG | VARCHAR2 | (1) | For internal use only | |
CHANGE_FUNCTION15_FLAG | VARCHAR2 | (1) | For internal use only | |
CHANGE_FUNCTION16_FLAG | VARCHAR2 | (1) | For internal use only | |
CHANGE_FUNCTION17_FLAG | VARCHAR2 | (1) | For internal use only | |
CHANGE_FUNCTION18_FLAG | VARCHAR2 | (1) | For internal use only | |
CHANGE_FUNCTION19_FLAG | VARCHAR2 | (1) | For internal use only | |
CHANGE_FUNCTION20_FLAG | VARCHAR2 | (1) | For internal use only | |
USSGL_MSG_NAME | VARCHAR2 | (30) | For internal use only | |
FUNCTION1_MSG_NAME | VARCHAR2 | (30) | For internal use only | |
FUNCTION2_MSG_NAME | VARCHAR2 | (30) | For internal use only | |
FUNCTION3_MSG_NAME | VARCHAR2 | (30) | For internal use only | |
FUNCTION4_MSG_NAME | VARCHAR2 | (30) | For internal use only | |
FUNCTION5_MSG_NAME | VARCHAR2 | (30) | For internal use only | |
FUNCTION6_MSG_NAME | VARCHAR2 | (30) | For internal use only | |
FUNCTION7_MSG_NAME | VARCHAR2 | (30) | For internal use only | |
FUNCTION8_MSG_NAME | VARCHAR2 | (30) | For internal use only | |
FUNCTION9_MSG_NAME | VARCHAR2 | (30) | For internal use only | |
FUNCTION10_MSG_NAME | VARCHAR2 | (30) | For internal use only | |
FUNCTION11_MSG_NAME | VARCHAR2 | (30) | For internal use only | |
FUNCTION12_MSG_NAME | VARCHAR2 | (30) | For internal use only | |
FUNCTION13_MSG_NAME | VARCHAR2 | (30) | For internal use only | |
FUNCTION14_MSG_NAME | VARCHAR2 | (30) | For internal use only | |
FUNCTION15_MSG_NAME | VARCHAR2 | (30) | For internal use only | |
FUNCTION16_MSG_NAME | VARCHAR2 | (30) | For internal use only | |
FUNCTION17_MSG_NAME | VARCHAR2 | (30) | For internal use only | |
FUNCTION18_MSG_NAME | VARCHAR2 | (30) | For internal use only | |
FUNCTION19_MSG_NAME | VARCHAR2 | (30) | For internal use only | |
FUNCTION20_MSG_NAME | VARCHAR2 | (30) | For internal use only | |
COMPLETE_PROPERTY | VARCHAR2 | (20) | For internal use only | |
RULES_PROPERTY | VARCHAR2 | (20) | For internal use only | |
PRINTED_PROPERTY | VARCHAR2 | (20) | For internal use only | |
ACTIVITY_PROPERTY | VARCHAR2 | (20) | For internal use only | |
POSTED_PROPERTY | VARCHAR2 | (20) | For internal use only | |
AUTORULE_PROPERTY | VARCHAR2 | (20) | For internal use only | |
CHANGE_CUST_ON_TRX_PROPERTY | VARCHAR2 | (20) | For internal use only | |
CHANGES_AFTER_PRINT_PROPERTY | VARCHAR2 | (20) | For internal use only | |
TAX_UPDATE_PROPERTY | VARCHAR2 | (20) | For internal use only | |
USE_INV_ACCT_FOR_CM_PROPERTY | VARCHAR2 | (20) | For internal use only | |
INVOICE_DELETION_PROPERTY | VARCHAR2 | (20) | For internal use only | |
AR_UPDATE_DUE_DATE_PROPERTY | VARCHAR2 | (20) | For internal use only | |
CHANGE_CUST_NAME_PROPERTY | VARCHAR2 | (20) | For internal use only | |
REV_BASED_ON_SREP_PROPERTY | VARCHAR2 | (20) | For internal use only | |
PROHIBIT_ALL_CHANGES_PROPERTY | VARCHAR2 | (20) | For internal use only | |
CHANGE_UNCONF_INV_PROPERTY | VARCHAR2 | (20) | For internal use only | |
USSGL_PROPERTY | VARCHAR2 | (20) | For internal use only | |
AUTOTAX_PROPERTY | VARCHAR2 | (20) | For internal use only | |
FUNCTION1_PROPERTY | VARCHAR2 | (20) | For internal use only | |
FUNCTION2_PROPERTY | VARCHAR2 | (20) | For internal use only | |
FUNCTION3_PROPERTY | VARCHAR2 | (20) | For internal use only | |
FUNCTION4_PROPERTY | VARCHAR2 | (20) | For internal use only | |
FUNCTION5_PROPERTY | VARCHAR2 | (20) | For internal use only | |
FUNCTION6_PROPERTY | VARCHAR2 | (20) | For internal use only | |
FUNCTION7_PROPERTY | VARCHAR2 | (20) | For internal use only | |
FUNCTION8_PROPERTY | VARCHAR2 | (20) | For internal use only | |
FUNCTION9_PROPERTY | VARCHAR2 | (20) | For internal use only | |
FUNCTION10_PROPERTY | VARCHAR2 | (20) | For internal use only | |
FUNCTION11_PROPERTY | VARCHAR2 | (20) | For internal use only | |
FUNCTION12_PROPERTY | VARCHAR2 | (20) | For internal use only | |
FUNCTION13_PROPERTY | VARCHAR2 | (20) | For internal use only | |
FUNCTION14_PROPERTY | VARCHAR2 | (20) | For internal use only | |
FUNCTION15_PROPERTY | VARCHAR2 | (20) | For internal use only | |
FUNCTION16_PROPERTY | VARCHAR2 | (20) | For internal use only | |
FUNCTION17_PROPERTY | VARCHAR2 | (20) | For internal use only | |
FUNCTION18_PROPERTY | VARCHAR2 | (20) | For internal use only | |
FUNCTION19_PROPERTY | VARCHAR2 | (20) | For internal use only | |
FUNCTION20_PROPERTY | VARCHAR2 | (20) | For internal use only | |
FIELD_MIRROR | VARCHAR2 | (30) | For internal use only |
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;
AR.AR_CHANGE_MATRIX does not reference any database object
AR.AR_CHANGE_MATRIX is referenced by following:
|
|
|