RA_CUST_TRX_TYPES_ALL
The RA_CUST_TRX_TYPES_ALL table stores information about each transaction type used for invoices, bills receivable, and credit memos. Each row includes AutoAccounting information as well as standard defaults for the transaction that results. The POST_TO_GL column stores Y or N to indicate if this transaction can post to your General Ledger. The ACCOUNTING_AFFECT_FLAG column stores Y or N to indicate if this transaction can update your open receivables balances. If the ACCOUNTING_AFFECT_FLAG column is Y, the transaction will appear in aging. The TYPE column contains values: INV for Invoice, CM for Credit Memo, and DM for Debit Memo. If AutoAccounting is based on transaction type, the GL_ID_REV, GL_ID_FREIGHT, and GL_ID_REC columns store the default revenue, freight, and receivables accounts. The STATUS and CREDIT_MEMO_TYPE_ID columns are required even though they are null allowed. The primary key for this table is CUST_TRX_TYPE_ID.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
RA_CUST_TRX_TYPES_ALL_PK |
CUST_TRX_TYPE_SEQ_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| CUST_TRX_TYPE_ID | NUMBER | 18 | Yes | Transaction type identifier | ||
| MODULE_ID | VARCHAR2 | 32 | Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data. | |||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| POST_TO_GL | VARCHAR2 | 1 | Yes | Indicates if transactions should be posted to the General Ledger. Y for yes, N otherwise. | ||
| ACCOUNTING_AFFECT_FLAG | VARCHAR2 | 1 | Yes | Indicates if transactions affect open receivable balances. Y for yes, N otherwise. | ||
| CREDIT_MEMO_TYPE_ID | NUMBER | 18 | Transaction type identifier of subsequent credit memos | |||
| STATUS | VARCHAR2 | 30 | Transaction type status flag. Lookup code for CODE_STATUS. | |||
| NAME | VARCHAR2 | 20 | Transaction type name | |||
| DESCRIPTION | VARCHAR2 | 80 | Transaction type description | |||
| TYPE | VARCHAR2 | 20 | Transaction class, such as INV, CM, DM, or CB | |||
| DEFAULT_TERM | NUMBER | 18 | Term to default for invoices of this type | |||
| DEFAULT_PRINTING_OPTION | VARCHAR2 | 20 | Yes | Printing option to default for invoices of this type | ||
| DEFAULT_STATUS | VARCHAR2 | 20 | Yes | Status to default for invoices of this type | ||
| SUBSEQUENT_TRX_TYPE_ID | NUMBER | 18 | Invoice type for invoices related to a commitment of this type | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Transaction Types (RA_CUST_TRX_TYPES) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Types (RA_CUST_TRX_TYPES) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Types (RA_CUST_TRX_TYPES) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Types (RA_CUST_TRX_TYPES) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Types (RA_CUST_TRX_TYPES) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Types (RA_CUST_TRX_TYPES) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Types (RA_CUST_TRX_TYPES) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Types (RA_CUST_TRX_TYPES) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Types (RA_CUST_TRX_TYPES) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Types (RA_CUST_TRX_TYPES) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Types (RA_CUST_TRX_TYPES) | ||
| ALLOW_FREIGHT_FLAG | VARCHAR2 | 1 | Yes | Indicates if freight is allowed with the transaction. Y for yes, N otherwise. | ||
| ALLOW_OVERAPPLICATION_FLAG | VARCHAR2 | 1 | Yes | Indicates if applications can exceed the transaction amount. Y for yes, N otherwise. | ||
| CREATION_SIGN | VARCHAR2 | 30 | Yes | Determines allowable signs for transactions | ||
| END_DATE | DATE | Transaction type end date | ||||
| START_DATE | DATE | Yes | Transaction type start date | |||
| TAX_CALCULATION_FLAG | VARCHAR2 | 1 | Yes | Indicates if tax is allowed on transactions. Y for yes, N otherwise. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Types (RA_CUST_TRX_TYPES) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Types (RA_CUST_TRX_TYPES) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Types (RA_CUST_TRX_TYPES) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Types (RA_CUST_TRX_TYPES) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Types (RA_CUST_TRX_TYPES) | ||
| NATURAL_APPLICATION_ONLY_FLAG | VARCHAR2 | 1 | Yes | Indicates if you want to restrict the direction in which items with this transaction type can be updated by applications entered against them. Y for yes, N otherwise. | ||
| SET_ID | NUMBER | 18 | Yes | Identifies a set of reference data shared across business units and other entities. Also known as Reference Data Sets, they are used to filter reference data in transactional UIs. | ||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE1 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE2 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE3 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE4 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE5 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| RULE_SET_ID | NUMBER | Application rule set ID for this transaction type | ||||
| SIGNED_FLAG | VARCHAR2 | 1 | Indicates if the drawee needs to accept the bills receivable. Y if acceptance is required, N otherwise. | |||
| DRAWEE_ISSUED_FLAG | VARCHAR2 | 1 | Indicates whether or not the drawee issues the bills receivable. If issued by the drawee, the value is Y, otherwise N. | |||
| MAGNETIC_FORMAT_CODE | VARCHAR2 | 30 | Code used to distinguish between accepted bills receivable, promissory notes, and unsigned bills receivable. | |||
| FORMAT_PROGRAM_ID | NUMBER | 18 | Identifier of the program that will be used to format bills receivable. | |||
| ALLOCATE_TAX_FREIGHT | VARCHAR2 | 1 | Determines if Receivables will permit the allocation of tax and freight against this type of deposit. | |||
| LEGAL_ENTITY_ID | NUMBER | 18 | Default legal entity assigned to transactions using this transaction type | |||
| EXCLUDE_FROM_LATE_CHARGES | VARCHAR2 | 30 | Control if late charge can be assessed | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| CUST_TRX_TYPE_SEQ_ID | NUMBER | 18 | Yes | Transaction type sequence identifier. | ||
| CREDIT_MEMO_TYPE_SEQ_ID | NUMBER | 18 | Credit memo type sequence identifier. | |||
| SUBSEQUENT_TRX_TYPE_SEQ_ID | NUMBER | 18 | Subsequent transaction type sequence identifier. | |||
| DOCUMENT_TYPE | VARCHAR2 | 15 | Document type. | |||
| ORG_ID | NUMBER | 18 | Indicates the identifier of the business unit associated to the row. | |||
| ADJ_POST_TO_GL_FLAG | VARCHAR2 | 1 | Option to indicate if posting of transaction adjustments to general ledger is enabled. | |||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | |||
| ALLOW_FUTURE_ACCT_DATE_FLAG | VARCHAR2 | 1 | Indicates whether a future accounting date is allowed on a transaction when chronological document sequencing is enabled on the ledger. | |||
| CONTROL_COMPLETION_LEVEL_CODE | VARCHAR2 | 30 | Lookup codes under the ORA_AR_CNTRL_COMPLETION_LEVEL lookup type that determine the level of control of transaction completion enabled on the transaction type. Valid values are NEGATIVE_LINE_AMT, ALL, NONE. | |||
| USAGE_CATEGORY_CODE | VARCHAR2 | 30 | Indicates the usage category assigned to this transaction type. Valid values are derived from the lookup type ORA_AR_USAGE_CATEGORY. | |||
| TRX_SUB_CLASS_CODE | VARCHAR2 | 30 | Indicates the transaction subclass assigned to this transaction type. Valid values are derived from the lookup type ORA_AR_TRX_SUB_CLASS. | |||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | ||
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| ra_customer_trx_all | ra_cust_trx_types_all | CUST_TRX_TYPE_SEQ_ID |
| hes_fee_attributes_b | ra_cust_trx_types_all | CUST_TRX_TYPE_SEQ_ID |
| hes_fee_attributes_b | ra_cust_trx_types_all | CREDIT_CUST_TRX_TYPE_SEQ_ID |
| hes_transaction_post_all | ra_cust_trx_types_all | CUST_TRX_TYPE_SEQ_ID |
| ra_batch_sources_all | ra_cust_trx_types_all | DEFAULT_INV_TRX_TYPE_SEQ_ID |
| ar_system_parameters_all | ra_cust_trx_types_all | LATE_CHARGE_INV_TYPE_SEQ_ID |
| ar_system_parameters_all | ra_cust_trx_types_all | LATE_CHARGE_DM_TYPE_SEQ_ID |
| jl_br_ar_select_controls_all | ra_cust_trx_types_all | CUST_TRX_TYPE_SEQ_ID |
| ar_interest_headers_all | ra_cust_trx_types_all | CUST_TRX_TYPE_SEQ_ID |
| jl_br_ar_pay_sched_aux | ra_cust_trx_types_all | CUSTOMER_TRX_TYPE_ID |
| okc_k_headers_all_b_h | ra_cust_trx_types_all | INV_TRX_TYPE_ID |
| hes_credits_all_b | ra_cust_trx_types_all | CUST_TRX_TYPE_SEQ_ID |
| hes_discount_all_b | ra_cust_trx_types_all | CREDIT_TRX_SEQ_TYPE_ID |
| ra_interface_lines_all | ra_cust_trx_types_all | CUST_TRX_TYPE_SEQ_ID |
| okc_k_headers_all_b | ra_cust_trx_types_all | INV_TRX_TYPE_ID |
| ar_payment_schedules_all | ra_cust_trx_types_all | CUST_TRX_TYPE_SEQ_ID |
| hes_credit_periods_b | ra_cust_trx_types_all | CUST_TRX_TYPE_SEQ_ID |
| ar_late_charge_trx_t | ra_cust_trx_types_all | CUST_TRX_TYPE_SEQ_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| RA_CUST_TRX_TYPES_ALL_U1 | Unique | Default | CUST_TRX_TYPE_SEQ_ID, ORA_SEED_SET1 |
| RA_CUST_TRX_TYPES_ALL_U11 | Unique | Default | CUST_TRX_TYPE_SEQ_ID, ORA_SEED_SET2 |
| RA_CUST_TRX_TYPES_N1 | Non Unique | Default | LAST_UPDATE_DATE |
| RA_CUST_TRX_TYPES_U1 | Unique | APPS_TS_TX_DATA | CUST_TRX_TYPE_ID, SET_ID, ORA_SEED_SET1 |
| RA_CUST_TRX_TYPES_U11 | Unique | APPS_TS_TX_DATA | CUST_TRX_TYPE_ID, SET_ID, ORA_SEED_SET2 |