SQL-021: Insert financialtransactioncode collection

Insert financialtransactioncode collection in the context of clsFinancialTransactionCodeCollection.

Classification

Field	Value
SQL ID	SQL-021
Operation type	Insert
Execution method	NonQuery
Database	Oracle
Command type	Text
Schema	[unqualified]
Business object	clsFinancialTransactionCodeCollection
Criteria property	InsertSQL
Lifecycle method	BeforeInsert / AfterInsert

Parameters

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

Tables

Table	Access	Columns used
POLICY_FINANCIAL_TRANS_CODE	INSERT	See sample SQL

Sample SQL

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

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