1. Tables and Views for Financials
  2. AR_BILL_TO_SITE_GT

AR_BILL_TO_SITE_GT

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

Details

  • Schema: FUSION

  • Object owner: AR

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Columns

Name Datatype Length Precision Comments
BILL_SITE_CUST_CAT_CODE VARCHAR2 30 User-definable category. The lookup type is ADDRESS_CATEGORY.
BILL_SITE_CUST_ACCT_SITE_ID NUMBER 18 Unique identifier of the bill-to customer account site.
BILL_SITE_GLOBAL_ATTR1 VARCHAR2 240 Segment of the Bill-to Customer Account site global descriptive flexfield 1.
BILL_SITE_GLOBAL_ATTR2 VARCHAR2 240 Segment of the Bill-to Customer Account site global descriptive flexfield 2.
BILL_SITE_GLOBAL_ATTR3 VARCHAR2 240 Segment of the Bill-to Customer Account site global descriptive flexfield 3.
BILL_SITE_GLOBAL_ATTR4 VARCHAR2 240 Segment of the Bill-to Customer Account site global descriptive flexfield 4.
BILL_SITE_GLOBAL_ATTR5 VARCHAR2 240 Segment of the Bill-to Customer Account site global descriptive flexfield 5.
BILL_SITE_GLOBAL_ATTR6 VARCHAR2 240 Segment of the Bill-to Customer Account site global descriptive flexfield 6.
BILL_SITE_GLOBAL_ATTR7 VARCHAR2 240 Segment of the Bill-to Customer Account site global descriptive flexfield 7.
BILL_SITE_GLOBAL_ATTR8 VARCHAR2 240 Segment of the Bill-to Customer Account site global descriptive flexfield 8.
BILL_SITE_GLOBAL_ATTR9 VARCHAR2 240 Segment of the Bill-to Customer Account site global descriptive flexfield 9.
BILL_SITE_GLOBAL_ATTR_CAT VARCHAR2 30 Structure definition of the Bill-to Customer Account site global descriptive flexfield.
BILL_SITE_TRNSL_CUST_NAME VARCHAR2 360 Customer name in the language used at the bill-to customer account site.
BILL_USES_GLOBAL_ATTR1 VARCHAR2 240 Segment of the Bill-to Customer Site Use global descriptive flexfield 1.
BILL_USES_GLOBAL_ATTR_CAT VARCHAR2 30 Structure definition of the Bill-to Customer Site Use global descriptive flexfield.
BILL_USES_CLEARING_CCID NUMBER 18 Account code combination of the bill-to customer site use clearing account.
BILL_USES_FREIGHT_CCID NUMBER 18 Account code combination of the bill-to customer site use freight account.
BILL_USES_REC_CCID NUMBER 18 Account code combination of the bill-to customer site use receivable account.
BILL_USES_REV_CCID NUMBER 18 Account code combination of the bill-to customer site use revenue account.
BILL_USES_TAX_CCID NUMBER 18 Account code combination of the bill-to customer site use tax account.
BILL_USES_UNBILLED_CCID NUMBER 18 Account code combination of the bill-to customer site use unbilled receivables account.
BILL_USES_UNEARNED_CCID NUMBER 18 Account code combination of the bill-to customer site use unearned revenue account.
BILL_USES_GSA_INDICATOR 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_USES_LOCATION VARCHAR2 150 Location of the bill-to customer site use.
BILL_USES_SITE_USE_CODE VARCHAR2 30 Code that identifies the business purpose of the bill-to customer site use.
BILL_USES_SITE_USE_ID NUMBER 18 Unique identifier of the business purpose of the bill-to customer site use.
BILL_TO_SITE VARCHAR2 150 Name of the bill-to customer site.
BILL_USES_TAX_REFERENCE VARCHAR2 50 Taxpayer identification number of the bill-to customer site use.
BILL_SITE_PARTY_SITE_ID NUMBER 18 Unique identifier of the party site for the bill-to customer site. Foreign key to the HZ_PARTY_SITES table.
BILL_SITE_USES_ATTR1 VARCHAR2 150 Segment of the Bill-to site uses user descriptive flexfield 1.
BILL_SITE_USES_ATTR2 VARCHAR2 150 Segment of the Bill-to site uses user descriptive flexfield 2.
BILL_SITE_USES_ATTR3 VARCHAR2 150 Segment of the Bill-to site uses user descriptive flexfield 3.
BILL_SITE_USES_ATTR4 VARCHAR2 150 Segment of the Bill-to site uses user descriptive flexfield 4.
BILL_SITE_USES_ATTR5 VARCHAR2 150 Segment of the Bill-to site uses user descriptive flexfield 5.
BILL_SITE_USES_ATTR6 VARCHAR2 150 Segment of the Bill-to site uses user descriptive flexfield 6.
BILL_SITE_USES_ATTR7 VARCHAR2 150 Segment of the Bill-to site uses user descriptive flexfield 7.
BILL_SITE_USES_ATTR8 VARCHAR2 150 Segment of the Bill-to site uses user descriptive flexfield 8.
BILL_SITE_USES_ATTR9 VARCHAR2 150 Segment of the Bill-to site uses user descriptive flexfield 9.
BILL_SITE_USES_ATTR10 VARCHAR2 150 Segment of the Bill-to site uses user descriptive flexfield 10.
BILL_SITE_USES_ATTR11 VARCHAR2 150 Segment of the Bill-to site uses user descriptive flexfield 11.
BILL_SITE_USES_ATTR12 VARCHAR2 150 Segment of the Bill-to site uses user descriptive flexfield 12.
BILL_SITE_USES_ATTR13 VARCHAR2 150 Segment of the Bill-to site uses user descriptive flexfield 13.
BILL_SITE_USES_ATTR14 VARCHAR2 150 Segment of the Bill-to site uses user descriptive flexfield 14.
BILL_SITE_USES_ATTR15 VARCHAR2 150 Segment of the Bill-to site uses user descriptive flexfield 15.
BILL_SITE_USES_ATTR_CAT VARCHAR2 30 Structure definition of the Bill-to site uses user descriptive flexfield.
BILL_SITE_ATTR1 VARCHAR2 150 Segment of the Bill-to site user descriptive flexfield 1.
BILL_SITE_ATTR2 VARCHAR2 150 Segment of the Bill-to site user descriptive flexfield 2.
BILL_SITE_ATTR3 VARCHAR2 150 Segment of the Bill-to site user descriptive flexfield 3.
BILL_SITE_ATTR4 VARCHAR2 150 Segment of the Bill-to site user descriptive flexfield 4.
BILL_SITE_ATTR5 VARCHAR2 150 Segment of the Bill-to site user descriptive flexfield 5.
BILL_SITE_ATTR6 VARCHAR2 150 Segment of the Bill-to site user descriptive flexfield 6.
BILL_SITE_ATTR7 VARCHAR2 150 Segment of the Bill-to site user descriptive flexfield 7.
BILL_SITE_ATTR8 VARCHAR2 150 Segment of the Bill-to site user descriptive flexfield 8.
BILL_SITE_ATTR9 VARCHAR2 150 Segment of the Bill-to site user descriptive flexfield 9.
BILL_SITE_ATTR10 VARCHAR2 150 Segment of the Bill-to site user descriptive flexfield 10.
BILL_SITE_ATTR11 VARCHAR2 150 Segment of the Bill-to site user descriptive flexfield 11.
BILL_SITE_ATTR12 VARCHAR2 150 Segment of the Bill-to site user descriptive flexfield 12.
BILL_SITE_ATTR13 VARCHAR2 150 Segment of the Bill-to site user descriptive flexfield 13.
BILL_SITE_ATTR14 VARCHAR2 150 Segment of the Bill-to site user descriptive flexfield 14.
BILL_SITE_ATTR15 VARCHAR2 150 Segment of the Bill-to site user descriptive flexfield 15.
BILL_SITE_ATTR_CAT VARCHAR2 30 Structure definition of the Bill-to site user descriptive flexfield.
ORG_ID NUMBER 18 Indicates the identifier of the business unit associated to the row.

Indexes

Index Uniqueness Columns
AR_BILL_TO_SITE_GT_U1 Unique BILL_USES_SITE_USE_ID, ORG_ID