SQL-022: Insert financialtransaction collection¶
Insert financialtransaction collection in the context of clsFinancialTransactionCollection.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-022 |
| Operation type | Insert |
| Execution method | NonQuery |
| Database | Oracle |
| Command type | Text |
| Schema | [unqualified] |
| Business object | clsFinancialTransactionCollection |
| Criteria property | InsertSQL |
| Lifecycle method | BeforeInsert / AfterInsert |
Parameters¶
| Parameter | Direction | Type | Max length | Description |
|---|---|---|---|---|
:PolicyTransSeqNum |
Input | Numeric* | inferred/unknown | Bind variable in clsFinancialTransactionCollection.InsertSQL. |
:PolicyNumber |
Input | Numeric* | inferred/unknown | Bind variable in clsFinancialTransactionCollection.InsertSQL. |
:PolicyPeriodEffectiveDate |
Input | Date | inferred/unknown | Bind variable in clsFinancialTransactionCollection.InsertSQL. |
:BatchNum |
Input | Numeric* | inferred/unknown | Bind variable in clsFinancialTransactionCollection.InsertSQL. |
:BatchDate |
Input | Date | inferred/unknown | Bind variable in clsFinancialTransactionCollection.InsertSQL. |
:CheckNum |
Input | Numeric* | inferred/unknown | Bind variable in clsFinancialTransactionCollection.InsertSQL. |
:InvoiceNum |
Input | Numeric* | inferred/unknown | Bind variable in clsFinancialTransactionCollection.InsertSQL. |
:TransAmt |
Input | Numeric* | inferred/unknown | Bind variable in clsFinancialTransactionCollection.InsertSQL. |
:InvoiceDate |
Input | Date | inferred/unknown | Bind variable in clsFinancialTransactionCollection.InsertSQL. |
:TransDate |
Input | Date | inferred/unknown | Bind variable in clsFinancialTransactionCollection.InsertSQL. |
:TransStatusCode |
Input | String* | inferred/unknown | Bind variable in clsFinancialTransactionCollection.InsertSQL. |
:TransTypeCode |
Input | String* | inferred/unknown | Bind variable in clsFinancialTransactionCollection.InsertSQL. |
:AmountPaid |
Input | Numeric* | inferred/unknown | Bind variable in clsFinancialTransactionCollection.InsertSQL. |
:PremHistSetID |
Input | Numeric* | inferred/unknown | Bind variable in clsFinancialTransactionCollection.InsertSQL. |
:CreateDate |
Input | Date | inferred/unknown | Bind variable in clsFinancialTransactionCollection.InsertSQL. |
:CreateUser |
Input | String* | inferred/unknown | Bind variable in clsFinancialTransactionCollection.InsertSQL. |
:UpdateDate |
Input | Date | inferred/unknown | Bind variable in clsFinancialTransactionCollection.InsertSQL. |
:UpdateUser |
Input | Date | inferred/unknown | Bind variable in clsFinancialTransactionCollection.InsertSQL. |
:WarrantNum |
Input | Numeric* | inferred/unknown | Bind variable in clsFinancialTransactionCollection.InsertSQL. |
:ApplyTOInvoiceNum |
Input | Numeric* | inferred/unknown | Bind variable in clsFinancialTransactionCollection.InsertSQL. |
:GLInterfaceControlNum |
Input | Numeric* | inferred/unknown | Bind variable in clsFinancialTransactionCollection.InsertSQL. |
:BillingDetailSeqNum |
Input | Numeric* | inferred/unknown | Bind variable in clsFinancialTransactionCollection.InsertSQL. |
:DcbTrackingSeqNum |
Input | Numeric* | inferred/unknown | Bind variable in clsFinancialTransactionCollection.InsertSQL. |
:CommPremAmt |
Input | Numeric* | inferred/unknown | Bind variable in clsFinancialTransactionCollection.InsertSQL. |
:PayrollSeqNum |
Input | Numeric* | inferred/unknown | Bind variable in clsFinancialTransactionCollection.InsertSQL. |
:DueDate |
Input | Date | inferred/unknown | Bind variable in clsFinancialTransactionCollection.InsertSQL. |
:PolRelPolicyNum |
Input | Numeric* | inferred/unknown | Bind variable in clsFinancialTransactionCollection.InsertSQL. |
:PolRelPolicyPeriodEffDate |
Input | Date | inferred/unknown | Bind variable in clsFinancialTransactionCollection.InsertSQL. |
:InvoiceDisplayFlag |
Input | String (Y/N)* | inferred/unknown | Bind variable in clsFinancialTransactionCollection.InsertSQL. |
:ArpPremAmt |
Input | Numeric* | inferred/unknown | Bind variable in clsFinancialTransactionCollection.InsertSQL. |
:GLTransTypeCode |
Input | String* | inferred/unknown | Bind variable in clsFinancialTransactionCollection.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 (
:PolicyTransSeqNum,
:PolicyNumber,
:PolicyPeriodEffectiveDate,
:BatchNum,
:BatchDate,
:CheckNum,
:InvoiceNum,
:TransAmt,
:InvoiceDate,
:TransDate,
:TransStatusCode,
:TransTypeCode,
:AmountPaid,
:PremHistSetID,
:CreateDate,
:CreateUser,
:UpdateDate,
:UpdateUser,
:WarrantNum,
:ApplyTOInvoiceNum,
:GLInterfaceControlNum,
:BillingDetailSeqNum,
:DcbTrackingSeqNum,
:CommPremAmt,
:PayrollSeqNum,
:DueDate,
:PolRelPolicyNum,
:PolRelPolicyPeriodEffDate,
:InvoiceDisplayFlag,
:ArpPremAmt,
:GLTransTypeCode
)
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