AR_RAMC_AUDIT_TRAIL

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.

Details

• Schema: FUSION

• Object owner: AR

• Object type: TABLE

• Tablespace: APPS_TS_TX_DATA

Primary Key

Name	Columns
AR_RAMC_AUDIT_TRAIL_PK	CUSTOMER_TRX_LINE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CUSTOMER_TRX_ID	NUMBER		18	Yes	Transaction identifier.
CUSTOMER_TRX_LINE_ID	NUMBER		18	Yes	Transaction line identifier.
ORIGINAL_COLLECTIBILITY_FLAG	VARCHAR2	1		Yes	Identifies whether line was originally collectible.
LINE_COLLECTIBLE_FLAG	VARCHAR2	1		Yes	Identifies whether line is currently collectible.
TRX_NUMBER	VARCHAR2	20			Transaction Number
BILL_TO_SITE_USE_ID	NUMBER		18		Bill-to site use identifier
CUST_ACCOUNT_ID	NUMBER		18		Customer Account Identifier
SALES_ORDER	VARCHAR2	50			Sales Order
CONTRACT_ID	NUMBER				Sales contract identifier.
CONTRACT_LINE_ID	NUMBER				Sales contract line identifier.
SALES_ORDER_LINE	VARCHAR2	50			Sales Order Line
AMOUNT_DUE_ORIGINAL	NUMBER				Original Amount Due
ACCTD_AMOUNT_DUE_ORIGINAL	NUMBER				Original accounted due amount.
AMOUNT_RECOGNIZED	NUMBER				Amount of recognized revenue.
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 forfeiture clause.
FORFEITURE_EXPIRY	DATE				Forfeiture Clause Expiration Date manual_override_flag Indicates Manual Adjustment
MANUAL_OVERRIDE_FLAG	VARCHAR2	1			Indicates Manual Adjustment
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
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.

Foreign Keys

Table	Foreign Table	Foreign Key Column
AR_RAMC_AUDIT_TRAIL	ra_customer_trx_lines_all	CUSTOMER_TRX_LINE_ID
AR_RAMC_AUDIT_TRAIL	hz_cust_site_uses_all	BILL_TO_SITE_USE_ID
AR_RAMC_AUDIT_TRAIL	hz_cust_accounts	CUST_ACCOUNT_ID
AR_RAMC_AUDIT_TRAIL	ra_customer_trx_all	CUSTOMER_TRX_ID

Indexes

Index	Uniqueness	Tablespace	Columns
AR_RAMC_AUDIT_TRAIL_N1	Non Unique	Default	CUSTOMER_TRX_ID
AR_RAMC_AUDIT_TRAIL_U1	Unique	Default	CUSTOMER_TRX_LINE_ID