|
|
 | | From: | Brad Thomas at PhoenixSoftware | | Subject: | MYOB Export File Headers | | Date: | Mon, 17 Jan 2005 01:44:53 GMT |
|
|
 | Hi everyone
I'm writing some software to do some analysis of MYOB data, and want to import
the data from the exported CSV files. I need the header row from the exported files
so that I know where the information goes when imported into my software.
For example, MYOB Premier 7 has these fields for;
Non-consolidated tax codes:
Tax Code,Description,Tax Type,Rate,Linked Account for Tax Collected,Linked Account for Tax Paid,Linked Card for Tax
Authority,Luxury Car Tax Threshold
Accounts:
Account Number,Account Name,Header,Balance,Cheque Privileges,Last Cheque Number,Tax Code,Currency Code,Exchange Account,Inactive
Account,AccountantLink Code
Accounts: (MYOB Accounting for Windows version 10.5)
Account Number,Account Name,Header,Balance,Cheque Privileges,Last Cheque Number,Tax Code
(see? MYOB Premier 7 has more fields than 10.5)
Item Sales:
Co./Last Name,First Name,Addr 1 - Line 1, - Line 2, - Line 3, - Line 4,Inclusive,Invoice
#,Date,Customer PO,Ship Via,Already Printed,Item Number,Quantity,Description,Price,Inc-Tax Price,Discount,Total,Inc-Tax
Total,Job,Comment,Journal Memo,Salesperson Last Name,Salesperson First Name,Shipping Date,Referral Source,Tax Code,Non-GST
Amount,GST Amount,LCT Amount,Freight Amount,Inc-Tax Freight Amount,Freight Tax Code,Freight Non-GST Amount,Freight GST
Amount,Freight LCT Amount,Sale Status,Currency Code,Exchange Rate,Terms - Payment is Due, - Discount Days, -
Balance Due Days, - % Discount, - % Monthly Charge,Amount Paid,Payment Method,Payment Notes,Name on
Card,Card Number,Expiry Date,Authorisation Number,BSB,Account Number,Drawer/Account Name,Cheque Number,Category
Item Purchases:
Co./Last Name,First Name,Addr 1 - Line 1, - Line 2, - Line 3, - Line 4,Inclusive,Purchase
#,Date,Supplier Invoice #,Ship Via,Already Printed,Item Number,Quantity,Description,Price,Inc-Tax Price,Discount,Total,Inc-Tax
Total,Job,Comment,Journal Memo,Shipping Date,Tax Code,Non-GST Amount,GST Amount,Import Duty Amount,Freight Amount,Inc-Tax
Freight Amount,Freight Tax Code,Freight Non-GST Amount,Freight GST Amount,Freight Import Duty Amount,Purchase Status,Currency
Code,Exchange Rate,Terms - Payment is Due, - Discount Days, - Balance Due Days, - %
Discount,Amount Paid,Category
Items:
Item Number,Item Name,Buy,Sell,Inventory,Asset Acct,Income Acct,Expense/COS Acct,Item Picture,Description,Use Desc. On
Sale,Custom List 1,Custom List 2,Custom List 3,Custom Field 1,Custom Field 2,Custom Field 3,Primary Supplier,Supplier Item
Number,Tax Code When Bought,Buy Unit Measure,# Items/Buy Unit,Reorder Quantity,Minimum Level,Selling Price,Sell Unit Measure,Tax
Code When Sold,Sell Price Inclusive,Sales Tax Calc. Method,# Items/Sell Unit,Quantity Break 1,Quantity Break 2,Quantity Break
3,Quantity Break 4,Quantity Break 5,"Price Level A, Qty Break 1","Price Level B, Qty Break 1","Price Level C, Qty Break
1","Price Level D, Qty Break 1","Price Level E, Qty Break 1","Price Level F, Qty Break 1","Price Level A, Qty Break 2","Price
Level B, Qty Break 2","Price Level C, Qty Break 2","Price Level D, Qty Break 2","Price Level E, Qty Break 2","Price Level F, Qty
Break 2","Price Level A, Qty Break 3","Price Level B, Qty Break 3","Price Level C, Qty Break 3","Price Level D, Qty Break
3","Price Level E, Qty Break 3","Price Level F, Qty Break 3","Price Level A, Qty Break 4","Price Level B, Qty Break 4","Price
Level C, Qty Break 4","Price Level D, Qty Break 4","Price Level E, Qty Break 4","Price Level F, Qty Break 4","Price Level A, Qty
Break 5","Price Level B, Qty Break 5","Price Level C, Qty Break 5","Price Level D, Qty Break 5","Price Level E, Qty Break
5","Price Level F, Qty Break 5",Inactive Item
If anyone who uses MYOB (all and any version) would be so kind as to export your data
to a file and just post the header row and version info (like I've done above)
I'd be very appreciative.
I do not need your data - just the header row!
Thanks
Brad
Phoenix Software International
http://REMOVE-ME-TO-LIMIT-SPAMphoenixsoftware.dyndns.biz
brad@REMOVE-ME-TO-LIMIT-SPAMphoenixsoftware.dyndns.biz
--
Brad Thomas
Director
Phoenix Software International
4 Richmond Place
Forest Lake QLD 4078
Ph: (07) 32787440
Mob: 0418192671
brad@phoenixsoftware.dyndns.biz
http://phoenixsoftware.dyndns.biz
|
|
|
