RA_CUSTOMER_TRX_ALL
This table contains invoice, debit memo, bills receivable, and credit memo header information. Each row in this table includes general invoice information such as customer, transaction type, and printing instructions. One row exists for each invoice, debit memo, bill receivable, and credit memo. Invoices, debit memos, credit memos, and bills receivable are distinguished by their associated transaction types stored in the this table.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
RA_CUSTOMER_TRX_PK |
CUSTOMER_TRX_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| CUSTOMER_TRX_ID | NUMBER | 18 | Yes | Transaction identifier. | ||
| SRC_INVOICING_RULE_ID | NUMBER | 18 | Stores invoice rule internal identifier for the invoices whose revenue is managed in Revenue Management. | |||
| BILL_TEMPLATE_NAME | VARCHAR2 | 240 | This column stores template used to print transactions. This template is also used to preview the transaction through the ADF UI. | |||
| REQUIRES_MANUAL_SCHEDULING | VARCHAR2 | 1 | Indicates if manual scheduling is required. | |||
| INTERCOMPANY_FLAG | VARCHAR2 | 1 | Indicates if invoice is intercompany. | |||
| 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. | |||
| TRX_NUMBER | VARCHAR2 | 20 | Yes | Transaction number. | ||
| TRX_DATE | DATE | Yes | Transaction date. | |||
| SET_OF_BOOKS_ID | NUMBER | 18 | Yes | identifies ledger associated with the interface line. | ||
| BILL_TO_CONTACT_ID | NUMBER | 18 | Bill to customer contact identifier. | |||
| BATCH_ID | NUMBER | 18 | Transaction batch identifier. | |||
| REASON_CODE | VARCHAR2 | 30 | Not currently used. | |||
| SOLD_TO_CUSTOMER_ID | NUMBER | 18 | Sold to customer identifier. | |||
| SOLD_TO_CONTACT_ID | NUMBER | 18 | Sold to customer contact identifier. | |||
| SOLD_TO_SITE_USE_ID | NUMBER | 18 | Sold to customer site use identifier. | |||
| BILL_TO_CUSTOMER_ID | NUMBER | 18 | Bill to customer identifier. | |||
| BILL_TO_SITE_USE_ID | NUMBER | 18 | Bill to customer site use identifier. | |||
| SHIP_TO_CUSTOMER_ID | NUMBER | 18 | Ship to customer identifier. | |||
| SHIP_TO_CONTACT_ID | NUMBER | 18 | Ship to customer contact identifier. | |||
| SHIP_TO_SITE_USE_ID | NUMBER | 18 | Ship to customer site use identifier. | |||
| SHIPMENT_ID | NUMBER | 18 | Shipment identifier. | |||
| REMIT_TO_ADDRESS_ID | NUMBER | 18 | Remit to address identifier. | |||
| TERM_ID | NUMBER | 18 | Payment term identifier. | |||
| TERM_DUE_DATE | DATE | Payment term due date identifier. | ||||
| PREVIOUS_CUSTOMER_TRX_ID | NUMBER | 18 | Previous transaction identifier. | |||
| PRINTING_ORIGINAL_DATE | DATE | Original print date. | ||||
| PRINTING_LAST_PRINTED | DATE | Last printed date. | ||||
| PRINTING_OPTION | VARCHAR2 | 20 | Indicates if transaction should print. | |||
| PRINTING_COUNT | NUMBER | 18 | Printing count. | |||
| PRINTING_PENDING | VARCHAR2 | 1 | Pending print. | |||
| PURCHASE_ORDER | VARCHAR2 | 50 | Purchase order number. | |||
| PURCHASE_ORDER_REVISION | VARCHAR2 | 50 | Purchase order revision | |||
| PURCHASE_ORDER_DATE | DATE | Purchase order date. | ||||
| CUSTOMER_REFERENCE | VARCHAR2 | 30 | Customer transaction reference. | |||
| CUSTOMER_REFERENCE_DATE | DATE | Customer transaction reference date. | ||||
| COMMENTS | VARCHAR2 | 1760 | Not currently used. | |||
| INTERNAL_NOTES | VARCHAR2 | 240 | Not currently used. | |||
| EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Currency conversion rate type. | |||
| EXCHANGE_DATE | DATE | Currency conversion date. | ||||
| EXCHANGE_RATE | NUMBER | Currency conversion date. | ||||
| TERRITORY_ID | NUMBER | 18 | Territory identifier. | |||
| INVOICE_CURRENCY_CODE | VARCHAR2 | 15 | Invoice currency code. | |||
| INITIAL_CUSTOMER_TRX_ID | NUMBER | 18 | Initial transaction identifier. | |||
| AGREEMENT_ID | NUMBER | 18 | Customer agreement identifier. | |||
| END_DATE_COMMITMENT | DATE | Not currently used. | ||||
| START_DATE_COMMITMENT | DATE | Not currently used. | ||||
| LAST_PRINTED_SEQUENCE_NUM | NUMBER | 18 | Last printed document sequence number. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Transactions (RA_CUSTOMER_TRX) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transactions (RA_CUSTOMER_TRX) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transactions (RA_CUSTOMER_TRX) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transactions (RA_CUSTOMER_TRX) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transactions (RA_CUSTOMER_TRX) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transactions (RA_CUSTOMER_TRX) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transactions (RA_CUSTOMER_TRX) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transactions (RA_CUSTOMER_TRX) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transactions (RA_CUSTOMER_TRX) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transactions (RA_CUSTOMER_TRX) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transactions (RA_CUSTOMER_TRX) | ||
| ORIG_SYSTEM_BATCH_NAME | VARCHAR2 | 40 | Batch name from originating system. | |||
| POST_REQUEST_ID | NUMBER | 18 | Not currently used. | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
| PROGRAM_APPLICATION_ID | NUMBER | 18 | Who column: indicates application that last updated this row. Foreign key to FND_APPLICATION.APPLICATION_ID. | |||
| PROGRAM_ID | NUMBER | 18 | Who column: indicates program that last updated this row. Foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID. | |||
| PROGRAM_UPDATE_DATE | DATE | Who column: date when a program last updated this row. | ||||
| FINANCE_CHARGES | VARCHAR2 | 1 | Yes or No flag that Indicates if transaction is exempt from late charges. | |||
| COMPLETE_FLAG | VARCHAR2 | 1 | Yes | Indicates if transaction is complete. | ||
| POSTING_CONTROL_ID | NUMBER | 18 | Posting status identifier. | |||
| BILL_TO_ADDRESS_ID | NUMBER | 18 | Bill to customer address identifier. | |||
| RA_POST_LOOP_NUMBER | NUMBER | 18 | Not currently used. | |||
| SHIP_TO_ADDRESS_ID | NUMBER | 18 | Ship to customer address identifier. | |||
| CREDIT_METHOD_FOR_RULES | VARCHAR2 | 30 | Credit method for invoices with rules. | |||
| CREDIT_METHOD_FOR_INSTALLMENTS | VARCHAR2 | 30 | Credit method for invoices with multiple installments. | |||
| RECEIPT_METHOD_ID | NUMBER | 18 | Receipt method identifier. | |||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transactions (RA_CUSTOMER_TRX) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transactions (RA_CUSTOMER_TRX) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transactions (RA_CUSTOMER_TRX) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transactions (RA_CUSTOMER_TRX) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transactions (RA_CUSTOMER_TRX) | ||
| RELATED_CUSTOMER_TRX_ID | NUMBER | 18 | Related customer identifier. | |||
| INVOICING_RULE_ID | NUMBER | 18 | Invoicing rule identifier. | |||
| SHIP_VIA | VARCHAR2 | 30 | Shipping vendor. | |||
| SHIP_DATE_ACTUAL | DATE | Actual shipment date. | ||||
| WAYBILL_NUMBER | VARCHAR2 | 50 | Waybill number | |||
| FOB_POINT | VARCHAR2 | 30 | Freight on board point. | |||
| CUSTOMER_BANK_ACCOUNT_ID | NUMBER | 18 | Customer bank account identifier. | |||
| INTERFACE_HEADER_ATTRIBUTE1 | VARCHAR2 | 30 | Interface header attribute 1. | Invoice Transactions (RA_INTERFACE_HEADER) | ||
| INTERFACE_HEADER_ATTRIBUTE2 | VARCHAR2 | 30 | Interface header attribute 2. | Invoice Transactions (RA_INTERFACE_HEADER) | ||
| INTERFACE_HEADER_ATTRIBUTE3 | VARCHAR2 | 30 | Interface header attribute 3. | Invoice Transactions (RA_INTERFACE_HEADER) | ||
| INTERFACE_HEADER_ATTRIBUTE4 | VARCHAR2 | 30 | Interface header attribute 4. | Invoice Transactions (RA_INTERFACE_HEADER) | ||
| INTERFACE_HEADER_ATTRIBUTE5 | VARCHAR2 | 30 | Interface header attribute 5. | Invoice Transactions (RA_INTERFACE_HEADER) | ||
| INTERFACE_HEADER_ATTRIBUTE6 | VARCHAR2 | 30 | Interface header attribute 6. | Invoice Transactions (RA_INTERFACE_HEADER) | ||
| INTERFACE_HEADER_ATTRIBUTE7 | VARCHAR2 | 30 | Interface header attribute 7. | Invoice Transactions (RA_INTERFACE_HEADER) | ||
| INTERFACE_HEADER_ATTRIBUTE8 | VARCHAR2 | 30 | Interface header attribute 8. | Invoice Transactions (RA_INTERFACE_HEADER) | ||
| INTERFACE_HEADER_CONTEXT | VARCHAR2 | 30 | Interface header context. | Invoice Transactions (RA_INTERFACE_HEADER) | ||
| DEFAULT_USSGL_TRX_CODE_CONTEXT | VARCHAR2 | 30 | Not currently used. | Government Transactions (RA_CUSTOMER_TRX_GOV) | ||
| INTERFACE_HEADER_ATTRIBUTE10 | VARCHAR2 | 30 | Interface header attribute 10. | Invoice Transactions (RA_INTERFACE_HEADER) | ||
| INTERFACE_HEADER_ATTRIBUTE11 | VARCHAR2 | 30 | Interface header attribute 11. | Invoice Transactions (RA_INTERFACE_HEADER) | ||
| INTERFACE_HEADER_ATTRIBUTE12 | VARCHAR2 | 30 | Interface header attribute 12. | Invoice Transactions (RA_INTERFACE_HEADER) | ||
| INTERFACE_HEADER_ATTRIBUTE13 | VARCHAR2 | 30 | Interface header attribute 13. | Invoice Transactions (RA_INTERFACE_HEADER) | ||
| INTERFACE_HEADER_ATTRIBUTE14 | VARCHAR2 | 30 | Interface header attribute 14. | Invoice Transactions (RA_INTERFACE_HEADER) | ||
| INTERFACE_HEADER_ATTRIBUTE15 | VARCHAR2 | 30 | Interface header attribute 15. | Invoice Transactions (RA_INTERFACE_HEADER) | ||
| INTERFACE_HEADER_ATTRIBUTE9 | VARCHAR2 | 30 | Interface header attribute 9. | Invoice Transactions (RA_INTERFACE_HEADER) | ||
| DEFAULT_USSGL_TRANSACTION_CODE | VARCHAR2 | 30 | Not currently used. | Government Transactions (RA_CUSTOMER_TRX_GOV) | ||
| RECURRED_FROM_TRX_NUMBER | VARCHAR2 | 20 | Transaction number used when a transaction was copied. | |||
| STATUS_TRX | VARCHAR2 | 30 | Status of the transaction. | |||
| DOC_SEQUENCE_ID | NUMBER | 18 | Document sequence identifier. | |||
| DOC_SEQUENCE_VALUE | NUMBER | 18 | Document sequence value. | |||
| PAYING_CUSTOMER_ID | NUMBER | 18 | Paying customer identifier. | |||
| PAYING_SITE_USE_ID | NUMBER | 18 | Paying customer site use identifier. | |||
| DEFAULT_TAX_EXEMPT_FLAG | VARCHAR2 | 1 | Indicates for default for tax exemption. | |||
| CREATED_FROM | VARCHAR2 | 30 | Yes | Indicates from which application the transaction is created. | ||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | ||
| WH_UPDATE_DATE | DATE | Date of who column update. | ||||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Receivables Transaction Region Information (JE_RA_CUSTOMER_TRX) | ||
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Receivables Transaction Region Information (JE_RA_CUSTOMER_TRX) | ||
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Receivables Transaction Region Information (JE_RA_CUSTOMER_TRX) | ||
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Receivables Transaction Region Information (JE_RA_CUSTOMER_TRX) | ||
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Receivables Transaction Region Information (JE_RA_CUSTOMER_TRX) | ||
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Receivables Transaction Region Information (JE_RA_CUSTOMER_TRX) | ||
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Receivables Transaction Region Information (JE_RA_CUSTOMER_TRX) | ||
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Receivables Transaction Region Information (JE_RA_CUSTOMER_TRX) | ||
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Receivables Transaction Region Information (JE_RA_CUSTOMER_TRX) | ||
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Receivables Transaction Region Information (JE_RA_CUSTOMER_TRX) | ||
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Receivables Transaction Region Information (JE_RA_CUSTOMER_TRX) | ||
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Receivables Transaction Region Information (JE_RA_CUSTOMER_TRX) | ||
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Receivables Transaction Region Information (JE_RA_CUSTOMER_TRX) | ||
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Receivables Transaction Region Information (JE_RA_CUSTOMER_TRX) | ||
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Receivables Transaction Region Information (JE_RA_CUSTOMER_TRX) | ||
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Receivables Transaction Region Information (JE_RA_CUSTOMER_TRX) | ||
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Receivables Transaction Region Information (JE_RA_CUSTOMER_TRX) | ||
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Receivables Transaction Region Information (JE_RA_CUSTOMER_TRX) | ||
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Receivables Transaction Region Information (JE_RA_CUSTOMER_TRX) | ||
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Receivables Transaction Region Information (JE_RA_CUSTOMER_TRX) | ||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | Receivables Transaction Region Information (JE_RA_CUSTOMER_TRX) | ||
| EDI_PROCESSED_FLAG | VARCHAR2 | 1 | Not currently used. | |||
| EDI_PROCESSED_STATUS | VARCHAR2 | 10 | Not currently used. | |||
| GLOBAL_ATTRIBUTE21 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE22 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE23 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE24 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE25 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE26 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE27 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE28 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE29 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE30 | VARCHAR2 | 240 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Receivables Transaction Region Information (JE_RA_CUSTOMER_TRX) | |||
| GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Receivables Transaction Region Information (JE_RA_CUSTOMER_TRX) | |||
| GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Receivables Transaction Region Information (JE_RA_CUSTOMER_TRX) | |||
| GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Receivables Transaction Region Information (JE_RA_CUSTOMER_TRX) | |||
| GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Receivables Transaction Region Information (JE_RA_CUSTOMER_TRX) | |||
| GLOBAL_ATTRIBUTE_NUMBER6 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Receivables Transaction Region Information (JE_RA_CUSTOMER_TRX) | |||
| GLOBAL_ATTRIBUTE_NUMBER7 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Receivables Transaction Region Information (JE_RA_CUSTOMER_TRX) | |||
| GLOBAL_ATTRIBUTE_NUMBER8 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Receivables Transaction Region Information (JE_RA_CUSTOMER_TRX) | |||
| GLOBAL_ATTRIBUTE_NUMBER9 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Receivables Transaction Region Information (JE_RA_CUSTOMER_TRX) | |||
| GLOBAL_ATTRIBUTE_NUMBER10 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Receivables Transaction Region Information (JE_RA_CUSTOMER_TRX) | |||
| GLOBAL_ATTRIBUTE_NUMBER11 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Receivables Transaction Region Information (JE_RA_CUSTOMER_TRX) | |||
| GLOBAL_ATTRIBUTE_NUMBER12 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Receivables Transaction Region Information (JE_RA_CUSTOMER_TRX) | |||
| GLOBAL_ATTRIBUTE_DATE1 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Receivables Transaction Region Information (JE_RA_CUSTOMER_TRX) | |||
| GLOBAL_ATTRIBUTE_DATE2 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Receivables Transaction Region Information (JE_RA_CUSTOMER_TRX) | |||
| GLOBAL_ATTRIBUTE_DATE3 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Receivables Transaction Region Information (JE_RA_CUSTOMER_TRX) | |||
| GLOBAL_ATTRIBUTE_DATE4 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Receivables Transaction Region Information (JE_RA_CUSTOMER_TRX) | |||
| GLOBAL_ATTRIBUTE_DATE5 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Receivables Transaction Region Information (JE_RA_CUSTOMER_TRX) | |||
| MRC_EXCHANGE_RATE_TYPE | VARCHAR2 | 2000 | Not currently used. | |||
| MRC_EXCHANGE_DATE | VARCHAR2 | 2000 | Not currently used. | |||
| MRC_EXCHANGE_RATE | VARCHAR2 | 2000 | Not currently used. | |||
| PAYMENT_SERVER_ORDER_NUM | VARCHAR2 | 80 | Payment server order number. | |||
| APPROVAL_CODE | VARCHAR2 | 80 | Approval code. | |||
| ADDRESS_VERIFICATION_CODE | VARCHAR2 | 80 | Address verification code. | |||
| OLD_TRX_NUMBER | VARCHAR2 | 20 | Stores value of the old document sequence transaction number. | |||
| BR_AMOUNT | NUMBER | Total amount of a bill receivable. | ||||
| BR_UNPAID_FLAG | VARCHAR2 | 1 | Indicates that the drawee failed to pay the bill receivable on the maturity date. | |||
| BR_ON_HOLD_FLAG | VARCHAR2 | 1 | Indicates that the bill receivable is on hold and cannot be remitted. | |||
| DRAWEE_ID | NUMBER | 18 | Bill receivable drawee identifier. | |||
| DRAWEE_CONTACT_ID | NUMBER | 18 | Bill receivable drawee contact identifier. | |||
| DRAWEE_SITE_USE_ID | NUMBER | 18 | Bill receivable drawee site use identifier. | |||
| REMITTANCE_BANK_ACCOUNT_ID | NUMBER | 18 | Bill receivable drawee bank account identifier. | |||
| OVERRIDE_REMIT_ACCOUNT_FLAG | VARCHAR2 | 1 | Indicates if remittance bank account can be overridden. | |||
| DRAWEE_BANK_ACCOUNT_ID | NUMBER | 18 | Bill receivable drawee bank account identifier. | |||
| SPECIAL_INSTRUCTIONS | VARCHAR2 | 240 | Special instructions that can print on invoice. | |||
| REMITTANCE_BATCH_ID | NUMBER | 18 | Remittance batch identifier. | |||
| PREPAYMENT_FLAG | VARCHAR2 | 1 | Indicates if prepayment exists. | |||
| CT_REFERENCE | VARCHAR2 | 30 | Derived Reference Field is derived from Interface Header attribute based on the batch source. | |||
| CONTRACT_ID | NUMBER | Not currently used. | ||||
| BILL_TEMPLATE_ID | NUMBER | 18 | Not currently used. | |||
| REVERSED_CASH_RECEIPT_ID | NUMBER | 18 | Reversed cash receipt identifier. | |||
| CC_ERROR_CODE | VARCHAR2 | 80 | Error code from credit card payment processor. | |||
| CC_ERROR_TEXT | VARCHAR2 | 255 | User enterable description for credit card error code. | |||
| CC_ERROR_FLAG | VARCHAR2 | 1 | Indicates if credit card processing error exists. | |||
| UPGRADE_METHOD | VARCHAR2 | 30 | Signifies which method customer upgraded from previous version of Oracle Application to current version of Oracle Applications. | |||
| LEGAL_ENTITY_ID | NUMBER | 18 | Legal entity identifier. | |||
| REMIT_BANK_ACCT_USE_ID | NUMBER | 18 | Remittance bank account use identifier. | |||
| PAYMENT_TRXN_EXTENSION_ID | NUMBER | 18 | Payment transaction extension identifier for credit card or bank account payment processing. Identifier of the transaction created in Fusion Oracle Payments for processing the credit card or bank account payment. | |||
| AX_ACCOUNTED_FLAG | VARCHAR2 | 1 | Not currently used. | |||
| APPLICATION_ID | NUMBER | 18 | Identifies the application that created this row. | |||
| PAYMENT_ATTRIBUTES | VARCHAR2 | 1000 | Used for grouping transactions for payment processing. | |||
| BILLING_DATE | DATE | Billing date for balance forward bill transactions. | ||||
| INTEREST_HEADER_ID | NUMBER | 18 | Interest header identifier of the late charge batch header for which the transaction is created. | |||
| LATE_CHARGES_ASSESSED | VARCHAR2 | 30 | Indicates if late charges are assessed. | |||
| CUST_TRX_TYPE_SEQ_ID | NUMBER | 18 | Yes | Transaction type sequence identifier. | ||
| BATCH_SOURCE_SEQ_ID | NUMBER | 18 | Batch source sequence identifier. | |||
| RELATED_BATCH_SOURCE_SEQ_ID | NUMBER | 18 | Related batch source sequence identifier. | |||
| PRIMARY_RESOURCE_SALESREP_ID | NUMBER | 18 | Primary sales person identifier. | |||
| 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. | ||
| REMIT_TO_ADDRESS_SEQ_ID | NUMBER | 18 | Remit to address sequence identifier. | |||
| DEFAULT_TAXATION_COUNTRY | VARCHAR2 | 2 | Default country to calculate tax. | |||
| DOCUMENT_SUB_TYPE | VARCHAR2 | 240 | Transaction header level tax determining attribute referred to in the user interface as Document Fiscal Classification. | |||
| TRX_BUSINESS_CATEGORY | VARCHAR2 | 240 | Transaction business category tax determinant. | |||
| USER_DEFINED_FISC_CLASS | VARCHAR2 | 30 | User defined fiscal classification tax determinant. | |||
| SOURCE_DOCUMENT_ID | NUMBER | 18 | Source Document Identifier | |||
| SOURCE_DOCUMENT_TYPE | VARCHAR2 | 240 | Source Document Type | |||
| TRX_CLASS | VARCHAR2 | 20 | Class of the transaction. | |||
| FIRST_PTY_REG_ID | NUMBER | 18 | Deploying company's Tax Registration number | |||
| THIRD_PTY_REG_ID | NUMBER | 18 | Bill-to Customer Tax Registration Number | |||
| FISCAL_DOC_ACCESS_KEY | VARCHAR2 | 50 | Key to identify a document uniquely in the govt. system. | |||
| FISCAL_DOC_STATUS | VARCHAR2 | 30 | The status of the fiscal document returned by fiscal authority. If a fiscal document request is originated from shipping and fiscal document is approved without errors, shipping can ship the goods. Similarly, if the request is made from AR, AR invoice can be completed after fiscal document is approved. | |||
| DELIVERY_METHOD_CODE | VARCHAR2 | 30 | Method used to deliver printed transactions. Valid values are E-Mail, Paper and XML. | |||
| DEL_CONTACT_EMAIL_ADDRESS | VARCHAR2 | 1000 | E-Mail address of the customer bill-to contact who receives printed transactions. | |||
| PRINT_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the last print. | |||
| SHIP_TO_PARTY_ID | NUMBER | 18 | Identifier of the ship-to party. | |||
| SHIP_TO_PARTY_CONTACT_ID | NUMBER | 18 | Identifier of the ship-to party contact. | |||
| SHIP_TO_PARTY_SITE_USE_ID | NUMBER | 18 | Identifier of the ship-to party site use. | |||
| SHIP_TO_PARTY_ADDRESS_ID | NUMBER | 18 | Identifier of the ship-to party address. | |||
| SOLD_TO_PARTY_ID | NUMBER | 18 | Identifier of the sold-to party. | |||
| DOCUMENT_TYPE_ID | NUMBER | 18 | Unique identifier of a source document type. | |||
| SOURCE_SYSTEM | VARCHAR2 | 120 | The source system sending the data. | |||
| DOCUMENT_CREATION_DATE | DATE | Date when the document is created in the source application. | ||||
| REV_REC_APPLICATION | VARCHAR2 | 30 | Indicates the application is used for revenue recognition. | |||
| BILLING_EXT_REQUEST_ID | NUMBER | 18 | Request that processed the billing line details of the document. | |||
| BILL_PLAN_ID | NUMBER | 18 | Identifier of the recurring bill plan. | |||
| BILL_PLAN_PERIOD | NUMBER | Period that identifies the number of recurring invoices for the bill plan. | ||||
| READY_FOR_XML_DELIVERY_FLAG | VARCHAR2 | 1 | Indicates whether the transaction is eligible to be processed for XML invoice delivery. When using extension attributes in XML invoice, this field has to be set to Y after extension attributes for a transaction are loaded into AR_EXTENSION_ATTRIBUTES table. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| INTERFACE_HEADER_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| INTERFACE_HEADER_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| INTERFACE_HEADER_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| INTERFACE_HEADER_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| INTERFACE_HEADER_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| INTERFACE_HEADER_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| INTERFACE_HEADER_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| INTERFACE_HEADER_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| INTERFACE_HEADER_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| INTERFACE_HEADER_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| STRUCTURED_PAYMENT_REFERENCE | VARCHAR2 | 256 | An industry standard reference on receivables transactions composed of letters, check digits, and transaction information, used to identify the transaction, transaction lines, and its payments to the customer and bank. | |||
| CONTROL_COMPLETION_REASON_CODE | VARCHAR2 | 30 | Lookup codes under the ORA_AR_CNTRL_COMPLETION_REASON lookup type that determine the reason for control on transaction completion. Valid values are NEGATIVE_LINE_AMT_NOT_ALLOWED, NO_TRX_ALLOWED_TO_COMPLETE, ALLOWED_TO_COMPLETE. The value is updated to ALLOWED_TO_COMPLETE using the Web Service once the transaction is reviewed and validated. | |||
| DOCUMENT_STATUS_CODE | VARCHAR2 | 30 | Indicates the status of the transaction document. For example, if an invoice has gone through review and approval, the value of this column will be Approved. Valid values are derived from the lookup type ORA_AR_TRX_DOCUMENT_STATUS. Any filter condition on this column is combined with the column COMPLETE_FLAG. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| RA_CUSTOMER_TRX_ALL | hz_cust_account_roles | BILL_TO_CONTACT_ID |
| RA_CUSTOMER_TRX_ALL | hz_cust_accounts | BILL_TO_CUSTOMER_ID |
| RA_CUSTOMER_TRX_ALL | hz_cust_site_uses_all | BILL_TO_SITE_USE_ID |
| RA_CUSTOMER_TRX_ALL | hz_cust_accounts | SHIP_TO_CUSTOMER_ID |
| RA_CUSTOMER_TRX_ALL | hz_cust_site_uses_all | SHIP_TO_SITE_USE_ID |
| RA_CUSTOMER_TRX_ALL | hz_cust_account_roles | SHIP_TO_CONTACT_ID |
| RA_CUSTOMER_TRX_ALL | ra_terms_b | TERM_ID |
| RA_CUSTOMER_TRX_ALL | ra_customer_trx_all | PREVIOUS_CUSTOMER_TRX_ID |
| RA_CUSTOMER_TRX_ALL | ra_remit_tos_all | REMIT_TO_ADDRESS_ID |
| RA_CUSTOMER_TRX_ALL | jtf_rs_salesreps | PRIMARY_RESOURCE_SALESREP_ID |
| RA_CUSTOMER_TRX_ALL | ra_cust_trx_types_all | CUST_TRX_TYPE_SEQ_ID |
| RA_CUSTOMER_TRX_ALL | ra_customer_trx_all | INITIAL_CUSTOMER_TRX_ID |
| RA_CUSTOMER_TRX_ALL | iby_ext_bank_accounts | CUSTOMER_BANK_ACCOUNT_ID |
| RA_CUSTOMER_TRX_ALL | hz_cust_accounts | PAYING_CUSTOMER_ID |
| RA_CUSTOMER_TRX_ALL | hz_cust_site_uses_all | PAYING_SITE_USE_ID |
| RA_CUSTOMER_TRX_ALL | hz_cust_acct_sites_all | REMIT_TO_ADDRESS_ID |
| RA_CUSTOMER_TRX_ALL | ar_receipt_methods | RECEIPT_METHOD_ID |
| RA_CUSTOMER_TRX_ALL | iby_ext_bank_accounts | DRAWEE_BANK_ACCOUNT_ID |
| RA_CUSTOMER_TRX_ALL | ce_bank_accounts | REMITTANCE_BANK_ACCOUNT_ID |
| RA_CUSTOMER_TRX_ALL | ar_batches_all | REMITTANCE_BATCH_ID |
| RA_CUSTOMER_TRX_ALL | ar_bpa_templates_b | BILL_TEMPLATE_ID |
| RA_CUSTOMER_TRX_ALL | hz_cust_acct_sites_all | BILL_TO_ADDRESS_ID |
| RA_CUSTOMER_TRX_ALL | hz_cust_account_roles | DRAWEE_CONTACT_ID |
| RA_CUSTOMER_TRX_ALL | hz_cust_acct_sites_all | SHIP_TO_ADDRESS_ID |
| RA_CUSTOMER_TRX_ALL | ce_bank_acct_uses_all | REMIT_BANK_ACCT_USE_ID |
| RA_CUSTOMER_TRX_ALL | iby_fndcpt_tx_extensions | PAYMENT_TRXN_EXTENSION_ID |
| RA_CUSTOMER_TRX_ALL | ar_interest_headers_all | INTEREST_HEADER_ID |
| RA_CUSTOMER_TRX_ALL | ra_batch_sources_all | BATCH_SOURCE_SEQ_ID |
| RA_CUSTOMER_TRX_ALL | gl_daily_conversion_types | EXCHANGE_RATE_TYPE |
| RA_CUSTOMER_TRX_ALL | ra_customer_trx_all | RELATED_CUSTOMER_TRX_ID |
| RA_CUSTOMER_TRX_ALL | ra_rules | INVOICING_RULE_ID |
| RA_CUSTOMER_TRX_ALL | ar_cash_receipts_all | REVERSED_CASH_RECEIPT_ID |
| RA_CUSTOMER_TRX_ALL | xle_entity_profiles | LEGAL_ENTITY_ID |
| RA_CUSTOMER_TRX_ALL | ra_batch_sources_all | RELATED_BATCH_SOURCE_SEQ_ID |
| RA_CUSTOMER_TRX_ALL | hz_parties | SHIP_TO_PARTY_ID |
| RA_CUSTOMER_TRX_ALL | hz_party_site_uses | SHIP_TO_PARTY_SITE_USE_ID |
| RA_CUSTOMER_TRX_ALL | hz_party_sites | SHIP_TO_PARTY_ADDRESS_ID |
| RA_CUSTOMER_TRX_ALL | hz_parties | SOLD_TO_PARTY_ID |
| RA_CUSTOMER_TRX_ALL | hz_cust_accounts | SOLD_TO_CUSTOMER_ID |
| RA_CUSTOMER_TRX_ALL | hz_cust_account_roles | SOLD_TO_CONTACT_ID |
| RA_CUSTOMER_TRX_ALL | hz_cust_site_uses_all | SOLD_TO_SITE_USE_ID |
| ar_cons_inv_trx_all | ra_customer_trx_all | CUSTOMER_TRX_ID |
| fun_trx_headers | ra_customer_trx_all | AR_CUSTOMER_TRX_ID |
| ra_customer_trx_all | ra_customer_trx_all | PREVIOUS_CUSTOMER_TRX_ID |
| ra_customer_trx_all | ra_customer_trx_all | INITIAL_CUSTOMER_TRX_ID |
| ra_customer_trx_all | ra_customer_trx_all | RELATED_CUSTOMER_TRX_ID |
| iex_delinquencies_all | ra_customer_trx_all | TRANSACTION_ID |
| ar_adjustments_all | ra_customer_trx_all | SUBSEQUENT_TRX_ID |
| ar_adjustments_all | ra_customer_trx_all | CHARGEBACK_CUSTOMER_TRX_ID |
| ar_adjustments_all | ra_customer_trx_all | CUSTOMER_TRX_ID |
| ar_cash_remit_refs_all | ra_customer_trx_all | CUSTOMER_TRX_ID |
| hes_transaction_post_all | ra_customer_trx_all | RESULT_CUSTOMER_TRX_ID |
| hes_transaction_post_all | ra_customer_trx_all | CUSTOMER_TRX_ID |
| ar_revenue_adjustments_all | ra_customer_trx_all | CUSTOMER_TRX_ID |
| ra_cust_trx_line_gl_dist_all | ra_customer_trx_all | CUSTOMER_TRX_ID |
| ar_incomplete_trx_hist | ra_customer_trx_all | CUSTOMER_TRX_ID |
| ar_bpa_delivery_details | ra_customer_trx_all | CUSTOMER_TRX_ID |
| ar_automatch_trx_t | ra_customer_trx_all | CUSTOMER_TRX_ID |
| ar_interest_lines_all | ra_customer_trx_all | ORIGINAL_TRX_ID |
| ar_ramc_audit_trail | ra_customer_trx_all | CUSTOMER_TRX_ID |
| ar_bpa_print_requests | ra_customer_trx_all | CUSTOMER_TRX_ID |
| jl_br_ar_pay_sched_aux | ra_customer_trx_all | CUSTOMER_TRX_ID |
| ar_trx_summary_hist | ra_customer_trx_all | CUSTOMER_TRX_ID |
| ar_interim_cash_receipts_all | ra_customer_trx_all | CUSTOMER_TRX_ID |
| ar_trx_summary | ra_customer_trx_all | LARGEST_INV_CUST_TRX_ID |
| ar_notes | ra_customer_trx_all | CUSTOMER_TRX_ID |
| okc_k_headers_all_b_h | ra_customer_trx_all | COMMITMENT_ID |
| ra_recur_interim | ra_customer_trx_all | CUSTOMER_TRX_ID |
| ra_recur_interim | ra_customer_trx_all | NEW_CUSTOMER_TRX_ID |
| ra_cm_requests_all | ra_customer_trx_all | CUSTOMER_TRX_ID |
| ra_cm_requests_all | ra_customer_trx_all | CM_CUSTOMER_TRX_ID |
| jl_br_ar_comp_inv_all | ra_customer_trx_all | CUSTOMER_TRX_ID |
| ar_deferred_lines_all | ra_customer_trx_all | CUSTOMER_TRX_ID |
| ra_interface_lines_all | ra_customer_trx_all | CUSTOMER_TRX_ID |
| ra_interface_lines_all | ra_customer_trx_all | RELATED_CUSTOMER_TRX_ID |
| ra_interface_lines_all | ra_customer_trx_all | PREVIOUS_CUSTOMER_TRX_ID |
| ra_interface_lines_all | ra_customer_trx_all | INITIAL_CUSTOMER_TRX_ID |
| ra_interface_lines_all | ra_customer_trx_all | INTERFACE_LINE_ID |
| ra_interface_lines_all | ra_customer_trx_all | PREPAY_CUSTOMER_TRX_ID |
| okc_k_headers_all_b | ra_customer_trx_all | COMMITMENT_ID |
| ra_cust_trx_line_salesreps_all | ra_customer_trx_all | CUSTOMER_TRX_ID |
| ar_payment_schedules_all | ra_customer_trx_all | CUSTOMER_TRX_ID |
| ar_cons_inv_trx_lines_all | ra_customer_trx_all | CUSTOMER_TRX_ID |
| ar_interim_cash_rcpt_lines_all | ra_customer_trx_all | CUSTOMER_TRX_ID |
| ra_customer_trx_lines_all | ra_customer_trx_all | PREVIOUS_CUSTOMER_TRX_ID |
| ra_customer_trx_lines_all | ra_customer_trx_all | CUSTOMER_TRX_ID |
| ra_customer_trx_lines_all | ra_customer_trx_all | PREPAY_CUSTOMER_TRX_ID |
| jl_br_ar_coll_docs_det_all | ra_customer_trx_all | CUSTOMER_TRX_ID |
| ar_receivable_applications_all | ra_customer_trx_all | CUSTOMER_TRX_ID |
| ar_receivable_applications_all | ra_customer_trx_all | APPLIED_CUSTOMER_TRX_ID |
| ar_late_charge_trx_t | ra_customer_trx_all | CUSTOMER_TRX_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| RA_CUSTOMER_TRX_N1 | Non Unique | Default | TRX_NUMBER, ORG_ID |
| RA_CUSTOMER_TRX_N10 | Non Unique | Default | PAYING_SITE_USE_ID |
| RA_CUSTOMER_TRX_N11 | Non Unique | Default | BILL_TO_CUSTOMER_ID, CUST_TRX_TYPE_SEQ_ID, AGREEMENT_ID |
| RA_CUSTOMER_TRX_N12 | Non Unique | Default | BATCH_ID |
| RA_CUSTOMER_TRX_N13 | Non Unique | Default | PRINTING_LAST_PRINTED |
| RA_CUSTOMER_TRX_N14 | Non Unique | Default | LAST_UPDATE_DATE |
| RA_CUSTOMER_TRX_N15 | Non Unique | Default | REQUEST_ID, CC_ERROR_FLAG |
| RA_CUSTOMER_TRX_N16 | Non Unique | Default | INITIAL_CUSTOMER_TRX_ID |
| RA_CUSTOMER_TRX_N17 | Non Unique | Default | PRINTING_PENDING, TRX_DATE |
| RA_CUSTOMER_TRX_N18 | Non Unique | Default | SHIP_TO_CUSTOMER_ID |
| RA_CUSTOMER_TRX_N19 | Non Unique | Default | GLOBAL_ATTRIBUTE1 |
| RA_CUSTOMER_TRX_N2 | Non Unique | Default | PURCHASE_ORDER |
| RA_CUSTOMER_TRX_N20 | Non Unique | Default | SOLD_TO_CUSTOMER_ID |
| RA_CUSTOMER_TRX_N21 | Non Unique | Default | DRAWEE_ID |
| RA_CUSTOMER_TRX_N22 | Non Unique | Default | REMITTANCE_BATCH_ID |
| RA_CUSTOMER_TRX_N23 | Non Unique | Default | CC_ERROR_FLAG |
| RA_CUSTOMER_TRX_N24 | Non Unique | Default | COMPLETE_FLAG |
| RA_CUSTOMER_TRX_N25 | Non Unique | Default | REQUIRES_MANUAL_SCHEDULING |
| RA_CUSTOMER_TRX_N26 | Non Unique | Default | BILL_PLAN_ID |
| RA_CUSTOMER_TRX_N27 | Non Unique | Default | WAYBILL_NUMBER |
| RA_CUSTOMER_TRX_N28 | Non Unique | Default | STRUCTURED_PAYMENT_REFERENCE |
| RA_CUSTOMER_TRX_N5 | Non Unique | Default | TRX_DATE |
| RA_CUSTOMER_TRX_N6 | Non Unique | Default | PREVIOUS_CUSTOMER_TRX_ID |
| RA_CUSTOMER_TRX_N7 | Non Unique | Default | CREATION_DATE |
| RA_CUSTOMER_TRX_N9 | Non Unique | Default | PAYING_CUSTOMER_ID |
| RA_CUSTOMER_TRX_U1 | Unique | Default | CUSTOMER_TRX_ID |
| RA_CUSTOMER_TRX_U2 | Unique | Default | REVERSED_CASH_RECEIPT_ID |