[Home] [Help] [Dependency Information]
Object Name: | FV_DELINQ_INVOICES_ALL |
---|---|
Object Type: | TABLE |
Owner: | FV |
FND Design Data: | FV.FV_DELINQ_INVOICES_ALL |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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;
FV.FV_DELINQ_INVOICES_ALL does not reference any database object
FV.FV_DELINQ_INVOICES_ALL is referenced by following:
|
|
|