XML Email Format

A windows standard format (eXtensible Markup Language) is the format of choice if you want to import into other applications.

Fields within an XML file are held between field name parameters in pointy brackets.

For instance,

       <Job Code>1000</Job Code> holds a value or 1000 for field "Job Code"

Fields

OrderType                                                group  either

"Order"

"OrderConfirmation"

"RequestForQuotation"

" Cancelled Order"

       Header                        "Export from Databuild Order System  version xxx {Date}"

DigitalSignature        Unique number identifying sender

              Reference                Order Number                Alpha numeric 24 char max

       From                        group

               FromName        Sender's Name

               FromAddress        Sender's Address

               FromEmail        Sender's Email address

From

To                        group

ToName        Recipient's Name

ToAddress        Recipient's Address

ToEmail        Recipient's Email address

       To

       Date                        Order date

       DeliveryDate                Alpha numeric 24 char

Job                        group

JobCode        Alpha numeric 8 char

                       JobClient        Alpha numeric 96 char

                       JobAddress        Alpha numeric 96 char

Job

       CostCtr                        group

CCCode        Alpha numeric 10 char

CCName        Alpha numeric 32 char

CostCtr                

Supervisor                Alpha numeric 50 char

Estimator                Alpha numeric 50 char

Load                        Number. Indicates multiple orders on a single cost centre",

GST                        Yes or No. Indicates whether GST is included

For each item in the load:

Item                                Group

Code                        Sender's code for current item. Alpha numeric 10

Scode                        Receiver's  code. Alpha numeric 30 char

Description                Item Description. Alpha numeric 120 char

Quantity                Quantity

Units                        Alpha numeric 120 char

UnitPrice                Currency

Price                        Currency.  = Quantity * Unit Price / Unit divisor

                       Divisor usually 1, but may vary for items priced (say) per 1000

Workup                Details of any workups. Up to 65 Kbytes

Item

At the end of the order:

Notes                                Any Special Notes. Up to 65 Kbytes

OrderType  (end of XML file)                See note at top

General Notes:

Carriage returns are replaced by  "[LF]"

">" and "<" are special XML fields, and are replaced by "^"

"&" is replaced by "+"

Example