DEBIT documents

From Wiki
Jump to: navigation, search

See the NOVUS Walkthrough Guide for general information about the system.


Document fields for DEBIT

The debit and document tags pages on this wiki will provide more information


This is intended to be a guide only, as some fields, or the format of fields may be client or risk details specific. Please contact Morning Data if the data is not as expected.

Version number f numbers checked for: vers 108

There are two ways of adding fields into a debit document dummy or template. The first is as with all documentation, using f numbers produced in the pc.csv file. The second is using xml tags that will be merged with the document when it is produced. A dummy or template can use f numbers and xml fields.


PC.CSV fields for DEBIT

F_Number Expected value Notes
f1 Company dataset ID
f2 Policy number
f3 Macro to run in Word 'DebitCreditNote'
f4 Dummy document being used (i.e. DS Direct Single Section, DM Direct Multi-Section, RS Reinsurance Single Section, RM Reinsurance Multi-Section if PNL & f10='GU' then f4 'GU',

if single insurer and ri_flag in ('Y','O') then 'RS' else 'DS' if multi-insurer and ri_flag in ('Y','O') then 'RM' else 'DM'

f5 Currency iba_ttl.scur
f6 Description If iba_ttl.end_no

otherwise descstri (block2.aorig converted to words ie one pound and fifty pence).

f7 Transaction number
f8 System date in long format
f9 Division code risk_head.div_code
f10 Policy type risk_head.poltype
f11 Policy year risk_head.year
f12 Year year (2 digits)last 2 digits of block1.year (risk_head.year)
f13 Option flag C(reate) or E(dit) depending on whether the debit note has previously been created.
f14 Department code risk_head.dept_code
f15 Your share if block2.your_share (100 * block2.s_line (market_c.s_line) / block1.order_percent (iba_ttl.order_percent)) not = 100 then '(*) Your Share ' block2.your_share '% figures'.
f16 Details 'DETAILS:'
f17 User name who.name for user
f18 No of sections cli_no
f19 Original amount block2.dbf (sign of the total of aorig - negative is -1, positive is 1).
f20 WP folder path
f21 Fax number
f22 Co reference if block4.client_selection = 1 (this defaults as 1 and doesn't appear to change) block2.wq_reference (this field does not appear to be populated). If null then block1.co_ref ('CLAIMANT' if block2.ac_ref_sc = 'CLAIMANT' otherwise market.co_ref).
f23 "Details:" If block1.tran_details (risk.limit_desc) has a value then 'Details:'
f24 Insured if block4.client_selection = 1 ( this defaults as 1 and doesn't appear to change) block2.wq_name (if iba.account = 'CLIENT' then proposer.name otherwise sec.name) otherwise block7.wq_name (sec.name where sec = risk_head.ass_code)..
f25 Address if block4.client_selection = 1 ( this defaults as 1 and doesn't appear to change) block2.wq_address (if iba.account = 'CLIENT' then proposer.address otherwise sec.address) otherwise block7.wq_address (sec.address where sec = risk_head.ass_code).
f26 Email who.email for user
f27 Fax number who.fax for user
f28 Telephone number who.telephone for user
f29 Division divisions.description for div_code
f30 Insurer If single section transaction then blank

otherwise record_a - risk.section_title record_b - iba_ttl.gross * block2.dbf / block1.rox_conv record_order - iba_ttl.order_percent gross_num - iba_ttl.gross * block2.dbf / block1.rox_conv section_aorig - total of iba_ttl.aorig * block2.dbf / block1.rox_conv block1.scur - iba_ttl.dcur block2.dbf - sign of the total of aorig, negative is -1, positive is 1 block1.rox_conv - if use converted field on the screen is N, then this defaults to 1, however, the calculation that sets this otherwise looks incorrect and will end up with null, therefore, rendering any calculation using this as null as well.

f31 If single section transaction then blank

otherwise record_a - risk.section_title record_b - iba_ttl.gross * block2.dbf / block1.rox_conv record_order - iba_ttl.order_percent gross_num - iba_ttl.gross * block2.dbf / block1.rox_conv section_aorig - total of iba_ttl.aorig * block2.dbf / block1.rox_conv block1.scur - iba_ttl.dcur block2.dbf - sign of the total of aorig, negative is -1, positive is 1 block1.rox_conv - if use converted field on the screen is N, then this defaults to 1, however, the calculation that sets this otherwise looks incorrect and will end up with null, therefore, rendering any calculation using this as null as well.

f32 If single section transaction then blank

otherwise record_a - risk.section_title record_b - iba_ttl.gross * block2.dbf / block1.rox_conv record_order - iba_ttl.order_percent gross_num - iba_ttl.gross * block2.dbf / block1.rox_conv section_aorig - total of iba_ttl.aorig * block2.dbf / block1.rox_conv block1.scur - iba_ttl.dcur block2.dbf - sign of the total of aorig, negative is -1, positive is 1 block1.rox_conv - if use converted field on the screen is N, then this defaults to 1, however, the calculation that sets this otherwise looks incorrect and will end up with null, therefore, rendering any calculation using this as null as well.

f33 record_a - risk.section_title

record_b - iba_ttl.gross * block2.dbf / block1.rox_conv record_order - iba_ttl.order_percent block1.scur gross_num * iba_ttl.order_percent/100 - section_aorig gross_num - iba_ttl.gross * block2.dbf / block1.rox_conv section_aorig - total of iba_ttl.aorig * block2.dbf / block1.rox_conv block1.scur - iba_ttl.dcur block2.dbf - sign of the total of aorig, negative is -1, positive is 1 block1.rox_conv - if use converted field on the screen is N, then this defaults to 1, however, the calculation that sets this otherwise looks incorrect and will end up with null, therefore, rendering any calculation using this as null as well.

f34 record_a - risk.section_title

record_b - iba_ttl.gross * block2.dbf / block1.rox_conv record_order - iba_ttl.order_percent gross_num - iba_ttl.gross * block2.dbf / block1.rox_conv section_aorig - total of iba_ttl.aorig * block2.dbf / block1.rox_conv block1.scur - iba_ttl.dcur block2.dbf - sign of the total of aorig, negative is -1, positive is 1 block1.rox_conv - if use converted field on the screen is N, then this defaults to 1, however, the calculation that sets this otherwise looks incorrect and will end up with null, therefore, rendering any calculation using this as null as well.

f35 Salutation sec.salutation (for account)
f36 Risk Details If single section transaction then record_a (codes.description risk_details.si amalgamated for up to the first five risk_details) otherwise blank for multi sections.
f37 If single section transaction then record_a (codes.description risk_details.si amalgamated for risk_details 6 - 12) otherwise blank for multi sections.
f38 Period to Date block7.tdate (risk_head.tdate)
f39 Original assured block2.sc_account (iba.account, if this is = 'CLIENT' then 'PROPOSER').
f40 2000 Not set.
f41 record_a - risk.section_title

record_b - iba_ttl.gross * block2.dbf / block1.rox_conv record_order - iba_ttl.order_percent gross_num - iba_ttl.gross * block2.dbf / block1.rox_conv section_aorig - total of iba_ttl.aorig * block2.dbf / block1.rox_conv block1.scur - iba_ttl.dcur block2.dbf - sign of the total of aorig, negative is -1, positive is 1 block1.rox_conv - if use converted field on the screen is N, then this defaults to 1, however, the calculation that sets this otherwise looks incorrect and will end up with null, therefore, rendering any calculation using this as null as well.

f42 record_a - risk.section_title

record_b - iba_ttl.gross * block2.dbf / block1.rox_conv record_order - iba_ttl.order_percent gross_num - iba_ttl.gross * block2.dbf / block1.rox_conv section_aorig - total of iba_ttl.aorig * block2.dbf / block1.rox_conv block1.scur - iba_ttl.dcur block2.dbf - sign of the total of aorig, negative is -1, positive is 1 block1.rox_conv - if use converted field on the screen is N, then this defaults to 1, however, the calculation that sets this otherwise looks incorrect and will end up with null, therefore, rendering any calculation using this as null as well.

f43 "Period:" Period:
f44 Period risk_head.period
f45 "DEBIT" or "CREDIT" if block1.dbf = 1 then 'DEBIT' otherwise 'CREDIT'.
f46 "Insured:" if block7.ri_flag (risk_head.ri_flag) = 'N' or 'I' then 'Insured :' block7.assured (risk_head.assured).
f47 Risk description if block7.ri_flag (risk_head.ri_flag) = 'N' or 'I' and sys_code = 'H' then 'Risk Description:' other sys_code values 'Risk Address'
f48 block1.details (risk_head.details)
f49 Limit description If block1.tran_details (risk.limit_desc) has a value then block1.tran_details.
f50 "Section:"
f51 "Type" if block7.type (risk_head.type) has a value then 'Type:',
f52 Insured or assured If block7.assured (risk_head.assured) has a value then 'Insured:'
f53 Period: or effective If block7.fdate (risk_head.fdate) has a value then 'Period:'
f54 Limits: If single section transaction and f64 has a value then 'Limits:'.
f55 Reinsured:, reassured or insured if block7.insured (risk_head.insured) has a value then

if block7.ri_flag (risk_head.ri_flag) = 'N' or 'I' then 'Insured:' otherwise 'Reinsured:'.

f56 Transaction: or details: If block1.tran_details (risk.limit_desc) has a value then 'Transaction:'.
f57 Bank details if block2.dbf = 1 (positive amount) then bank.address where dcur = block1.dcur
f58 'Acc No:' bank.acc_number 'Sort Code:' or 'CHAPS Code:' depending on bank.sw_ch bank.sort_code 'SWIFT Code:' bank.swift_code.
f59 Claims department block1.effective_date.
f60 Section_title block7.section_title (risk.section_title).
f61 Policy type description risk_head.type
f62 Assured block7.assured (risk_head.assured).
f63 Policy period block7.fdate (risk_head.fdate) ' to ' block7.tdate (risk_head.tdate) - formatting of dates varies per company.
f64 Minimum & deposit premium: iba_ttl.details
f65 Insured block7.insured (risk_head.insured).
f66 Description block1.description (codes.description with a gid = 2 and code = iba_ttl.trantype).
f67 block1.iba_tt_details (iba_ttl.details).
f68 Claim number concatenate first 5 instalment dates uw_pbdate (iba.pbdate + block1.terms_tot (iba_ttle.tot) + uw_pbdate_adjust
f69 User
f70 Currency if single section then block1.cur_desc (currency.description). if mulitple sections then block1.cur_desc (currency.description) '100% Amount' block1.ast ('(*)' if block2.your_share not = 100) 'Order' 'Deductions' 'Net'.
f71 Estimated GWP, 100% amount f single section transaction

if block2.net_or_gross = N (market_head.net_or_gross) if block1.gross_premium (iba_ttl.gross_premium) * block2.your_share (100 * block2.s_line (market_c.s_line) / block1.order_percent (iba_ttl.order_percent)) has a value then 'Gross Premium ' f5 (currency) gross_premium_sum (total of block1.gross_premium for all sections of the transaction) otherwise '100% Amount' block1.ast ( '(*)' ) gross_premium_sum (total of block1.gross_premium for all sections of the transaction).

if block2.net_or_gross not = N if block1.gross (total of iba_ttl.gross) * block2.your_share has a value and block7.ri_flag = N or I and block2.dbf = 1 then

if block2.net_or_gross not = N if block1.gross (total of iba_ttl.gross) * block2.your_share has a value and block7.ri_flag = N or I and block2.dbf not = 1 then 'Net Credit' block1.gross.

if block2.net_or_gross not = N if block1.gross (total of iba_ttl.gross) * block2.your_share does not hava a value '100% Amount' block1.ast block1.gross.

f72 Order percentage %, amount if single section transaction

if block1.order_percent not = 100 then block2.ord 0.01 * block2.order_amount * block2.your_share record_d.

Regardless of order percent block2.ord - 'Order' market_c.s_line ' %' block2.ord_alt - market_c.s_line ' %' block2.order_amount - 0.01 * :block1.order_percent * block1.gross block2.your_share - (100 * block2.s_line / block1.order_percent) record_d - sec.sname block1.order_percent -(iba_ttl.order_percent block2.s_line - market_c.s_line

if multi-section transaction if block1.order_percent not = 100 then block2.ord 0.01 * block2.order_amount * block2.your_share record_d.

f73 if single section transaction

if block2.net_or_gross = N (market_head.net_or_gross) then 'Net Premium f5 (currency) block1.gross

f74 Deductions, commission if single section transaction

if block2.net_or_gross = N (market_head.net_or_gross) then 'Less commission' f5 block1.precedence_cl_comm (total of precedence_taxes.amount for transaction/section and tax_code = '*'. if block2.net_or_gross not = N and absolute value of block2.deductions > 0.01 'Deductions ' block1.deductions_pc ' %' block2.deductions. block2.deductions - (0.01 * block2.your_share * block2.order_amount) - block2.aorig_pre_tax. block1.deductions_pc - 10000 * block2.deductions / (block2.your_share * block2.order_amount) block2.your_share - (100 * block2.s_line / block1.order_percent) block2.s_line - market_c.s_line block1.scur - iba_ttl.scur block1.order_percent - iba_ttl.order_percent block2.order_amount - 0.01 * :block1.order_percent * block1.gross block2.aorig_pre_tax - total of iba.aorig / block1.rox_conv for the trannum/account/suff and the iba.tax_code is null. block1.rox_conv - see notes on this field in f30.

f75 IPT concatenate for all appropriate iba records for the transaction/account/reference and where the tax_code has a value :

record_a_alt record_b.

record_a - iba.tax_description record_a_alt - i.tax_description record_b - total of block2.dbf * iba.aorig / iba.rox_conv (or 1 if block1.use_converted not = Y)

block1.scur - iba_ttl.scur default_rate - fees.default_rate block2.dbf - sign of the total of aorig - negative is -1, positive is 1 block1.use_converted - on the screen

f76 Net amount due from, amount due, total amount due, net credit if block2.dbf = 1

Amount Due' block2.aorig

if block2.dbf not = 1 'Net Credit' block2.aorig.

block2.aorig - total of iba.aorig / block1.rox_conv * block2.dbf for the trannum/account/suff and the iba.tax_code is null. block1.scur - iba_ttl.scur

f77 "Payable" Default is 'Payable: '.
f78 Dependant on client, instalment , amount, etc Amalgamate upto first 5 instalments as follows :

iba.pbdate record_b for all instalments. record_b - total of block2.dbf * iba.aorig / iba.rox_conv (or 1 if block1.use_converted not = Y).

f79 Dependant on client Amalgamate instalments 6 - 11 as follows :

iba.pbdate record_b for all instalments.

f80 if block4.client_selection not = '1' (this defaults as 1 and doesn't appear to change!) then 'FOR INFORMATION ONLY'.

Version History

v4.2.0 – Updated to the latest version