VIEW: OZF.OZF_SYS_PARAMETERS_ALL#

Source

View Text - Preformatted

select SET_OF_BOOKS_ID SET_OF_BOOKS_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PROGRAM_ID PROGRAM_ID, CREATED_FROM CREATED_FROM, POST_TO_GL POST_TO_GL, TRANSFER_TO_GL_IN TRANSFER_TO_GL_IN, AP_PAYMENT_TERM_ID AP_PAYMENT_TERM_ID, ROUNDING_LEVEL_FLAG ROUNDING_LEVEL_FLAG, GL_ID_ROUNDING GL_ID_ROUNDING, GL_ID_DED_CLEARING GL_ID_DED_CLEARING, GL_ID_DED_ADJ GL_ID_DED_ADJ, GL_ID_ACCR_PROMO_LIAB GL_ID_ACCR_PROMO_LIAB, GL_ID_DED_ADJ_CLEARING GL_ID_DED_ADJ_CLEARING, BILLBACK_TRX_TYPE_ID BILLBACK_TRX_TYPE_ID, CM_TRX_TYPE_ID CM_TRX_TYPE_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ORG_ID ORG_ID, SECURITY_GROUP_ID SECURITY_GROUP_ID, GL_REC_DED_ACCOUNT GL_REC_DED_ACCOUNT, GL_REC_CLEARING_ACCOUNT GL_REC_CLEARING_ACCOUNT, AUTOPAY_REASON_CODE_ID AUTOPAY_REASON_CODE_ID, ACCOUNTING_METHOD_OPTION ACCOUNTING_METHOD_OPTION, GL_DATE_TYPE GL_DATE_TYPE, DAYS_DUE DAYS_DUE, CLAIM_TYPE_ID CLAIM_TYPE_ID, REASON_CODE_ID REASON_CODE_ID, AUTOPAY_CLAIM_TYPE_ID AUTOPAY_CLAIM_TYPE_ID, AUTOPAY_FLAG AUTOPAY_FLAG, AUTOPAY_PERIODICITY AUTOPAY_PERIODICITY, AUTOPAY_PERIODICITY_TYPE AUTOPAY_PERIODICITY_TYPE, BATCH_SOURCE_ID BATCH_SOURCE_ID, PAYABLES_SOURCE PAYABLES_SOURCE, DEFAULT_OWNER_ID DEFAULT_OWNER_ID, AUTO_ASSIGN_FLAG AUTO_ASSIGN_FLAG, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, ORDER_TYPE_ID ORDER_TYPE_ID, GL_BALANCING_FLEX_VALUE GL_BALANCING_FLEX_VALUE, CB_TRX_TYPE_ID CB_TRX_TYPE_ID, ADJ_REC_TRX_ID ADJ_REC_TRX_ID, WO_REC_TRX_ID WO_REC_TRX_ID, NEG_WO_REC_TRX_ID NEG_WO_REC_TRX_ID, POS_WRITE_OFF_THRESHOLD POS_WRITE_OFF_THRESHOLD, NEG_WRITE_OFF_THRESHOLD NEG_WRITE_OFF_THRESHOLD, GL_ACCT_FOR_OFFINV_FLAG GL_ACCT_FOR_OFFINV_FLAG, PRORATE_EARNINGS_FLAG PRORATE_EARNINGS_FLAG, UN_EARNED_PAY_ALLOW_TO UN_EARNED_PAY_ALLOW_TO, UN_EARNED_PAY_THOLD_TYPE UN_EARNED_PAY_THOLD_TYPE, UN_EARNED_PAY_THOLD_AMOUNT UN_EARNED_PAY_THOLD_AMOUNT, UN_EARNED_PAY_THOLD_FLAG UN_EARNED_PAY_THOLD_FLAG, HEADER_TOLERANCE_OPERAND HEADER_TOLERANCE_OPERAND, HEADER_TOLERANCE_CALC_CODE HEADER_TOLERANCE_CALC_CODE, LINE_TOLERANCE_OPERAND LINE_TOLERANCE_OPERAND, LINE_TOLERANCE_CALC_CODE LINE_TOLERANCE_CALC_CODE, SHIP_DEBIT_ACCRUAL_FLAG SHIP_DEBIT_ACCRUAL_FLAG, SHIP_DEBIT_CALC_TYPE SHIP_DEBIT_CALC_TYPE, INVENTORY_TRACKING_FLAG INVENTORY_TRACKING_FLAG, END_CUST_RELATION_FLAG END_CUST_RELATION_FLAG, AUTO_TP_ACCRUAL_FLAG AUTO_TP_ACCRUAL_FLAG, QUOTA_UNIT QUOTA_UNIT, SALES_CREDIT_DEFAULT_TYPE SALES_CREDIT_DEFAULT_TYPE, NET_AMT_FOR_MASS_SETTLE_FLAG NET_AMT_FOR_MASS_SETTLE_FLAG, CLAIM_TAX_INCL_FLAG CLAIM_TAX_INCL_FLAG, GL_CONTRA_LIABILITY_ACCT GL_CONTRA_LIABILITY_ACCT, GL_COST_ADJUSTMENT_ACCT GL_COST_ADJUSTMENT_ACCT, GL_PP_ACCRUAL_ACCT GL_PP_ACCRUAL_ACCT, RULE_BASED RULE_BASED, APPROVAL_NEW_CREDIT APPROVAL_NEW_CREDIT, APPROVAL_MATCHED_CREDIT APPROVAL_MATCHED_CREDIT, CUST_NAME_MATCH_TYPE CUST_NAME_MATCH_TYPE, CREDIT_MATCHING_THOLD_TYPE CREDIT_MATCHING_THOLD_TYPE, CREDIT_TOLERANCE_OPERAND CREDIT_TOLERANCE_OPERAND, AUTOMATE_NOTIFICATION_DAYS AUTOMATE_NOTIFICATION_DAYS, SSD_INC_ADJ_TYPE_ID SSD_INC_ADJ_TYPE_ID, SSD_DEC_ADJ_TYPE_ID SSD_DEC_ADJ_TYPE_ID, SSD_IMD_CLAIM_FLAG SSD_IMD_CLAIM_FLAG from "OZF"."OZF_SYS_PARAMETERS_ALL"

View Text - HTML Formatted

SELECT SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PROGRAM_ID PROGRAM_ID
, CREATED_FROM CREATED_FROM
, POST_TO_GL POST_TO_GL
, TRANSFER_TO_GL_IN TRANSFER_TO_GL_IN
, AP_PAYMENT_TERM_ID AP_PAYMENT_TERM_ID
, ROUNDING_LEVEL_FLAG ROUNDING_LEVEL_FLAG
, GL_ID_ROUNDING GL_ID_ROUNDING
, GL_ID_DED_CLEARING GL_ID_DED_CLEARING
, GL_ID_DED_ADJ GL_ID_DED_ADJ
, GL_ID_ACCR_PROMO_LIAB GL_ID_ACCR_PROMO_LIAB
, GL_ID_DED_ADJ_CLEARING GL_ID_DED_ADJ_CLEARING
, BILLBACK_TRX_TYPE_ID BILLBACK_TRX_TYPE_ID
, CM_TRX_TYPE_ID CM_TRX_TYPE_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ORG_ID ORG_ID
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, GL_REC_DED_ACCOUNT GL_REC_DED_ACCOUNT
, GL_REC_CLEARING_ACCOUNT GL_REC_CLEARING_ACCOUNT
, AUTOPAY_REASON_CODE_ID AUTOPAY_REASON_CODE_ID
, ACCOUNTING_METHOD_OPTION ACCOUNTING_METHOD_OPTION
, GL_DATE_TYPE GL_DATE_TYPE
, DAYS_DUE DAYS_DUE
, CLAIM_TYPE_ID CLAIM_TYPE_ID
, REASON_CODE_ID REASON_CODE_ID
, AUTOPAY_CLAIM_TYPE_ID AUTOPAY_CLAIM_TYPE_ID
, AUTOPAY_FLAG AUTOPAY_FLAG
, AUTOPAY_PERIODICITY AUTOPAY_PERIODICITY
, AUTOPAY_PERIODICITY_TYPE AUTOPAY_PERIODICITY_TYPE
, BATCH_SOURCE_ID BATCH_SOURCE_ID
, PAYABLES_SOURCE PAYABLES_SOURCE
, DEFAULT_OWNER_ID DEFAULT_OWNER_ID
, AUTO_ASSIGN_FLAG AUTO_ASSIGN_FLAG
, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, ORDER_TYPE_ID ORDER_TYPE_ID
, GL_BALANCING_FLEX_VALUE GL_BALANCING_FLEX_VALUE
, CB_TRX_TYPE_ID CB_TRX_TYPE_ID
, ADJ_REC_TRX_ID ADJ_REC_TRX_ID
, WO_REC_TRX_ID WO_REC_TRX_ID
, NEG_WO_REC_TRX_ID NEG_WO_REC_TRX_ID
, POS_WRITE_OFF_THRESHOLD POS_WRITE_OFF_THRESHOLD
, NEG_WRITE_OFF_THRESHOLD NEG_WRITE_OFF_THRESHOLD
, GL_ACCT_FOR_OFFINV_FLAG GL_ACCT_FOR_OFFINV_FLAG
, PRORATE_EARNINGS_FLAG PRORATE_EARNINGS_FLAG
, UN_EARNED_PAY_ALLOW_TO UN_EARNED_PAY_ALLOW_TO
, UN_EARNED_PAY_THOLD_TYPE UN_EARNED_PAY_THOLD_TYPE
, UN_EARNED_PAY_THOLD_AMOUNT UN_EARNED_PAY_THOLD_AMOUNT
, UN_EARNED_PAY_THOLD_FLAG UN_EARNED_PAY_THOLD_FLAG
, HEADER_TOLERANCE_OPERAND HEADER_TOLERANCE_OPERAND
, HEADER_TOLERANCE_CALC_CODE HEADER_TOLERANCE_CALC_CODE
, LINE_TOLERANCE_OPERAND LINE_TOLERANCE_OPERAND
, LINE_TOLERANCE_CALC_CODE LINE_TOLERANCE_CALC_CODE
, SHIP_DEBIT_ACCRUAL_FLAG SHIP_DEBIT_ACCRUAL_FLAG
, SHIP_DEBIT_CALC_TYPE SHIP_DEBIT_CALC_TYPE
, INVENTORY_TRACKING_FLAG INVENTORY_TRACKING_FLAG
, END_CUST_RELATION_FLAG END_CUST_RELATION_FLAG
, AUTO_TP_ACCRUAL_FLAG AUTO_TP_ACCRUAL_FLAG
, QUOTA_UNIT QUOTA_UNIT
, SALES_CREDIT_DEFAULT_TYPE SALES_CREDIT_DEFAULT_TYPE
, NET_AMT_FOR_MASS_SETTLE_FLAG NET_AMT_FOR_MASS_SETTLE_FLAG
, CLAIM_TAX_INCL_FLAG CLAIM_TAX_INCL_FLAG
, GL_CONTRA_LIABILITY_ACCT GL_CONTRA_LIABILITY_ACCT
, GL_COST_ADJUSTMENT_ACCT GL_COST_ADJUSTMENT_ACCT
, GL_PP_ACCRUAL_ACCT GL_PP_ACCRUAL_ACCT
, RULE_BASED RULE_BASED
, APPROVAL_NEW_CREDIT APPROVAL_NEW_CREDIT
, APPROVAL_MATCHED_CREDIT APPROVAL_MATCHED_CREDIT
, CUST_NAME_MATCH_TYPE CUST_NAME_MATCH_TYPE
, CREDIT_MATCHING_THOLD_TYPE CREDIT_MATCHING_THOLD_TYPE
, CREDIT_TOLERANCE_OPERAND CREDIT_TOLERANCE_OPERAND
, AUTOMATE_NOTIFICATION_DAYS AUTOMATE_NOTIFICATION_DAYS
, SSD_INC_ADJ_TYPE_ID SSD_INC_ADJ_TYPE_ID
, SSD_DEC_ADJ_TYPE_ID SSD_DEC_ADJ_TYPE_ID
, SSD_IMD_CLAIM_FLAG SSD_IMD_CLAIM_FLAG
FROM "OZF"."OZF_SYS_PARAMETERS_ALL"