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


TABLE: AR.AR_RAMC_AUDIT_TRAIL

Object Details
Object Name: AR_RAMC_AUDIT_TRAIL
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.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.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AR_RAMC_AUDIT_TRAIL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUSTOMER_TRX_LINE_ID
AR_RAMC_AUDIT_TRAIL_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUSTOMER_TRX_ID
Columns
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).
Query Text

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;

Dependencies

[top of page]

AR.AR_RAMC_AUDIT_TRAIL does not reference any database object

AR.AR_RAMC_AUDIT_TRAIL is referenced by following:

SchemaAR
ViewAR_RAMC_AUDIT_TRAIL#