File Format Document

Token File Format for Commodity Invoice Supporting Information (.TKC)

Transporter to System User

Copyright Xoserve 2014©, all rights reserved.

No part of this publication may be reproduced in any material form (including photocopying and restoring in any medium or electronic means and whether or not transiently or incidentally) without the written permission of Xoserve except in accordance with the provisions of the Copyright, Designs and Patents Act 1998.

Author: / Xoserve
Owner: / Xoserve
Version: / 1.1
Status: / For Approval
Date: / 21-Aug-2015

Version Control

Version / COR / Issue Date / Implementation Date / Summary of Change
1FA / 1154 / 07-Aug-2015 / TBC / For Approval
1.1FA / 1154 / 21-Aug-2015 / Project Nexus Implementation Date / Occurrence of B50 record amended to 1000
Contains4different Record Types
Level / Record Name / Occurrence / Optionality
1 / HD_A00_STANDARD_HEADER / 1 / M
1 / RT_B50_FILE_NAME_RECORD_COUNT / Up to1000 / M
1 / TR_Z99_STANDARD_TRAILER / 1 / M

Note 1

OPT - Optional/Mandatory (O - Optional, M - Mandatory)
DOM - Domain (T - text, N - Numeric, D - Date (YYYYMMDD), M - Timestamp)
LNG - Number of characters
DEC - Number of decimal places

Note 2

All text fields will be enclosed in double quotes ("")

Token File for Commodity Invoice Supporting Information Page 1 of 6 Submission Date:21/08/2015
Version 1.1For Approval Implementation Date: Project Nexus Implementation Date

Record Type Definition

HD_A00_STANDARD_HEADER

RECORD/FIELD_NAME *Occurs Max 1* / OPT / DOM / LNG / DEC / DESCRIPTION
TRANSACTION_TYPE / M / T / 3 / 0 / DEFINITION: A code identifying the type ofrecord.
VALUE:A00
ORGANISATION_ID / M / N / 10 / 0 / DEFINITION: A reference which uniquely identifies a Organisation.
FILE_TYPE / M / T / 3 / 0 / DEFINITION: An application specific code used to identify the structure and the usage of the file.
VALUE: TKC
CREATION_DATE / M / D / 8 / 0 / DEFINITION: The date on which the file was generated. YYYYMMDD
CREATION_TIME / M / M / 6 / 0 / DEFINITION: The time at which the file was generated (within the Creation Date).
GENERATION_NUMBER / M / N / 6 / 0 / DEFINITION: A sequence number which represents an issue of a file that is unique for a combination of System User and file type. Files of the same file type submitted by a System User or to a System User must have consecutive numbers
Total / 36

RT_B50_FILE_NAME_RECORD_COUNT

RECORD/FIELD_NAME
*Occurs Max 1000* / OPT / DOM / LNG / DEC / DESCRIPTION
TRANSACTION_TYPE / M / T / 3 / 0 / DEFINITION: A code identifying the type of request that this record represents.
VALUE : B50
SPLIT_FILE_NAME / M / T / 22 / 0 / DEFINITION: The name of the Split individual file which makes up part of the split file
SPLIT_RECORD_COUNT / M / N / 10 / 0 / DEFINITION: Number of records contained within the individual file specified in the SPLIT_FILE_NAME excluding header and footer
Total / 35

TR_Z99_STANDARD_TRAILER

RECORD/FIELD_NAME
*Occurs Max 1* / OPT / DOM / LNG / DEC / DESCRIPTION
TRANSACTION_TYPE / M / T / 3 / 0 / A code identifying the type of request that this record represents VALUE:Z99
RECORD_COUNT / M / N / 10 / 0 / The number of detail records contained within the file. This should not include the Standard Header (A00) and Standard Trailer (Z99) but should include any file specific Headers and Trailers specified for this file type.
Total / 13

Total Length: 84

Token File for Commodity Invoice Supporting Information Page 1 of 6 Submission Date:21/08/2015
Version 1.1For Approval Implementation Date: Project Nexus Implementation Date