eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: AR.HZ_BILLING_PREFERENCES

Object Details

Object Name:	HZ_BILLING_PREFERENCES
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.HZ_BILLING_PREFERENCES
Subobject Name:
Status:	VALID

The HZ_BILLING_PREFERENCES table stores information about the invoice format and media that is requested by a customer account or customer account site. For example, a customer account site may request that although a Latin American subsidiary is based in Florida, United States all invoices should be in Spanish and sent to the subsidiary on a CD-ROM.
.
The primary key for this table is BILLING_PREFERENCES_ID.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HZ_BILLING_PREFERENCES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BILLING_PREFERENCES_ID
HZ_BILLING_PREFERENCES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUST_ACCOUNT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BILLING_PREFERENCES_ID	NUMBER	(15)	Yes	Unique identifier for this billing information
BILL_LANGUAGE	VARCHAR2	(4)		The language, such as English or Spanish, that the bill is printed in. Foreign key to the FND_LANGUAGES table.
BILL_ROUND_NUMBER	VARCHAR2	(30)		Describes the rounding method that rounds the amounts on the bill to a specified limit.
BILL_TYPE	VARCHAR2	(30)		Detail or summary
MEDIA_FORMAT	VARCHAR2	(30)		An identifier for the type of media such as tape, CD, or diskette on which the bill is to be copied for distribution to the customer.
SITE_USE_ID	NUMBER	(15)		Foreign key to the HZ_CUST_SITE_USES_ALL table
MEDIA_TYPE	VARCHAR2	(30)		The type of media on which the bill is to be presented. For example, printed, electronic transmission or electromagnetic (tape, diskette, and so on).
CUST_ACCOUNT_ID	NUMBER	(15)	Yes	Customer account identifier. Foreign key to the HZ_CUST_ACCOUNTS table
NUMBER_OF_COPIES	NUMBER			Number of copies (printed or copies of the media) that are to be made at the time of printing.
CURRENCY_CODE	VARCHAR2	(15)		ISO code for the currency that should appear on a billing document. Foreign key to the FND_CURRENCIES table
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_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
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).
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).
WH_UPDATE_DATE	DATE			Date when the record was entered or changed in a data warehouse

Query Text

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


SELECT BILLING_PREFERENCES_ID
,      BILL_LANGUAGE
,      BILL_ROUND_NUMBER
,      BILL_TYPE
,      MEDIA_FORMAT
,      SITE_USE_ID
,      MEDIA_TYPE
,      CUST_ACCOUNT_ID
,      NUMBER_OF_COPIES
,      CURRENCY_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      WH_UPDATE_DATE
FROM AR.HZ_BILLING_PREFERENCES;

Dependencies

[top of page]

AR.HZ_BILLING_PREFERENCES does not reference any database object

AR.HZ_BILLING_PREFERENCES is referenced by following:

APPS: HZ_BILLING_PREFERENCES