[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OZF_SYS_PARAMETERS_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | OZF |
| FND Design Data: |  OZF.OZF_SYS_PARAMETERS_ALL
|
| Subobject Name: | |
| Status: | VALID |
OZF_SYS_PARAMETERS_ALL stores the system parameters for General Ledger interface
| Tablespace: |  APPS_TS_SEED |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| OZF_SYS_PARAMETERS_ALL_U1 | NORMAL | UNIQUE |
APPS_TS_SEED
|
 ORG_ID
SET_OF_BOOKS_ID
|
| OZF_SYS_PARAMETERS_ALL_N1 | NORMAL | NONUNIQUE |
APPS_TS_SEED
|
SET_OF_BOOKS_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SET_OF_BOOKS_ID | NUMBER | Yes | Set Of Books 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 | |
| POST_TO_GL | VARCHAR2 | (1) | Yes | Indicated whether transactions will be posted to General Ledger |
| TRANSFER_TO_GL_IN | VARCHAR2 | (1) | Yes | Indicatess whether the transter to General Ledger is complete |
| AP_PAYMENT_TERM_ID | NUMBER | AP Payment term Identifier | ||
| ROUNDING_LEVEL_FLAG | VARCHAR2 | (1) | Rounding level flag | |
| GL_ID_ROUNDING | NUMBER | General Ledger Rounding Account Identifier | ||
| GL_ID_DED_CLEARING | NUMBER | General Ledger Deduction Clearing Account Identifier | ||
| GL_ID_DED_ADJ | NUMBER | General Ledger Deduction Adjustment Account Identifier | ||
| GL_ID_ACCR_PROMO_LIAB | NUMBER | General Ledger Accural Promotion Account Identifier | ||
| GL_ID_DED_ADJ_CLEARING | NUMBER | General Ledger Deduction Adjustment Clearing Account Identifier | ||
| BILLBACK_TRX_TYPE_ID | NUMBER | Debit Transaction Type Identifier | ||
| CM_TRX_TYPE_ID | NUMBER | Credit Transaction Type Identifier | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | 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 | Organization Identifier | ||
| SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
| GL_REC_DED_ACCOUNT | NUMBER | General Ledger Receivables Deduction Account Identifier | ||
| GL_REC_CLEARING_ACCOUNT | NUMBER | General Ledger Receivables Clearing Account Identifier | ||
| AUTOPAY_REASON_CODE_ID | NUMBER | Autopay reason code identifier | ||
| ACCOUNTING_METHOD_OPTION | VARCHAR2 | (25) | Accounting method option | |
| GL_DATE_TYPE | VARCHAR2 | (30) | GL Date type used for defaulting on settlement | |
| DAYS_DUE | NUMBER | Grace days due for settling claims | ||
| CLAIM_TYPE_ID | NUMBER | Claim type identifier used in defaulting deductions | ||
| REASON_CODE_ID | NUMBER | Reason Code identifier used in defaulting deductions | ||
| AUTOPAY_CLAIM_TYPE_ID | NUMBER | Claim type identifier used in defaulting autopay | ||
| AUTOPAY_FLAG | VARCHAR2 | (1) | Indicates whether autopay is made | |
| AUTOPAY_PERIODICITY | NUMBER | Duration in numbers for autopay | ||
| AUTOPAY_PERIODICITY_TYPE | VARCHAR2 | (30) | Duration type for autopay | |
| BATCH_SOURCE_ID | NUMBER | Receivables Batch Source | ||
| PAYABLES_SOURCE | VARCHAR2 | (30) | Payables Source for Invoice import | |
| DEFAULT_OWNER_ID | NUMBER | Default owner for imported claims | ||
| AUTO_ASSIGN_FLAG | VARCHAR2 | (1) | Flag to indicate if auto assignment is enabled using territories - assignment manager for claim owner | |
| EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Default Exchange rate type used when creating claims | |
| ORDER_TYPE_ID | NUMBER | Transaction type id from Order Management | ||
| GL_BALANCING_FLEX_VALUE | VARCHAR2 | (150) | General Legder Balancing Segment Value | |
| CB_TRX_TYPE_ID | NUMBER | Chargeback Transaction Type Identifier | ||
| ADJ_REC_TRX_ID | NUMBER | Receivables Activity Identifier for Transaction Write-off Activity | ||
| WO_REC_TRX_ID | NUMBER | Receivables Activity Identifier for Deduction Write-off | ||
| NEG_WO_REC_TRX_ID | NUMBER | Receivables Activity Identifier for Overpayment Write-off | ||
| POS_WRITE_OFF_THRESHOLD | NUMBER | Write-off threshold for overpayments | ||
| NEG_WRITE_OFF_THRESHOLD | NUMBER | Write-off threshold for Deduction | ||
| GL_ACCT_FOR_OFFINV_FLAG | VARCHAR2 | (1) | Indicates if posting to GL happens for Off-invoice discounts | |
| PRORATE_EARNINGS_FLAG | VARCHAR2 | (1) | Indicates if earnings should be prorated among products | |
| UN_EARNED_PAY_ALLOW_TO | VARCHAR2 | (30) | Flag that 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) | Flag that indicates whether the threshold for unearned earnings can be overriden | |
| HEADER_TOLERANCE_OPERAND | NUMBER | Header tolerance operand | ||
| HEADER_TOLERANCE_CALC_CODE | VARCHAR2 | (30) | Header tolearance calculation code | |
| LINE_TOLERANCE_OPERAND | NUMBER | Line level tolerance operand | ||
| LINE_TOLERANCE_CALC_CODE | VARCHAR2 | (30) | Line tolerance calculation code | |
| SHIP_DEBIT_ACCRUAL_FLAG | VARCHAR2 | (1) | Flag that Indicates whether to Create Accruals On Chargeback Claims | |
| SHIP_DEBIT_CALC_TYPE | VARCHAR2 | (30) | Chargeback Calculation Basis Chargeback Calculation Basis | |
| INVENTORY_TRACKING_FLAG | VARCHAR2 | (1) | Inventory Tracking Flag | |
| END_CUST_RELATION_FLAG | VARCHAR2 | (1) | Create Relationship Between End User and Wholesaler | |
| AUTO_TP_ACCRUAL_FLAG | VARCHAR2 | (1) | Run Third Party Accrual After Chargeback Calculation | |
| QUOTA_UNIT | VARCHAR2 | (1) | ||
| SALES_CREDIT_DEFAULT_TYPE | VARCHAR2 | (30) | Sales Credit Default Type | |
| NET_AMT_FOR_MASS_SETTLE_FLAG | VARCHAR2 | (1) | Route Mass Settlement Approval Based on Net Amount | |
| CLAIM_TAX_INCL_FLAG | VARCHAR2 | (240) | Value will determins if claims and debit claims will be tax inclusive | |
| GL_CONTRA_LIABILITY_ACCT | NUMBER | General Ledger Contra Liability Account Identifier | ||
| GL_COST_ADJUSTMENT_ACCT | NUMBER | General Ledger Cost Adjustment Account Identifier | ||
| GL_PP_ACCRUAL_ACCT | NUMBER | General Ledger Price Protection Accrual Account Identifier | ||
| RULE_BASED | VARCHAR2 | (1) | Rule Based | |
| APPROVAL_NEW_CREDIT | VARCHAR2 | (1) | Approval New Credit | |
| APPROVAL_MATCHED_CREDIT | VARCHAR2 | (1) | Approval Matched Credit | |
| CUST_NAME_MATCH_TYPE | VARCHAR2 | (50) | Cust Name Match Type | |
| CREDIT_MATCHING_THOLD_TYPE | VARCHAR2 | (50) | Credit Matching Thold Type | |
| CREDIT_TOLERANCE_OPERAND | NUMBER | Credit Tolerance Operand | ||
| AUTOMATE_NOTIFICATION_DAYS | NUMBER | Automate Notification Days | ||
| SSD_INC_ADJ_TYPE_ID | NUMBER | Ship & Debit Increase Adjustment Type Identifier | ||
| SSD_DEC_ADJ_TYPE_ID | NUMBER | Ship & Debit Decrease Adjustment Type Identifier | ||
| SSD_IMD_CLAIM_FLAG | VARCHAR2 | (1) | Flag for allowing immediate claims for Supplier Ship and Debit Batch |
Cut, paste (and edit) the following text to query this object:
SELECT SET_OF_BOOKS_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
, POST_TO_GL
, TRANSFER_TO_GL_IN
, AP_PAYMENT_TERM_ID
, ROUNDING_LEVEL_FLAG
, GL_ID_ROUNDING
, GL_ID_DED_CLEARING
, GL_ID_DED_ADJ
, GL_ID_ACCR_PROMO_LIAB
, GL_ID_DED_ADJ_CLEARING
, BILLBACK_TRX_TYPE_ID
, CM_TRX_TYPE_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ORG_ID
, SECURITY_GROUP_ID
, GL_REC_DED_ACCOUNT
, GL_REC_CLEARING_ACCOUNT
, AUTOPAY_REASON_CODE_ID
, ACCOUNTING_METHOD_OPTION
, GL_DATE_TYPE
, DAYS_DUE
, CLAIM_TYPE_ID
, REASON_CODE_ID
, AUTOPAY_CLAIM_TYPE_ID
, AUTOPAY_FLAG
, AUTOPAY_PERIODICITY
, AUTOPAY_PERIODICITY_TYPE
, BATCH_SOURCE_ID
, PAYABLES_SOURCE
, DEFAULT_OWNER_ID
, AUTO_ASSIGN_FLAG
, EXCHANGE_RATE_TYPE
, ORDER_TYPE_ID
, GL_BALANCING_FLEX_VALUE
, CB_TRX_TYPE_ID
, ADJ_REC_TRX_ID
, WO_REC_TRX_ID
, NEG_WO_REC_TRX_ID
, POS_WRITE_OFF_THRESHOLD
, NEG_WRITE_OFF_THRESHOLD
, GL_ACCT_FOR_OFFINV_FLAG
, PRORATE_EARNINGS_FLAG
, 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
, SHIP_DEBIT_ACCRUAL_FLAG
, SHIP_DEBIT_CALC_TYPE
, INVENTORY_TRACKING_FLAG
, END_CUST_RELATION_FLAG
, AUTO_TP_ACCRUAL_FLAG
, QUOTA_UNIT
, SALES_CREDIT_DEFAULT_TYPE
, NET_AMT_FOR_MASS_SETTLE_FLAG
, CLAIM_TAX_INCL_FLAG
, GL_CONTRA_LIABILITY_ACCT
, GL_COST_ADJUSTMENT_ACCT
, GL_PP_ACCRUAL_ACCT
, RULE_BASED
, APPROVAL_NEW_CREDIT
, APPROVAL_MATCHED_CREDIT
, CUST_NAME_MATCH_TYPE
, CREDIT_MATCHING_THOLD_TYPE
, CREDIT_TOLERANCE_OPERAND
, AUTOMATE_NOTIFICATION_DAYS
, SSD_INC_ADJ_TYPE_ID
, SSD_DEC_ADJ_TYPE_ID
, SSD_IMD_CLAIM_FLAG
FROM OZF.OZF_SYS_PARAMETERS_ALL;
OZF.OZF_SYS_PARAMETERS_ALL does not reference any database object
OZF.OZF_SYS_PARAMETERS_ALL is referenced by following:
OZF
OZF_SYS_PARAMETERS_ALL#
|
|
|
|