STATEMENT documents

From Wiki
Jump to: navigation, search

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


Document fields for STATEMENT

This is a guide only, and some fields may be client specific. Please contact Morning Data if the data is not as expected.

Please refer to the statement and document tags pages on this wiki for more information.

Version number f numbers checked for 74


PC.CSV fields for STATEMENT

F_Number Description Expected value Notes
f1 Company dataset ID
f2
f3 Macro to run in world 'state'
f4
f5
f6
f7
f8 Date
f9
f10
f11
f12
f13 Dummy or template T for template or blank if dummy
f14 Template name selected on screen
f15
f16 Client account :block2.account (iba.account)
f17
f18 Currrency in full currency.description (for iba.scur if iba.amos_d is null otherwise iba.dcur)
f19 Username who.name for user
f20 WP folder path
f21 Email address of username who.email for user
f22 Telephone number of username who.telephone for user
f23
f24 Client name sec.name for client account (f16)
f25 Client address sec.address for client account (f16)
f26 This is used to set up f78
f27 IBAN no bank.iban where dcur = iba.dcur and def_cur = Y
f28 Bank account no bank.acc_number where dcur = iba.dcur and def_cur = Y
f29 Bank sort code bank.sort_code where dcur = iba.dcur and def_cur = Y(- between each pair of digits is added ie 99-99-99)
f30 Cut off date block1.cut_off_date (date of the last day in the current month, ie if todays date is 02-apr-21 then this would be 30-apr-21).
f31 Page count Initially set to 1 and incremented
f32 Opposite side block1.opp_side (sets to ALL)
f33 Original assured in risk block1.ass_code (sets to ALL)
f34 Gross
f35 IPT
f36 Commission
f37
f38
f39 Totals
f40 MS Word version who.wp_version, if not available default to 2000
f41 polnum &trannum
f42 Name and dates
f43 currency
f44 original amount
f45 outstanding amount
f46 Repeat of 41 for next transaction 41
f47 Repeat of 42 for next transaction 42
f48 Repeat of 43 for next transaction 43
f49 Repeat of 44 for next transaction 44
f50 Repeat of 45 for next transaction 45
f51 Repeat of 46 for next transaction 46
f52 Repeat of 47 for next transaction 47
f53 Repeat of 48 for next transaction 48
f54 Repeat of 49 for next transaction 49
f55 Repeat of 50 for next transaction 50
f56 Repeat of 51 for next transaction 51
f57 Repeat of 52 for next transaction 52
f58 Repeat of 53 for next transaction 53
f59 Repeat of 54 for next transaction 54
f60 Repeat of 55 for next transaction 55
f61 Repeat of 56 for next transaction 56
f62 Repeat of 57 for next transaction 57
f63 Repeat of 58 for next transaction 58
f64 Repeat of 59 for next transaction 59
f65 Repeat of 60 for next transaction 60
f66 Repeat of 61 for next transaction 61
f67 Repeat of 62 for next transaction 62
f68 Repeat of 63 for next transaction 63
f69 Repeat of 64 for next transaction 64
f70 Repeat of 65 for next transaction 65
f71 Repeat of 66 for next transaction 66
f72 Repeat of 67 for next transaction 67
f73 Repeat of 68 for next transaction 68
f74 Repeat of 69 for next transaction 69
f75 Repeat of 70 for next transaction 70
f76 Balance due to' or 'balance due from' if last transaction 71
f77 Balance amount if last transaction 72
f78 Client specific registered/trading info 73
f79 - 74
f80 Client specific registered/trading info 75


Version History

v4.2.0 – Updated to the latest version
v4.2.0 – Updated to the latest version