SQL-020: Insert financialtransactioncode¶

Insert financialtransactioncode in the context of clsFinancialTransactionCode.

Classification¶

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

Parameters¶

Parameter	Direction	Type	Max length	Description
`:Code`	Input	String*	inferred/unknown	Bind variable in clsFinancialTransactionCode.InsertSQL.
`:Description`	Input	String*	inferred/unknown	Bind variable in clsFinancialTransactionCode.InsertSQL.
`:CommissionEligibleFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCode.InsertSQL.
`:ManualAddFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCode.InsertSQL.
`:DetailTable`	Input	Unknown*	inferred/unknown	Bind variable in clsFinancialTransactionCode.InsertSQL.
`:CreditPFTHierarchyNumber`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransactionCode.InsertSQL.
`:FeeAmount`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransactionCode.InsertSQL.
`:GroupCode`	Input	String*	inferred/unknown	Bind variable in clsFinancialTransactionCode.InsertSQL.
`:BilledPremiumFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCode.InsertSQL.
`:AllowableSign`	Input	Unknown*	inferred/unknown	Bind variable in clsFinancialTransactionCode.InsertSQL.
`:DebitPFTHierarchyNumber`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransactionCode.InsertSQL.
`:WCISReversalFunctionCode`	Input	String*	inferred/unknown	Bind variable in clsFinancialTransactionCode.InsertSQL.
`:ARReportPFTGroupCode`	Input	String*	inferred/unknown	Bind variable in clsFinancialTransactionCode.InsertSQL.
`:WCISAddFunctionCode`	Input	String*	inferred/unknown	Bind variable in clsFinancialTransactionCode.InsertSQL.
`:ManualDistributionCode`	Input	String*	inferred/unknown	Bind variable in clsFinancialTransactionCode.InsertSQL.
`:InterestFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCode.InsertSQL.
`:PenaltyPFTHierarchyNumber`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransactionCode.InsertSQL.
`:CancelReasonCode`	Input	String*	inferred/unknown	Bind variable in clsFinancialTransactionCode.InsertSQL.
`:GLReportPFTGroupCode`	Input	String*	inferred/unknown	Bind variable in clsFinancialTransactionCode.InsertSQL.
`:AutoReverseFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCode.InsertSQL.
`:CommSourceExclFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCode.InsertSQL.
`:AdvancePremiumSearchFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCode.InsertSQL.
`:CreditApplyPPFirstFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCode.InsertSQL.
`:PeriodSummaryGroupCode`	Input	String*	inferred/unknown	Bind variable in clsFinancialTransactionCode.InsertSQL.
`:ReconciliationNetFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCode.InsertSQL.
`:PPCreditAvailableFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCode.InsertSQL.
`:ARPReportPremiumFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCode.InsertSQL.
`:DepositPolicyPeriodFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCode.InsertSQL.
`:DepositPaidFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCode.InsertSQL.
`:DebitPaidFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCode.InsertSQL.
`:RetroPFTTypeCode`	Input	String*	inferred/unknown	Bind variable in clsFinancialTransactionCode.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,
  DEBIT_PAID_FLAG,
  RETRO_PFT_TYPE_CODE
)
VALUES (
  :Code,
  :Description,
  :CommissionEligibleFlag,
  :ManualAddFlag,
  :DetailTable,
  :CreditPFTHierarchyNumber,
  :FeeAmount,
  :GroupCode,
  :BilledPremiumFlag,
  :AllowableSign,
  :DebitPFTHierarchyNumber,
  :WCISReversalFunctionCode,
  :ARReportPFTGroupCode,
  :WCISAddFunctionCode,
  :ManualDistributionCode,
  :InterestFlag,
  :PenaltyPFTHierarchyNumber,
  :CancelReasonCode,
  :GLReportPFTGroupCode,
  :AutoReverseFlag,
  :CommSourceExclFlag,
  :AdvancePremiumSearchFlag,
  :CreditApplyPPFirstFlag,
  :PeriodSummaryGroupCode,
  :ReconciliationNetFlag,
  :PPCreditAvailableFlag,
  :ARPReportPremiumFlag,
  :DepositPolicyPeriodFlag,
  :DepositPaidFlag,
  :DebitPaidFlag,
  :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/clsFinancialTransactionCode.vb