SQL-019: Insert financialtransaction¶
Insert financialtransaction in the context of clsFinancialTransaction.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-019 |
| Operation type | Insert |
| Execution method | NonQuery |
| Database | Oracle |
| Command type | Text |
| Schema | [unqualified] |
| Business object | clsFinancialTransaction |
| Criteria property | InsertSQL |
| Lifecycle method | BeforeInsert / AfterInsert |
Parameters¶
| Parameter | Direction | Type | Max length | Description |
|---|---|---|---|---|
:FinancialTransactionSeqNum |
Input | Numeric* | inferred/unknown | Bind variable in clsFinancialTransaction.InsertSQL. |
:PolicyNumber |
Input | Numeric* | inferred/unknown | Bind variable in clsFinancialTransaction.InsertSQL. |
:PolicyPeriodEffectiveDate |
Input | Date | inferred/unknown | Bind variable in clsFinancialTransaction.InsertSQL. |
:BatchNumber |
Input | Numeric* | inferred/unknown | Bind variable in clsFinancialTransaction.InsertSQL. |
:BatchDate |
Input | Date | inferred/unknown | Bind variable in clsFinancialTransaction.InsertSQL. |
:CheckNumber |
Input | Numeric* | inferred/unknown | Bind variable in clsFinancialTransaction.InsertSQL. |
:InvoiceNumber |
Input | Numeric* | inferred/unknown | Bind variable in clsFinancialTransaction.InsertSQL. |
:TransactionAmount |
Input | Numeric* | inferred/unknown | Bind variable in clsFinancialTransaction.InsertSQL. |
:InvoiceDate |
Input | Date | inferred/unknown | Bind variable in clsFinancialTransaction.InsertSQL. |
:TransactionDate |
Input | Date | inferred/unknown | Bind variable in clsFinancialTransaction.InsertSQL. |
:TransactionStatusCode |
Input | String* | inferred/unknown | Bind variable in clsFinancialTransaction.InsertSQL. |
:TransactionTypeCode |
Input | String* | inferred/unknown | Bind variable in clsFinancialTransaction.InsertSQL. |
:AmountPaid |
Input | Numeric* | inferred/unknown | Bind variable in clsFinancialTransaction.InsertSQL. |
:PremiumHistorySetID |
Input | Numeric* | inferred/unknown | Bind variable in clsFinancialTransaction.InsertSQL. |
:CreateDate |
Input | Date | inferred/unknown | Bind variable in clsFinancialTransaction.InsertSQL. |
:CreateUser |
Input | String* | inferred/unknown | Bind variable in clsFinancialTransaction.InsertSQL. |
:UpdateDate |
Input | Date | inferred/unknown | Bind variable in clsFinancialTransaction.InsertSQL. |
:UpdateUser |
Input | Date | inferred/unknown | Bind variable in clsFinancialTransaction.InsertSQL. |
:WarrantNumber |
Input | Numeric* | inferred/unknown | Bind variable in clsFinancialTransaction.InsertSQL. |
:ApplyToInvoiceNumber |
Input | Numeric* | inferred/unknown | Bind variable in clsFinancialTransaction.InsertSQL. |
:GLInterfaceControlNumber |
Input | Numeric* | inferred/unknown | Bind variable in clsFinancialTransaction.InsertSQL. |
:BillingDetailSeqNum |
Input | Numeric* | inferred/unknown | Bind variable in clsFinancialTransaction.InsertSQL. |
:DCBTrackingSeqNum |
Input | Numeric* | inferred/unknown | Bind variable in clsFinancialTransaction.InsertSQL. |
:CommPremAmt |
Input | Numeric* | inferred/unknown | Bind variable in clsFinancialTransaction.InsertSQL. |
:PayrollSeqNum |
Input | Numeric* | inferred/unknown | Bind variable in clsFinancialTransaction.InsertSQL. |
:DueDate |
Input | Date | inferred/unknown | Bind variable in clsFinancialTransaction.InsertSQL. |
:PolicyRelationshipPolicyNumber |
Input | Numeric* | inferred/unknown | Bind variable in clsFinancialTransaction.InsertSQL. |
:PolicyRelationshipPolicyPeriodEffectiveDate |
Input | Date | inferred/unknown | Bind variable in clsFinancialTransaction.InsertSQL. |
:InvoiceDisplayFlag |
Input | String (Y/N)* | inferred/unknown | Bind variable in clsFinancialTransaction.InsertSQL. |
:ARPPremiumAmount |
Input | Numeric* | inferred/unknown | Bind variable in clsFinancialTransaction.InsertSQL. |
:GLTransactionTypeCode |
Input | String* | inferred/unknown | Bind variable in clsFinancialTransaction.InsertSQL. |
Tables¶
| Table | Access | Columns used |
|---|---|---|
| POLICY_FINANCIAL_TRANS | INSERT | See sample SQL |
Sample SQL¶
Insert into POLICY_FINANCIAL_TRANS (
POLICY_TRANS_SEQ_NUM,
POLICY_NUM,
POLICY_PERIOD_EFF_DATE,
BATCH_NUM,
BATCH_DATE,
CHECK_NUM,
INVOICE_NUM,
TRANS_AMT,
INVOICE_DATE,
TRANS_DATE,
TRANS_STATUS_CODE,
TRANS_TYPE_CODE,
AMOUNT_PAID,
PREM_HIST_SET_ID,
CREATE_DATE,
CREATE_USER,
UPDATE_DATE,
UPDATE_USER,
WARRANT_NUM,
APPLY_TO_INVOICE_NUM,
GL_INTERFACE_CONTROL_NUM,
BILLING_DETAIL_SEQ_NUM,
DCB_TRACKING_SEQ_NUM,
COMM_PREM_AMT,
PAYROLL_SEQ_NUM,
DUE_DATE,
POL_REL_POLICY_NUM,
POL_REL_POLICY_PERIOD_EFF_DATE,
INVOICE_DISPLAY_FLAG,
ARP_PREM_AMT,
GL_TRANS_TYPE_CODE
)
VALUES (
:FinancialTransactionSeqNum,
:PolicyNumber,
:PolicyPeriodEffectiveDate,
:BatchNumber,
:BatchDate,
:CheckNumber,
:InvoiceNumber,
:TransactionAmount,
:InvoiceDate,
:TransactionDate,
:TransactionStatusCode,
:TransactionTypeCode,
:AmountPaid,
:PremiumHistorySetID,
:CreateDate,
:CreateUser,
:UpdateDate,
:UpdateUser,
:WarrantNumber,
:ApplyToInvoiceNumber,
:GLInterfaceControlNumber,
:BillingDetailSeqNum,
:DCBTrackingSeqNum,
:CommPremAmt,
:PayrollSeqNum,
:DueDate,
:PolicyRelationshipPolicyNumber,
:PolicyRelationshipPolicyPeriodEffectiveDate,
:InvoiceDisplayFlag,
:ARPPremiumAmount,
:GLTransactionTypeCode
)
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