AR_CUST_CREDIT_AUTHORIZATION

Details

Schema: FUSION
Object owner: AR
Object type: TABLE
Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
AR_CUST_CREDIT_AUTH_PK	CREDIT_AUTHORIZATION_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CUST_ACCOUNT_ID	NUMBER		18	Yes	Identifier for the customer account. Foreign key to the HZ_CUST_ACCOUNTS table.
AUTHORIZATION_NUMBER	VARCHAR2	30		Yes	Unique identifying number for the credit authorization. It is generated when the credit authorization amount is approved.
REQUEST_AUTH_AMOUNT	NUMBER			Yes	The amount requested for credit checking, and is approved. It should be the same amount as that from the requested sales order line with the corresponding authorization number.
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.
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.
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.
REQUEST_CURRENCY_CODE	VARCHAR2	15		Yes	Currency code associated with an authorization amount.
CREDIT_AUTH_AMOUNT	NUMBER				Authorized amount converted to the credit limit currency using the conversion rate defined on the customer account profile.
REM_AUTH_AMOUNT	NUMBER				Remaining authorized amount converted to the credit limit currency using the conversion rate defined on the customer account profile.
EXCHANGE_RATE_TYPE	VARCHAR2	30			Currency conversion rate type associated with the authorization currency.
EXCHANGE_RATE	NUMBER		9		Currency conversion rate associated with the authorization currency
AUTHORIZATION_DATE	DATE			Yes	Date and time the credit amount was authorized.
AUTHORIZATION_STATUS	VARCHAR2	20		Yes	Indicates the status of the authorization, based on the system lookup values.
EXPIRATION_DATE	DATE			Yes	Expiration date and time of the authorized amount.
EXCLUDE_FROM_EXPIRATION_FLAG	VARCHAR2	20		Yes	Indicates whether the authorization is finalized.
RECURRENCE_PERIOD	VARCHAR2	20			Used for price types other than one-time to indicate the recurring time period.
PRICE_TYPE	VARCHAR2	20			Indicates the basis on which a price applies. Valid values are: One-Time, Recurring, Usage, Recurring Usage and Rate Plan.
CREDIT_AUTHORIZATION_ID	NUMBER		18	Yes	Credit authorization unique identifier.
CREDIT_CURRENCY_CODE	VARCHAR2	15			Credit currency defined in the customer or customer account profile.
AUTH_UPDATE_REQUEST_ID	NUMBER		18		Indicates the request identifier of the most recent process which updates the authorization detail table.
SALES_ORDER	VARCHAR2	50			Indicates the Sales Order Number for which the authorization is requested.

Foreign Keys

Table	Foreign Table	Foreign Key Column
AR_CUST_CREDIT_AUTHORIZATION	hz_cust_accounts	CUST_ACCOUNT_ID

Indexes

Index	Uniqueness	Tablespace	Columns
AR_CUST_CREDIT_AUTH_N1	Non Unique	FUSION_TS_TX_DATA	CUST_ACCOUNT_ID, AUTHORIZATION_STATUS
AR_CUST_CREDIT_AUTH_PK	Unique	FUSION_TS_TX_DATA	CREDIT_AUTHORIZATION_ID
AR_CUST_CREDIT_AUTH_U1	Unique	FUSION_TS_TX_DATA	AUTHORIZATION_NUMBER