Transportation Manager Data Dictionary

Transportation ManagerData DictionaryVersion 6.0

Copyright InformationOne i2 Place11701 Luna Rd.Dallas, TX 75234 USAi2 Transportation Manager Data DictionaryVersion 6.0, August 2002Copyright 1995-2002 i2 Technologies US, Inc. All Rights Reserved.This notice is intended as a precaution against inadvertent publication and does not imply any waiver ofconfidentiality. Information in this document is subject to change without notice. No part of this document may bereproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying,recording, or information storage or retrieval systems, for any purpose without the express written permission of i2Technologies US, Inc.The software and/or database described in this document are furnished under a license agreement or nondisclosureagreement. It is against the law to copy the software onto any medium except as specifically allowed in the license ornondisclosure agreement. If software or documentation is to be used by the federal government, the followingstatement is applicable: In accordance with FAR 52.227-19 Commercial Computer Software -- RestrictedRights, the following applies: This software is Unpublished--rights reserved under the copyright laws of theUnited States.The text and drawings set forth in this document are the exclusive property of i2 Technologies US, Inc. Unlessotherwise noted, all names of companies, products, street addresses, and persons contained in the scenarios aredesigned solely to document the use of i2 Technologies US, Inc. products.The brand names and product names used in this document are the trademarks, registered trademarks, service marks,or trade names of their respective owners. i2 Technologies US, Inc. is not associated with any product or vendormentioned in this publication unless otherwise noted.The following trademarks and service marks are the property of i2 Technologies US, Inc. and its affiliates:TradeMatrix; RHYTHM Transportation Enabled Planning; Rhythmtone; eBPO; eBPO Electronic Business ProcessOptimization; AeroMatrix; AeroMatrix.com; AeroSpaceMatrix; AeroSpaceMatrix.com; AutoMatrix;AutoMatrix.com; eServiceMatrix; FreightMatrix; FreightMatrix.com; SoftgoodsMatrix; B2A; ConstructionMatrix;ConstructionMatrix.com; TelecoMatrix; TelecoMatrix.com; HightechMatrix; HightechMatrix.com; C-StoreMatrix;C-StoreMatrix.com; Heterocasting.The following registered trademarks are the property of i2 Technologies US, Inc. and its affiliates: i2; i2Technologies and design; Global Supply Chain Management; PLANET; RHYTHM; “juggler” design; RhythmLink;TradeMatrix.com.This product may be protected by one or more of the following patents:Australian Patent No. 692929Australian Patent No. 708311Australian Patent No. 709987Australian Patent No. 710420Australian Patent No. 711699Australian Patent No. 712238Australian Patent No. 728154Australian Patent No. 731197PATENTED NO. EP0752134PATENTED NO. EP0755537PATENTED NO. EP0776506PATENTED NO. EP0776507PATENTED NO. EP0776508PATENTED NO. EP0776509Singapore PATENT NO. 37930Singapore PATENT NO. 37931Singapore PATENT NO. 51047Singapore PATENT NO. 51051Singapore PATENT NO. 64044Singapore PATENT NO. 67163Taiwan PATENT NO. 80326Taiwan PATENT NO. 93090Taiwan PATENT NO. 100569Taiwan PATENT NO. 108409Taiwan PATENT NO. 110827Taiwan PATENT NO. 113331Taiwan PATENT NO. 113820Taiwan PATENT NO. 114592Taiwan PATENT NO. 127358United Kingdom Patent No. 2316506U. S. Patent No. 5,630,123U. S. Patent No. 5,764,543U. S. Patent No. 5,832,532U. S. Patent No. 5,845,258U. S. Patent No. 5,930,156U. S. Patent No. 5,931,900U. S. Patent No. 5,937,155U. S. Patent No. 5,943,244U. S. Patent No. 5,974,395U. S. Patent No. 5,983,194U. S. Patent No. 5,995,945U. S. Patent No. 6,031,984U. S. Patent No. 6,047,290U. S. Patent No. 6,055,519U. S. Patent No. 6,055,533U. S. Patent No. 6,076,108U. S. Patent No. 6,085,220U. S. Patent No. 6,119,149U. S. Patent No. 6,167,380U. S. Patent No. 6,188,989U. S. Patent No. 6,222,533U. S. Patent No. 6,233,493U. S. Patent No. 6,233,572U. S. Patent No. 6,266,655U. S. Patent No. 6,289,384U. S. Patent No. 6,289,38508/16/02

Contents1 Introduction. 9Understanding the Data Dictionary Format .9Data Dictionary Changes.10New Report .10New Fields.10Additional Information.132 Setting Up Reports . 15Overview .15Setting Up Crystal Reports.15Saving Changes .16Enabling Changes.16Using Entity-Specific Formats .17Using Services in Confirmation .17Standard Reports .173 Creating Reports. 21Introduction .21Creating a Simple Report .21Creating a Multiple-View Report.254 Report Views . 29ACCOUNTING PERIOD R.29ACCRUAL RUN R.30ACCRUAL VERSION AP R.30ACCRUAL VERSION AR R .31ADDRESS R .31APPOINTMENT R .33APPOINTMENT STAT TRANSITION R .33AP TRANSACTION R .34AP TRANSACTION VERSION R.35AR TRANSACTION R.36Transportation Manager Data Dictionary3

ContentsAR TRANSACTION VERSION R. 37ARCHIVE REFERENCE NUMBER R . 38ASSOCIATION EXCL COMMODITY R. 38ASSOCIATION SEC STATUS R. 39AUTO APPLIED OPTION R. 39BUSINESS DAYS R . 40CARRIER R . 40CARRIER CUSTOMER FREIGHT AUD R . 45CHARGE DETAIL R . 45CHARGE OVERRIDE R . 48COMMODITY R. 48COMPONENT R (Container) . 49COMPONENT TYPE R (Container Type) . 51COMPONENT TYPE GROUP R (Container Type Group) . 52CONSIGNEE R . 53COUNTRY R . 55CUSTOMER R . 56CUSTOMER DERIVED R . 59CUSTOMER SHIPPING LOCATION R. 60CUSTOMER VERSION R. 60DAY SCHEDULE R . 61DELIVERY SCHEDULE R . 61DISTRIBUTION CENTER R . 62DIVISION R . 64DOMICILE R . 65DOMICILE EQUIPMENT R . 65EQUIPMENT TYPE R. 66EVENT DELIVERY R. 67EVENT DELIVERY RECIPIENT R . 67EXCHANGE RATE R . 68EXTL CUST ACCT DEFINITION R . 69EXTL CUSTOMER ACCT POSTED R . 69EXTL CUSTOMER SHIPPING LOC R. 70FINANCIAL AP TRANSITION R . 70FINANCIAL AR TRANSITION R. 71FINANCIAL ENTITY TRANSITION R. 72FREIGHT BILL R . 73FREIGHT BILL AUTO PAY RUN R . 74FREIGHT BILL BATCH CONTROL R. 75FREIGHT BILL DETAIL R. 75FREIGHT BILL DETL CHARGE R . 76FREIGHT BILL VERSION R. 77FREIGHT CLASS R . 78GEOGRAPHIC AREA R . 78GL ACCOUNT DESIGNATION R . 79GL TRANSACTION R . 804Transportation Manager Data Dictionary

ContentsGLOBAL DEFAULTS R.82HARMONIZED TARRIFS R .94HELD LOG R.94HUB R .94INCO TERMS R .97INVOICE R .97INVOICE DETAIL R.99INVOICE RUN R.99INVOICE VERSION R.100ITEM GROUP R .101ITEM MASTER R .102ITINERARY R.102ITINERARY LANE PERFORMANCE R.103ITINERARY POINT R .103ITINERARY POINT TIMETABLE R .104ITINERARY TIMETABLE R .105ITINERARY TIMETABLE ENTRY R.105JOURNEY TEMPLATE R (Itinerary Template).105LANE ASSOCIATION R .106LANE AVAILABILITY R .107LANE DELIVERY SCHEDULE R.108LOAD AT R .108LOAD LEG R (Load).110LOAD LEG DETAIL R (Shipment Leg).117LOAD LEG DETAIL COMPONENT R (Shipment Leg Container) .122LOAD TENDER CONTACT R.123LOAD TENDER DENORM (Load Tender Enhanced Report) .124LOADING INSTRUCTION R.126LOGISTICS GROUP R .126MANIFEST GROUP R.127MASTER CHARGES R (Condition and Options) .127MASTER SERVICES R .128MBOL DENORM (Master Bill of Lading).129Materialized Views.134MV COMPLETED BY CUSTOMER .134MV MISSING PODS BY CARRIER .135MV MISSING PODS BY CUSTOMER.136MV UNDELIVERED BY CARRIER.137MV UNDELIVERED BY CUSTOMER .138MV UNSCHEDULED BY CUSTOMER.139NMFC R .140NON OPERATIONAL FREIGHT R.140NON OPERATIONAL STOP R .144NON OP WEIGHT BY FC R .145OPERATIONAL AP TRANSITION R .145OPERATIONAL AR TRANSITION R.146Transportation Manager Data Dictionary5

ContentsPAYABLE CARRIER OVERRIDE R. 147PERSON R . 147PLAN R . 148POD R. 148POSTAL CODE R. 149RANGE BREAK R . 149RANGE CODE R . 150RANGE RATE R. 150RATE R . 151RATE CODE R . 151RATING INFO R . 152REFERENCE NUMBER R. 153REFERENCE NUMBER CATEGORY R . 154REFERENCE NUMBER QUALIFIER R. 154RESPONSIBLE CUST OVERRIDE R . 156RESTRICTION R. 157SALES PERSON R . 159SERIAL LOT CONTROL NUM R. 159SERVICE EXCEPTION CODE R . 160SHIPMENT R. 160SHIPMENT ITEM R . 167SHIPMENT SAVINGS CALCULATION R . 168SHIPMENT THROUGH POINT R . 168STATE R . 169STATUS R. 169STOP R . 170SURCHARGES R . 171TARIFF R . 172TARIFF CHARGE R. 173TARIFF CHARGE COMMON R . 175TARIFF SERVICE R . 177TARIFF SERVICE EQUIPMENT R . 180TAX ACCOUNT R . 181TAX CODE R. 181TAX RATE R . 182TAX REGISTRATION NUMBER R . 182THROUGH POINT R . 182TRANSACTION RUN R . 183TRANSPORT ORDER R . 184TRANSPORT ORDER ENTRY TYPE R (Shipment Type) . 187TRANSPORT ORDER ENTRY VER R (Shipment Version). 188TRIP R . 189VOUCHER AP R . 193VOUCHER AR R . 195VOUCHER RUN R . 197VOUCHER RUN EXCEPTION R. 1976Transportation Manager Data Dictionary

ContentsVOUCHER VERSION AP R.198VOUCHER VERSION AR R .199WEIGHT BY FREIGHT CLASS R.200ZONE R.200ZONE GROUP R .201Index . 203Transportation Manager Data Dictionary7

Contents8Transportation Manager Data Dictionary

Chapter 1IntroductionWelcome to the Data Dictionary for Transportation Manager. This document containsthe business views and their associated columns for Transportation Manager. Theseread-only views are for users who need to create custom reports according to theirspecific business needs.Before using the Data Dictionary, you should be familiar with the layout of thisdictionary. You must also understand the terminology used within this dictionary.Understanding the Data Dictionary FormatThe Data Dictionary is organized in the following hierarchy:Views (Tables) Columns FieldsFor example:ADDRESS R Name ADDR IDBusiness ViewsA view (or report) is a set of columns linked together in a table for a common businesspurpose. All the tables have the same four columns. Each column contains variousfields.The primary keys are listed first, in bold. Once a primary key exists, the field willhave a unique value within its view. The remaining fields are listed alphabetically.The following describes each view column.NameThe name of the column.NullThis can be one of two values:lN – This column is mandatory and will always contain data.lY – This column can have a null entry (no data present).Transportation Manager Data Dictionary9

IntroductionType(Size)The type of variable that you entered into this column. It is one of the following:CHAR(Size) – Fixed length character data. The entered data must be equal to or lessthan Size. If the entered data is shorter than Size, then the data will be padded withtrailing blanks until the column length equals Size.DATE – Day, month, and year data. The standard format for all entries of this variabletype is DD-MM-YY. For example, you would enter February 15, 1999 as 15-02-99.You can change this format based on the format setting in your reporting program.VARCHAR2(Size) – Variable length character data. The entered data must be equalto or less than the given Size. If the entered data is less than Size, then the stored datawill be the same length as the data you have entered. It will

Australian Patent No. 692929 Australian Patent No. 708311 Australian Patent No. 709987 Australian Patent No. 710420 Australian Patent No. 711699 Australian Patent No. 712238 Australian Patent No. 728154 Australian Patent No. 731197 PATENTED NO. EP0752134 PATENTED NO.