1. Tables and Views for Financials
  2. AR_BILL_TO_CUST_GT

AR_BILL_TO_CUST_GT

This is a temporary table which is used internally by Oracle.

Details

  • Schema: FUSION

  • Object owner: AR

  • Object type: TABLE

  • Tablespace: Default

Columns

Name Datatype Length Precision Comments
BILL_CUST_ACCOUNT_NUMBER VARCHAR2 30 Bill-to customer account number.
BILL_CUST_TYPE_CODE VARCHAR2 30 Receivables lookup code for the CUSTOMER_TYPE attribute. Valid values are: I for internal customers; R for revenue-generating external customers.
BILL_CUST_ACCOUNT_ID NUMBER 18 Unique identifier of the bill-to customer account.
BILL_CUST_GLOBAL_ATTR1 VARCHAR2 240 Segment of the Bill-to Customer global descriptive flexfield 1.
BILL_CUST_GLOBAL_ATTR10 VARCHAR2 240 Segment of the Bill-to Customer global descriptive flexfield 10.
BILL_CUST_GLOBAL_ATTR12 VARCHAR2 240 Segment of the Bill-to Customer global descriptive flexfield 12.
BILL_CUST_GLOBAL_ATTR9 VARCHAR2 240 Segment of the Bill-to Customer global descriptive flexfield 9.
BILL_CUST_GLOBAL_ATTR_CAT VARCHAR2 30 Structure definition of the Bill-to Customer global descriptive flexfield.
BILL_CUST_NPA_NUMBER VARCHAR2 60 Number Plan Area (NPA) number, or Area Code, of the bill-to customer account.
BILL_CUST_CAT_CODE VARCHAR2 30 User-defined category code of the bill-to customer account. Lookup type is CUSTOMER_CATEGORY.
BILL_CUST_CITY VARCHAR2 60 City of the bill-to customer identifying address.
BILL_CUST_COUNTRY VARCHAR2 2 Country of the bill-to customer identifying address. Countries codes are listed in the TERRITORY_CODE column of the FND_TERRITORY table.
BILL_CUST_COUNTY VARCHAR2 60 County of the bill-to customer identifying address.
BILL_CUST_GROUP_TYPE_CODE VARCHAR2 30 Group type lookup code for the bill-to customer.
BILL_CUST_GSA_FLAG VARCHAR2 1 Code that indicates whether the bill-to customer is a US federal agency supported by the General Services Administration (GSA). Valid values are: Y for organizations served by the GSA; N for organizations that are not served by the GSA.
BILL_CUST_FISCAL_CODE VARCHAR2 20 Taxpayer identification number of the bill-to customer.
BILL_CUST_PARTY_ID NUMBER 18 Unique identifier of the bill-to customer party.
BILL_CUST_PARTY_NAME VARCHAR2 360 Name of the bill-to customer party.
BILL_CUST_PARTY_NUMBER VARCHAR2 30 Number of the bill-to customer party.
BILL_CUST_PARTY_TYPE VARCHAR2 30 Party type of the bill-to customer party. Valid values are: Person, Organization, Group.
BILL_CUST_POSTAL_CODE VARCHAR2 60 Postal code of the Identifying address of the bill-to customer.
BILL_CUST_PROVINCE VARCHAR2 60 Province of the Identifying address of the bill-to customer.
BILL_CUST_STATE VARCHAR2 60 State of the Identifying address of the bill-to customer.
BILL_CUST_TAX_REFERENCE VARCHAR2 50 Tax reference for the bill-to customer.
BILL_CUSTOMER_CLASS_CODE VARCHAR2 30 Customer class identifier of the bill-to customer. For example, an account created for a reseller or educational customer has a customer_class_code of reseller or education.
BILL_CUST_ATTR1 VARCHAR2 150 Segment of the Bill-to Customer user descriptive flexfield 1.
BILL_CUST_ATTR2 VARCHAR2 150 Segment of the Bill-to Customer user descriptive flexfield 2.
BILL_CUST_ATTR3 VARCHAR2 150 Segment of the Bill-to Customer user descriptive flexfield 3.
BILL_CUST_ATTR4 VARCHAR2 150 Segment of the Bill-to Customer user descriptive flexfield 4.
BILL_CUST_ATTR5 VARCHAR2 150 Segment of the Bill-to Customer user descriptive flexfield 5.
BILL_CUST_ATTR6 VARCHAR2 150 Segment of the Bill-to Customer user descriptive flexfield 6.
BILL_CUST_ATTR7 VARCHAR2 150 Segment of the Bill-to Customer user descriptive flexfield 7.
BILL_CUST_ATTR8 VARCHAR2 150 Segment of the Bill-to Customer user descriptive flexfield 8.
BILL_CUST_ATTR9 VARCHAR2 150 Segment of the Bill-to Customer user descriptive flexfield 9.
BILL_CUST_ATTR10 VARCHAR2 150 Segment of the Bill-to Customer user descriptive flexfield 10.
BILL_CUST_ATTR11 VARCHAR2 150 Segment of the Bill-to Customer user descriptive flexfield 11.
BILL_CUST_ATTR12 VARCHAR2 150 Segment of the Bill-to Customer user descriptive flexfield 12.
BILL_CUST_ATTR13 VARCHAR2 150 Segment of the Bill-to Customer user descriptive flexfield 13.
BILL_CUST_ATTR14 VARCHAR2 150 Segment of the Bill-to Customer user descriptive flexfield 14.
BILL_CUST_ATTR15 VARCHAR2 150 Segment of the Bill-to Customer user descriptive flexfield 15.
BILL_CUST_ATTR_CAT VARCHAR2 30 Structure definition of the Bill-to Customer user descriptive flexfield.
BILL_SITE_USE_ID NUMBER 18 Unique identifier of the site use of the bill-to customer site.

Indexes

Index Uniqueness Columns
AR_BILL_TO_CUST_GT_U1 Unique BILL_CUST_ACCOUNT_ID, BILL_SITE_USE_ID