Name,Description,FieldType,Length,FieldState,DecimalPlaces
ACCOUNT_MANAGER,"Name of Account Manager",12,60,0,0
ACCOUNT_ON_HOLD,"Account On Hold",-6,1,0,0
ACCOUNT_OPENED,"Date Account Opened",9,2,0,0
ACCOUNT_REF,"Account Reference",12,8,1,0
ACCOUNT_STATUS,"Account Status",5,2,0,0
ACCOUNT_TYPE,"Account Type",5,2,0,0
ADDRESS_1,"Registered Address Line1",12,60,0,0
ADDRESS_2,"Registered Address Line2",12,60,0,0
ADDRESS_3,"Registered Address Line3",12,60,0,0
ADDRESS_4,"Registered Address Line4",12,60,0,0
ADDRESS_5,"Registered Address Line5",12,60,0,0
ANALYSIS_1,"Analysis 1",12,30,0,0
ANALYSIS_2,"Analysis 2",12,30,0,0
ANALYSIS_3,"Analysis 3",12,30,0,0
ANALYSIS_4,"Analysis 4",12,30,0,0
ANALYSIS_5,"Analysis 5",12,30,0,0
ANALYSIS_6,"Analysis 6",12,30,0,0
BACS,"Bank Online Payments",5,2,0,0
BACS_REFERENCE,"Bank BACS Ref",12,60,0,0
BALANCE,"Balance",8,8,0,2
BANK_ACCOUNT_NAME,"Bank Account Name",12,60,0,0
BANK_ACCOUNT_NUMBER,"Bank Account Number",12,60,0,0
BANK_ADDITIONAL_REF1,"Bank Additional Ref1",12,60,0,0
BANK_ADDITIONAL_REF2,"Bank Additional Ref2",12,60,0,0
BANK_ADDITIONAL_REF3,"Bank Additional Ref3",12,60,0,0
BANK_ADDRESS_1,"Bank Address Line1",12,60,0,0
BANK_ADDRESS_2,"Bank Address Line2",12,60,0,0
BANK_ADDRESS_3,"Bank Address Line3",12,60,0,0
BANK_ADDRESS_4,"Bank Address Line4",12,60,0,0
BANK_ADDRESS_5,"Bank Address Line5",12,60,0,0
BANK_BICSWIFT,"Bank BIC/Swift",12,60,0,0
BANK_IBAN,"Bank IBAN",12,60,0,0
BANK_NAME,"Bank Name",12,60,0,0
BANK_ROLL_NUMBER,"Bank Roll Number",12,60,0,0
BANK_SORT_CODE,"Bank Sort Code",12,10,0,0
BUILD_SOCIETY_REF,"Refernce for Building Society Transfer",12,60,0,0
BUILDING_SOCIETY,"Account Uses Building Society",5,2,0,0
CAN_APPLY_CHARGES,"Can Charge Credit",5,2,0,0
COMPANY_REGISTRATION_NUMBER,"Company Reg. Number",12,16,0,0
CONTACT_NAME,"Contact Name",12,30,0,0
COUNTRY_CODE,"Country Code",12,2,0,0
CREDIT_APP_RECEIVED,"True if Credit Application Received",5,2,0,0
CREDIT_APPLIED_FOR,"Date Credit Applied For",9,2,0,0
CREDIT_BF,"Credits Brought Forward",8,8,0,2
CREDIT_BUREAU,"Credit Bureau Used",5,2,0,0
CREDIT_CARD_NO,"Credit card number",12,30,0,0
CREDIT_CF,"Credits Carry Forward",8,8,0,2
CREDIT_LIMIT,"Credit Limit",8,8,0,2
CREDIT_MTH1,"Credits Month 1",8,8,0,2
CREDIT_MTH10,"Credits Month 10",8,8,0,2
CREDIT_MTH11,"Credits Month 11",8,8,0,2
CREDIT_MTH12,"Credits Month 12",8,8,0,2
CREDIT_MTH2,"Credits Month 2",8,8,0,2
CREDIT_MTH3,"Credits Month 3",8,8,0,2
CREDIT_MTH4,"Credits Month 4",8,8,0,2
CREDIT_MTH5,"Credits Month 5",8,8,0,2
CREDIT_MTH6,"Credits Month 6",8,8,0,2
CREDIT_MTH7,"Credits Month 7",8,8,0,2
CREDIT_MTH8,"Credits Month 8",8,8,0,2
CREDIT_MTH9,"Credits Month 9",8,8,0,2
CREDIT_POSITION,"Credit Position",5,2,0,0
CREDIT_REFERENCE,"Credit Bureau Reference",12,60,0,0
CURRENCY,"Currency",-6,1,0,0
DATE_CREDIT_APP_RECEIVED,"Date Credit Application Received",9,2,0,0
DECLARATION_VALID_FROM,"Donor Declaration Valid From",9,2,0,0
DEF_NOM_CODE,"Default Nominal Code",12,8,0,0
DEF_TAX_CODE,"Tax Code",5,2,0,0
DEL_ADDRESS_1,"Default Delivery Address Line1",12,60,0,0
DEL_ADDRESS_2,"Default Delivery Address Line2",12,60,0,0
DEL_ADDRESS_3,"Default Delivery Address Line3",12,60,0,0
DEL_ADDRESS_4,"Default Delivery Address Line4",12,60,0,0
DEL_ADDRESS_5,"Default Delivery Address Line5",12,60,0,0
DEL_CONTACT_NAME,"Default Delivery Contact Name",12,30,0,0
DEL_FAX,"Default Delivery Fax Number",12,30,0,0
DEL_NAME,"Default Delivery Name",12,60,0,0
DEL_TELEPHONE,"Default Delivery Telephone Number",12,30,0,0
DELETED_FLAG,"Reserved for Future Use",5,2,0,0
DEPT_NUMBER,"Department Code",5,2,0,0
DISCOUNT_RATE,"Discount Rate",8,8,0,2
DISCOUNT_TYPE,"Discount Type",-6,1,0,0
DISPUTED,"Disputed",4,4,0,0
DONOR_FORENAME,"Donor Forename",12,35,0,0
DONOR_SURNAME,"Donor Surname",12,35,0,0
DONOR_TITLE,"Donor Title",12,4,0,0
DUNS_NUMBER,"DUNS Number",12,9,0,0
E_MAIL,"E-Mail Address",12,255,0,0
E_MAIL2,"E-Mail Address (2)",12,255,0,0
E_MAIL3,"E-Mail Address (3)",12,255,0,0
E_MAIL4,"E-Mail Address (4)",12,255,0,0
E_MAIL5,"E-Mail Address (5)",12,255,0,0
E_MAIL6,"E-Mail Address (6)",12,255,0,0
EC_CODE,"EC member code",12,3,0,0
EORI_NUMBER,"EORI number",12,17,0,0
EXTERNAL_USAGE,"Number of External Usages for This Record",4,4,0,0
FACEBOOK,"Facebook Address",12,75,0,0
FAX,"Fax Number",12,30,0,0
FIRST_HEADER,"First transaction",4,4,0,0
FIRST_INVOICE,"First Invoice Date",9,2,0,0
GIFT_AID_ENABLED,"Gift Aid is enabled",5,2,0,0
HOLD_MAIL,"Restrict Mail",5,2,0,0
INACTIVE_FLAG,"Inactive Flag - Yes/No",-6,1,0,0
INCOTERMS,"Incoterms",5,2,0,0
INVOICE_BF,"Invoices Brought Forward",8,8,0,2
INVOICE_CF,"Invoices Carry Forward",8,8,0,2
INVOICE_MTH1,"Invoices Month 1",8,8,0,2
INVOICE_MTH10,"Invoices Month 10",8,8,0,2
INVOICE_MTH11,"Invoices Month 11",8,8,0,2
INVOICE_MTH12,"Invoices Month 12",8,8,0,2
INVOICE_MTH2,"Invoices Month 2",8,8,0,2
INVOICE_MTH3,"Invoices Month 3",8,8,0,2
INVOICE_MTH4,"Invoices Month 4",8,8,0,2
INVOICE_MTH5,"Invoices Month 5",8,8,0,2
INVOICE_MTH6,"Invoices Month 6",8,8,0,2
INVOICE_MTH7,"Invoices Month 7",8,8,0,2
INVOICE_MTH8,"Invoices Month 8",8,8,0,2
INVOICE_MTH9,"Invoices Month 9",8,8,0,2
LAST_CREDIT_REV,"Date Last Credit Review",9,2,0,0
LAST_HEADER,"Last transaction",4,4,0,0
LAST_INV_DATE,"Last Invoice Date",9,2,0,0
LAST_PAY_DATE,"Last Payment Date",9,2,0,0
LAST_UPDATED,"Date of last update",11,8,0,0
LINKEDIN,"LinkedIn Address",12,64,0,0
MANDATEREF,"Direct Debit Mandate Ref",12,25,0,0
MEMBER_REMINDER_DATE,"Member Reminder Date",4,2,0,0
MEMBER_RENEWAL_DATE,"Member Renewal Date",9,2,0,0
MEMBER_SINCE,"Member Since",9,2,0,0
MEMO_OFFSET,"Offset in Credit Memo File",4,4,0,0
MEMO_SIZE,"Size of Memo in Bytes",4,4,0,0
MODIFY,"Modified Count",4,4,0,0
NAME,"Account Name",12,60,0,0
NEXT_CREDIT_REV,"Date Next Credit Review",9,2,0,0
NO_OF_HEADER,"No of trans",4,4,0,0
OVERRIDE_PRODUCT_NOMINAL,"Override product nominal code in invoicing and pop",-6,1,0,0
OVERRIDE_PRODUCT_TAX,"Override product tax code in invoicing",-6,1,0,0
PAYMENT_BF,"Payments Brought Forward",8,8,0,2
PAYMENT_CF,"Payments Carry Forward",8,8,0,2
PAYMENT_DUE_DAYS,"Payment Due Days",5,2,0,0
PAYMENT_DUE_FROM,"Payment Due From",5,2,0,0
PAYMENT_MTH1,"Payments Month 1",8,8,0,2
PAYMENT_MTH10,"Payments Month 10",8,8,0,2
PAYMENT_MTH11,"Payments Month 11",8,8,0,2
PAYMENT_MTH12,"Payments Month 12",8,8,0,2
PAYMENT_MTH2,"Payments Month 2",8,8,0,2
PAYMENT_MTH3,"Payments Month 3",8,8,0,2
PAYMENT_MTH4,"Payments Month 4",8,8,0,2
PAYMENT_MTH5,"Payments Month 5",8,8,0,2
PAYMENT_MTH6,"Payments Month 6",8,8,0,2
PAYMENT_MTH7,"Payments Month 7",8,8,0,2
PAYMENT_MTH8,"Payments Month 8",8,8,0,2
PAYMENT_MTH9,"Payments Month 9",8,8,0,2
PAYMENT_TYPE,"Payment Method",4,4,0,0
PRICE_LIST_REF,"Price list reference",12,8,0,0
PRIOR_YEAR,"Prior YTD",8,8,0,2
PRIORITY_TRADER,"Priority Supplier",5,2,0,0
RECEIPT_BF,"Receipts Brought Forward",8,8,0,2
RECEIPT_CF,"Receipts Carry Forward",8,8,0,2
RECEIPT_MTH1,"Receipts Month 1",8,8,0,2
RECEIPT_MTH10,"Receipts Month 10",8,8,0,2
RECEIPT_MTH11,"Receipts Month 11",8,8,0,2
RECEIPT_MTH12,"Receipts Month 12",8,8,0,2
RECEIPT_MTH2,"Receipts Month 2",8,8,0,2
RECEIPT_MTH3,"Receipts Month 3",8,8,0,2
RECEIPT_MTH4,"Receipts Month 4",8,8,0,2
RECEIPT_MTH5,"Receipts Month 5",8,8,0,2
RECEIPT_MTH6,"Receipts Month 6",8,8,0,2
RECEIPT_MTH7,"Receipts Month 7",8,8,0,2
RECEIPT_MTH8,"Receipts Month 8",8,8,0,2
RECEIPT_MTH9,"Receipts Month 9",8,8,0,2
RECORD_CREATE_DATE,"Date and time when the record was created",11,8,0,0
RECORD_DELETED,"Flag denoting if the record has been deleted or not.",5,2,0,0
RECORD_MODIFY_DATE,"Date and time when the record was modified",11,8,0,0
SALES_REP,"Name of Sales Representative",12,60,0,0
SEND_INVOICES_ELECTRONICALLY,"Send Invoices to this account via Email",5,2,0,0
SEND_LETTERS_ELECTRONICALLY,"Send letters to this account via Email",5,2,0,0
SETTLEMENT_DISC_RATE,"Settlement Discount Rate",8,8,0,2
SETTLEMENT_DUE_DAYS,"Settlement Due Days",5,2,0,0
TELEPHONE,"Telephone Number",12,30,0,0
TELEPHONE_2,"Second Telephone Number",12,30,0,0
TERMS,"Terms",12,30,0,0
TERMS_AGREED_FLAG,"Terms agreed flag",5,2,0,0
TRADE_CONTACT,"Name of Trade Contact",12,30,0,0
TRADER_FOREIGN_BALANCE,"Foreign Balance",8,8,0,6
TURNOVER_MTD,"Turnover Month To Date",8,8,0,2
TURNOVER_YTD,"Turnover Year To Date",8,8,0,2
TWITTER,"Twitter Address",12,35,0,0
VAT_REG_NUMBER,"VAT Registration Number",12,20,0,0
WWW,"WWW Address",12,255,0,0