FND Design Data [Home] [Help]

View: AST_CUST_SITE_USES_V

Product: AST - TeleSales
Description:
Implementation/DBA Data: ViewAPPS.AST_CUST_SITE_USES_V
View Text

SELECT ROWID
, SITE_USE_ID
, CUST_ACCT_SITE_ID
, BILL_TO_SITE_USE_ID
, CONTACT_ID
, PAYMENT_TERM_ID
, SITE_USE_CODE
, PRIMARY_FLAG
, STATUS
, LOCATION
, ORIG_SYSTEM_REFERENCE
, SIC_CODE
, GSA_INDICATOR
, SHIP_PARTIAL
, SHIP_VIA
, FOB_POINT
, ORDER_TYPE_ID
, PRICE_LIST_ID
, FREIGHT_TERM
, WAREHOUSE_ID
, TERRITORY_ID
, TAX_REFERENCE
, SORT_PRIORITY
, TAX_CODE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ATTRIBUTE21
, ATTRIBUTE22
, ATTRIBUTE23
, ATTRIBUTE24
, ATTRIBUTE25
, LAST_ACCRUE_CHARGE_DATE
, SECOND_LAST_ACCRUE_CHARGE_DATE
, LAST_UNACCRUE_CHARGE_DATE
, SECOND_LAST_UNACCRUE_CHRG_DATE
, DEMAND_CLASS_CODE
, ORG_ID
, TAX_HEADER_LEVEL_FLAG
, TAX_ROUNDING_RULE
, PRIMARY_SALESREP_ID
, FINCHRG_RECEIVABLES_TRX_ID
, DATES_NEGATIVE_TOLERANCE
, DATES_POSITIVE_TOLERANCE
, DATE_TYPE_PREFERENCE
, OVER_SHIPMENT_TOLERANCE
, UNDER_SHIPMENT_TOLERANCE
, ITEM_CROSS_REF_PREF
, OVER_RETURN_TOLERANCE
, UNDER_RETURN_TOLERANCE
, SHIP_SETS_INCLUDE_LINES_FLAG
, ARRIVALSETS_INCLUDE_LINES_FLAG
, SCHED_DATE_PUSH_FLAG
, INVOICE_QUANTITY_RULE
, PRICING_EVENT
, GL_ID_REC
, GL_ID_REV
, GL_ID_TAX
, GL_ID_FREIGHT
, GL_ID_CLEARING
, GL_ID_UNBILLED
, GL_ID_UNEARNED
, GL_ID_UNPAID_REC
, GL_ID_REMITTANCE
, GL_ID_FACTOR
FROM HZ_CUST_SITE_USES_ALL

Columns

Name
ROW_ID
SITE_USE_ID
CUST_ACCT_SITE_ID
BILL_TO_SITE_USE_ID
CONTACT_ID
PAYMENT_TERM_ID
SITE_USE_CODE
PRIMARY_FLAG
STATUS
LOCATION
ORIG_SYSTEM_REFERENCE
SIC_CODE
GSA_INDICATOR
SHIP_PARTIAL
SHIP_VIA
FOB_POINT
ORDER_TYPE_ID
PRICE_LIST_ID
FREIGHT_TERM
WAREHOUSE_ID
TERRITORY_ID
TAX_REFERENCE
SORT_PRIORITY
TAX_CODE
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20
ATTRIBUTE21
ATTRIBUTE22
ATTRIBUTE23
ATTRIBUTE24
ATTRIBUTE25
LAST_ACCRUE_CHARGE_DATE
SECOND_LAST_ACCRUE_CHARGE_DATE
LAST_UNACCRUE_CHARGE_DATE
SECOND_LAST_UNACCRUE_CHRG_DATE
DEMAND_CLASS_CODE
ORG_ID
TAX_HEADER_LEVEL_FLAG
TAX_ROUNDING_RULE
PRIMARY_SALESREP_ID
FINCHRG_RECEIVABLES_TRX_ID
DATES_NEGATIVE_TOLERANCE
DATES_POSITIVE_TOLERANCE
DATE_TYPE_PREFERENCE
OVER_SHIPMENT_TOLERANCE
UNDER_SHIPMENT_TOLERANCE
ITEM_CROSS_REF_PREF
OVER_RETURN_TOLERANCE
UNDER_RETURN_TOLERANCE
SHIP_SETS_INCLUDE_LINES_FLAG
ARRIVALSETS_INCLUDE_LINES_FLAG
SCHED_DATE_PUSH_FLAG
INVOICE_QUANTITY_RULE
PRICING_EVENT
GL_ID_REC
GL_ID_REV
GL_ID_TAX
GL_ID_FREIGHT
GL_ID_CLEARING
GL_ID_UNBILLED
GL_ID_UNEARNED
GL_ID_UNPAID_REC
GL_ID_REMITTANCE
GL_ID_FACTOR