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: FV.FV_1099C_ALL

Object Details

Object Name:	FV_1099C_ALL
Object Type:	TABLE
Owner:	FV
FND Design Data:	FV.FV_1099C_ALL
Subobject Name:
Status:	VALID

FV_1099C_ALL is a temporary processing table that is populated by the 1099-C Cancellation of Debt process. There is one record for each cancelled debt by individual customer in this table. Records in this table are modified in the Maintain 1099-C Information window.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
SET_OF_BOOKS_ID	NUMBER		Yes	Set of Books identifier
CREDITORS_TIN	VARCHAR2	(10)	Yes	Tax identifier number of agency
CUSTOMER_ID	NUMBER	(15)	Yes	Customer identifier
DATE_CANCELED	DATE		Yes	Date adjustment applied to payment
CUSTOMER_NAME	VARCHAR2	(360)	Yes	Customer name
AMOUNT	NUMBER		Yes	Adjustment amount
TRX_NUMBER	VARCHAR2	(20)	Yes	Invoice number related to invoice identifier in RA_CUSTOMER_TRX table
REPORTABLE_FLAG	VARCHAR2	(1)	Yes	Indicates 1099C invoice is reportable
COUNTRY	VARCHAR2	(2)	Yes	Country
ADDRESS1	VARCHAR2	(240)	Yes	First line of address
ADDRESS2	VARCHAR2	(240)		Second line of address
ADDRESS3	VARCHAR2	(240)		Third line of address
ADDRESS4	VARCHAR2	(240)		Fourth line of address
VOID_FLAG	VARCHAR2	(1)		Indicates 1099C invoice is voided
CORRECTED_FLAG	VARCHAR2	(1)		Indicates 1099C invoice is corrected
REPRINT_FLAG	VARCHAR2	(1)		Indicates 1099C invoice is to be reprinted
TAX_ID	VARCHAR2	(50)		Tax identifier
FINANCE_CHARGE_AMOUNT	NUMBER			Finance charge adjustment amount
DEBT_DESCRIPTION	VARCHAR2	(240)		Description of debt
CITY	VARCHAR2	(60)		City
STATE	VARCHAR2	(60)		State
POSTAL_CODE	VARCHAR2	(60)		Postal code
PROVINCE	VARCHAR2	(60)		Province
BANKRUPTCY_CODE	VARCHAR2	(1)		Indicates if debt cancelled due to bankruptcy
PROPERTY_VALUE	NUMBER			Fair market value of property
ACCOUNT_NUMBER	VARCHAR2	(20)		Debtor account number
ORG_ID	NUMBER	(15)	Yes	Organization identifier
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).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
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 SET_OF_BOOKS_ID
,      CREDITORS_TIN
,      CUSTOMER_ID
,      DATE_CANCELED
,      CUSTOMER_NAME
,      AMOUNT
,      TRX_NUMBER
,      REPORTABLE_FLAG
,      COUNTRY
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      VOID_FLAG
,      CORRECTED_FLAG
,      REPRINT_FLAG
,      TAX_ID
,      FINANCE_CHARGE_AMOUNT
,      DEBT_DESCRIPTION
,      CITY
,      STATE
,      POSTAL_CODE
,      PROVINCE
,      BANKRUPTCY_CODE
,      PROPERTY_VALUE
,      ACCOUNT_NUMBER
,      ORG_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM FV.FV_1099C_ALL;

Dependencies

[top of page]

FV.FV_1099C_ALL does not reference any database object

FV.FV_1099C_ALL is referenced by following:

APPS: FV_1099C; FV_1099C_ALL