DBA Data[Home] [Help] [Dependency Information]

TABLE: OZF.OZF_CUST_TRD_PRFLS_ALL

Object Details
Object Name: OZF_CUST_TRD_PRFLS_ALL
Object Type: TABLE
Owner: OZF
FND Design Data: TableOZF.OZF_CUST_TRD_PRFLS_ALL
Subobject Name:
Status: VALID


OZF_CUST_TRD_PRFLS_ALL stores the Customer trade profiles


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OZF_CUST_TRD_PRFLS_ALL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRADE_PROFILE_ID
OZF_CUST_TRD_PRFLS_ALL_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUST_ACCOUNT_ID
OZF_CUST_TRD_PRFLS_ALL_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARTY_ID
Columns
Name Datatype Length Mandatory Comments
TRADE_PROFILE_ID NUMBER
Yes Unique identifier
OBJECT_VERSION_NUMBER NUMBER (9) Yes Sequential number used for database locking control when using HTML as a user interface
LAST_UPDATE_DATE DATE
Yes Standard WHO Column
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO Column
CREATION_DATE DATE
Yes Standard WHO Column
CREATED_BY NUMBER (15) Yes Standard WHO Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Column
REQUEST_ID NUMBER (15)
Standard WHO Column
PROGRAM_APPLICATION_ID NUMBER (15)
Standard WHO Column
PROGRAM_UPDATE_DATE DATE

Standard WHO Column
PROGRAM_ID NUMBER (15)
Standard WHO Column
CREATED_FROM VARCHAR2 (30)
Standard WHO Column
PARTY_ID NUMBER
Yes Party Identifier
SITE_USE_ID NUMBER

Site Use Identifier of Customer
AUTOPAY_FLAG VARCHAR2 (1)
Indicates whether autopay is enabled
CLAIM_THRESHOLD NUMBER

Claim Threshold Amount
CLAIM_CURRENCY VARCHAR2 (30)
Claim currency
PRINT_FLAG VARCHAR2 (1) Yes Indicates whether print allowed
INTERNET_DEAL_VIEW_FLAG VARCHAR2 (1)
Indicates whether checked user can view the deal over the web
INTERNET_CLAIMS_FLAG VARCHAR2 (1)
Indicates whether user can see the Claims over the web
AUTOPAY_PERIODICITY NUMBER

Total Period for Auto Pay
AUTOPAY_PERIODICITY_TYPE VARCHAR2 (30)
Periodicity type for Promotional, Fiscal Period
PAYMENT_METHOD VARCHAR2 (15)
Mode of Payment
DISCOUNT_TYPE VARCHAR2 (30)
Discount Type
CUST_ACCOUNT_ID NUMBER

Customer account identifier
CUST_ACCT_SITE_ID NUMBER

Customer account site identifier
CONTEXT VARCHAR2 (30)
Descriptive Flexfield Structure Defining Column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield Structure Defining Column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
ORG_ID NUMBER
Yes Operating Unit which perfom this transaction
SECURITY_GROUP_ID NUMBER

Used in hosted environments
VENDOR_ID NUMBER

Vendor Identifier
VENDOR_SITE_ID NUMBER

Vendor Site Identifier
VENDOR_SITE_CODE VARCHAR2 (15)
Vendor Site Code
DAYS_DUE NUMBER

Grace days for resolution of claim
LAST_PAID_DATE DATE

Date customer was last paid from autopay
UN_EARNED_PAY_ALLOW_TO VARCHAR2 (30)
Indicates whether payment of unearned earnings is allowed
UN_EARNED_PAY_THOLD_TYPE VARCHAR2 (30)
Threshold type for payment of unearned earnings
UN_EARNED_PAY_THOLD_AMOUNT NUMBER

Threshold amount for payment of unearned earnings
UN_EARNED_PAY_THOLD_FLAG VARCHAR2 (1)
Indicates whether payment threshold of uneared earnings can be overriden
HEADER_TOLERANCE_OPERAND NUMBER

Batch Tolerance Type
HEADER_TOLERANCE_CALC_CODE VARCHAR2 (30)
Batch Tolerance Amount
LINE_TOLERANCE_OPERAND NUMBER

Line Tolerance Type
LINE_TOLERANCE_CALC_CODE VARCHAR2 (30)
Line Tolerance Amount
POS_WRITE_OFF_THRESHOLD NUMBER

Writeoff Threshold (Overpayment) Writeoff Threshold (Overpayment)
NEG_WRITE_OFF_THRESHOLD NUMBER

Writeoff Threshold (Deduction)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TRADE_PROFILE_ID
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      PROGRAM_ID
,      CREATED_FROM
,      PARTY_ID
,      SITE_USE_ID
,      AUTOPAY_FLAG
,      CLAIM_THRESHOLD
,      CLAIM_CURRENCY
,      PRINT_FLAG
,      INTERNET_DEAL_VIEW_FLAG
,      INTERNET_CLAIMS_FLAG
,      AUTOPAY_PERIODICITY
,      AUTOPAY_PERIODICITY_TYPE
,      PAYMENT_METHOD
,      DISCOUNT_TYPE
,      CUST_ACCOUNT_ID
,      CUST_ACCT_SITE_ID
,      CONTEXT
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ORG_ID
,      SECURITY_GROUP_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      VENDOR_SITE_CODE
,      DAYS_DUE
,      LAST_PAID_DATE
,      UN_EARNED_PAY_ALLOW_TO
,      UN_EARNED_PAY_THOLD_TYPE
,      UN_EARNED_PAY_THOLD_AMOUNT
,      UN_EARNED_PAY_THOLD_FLAG
,      HEADER_TOLERANCE_OPERAND
,      HEADER_TOLERANCE_CALC_CODE
,      LINE_TOLERANCE_OPERAND
,      LINE_TOLERANCE_CALC_CODE
,      POS_WRITE_OFF_THRESHOLD
,      NEG_WRITE_OFF_THRESHOLD
FROM OZF.OZF_CUST_TRD_PRFLS_ALL;

Dependencies

[top of page]

OZF.OZF_CUST_TRD_PRFLS_ALL does not reference any database object

OZF.OZF_CUST_TRD_PRFLS_ALL is referenced by following:

SchemaOZF
ViewOZF_CUST_TRD_PRFLS_ALL#