| No | Field | Required | Notes |
| 1 | Cust ID | N | The BluSynergy assigned customer id. Either this field or the CustomerAccountNumber must be specified to identify the customer that owns this order |
| 2 | Customer Ref | Y | The externally assigned customer reference number. Either this field or the CustomerId must be specified to identify the customer that owns this order |
| 3 | Order ID | N | Auto-generated if not supplied. |
| 4 | Order Number | Y | This is the Number assigned to each Order |
| 5 | Price Code | Y | The PriceCode corresponding to the Charge for the Plan. This PriceCode must obviously be one of the charges under the Plan identified by the 'ContractCode' field |
| 6 | External ID | N | This an ID assigned from an external source |
| 7 | Charge Date | Y | The assigned billable date for the activity |
| 8 | Charge End Date | Y | The assigned billable end date for the activity if different from above |
| 9 | Invoice Text | N | The externally assigned invoice text if any |
| 10 | Unit Price | Y | The rated unit price for the invoice record. This is assigned only after the activity has been "processed" (as indicated by the status column) |
| 11 | Quantity | Y | The quantity must be specified |
| 12 | Amount | Y | The rated amount for the invoice record. This is assigned only after the activity has been "processed" (as indicated by the status column) |
| 13 | Purchase Order Number | N | This Order number is the number specified by you for your Orders |
| 14 | CustomString1 | N | Optional Text or Other details can be specified. Appears as a seperate column |
| 15 | CustomString2 | N | Optional Text or Other details can be specified. Appears as a seperate column |
| 16 | CustomString3 | N | Optional Text or Other details can be specified. Appears as a seperate column |
| 17 | CustomString4 | N | Optional Text or Other details can be specified. Appears as a seperate column |
| 18 | CustomNumber1 | N | Optional numerical column. Can be used if required |
| 19 | CustomNumber2 | N | Optional numerical column. Can be used if required |
| 20 | OperationType | Y | Insert, Update or Delete operations can be performed. Denoted by I,U and D respectively |
| 21 | Activity Id | N | The internal ID of the activity record |
| 22 | Customer Name | Y | This is the name of the customer that will appear on the Invoice |
| 23 | Order Text | N | This is the text that appears on each Order |
| 24 | Line Item Text | N | This is the text that needs to appear on each Line Item |
