SQL-086: Update financialtransaction collection¶

Update financialtransaction collection in the context of clsFinancialTransactionCollection.

Classification¶

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

Parameters¶

Parameter	Direction	Type	Max length	Description
`:PolicyTransSeqNum`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransactionCollection.UpdateSQL.
`:PolicyNumber`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransactionCollection.UpdateSQL.
`:PolicyPeriodEffectiveDate`	Input	Date	inferred/unknown	Bind variable in clsFinancialTransactionCollection.UpdateSQL.
`:BatchNum`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransactionCollection.UpdateSQL.
`:BatchDate`	Input	Date	inferred/unknown	Bind variable in clsFinancialTransactionCollection.UpdateSQL.
`:CheckNum`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransactionCollection.UpdateSQL.
`:InvoiceNum`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransactionCollection.UpdateSQL.
`:TransAmt`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransactionCollection.UpdateSQL.
`:InvoiceDate`	Input	Date	inferred/unknown	Bind variable in clsFinancialTransactionCollection.UpdateSQL.
`:TransDate`	Input	Date	inferred/unknown	Bind variable in clsFinancialTransactionCollection.UpdateSQL.
`:TransStatusCode`	Input	String*	inferred/unknown	Bind variable in clsFinancialTransactionCollection.UpdateSQL.
`:TransTypeCode`	Input	String*	inferred/unknown	Bind variable in clsFinancialTransactionCollection.UpdateSQL.
`:AmountPaid`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransactionCollection.UpdateSQL.
`:PremHistSetID`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransactionCollection.UpdateSQL.
`:CreateDate`	Input	Date	inferred/unknown	Bind variable in clsFinancialTransactionCollection.UpdateSQL.
`:CreateUser`	Input	String*	inferred/unknown	Bind variable in clsFinancialTransactionCollection.UpdateSQL.
`:UpdateDate`	Input	Date	inferred/unknown	Bind variable in clsFinancialTransactionCollection.UpdateSQL.
`:UpdateUser`	Input	Date	inferred/unknown	Bind variable in clsFinancialTransactionCollection.UpdateSQL.
`:WarrantNum`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransactionCollection.UpdateSQL.
`:ApplyTOInvoiceNum`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransactionCollection.UpdateSQL.
`:GLInterfaceControlNum`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransactionCollection.UpdateSQL.
`:BillingDetailSeqNum`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransactionCollection.UpdateSQL.
`:DcbTrackingSeqNum`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransactionCollection.UpdateSQL.
`:CommPremAmt`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransactionCollection.UpdateSQL.
`:PayrollSeqNum`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransactionCollection.UpdateSQL.
`:DueDate`	Input	Date	inferred/unknown	Bind variable in clsFinancialTransactionCollection.UpdateSQL.
`:PolRelPolicyNum`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransactionCollection.UpdateSQL.
`:PolRelPolicyPeriodEffDate`	Input	Date	inferred/unknown	Bind variable in clsFinancialTransactionCollection.UpdateSQL.
`:InvoiceDisplayFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransactionCollection.UpdateSQL.
`:ArpPremAmt`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransactionCollection.UpdateSQL.
`:GLTransTypeCode`	Input	String*	inferred/unknown	Bind variable in clsFinancialTransactionCollection.UpdateSQL.

Tables¶

Table	Access	Columns used
POLICY_FINANCIAL_TRANS	UPDATE	See sample SQL

Sample SQL¶

Update POLICY_FINANCIAL_TRANS
SET
  POLICY_TRANS_SEQ_NUM = :PolicyTransSeqNum,
  POLICY_NUM = :PolicyNumber,
  POLICY_PERIOD_EFF_DATE = :PolicyPeriodEffectiveDate,
  BATCH_NUM = :BatchNum,
  BATCH_DATE = :BatchDate,
  CHECK_NUM = :CheckNum,
  INVOICE_NUM = :InvoiceNum,
  TRANS_AMT = :TransAmt,
  INVOICE_DATE = :InvoiceDate,
  TRANS_DATE = :TransDate,
  TRANS_STATUS_CODE = :TransStatusCode,
  TRANS_TYPE_CODE = :TransTypeCode,
  AMOUNT_PAID = :AmountPaid,
  PREM_HIST_SET_ID = :PremHistSetID,
  CREATE_DATE = :CreateDate,
  CREATE_USER = :CreateUser,
  UPDATE_DATE = :UpdateDate,
  UPDATE_USER = :UpdateUser,
  WARRANT_NUM = :WarrantNum,
  APPLY_TO_INVOICE_NUM = :ApplyTOInvoiceNum,
  GL_INTERFACE_CONTROL_NUM = :GLInterfaceControlNum,
  BILLING_DETAIL_SEQ_NUM = :BillingDetailSeqNum,
  DCB_TRACKING_SEQ_NUM = :DcbTrackingSeqNum,
  COMM_PREM_AMT = :CommPremAmt,
  PAYROLL_SEQ_NUM = :PayrollSeqNum,
  DUE_DATE = :DueDate,
  POL_REL_POLICY_NUM = :PolRelPolicyNum,
  POL_REL_POLICY_PERIOD_EFF_DATE = :PolRelPolicyPeriodEffDate,
  INVOICE_DISPLAY_FLAG = :InvoiceDisplayFlag,
  ARP_PREM_AMT = :ArpPremAmt,
  GL_TRANS_TYPE_CODE = :GLTransTypeCode
WHERE
  POLICY_FINANCIAL_TRANS.POLICY_NUM = :PolicyNumber
  AND POLICY_FINANCIAL_TRANS.POLICY_PERIOD_EFF_DATE = :PolicyPeriodEffectiveDate

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