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

TABLE: FV.FV_DELINQ_INVOICES_ALL

Object Details
Object Name: FV_DELINQ_INVOICES_ALL
Object Type: TABLE
Owner: FV
FND Design Data: TableFV.FV_DELINQ_INVOICES_ALL
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
CUSTOMER_ID NUMBER (15) Yes Customer identifier
CUSTOMER_NAME VARCHAR2 (360) Yes Customer name
CUSTOMER_NUMBER VARCHAR2 (30) Yes Customer number
PARTY_ID NUMBER (15) Yes Party identifier
PARTY_TYPE VARCHAR2 (30) Yes Can only be person or organization
CUSTOMER_TRX_ID NUMBER (15) Yes Invoice identifier
TRX_NUMBER VARCHAR2 (20) Yes Transaction number
DEBT_TYPE VARCHAR2 (1)
Debt type
CUST_TRX_TYPE_ID NUMBER (15)
Transaction type identifier
BILL_TO_SITE_USE_ID NUMBER (15)
Site use identifier billed
CUSTOMER_BANK_ACCOUNT_ID NUMBER (15)
Identifies the customer bank account
TRX_DATE DATE

Invoice date
TERM_DUE_DATE DATE

Due date of the first payment
DAYS_PAST_DUE NUMBER

Days past due
ORIGINAL NUMBER

Original debt amount
PRINCIPAL NUMBER

Principle amount
ADD_INT NUMBER

Additional interest amount
ADMIN_COST NUMBER

Administrative cost amount
PEN_CHARGES NUMBER

Penalty charges amount
TOT_REFERRED NUMBER

Total referral amount
PROGRAM_CODE VARCHAR2 (6)
DMS assigned program code
INT_CAL_DATE DATE

Interest calculation date
TAX_REFERENCE VARCHAR2 (50)
Taxpayer identification number
PERSON_FIRST_NAME VARCHAR2 (150)
person's first name
PERSON_MIDDLE_NAME VARCHAR2 (60)
person's middle name
PERSON_LAST_NAME VARCHAR2 (150)
person's last name
ADDRESS1 VARCHAR2 (240)
Address 1
ADDRESS2 VARCHAR2 (240)
Address 2
PERSON_CITY VARCHAR2 (60)
person's city
PERSON_STATE VARCHAR2 (60)
Person's state
POSTAL_CODE VARCHAR2 (60)
zip code
AREA_CODE VARCHAR2 (10)
telephone area code
PHONE_NUMBER VARCHAR2 (50)
telephone number
EXTENSION VARCHAR2 (20)
telephone extension
BANK_NAME VARCHAR2 (60)
Bank name
ADDRESS_LINE1 VARCHAR2 (35)
First address line
ADDRESS_LINE2 VARCHAR2 (35)
Second address line
CITY VARCHAR2 (25)
City
STATE VARCHAR2 (25)
State or province
ZIP VARCHAR2 (20)
Zip code
BANK_ACCOUNT_NUM VARCHAR2 (30)
Bank account number
PARTY_NAME VARCHAR2 (50)
Party name
DUNS_NUMBER NUMBER

DUNS Number; a unique, nine digit identification number assigned to business entities by Dun & Bradstreet
RECEIPT_DATE DATE

Receipt date
AMOUNT NUMBER (38)
Receipt amount
ERR_MSG VARCHAR2 (2000)
Exception messages for the invoice
ORG_ID NUMBER (15) Yes Organization identifier
Query Text

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


SELECT CUSTOMER_ID
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      PARTY_ID
,      PARTY_TYPE
,      CUSTOMER_TRX_ID
,      TRX_NUMBER
,      DEBT_TYPE
,      CUST_TRX_TYPE_ID
,      BILL_TO_SITE_USE_ID
,      CUSTOMER_BANK_ACCOUNT_ID
,      TRX_DATE
,      TERM_DUE_DATE
,      DAYS_PAST_DUE
,      ORIGINAL
,      PRINCIPAL
,      ADD_INT
,      ADMIN_COST
,      PEN_CHARGES
,      TOT_REFERRED
,      PROGRAM_CODE
,      INT_CAL_DATE
,      TAX_REFERENCE
,      PERSON_FIRST_NAME
,      PERSON_MIDDLE_NAME
,      PERSON_LAST_NAME
,      ADDRESS1
,      ADDRESS2
,      PERSON_CITY
,      PERSON_STATE
,      POSTAL_CODE
,      AREA_CODE
,      PHONE_NUMBER
,      EXTENSION
,      BANK_NAME
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      CITY
,      STATE
,      ZIP
,      BANK_ACCOUNT_NUM
,      PARTY_NAME
,      DUNS_NUMBER
,      RECEIPT_DATE
,      AMOUNT
,      ERR_MSG
,      ORG_ID
FROM FV.FV_DELINQ_INVOICES_ALL;

Dependencies

[top of page]

FV.FV_DELINQ_INVOICES_ALL does not reference any database object

FV.FV_DELINQ_INVOICES_ALL is referenced by following:

SchemaAPPS
SynonymFV_DELINQ_INVOICES
SynonymFV_DELINQ_INVOICES_ALL