Skip to content

Instantly share code, notes, and snippets.

@rossjones
Last active September 14, 2016 11:38
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rossjones/ab798b6201127a788840b06b7559ce50 to your computer and use it in GitHub Desktop.
Save rossjones/ab798b6201127a788840b06b7559ce50 to your computer and use it in GitHub Desktop.
'#name?',
'.expense description',
'0',
'1 department family',
'2 entity',
'3 date',
'4 expense type',
'5 expense area',
'6 supplier',
'7 transaction no',
'8 amount',
'9 vat reg no',
'account',
'account code',
'account code description',
'account name',
'accounting year',
'accounting_date',
'activity description',
'additional narrative',
'additional sap narrative',
'admin,capital,programme',
'admin,programme or capital expenditure',
'allocation date',
'amount',
'amount (excluding vat)',
'amount (\x9c)',
'amount (\xa3)',
'amount (\xc2\xa3)',
'amount exc vat',
'amount in sterling',
'amount in sterling \xa3s',
'amount in sterling \xa3s (incl vat)',
'amount paid',
'amount published',
'amount \xa0in sterling \xa3s (inc. vat)',
'amount \xa3',
'amount \xa3 (excluding vat)',
"amount \xa3's",
"amount \xef\xbf\xbd's",
'amount(excluding vat)',
'analysis',
'ap amount',
'ap amount (?)',
'ap amount (\x9c)',
'ap amount (\xa3)',
'ap amount (\xef\xbf\xbd)',
'authority',
'batch ref',
'be_level_7',
'beneficiaryname',
'billed amount',
'body',
'body name',
'body,body name,clearance date,unique reference,amount,supplier name,supplier ref. no.,gl_code,department / expense area,expense type,expense code,extended description,account holder,merchant category',
'body,body name,date,transaction number,amount,supplier name,supplier id,expense area,expense type,expense code',
'body,body name,date,transaction number,amount,supplier name,supplier id,expense area,expense type,expense code,',
'bodyname',
'bvacop',
'campaign',
'cap / rev',
'capital\nrevenue',
'capitalorrevenue',
'category',
'cipfa sercop heading department type',
'cipfa sercop heading expense type',
'clear date',
'clear_ref',
'cleared date',
'client',
'company',
'component code',
'component number',
'contract',
'contract number',
'contract_number',
'cost centre',
'cost centre description',
'cost centre name',
'currency unit',
'd-u-n-s number',
'date',
'date of payment',
'date of payments',
'date paid',
'date settled',
'definition',
'dep',
'departament family',
'department',
'department entity',
'department family',
'department family (t)',
'department family(t)',
'department family(t);entity(t);pay date;expense type(t);expense area(t);supplier(t);transno;amount;vat registration number',
'department family,entity,date,expense type,expense area,supplier,transaction number,amount,vat registration number',
'department name',
'department of health',
'departmental family',
'departments',
'dept code',
'dept family',
'dept. family',
'descr',
'description',
'description ( please populate using the invoice description: please rememebr no acroynms, abbreviations or po numbers)',
'descritption',
'detailed expenses type',
'dfid',
'distribution cost centre',
'distribution line number',
'distribution_amount',
'document number',
'documentno',
'effective date',
'enitity',
'entitiy',
'entitly',
'entity',
'entity (t)',
'entity(t)',
'exp code',
'expediture',
'expenditure',
'expenditure description',
'expenditure type',
'expenditure_type',
'expenditurecode',
'expenese type',
'expense',
'expense area',
'expense area (t)',
'expense area - csv version',
'expense area code',
'expense area desc',
'expense area published',
'expense area(t)',
'expense category',
'expense code',
'expense description',
'expense description published for admin spend above \xa325,000 only',
'expense reason',
'expense type',
'expense type (t)',
'expense type - use on csv version',
'expense type code',
'expense type published',
'expense type(t)',
'expense types',
'expense_area',
'expense_area_1',
'expense_area_3',
'expense_type',
'expense_type_3',
'expense_type_6',
'expensecategory',
'expenses description',
'expenses area',
'expenses type',
'explanation',
'extended description',
'geopointlicencingurl',
'gl code',
'gl_code',
'grant?',
'gross',
'gross amount',
'group',
'home_credit',
'home_debit',
'input date',
'inv no',
'inv number',
'inv_num',
'invoice amount',
'invoice date',
'invoice description',
'invoice no',
'invoice num',
'invoice number',
'invoice number - delete',
'invoice paid date',
'invoice posting date',
'invoice ref.',
'invoice total',
'irrecoverable vat',
'item text',
'job code',
'job description',
'journal no.',
'ledger description',
'line amount',
'line description',
'mcc',
'merchant category',
'merchant category group',
'merchant name',
'micro-category',
'mix of nett & gross',
'month',
'nac description',
'nac_level_6',
'narrative',
'net amount',
'net vat',
'nett amount',
'newcldate',
'optems',
'org code desc',
'organisation',
'organisation code',
'organisation name',
'organisation primary business',
"organisation's primary business",
'organisationalunit',
'organisationlabel',
'organisationunit',
'organisationuri',
'original narrative',
'paid date',
'pay date',
'payment amount',
'payment date',
'payment number',
'paymentdate',
'period',
'periodnumber',
'pes category',
'po line description',
'po number',
'po text',
'post code',
'postal code',
'postcode',
'posting date',
'procalss',
'proclass',
'proclass description',
'procurement card?',
'prog / admin?',
'project',
'project code',
'project number',
'project type',
'project_code',
'pspes level 2',
'purchase invoice number',
'purchase item text',
'purchase order',
'purchasing item text',
'purpose',
'purpose of expenditure',
'purpose of grant',
'ref',
'reference',
'reference no',
'registration number',
'replaced sap narrative',
'reporting month',
'sap narrative',
'sbe',
'sector',
'service area',
'service area categorisation',
'service label',
'service provided',
'service supplied',
'sme',
'sme class',
'sme?',
'sole trader',
'sort',
'source',
'spending area',
'status',
'sub-category',
'subsource',
'sum of amount',
'sumofamount',
'supp id',
'suppler type',
'supplier',
'supplier (and location)',
'supplier (t)',
'supplier code',
'supplier id',
'supplier name',
'supplier name published',
'supplier number',
'supplier post code',
'supplier postcode',
'supplier site postcode',
'supplier tab final',
'supplier type',
'supplier vat registration number',
'supplier(t)',
'supplier_',
'supplier_obs_type',
'supplier_obs_type_1',
'supplier_postcode',
'supplier_type',
'supplieraccountnumber',
'suppliername',
'suppliers',
'system transaction number',
'tax code',
'text',
'time period for grant',
'total inv amount',
'tran_ref',
'tranaction number',
'trans no.',
'trans ref',
'trans type desc',
'transaction',
'transaction\nnumber',
'transaction \nnumber',
'transaction amount',
'transaction date',
'transaction description',
'transaction id',
'transaction no',
'transaction no.',
'transaction number',
'transaction reference',
'transaction_num',
'transaction_number',
'transactionno',
'transactionnumber',
'transactions number',
'transation description',
'transation number',
'transno',
'type',
'uri',
'vat',
'vat included',
'vat no',
'vat not recovered',
'vat reg',
'vat reg no',
'vat reg no.',
'vat registration no',
'vat registration num',
'vat registration number',
'vat_registration_num',
'vendor name',
'voluntary & community sector',
'voucher date',
'voucher number',
'year',
'year_period',
'\xef\xbb\xbf department family',
'\xef\xbb\xbf"department family"',
'\xef\xbb\xbfbody',
'\xef\xbb\xbfdepartment',
'\xef\xbb\xbfdepartment family',
'\xef\xbb\xbfdept family'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment