DBA Data[Home] [Help] [Dependency Information]


TABLE: AR.AR_RECEIVABLE_APPLICATIONS_ALL

Object Details
Object Name: AR_RECEIVABLE_APPLICATIONS_ALL
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.AR_RECEIVABLE_APPLICATIONS_ALL
Subobject Name:
Status: VALID


The AR_RECEIVABLE_APPLICATIONS_ALL table stores all accounting entries for both your cash and credit memo applications. The APPLICATION_TYPE column stores either CASH or CM (for credit memo applications). Each row in this table includes the amount applied, status, and accounting flexfield information.
.
Possible application statuses include:
{{"bul:1"}}APP - Applied
{{"bul:1"}}UNAPP - Unapplied
{{"bul:1"}}ACC - On-Account
{{"bul:1"}}UNID - Unidentified
{{"bul:1"}}ACTIVITY - Receivable Activity
{{"bul:1"}}OTHER ACC - Other Receipt Application
{{"bodytext"}}Receivables looks at the application status to determine which flexfield account to use. Receivables uses the CODE_COMBINATION_ID foreign key column to associate this payment with the Unidentified flexfield account. The CODE_COMBINATION_ID column stores valid Accounting Flexfield segment value combinations that are credited in General Ledger when this application is posted.
.
Cash applications represent cash receipt applications. The sum of the AMOUNT_APPLIED column for cash applications should always equal the amount of the cash receipt. A negative value in the AMOUNT_APPLIED column becomes a debit when this application is posted to General Ledger.
.
When a cash receipt is initially created, Receivables creates a row in this table for the cash receipt amount with a status of UNAPP. For each subsequent application, Receivables creates two rows: one row with a status of APP for the amount that is applied to the invoice, and one row with status of UNAPP for the negative of the amount that is applied.
.
If you reverse a cash application, Receivables creates two new rows: one row with status of APP for the original application's inverse amount (the negative of the original application amount), and one row with a status of UNAPP for the positive amount of the application that is reversed.
.
Credit memo applications do not have rows with a status of UNAPP, and use only rows with a status of APP.
.
The CASH_RECEIPT_ID column stores the ID of the receipt that you entered. Receivables concurrently creates a record for this receipt in the AR_CASH_RECEIPTS_ALL table. This column is null for a credit memo application. The CUSTOMER_TRX_ID and PAYMENT_SCHEDULE_ID columns also identify the transaction that you are actually applying.
.
The APPLIED_CUSTOMER_TRX_ID and APPLIED_PAYMENT_SCHEDULE_ID columns identify the invoice or credit memo that receives the application.
.
If you apply a credit memo against the invoice, Receivables creates a record in this table. The CUSTOMER_TRX_ID and PAYMENT_SCHEDULE_ID columns for this record identify the credit memo that you are applying. The APPLIED_CUSTOMER_TRX_ID and APPLIED_PAYMENT_SCHEDULE_ID columns for this record belong to the invoice that is receiving the application.
.
If you combine an on-account credit and a receipt, Receivables creates a record in this table. The CASH_RECEIPT_ID and PAYMENT_SCHEDULE_ID columns for this record identify the receipt. The APPLIED_CUSTOMER_TRX_ID and APPLIED_PAYMENT_SCHEDULE_ID columns for this record identify the on-account credit that you are combining with the receipt.
.
The CONFIRMED_FLAG column is a denormalization from the AR_CASH_RECEIPTS_ALL table. If the cash receipt is not confirmed, the applications of that receipt are not reflected in the payment schedule of the transaction that the receipt is applied against.
.
For more details, see Technical Perspective: Transactions (Oracle Receivables User Guide).


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AR_RECEIVABLE_APPLICATIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRECEIVABLE_APPLICATION_ID
AR_RECEIVABLE_APPLICATIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCASH_RECEIPT_ID
ColumnSTATUS
AR_RECEIVABLE_APPLICATIONS_N10 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnGL_POSTED_DATE
AR_RECEIVABLE_APPLICATIONS_N11 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPOSTING_CONTROL_ID
ColumnGL_DATE
AR_RECEIVABLE_APPLICATIONS_N12 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONS_INV_ID
AR_RECEIVABLE_APPLICATIONS_N13 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLINK_TO_CUSTOMER_TRX_ID
AR_RECEIVABLE_APPLICATIONS_N14 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAYMENT_SET_ID
AR_RECEIVABLE_APPLICATIONS_N15 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_ID
AR_RECEIVABLE_APPLICATIONS_N16 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEVENT_ID
AR_RECEIVABLE_APPLICATIONS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUSTOMER_TRX_ID
AR_RECEIVABLE_APPLICATIONS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAYMENT_SCHEDULE_ID
ColumnGL_DATE
AR_RECEIVABLE_APPLICATIONS_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAPPLY_DATE
AR_RECEIVABLE_APPLICATIONS_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnGL_DATE
ColumnSET_OF_BOOKS_ID
ColumnORG_ID
ColumnSTATUS
ColumnAPPLICATION_TYPE
ColumnCONFIRMED_FLAG
AR_RECEIVABLE_APPLICATIONS_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCREATION_DATE
AR_RECEIVABLE_APPLICATIONS_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAPPLIED_PAYMENT_SCHEDULE_ID
ColumnGL_DATE
AR_RECEIVABLE_APPLICATIONS_N9 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAPPLIED_CUSTOMER_TRX_ID
Columns
Name Datatype Length Mandatory Comments
RECEIVABLE_APPLICATION_ID NUMBER (15) Yes Identifies the receivable application
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated 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.
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
AMOUNT_APPLIED NUMBER
Yes For same currency applications, the total amount of the application in the currency of the receipt and transaction. For cross currency applications, the total amount of the application in the currency of the transaction.
AMOUNT_APPLIED_FROM NUMBER

The amount applied to the transaction in the receipt currency. This field is used only for cross currency applications (will be null for same currency applications).
TRANS_TO_RECEIPT_RATE NUMBER

The exchange rate used to convert the amount applied in the transaction currency to the amount applied in the receipt currency. This field is used only for cross currency receipt applications.
GL_DATE DATE
Yes Date that this application will post to the General Ledger
CODE_COMBINATION_ID NUMBER (15) Yes General Ledger code combination (account)
SET_OF_BOOKS_ID NUMBER (15) Yes General Ledger Set of Books used (only one supported per organization)
DISPLAY VARCHAR2 (1) Yes Y or N flag to indicate whether this is the latest application
APPLY_DATE DATE
Yes Date the application was applied
APPLICATION_TYPE VARCHAR2 (20) Yes Lookup code for the type of application
STATUS VARCHAR2 (30) Yes Lookup type for the status of the application
PAYMENT_SCHEDULE_ID NUMBER (15) Yes Identifies the payment schedule of the payment or credit memo that is being applied
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).
CASH_RECEIPT_ID NUMBER (15)
Identifies the payment being applied
APPLIED_CUSTOMER_TRX_ID NUMBER (15)
Identifies the debit item or credit memo to which a payment or credit memo is applied
APPLIED_CUSTOMER_TRX_LINE_ID NUMBER (15)
The line number of the debit item or credit memo to which a payment or credit memo is applied
APPLIED_PAYMENT_SCHEDULE_ID NUMBER (15)
Identifies the payment schedule of the debit item or credit memo that a payment or credit memo was applied to
CUSTOMER_TRX_ID NUMBER (15)
Identifies the debit item or credit memo being applied
LINE_APPLIED NUMBER

Line amount applied
TAX_APPLIED NUMBER

Tax amount applied
FREIGHT_APPLIED NUMBER

Freight amount applied
RECEIVABLES_CHARGES_APPLIED NUMBER

Receivables charges amount applied
EARNED_DISCOUNT_TAKEN NUMBER

Amount of earned discount taken towards the application
UNEARNED_DISCOUNT_TAKEN NUMBER

Amount of unearned discount taken towards the application
DAYS_LATE NUMBER (15)
Difference between apply date and due date of transaction
APPLICATION_RULE VARCHAR2 (30) Yes Code used internally to identify which SQL statements in which modules created this record
GL_POSTED_DATE DATE

Date the application was posted to General Ledger
COMMENTS VARCHAR2 (240)
User's comments
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
POSTABLE VARCHAR2 (1)
Y or N indicates whether the item is postable to the General Ledger
POSTING_CONTROL_ID NUMBER (15) Yes Receivables posting batch identifier, -1, -2, and -4 for posted in previous releases and -3 for not posted
ACCTD_AMOUNT_APPLIED_FROM NUMBER
Yes Receipt portion in functional currency, converted using the receipt rate
ACCTD_AMOUNT_APPLIED_TO NUMBER

Amount allocated to the transaction in functional currency, converted using the transaction rate
ACCTD_EARNED_DISCOUNT_TAKEN NUMBER

Earned discount equivalent in the functional currency obtained using the invoice exchange rate
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
CONFIRMED_FLAG VARCHAR2 (1)
Null or Y when the cash receipt is confirmed, N if the cash receipt is not confirmed. Always use nvl (CONFIRMED_FLAG is Y) when checking this column.
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).
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).
USSGL_TRANSACTION_CODE VARCHAR2 (30)
Code defined by public sector accounting
USSGL_TRANSACTION_CODE_CONTEXT VARCHAR2 (30)
Context value for the USSGL Transaction Code Flexfield
EARNED_DISCOUNT_CCID NUMBER (15)
General Ledger code combination for the earned discount
UNEARNED_DISCOUNT_CCID NUMBER (15)
General Ledger code combination for the unearned discount
ACCTD_UNEARNED_DISCOUNT_TAKEN NUMBER

Unearned discount equivalent in the functional currency obtained using the invoice exchange rate
REVERSAL_GL_DATE DATE

This column is filled in for the records that have been reversed and for the reversing record as well.
CASH_RECEIPT_HISTORY_ID NUMBER (15)
Foreign key to the AR_CASH_RECEIPT_HISTORY table identifying the row that was current when the receivable application was created
ORG_ID NUMBER (15)
Organization identifier
TAX_CODE VARCHAR2 (50)
Tax code for on-account transactions
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_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Reserved for country-specific functionality
CONS_INV_ID NUMBER (15)
Consolidated invoice ID against which this adjustment appears
CONS_INV_ID_TO NUMBER (15)
Consolidated billing invoice ID which contains the application to the new site (if application of cash or credit memo is applied to a site that is different from the site that was originally assigned to the cash or credit memo transaction)
RULE_SET_ID NUMBER

The application rule set ID
LINE_EDISCOUNTED NUMBER

Amount of earned discount taken from the remaining line amount for the item
TAX_EDISCOUNTED NUMBER

Amount of earned discount taken from the remaining tax amount for the item
FREIGHT_EDISCOUNTED NUMBER

Amount of earned discount taken from the remaining freight amount for the item
CHARGES_EDISCOUNTED NUMBER

Amount of earned discount taken from the remaining receivables charges amount for the item
LINE_UEDISCOUNTED NUMBER

Amount of unearned discount taken from the remaining line amount for the item
TAX_UEDISCOUNTED NUMBER

Amount of unearned discount taken from the remaining tax amount for the item
FREIGHT_UEDISCOUNTED NUMBER

Amount of unearned discount taken from the remaining freight amount for the item
CHARGES_UEDISCOUNTED NUMBER

Amount of unearned discount taken from the remaining receivables charges for the item
RECEIVABLES_TRX_ID NUMBER (15)
Identifier of receivable activity.
ON_ACCOUNT_CUSTOMER NUMBER (15)
No longer used
MRC_AMOUNT_APPLIED VARCHAR2 (2000)
MRC only: Concatenated string of reporting set of books ID, total amount of the application pairs
MRC_AMOUNT_APPLIED_FROM VARCHAR2 (2000)
MRC only: Concatenated string of reporting set of books ID, total amount of the application in the currency of the receipt pairs
MRC_DISPLAY VARCHAR2 (2000)
MRC only: Concatenated string of reporting set of books ID, Y/N flag to indicate the latest application pairs
MRC_STATUS VARCHAR2 (2000)
MRC only: Concatenated string of reporting set of books ID, lookup type for the status of the application pairs
MRC_PAYMENT_SCHEDULE_ID VARCHAR2 (2000)
MRC only: Concatenated string of reporting set of books ID, payment schedule identifier or credit memo being applied pairs
MRC_CASH_RECEIPT_ID VARCHAR2 (2000)
MRC only: Concatenated string of reporting set of books ID, payment identifier being applied pairs
MRC_GL_POSTED_DATE VARCHAR2 (2000)
MRC only: Concatenated string of reporting set of books ID, receivable posting batch identifier pairs
MRC_POSTING_CONTROL_ID VARCHAR2 (2000)
MRC only: Concatenated string of reporting set of books ID, receivable posting batch identifier pairs
MRC_ACCTD_AMOUNT_APPLIED_FROM VARCHAR2 (2000)
MRC only: Concatenated string of reporting set of books ID, amount of the source converted pairs
MRC_ACCTD_AMOUNT_APPLIED_TO VARCHAR2 (2000)
MRC only: Concatenated string of reporting set of books ID, amount applied to item converted pairs
MRC_ACCTD_EARNED_DISC_TAKEN VARCHAR2 (2000)
MRC only: Concatenated string of reporting set of books ID, earned discount equivalent in the reporting currency(s) pairs
MRC_ACCTD_UNEARNED_DISC_TAKEN VARCHAR2 (2000)
MRC only: Concatenated string of reporting set of books ID unearned discount equivalent in the reporting currency(s) pairs
EDISC_TAX_ACCT_RULE VARCHAR2 (3)
Indicates the rule used to create the accounting for tax on earned discounts.
UNEDISC_TAX_ACCT_RULE VARCHAR2 (3)
Indicates the rule used to create the accounting for tax on unearned discounts.
LINK_TO_TRX_HIST_ID NUMBER (15)
This column is used to reference the transaction history record, which is associated with the movement of deferred tax due to maturity date event, or its subsequent reversal event.
LINK_TO_CUSTOMER_TRX_ID NUMBER (15)
This column is used to reference the transaction that is associated with the short term debt application.
APPLICATION_REF_TYPE VARCHAR2 (30)
Identifies the application reference type and determines the context for the APPLICATION_REF_ID and APPLICATION_REF_NUM columns
APPLICATION_REF_ID NUMBER (15)
Application reference identifier whose context is determined by the APPLICATION_REF_TYPE column's value
APPLICATION_REF_NUM VARCHAR2 (150)
User-visible application reference number whose context is determined by the APPLICATION_REF_TYPE column's value
CHARGEBACK_CUSTOMER_TRX_ID NUMBER (15)
OBSOLETED
SECONDARY_APPLICATION_REF_ID NUMBER (15)
Secondary application reference identifier of another transaction or application, such as a claim, that is associated with this receipt application
PAYMENT_SET_ID NUMBER (15)
Identifies the prepayment application's payment set ID
APPLICATION_REF_REASON VARCHAR2 (30)
Application reason code whose context is determined by the APPLICATION_REF_TYPE column's value
CUSTOMER_REFERENCE VARCHAR2 (100)
Reference supplied by customer
CUSTOMER_REASON VARCHAR2 (30)
Customer reason
APPLIED_REC_APP_ID NUMBER (15)
Identifies the Receivable Application record to which the payment has been applied.
SECONDARY_APPLICATION_REF_TYPE VARCHAR2 (30)
Identifies the application reference type and determines the context for the SECONDARY_APPLICATION_REF_ID and SECONDARY_APPLICATION_REF_NUM columns
SECONDARY_APPLICATION_REF_NUM VARCHAR2 (150)
User-visible application reference number whose context is determined by the SECONDARY_APPLICATION_REF_TYPE column's value
EVENT_ID NUMBER (15)
SLA event_id
UPGRADE_METHOD VARCHAR2 (30)
Upgrade flag to indicate the origin of the application
AX_ACCOUNTED_FLAG VARCHAR2 (1)
INCLUDE_IN_ACCUMULATION VARCHAR2 (1)
Flag to include in acucmulation or not
ON_ACCT_CUST_ID NUMBER (15)
On account customer id
ON_ACCT_CUST_SITE_USE_ID NUMBER (15)
On account customer site use id
ON_ACCT_PO_NUM VARCHAR2 (50)
On account PO number
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT RECEIVABLE_APPLICATION_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      AMOUNT_APPLIED
,      AMOUNT_APPLIED_FROM
,      TRANS_TO_RECEIPT_RATE
,      GL_DATE
,      CODE_COMBINATION_ID
,      SET_OF_BOOKS_ID
,      DISPLAY
,      APPLY_DATE
,      APPLICATION_TYPE
,      STATUS
,      PAYMENT_SCHEDULE_ID
,      LAST_UPDATE_LOGIN
,      CASH_RECEIPT_ID
,      APPLIED_CUSTOMER_TRX_ID
,      APPLIED_CUSTOMER_TRX_LINE_ID
,      APPLIED_PAYMENT_SCHEDULE_ID
,      CUSTOMER_TRX_ID
,      LINE_APPLIED
,      TAX_APPLIED
,      FREIGHT_APPLIED
,      RECEIVABLES_CHARGES_APPLIED
,      EARNED_DISCOUNT_TAKEN
,      UNEARNED_DISCOUNT_TAKEN
,      DAYS_LATE
,      APPLICATION_RULE
,      GL_POSTED_DATE
,      COMMENTS
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      POSTABLE
,      POSTING_CONTROL_ID
,      ACCTD_AMOUNT_APPLIED_FROM
,      ACCTD_AMOUNT_APPLIED_TO
,      ACCTD_EARNED_DISCOUNT_TAKEN
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CONFIRMED_FLAG
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      USSGL_TRANSACTION_CODE
,      USSGL_TRANSACTION_CODE_CONTEXT
,      EARNED_DISCOUNT_CCID
,      UNEARNED_DISCOUNT_CCID
,      ACCTD_UNEARNED_DISCOUNT_TAKEN
,      REVERSAL_GL_DATE
,      CASH_RECEIPT_HISTORY_ID
,      ORG_ID
,      TAX_CODE
,      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_ATTRIBUTE_CATEGORY
,      CONS_INV_ID
,      CONS_INV_ID_TO
,      RULE_SET_ID
,      LINE_EDISCOUNTED
,      TAX_EDISCOUNTED
,      FREIGHT_EDISCOUNTED
,      CHARGES_EDISCOUNTED
,      LINE_UEDISCOUNTED
,      TAX_UEDISCOUNTED
,      FREIGHT_UEDISCOUNTED
,      CHARGES_UEDISCOUNTED
,      RECEIVABLES_TRX_ID
,      ON_ACCOUNT_CUSTOMER
,      MRC_AMOUNT_APPLIED
,      MRC_AMOUNT_APPLIED_FROM
,      MRC_DISPLAY
,      MRC_STATUS
,      MRC_PAYMENT_SCHEDULE_ID
,      MRC_CASH_RECEIPT_ID
,      MRC_GL_POSTED_DATE
,      MRC_POSTING_CONTROL_ID
,      MRC_ACCTD_AMOUNT_APPLIED_FROM
,      MRC_ACCTD_AMOUNT_APPLIED_TO
,      MRC_ACCTD_EARNED_DISC_TAKEN
,      MRC_ACCTD_UNEARNED_DISC_TAKEN
,      EDISC_TAX_ACCT_RULE
,      UNEDISC_TAX_ACCT_RULE
,      LINK_TO_TRX_HIST_ID
,      LINK_TO_CUSTOMER_TRX_ID
,      APPLICATION_REF_TYPE
,      APPLICATION_REF_ID
,      APPLICATION_REF_NUM
,      CHARGEBACK_CUSTOMER_TRX_ID
,      SECONDARY_APPLICATION_REF_ID
,      PAYMENT_SET_ID
,      APPLICATION_REF_REASON
,      CUSTOMER_REFERENCE
,      CUSTOMER_REASON
,      APPLIED_REC_APP_ID
,      SECONDARY_APPLICATION_REF_TYPE
,      SECONDARY_APPLICATION_REF_NUM
,      EVENT_ID
,      UPGRADE_METHOD
,      AX_ACCOUNTED_FLAG
,      INCLUDE_IN_ACCUMULATION
,      ON_ACCT_CUST_ID
,      ON_ACCT_CUST_SITE_USE_ID
,      ON_ACCT_PO_NUM
FROM AR.AR_RECEIVABLE_APPLICATIONS_ALL;

Dependencies

[top of page]

AR.AR_RECEIVABLE_APPLICATIONS_ALL does not reference any database object

AR.AR_RECEIVABLE_APPLICATIONS_ALL is referenced by following:

SchemaAR
ViewAR_RECEIVABLE_APPLICATIONS_AL#