SQL-084: Update financialtransactioncode¶

Update financialtransactioncode in the context of clsFinancialTransactionCode.

Classification¶

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

Parameters¶

Parameter	Direction	Type	Max length	Description
`:Code`	Input	String*	inferred/unknown	Bind variable in clsFinancialTransactionCode.UpdateSQL.
`:Description`	Input	String*	inferred/unknown	Bind variable in clsFinancialTransactionCode.UpdateSQL.
`:CommissionEligibleFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCode.UpdateSQL.
`:ManualAddFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCode.UpdateSQL.
`:DetailTable`	Input	Unknown*	inferred/unknown	Bind variable in clsFinancialTransactionCode.UpdateSQL.
`:CreditPFTHierarchyNumber`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransactionCode.UpdateSQL.
`:FeeAmount`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransactionCode.UpdateSQL.
`:GroupCode`	Input	String*	inferred/unknown	Bind variable in clsFinancialTransactionCode.UpdateSQL.
`:BilledPremiumFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCode.UpdateSQL.
`:AllowableSign`	Input	Unknown*	inferred/unknown	Bind variable in clsFinancialTransactionCode.UpdateSQL.
`:DebitPFTHierarchyNumber`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransactionCode.UpdateSQL.
`:WCISReversalFunctionCode`	Input	String*	inferred/unknown	Bind variable in clsFinancialTransactionCode.UpdateSQL.
`:ARReportPFTGroupCode`	Input	String*	inferred/unknown	Bind variable in clsFinancialTransactionCode.UpdateSQL.
`:WCISAddFunctionCode`	Input	String*	inferred/unknown	Bind variable in clsFinancialTransactionCode.UpdateSQL.
`:ManualDistributionCode`	Input	String*	inferred/unknown	Bind variable in clsFinancialTransactionCode.UpdateSQL.
`:InterestFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCode.UpdateSQL.
`:PenaltyPFTHierarchyNumber`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransactionCode.UpdateSQL.
`:CancelReasonCode`	Input	String*	inferred/unknown	Bind variable in clsFinancialTransactionCode.UpdateSQL.
`:GLReportPFTGroupCode`	Input	String*	inferred/unknown	Bind variable in clsFinancialTransactionCode.UpdateSQL.
`:AutoReverseFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCode.UpdateSQL.
`:CommSourceExclFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCode.UpdateSQL.
`:AdvancePremiumSearchFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCode.UpdateSQL.
`:CreditApplyPPFirstFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCode.UpdateSQL.
`:PeriodSummaryGroupCode`	Input	String*	inferred/unknown	Bind variable in clsFinancialTransactionCode.UpdateSQL.
`:ReconciliationNetFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCode.UpdateSQL.
`:PPCreditAvailableFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCode.UpdateSQL.
`:ARPReportPremiumFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCode.UpdateSQL.
`:DepositPolicyPeriodFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCode.UpdateSQL.
`:DepositPaidFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCode.UpdateSQL.
`:DebitPaidFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCode.UpdateSQL.
`:RetroPFTTypeCode`	Input	String*	inferred/unknown	Bind variable in clsFinancialTransactionCode.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 = :Description,
  COMMISSION_ELIGIBLE_FLAG = :CommissionEligibleFlag,
  MANUAL_ADD_FLAG = :ManualAddFlag,
  DETAIL_TABLE = :DetailTable,
  CREDIT_PFT_HIERARCHY_NUM = :CreditPFTHierarchyNumber,
  FEE_AMOUNT = :FeeAmount,
  PFT_GROUP_CODE = :GroupCode,
  BILLED_PREM_FLAG = :BilledPremiumFlag,
  ALLOWABLE_SIGN = :AllowableSign,
  DEBIT_PFT_HIERARCHY_NUM = :DebitPFTHierarchyNumber,
  WCIS_REVERSAL_FUNCTION_CODE = :WCISReversalFunctionCode,
  AR_RPT_PFT_GROUP_CODE = :ARReportPFTGroupCode,
  WCIS_ADD_FUNCTION_CODE = :WCISAddFunctionCode,
  PFT_MANUAL_DISTRIBUTION_CODE = :ManualDistributionCode,
  INTEREST_FLAG = :InterestFlag,
  PENALTY_PFT_HIERARCHY_NUM = :PenaltyPFTHierarchyNumber,
  CANCEL_REASON_CODE = :CancelReasonCode,
  GL_RPT_PFT_GROUP_CODE = :GLReportPFTGroupCode,
  AUTO_REVERSE_FLAG = :AutoReverseFlag,
  COMM_SOURCE_EXCL_FLAG = :CommSourceExclFlag,
  ADV_PREM_SEARCH_FLAG = :AdvancePremiumSearchFlag,
  CREDIT_APPLY_PP_FIRST_FLAG = :CreditApplyPPFirstFlag,
  PERIOD_SUMMARY_GROUP_CODE = :PeriodSummaryGroupCode,
  RECONCILIATION_NET_FLAG = :ReconciliationNetFlag,
  POL_PER_CREDIT_AVAILABLE_FLAG = :PPCreditAvailableFlag,
  ARP_RPT_PREMIUM_FLAG = :ARPReportPremiumFlag,
  DEPOSIT_POLICY_PERIOD_FLAG = :DepositPolicyPeriodFlag,
  DEPOSIT_PAID_FLAG = :DepositPaidFlag,
  DEBIT_PAID_FLAG = :DebitPaidFlag,
  RETRO_PFT_TYPE_CODE = :RetroPFTTypeCode
WHERE
  POLICY_FINANCIAL_TRANS_CODE.CODE = :Code

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/clsFinancialTransactionCode.vb