[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AR_RAMC_AUDIT_TRAIL |
|---|---|
| Object Type: | TABLE |
| Owner: | AR |
| FND Design Data: |  AR.AR_RAMC_AUDIT_TRAIL
|
| Subobject Name: | |
| Status: | VALID |
The AR_RAMC_AUDIT_TRAIL table records status changes for invoices as it goes through the revenue management life cycle.The primary key for this table is customer_trx_line_id.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| AR_RAMC_AUDIT_TRAIL_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 CUSTOMER_TRX_LINE_ID
|
| AR_RAMC_AUDIT_TRAIL_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CUSTOMER_TRX_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CUSTOMER_TRX_ID | NUMBER | (15) | Yes | Invoice Identifier |
| CUSTOMER_TRX_LINE_ID | NUMBER | (15) | Yes | Invoice Line Identifier |
| ORIGINAL_COLLECTIBILITY_FLAG | VARCHAR2 | (1) | Yes | Original Line Collectibility |
| LINE_COLLECTIBLE_FLAG | VARCHAR2 | (1) | Yes | Line Collectibility |
| TRX_NUMBER | VARCHAR2 | (20) | Transaction Number | |
| BILL_TO_SITE_USE_ID | NUMBER | (15) | Bill-to site use identifier | |
| CUST_ACCOUNT_ID | NUMBER | (15) | Customer Account Identifier | |
| SALES_ORDER | VARCHAR2 | (50) | Sales Order | |
| CONTRACT_ID | NUMBER | Contract Identifier | ||
| CONTRACT_LINE_ID | NUMBER | Contract Line Identifier | ||
| SALES_ORDER_LINE | VARCHAR2 | (50) | Sales Order Line | |
| AMOUNT_DUE_ORIGINAL | NUMBER | Original Amount Due | ||
| ACCTD_AMOUNT_DUE_ORIGINAL | NUMBER | Original Amount Due | ||
| AMOUNT_RECOGNIZED | NUMBER | Amount Recognized | ||
| ACCTD_AMOUNT_RECOGNIZED | NUMBER | Amount Recognized in Functional Currency | ||
| AMOUNT_PENDING | NUMBER | Amount Pending | ||
| ACCTD_AMOUNT_PENDING | NUMBER | Amount Pending in Functional Currency | ||
| REASON_REFUND_FLAG | VARCHAR2 | (1) | Indicates Existence of Refund Clause | |
| REFUND_EXPIRY | DATE | Refund Clause Expiration Date | ||
| REASON_PAYMENT_TERM_FLAG | VARCHAR2 | (1) | Indicates Existence of Non Standard Payment Terms | |
| REASON_CREDIT_FLAG | VARCHAR2 | (1) | Indicates Existence of Credit Problem | |
| REASON_ACCEPTANCE_FLAG | VARCHAR2 | (1) | Indicates Existence of Acceptance Clause | |
| ACCEPTANCE_EXPIRY | DATE | Acceptance Clause Expiration Date | ||
| REASON_CANCELLATION_FLAG | VARCHAR2 | (1) | Indicates Existence of Cancellation Clause | |
| CANCELLATION_EXPIRY | DATE | Cancellation Clause Expiration Date | ||
| REASON_FISCAL_FLAG | VARCHAR2 | (1) | Indicates Existence of Fiscal Funding Clause | |
| FISCAL_EXPIRY | DATE | Fiscal Funding Clause Expiration Date | ||
| REASON_FORFEITURE_FLAG | VARCHAR2 | (1) | Indicates Existence of ForfeitureClause | |
| FORFEITURE_EXPIRY | DATE | Forfeiture Clause Expiration Date manual_override_flag Indicates Manual Adjustment | ||
| MANUAL_OVERRIDE_FLAG | VARCHAR2 | (1) | Indicates Manual Adjustment | |
| 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). | |
| 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. | |
| 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. | |
| 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). |
Cut, paste (and edit) the following text to query this object:
SELECT CUSTOMER_TRX_ID
, CUSTOMER_TRX_LINE_ID
, ORIGINAL_COLLECTIBILITY_FLAG
, LINE_COLLECTIBLE_FLAG
, TRX_NUMBER
, BILL_TO_SITE_USE_ID
, CUST_ACCOUNT_ID
, SALES_ORDER
, CONTRACT_ID
, CONTRACT_LINE_ID
, SALES_ORDER_LINE
, AMOUNT_DUE_ORIGINAL
, ACCTD_AMOUNT_DUE_ORIGINAL
, AMOUNT_RECOGNIZED
, ACCTD_AMOUNT_RECOGNIZED
, AMOUNT_PENDING
, ACCTD_AMOUNT_PENDING
, REASON_REFUND_FLAG
, REFUND_EXPIRY
, REASON_PAYMENT_TERM_FLAG
, REASON_CREDIT_FLAG
, REASON_ACCEPTANCE_FLAG
, ACCEPTANCE_EXPIRY
, REASON_CANCELLATION_FLAG
, CANCELLATION_EXPIRY
, REASON_FISCAL_FLAG
, FISCAL_EXPIRY
, REASON_FORFEITURE_FLAG
, FORFEITURE_EXPIRY
, MANUAL_OVERRIDE_FLAG
, REQUEST_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM AR.AR_RAMC_AUDIT_TRAIL;
AR.AR_RAMC_AUDIT_TRAIL does not reference any database object
AR.AR_RAMC_AUDIT_TRAIL is referenced by following:
AR
AR_RAMC_AUDIT_TRAIL#
|
|
|
|