SQL-085: Update financialtransactioncode collection¶

Update financialtransactioncode collection in the context of clsFinancialTransactionCodeCollection.

Classification¶

Field	Value
SQL ID	SQL-085
Operation type	Update
Execution method	NonQuery
Database	Oracle
Command type	Text
Schema	[unqualified]
Business object	`clsFinancialTransactionCodeCollection`
Criteria property	`UpdateSQL`
Lifecycle method	BeforeUpdate / AfterUpdate

Parameters¶

Parameter	Direction	Type	Max length	Description
`:Code`	Input	String*	inferred/unknown	Bind variable in clsFinancialTransactionCodeCollection.UpdateSQL.
`:CodeDescr`	Input	String*	inferred/unknown	Bind variable in clsFinancialTransactionCodeCollection.UpdateSQL.
`:CommissionEligibleFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCodeCollection.UpdateSQL.
`:ManualAddFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCodeCollection.UpdateSQL.
`:DetailTable`	Input	Unknown*	inferred/unknown	Bind variable in clsFinancialTransactionCodeCollection.UpdateSQL.
`:CreditPftHierarchyNum`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransactionCodeCollection.UpdateSQL.
`:FeeAmount`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransactionCodeCollection.UpdateSQL.
`:PftGroupCode`	Input	String*	inferred/unknown	Bind variable in clsFinancialTransactionCodeCollection.UpdateSQL.
`:BilledPremFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCodeCollection.UpdateSQL.
`:AllowableSign`	Input	Unknown*	inferred/unknown	Bind variable in clsFinancialTransactionCodeCollection.UpdateSQL.
`:DebitPftHierarchyNum`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransactionCodeCollection.UpdateSQL.
`:WcisReversalFunctionCode`	Input	String*	inferred/unknown	Bind variable in clsFinancialTransactionCodeCollection.UpdateSQL.
`:ARRptPftGroupCode`	Input	String*	inferred/unknown	Bind variable in clsFinancialTransactionCodeCollection.UpdateSQL.
`:WcisAddFunctionCode`	Input	String*	inferred/unknown	Bind variable in clsFinancialTransactionCodeCollection.UpdateSQL.
`:PftManualDistributionCode`	Input	String*	inferred/unknown	Bind variable in clsFinancialTransactionCodeCollection.UpdateSQL.
`:InterestFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCodeCollection.UpdateSQL.
`:PenaltyPftHierarchyNum`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransactionCodeCollection.UpdateSQL.
`:CancelReasonCode`	Input	String*	inferred/unknown	Bind variable in clsFinancialTransactionCodeCollection.UpdateSQL.
`:GLRptPftGroupCode`	Input	String*	inferred/unknown	Bind variable in clsFinancialTransactionCodeCollection.UpdateSQL.
`:AutoReverseFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCodeCollection.UpdateSQL.
`:CommSourceExclFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCodeCollection.UpdateSQL.
`:AdvPremSearchFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCodeCollection.UpdateSQL.
`:CreditApplyPPFirstFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCodeCollection.UpdateSQL.
`:PeriodSummaryGroupCode`	Input	String*	inferred/unknown	Bind variable in clsFinancialTransactionCodeCollection.UpdateSQL.
`:ReconciliationNetFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCodeCollection.UpdateSQL.
`:PolPerCreditAvailableFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCodeCollection.UpdateSQL.
`:ArpRptPremiumFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCodeCollection.UpdateSQL.
`:DepositPolicyPeriodFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCodeCollection.UpdateSQL.
`:DepositPaidFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCodeCollection.UpdateSQL.
`:RetroPftTypeCode`	Input	String*	inferred/unknown	Bind variable in clsFinancialTransactionCodeCollection.UpdateSQL.

Tables¶

Table	Access	Columns used
POLICY_FINANCIAL_TRANS_CODE	UPDATE	See sample SQL

Sample SQL¶

Update POLICY_FINANCIAL_TRANS_CODE
SET
  CODE = :Code,
  CODE_DESCR = :CodeDescr,
  COMMISSION_ELIGIBLE_FLAG = :CommissionEligibleFlag,
  MANUAL_ADD_FLAG = :ManualAddFlag,
  DETAIL_TABLE = :DetailTable,
  CREDIT_PFT_HIERARCHY_NUM = :CreditPftHierarchyNum,
  FEE_AMOUNT = :FeeAmount,
  PFT_GROUP_CODE = :PftGroupCode,
  BILLED_PREM_FLAG = :BilledPremFlag,
  ALLOWABLE_SIGN = :AllowableSign,
  DEBIT_PFT_HIERARCHY_NUM = :DebitPftHierarchyNum,
  WCIS_REVERSAL_FUNCTION_CODE = :WcisReversalFunctionCode,
  AR_RPT_PFT_GROUP_CODE = :ARRptPftGroupCode,
  WCIS_ADD_FUNCTION_CODE = :WcisAddFunctionCode,
  PFT_MANUAL_DISTRIBUTION_CODE = :PftManualDistributionCode,
  INTEREST_FLAG = :InterestFlag,
  PENALTY_PFT_HIERARCHY_NUM = :PenaltyPftHierarchyNum,
  CANCEL_REASON_CODE = :CancelReasonCode,
  GL_RPT_PFT_GROUP_CODE = :GLRptPftGroupCode,
  AUTO_REVERSE_FLAG = :AutoReverseFlag,
  COMM_SOURCE_EXCL_FLAG = :CommSourceExclFlag,
  ADV_PREM_SEARCH_FLAG = :AdvPremSearchFlag,
  CREDIT_APPLY_PP_FIRST_FLAG = :CreditApplyPPFirstFlag,
  PERIOD_SUMMARY_GROUP_CODE = :PeriodSummaryGroupCode,
  RECONCILIATION_NET_FLAG = :ReconciliationNetFlag,
  POL_PER_CREDIT_AVAILABLE_FLAG = :PolPerCreditAvailableFlag,
  ARP_RPT_PREMIUM_FLAG = :ArpRptPremiumFlag,
  DEPOSIT_POLICY_PERIOD_FLAG = :DepositPolicyPeriodFlag,
  DEPOSIT_PAID_FLAG = :DepositPaidFlag,
  RETRO_PFT_TYPE_CODE = :RetroPftTypeCode Where

Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources¶

Business/SAIF.Business.Policy.Premium/Billing/clsFinancialTransactionCodeCollection.vb