[Home] [Help] [Dependency Information]
Object Name: | OZF_CUST_TRD_PRFLS_ALL |
---|---|
Object Type: | TABLE |
Owner: | OZF |
FND Design Data: | OZF.OZF_CUST_TRD_PRFLS_ALL |
Subobject Name: | |
Status: | VALID |
OZF_CUST_TRD_PRFLS_ALL stores the Customer trade profiles
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OZF_CUST_TRD_PRFLS_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | TRADE_PROFILE_ID |
OZF_CUST_TRD_PRFLS_ALL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CUST_ACCOUNT_ID |
OZF_CUST_TRD_PRFLS_ALL_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PARTY_ID |
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) |
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;
OZF.OZF_CUST_TRD_PRFLS_ALL does not reference any database object
OZF.OZF_CUST_TRD_PRFLS_ALL is referenced by following:
|
|
|