SQL-083: Update financialtransaction¶

Update financialtransaction in the context of clsFinancialTransaction.

Classification¶

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

Parameters¶

Parameter	Direction	Type	Max length	Description
`:FinancialTransactionSeqNum`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransaction.UpdateSQL.
`:PolicyNumber`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransaction.UpdateSQL.
`:PolicyPeriodEffectiveDate`	Input	Date	inferred/unknown	Bind variable in clsFinancialTransaction.UpdateSQL.
`:BatchNumber`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransaction.UpdateSQL.
`:BatchDate`	Input	Date	inferred/unknown	Bind variable in clsFinancialTransaction.UpdateSQL.
`:CheckNumber`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransaction.UpdateSQL.
`:InvoiceNumber`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransaction.UpdateSQL.
`:TransactionAmount`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransaction.UpdateSQL.
`:InvoiceDate`	Input	Date	inferred/unknown	Bind variable in clsFinancialTransaction.UpdateSQL.
`:TransactionDate`	Input	Date	inferred/unknown	Bind variable in clsFinancialTransaction.UpdateSQL.
`:TransactionStatusCode`	Input	String*	inferred/unknown	Bind variable in clsFinancialTransaction.UpdateSQL.
`:TransactionTypeCode`	Input	String*	inferred/unknown	Bind variable in clsFinancialTransaction.UpdateSQL.
`:AmountPaid`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransaction.UpdateSQL.
`:PremiumHistorySetID`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransaction.UpdateSQL.
`:CreateDate`	Input	Date	inferred/unknown	Bind variable in clsFinancialTransaction.UpdateSQL.
`:CreateUser`	Input	String*	inferred/unknown	Bind variable in clsFinancialTransaction.UpdateSQL.
`:UpdateDate`	Input	Date	inferred/unknown	Bind variable in clsFinancialTransaction.UpdateSQL.
`:UpdateUser`	Input	Date	inferred/unknown	Bind variable in clsFinancialTransaction.UpdateSQL.
`:WarrantNumber`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransaction.UpdateSQL.
`:ApplyToInvoiceNumber`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransaction.UpdateSQL.
`:GLInterfaceControlNumber`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransaction.UpdateSQL.
`:BillingDetailSeqNum`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransaction.UpdateSQL.
`:DCBTrackingSeqNum`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransaction.UpdateSQL.
`:CommPremAmt`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransaction.UpdateSQL.
`:PayrollSeqNum`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransaction.UpdateSQL.
`:DueDate`	Input	Date	inferred/unknown	Bind variable in clsFinancialTransaction.UpdateSQL.
`:PolicyRelationshipPolicyNumber`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransaction.UpdateSQL.
`:PolicyRelationshipPolicyPeriodEffectiveDate`	Input	Date	inferred/unknown	Bind variable in clsFinancialTransaction.UpdateSQL.
`:InvoiceDisplayFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsFinancialTransaction.UpdateSQL.
`:ARPPremiumAmount`	Input	Numeric*	inferred/unknown	Bind variable in clsFinancialTransaction.UpdateSQL.
`:GLTransactionTypeCode`	Input	String*	inferred/unknown	Bind variable in clsFinancialTransaction.UpdateSQL.

Tables¶

Table	Access	Columns used
POLICY_FINANCIAL_TRANS	UPDATE	See sample SQL

Sample SQL¶

Update POLICY_FINANCIAL_TRANS
SET
  POLICY_TRANS_SEQ_NUM = :FinancialTransactionSeqNum,
  POLICY_NUM = :PolicyNumber,
  POLICY_PERIOD_EFF_DATE = :PolicyPeriodEffectiveDate,
  BATCH_NUM = :BatchNumber,
  BATCH_DATE = :BatchDate,
  CHECK_NUM = :CheckNumber,
  INVOICE_NUM = :InvoiceNumber,
  TRANS_AMT = :TransactionAmount,
  INVOICE_DATE = :InvoiceDate,
  TRANS_DATE = :TransactionDate,
  TRANS_STATUS_CODE = :TransactionStatusCode,
  TRANS_TYPE_CODE = :TransactionTypeCode,
  AMOUNT_PAID = :AmountPaid,
  PREM_HIST_SET_ID = :PremiumHistorySetID,
  CREATE_DATE = :CreateDate,
  CREATE_USER = :CreateUser,
  UPDATE_DATE = :UpdateDate,
  UPDATE_USER = :UpdateUser,
  WARRANT_NUM = :WarrantNumber,
  APPLY_TO_INVOICE_NUM = :ApplyToInvoiceNumber,
  GL_INTERFACE_CONTROL_NUM = :GLInterfaceControlNumber,
  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 = :PolicyRelationshipPolicyNumber,
  POL_REL_POLICY_PERIOD_EFF_DATE = :PolicyRelationshipPolicyPeriodEffectiveDate,
  INVOICE_DISPLAY_FLAG = :InvoiceDisplayFlag,
  ARP_PREM_AMT = :ARPPremiumAmount,
  GL_TRANS_TYPE_CODE = :GLTransactionTypeCode
WHERE
  POLICY_FINANCIAL_TRANS.POLICY_TRANS_SEQ_NUM = :FinancialTransactionSeqNum

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