TRADACOMS ›
Utility Bill › UTLBIL
UTLBIL: Utility Bill File Details
The UTLBIL message is part of the TRADACOMS Utility Bill file: utility billing (electricity, gas, water, telecoms).
The Utility Bill file contains: UTLHDR → UTLBIL → UVATLR → UTLTLR.
Message structure
| Segment | Name | Usage |
|---|---|---|
MHD | Message Header | One message for each bill |
CLO | Customer's Location | |
BCD | Bill Control Data | |
PYT | Settlement Terms CDA = Contract Data | Repeat as necessary |
DNA | Data Narrative | Repeat as necessary |
CCD | Consumption/Charge Details | Repeat as necessary |
MOD | Charge Modifiers | Repeat as necessary |
ADJ | Additional Adjustments MAN = Meter Administration Number VAT = Value Added Tax | Repeat as necessary |
PRV | Payment Received | Repeat as necessary |
BTL | Bill Trailer | |
DEF | Deferred Charges | |
MTR | Message Trailer |
Segments and data elements
| Element | Name | M/C | F/V | Format | Notes |
|---|---|---|---|---|---|
MSRF | Message Reference | M | V | 9(12) | Consecutive count of messages within the transmission |
TYPE | Type of Message composite | M | `UTLBIL' `3' for this version | ||
| Type | M | F | X(6) | ||
| Version Number | M | F | 9(1) |
| Element | Name | M/C | F/V | Format | Notes |
|---|---|---|---|---|---|
CLOC | Customer's Location composite | M | One of the following 3 customer references must be present EAN Location number identifying the customer's location Customer's identity for the location to which the goods ordered are to be/have been delivered Supplier's reference for the customer's location | ||
| Customer's EAN Location Number | C | F | 9(13) | ||
| Customer's Own Location Number | C | V | X(17) | ||
| Supplier's Identity of Customer's Location | C | V | X(17) | ||
CNAM | Customer's Name | C | V | X(40) | Customer's registered legal name |
CADD | Customer' Address composite | C | A maximum of five lines to give the customer's address | ||
| Customer's Address Line 1 | C | V | X(35) | ||
| Customer's Address Line 2 | C | V | X(35) | ||
| Customer's Address Line 3 | C | V | X(35) | ||
| Customer's Address Line 4 | C | V | X(35) | ||
| Customer's Post Code | C | V | X(8) |
| Element | Name | M/C | F/V | Format | Notes |
|---|---|---|---|---|---|
IVDT | Date of Invoice | M | F | 9(6) | Format: YYMMDD |
TXDT | Tax-point Date | M | F | 9(6) | Format: YYMMDD May be same as Date of Invoice |
INVN | Invoice Number | C | V | X(17) | As allocated by the supplier |
PBID | Previous Bill Date | C | F | 9(6) | Format: YYMMDD |
BIFR | Bill Frequency Code | C | V | X(3) | Code Values List 27 |
BTCD | Bill Type Code | C | V | X(3) | See Code Values List 42 · code list 42 |
VDAA | VAT Declaration for Amended Account composite | C | Mandatory for amended accounts User defined coded statement IVDT of previous bill UTVA of previous bill INVN of previous bill CLOC of previous bill | ||
| VAT Declaration Code | M | V | X(3) | ||
| Date of Bill Withdrawn | M | F | 9(6) | ||
| VAT Total Amount on Bill Withdrawn | M | V | 9(10)V9(2) | ||
| Amended Invoice Reference | C | V | X(17) | ||
| Premises Reference of Previous Bill | C | V | X(17) | ||
SUMO | Supply Period composite | C | Format: YYMMDD Format: YYMMDD | ||
| Start Date | C | F | 9(6) | ||
| End Date | C | F | 9(6) | ||
CLVM | Calorific Value in Specified Units composite | C | Calorific value of gas supply Code Values List 4 | ||
| Calorific Value | C | V | 9(10)V9(3) | ||
| Unit of Measure | M | V | X(6) |
| Element | Name | M/C | F/V | Format | Notes |
|---|---|---|---|---|---|
SEQA | First Level Sequence Number | M | V | 9(10) | Starts at 1 and increases for each repeat of this segment |
PAYT | Terms of Payment | C | V | X(40) | Text description of the settlement terms |
PAYD | Payment Date and Terms composite | C | Settlement terms agreed between the buyer and the seller, expressed in terms of payment due date and percentage Date that payment should be made available to the payee to obtain the specified discount Percentage discount applicable | ||
| Payment Date | M | F | 9(6) | ||
| Settlement Discount Percentage | M | V | 9(3)V9(3) | ||
PAYY | Settlement Terms composite | C | Settlement terms described using calendar days after a reference date and/or code Days until payment is due is defined as the number of calendar days after a reference date, usually the date of the invoice, that payment is to be made available to the payee Percentage discount applicable Code for settlement terms. User defined | ||
| Number of Days | M | V | 9(3) | ||
| Settlement Discount Percentage | C | V | 9(3)V9(3) | ||
| Settlement Code | C | V | X(3) |
| Element | Name | M/C | F/V | Format | Notes |
|---|---|---|---|---|---|
CPSC | Current Price Schedule Reference | C | F | X(17) | Applicable price schedule |
ORNO | Order Number and Date composite | C | Order references As allocated by the customer to identify the order As allocated by the supplier to identify the order Date order placed, which may be date of file. Format: YYMMDD Format: YYMMDD | ||
| Customer's Order Number | C | V | X(17) | ||
| Supplier's Order Number | C | V | X(17) | ||
| Date Order Placed by customer | C | F | 9(6) | ||
| Date Order Received by Supplier | C | F | 9(6) | ||
INSD | Installation Date | C | F | 9(6) | Date equipment installed. Format: YYMMDD |
REPE | Rental Period | C | V | X(3) | See Code Values List 27 |
| Element | Name | M/C | F/V | Format | Notes |
|---|---|---|---|---|---|
SEQA | First Level Sequence Number | M | V | 9(10) | Starts at 1 and is incremented by 1 for each segment of this type in the message |
DNAC | Data Narrative Code composite | C | Text statement held on mutually supported file Number of relevant code list Code Value from list · code list 22 | ||
| Code Table Number | C | V | 9(4) | ||
| Code Value | C | V | X(3) | ||
RTEX | Registered Text composite | C | Essential text, where not provided for by specific fields, may be communicated using this element Code values MUST be registered with e centreUK prior to use. The same application code may be repeated up to 4 times, or up to 4 different codes may be used · code list 24 | ||
| First Line Registered Text Code | C | V | X(3) | ||
| Application Text | C | V | X(40) | ||
| Second Line Registered Text Code | C | V | X(3) | ||
| Application Text | C | V | X(40) | ||
| Third Line Registered Text Code | C | V | X(3) | ||
| Application Text | C | V | X(40) | ||
| Fourth Line Registered Text Code | C | V | X(3) | ||
| Application Text | C | V | X(40) | ||
GNAR | General Narrative composite | C | Narrative covering information which cannot be sent in a coded form ie. RTEX/DNAC. This is likely to preclude automatic processing | ||
| General Narrative Line 1 | C | V | X(40) | ||
| General Narrative Line 2 | C | V | X(40) | ||
| General Narrative Line 3 | C | V | X(40) | ||
| General Narrative Line 4 | C | V | X(40) |
| Element | Name | M/C | F/V | Format | Notes |
|---|---|---|---|---|---|
SEQA | First Level Sequence Number | M | V | 9(10) | Starts at 1 and is incremented by 1 for each segment of this type in the message |
CCDE | Charge Type Code composite | M | Code to indicate use of this segment. Code Values List 43 EAN article number allocated to the service or product Supplier's internal reference · code list 43 | ||
| Consumption/Charge Indicator | C | V | X(3) | ||
| EAN-13 Article Number | C | F | 9(13) | ||
| Supplier Code | C | V | X(3) | ||
TCOD | Tariff Code composite | C | User defined tariff in coded or text format. A text field cannot be automatically processed | ||
| Tariff Code | C | V | X(6) | ||
| Tariff Description | C | V | X(40) | ||
TMOD | Tariff Code Modifier composite | C | User defined codes | ||
| Tariff Code Modifier 1 | C | V | X(6) | ||
| Tariff Code Modifier 2 | C | V | X(6) | ||
| Tariff Code Modifier 3 | C | V | X(6) | ||
| Tariff Code Modifier 4 | C | V | X(6) | ||
MTNR | Meter Number | C | V | X(35) | Identifies the meter |
MLOC | Meter Location | C | V | X(40) | Additional identification to locate the meter |
PRDT | Present Read Date | C | F | 9(6) | Format: YYMMDD |
PVDT | Previous Read Date | C | F | 9(6) | Format: YYMMDD |
NDRP | Reading Period | C | V | 9(3) | Number of Days covered by reading period PRDT to PVDT |
PRRD | Reading Data composite | C | Meter readings See Code Values List 44 See Code Values List 44 · code list 44 | ||
| Present Reading | M | V | 9(15) | ||
| Type | C | V | X(4) | ||
| Previous Reading | M | V | 9(15) | ||
| Type | C | V | X(4) | ||
CONS | Consumption (Billing Units) composite | C | Supply consumed in billing units See Code Values List 4 Allowed value: R | ||
| Units Consumed | M | V | 9(10)V9(3) | ||
| Unit of Measure | M | V | X(6) | ||
| Negative Indicator | C | V | X(4) | ||
CONB | Consumption (Base Units) composite | C | Supply consumed in meter units Difference between present and previous readings in PRRD See Code Values List 4 Allowed value: R | ||
| Units Consumed | M | V | 9(10)V9(3) | ||
| Unit of Measure | M | V | X(6) | ||
| Negative Indicator | C | V | X(4) | ||
ADJF | Adjustment Factor composite | C | Adjustment applied to CONB User defined code for adjustment Multiplication factor Allowed value: R when negative | ||
| Adjustment Factor Code | C | V | X(3) | ||
| Adjustment Factor Value | M | V | 9(10)V9(5) | ||
| Negative Indicator | C | V | X(4) | ||
CONA | Consumption (Adjusted Units) composite | C | Adjusted consumption Calculated from CONB after adjustment, ADJF, has been applied See Code Values List 4 Allowed Value: R | ||
| Units Consumed | M | V | 9(10)V9(3) | ||
| Unit of Measure | M | V | X(6) | ||
| Negative Indicator | C | V | X(4) | ||
BPRI | Base Price Per Unit | C | V | 9(10)V9(5) | Unmodified unit price |
NUCT | Number of Units for Charge Type composite | C | Number of units for this CCDE See Code Values List 4 Allowed Value: R | ||
| Units Billed | M | V | 9(10)V9(3) | ||
| Unit of Measure | M | V | X(6) | ||
| Negative Indicator | C | V | X(4) | ||
CSDT | Charge Start Date | C | F | 9(6) | Format YYMMDD |
CEDT | Charge End Date | C | F | 9(6) | Format YYMMDD |
CPPU | Price per Unit | C | V | 9(10)V9(5) | Price charged |
CTOT | Total Charge for Charge Type composite | C | NUCT x CPPU Allowed value: R | ||
| Total Charge for Charge Type | M | V | 9(10)V9(2) | ||
| Credit Indicator | C | V | X(4) | ||
TSUP | VAT - Type of Supply | C | F | X(1) | Code as defined by HM C&E. See Code Values List 14. Mandatory unless code is A, Ordinary Sale · code list 14 |
VATC | VAT Rate Category Code | C | F | X(1) | Code Values List 12 · code list 12 |
VATP | VAT Rate Percentage | C | V | 9(3)V9(3) | Percentage rate for VAT Category Code |
MSAD | Meter Sub-address Sub-address Code Sub-address Line | C | V | X(17) | Identification of a user beyond the metered point of supply in code or text form e.g. a network address |
| Element | Name | M/C | F/V | Format | Notes |
|---|---|---|---|---|---|
SEQA | First Level Sequence Number | M | V | 9(10) | Starts at 1 and is incremented by 1 for each segment of this type in the message |
SEQB | Second Level Sequence Number | M | V | 9(10) | Starts at 1 and is successively incremented by 1 for each 2nd level nesting of this segment |
MCAT | Modifier Category | C | V | X(3) | Allowed values: 1 = Factor applied to BPRI; 2 = Value applied to BPRI ; 3 = Percentage applied to BPRI |
MCDE | Modifier Code | C | V | X(3) | User defined code for the modifier |
MVAL | Modifier Value composite | C | Value of modifier Allowed value: R. Used when the value is negative. | ||
| Modifier Value | M | V | 9(10)V9(3) | ||
| Credit Indicator | C | V | X(4) |
| Element | Name | M/C | F/V | Format | Notes |
|---|---|---|---|---|---|
SEQA | First Level Sequence Number | M | V | 9(10) | Starts at 1 and is incremented by 1 for each segment of this type in the message |
SEQB | Second Level Sequence Number | M | V | 9(10) | Starts at 1 and is successively incremented by 1 for each 2nd level nesting of this segment |
ADJF | Adjustment Factor composite | C | User defined code for adjustment Value of adjustment Allowed value: R | ||
| Adjustment Factor Code | C | V | X(3) | ||
| Adjustment Factor Value | M | V | 9(1)V9(5) | ||
| Negative Indicator | C | V | X(4) |
| Element | Name | M/C | F/V | Format | Notes |
|---|---|---|---|---|---|
PNDP | Percentage Qualifying for Lower / Zero VAT Rate | C | V | 9(3)V9(3) | Domestic proportion of bill |
VATC | VAT Rate Category Code | M | F | X(1) | Code Values List 12 · code list 12 |
VATP | VAT Rate Percentage | M | V | 9(3)V9(3) | Percentage rate for VAT Category Code |
UVLA | Total Charge for VAT Category Before VAT composite | M | Amount after settlement discount and subsidy have been applied Allowed Value: R | ||
| Total Charge Before VAT | M | V | 9(10)V9(2) | ||
| Credit Line Indicator | C | V | X(4) | ||
UVTT | VAT Amount Payable composite | M | VAT amount at quoted rate Allowed Value: R | ||
| VAT Amount Payable | M | V | 9(10)V9(2) | ||
| Credit Line Indicator | C | V | X(4) | ||
UCSI | Total Charge for VAT Category including VAT Total Charge including VAT Credit Line Indicator | M | V | 9(10)V9(2) | After settlement discount has been applied, plus VAT Allowed value: R |
NRIL | Number of Item Lines | C | V | 9(4) | Number of CCD segments with this VAT Category Code |
RFLV | Reason for Lower/Zero VAT Rate | C | V | X(3) | Used when premises are lower or zero rated. Allowed values: L = Low consumption D = Domestic usage C = Combined |
| Element | Name | M/C | F/V | Format | Notes |
|---|---|---|---|---|---|
SEQA | First Level Sequence Number | M | V | 9(10) | Starts at 1 and is incremented by 1 for each segment of this type in the message |
PPAM | Prepayment Amount composite | M | Allowed Value: R. Only used if debit payment e.g. returned cheque | ||
| Prepayment Amount | M | V | 9(10)V9(2) | ||
| Credit Line Indicator | C | V | X(4) | ||
PADT | Prepayment Date | M | F | 9(6) | Payment date as defined by trading partners. Format YYMMDD |
PAYB | Balance of Outstanding Prepayments Received | C | V | 9(10)V9(2) | Remaining credit - not used in calculations. |
TBTL | Total Bill Amount Payable composite | M | BABF + UVLT + UTVA - PTOT Only used if actual consumption is less than previous estimate. Allowed Value: R | ||
| Total Bill Amount Payable | M | V | 9(10)V9(2) | ||
| Credit Indicator | C | V | X(4) |
| Element | Name | M/C | F/V | Format | Notes |
|---|---|---|---|---|---|
MCDV | Monthly Charge Deferred Value | M | V | 9(10)V9(2) | Deferred charge |
| Element | Name | M/C | F/V | Format | Notes |
|---|---|---|---|---|---|
NOSG | Number of Segments in Message | M | V | 9(10) | Control count of the number of segments comprising message. Includes the MHD and MTR segments |
Need to exchange TRADACOMS messages with a UK retailer?
SupplyLens connects your ERP, e-commerce or accounting system to any TRADACOMS or EDIFACT trading partner: orders in, invoices out, fully managed.
Book a demo Learn about retail EDI →