|
Size: 2014
Comment:
|
Size: 2425
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 30: | Line 30: |
| * Size run, | |
| Line 32: | Line 31: |
| * Size run | |
| Line 33: | Line 33: |
| * Attribute | |
| Line 35: | Line 36: |
| * Season | |
| Line 36: | Line 38: |
| * Supplier code | * Supplier_code * Supplier_name |
| Line 40: | Line 43: |
| * main_city * main_state * main_postcode |
* main_addr3 (City, State, Postcode) |
| Line 47: | Line 48: |
| * accounts_email | |
| Line 49: | Line 51: |
| * other_city * other_state * other_postcode * abn |
* other_addr3 (City, State, Postcode) * Supplier_ABN * Supplier_Group * Payment_Type (E for eft, C for cheque) * BSB_Number * Account_Number * Credit Terms (in days) * Past End of Month * GL Sundry Invoice Expense Account |
| Line 57: | Line 64: |
| * Title (Mr, Mrs, Miss, Dr, etc) | |
| Line 60: | Line 68: |
| * State | * Address 3 (City, State) |
| Line 62: | Line 70: |
| * Country | * Zone (delivery zone or postcode) * Country (3 character country code) |
| Line 67: | Line 76: |
| * Contact | * Email Address * Contact Person |
| Line 70: | Line 80: |
| = DEPARTMENT = * Department ID * Department Name = Category = * Department ID * Category ID |
* Credit Limit = CATEGORY/DEPARTMENT IMPORT = * Category ID (Category code including department prefix, or just department prefix) |
IMPORTING FILES
Importing files is a quick way of getting data from one system, possibly manipulating it with third party software and (re)importing into CONTROL. The data must have columns in the following sequence and all columns with data in them will be assumed to match the columns defined below. All columns defined below past the last column with actual data in the import file, will be given the currently defined "default value".
STOCK FILE IMPORT
- Stock/Style Number
- Description
- Comment
- Category (Dept/Sub-department)
- Supplier 1
- Supplier 1 Product Code,
- Supplier 1 Cost in SUPPLIER'S currency
- Last Supplier Cost in LOCAL currency
- Duty %
- Other Charges (amount or % of supplier cost in local currency)
- Landed Cost
- Current Sell Price (Inc GST)
- Price Level 1
- Price Level 2
- Price Level 3
- Price Level 4
- Unit (assume buy unit = sell unit, etc.)
- Barcode Number
- Quantity on hand
- Minimum
- Maximum
- Type (C = Consignment, D = discontinued, G = Gross (no qty), I = Inactive, M = Miscellaneous (fixed GP), S = scalable item, W = whole number only)
- On Internet (y/n)
- Weight
- Volume
- Colour palette
- Size run
- Parent/Style number (this and next two columns are only valid for "child" items)
- Attribute
- Colour
- Size
- Season
CREDITORS IMPORT
- Supplier_code
- Supplier_name
- main_contact
- main_addr1
- main_addr2
- main_addr3 (City, State, Postcode)
- main_country
- main_phone
- main_fax
- main_email
- accounts_email
- other_addr1
- other_addr2
- other_addr3 (City, State, Postcode)
- Supplier_ABN
- Supplier_Group
- Payment_Type (E for eft, C for cheque)
- BSB_Number
- Account_Number
- Credit Terms (in days)
- Past End of Month
- GL Sundry Invoice Expense Account
CUSTOMERS IMPORT
- Customer Code
- First Name
- Last Name
- Title (Mr, Mrs, Miss, Dr, etc)
- Customer Name (Business name or Full Customer name)
- Address 1
- Address 2
- Address 3 (City, State)
- Postcode
- Zone (delivery zone or postcode)
- Country (3 character country code)
- Main Phone
- A/H Phone
- Mobile Phone
- Fax Number
- Email Address
- Contact Person
- Group 1
- Group 2
- Credit Limit
CATEGORY/DEPARTMENT IMPORT
- Category ID (Category code including department prefix, or just department prefix)
- Category Name