03333 445950
03333 calls are same cost
 |  |  |
Making I.T. Happen
Accounting and Information Technology Assistance and Support
Sage Custom Integration - Status Codes And Values.
INVOICES SOP & POP
SALES_DEL_ADDR
Flags
There are a number of "FLAG" variables these are generally 1 or 0 to represent True or False.
It is worth noting that the ODBC drivers have "on the fly" created variables in some cases. Things that appear as tri state eg bank and vat rec flags are actually only have 2 states the third state is calculated. This is because the eligibility of a transaction to go on a vat return depends on if you use Cash or standard accounting.
| ACCOUNT_STATUS | Default Description |
| 0 | Open |
| rest are user defined | |
| LETTER_TYPE | DESCRIPTION |
| 1 | Reminder |
| 2 | Warning |
| 3 | Legal threat |
| 4 | Statements |
| 5 | Orders/Quotes |
| 6 | Invoice/Credits |
| 7 | GDN/GRN |
| 8 | Remittances |
| 9 | Default Letter |
INVOICES SOP/POP Types
| Type | Default Description |
| 0 | Product sales invoice |
| 1 | SOP Sales Invoices |
| 2 | Service Sales Invoice |
| 3 | Product credit note |
| 4 | Service Credit note |
| 5 | Product Proforma |
| 6 | Product Quote |
| 7 | Service Proforma |
| 8 | Service Quote |
| 9 | SOP Quote |
| 10 | POP Quote |
| 11 | SOP Proforma |
| 12 | POP Proforma |
In POP Sage uses field names that do not clearly relate to what they are for the Qtys
QTY_ALLOCATED = Allocation doe snot happen in POP, this field is used to represent the number of outstanding items (if it is on order) ie QTY on back order
QTY_DELIVERED = The Number that have already com into stock
QTY_DESPATCH = The number that are not yet delivered, if the order is on order then this will be the same as the QTY_ALLOCATED
QTY_INVOICED = How many have been updated to the purchase ledger.
POSTED_CODE
| Type | Default Description |
| 0 | NONE |
| 1 | PART |
| 2 | FULL |
This is used to indicate if the ITEMS have been UPDATED to the purchase ledger.
SALES_ORDER - INVOICE - PURCHASE ORDER
| TYPE | Description |
| 0 | Product Invoice |
| 1 | Invoice from SOP |
| 2 | Service Invoice |
| 3 | Product Credit |
| 4 | Service Credit |
| 5 | Product Proforma |
| 6 | Product Quote |
| 7 | Service Proforma |
| 8 | Service Quote |
| 9 | SOP Quote |
| 10 | POP Quote |
| 11 | SOP Proforma |
| 12 | POP Proforma |
| PAYMENT_TYPE | Description |
| 0 | Already Recd |
| 1 | ??Undefined |
| 2 | ??Undefined |
| 3 | Post & Allocate (SR) |
| 4 | Post & No Allocate (SA) |
| STATUS | Description |
| 0 | Blank |
| 1 | Part Allocated |
| 2 | Fully Allocated |
| 3 | Cancelled |
| 4 | Zero Allocated / Part Despatched |
| 5 | Part Allocated/Part Despatch |
| 6 | Fully Allocated / Part Despatched |
| 7 | Cancelled / Part Despatched |
| 8 | Fully Despatched (Complete) |
| 9 | Held / Part Despatched |
| 10 | Held / None Despatched |
| ALLOCATION STATUS | Description |
| 0 | None |
| 1 | Part |
| 2 | Fully |
| 3 | Cancelled |
| DESPATCH STATUS | Description |
| 0 | None |
| 1 | Part |
| 2 | Fully (Complete) |
Status must be compatible with Item Qty, changing item qtys will result in default status
| S | Description | Order | Allocate | Despatch |
| 0 | Blank | 10 | 0 | 0 |
| 1 | Part Allocated | 10 | 5 | 0 |
| 2 | Fully Allocated | 10 | 10 | 10 |
| 3 | Cancelled | 10 | 0 | 0 |
| 4 | Zero Allocated / Part Despatched | 10 | 0 | 5 |
| 5 | Part Allocated/Part Despatch | 10 | 3 | 5 |
| 6 | Fully Allocated / Part Despatched | 10 | 5 | 5 |
| 7 | Cancelled / Part Despatched | 10 | 0 | 5 |
| 8 | Fully Despatched (Complete) | 10 | 0 | 10 |
| 9 | Held / Part Despatched | 10 | 5 | 5 |
| 10 | Held / None Despatched | 10 | 10 | 0 |
| QUOTE_STATUS | Type Description |
| 0 | Not a quote |
| 1 | Open |
| 2 | Won |
| 3 | Lost |
| 4 | Invalid - Expired |
| ITEM.SERVICE_FLAG | Description |
| 0 | Product Item |
| 1 | ??Undefined |
| 2 | Service Item |
| TYPE | Type Description |
| 0 | Stock |
| 1 | Non Stock |
| 2 | Service |
| TYPE | Description |
| AI | Adjustment In |
| AO | Adjustment Out |
| GI | Goods In (Purchase Order) |
| GO | Goods Out (Inv/ Sales Order) |
| GR | Goods Returned (Credit Note) |
| MI | Manufacturing In |
| MO | Manufacturing Out |
| DI | Damaged In |
| DO | Damaged Out |
| WO | Write Off |
| UN | Non standard special: set to value create an AI or AO to adjust stock to stated level, Ref needs to be set to "STK TAKE" (can be configurable to be something else) |
| ARTEFACT_TYPE | Description |
| 0 | No Link |
| 1 | Ref hyperlinks to Invoice |
| 2 | Ref hyperlinks to Sales Order |
| 3 | Ref hyperlinks to Purchase order |
| CALC_METHOD | Description |
| 0 | Fixed Price |
| 1 | Sales Price Std |
| 2 | Sales price -% |
| 3 | Sales price -£ |
| 4 | Cost + % |
| 5 | cost + £ |
| 6 | Sales Price + % |
| ROUNDER_DIRECTION | Description |
| 0 | Round Up |
| 1 | Nearest |
| 2 | Round Down |
| ROUNDER_METHOD | Description |
| 0 | To |
| 1 | Multiples of |
| TYPE | Description |
| 85 | U-Supplier |
| 83 | S-Special Customer Price |
| 80 | P-Customer |
| TYPE | Description |
| 80 | P-Customer |
| 85 | U-Supplier |
AUDIT_HEADER / AUDIT_SPLIT
| TYPE | Description |
| SI | Sales Invoice |
| SA | Sales receipt on Account |
| SC | Sales Credit Note |
| SP | Sales Payment (Refund) |
| SR | Sales Receipt |
| SD | Sales Discount |
| PI | Purchase Invoice |
| PA | Payment on Account |
| PC | Purchase Credit Note |
| PR | Purchase Receipt (Refund) |
| PP | Purchase Payment |
| PD | Purchase Discount |
| JD | Journal Debit |
| JC | Journal Credit |
| BP | Bank Payment |
| BR | Bank Receipt |
| VP | Visa Payment |
| VR | Visa Receipt |
| CP | Cash Payment |
| CR | Cash Receipt |
| Code | Name |
| AD | Andorra |
| AE | United Arab Emirates |
| AF | Afghanistan |
| AG | Antigua and Barbuda |
| AI | Anguilla |
| AL | Albania |
| AM | Armenia |
| AN | Netherlands Antilles |
| AO | Angola |
| AQ | Antarctica |
| AR | Argentina |
| AS | American Samoa |
| AT | Austria |
| AU | Australia |
| AW | Aruba |
| AX | Aland Islands |
| AZ | Azerbaijan |
| BA | Bosnia-Herzegovina |
| BB | Barbados |
| BD | Bangladesh |
| BE | Belgium |
| BF | Burkina Faso |
| BG | Bulgaria |
| BH | Bahrain |
| BI | Burundi |
| BJ | Benin |
| BM | Bermuda |
| BN | Brunei Darussalam |
| BO | Bolivia |
| BR | Brazil |
| BS | Bahamas |
| BT | Bhutan |
| BV | Bouvet Island |
| BW | Botswana |
| BY | Belarus |
| BZ | Belize |
| CA | Canada |
| CC | Cocos (Keeling) Islands |
| CD | Congo (Democratic Republic) |
| CF | Central African Republic |
| CG | Congo (Brazzaville) |
| CH | Switzerland |
| CI | Cote d'Ivoire |
| CK | Cook Islands |
| CL | Chile |
| CM | Cameroon Republic |
| CN | China |
| CO | Colombia |
| CR | Costa Rica |
| CS | Serbia and Montenegro |
| CU | Cuba |
| CV | Cape Verde |
| CX | Christmas Island |
| CY | Cyprus |
| CZ | Czech Republic |
| DE | Germany |
| DJ | Djibouti |
| DK | Denmark |
| DM | Dominica |
| DO | Dominican Republic |
| DZ | Algeria |
| EC | Ecuador |
| EE | Estonia |
| EG | Egypt |
| EH | Western Sahara |
| ER | Eritrea |
| ES | Spain |
| ET | Ethiopia |
| FI | Finland |
| FJ | Fiji Islands |
| FK | Falkland Islands |
| FM | Micronesia, Federal States of |
| FO | Faroe Islands |
| FR | France |
| GA | Gabon |
| GB | United Kingdom |
| GD | Grenada |
| GE | Georgia |
| GF | French Guiana |
| GH | Ghana |
| GI | Gibraltar |
| GL | Greenland |
| GM | Gambia |
| GN | Guinea |
| GP | Guadeloupe |
| GQ | Equatorial Guinea |
| GR | Greece |
| GS | South Georgia, Sandwich Isl. |
| GT | Guatemala |
| GU | Guam |
| GW | Guinea-Bissau |
| GY | Guyana |
| HK | Hong Kong |
| HM | Heard Is. and McDonald Islands |
| HN | Honduras |
| HR | Croatia |
| HT | Haiti |
| HU | Hungary |
| ID | Indonesia |
| IE | Ireland |
| IL | Israel |
| IN | India |
| IO | British Indian Ocean Territory |
| IQ | Iraq |
| IR | Iran, Islamic Republic of |
| IS | Iceland |
| IT | Italy |
| JM | Jamaica |
| JO | Jordan |
| JP | Japan |
| KE | Kenya |
| KG | Kyrgyzstan |
| KH | Cambodia |
| KI | Kiribati |
| KM | Comoros |
| KN | Saint Kitts and Nevis |
| KP | Korea (North) |
| KR | Korea (South) |
| KW | Kuwait |
| KY | Cayman Islands |
| KZ | Kazakhstan |
| LA | Laos |
| LB | Lebanon |
| LC | Saint Lucia |
| LI | Liechtenstein |
| LK | Sri Lanka |
| LR | Liberia |
| LS | Lesotho |
| LT | Lithuania |
| LU | Luxembourg |
| LV | Latvia |
| LY | Libya |
| MA | Morocco |
| MC | Monaco |
| MD | Moldova, Republic of |
| MG | Madagascar |
| MH | Marshall Islands |
| MK | Macedonia |
| ML | Mali Republic |
| MM | Myanmar |
| MN | Mongolia |
| MO | Macao |
| MP | Northern Mariana Islands |
| MQ | Martinique |
| MR | Mauritania |
| MS | Montserrat |
| MT | Malta |
| MU | Mauritius |
| MV | Maldives |
| MW | Malawi |
| MX | Mexico |
| MY | Malaysia |
| MZ | Mozambique |
| NA | Namibia |
| NC | New Caledonia |
| NE | Niger Republic |
| NF | Norfolk Island |
| NG | Nigeria |
| NI | Nicaragua |
| NL | Netherlands |
| NO | Norway |
| NP | Nepal |
| NR | Nauru |
| NU | Niue |
| NZ | New Zealand |
| OM | Oman |
| PA | Panama |
| PE | Peru |
| PF | French Polynesia |
| PG | Papua New Guinea |
| PH | Philippines |
| PK | Pakistan |
| PL | Poland |
| PM | Saint Pierre and Miquelon |
| PN | Pitcairn |
| PR | Puerto Rico |
| PS | Palestinian Territ., Occupied |
| PT | Portugal |
| PW | Palau |
| PY | Paraguay |
| QA | Qatar |
| RE | Reunion |
| RO | Romania |
| RU | Russian Federation |
| RW | Rwanda |
| SA | Saudi Arabia |
| SB | Solomon Islands |
| SC | Seychelles |
| SD | Sudan Republic |
| SE | Sweden |
| SG | Singapore |
| SH | Saint Helena |
| SI | Slovenia |
| SJ | Svalbard and Jan Mayen |
| SK | Slovakia |
| SL | Sierra Leone |
| SM | San Marino |
| SN | Senegal |
| SO | Somali Republic |
| SR | Suriname |
| ST | Sao Tome & Principe |
| SV | El Salvador |
| SY | Syrian Arab Republic |
| SZ | Swaziland |
| TC | Turks and Caicos Islands |
| TD | Chad |
| TF | French Southern Territories |
| TG | Togo Republic |
| TH | Thailand |
| TJ | Tajikistan |
| TK | Tokelau |
| TL | Timor-Leste |
| TM | Turkmenistan |
| TN | Tunisia |
| TO | Tonga Islands |
| TR | Turkey |
| TT | Trinidad/Tobago |
| TV | Tuvalu |
| TW | Taiwan, Province of China |
| TZ | Tanzania |
| UA | Ukraine |
| UG | Uganda |
| UM | US Minor Outlying Islands |
| US | United States |
| UY | Uruguay |
| UZ | Uzbekistan |
| VA | Holy See (Vatican City State) |
| VC | Saint Vincent and Grenadines |
| VE | Venezuela |
| VG | Virgin Islands, British |
| VI | Virgin Islands, US |
| VN | Vietnam |
| VU | Vanuatu |
| WF | Wallis & Futuna Islands |
| WS | Samoa |
| XC | Channel Islands |
| XX | Unknown Country |
| YE | Yemen (Rep of) |
| YT | Mayotte |
| ZA | South Africa |
| ZM | Zambia |
| ZW | Zimbabwe |
| NUMBER | CODE | NAME | SYMBOL | MAJOR_CURRENCY_UNIT | MINOR_CURRENCY_UNIT |
| 1 | GBP | Pound Sterling | £ | pounds | pence |
| 2 | USD | US Dollar | $ | dollars | cents |
| 3 | EUR | Euro | € | euro | cent |
| 4 | ARS | Argentinean Peso | $ | pesos | centavos |
| 5 | AUD | Australian Dollar | $ | dollars | cents |
| 6 | BRL | Brazilian Real | $ | reals | centavos |
| 7 | CAD | Canadian Dollar | $ | dollars | cents |
| 8 | CYP | Cypriot Pound | £ | pounds | cents |
| 9 | DDK | Danish Krone | kr. | krone | ore |
| 10 | HKD | Hong Kong Dollar | $ | dollars | cents |
| 11 | INR | Indian Rupee | Rs. | rupees | paises |
| 12 | IDR | Indonesian Rupiah | Rp. | rupiahs | sens |
| 13 | IRR | Iranian Rial | Rls | rials | rials |
| 14 | ILS | Israeli Shekel | new shekels | agorots | |
| 15 | JPY | Japanese Yen | ¥ | yen | sen |
| 16 | MYR | Malaysian Ringgit | RM | ringgits | sens |
| 17 | MTL | Maltese Lira | liri | cents | |
| 18 | MXV | Mexican Peso | $ | pesos | centavos |
| 19 | NZD | New Zealand Dollar | $ | dollar | sents |
| 20 | NOK | Norwegian Krone | kr | krone | ore |
| 21 | PHP | Philippine Peso | pesos | centavos | |
| 22 | RUR | Russian Rouble | roubles | kopecks | |
| 23 | SAR | Saudi Arabian Riyal | SR | riyals | halalats |
| 24 | SGD | Singapore Dollar | $ | dollars | cents |
| 25 | ZAR | South African Rand | R | rand | cents |
| 26 | KRW | South Korean Won | won | chon | |
| 27 | SEK | Swedish Krona | krona | ore | |
| 28 | CHF | Swiss Franc | SFr | francs | rappen |
| 29 | TWD | Taiwanese Dollar | $ | dollars | cents |
| 30 | THB | Thai Baht | baht | sastang |
| Value | Description |
| 0 | No additional Discount |
| 1 | Invoice Value |
| 2 | Table A |
| 3 | Table B |
| 4 | Table C |
| 5 | Table D |
| 6 | Table E |
Note: To set discounts specifically in the Item do NOT use DISCOUNT_RATE use ADD_DISC_RATE.
Set the item table DISCOUNT_RATE to 0
Set the header table CUST_DISC_RATE to 0
Discount is the sum of
- (Stock discount) ITEM.DISCOUNT_RATE
- (Customer discount) HEADER.CUST_DISC_RATE
- (Manual discount) ITEM.ADD_DISC_RATE
SALES_DEL_ADDR
| ADDRESS_TYPE | Description |
| 0 | Delivery Address |
| 1 | Contact Address |
| 2 | Registered Address |
| DEFAULT_REF | Description |
| 0 | Not Default |
| 1 | Is Default |
REFERENCE
This is The ACCOUNT_REF padded with spaces to 8 chars then the ADDRESS_REF zero padded to 4 chars
