[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | RA_CUSTOMER_TRX_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | AR |
| FND Design Data: |  AR.RA_CUSTOMER_TRX_ALL
|
| Subobject Name: | |
| Status: | VALID |
The RA_CUSTOMER_TRX_ALL table stores invoice, debit memo, commitment, 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, commitment, bill receivable, and credit memo that you create in Oracle Receivables. Invoices, debit memos, credit memos, bills receivable, and commitments are distinguished by their associated transaction types, which are stored in the RA_CUST_TRX_TYPES_ALL table.
.
If you entered a credit memo, the PREVIOUS_CUSTOMER_TRX_ID column stores the customer transaction ID of the invoice that you credited. In the case of on-account credits, which are not related to any invoice when the credits are created, the PREVIOUS_CUSTOMER_TRX_ID column is null. If you create an invoice against a commitment, Receivables stores the customer transaction ID of the commitment in the INITIAL_CUSTOMER_TRX_ID column. Otherwise, the INITIAL_CUSTOMER_TRX_ID column is null.
.
The COMPLETE_FLAG column stores Y or N to indicate if the invoice is complete. When you complete an invoice, Receivables creates your payment schedules and updates any commitments against this invoice. Before an invoice can be completed, the invoice must have at least one invoice line, revenue records must exist for each line and add up to the line amount, and a sales tax record must exist for each line.
.
The SOLD_TO_CUSTOMER_ID, SOLD_TO_SITE_USE_ID, BILL_TO_CUSTOMER_ID, BILL_TO_SITE_USE_ID, SHIP_TO_SITE_USE_ID, PRINTING_OPTION, PRINTING_PENDING, TERM_ID, REMIT_TO_ADDRESS_ID, PRIMARY_SALES_REP_ID, and INVOICE_CURRENCY_CODE columns are required even though they are null allowed.
.
The primary key for this table is CUSTOMER_TRX_ID.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| RA_CUSTOMER_TRX_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 CUSTOMER_TRX_ID
|
| RA_CUSTOMER_TRX_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
REVERSED_CASH_RECEIPT_ID
|
| RA_CUSTOMER_TRX_U3 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
DOC_SEQUENCE_ID
DOC_SEQUENCE_VALUE
|
| RA_CUSTOMER_TRX_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
TRX_NUMBER
ORG_ID
|
| RA_CUSTOMER_TRX_N10 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PAYING_SITE_USE_ID
|
| RA_CUSTOMER_TRX_N11 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BILL_TO_CUSTOMER_ID
CUST_TRX_TYPE_ID
AGREEMENT_ID
|
| RA_CUSTOMER_TRX_N12 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BATCH_ID
|
| RA_CUSTOMER_TRX_N13 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PRINTING_LAST_PRINTED
|
| RA_CUSTOMER_TRX_N14 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LAST_UPDATE_DATE
|
| RA_CUSTOMER_TRX_N15 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
REQUEST_ID
CC_ERROR_FLAG
|
| RA_CUSTOMER_TRX_N16 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
INITIAL_CUSTOMER_TRX_ID
|
| RA_CUSTOMER_TRX_N17 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PRINTING_PENDING
TRX_DATE
|
| RA_CUSTOMER_TRX_N18 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SHIP_TO_CUSTOMER_ID
|
| RA_CUSTOMER_TRX_N19 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
GLOBAL_ATTRIBUTE1
|
| RA_CUSTOMER_TRX_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PURCHASE_ORDER
|
| RA_CUSTOMER_TRX_N20 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SOLD_TO_CUSTOMER_ID
|
| RA_CUSTOMER_TRX_N21 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
DRAWEE_ID
|
| RA_CUSTOMER_TRX_N22 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
REMITTANCE_BATCH_ID
|
| RA_CUSTOMER_TRX_N23 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CC_ERROR_FLAG
|
| RA_CUSTOMER_TRX_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
TRX_DATE
|
| RA_CUSTOMER_TRX_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PREVIOUS_CUSTOMER_TRX_ID
|
| RA_CUSTOMER_TRX_N7 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CREATION_DATE
|
| RA_CUSTOMER_TRX_N9 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PAYING_CUSTOMER_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CUSTOMER_TRX_ID | NUMBER | (15) | Yes | Invoice identifier |
| 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). |
| 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_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
| TRX_NUMBER | VARCHAR2 | (20) | Yes | Transaction number |
| CUST_TRX_TYPE_ID | NUMBER | (15) | Yes | Transaction type identifier |
| TRX_DATE | DATE | Yes | Invoice date | |
| SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Set of Books identifier |
| BILL_TO_CONTACT_ID | NUMBER | (15) | Contact identifier to send bills to | |
| BATCH_ID | NUMBER | (15) | Batch identifier | |
| BATCH_SOURCE_ID | NUMBER | (15) | Batch source identifier | |
| REASON_CODE | VARCHAR2 | (30) | Reason code identifier | |
| SOLD_TO_CUSTOMER_ID | NUMBER | (15) | Customer identifier | |
| SOLD_TO_CONTACT_ID | NUMBER | (15) | Sold to contact identifier | |
| SOLD_TO_SITE_USE_ID | NUMBER | (15) | Sold to site use identifier | |
| BILL_TO_CUSTOMER_ID | NUMBER | (15) | Customer identifier | |
| BILL_TO_SITE_USE_ID | NUMBER | (15) | Site use identifier billed | |
| SHIP_TO_CUSTOMER_ID | NUMBER | (15) | Customer identifier | |
| SHIP_TO_CONTACT_ID | NUMBER | (15) | Contact identifier for shipments | |
| SHIP_TO_SITE_USE_ID | NUMBER | (15) | Site identifier for the shipments | |
| SHIPMENT_ID | NUMBER | (15) | Not currently used | |
| REMIT_TO_ADDRESS_ID | NUMBER | (15) | Remit to address identifier | |
| TERM_ID | NUMBER | (15) | Payment term identifier | |
| TERM_DUE_DATE | DATE | Due date of the first payment | ||
| PREVIOUS_CUSTOMER_TRX_ID | NUMBER | (15) | Identifier for invoice credited | |
| PRIMARY_SALESREP_ID | NUMBER | (15) | Sale rep given primary credit for the transaction | |
| PRINTING_ORIGINAL_DATE | DATE | Date the first installment is printed | ||
| PRINTING_LAST_PRINTED | DATE | Last date any installment was printed | ||
| PRINTING_OPTION | VARCHAR2 | (20) | Revenue Accounting lookup code for INVOICE_PRINT_OPTIONS | |
| PRINTING_COUNT | NUMBER | (15) | This column shows the number of times this invoice was printed. If there are multiple installments for this invoice, this will increment once for every installment that was printed. | |
| PRINTING_PENDING | VARCHAR2 | (1) | Indicates if this invoice is waiting to be printed. Y for yes, N otherwise. | |
| PURCHASE_ORDER | VARCHAR2 | (50) | Purchase order | |
| PURCHASE_ORDER_REVISION | VARCHAR2 | (50) | Purchase order revision | |
| PURCHASE_ORDER_DATE | DATE | Date of purchase order | ||
| CUSTOMER_REFERENCE | VARCHAR2 | (30) | Customer identifier from foreign system | |
| CUSTOMER_REFERENCE_DATE | DATE | Additional comments | ||
| COMMENTS | VARCHAR2 | (1760) | Stores comments entered in the Transactions workbench. Value can be printed on an invoice using the Print Invoice view. | |
| INTERNAL_NOTES | VARCHAR2 | (240) | Stores the special instruction entered in the Transactions workbench. Value can be printed on an invoice with using the Print Invoice View | |
| EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Exchange rate type | |
| EXCHANGE_DATE | DATE | Date of the exchange rate | ||
| EXCHANGE_RATE | NUMBER | Exchange rate | ||
| TERRITORY_ID | NUMBER | (15) | Territory identifier | |
| INVOICE_CURRENCY_CODE | VARCHAR2 | (15) | Invoice currency | |
| INITIAL_CUSTOMER_TRX_ID | NUMBER | (15) | Identifier of a related commitment | |
| AGREEMENT_ID | NUMBER | (15) | Agreement identifier | |
| END_DATE_COMMITMENT | DATE | Date a commitment becomes active | ||
| START_DATE_COMMITMENT | DATE | Date a commitment becomes inactive | ||
| LAST_PRINTED_SEQUENCE_NUM | NUMBER | (15) | Last installment printed | |
| 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 | |
| ORIG_SYSTEM_BATCH_NAME | VARCHAR2 | (40) | Batch identifier from foreign system | |
| POST_REQUEST_ID | NUMBER | (15) | No longer used | |
| REQUEST_ID | NUMBER | (15) | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | |
| PROGRAM_ID | NUMBER | (15) | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | |
| PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
| FINANCE_CHARGES | VARCHAR2 | (1) | Indicates if finance charges are included. Y for yes, N otherwise. | |
| COMPLETE_FLAG | VARCHAR2 | (1) | Yes | Indicates if the invoice is complete. Y for yes, N otherwise. |
| POSTING_CONTROL_ID | NUMBER | (15) | Receivables posting batch identifier, -1, -2, and -4 for posted in previous releases and -3 for not posted | |
| BILL_TO_ADDRESS_ID | NUMBER | (15) | Identifies the bill-to address | |
| RA_POST_LOOP_NUMBER | NUMBER | (15) | No longer used | |
| SHIP_TO_ADDRESS_ID | NUMBER | (15) | Identifies the ship-to address | |
| CREDIT_METHOD_FOR_RULES | VARCHAR2 | (30) | Rule to use when crediting invoice account assignments for invoices that use invoicing and accounting rules | |
| CREDIT_METHOD_FOR_INSTALLMENTS | VARCHAR2 | (30) | Rule to use when crediting the payment schedules of split term transactions | |
| RECEIPT_METHOD_ID | NUMBER | (15) | Receipt method identifier | |
| 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 | |
| RELATED_CUSTOMER_TRX_ID | NUMBER | (15) | Related transaction identifier | |
| INVOICING_RULE_ID | NUMBER | (15) | Invoicing Rule identifier | |
| SHIP_VIA | VARCHAR2 | (30) | Ship via | |
| SHIP_DATE_ACTUAL | DATE | Ship date | ||
| WAYBILL_NUMBER | VARCHAR2 | (50) | Waybill number | |
| FOB_POINT | VARCHAR2 | (30) | Free on Board point | |
| CUSTOMER_BANK_ACCOUNT_ID | NUMBER | (15) | Identifies the customer bank account | |
| INTERFACE_HEADER_ATTRIBUTE1 | VARCHAR2 | (150) | Interface header attribute value | |
| INTERFACE_HEADER_ATTRIBUTE2 | VARCHAR2 | (150) | Interface header attribute value | |
| INTERFACE_HEADER_ATTRIBUTE3 | VARCHAR2 | (150) | Interface header attribute value | |
| INTERFACE_HEADER_ATTRIBUTE4 | VARCHAR2 | (150) | Interface header attribute value | |
| INTERFACE_HEADER_ATTRIBUTE5 | VARCHAR2 | (150) | Interface header attribute value | |
| INTERFACE_HEADER_ATTRIBUTE6 | VARCHAR2 | (150) | Interface header attribute value | |
| INTERFACE_HEADER_ATTRIBUTE7 | VARCHAR2 | (150) | Interface header attribute value | |
| INTERFACE_HEADER_ATTRIBUTE8 | VARCHAR2 | (150) | Interface header attribute value | |
| INTERFACE_HEADER_CONTEXT | VARCHAR2 | (30) | Interface header context | |
| DEFAULT_USSGL_TRX_CODE_CONTEXT | VARCHAR2 | (30) | Default context value for the USSGL Transaction Code Flexfield | |
| INTERFACE_HEADER_ATTRIBUTE10 | VARCHAR2 | (150) | Interface header attribute value | |
| INTERFACE_HEADER_ATTRIBUTE11 | VARCHAR2 | (150) | Interface header attribute value | |
| INTERFACE_HEADER_ATTRIBUTE12 | VARCHAR2 | (150) | Interface header attribute value | |
| INTERFACE_HEADER_ATTRIBUTE13 | VARCHAR2 | (150) | Interface header attribute value | |
| INTERFACE_HEADER_ATTRIBUTE14 | VARCHAR2 | (150) | Interface header attribute value | |
| INTERFACE_HEADER_ATTRIBUTE15 | VARCHAR2 | (150) | Interface header attribute value | |
| INTERFACE_HEADER_ATTRIBUTE9 | VARCHAR2 | (150) | Interface header attribute value | |
| DEFAULT_USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | Default value for the USSGL Transaction Code Flexfield | |
| RECURRED_FROM_TRX_NUMBER | VARCHAR2 | (20) | Model transaction for this record | |
| STATUS_TRX | VARCHAR2 | (30) | The status of the transaction | |
| DOC_SEQUENCE_ID | NUMBER | (15) | Identifies the document sequence | |
| DOC_SEQUENCE_VALUE | NUMBER | (15) | The value of the document sequence | |
| PAYING_CUSTOMER_ID | NUMBER | (15) | This column is required when the RECEIPT_METHOD_ID column is an automatic payment method. Otherwise, this column should be left null. | |
| PAYING_SITE_USE_ID | NUMBER | (15) | This column is required when the RECEIPT_METHOD_ID column is an automatic payment method. Otherwise, this column should be left null. | |
| RELATED_BATCH_SOURCE_ID | NUMBER | (15) | Related batch source identifier | |
| DEFAULT_TAX_EXEMPT_FLAG | VARCHAR2 | (1) | This column defaults to the tax exempt flag in RA_CUSTOMER_TRX_LINES_ALL upon manual data entry. | |
| CREATED_FROM | VARCHAR2 | (30) | Yes | Populated by code that points to form or program that created this row |
| ORG_ID | NUMBER | (15) | Organization identifier | |
| WH_UPDATE_DATE | DATE | Date sent to data warehouse | ||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE21 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE22 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE23 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE24 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE25 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE26 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE27 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE28 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE29 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE30 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Reserved for country-specific functionality | |
| EDI_PROCESSED_FLAG | VARCHAR2 | (1) | Indicates if this invoice was processed by EDI. Y for yes, N otherwise. | |
| EDI_PROCESSED_STATUS | VARCHAR2 | (10) | Status of the invoice (used by EDI) | |
| MRC_EXCHANGE_RATE_TYPE | VARCHAR2 | (2000) | Multiple Reporting Currencies only: Concatenated string of reporting Set of Books ID, currency conversion rate type pairs | |
| MRC_EXCHANGE_DATE | VARCHAR2 | (2000) | Multiple Reporting Currencies only: Concatenated string of reporting Set of Books ID, currency conversion date pairs | |
| MRC_EXCHANGE_RATE | VARCHAR2 | (2000) | Multiple Reporting Currencies only: Concatenated string of reporting Set of Books ID, currency conversion rate pairs | |
| PAYMENT_SERVER_ORDER_NUM | VARCHAR2 | (80) | A number that indicates the credit card payment was authorized by Oracle Payment Server. | |
| APPROVAL_CODE | VARCHAR2 | (80) | Payment approval code returned by credit card issuer | |
| ADDRESS_VERIFICATION_CODE | VARCHAR2 | (80) | Credit card address verification code returned by Oracle payment server | |
| OLD_TRX_NUMBER | VARCHAR2 | (20) | If the transaction batch source option copy document number to transaction number is set to Y, this column stores the old transaction number. | |
| BR_AMOUNT | NUMBER | The control amount of a bills receivable | ||
| BR_UNPAID_FLAG | VARCHAR2 | (1) | Indicates if a bills receivable is unpaid. It is Y if the bills receivable is unpaid. Otherwise, it is N. | |
| BR_ON_HOLD_FLAG | VARCHAR2 | (1) | Indicates if a bills receivable is on hold. It is Y if the bills receivable is on hold. Otherwise, it is N. | |
| DRAWEE_ID | NUMBER | (15) | Drawee customer identifier for a bills receivable | |
| DRAWEE_CONTACT_ID | NUMBER | (15) | Drawee contact identifier for a bills receivable | |
| DRAWEE_SITE_USE_ID | NUMBER | (15) | Drawee site identifier for a bills receivable | |
| REMITTANCE_BANK_ACCOUNT_ID | NUMBER | (15) | Identifies the user bank account for depositing the receipt | |
| OVERRIDE_REMIT_ACCOUNT_FLAG | VARCHAR2 | (1) | Indicates if the remittance bank account can be overridden by the remittance selection process. Y for yes, N otherwise. | |
| DRAWEE_BANK_ACCOUNT_ID | NUMBER | (15) | Drawee bank account identifier for a bills receivable | |
| SPECIAL_INSTRUCTIONS | VARCHAR2 | (240) | Special instructions that appear on a bills receivable | |
| REMITTANCE_BATCH_ID | NUMBER | (15) | This is the foreign key to the AR_BATCHES table. It points to the latest approved bills receivable remittance batch used to remit this transaction. | |
| PREPAYMENT_FLAG | VARCHAR2 | (1) | Indicates whether this transaction is a prepayment transaction | |
| CT_REFERENCE | VARCHAR2 | (150) | Derived Reference Field. Derived from Interface Header attribute based on the batch source | |
| CONTRACT_ID | NUMBER | Identifies the contract from Oracle Contracts Core that is associated with this line | ||
| BILL_TEMPLATE_ID | NUMBER | (15) | Identifies the template id of the presented bill | |
| REVERSED_CASH_RECEIPT_ID | NUMBER | (15) | CASH_RECEIPT_ID of receipt whose reversal created this debit memo | |
| 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) | Y indicates a transaction had a credit card processing error | |
| UPGRADE_METHOD | VARCHAR2 | (30) | Upgrade flag to indicate the origin of the transaction | |
| LEGAL_ENTITY_ID | NUMBER | (15) | Identifies the legal entity that owns or issues this transaction. | |
| REMIT_BANK_ACCT_USE_ID | NUMBER | (15) | Unique identifier of remittance bank account use that automatic receipt will be deposited into | |
| PAYMENT_TRXN_EXTENSION_ID | NUMBER | (15) | Payment extension identifier | |
| AX_ACCOUNTED_FLAG | VARCHAR2 | (1) | Upgrade flag to indicate the distributions have been upgraded by AX | |
| APPLICATION_ID | NUMBER | (15) | The column holds the originate application id of the transaction | |
| PAYMENT_ATTRIBUTES | VARCHAR2 | (1000) | Payment attributes used for grouping transaction lines. | |
| BILLING_DATE | DATE | Billing date for balance forward transactions | ||
| INTEREST_HEADER_ID | NUMBER | (15) | Fkey late charge | |
| LATE_CHARGES_ASSESSED | VARCHAR2 | (30) | Control if a transaction can be late charged | |
| TRAILER_NUMBER | VARCHAR2 | (50) |
Cut, paste (and edit) the following text to query this object:
SELECT CUSTOMER_TRX_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, TRX_NUMBER
, CUST_TRX_TYPE_ID
, TRX_DATE
, SET_OF_BOOKS_ID
, BILL_TO_CONTACT_ID
, BATCH_ID
, BATCH_SOURCE_ID
, REASON_CODE
, SOLD_TO_CUSTOMER_ID
, SOLD_TO_CONTACT_ID
, SOLD_TO_SITE_USE_ID
, BILL_TO_CUSTOMER_ID
, BILL_TO_SITE_USE_ID
, SHIP_TO_CUSTOMER_ID
, SHIP_TO_CONTACT_ID
, SHIP_TO_SITE_USE_ID
, SHIPMENT_ID
, REMIT_TO_ADDRESS_ID
, TERM_ID
, TERM_DUE_DATE
, PREVIOUS_CUSTOMER_TRX_ID
, PRIMARY_SALESREP_ID
, PRINTING_ORIGINAL_DATE
, PRINTING_LAST_PRINTED
, PRINTING_OPTION
, PRINTING_COUNT
, PRINTING_PENDING
, PURCHASE_ORDER
, PURCHASE_ORDER_REVISION
, PURCHASE_ORDER_DATE
, CUSTOMER_REFERENCE
, CUSTOMER_REFERENCE_DATE
, COMMENTS
, INTERNAL_NOTES
, EXCHANGE_RATE_TYPE
, EXCHANGE_DATE
, EXCHANGE_RATE
, TERRITORY_ID
, INVOICE_CURRENCY_CODE
, INITIAL_CUSTOMER_TRX_ID
, AGREEMENT_ID
, END_DATE_COMMITMENT
, START_DATE_COMMITMENT
, LAST_PRINTED_SEQUENCE_NUM
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ORIG_SYSTEM_BATCH_NAME
, POST_REQUEST_ID
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, FINANCE_CHARGES
, COMPLETE_FLAG
, POSTING_CONTROL_ID
, BILL_TO_ADDRESS_ID
, RA_POST_LOOP_NUMBER
, SHIP_TO_ADDRESS_ID
, CREDIT_METHOD_FOR_RULES
, CREDIT_METHOD_FOR_INSTALLMENTS
, RECEIPT_METHOD_ID
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, RELATED_CUSTOMER_TRX_ID
, INVOICING_RULE_ID
, SHIP_VIA
, SHIP_DATE_ACTUAL
, WAYBILL_NUMBER
, FOB_POINT
, CUSTOMER_BANK_ACCOUNT_ID
, INTERFACE_HEADER_ATTRIBUTE1
, INTERFACE_HEADER_ATTRIBUTE2
, INTERFACE_HEADER_ATTRIBUTE3
, INTERFACE_HEADER_ATTRIBUTE4
, INTERFACE_HEADER_ATTRIBUTE5
, INTERFACE_HEADER_ATTRIBUTE6
, INTERFACE_HEADER_ATTRIBUTE7
, INTERFACE_HEADER_ATTRIBUTE8
, INTERFACE_HEADER_CONTEXT
, DEFAULT_USSGL_TRX_CODE_CONTEXT
, INTERFACE_HEADER_ATTRIBUTE10
, INTERFACE_HEADER_ATTRIBUTE11
, INTERFACE_HEADER_ATTRIBUTE12
, INTERFACE_HEADER_ATTRIBUTE13
, INTERFACE_HEADER_ATTRIBUTE14
, INTERFACE_HEADER_ATTRIBUTE15
, INTERFACE_HEADER_ATTRIBUTE9
, DEFAULT_USSGL_TRANSACTION_CODE
, RECURRED_FROM_TRX_NUMBER
, STATUS_TRX
, DOC_SEQUENCE_ID
, DOC_SEQUENCE_VALUE
, PAYING_CUSTOMER_ID
, PAYING_SITE_USE_ID
, RELATED_BATCH_SOURCE_ID
, DEFAULT_TAX_EXEMPT_FLAG
, CREATED_FROM
, ORG_ID
, WH_UPDATE_DATE
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE21
, GLOBAL_ATTRIBUTE22
, GLOBAL_ATTRIBUTE23
, GLOBAL_ATTRIBUTE24
, GLOBAL_ATTRIBUTE25
, GLOBAL_ATTRIBUTE26
, GLOBAL_ATTRIBUTE27
, GLOBAL_ATTRIBUTE28
, GLOBAL_ATTRIBUTE29
, GLOBAL_ATTRIBUTE30
, GLOBAL_ATTRIBUTE_CATEGORY
, EDI_PROCESSED_FLAG
, EDI_PROCESSED_STATUS
, MRC_EXCHANGE_RATE_TYPE
, MRC_EXCHANGE_DATE
, MRC_EXCHANGE_RATE
, PAYMENT_SERVER_ORDER_NUM
, APPROVAL_CODE
, ADDRESS_VERIFICATION_CODE
, OLD_TRX_NUMBER
, BR_AMOUNT
, BR_UNPAID_FLAG
, BR_ON_HOLD_FLAG
, DRAWEE_ID
, DRAWEE_CONTACT_ID
, DRAWEE_SITE_USE_ID
, REMITTANCE_BANK_ACCOUNT_ID
, OVERRIDE_REMIT_ACCOUNT_FLAG
, DRAWEE_BANK_ACCOUNT_ID
, SPECIAL_INSTRUCTIONS
, REMITTANCE_BATCH_ID
, PREPAYMENT_FLAG
, CT_REFERENCE
, CONTRACT_ID
, BILL_TEMPLATE_ID
, REVERSED_CASH_RECEIPT_ID
, CC_ERROR_CODE
, CC_ERROR_TEXT
, CC_ERROR_FLAG
, UPGRADE_METHOD
, LEGAL_ENTITY_ID
, REMIT_BANK_ACCT_USE_ID
, PAYMENT_TRXN_EXTENSION_ID
, AX_ACCOUNTED_FLAG
, APPLICATION_ID
, PAYMENT_ATTRIBUTES
, BILLING_DATE
, INTEREST_HEADER_ID
, LATE_CHARGES_ASSESSED
, TRAILER_NUMBER
FROM AR.RA_CUSTOMER_TRX_ALL;
AR.RA_CUSTOMER_TRX_ALL does not reference any database object
AR.RA_CUSTOMER_TRX_ALL is referenced by following:
AR
RA_CUSTOMER_TRX_ALL#
|
|
|
|