struct_name = 'TBatchCURec'
struct_desc = 'Customer/Supplier Record'
struct_def = [
# (name, array_size, pascal_type, qty, excluded, comment)
('cust_code', 0, 'String', 6, False, 'Customer code, must not be blank'),
('cust_supp', 0, 'Char', 1, False, 'Must be C or S'),
('company', 0, 'String', 45, False, 'Company Name'),
('area_code', 0, 'String', 4, False, 'Free Type Sort Field'),
('rep_code', 0, 'String', 4, False, 'Free Type Sort Field'),
('remit_code', 0, 'String', 10, False, 'Account Code of Remit Account'),
('vat_reg_no', 0, 'String', 30, False, 'VAT Registration No.'),
('addr', 5, 'String', 30, False, 'Address 1-5'),
('pad_char5', 0, 'Char', 1, True, ''),
('desp_addr', 0, 'WordBool', 1, False, 'Despatch Address'),
('d_addr', 5, 'String', 30, False, 'Despatch Address 1-5'),
('contact', 0, 'String', 25, False, 'Contact Name'),
('phone', 0, 'String', 30, False, 'Phone No.'),
('fax', 0, 'String', 30, False, 'Fax No.'),
('ref_no', 0, 'String', 10, False, 'Our Code with them'),
('trad_term', 0, 'WordBool', 1, False, 'Special Terms'),
('s_terms', 2, 'String', 60, False, '2 Lines of Terms'),
('currency', 0, 'SmallInt', 1, False, ''),
('vat_code', 0, 'Char', 1, False, ''),
('pad_char1', 0, 'Char', 1, True, 'Padding Char for Word Alignment'),
('pay_terms', 0, 'SmallInt', 1, False, 'Number of days, 0-30, 999...'),
('credit_limit', 0, 'Double', 1, False, ''),
('discount', 0, 'Double', 1, False, ''),
('credit_status', 0, 'SmallInt', 1, False, ''),
('cust_cc', 0, 'String', 3, False, ''),
('c_disc_ch', 0, 'Char', 1, False, ''),
('cust_dep', 0, 'String', 3, False, ''),
('pad_char2', 0, 'Char', 1, True, 'Padding Char for Word Alignment'),
('eec_member', 0, 'WordBool', 1, False, 'VAT Inclusion for EE'),
('inc_stat', 0, 'WordBool', 1, False, 'Include in Statement'),
('def_nom_code', 0, 'LongInt', 1, False, 'DefNomCode'),
('def_m_loc_stk', 0, 'String', 3, False, 'Default Multi Loc Stock'),
('acc_status', 0, 'SmallInt', 1, False, 'On Hold, Closed, See notes'),
('pay_type', 0, 'Char', 1, False, '[B]acs,[C]ash'),
('bank_sort', 0, 'String', 15, False, 'Bank Sort Code'),
('bank_acc', 0, 'String', 20, False, 'Bank Account No.'),
('bank_ref', 0, 'String', 28, False, 'Bank additional ref, ie Build Soc.Acc'),
('last_used', 0, 'String', 8, False, 'ReadOnly - Date last updated'),
# {Added on 7.1.97}
('phone2', 0, 'String', 30, False, 'Second Phone No.'),
('user_def1', 0, 'String', 20, False, 'User Definable string1'),
('user_def2', 0, 'String', 20, False, 'User Definable string2'),
('sop_inv_code', 0, 'String', 6, False, 'Ent SOP Invoice Code'),
('pad_char3', 2, 'Char', 1, True, 'Padding Char for Word Alignment'),
('sop_auto_w_off', 0, 'WordBool', 1, False, 'Auto write off Sales Order'),
('pad_char6', 2, 'Char', 1, True, ''),
('b_ord_val', 0, 'Double', 1, False, 'Book order value'),
# {* Added on 23/07/97 *}
('def_cos_nom', 0, 'LongInt', 1, False, 'Cost of Sales Nominal Code'),
('def_ctrl_nom', 0, 'LongInt', 1, False, 'Default Control Nominal Code'),
# {* Added on 20.1.98 *}
('dir_deb', 0, 'SmallInt', 1, False, 'Current Direct Debit Mode'),
('ccd_s_date', 0, 'String', 8, False, 'Credit Card Start Date'),
('ccd_e_date', 0, 'String', 8, False, 'Credit Card End Date'),
('ccd_name', 0, 'String', 50, False, 'Name on Credit Card'),
('ccd_card_no', 0, 'String', 30, False, 'Credit Card No.'),
('ccd_sa_ref', 0, 'String', 4, False, 'Credit Card Switch Ref'),
#
('pad_char7', 0, 'Char', 1, True, ''),
# {* Added on 17.11.98 *}
('def_set_d_days', 0, 'SmallInt', 1, False, 'Default Sett.Discount Days'),
('pad_char4', 2, 'Char', 1, True, 'Padding Char for Word Alignment'),
('def_set_disc', 0, 'Double', 1, False, 'Default Sett.Discount %'),
('def_form_no', 0, 'SmallInt', 1, False, 'Default Form Set No., 0-99, default 0'),
#
# {*** New fields in ver 4.31 ***}
('stat_d_mode', 0, 'SmallInt', 1, False, 'Statement/Remittance delivery mode. 0=Printed, 1=Fax, 2=email'),
('email_addr', 0, 'String', 100, False, 'Email address for Statement/ Remittance'),
('pad_char', 0, 'Char', 1, True, ''),
('eml_snd_rdr', 0, 'WordBool', 1, False, 'On next email transmission, send reader & reset'),
('ebus_pwrd', 0, 'String', 20, False, 'ebusiness module web password'),
('post_code', 0, 'String', 20, False, 'Separate postcode ** Add index'),
('cust_code2', 0, 'String', 20, False, 'Alternative look up code, can be blank'),
('pad_char8', 0, 'Char', 1, True, ''),
('allow_web', 0, 'SmallInt', 1, False, 'Allow upload to Web'),
('eml_zip_atc', 0, 'WordBool', 1, False, 'Default Zip attachment'),
('user_def3', 0, 'String', 30, False, 'User Defined 3'),
('user_def4', 0, 'String', 30, False, 'User Defined 4'),
('time_change', 0, 'String', 6, False, 'ReadOnly - Time stamp for record Change'),
('ssd_del_terms', 0, 'String', 5, False, 'ReadOnly - Delivery Terms'),
('c_vat_inc_flg', 0, 'Char', 1, False, ''),
('ssd_mode_tr', 0, 'SmallInt', 1, False, ''),
('last_opo', 0, 'String', 10, False, ''),
('pad_char9', 0, 'Char', 1, True, ''),
('inv_d_mode', 0, 'SmallInt', 1, False, 'Invoice delivery mode'),
('eml_snd_html', 0, 'WordBool', 1, False, 'When sending XML, send HTML'),
('web_live_cat', 0, 'String', 20, False, 'Read Only - Web current catalogue entry'),
('web_prev_cat', 0, 'String', 20, False, 'Web previous catalogue entry'),
#
# {27.09.2000 }
('sop_cons_ho', 0, 'SmallInt', 1, False, 'Consolidate Committed Balance. 0 or 1 only'),
#
# {*** ------------------------------------------------------ ***}
#
('spare', 129, 'Char', 1, True, '131/129'),
('last_char', 0, 'Char', 1, True, 'Padding Char for Word Alignment'),
]
struct_size = 1432
Recent
