DOWNLOAD SAMPLE FILE: SUPP.dat
| Field | Field Label | Data Type | Max Size | Up-date | Sample Values | Customer, Supplier or Both | Default if blank or invalid | SUPP.dat Remarks |
|---|---|---|---|---|---|---|---|---|
| 1 | AccountCode | A | 10 | CUST0001 | B | Supplier Code (Must be unique – no duplicates allowed – and U/case) | ||
| 2 | Name | A | 40 | O | Sheraton Hotels | B | AccountCode | Supplier Name; should not be blank, otherwise defaults to Field 1 value; note that Update is Optional. |
| 3 | AddressLine1 | A | 40 | Y | Accounts Department | B | Address Line 1. | |
| 4 | AddressLine2 | A | 40 | Y | The Park Lane Hotel Ltd. | B | Address Line 2. | |
| 5 | AddressLine3 | A | 40 | Y | Piccadilly | B | Address Line 3. | |
| 6 | AddressLine4 | A | 40 | Y | London | B | Address Line 4. | |
| 7 | Country | A | 40 | Y | United Kingdom | B | Country. | |
| 8 | PostCode | A | 8 | Y | W1Y 8BX | B | Postal Code – must be U/case | |
| 9 | Customer Contact 1 | A | 40 | Y | C | Ignored | ||
| 10 | Customer Contact 1 Salutation | A | 20 | Y | C | Ignored | ||
| 11 | Customer Contact 1 Ending | A | 1 | Y | C | Ignored | ||
| 12 | AccountsContact | A | 40 | Y | Accounts Department | B | Accounts Contact Name | |
| 13 | AccountsContact Salutation | A | 20 | Y | Sirs | B | Sirs | Accounts Contact Salutation |
| 14 | AccountsContact Ending | A | 1 | Y | F | B | F | Accounts Contact Letter Ending – ‘F’ or ‘S’ (u/case) – prints faithfully or sincerely at end of letter |
| 15 | Supplier Contact 1 | A | 40 | Y | 0 | S | Supplier Main Sales Contact Name. | |
| 16 | Supplier Contact 1 Salutation | A | 20 | Y | 0 | S | Sirs | Supplier Main Sales Contact Salutation, e.g. [Dear] “Mr Smith” |
| 17 | Supplier Contact 1 Ending | A | 1 | Y | 0 | S | F | Supplier Main Sales Contact Letter Ending – ‘F’ or ‘S’ (u/case) – prints faithfully or sincerely at end of letter |
| 18 | Main Contact Tel | A | 20 | Y | 01712358050 | B | Main Telephone Number (Purchase Contact 1) | |
| 19 | Accounts Contact Tel | A | 20 | Y | 0 | B | Second Telephone Number (Accounts Contact) | |
| 20 | Main Contact Fax | A | 20 | Y | 01712358231 | B | Main Fax Number (Purchase Contact) | |
| 21 | Accounts Contact Fax | A | 20 | Y | 02072358211 | B | Accounts Contact Fax No | |
| 22 | Customer Price Type | A | 1 | Y | C | Ignored | ||
| 23 | Start Date | A | 8 | 35992 | B | [System Date] | Date Business Started (DD/MM/YY) | |
| 24 | Sales Person Code | A | 3 | Y | C | Ignored | ||
| 25 | Days Before On Stop | N | 2 | N | C | Ignored | ||
| 26 | Credit Limit | N | 13 | Y | 5000 | B | 0 | Credit Limit, 2 decimal places and must >= 0 (max format 10.2); defaults to zero if invalid. |
| 27 | VAT Type | A | 1 | Y | 0 | B | Y | Pay VAT; (u/case) Y = Home Suppliers, E = EC, N = Non- EC, O = Outside Scope, X = Exempt; blank defaults to Home for new record but does not change for update |
| 28 | Get Statement | A | 1 | Y | C | Ignored | ||
| 29 | Dynamic Discount | A | 1 | Y | C | Ignored | ||
| 30 | Notes | A | 512 | Y | 0 | B | Any Notes for this Supplier; 512 characters for TAS Books 1/2/3 | |
| 31 | Credit Card IssueNo | N | 2 | Y | 0 | C | Ignored | |
| 32 | Credit Card Issue Month | N | 2 | Y | 0 | C | Ignored | |
| 33 | Credit Card Issue Year | N | 2 | Y | 0 | C | Ignored | |
| 34 | Credit Card Number | A | 20 | Y | 0 | C | Ignored | |
| 35 | Credit Card Expiry Month | N | 2 | Y | 0 | C | Ignored | |
| 36 | Credit Card Expiry Year | N | 2 | Y | 0 | C | Ignored | |
| 37 | Credit Card Type | A | 1 | Y | 0 | C | Ignored | |
| 38 | Credit Card Name | A | 40 | Y | 0 | C | Ignored | |
| 39 | Credit Card Company Name | A | 40 | Y | 0 | C | Ignored | |
| 40 | Credit Card Address 1 | A | 40 | Y | 0 | C | Ignored | |
| 41 | Credit Card Address 2 | A | 40 | Y | 0 | C | Ignored | |
| 42 | Credit Card Address 3 | A | 40 | Y | 0 | C | Ignored | |
| 43 | Credit Card Address 4 | A | 40 | Y | 0 | C | Ignored | |
| 44 | Credit Card Post Code | A | 8 | Y | 0 | C | Ignored | |
| 45 | Credit Card Country | A | 40 | Y | 0 | C | Ignored | |
| 46 | Web Site URL | A | 60 | Y | www.infoplex.co.uk | B | ||
| 47 | Send Mailings | A | 1 | Y | C | Ignored | ||
| 48 | VATRegNum | A | 20 | Y | 0 | B | VAT Number (u/case) for EC Suppliers, optional for Home ones | |
| 49 | EC Country Code | A | 3 | Y | GB | B | [blank] | EC Country Code (u/case); only specify if VAT Type (col 27) = E; if H this is set to Home Country default. Not used for Non-EC. [Not validated] |
| 50 | Main Contact Email | A | 60 | Y | sales@infoplex.co.uk | B | Email for Main Supplier Purchase Contact | |
| 51 | Accounts Email | A | 60 | Y | accts@infoplex.co.uk | B | Email for Supplier Accounts Contact | |
| 52 | Main Contact Tel Ext | A | 4 | Y | 0 | B | Tel Extension for Main Supplier Purchase Contact | |
| 53 | Accounts Contact Tel Ext | A | 4 | Y | 0 | B | Tel Extension for Supplier Accounts Contact | |
| 54 | Settlement Discount Percent | N | 5 | Y | C | Ignored | ||
| 55 | SettlementDiscDays | N | 3 | Y | C | Ignored | ||
| 56 | Date Put On Stop | A | 8 | Y | C | Ignored | ||
| 57 | Who Put On Stop | A | 3 | Y | C | Ignored | ||
| 58 | On Stop | A | 1 | Y | C | Ignored | ||
| 59 | Group Code | A | 10 | Y | 0 | B | DEFAULT | Supplier Group Code; must be valid, otherwise DEFAULT used. |
| 60 | Marketing Code | A | 10 | Y | C | Ignored | ||
| 61 | Inactive Flag | A | 1 | Y | 0 | B | N | Y’ or ‘N’; whether or not supplier is inactive |
| 62 | Charge Overdue Interest | A | 1 | Y | C | Ignored | ||
| 63 | Days Credit | N | 3 | Y | C | Ignored | ||
| 64 | Customer Default Delivery Address Code | A | 10 | Y | C | Ignored | ||
| 65 | Supplier Account Ref For Us | A | 20 | Y | INF001 | S | Our Account Ref/Num with Supplier | |
| 66 | Use BACS to Pay | A | 1 | Y | Y | S | N | Y or N |
| 67 | BACS Ref | N | 8 | Y | 12345678 | B | ||
| 68 | BACS Beneficiary | A | 18 | Y | Sheraton Hotels Ltd | B | ||
| 69 | BACS Bank Name | A | 31 | Y | NatWest | B | ||
| 70 | Bank Sort Code | A | 8 | Y | 99-99-99 | B | For UK Banks use format 99-99- 99 | |
| 71 | Bank Account Number | A | 8 | Y | 99009900 | B | ||
| 72 | Bank Building Society | A | 18 | Y | 0 | B | TAS 1/2/3 only | |
| 73 | Statement Name | A | 40 | Y | 0 | C | Ignored | |
| 74 | Statement Address 1 | A | 40 | Y | 0 | C | Ignored | |
| 75 | Statement Address 2 | A | 40 | Y | 0 | C | Ignored | |
| 76 | Statement Address 3 | A | 40 | Y | 0 | C | Ignored | |
| 77 | Statement Address 4 | A | 40 | Y | 0 | C | Ignored | |
| 78 | Statement Post Code | A | 8 | Y | 0 | C | Ignored | |
| 79 | Statement Country | A | 40 | Y | 0 | C | Ignored | |
| 80 | Statement Contact | A | 40 | Y | 0 | C | Ignored | |
| 81 | Statement ContactEmail | A | 60 | Y | 0 | C | Ignored | |
| 82 | Statement Contact Tel | A | 20 | Y | 0 | C | Ignored | |
| 83 | Statement Contact Fax | A | 20 | Y | 0 | C | Ignored | |
| 84 | Default Payment Method | N | 2 | Y | 2 | S | 1=Cash, 2=Chq, 3=C-Cd, 4=eP, 5=T/f, 6=Othr, 7=N/A | |
| 85 | SuppPaymentName | A | 40 | Y | 0 | S | Ignored | |
| 86 | SuppPaymentAddr1 | A | 40 | Y | 0 | S | Ignored | |
| 87 | SuppPaymentAddr2 | A | 40 | Y | 0 | S | Ignored | |
| 88 | SuppPaymentAddr3 | A | 40 | Y | 0 | S | Ignored | |
| 89 | SuppPaymentAddr4 | A | 40 | Y | 0 | S | Ignored | |
| 90 | SuppPaymentPostCode | A | 8 | Y | 0 | S | Ignored | |
| 91 | SuppPaymentCountry | A | 40 | Y | 0 | S | Ignored | |
| 92 | SuppPaymentContact | A | 40 | Y | 0 | S | Ignored | |
| 93 | SuppPaymentContact Email | A | 60 | Y | 0 | S | Ignored | |
| 94 | SuppPaymentContact Tel | A | 20 | Y | 0 | S | Ignored | |
| 95 | SuppPaymentContact Fax | A | 20 | Y | 0 | S | Ignored | |
| 96 | Main Contact Mobile Tel | A | 20 | Y | 07790698431 | B | Purchase Contact’s Mobile Telephone Number | |
| 97 | Accounts Contact Mobile Tel | A | 20 | Y | 07790698469 | B | Accounts Contact’s Mobile Telephone Number | |
| Carriage Return (Hex = 0D, Dec = 13) | ||||||||
| Line Feed (Hex = 0A, Dec = 10) |
Last Updated: 21/02/2018