[Home] [Help] [Dependency Information]
Object Name: | AR_DRAWEE_CUSTOMERS_H_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AR.AR_DRAWEE_CUSTOMERS_H_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DRAW_CUST_ACCOUNT_NUMBER | VARCHAR2 | (30) | Yes | Account Number |
DRAW_CUST_TYPE | VARCHAR2 | (30) | Receivables lookup code for the CUSTOMER_TYPE attribute. I for internal customers, R for revenue generating external customers. | |
DRAW_CUST_ACCOUNT_ID | NUMBER | (15) | Yes | Customer account identifier |
DRAW_CUST_GLOBAL_ATTR1 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
DRAW_CUST_GLOBAL_ATTR10 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
DRAW_CUST_GLOBAL_ATTR12 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
DRAW_CUST_GLOBAL_ATTR9 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
DRAW_CUST_GLOBAL_ATTR_CAT | VARCHAR2 | (30) | Reserved for country-specific functionality | |
DRAW_CUST_NPA_NUMBER | VARCHAR2 | (60) | Identifies an account with a Number Plan Area (NPA) used in telecommunications. | |
DRAW_CUST_CAT_CODE | VARCHAR2 | (30) | User-definable category. Lookup type is CUSTOMER_CATEGORY | |
DRAW_CUST_CITY | VARCHAR2 | (60) | City of the Identifying address | |
DRAW_CUST_COUNTRY | VARCHAR2 | (60) | The country listed in the TERRITORY_CODE column of the FND_TERRITORY table. for the Identifying address. | |
DRAW_CUST_COUNTY | VARCHAR2 | (60) | County of the Identifying address | |
DRAW_CUST_GROUP_TYPE | VARCHAR2 | (30) | Lookup for group type | |
DRAW_CUST_GSA_FLAG | VARCHAR2 | (1) | Indicates if this is a US federal agency supported by the General Services Administration (GSA). Y for organizations served by the GSA, N for organizations that are not served by the GSA. | |
DRAW_CUST_FISCAL_CODE | VARCHAR2 | (20) | Taxpayer identification number, often unique identifier of person or organization. Can be SSN or income taxpayer ID in US, fiscal code or NIF in Europe | |
DRAW_CUST_ALTERNATE_NAME | VARCHAR2 | (240) | An alias or other name by which a party is known | |
DRAW_CUST_PARTY_ID | NUMBER | (15) | Yes | Party identifier |
DRAW_CUST_PARTY_NAME | VARCHAR2 | (360) | Yes | Name of this party |
DRAW_CUST_PARTY_NUMBER | VARCHAR2 | (30) | Yes | Unique identification number for this party |
DRAW_CUST_PARTY_TYPE | VARCHAR2 | (30) | Yes | The party type can only be Person, Organization, Group or Relationship. |
DRAW_CUST_POSTAL_CODE | VARCHAR2 | (60) | Postal Code of the Identifying address | |
DRAW_CUST_PROVINCE | VARCHAR2 | (30) | Version of Standard Industry Classification (SIC) code | |
DRAW_CUST_STATE | VARCHAR2 | (60) | State of the Identifying address | |
DRAW_CUST_TAX_REFERENCE | VARCHAR2 | (50) | Taxpayer registration number, also known as the VAT number. | |
EVENT_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT DRAW_CUST_ACCOUNT_NUMBER
, DRAW_CUST_TYPE
, DRAW_CUST_ACCOUNT_ID
, DRAW_CUST_GLOBAL_ATTR1
, DRAW_CUST_GLOBAL_ATTR10
, DRAW_CUST_GLOBAL_ATTR12
, DRAW_CUST_GLOBAL_ATTR9
, DRAW_CUST_GLOBAL_ATTR_CAT
, DRAW_CUST_NPA_NUMBER
, DRAW_CUST_CAT_CODE
, DRAW_CUST_CITY
, DRAW_CUST_COUNTRY
, DRAW_CUST_COUNTY
, DRAW_CUST_GROUP_TYPE
, DRAW_CUST_GSA_FLAG
, DRAW_CUST_FISCAL_CODE
, DRAW_CUST_ALTERNATE_NAME
, DRAW_CUST_PARTY_ID
, DRAW_CUST_PARTY_NAME
, DRAW_CUST_PARTY_NUMBER
, DRAW_CUST_PARTY_TYPE
, DRAW_CUST_POSTAL_CODE
, DRAW_CUST_PROVINCE
, DRAW_CUST_STATE
, DRAW_CUST_TAX_REFERENCE
, EVENT_ID
FROM APPS.AR_DRAWEE_CUSTOMERS_H_V;
|
|
|