General John Deere DBS Setup

Note

This site is only available in English.

Introduction
General Tasks
DBS Setup Tables — Step 1
DBS Setup Tables — Step 2

Individual Setup Tables

Introduction

Dear Readers,

We are pleased to provide you with this document.

The transfer, publication or duplication of this document is only permitted with the explicit permission of TRASER Software GmbH.

Your contacts from our teams will be happy to help you. Ask us!

Your

TRASER Software GmbH

General Tasks

New Company

Create a new company in the environment:

Back to parent section

Change Upload Size in Service Tier

Change upload size for the main service tier to import bigger files (i.e.,price files) as standard NAV setup will support.

Back to parent section

Job Queues

The following setup should be done and verified with the customer:

Description	Object Type to Run	Object ID to Run
DS TempVision Absences	Codeunit	2087676
JD JQueue Import Price List	Codeunit	5446273
Erledigte Verk.-Rekl. löschen	Report	6651
Calc. Average Hours per Job	Codeunit	5446254
Erledigte Eink.-Rekl. löschen	Report	6661
JD Autom. Warr. Claims Update	Codeunit	5446238
An Parts Locator exportieren	Report	5446213
Create Service Notifications	Codeunit	5446244
JD Import Price List	Report	5445565
Import John Deere Document	Report	5446210
Import JD Prism Documents	Codeunit	5446205
JD JQueue Apply Price List	Codeunit	5446274
Import Parts Receipts	Report	5446211
JD Link Management	Codeunit	5446190
GfK Export	Codeunit	5446200
OKTA Acces Token Aktualisierung	Codeunit	5446278
Delete Invoiced Purch. Orders	Report	499
DPM Stock Mgt. exportieren	Report	5446207
Export PM Manage Data	Report	5446217
JD TS Program Import	Codeunit	5446234
Update JD Link Machines	Report	5446191
Imp. Electr. Requsitions	Report	5446208
Delete Invoiced Sales Orders	Report	299
Delete Invoiced Service Orders	Report	5914

Back to parent section

Profiles

We are providing several default profiles which can be imported via XML files:

Profile ID	Description	Role Center ID
JD GRP PARTS MGR	Group Parts Mgr.	5445826
JD SALES MGR	Sales Mgr.	5445820
JD SERVICE MGR	Service Mgr.	5445801

Back to parent section

Add-ins

To use our database with every feature regarding external dll files you need to add the Addins_NAV2018 ZIP file to your local Add-ins folder.

Note

Please contact your contact at TRASER Software GmbH to receive the corresponding ZIP file.

Some JavaScript Add-Ins in John Deere DBS are based on external sources and need to be activated in the Control Add-ins table in John Deere DBS:

Add-in Name	Public Key Token	Version	Description
BingMapsControlAddInTSR	002c3825efea3d39	1	BingMaps TSR v8
Traser.SignPad	73b7e3b0b8b5d31d	1.0.0.0	Traser SignPad
Traser.TextMultiline	5c43745699c5fbf6	1.0.0.0	Traser Text Multiline
Traser.TimeTrackingControl	f0af86fc67e61a75	1.2.0.0	Traser Time Tracking Control
TRASERSoftwareAdvancedSearch	af894113833ff819	1.0.0.0	TRASER Software Advanced Search
TSRChecklist	910e5c15ddb7a874		CheckLists

(see Control Add-ins Resources ZIP file)

Note

Please contact your contact at TRASER Software GmbH to receive the corresponding ZIP file.

Back to parent section

Permission Sets

We are supplying several default permission sets which can be added to the current database by using the corresponding function in TRASER Setup Ribbon Batch Jobs:

The result in the corresponding table is:

Permission Set	Name
TSR-ADVANCE	TRASER Advanced User
TSR-ALL-LOGIN	TRASER User Login
TSR-ALL-SETUP	TRASER Setup Tables
TSR-BASIC	TRASER Basic Permissions
TSR-DIME	TRASER Dime.Scheduler
TSR-DIM-UPDATE	TRASER Dimension Update
TSR-ES-FLADS	TRASER Easy Security FLADS
TSR-RNT	TRASER Rental
TSR-RNT-BASIC	TRASER Rental Basic
TSR-SRV-CALC	TRASER Calculation modify
TSR-SRV-FINANCE	TRASER Financing modify
TSR-SRV-SERVICE-IC	TRASER Service Intercompany
TSR-SRV-SERVITEM	TRASER Service Item modify
TSR-SRV-SN-CHANGE	TRASER Serial No. Change
TSR-SRV-TIMEMGT	TRASER Time Management
TSR-SRV-WARRANTY	TRASER Warranty modify
TSR-TRD-ASSOCIATION	TRASER Association modify
TSR-TRD-CATALOG	TRASER Catalog Manager modify
TSR-TRD-COMMISSION	TRASER Commission modify
TSR-TRD-ELO	TRASER ELO
TSR-TRD-MASTERDATA	TRASER Master Data modify
TSR-TRD-POS	TRASER Point Of Sale modify
TSR-TRD-PRICES	TRASER Item Prices modify
TSR-TRD-PURCH-ITEM	TRASER Purchase & Item modify
TSR-USER-SETUP	TRASER User Setup

Back to parent section

User Groups

We have predefined user groups which can be used, modified or enhanced individually. The default values are added by using the corresponding function in TRASER Setup Ribbon Batch Jobs:

The result in hierarchical sorting is shown in the table below. Hierarchical sorting means that the results are shown in that order that the highest user group has the less permission sets assigned and is always a subsequence of the following user group:

Code	Name
READ	Only Read Permissions
PERSONINCHARGE	Person in Charge & Salesman
PIC+MASTERDATA	Person in Charge + Master Data
PIC+MASTER+CAT	PiC + MD + CI
FINANCIAL	Financial Accountant
FINANCIAL_FA	Financial Acc. + Fixed Assets
SUPER_DATA	Super (without admins)

Back to parent section

DBS Setup Tables — Step 1

The first impelementation step for the setup tables will be supplied by TRASER and/or JD predefinition. There are several steps to be considered by implementing predefined values. So, in the following abstract we will show how to add the default values regarding a predefined sorting.

Tip

All of the following tables can be imported via RapidStart packages. For this, proceed as follows:

Download the RapidStart package (DBS STEP 1.rapidstart) from TRASER Sharepoint (You must be a member of the TRASER JD DBS Partnerchannel.).

Open the Configuration Packages page in John Deere DBS.

In the header, click on HOME > Import Package.

Select the RapidStart package DBS STEP 1.rapidstart and confirm.

In the header, click on HOME > Apply Package.

The package is now applied, and the values are automatically entered.

Note

In case a value in the tables states the value true, the corresponding check box is selected.
In case a value in the tables states the value false, the corresponding check box is cleared.

Sorting	Table ID	Table Name	Comment/Dependent on
1	8	Language
1	9	Country/Region
1	42	Rounding Method
1	50	Accounting Period	Accounting period needs to be set up with the dealer. Typically dealers follow the John Deere Fiscal Year that begins with November.
1	77	Report Selections	Prefilled with TRASER Reports
1	98	General Ledger Setup
1	204	Unit of Measure	Default NAV UoM
1	230	Source Code	Predefined by Company Initialize… & predefined for Rental Module
1	231	Reason Code
1	244	Req. Wksh. Template
1	308	No. Series
1	348	Dimension
1	801	Online Map Parameter Setup
1	5053	Business Relation
1	5063	Interaction Group
1	5094	Close Opportunity Code
1	5212	Employee Statistics Group
1	5220	Human Resource Unit of Measure
1	5719	Nonstock Item Setup
1	5720	Manufacturer	(TRASER Setup)
1	5721	Purchasing
1	5722	Item Category
1	5814	Inventory Period
1	5904	Service Item Group
1	5928	Service Status Priority Setup
1	6502	Item Tracking Code
1	6635	Return Reason
1	7600	Base Calendar
1	8618	Config. Template Header
1	5445557	TRASER License Information	Not to be changed by end-user
1	5445579	Order Type
1	5445585	Communication Type
1	5445605	Other Credit - Material Codes
1	5445654	Service Item Status
1	5445664	Service Item Data in Document
1	5445685	Series
1	5445754	Counter Type
1	5446015	Warranty Claim Type
1	5446016	Warranty Failure Mode
1	5446017	Warranty Ownership Status
1	5446018	Warranty Downtime
1	5446020	Warranty Service Interval
1	5446024	Warranty Use Indicator
1	5446161	Quote Status
1	5446165	Warranty Type
1	5446186	Service Location
1	5446208	JD Interface
1	5446209	JD Field
1	5446215	JD Quote Lost Reason
1	5446218	JD Quote Status
1	5446225	JD Critical Code
1	5446229	JD Import Selection
1	5446236	JD Magazine
1	5446237	JD Branch
1	5446243	JD PIP Type
1	5446244	JD Policy Allowance Type
1	5446247	JD Category
1	5446250	JD Base Machine Code
1	15000606	EQM Rental Text
1	15000634	EQM Object Price Term
1	15000745	EQM Report Selections
1	15000751	EQM Rental Codes Setup
1	15000752	EQM Rental Cal. Codes Setup

Back to parent section

Table 8 — Language

Code	Name	Windows Language ID
DEU	German (Germany)	1031
ENG	English (United Kingdom)	2057
ENU	English (USA)	1033
NLD	Dutch (Netherlands)	1043

Back to parent section

Table 9 — Country/Region

Code	Name	EU Country/Region Code	Intrastat Code	Address Format	Contact Address Format	VAT Scheme
AE	United Arab Emirates			City+Post Code	After Company Name
AT	Austria	AT	AT	Post Code+City	After Company Name	AT:VAT
AU	Australia			City+County+Post Code	After Company Name
BE	Belgium	BE	BE	Post Code+City	After Company Name	BE:VAT
BG	Bulgaria	BG	BG	City+County+Post Code	After Company Name	BG:VAT
BN	Brunei Darussalam			City+Post Code	First
BR	Brazil			City+Post Code	First
CA	Canada			City+Post Code	After Company Name
CH	Switzerland			Post Code+City	After Company Name
CN	China			Post Code+City	First
CY	Cyprus	CY	CY	Post Code+City	After Company Name	CY:VAT
CZ	Czech Republic	CZ	CZ	Post Code+City	After Company Name	CZ:VAT
DE	Germany	DE	DE	Post Code+City	After Company Name	DE:VAT
DK	Denmark	DK	DK	Post Code+City	After Company Name	DK:SE
DZ	Algeria			Post Code+City	After Company Name
EE	Estonia	EE	EE	Post Code+City	After Company Name	EE:VAT
EL	Greece	EL	EL	Post Code+City	After Company Name
ES	Spain	ES	ES	Post Code+City	After Company Name	ES:VAT
FI	Finland	FI	FI	Post Code+City	After Company Name
FJ	Fiji Islands			City+Post Code	First
FR	France	FR	FR	Post Code+City	After Company Name	FR:SIRET
GB	Great Britain	GB	GB	City+Post Code	After Company Name	GB:VAT
HR	Croatia	HR	HR	Post Code+City	After Company Name	HR:VAT
HU	Hungary	HU	HU	City+Post Code	After Company Name	HU:VAT
ID	Indonesia			Post Code+City	After Company Name
IE	Ireland	IE	IE	City+County+Post Code	After Company Name	IE:VAT
IN	India			City+Post Code	First
IS	Iceland			Post Code+City	After Company Name
IT	Italy	IT	IT	Post Code+City	After Company Name	IT:VAT
JP	Japan			City+Post Code	First
KE	Kenya			Post Code+City	After Company Name
LT	Lithuania	LT	LT	Post Code+City	After Company Name	LT:VAT
LU	Luxembourg	LU	LU	Post Code+City	After Company Name	LU:VAT
LV	Latvia	LV	LV	Post Code+City	After Company Name	LV:VAT
MA	Morocco			Post Code+City	After Company Name
ME	Montenegro			Post Code+City	After Company Name	ME:VAT
MT	Malta	MT	MT	Post Code+City	After Company Name	MT:VAT
MX	Mexico			City+County+Post Code	After Company Name
MY	Malaysia			Post Code+City	After Company Name
MZ	Mozambique			Post Code+City	After Company Name
NG	Nigeria			City+Post Code	After Company Name
NL	Netherlands	NL	NL	Post Code+City	After Company Name	NL:VAT
NO	Norway			Post Code+City	After Company Name	NO:VAT
NZ	New Zealand			City+Post Code	After Company Name
PH	Philippines			Post Code+City	After Company Name
PL	Poland	PL	PL	Post Code+City	After Company Name	PL:VAT
PT	Portugal	PT	PT	Post Code+City	After Company Name	PT:VAT
RO	Romania	RO	RO	Post Code+City	After Company Name	RO:VAT
RS	Serbia			Post Code+City	After Company Name	RS:VAT
RU	Russia			City+Post Code	Last
SA	Saudi Arabia			City+Post Code	First
SB	Solomon Islands			City+Post Code	First
SE	Sweden	SE	SE	Post Code+City	After Company Name	DK:SE
SG	Singapore			City+Post Code	After Company Name
SI	Slovenia	SI	SI	Post Code+City	After Company Name	SI:VAT
SK	Slovakia	SK	SK	Post Code+City	After Company Name	SK:VAT
SZ	Swaziland			City+Post Code	After Company Name
TH	Thailand	AT		Post Code+City	After Company Name
TN	Tunisia			Post Code+City	After Company Name
TR	Turkey	BE		Post Code+City	First	TR:VAT
TZ	Tanzania	BG		Post Code+City	After Company Name
UG	Uganda			City+Post Code	After Company Name
US	USA			City+County+Post Code	After Company Name
VU	Vanuatu			City+Post Code	First
WS	Samoa			City+Post Code	First
ZA	South Africa			City+Post Code	First

Back to parent section

Table 42 — Rounding Method

Code	Minimum Amount	Amount Added Before	Type	Precision	Amount Added After
DEFAULT	0	0	Nearest	0.01	0

Back to parent section

Table 50 — Accounting Period

Accounting period needs to be set up with the dealer. Typically dealers follow the John Deere Fiscal Year that begins with November.

Back to parent section

Table 77 — Report Selections

This is the recommended report selection in John Deere DBS. A lot of reports have customizations. Check with the dealer if further modifications are needed to the standard John Deere DBS report layouts.

Usage	Sequence	Report ID	Use for Email Attachment	Use for Email Body	Email Body Layout Type
S.Quote	1	5445857	True	False	Custom Report Layout
S.Order	1	5445858	True	False	Custom Report Layout
S.Invoice	1	5445859	True	False	Custom Report Layout
S.Cr.Memo	1	5445860	True	False	Custom Report Layout
S.Test	1	202	True	False	Custom Report Layout
P.Quote	1	5445867	True	False	Custom Report Layout
P.Order	1	5445868	True	False	Custom Report Layout
P.Invoice	1	5445869	True	False	Custom Report Layout
P.Cr.Memo	1	5445870	True	False	Custom Report Layout
P.Receipt	1	5445871	True	False	Custom Report Layout
P.Ret.Shpt.	1	5445873	True	False	Custom Report Layout
P.Test	1	402	True	False	Custom Report Layout
B.Stmt	1	1407	True	False	Custom Report Layout
B.Recon.Test	1	1408	True	False	Custom Report Layout
B.Check	1	1401	True	False	Custom Report Layout
Reminder	1	5445890	True	False	Custom Report Layout
Fin.Charge	1	5445891	True	False	Custom Report Layout
Rem.Test	1	122	True	False	Custom Report Layout
F.C.Test	1	123	True	False	Custom Report Layout
Prod.Order	1	99000762	True	False	Custom Report Layout
S.Blanket	1	210	True	False	Custom Report Layout
P.Blanket	1	410	True	False	Custom Report Layout
M1	1	99000762	True	False	Custom Report Layout
M2	1	99000765	True	False	Custom Report Layout
M3	1	99000788	True	False	Custom Report Layout
Inv1	1	5445884	True	False	Custom Report Layout
Inv2	1	5445885	True	False	Custom Report Layout
Inv3	1	5445886	True	False	Custom Report Layout
SM.Quote	1	5445877	True	False	Custom Report Layout
SM.Order	1	5445878	True	False	Custom Report Layout
SM.Invoice	1	5445879	True	False	Custom Report Layout
SM.Credit Memo	1	5445880	True	False	Custom Report Layout
SM.Contract Quote	1	5972	True	False	Custom Report Layout
SM.Contract	1	5445874	True	False	Custom Report Layout
SM.Test	1	5915	True	False	Custom Report Layout
S.Return	1	5445864	True	False	Custom Report Layout
P.Return	1	5445872	True	False	Custom Report Layout
S.Shipment	1	5445861	True	False	Custom Report Layout
S.Ret.Rcpt.	1	5445865	True	False	Custom Report Layout
S.Work Order	1	752	True	False	Custom Report Layout
Invt.Period Test	1	1004	True	False	Custom Report Layout
SM.Shipment	1	5445881	True	False	Custom Report Layout
S.Test Prepmt.	1	212	True	False	Custom Report Layout
P.Test Prepmt.	1	412	True	False	Custom Report Layout
S.Arch.Quote	1	215	True	False	Custom Report Layout
S.Arch.Order	1	216	True	False	Custom Report Layout
P.Arch.Quote	1	415	True	False	Custom Report Layout
P.Arch.Order	1	416	True	False	Custom Report Layout
S.Arch.Return	1	418	True	False	Custom Report Layout
P.Arch.Return	1	417	True	False	Custom Report Layout
Asm.Order	1	902	True	False	Custom Report Layout
P.Asm.Order	1	910	True	False	Custom Report Layout
S.Order Pick Instruction	1	5445887	True	False	Custom Report Layout
C.Statement	1	1316	True	False	Custom Report Layout
S.Invoice Draft	1	1303	True	False	Custom Report Layout
Pro Forma S. Invoice	1	5445863	True	False	Custom Report Layout
S.Arch.Blanket	1	5176	True	False	Custom Report Layout
P.Arch.Blanket	1	5174	True	False	Custom Report Layout
Phys.Invt.Order Test	1	5877	True	False	Custom Report Layout
Phys.Invt.Order	1	5875	True	False	Custom Report Layout
P.Phys.Invt.Order	1	5876	True	False	Custom Report Layout
Phys.Invt.Rec.	1	5445901	True	False	Custom Report Layout
P.Phys.Invt.Rec.	1	5445902	True	False	Custom Report Layout

Back to parent section

Table 98 — General Ledger Setup

This is an example general ledger setup we recommend using with John Deere DBS. Obviously, values like local currency are up to the choice and needs of the dealer.

Primary Key	Allow Posting From	Allow Posting To	Register Time	Pmt. Disc. Excl. VAT	Unrealized VAT	Adjust for Payment Disc.	Mark Cr. Memos as Corrections	Local Address Format	Inv. Rounding Precision (LCY)	Inv. Rounding Type (LCY)	Local Cont. Addr. Format	Bank Account Nos.	Summarize G/L Entries	Amount Decimal Places	Unit-Amount Decimal Places	Additional Reporting Currency	VAT Tolerance %	EMU Currency	LCY Code	VAT Exchange Rate Adjustment	Amount Rounding Precision	Unit-Amount Rounding Precision	Appln. Rounding Precision	Global Dimension 1 Code	Global Dimension 2 Code	Shortcut Dimension 1 Code	Shortcut Dimension 2 Code	Shortcut Dimension 3 Code	Shortcut Dimension 4 Code	Shortcut Dimension 5 Code	Shortcut Dimension 6 Code	Shortcut Dimension 7 Code	Shortcut Dimension 8 Code	Max. VAT Difference Allowed	VAT Rounding Type	Pmt. Disc. Tolerance Posting	Payment Discount Grace Period	Payment Tolerance %	Max. Payment Tolerance Amount	Adapt Main Menu to Permissions	Allow G/L Acc. Deletion Before	Check G/L Account Usage	Payment Tolerance Posting	Pmt. Disc. Tolerance Warning	Payment Tolerance Warning	Last IC Transaction No.	Bill-to/Sell-to VAT Calc.	Acc. Sched. for Balance Sheet	Acc. Sched. for Income Stmt.	Acc. Sched. for Cash Flow Stmt	Acc. Sched. for Retained Earn.	Tax Invoice Renaming Threshold	Print VAT specification in LCY	Prepayment Unrealized VAT	Use Legacy G/L Entry Locking	Payroll Trans. Import Format	VAT Reg. No. Validation URL	Local Currency Symbol	Local Currency Description	Show Amounts	SEPA Non-Euro Export	SEPA DD Export Without IBAN And SWIFT
			False	False	False	True	False	Post Code+City	0.01	Nearest	After Company Name		False	2:2	2:5		0	False		No Adjustment	0.01	0.00001	0	PROFIT CENTRE	LOCATION/OUTLET	PROFIT CENTRE	LOCATION/OUTLET	BRAND	FAMILY	MODEL	CUSTOMERTYPE		COMMODITY	0	Nearest	Payment Tolerance Accounts		0	0	True		True	Payment Tolerance Accounts	False	False	0	Sell-to/Buy-from No.	M-BALANCE	M-INCOME	M-CASHFLOW	M-RETAIND	0	True	True	True					All Amounts	False	False

Important

Some of the fields are predefined in John Deere DBS and should not be modified individually.

Back to parent section

Table 204 — Unit of Measure

This table is used to store default unit of measure codes for John Deere DBS.

Back to parent section

Table 230 — Source Code

A RapidStart package delivers a predefined set of source codes used in John Deere DBS. These are mainly default values as known from the CRONUS standard company.

Back to parent section

Table 231 — Reason Code

Code	Description	Reason Code for Lost Orders	Lost Sales - Cue 1	Lost Sales - Cue 2	Lost Sales - Cue 3
COM	Communication Issue	False	False	False	False
FAWIZ	FA Wizard	False	False	False	False
NO AVA	Not available	False	False	False	True
NO STOCK	No Stock	False	False	False	False
OTHERS	Others	False	False	False	False
POST	Purchase posted	False	False	False	False
TOO EXP	Too expensive	False	False	False	True
UNKNOWN	Unknown	False	False	False	True
WIP	Work In Progress	False	False	False	False
WON	Won	False	False	False	False

Back to parent section

Table 244 — Req. Wksh. - Template

Requisition Worksheet Templates are used a lot for several processes throughout John Deere DBS, but there is no additional functionality in the templates itself.

Back to parent section

Table 258 — Transaction Type

Transaction Types are used as in standard Microsoft Dynamics Business Central. These are included in the RapidStart package but do not deviate from a normal CRONUS company.

Back to parent section

Table 308 — No. Series

The No. Series table of the RapidStart package contains default recommendations set up for number series. These will be used in later setups. Of course, the No. Series lines, etc. can be set up according to the customer. The content of the RapidStart package can be used as a demo setup.

Back to parent section

Table 348 — Dimension

Code	Name	Code Caption	Filter Caption	Blocked
BRAND	Brand	Brand Code	Brand Filter	False
COMMODITY	Commodity	Commodity Code	Commodity Filter	False
CUSTOMERGROUP	Customer Group	Customergroup Code	Customergroup Filter	False
CUSTOMERTYPE	Customer Type	Customertype Code	Customertype Filter	False
FAMILY	Family	Family Code	Family Filter	False
LOCATION/OUTLET	Location/Outlet	Location/outlet Code	Location/outlet Filter	False
MACHINE	Machine	Machine Code	Machine Filter	False
MODEL	Model	Model Code	Model Filter	False
PRODUCTGROUP	Product Group	Productgroup Code	Productgroup Filter	False
PROFIT CENTRE	Profit Centre	Profit centre Code	Profit centre Filter	False
RENTALTARIFF	Rental Tariff	Rentaltariff Code	Rentaltariff Filter	False
SALESCAMPAIGN	Sales Campaign	Salescampaign Code	Salescampaign Filter	False
SALESPERSON	Salesperson	Salesperson Code	Salesperson Filter	False
VARIANT	Variant	Variant Code	Variant Filter	False

Back to parent section

Table 801 — Online Map Parameter Setup

John Deere DBS relies on Bing Maps as default Online Map Setup. This is for example used in telemetry functionality regarding machines and service orders.

Code	Name	Map Service	Directions Service	Comment	URL Encode Non-ASCII Chars	Miles/Kilometers Option List	Quickest/Shortest Option List	Directions from Location Serv.	BingMap API Key	Latitude and Longitude Service	BingMap Type Response
BING	Bing Maps	`http://bing.com/maps/default.aspx?where1={1}+{2}+{6}&v=2&mkt={7}`	`http://bing.com/maps/default.aspx?rtp=adr.{1}+{2}+{6}~adr.{1}+{2}+{6}&v=2&mkt={7}&rtop={9}~0~0`	`http://go.microsoft.com/fwlink/?LinkId=519372`	True		0,1	`http://bing.com/maps/default.aspx?rtp=pos.{10}\_{11}~adr.{1}+{2}+{6}&v=2&mkt={7}&rtop={9}~0~0`	`AldaIARJrTWwganBF8wVi3hyK2UV-YdtHFBSyXcHbP4iv6i7zq\_P0HbU9aNcJtdW`	`http://dev.virtualearth.net/REST/v1/Locations/`	xml

Back to parent section

Table 5053 — Business Relation

Only default Microsoft values are used here (Customer, Vendor, Bank).

Back to parent section

Table 5063 — Interaction Group

Only two Interaction Group entries are needed for John Deere DBS functionality: DOC and SYSTEM:

Code	Description
DOC	Documents
SYSTEM	System Generated Entries

Back to parent section

Table 5094 — Close Opportunity Code

Code	Description	Type
AVAILABLE	Product availability	Lost
LOYALTY	Loyalty to competitor brand or dealer	Lost
OTHERS	Others	Lost
QUALITY	Product quality	Lost
RATIO	Price value ratio	Lost
SPECS	Product specifications, features or attachments	Lost
SUPPORT	Customer support	Lost
TRADE-IN	Trade-in offer	Lost

Back to parent section

Table 5212 — Employee Statistics Group

Code	Description
14DAYS	Salaried (Twice Monthly)
HOUR	Hourly Wages
MONTH	Salaried (Monthly)

Back to parent section

Table 5220 — Human Resource Unit of Measure

Code	Qty. per Unit of Measure
DAY	1
HOUR	0.125

Back to parent section

Table 5719 — Nonstock Item Setup

As shown in the screenshot above, the marked fields with the red rectangle are predefined in John Deere DBS and should not be modified individually.

Back to parent section

Table 5720 — Manufacturer

Code	Name	Default Item Disc. Group
ACC	ACCORD	ACC
AEB	AEBI	AEB
AGC	AG-CHEM	AGC
AGF	AGRIFAC	AGF
AGI	AGRIO KREMZE	AGI
AGM	AGROMEHANIKA	AGM
AGO	AGCO	AGO
AGR	AGRIA	AGR
AGU	AGUIRRE	AGU
AHL	AHLMANN	AHL
ALC	ALANCO	ALC
ALE	ALLET	ALE
ALL	ALLAN	ALL
ALO	ALO	ALO
ALP	ALPINA	ALP
ALT	ALTHAUS	ALT
AMZ	AMAZONE	AMZ
APC	APACHE	APC
ARC	Arctic Cat	ARC
ATC	ARTEC	ATC
ATE	AGUAS TENIAS	ATE
ATK	ATKO	ATK
AUT	AUTOFARM	AUT
BAR	BARIGELLI	BAR
BAS	BASAK	BAS
BAT	BATEMAN	BAT
BEC	BECKER	BEC
BEG	BEGUER	BEG
BEL	BELARUS	BEL
BEN	BENASSI	BEN
BER	BERTHOUD	BER
BEY	BEYNE	BEY
BIZ	BIZON	BIZ
BLA	BLANCHARD	BLA
BOG	BOGBALLE	BOG
BOU	BOURGAULT	BOU
BRI	BRILL	BRI
BRN	Baroness	BRN
BRU	BRUMI	BRU
BUC	BUCHER	BUC
BUH	BUHLER	BUH
CAG	CARRAY GIRARDOU	CAG
CAP	CAPELLO	CAP
CAR	CARRARO	CAR
CAS	CASE	CAS
CAT	CATERPILLAR	CAT
CEL	CELMAK	CEL
CGN	CASTLEGARDEN	CGN
CHA	CHARTERHOUSE	CHA
CHD	CHD EEFFTING	CHD
CHF	CHAFER	CHF
CHL	CHALLENGER	CHL
CHT	CHTZ	CHT
CLA	CLAAS	CLA
CLN	CLEANACRES	CLN
COR	COREMASTER	COR
CRU	CARUELLE	CRU
CUS	CUSHMAN	CUS
DAB	DAVID BROWN	DAB
DAL	DAL-BO	DAL
DAM	DAMMANN	DAM
DAN	DANFOIL	DAN
DER	DEROT	DER
DES	DESAPARECIDA	DES
DEV	DELVANO	DEV
DEX	DEXHEIMER	DEX
DON	DONNSTETT	DON
DOP	DOPPSTADT	DOP
DOU	DOUVEN	DOU
DUB	DUBEX	DUB
DUR	DURO DAKOVIC	DUR
EBR	EBRO	EBR
EIC	EICHER	EIC
ERK	ERKUNT	ERK
ETE	ETESIA	ETE
EVR	EVRARD	EVR
FAR	FARMET	FAR
FAU	FAUCHEUX	FAU
FDT	FENDT	FDT
FEA	FERRARI	FEA
FEL	FELLA	FEL
FER	FERRAG	FER
FIA	FIATAGRI	FIA
FIM	FIMAKS	FIM
FIS	FISCHER	FIS
FLI	FLIEGEL	FLI
FNH	FORD NEW HOLLAND	FNH
FOR	FORTSCHRITT	FOR
FRI	FRICK	FRI
FRO	FROST	FRO
FTI	FANTINISRL	FTI
FXC	Flexi-Coil	FXC
GAL	GALLIGNANI	GAL
GAM	GAMBETTI	GAM
GAN	GANGS	GAN
GAS	GASPARDO	GAS
GEF	GERINGHOFF	GEF
GFR	GIANNI FERRARI	GFR
GHP	GRASHOPPER	GHP
GLL	GRILLO	GLL
GMR	GM-R	GMR
GOL	GOLDONI	GOL
GOM	GOMSELMASH	GOM
GPL	GREAT PLAINS	GPL
GRB	GREGOIR BESSON	GRB
GRI	GRIMME	GRI
GRL	GREENLAND	GRL
GRO	GROUNDSMAN	GRO
GRU	GRUBBER	GRU
GUL	GÜLDNER	GUL
GUN	GÜNGÖR	GUN
GUT	GUTBROD	GUT
HAG	HAGIE	HAG
HAK	HAKO	HAK
HAN	HANOMAG	HAN
HAR	HARDI	HAR
HAS	HASSIO	HAS
HAT	HATTAT	HAT
HAU	HAUER	HAU
HAY	HAYTER	HAY
HER	HERDER	HER
HIL	HILKEN	HIL
HLM	HOLMER	HLM
HOL	HOLDER	HOL
HON	HONDA	HON
HOR	HORSCH	HOR
HOS	HOLSAN	HOS
HOU	HOUSEHAM	HOU
HOW	HOWARD	HOW
HSL	HUSTLER	HSL
HSM	HSM	HSM
HUN	HUNTER	HUN
HUR	HURLIMANN	HUR
HUS	HUSQVARNA	HUS
HUX	HUXLEY	HUX
HYD	HYDRAC	HYD
IDA	I.DAVID	IDA
IFA	IFA	IFA
IMT	IMT	IMT
INU	INUMA	INU
IRT	IRTEM	IRT
ISE	ISEKI	ISE
JAC	JACOBSEN	JAC
JAO	JACOBY	JAO
JAP	JAPANESE	JAP
JAT	JACTO	JAT
JCB	JCB	JCB
JD	JOHN DEERE	JD
JES	JESSERNIGG	JES
JF	JF	JF
JOS	Joskin	JOS
JSR	JONSERED	JSR
JUS	JUSCAFRESA	JUS
KAW	KAWASAKI	KAW
KCK	KÖCKERLING	KCK
KEL	KELLANDS	KEL
KEM	KEMPER	KEM
KHD	DEUTZ FAHR	KHD
KHT	KHTZ	KHT
KIN	KINZE	KIN
KIO	KIOTI	KIO
KLE	KLEINE	KLE
KLO	KONGSKILDE	KLO
KNI	KNIGHT	KNI
KNO	KNOCHE	KNO
KON	KONGSKILDE	KON
KRA	KRAMER	KRA
KRI	KRIEGER	KRI
KRO	KRONE	KRO
KRU	KRUKOWIAK	KRU
KUB	KUBOTA	KUB
KUH	KUHN	KUH
KVE	KVERNELAND	KVE
KWH	KWH	KWH
KYR	KYROWETZ	KYR
LAM	LAMBORGHINI	LAM
LAN	LANDINI	LAN
LAV	LAVERDA	LAV
LEE	LEEB	LEE
LEL	LELY	LEL
LEN	LENINGRAD	LEN
LES	LESTRADET	LES
LEY	LEYLAND	LEY
LHA	LH-AGRO	LHA
LID	LINDNER	LID
LIN	LINDMEYR	LIN
LKT	LKT	LKT
LMK	LEMKEN	LMK
LOC	LOCHMANN	LOC
LQP	LANDQUIP	LQP
LTK	LANDTECHNIK	LTK
LTS	LTS SCHÖNEBECK	LTS
MAH	MAILLEUX	MAH
MAN	MANITOU	MAN
MAT	MATBRO	MAT
MB	MERCEDES BENZ	MB
MCC	MCCORMICK	MCC
MCH	McHALE	MCH
MDW	MDW (FORTSCHRITT)	MDW
MEN	MENGELE	MEN
MER	MERLO	MER
MF	MASSEY FERGUSON	MF
MIE	MIELE	MIE
MIL	MILLER	MIL
MON	MONOSEM	MON
MOO	MOORE	MOO
MOR	MORA	MOR
MOT	Montana	MOT
MRR	MORRIS	MRR
MTD	MTD	MTD
MTR	MATROT	MTR
MTS	MTS	MTS
MTZ	MTZ	MTZ
MUL	MULTICORE	MUL
MUN	MUNCKHOFF	MUN
MUR	MURATORI	MUR
NAP	NAPO	NAP
NHL	NEW HOLLAND	NHL
NIE	NIEMEYER	NIE
NOD	NODET	NOD
NOK	NOKKA THUME	NOK
NPU	NORD PULVE	NPU
OEL	OEHLER	OEL
OLI	OLIMAC	OLI
OTH	OTHERS	OTH
OVE	OVERRUM	OVE
PAS	PASQUALI	PAS
PEL	PELLENC	PEL
PER	PERROT	PER
PIL	PILMET	PIL
POL	Polaris	POL
POR	PORSCHE	POR
POT	POTTINGER	POT
PRE	PRECICULTURE	PRE
PRO	PRODAG ZLIN	PRO
PTZ	PTZ	PTZ
PZV	PZV	PZV
RAB	RABE	RAB
RAI	RAINBIRD	RAI
RAN	RANSOMES	RAN
RAU	RAU	RAU
RCH	RAUCH	RCH
REF	REFORM	REF
REN	RENAULT	REN
RIG	RIGUAL	RIG
ROB	ROBERINE	ROB
ROS	ROSTSELMASH	ROS
RP	RP	RP
RTS	RTS	RTS
SAM	SAME	SAM
SAN	SANDS	SAN
SAX	SAXON	SAX
SBG	SBG	SBG
SCH	SCHLÜTER	SCH
SEA	SEMANATOAREA	SEA
SEG	SEGUIP	SEG
SEM	SEMEATO	SEM
SEP	SEGUIP	SEP
SHA	SCHANZLIN	SHA
SHF	SCHÄFFER	SHF
SHI	SHIBAURA	SHI
SHR	SHELBOURNE/REYNOLDS	SHR
SIE	SIEGER	SIE
SIM	SIMPLICITY	SIM
SIP	SIPMA	SIP
SIS	SISIS	SIS
SLA	SLAVUTYCH	SLA
SLH	SAME-LAMB.HÜRLIM.	SLH
SMA	SANTAMARIA	SMA
SMI	SMITCHO	SMI
SMP	SAMPO	SMP
SNO	SANO	SNO
SNW	SHINDAWA	SNW
SOL	SOLO	SOL
SPR	SPRA COUPE	SPR
STE	STEYR	STE
STI	STIGA	STI
STO	STOLL	STO
STR	STRAUTMANN	STR
SUL	SULKY	SUL
SUP	SUPERTINO	SUP
SUZ	Suzuki	SUZ
SYS	SYSTRA	SYS
TAR	TARAL	TAR
TAT	TATRA	TAT
TEC	TECNOMA	TEC
TEX	TEXTRON	TEX
TMS	TEAM SPRAYER	TMS
TOR	TORO	TOR
TRI	TRIMBLE	TRI
TRP	TORPEDO	TRP
TUM	TÜMOSAN	TUM
UNI	UNIVERSAL	UNI
URS	URSUS	URS
UZE	UZEL	UZE
VAD	VADERSTAD	VAD
VAL	VALTRA	VAL
VAM	VALMET	VAM
VAP	VALPADANA	VAP
VER	VERVAET	VER
VES	VERSATILE	VES
VIC	VICON	VIC
VIK	VIKING	VIK
VOG	VOGEL & NOOT	VOG
VTZ	VTZ	VTZ
WAL	WALKER	WAL
WAT	WATERMATION	WAT
WEI	WEIDEMANN	WEI
WEL	WELGER	WEL
WLT	WELTE	WLT
WOL	WOLF	WOL
YAM	YAMAHA	YAM
YAN	YANMAR	YAN
ZET	ZETOR	ZET
ZIP	ZIPZIP	ZIP
ZMA	ZMAJ	ZMA

Note

The Default Item Disc. Group is dependent on a setup field in TRASER Setup which can me manually modified:

If the field is set to Brand Code, the value from field Code will be automatically created as Item Disc. Group in corresponding table and added as value in the field Default Item Disc. Group.

Back to parent section

Table 5721 — Purchasing

Code	Description	Drop Shipment	Special Order	Transfer	Skip in order related requisitions
DROP SHIP	Drop Shipment	True	False	False	False
SPECIAL	Special Order	False	True	False	False
TRANSFER	Transfer	False	False	True	False

Back to parent section

Table 5722 — Item Category

Code	Parent Category	Description	Indentation	Presentation Order	Has Children	Def. Item Tracking Code	Def. Type	Def. Tariff No.
MACHINES		Machines	0	1	False		Inventory
PARTS		Parts	0	2	False		Inventory

Back to parent section

Table 5814 — Inventory Period

Inventory Periods are mandatory and corresponding with the current and future years. So, there are no default values which should be provided automatically.

Back to parent section

Table 5904 — Service Item Group

Code	Description	Sales: Create Machine	Purchase: Create Machine
30	Self-Propelled Sprayers	False	False
31	Trailed Sprayers	False	False
32	Seeders	False	False
33	Seeding Attachments	False	False
34	Planters	False	False
35	Combines Headers	False	False
36	Combines	False	False
37	Combines Miscelaneous	False	False
38	Specialty Sprayers	False	False
40	Pallet Forks	False	False
41	Large Square Balers	False	False
42	Round Balers	False	False
43	Small Square Balers	False	False
44	Spfh Headers	False	False
45	Forage Harvesters	False	False
46	Mowing Implements	False	False
47	Isg	False	False
48	Earthmoving	False	False
49	Equipment For Utility Tractors	False	False
50	Tractors	False	False
51	Loaders	False	False
52	Autonomous Mower	False	False
53	Commercial Mowing	False	False
54	Golf	False	False
55	Riding Lawn Equipment	False	False
56	Turf And Utility Implements	False	False
57	Utility Vehicles	False	False
58	Walk-Behind Products	False	False
62	Aeration And Debris Maintenance	False	False
63	Bunker Rakes	False	False
64	Commercial Front Mowers	False	False
68	Heavy Duty Gator & Attachments	False	False
70	Riding Greens Mowers	False	False
73	Roughs, Trim, And Surrounds	False	False
78	Walk Behind Greens Mowers	False	False
79	Zero Turn Mowers	False	False

Back to parent section

Table 5928 — Service Status Priority Setup

Service Order Status	Priority
Pending	Medium High
In Process	High
Finished	Low
On Hold	Medium Low

Back to parent section

Table 6502 — Item Tracking Code

Code	Description	Warranty Date Formula	Man. Warranty Date Entry Reqd.	Man. Expir. Date Entry Reqd.	Strict Expiration Posting	SN Specific Tracking	SN Info. Inbound Must Exist	SN Info. Outbound Must Exist	SN Warehouse Tracking	SN Purchase Inbound Tracking	SN Purchase Outbound Tracking	SN Sales Inbound Tracking	SN Sales Outbound Tracking	SN Pos. Adjmt. Inb. Tracking	SN Pos. Adjmt. Outb. Tracking	SN Neg. Adjmt. Inb. Tracking	SN Neg. Adjmt. Outb. Tracking	SN Transfer Tracking	SN Manuf. Inbound Tracking	SN Manuf. Outbound Tracking	SN Assembly Inbound Tracking	SN Assembly Outbound Tracking	Lot Specific Tracking	Lot Info. Inbound Must Exist	Lot Info. Outbound Must Exist	Lot Warehouse Tracking	Lot Purchase Inbound Tracking	Lot Purchase Outbound Tracking	Lot Sales Inbound Tracking	Lot Sales Outbound Tracking	Lot Pos. Adjmt. Inb. Tracking	Lot Pos. Adjmt. Outb. Tracking	Lot Neg. Adjmt. Inb. Tracking	Lot Neg. Adjmt. Outb. Tracking	Lot Transfer Tracking	Lot Manuf. Inbound Tracking	Lot Manuf. Outbound Tracking	Lot Assembly Inbound Tracking	Lot Assembly Outbound Tracking	Ignore SN Inventory Tracking
SNALL	SN all		False	False	False	True	False	False	True	True	True	True	True	True	True	True	True	True	True	True	True	True	False	False	False	False	False	False	False	False	False	False	False	False	False	False	False	False	False	False

Note

Some of the fields are predefined in John Deere DBS and should not be modified individually.
The SN Warehouse Trackingfield is indispensable regarding stock counting of machines or parts including tracking specifications per bin.

Back to parent section

Table 6635 — Return Reason

Code	Description	Inventory Value Zero	Automatic Posting
DAMAGED	Damaged in Shipment	False	False
DEFECTIVE	Defective Item	False	False
GOODWILL	Goodwill	False	False
INTERNAL	Internal Correction	False	True
NONEED	No Current Need	False	False
NOT-RECD	Not Received	False	False
ORDER	Incorrect Order Number	False	False
PRICE	Incorrect Pricing	False	False
PURCH REP	Repair Purchased Item	False	False
REMAN	Reman Parts	False	False
SALES REP	Repair Sold Item	False	False
TRADE-IN	Trade-In	False	False
WARRANTY	Warranty	False	False
WRONG	Wrong Item	False	False

Back to parent section

Table 7600 — Base Calendar

Code	Name	Days For Fraction Calculation in Rental Week	Days For Fraction Calculation in Rental Month
5D	5-Day-Calendar	0	0
7D	7 Days Calendar	0	0

Back to parent section

Table 8618 — Config. Template Header

Code	Description	Table ID	Enabled	Instance No. Series
MACHINES	Machines	27	True
PARTS	Parts	27	True

Back to parent section

Table 5445557 — TRASER License Information

TRASER License Information

Primary Key	Only Read	Activate Signpad	Activate Trackunit	Activate Kobelco Telematics	Activate Starter Pack	Extended Pack	Documents	Activate Sync-Management	Activate Contract Management	Activate John Deere Interfaces	Activate ELO Interfaces	Activate Commission Mgt.	Activate Warranty Mgt.	Activate MPO	Activate Financing Module	Activate Transport Module	Activate Ext. Service Item Attributes	Activate Checklist Module	Home Page	Activate Armada Dynamics EQM	Activate OPplus	Activate Datev	Activate Document Capture	Activate Dime.Scheduler	Activate crefodynamics	Activate CKL Cost Accounting	Activate MPS	Activate TRASER Interfaces
	False	True	False	False	True	True	True	False	False	True	False	False	True	False	False	True	True	False	`http://www.traser-software.de`	True	True	True	True	True	True	True	True	True

Important

These fields are predefined in John Deere DBS and should not be modified individually. The values above serve only as examples.

Back to parent section

Table 5445579 — Order Type

Code	Description	Purchasing Code	JD Order Type	Default Order Code	Sort Sequence in Warehouse Receipts
JD SO	JD Daily Stock Order	SPECIAL	SO	False	3
JD TS	JD TS Order	SPECIAL	TS	False	0
MD 1030	MD 10:30	SPECIAL	MD	False	1
MD TIER 2	MD T2	SPECIAL	MD	False	4
MD TIER 3	MD T3	SPECIAL	MD	False	4
NO JD DAY	OM individual order	SPECIAL		False	0
NO JD SO	OM collated order	SPECIAL		False	0
STANDARD	Standard Order	SPECIAL		False	0
TRANSFER	Transfer Order	TRANSFER		False	5

Back to parent section

Table 5445585 — Communication Type

Code	Description	Type
E-MAIL	E-Mail	E-Mail
FAX	Fax	Fax
HOMEPAGE	Homepage	Homepage
MOBILE	Mobile	Mobile
PHONE	Phone	Phone

Back to parent section

Table 5445605 — Other Credit - Material Codes

Code	Description	JD-Code
WTYSUBL1	Environmental Fees	WTYSUBL1
WTYSUBL2	Sublet	WTYSUBL2
WTYSUBL3	Refrigerant Recovery	WTYSUBL3
WTYSUBL4	Hauling (U.S. South Dakota Dealers Only)	WTYSUBL4
WTYSUBL5	Travel Distance - Kilometers	WTYSUBL5
WTYSUBL6	Travel Distance - Miles	WTYSUBL6
WTYSUBL7	Others	WTYSUBL7
WTYSUBL8	Fixed Travel	WTYSUBL8

Back to parent section

Table 5445654 — Service Item Status

Code	Description
COPIED	Copied
DAMAGED	Damaged
NEW	New
SCRAPPED	Scrapped
SOLD	Sold
USED	Used

Back to parent section

Table 5445664 — Service Item Data in Document

Table No.	Field No.	Field Name	Field Caption	Rental	Purchase	Sales	Only with Content	Sequence
5940	1	No.	No.	False	False	False	False	0
5940	2	Serial No.	Serial No.	True	True	True	True	1
5940	3	Service Item Group Code	Family	False	False	False	False	0
5940	4	Description	Description	False	False	False	False	0
5940	5	Description 2	Description 2	False	False	False	False	0
5940	6	Status	Status	False	False	False	False	0
5940	7	Priority	Priority	False	False	False	False	0
5940	8	Customer No.	Customer No.	False	False	False	False	0
5940	9	Ship-to Code	Ship-to Code	False	False	False	False	0
5940	10	Item No.	Item No.	False	False	False	False	0
5940	11	Unit of Measure Code	Unit of Measure Code	False	False	False	False	0
5940	12	Location of Service Item	Location of Machine	False	False	False	False	0
5940	13	Sales Unit Price	Sales Unit Price	False	False	False	False	0
5940	14	Sales Unit Cost	Sales Unit Cost	False	False	False	False	0
5940	15	Warranty Starting Date (Labor)	Warranty Starting Date (Labor)	False	False	False	False	0
5940	16	Warranty Ending Date (Labor)	Warranty Ending Date (Labor)	False	False	False	False	0
5940	17	Warranty Starting Date (Parts)	Warranty Starting Date (Parts)	False	False	False	False	0
5940	18	Warranty Ending Date (Parts)	Warranty Ending Date (Parts)	False	False	False	False	0
5940	19	Warranty % (Parts)	Warranty % (Parts)	False	False	False	False	0
5940	20	Warranty % (Labor)	Warranty % (Labor)	False	False	False	False	0
5940	21	Response Time (Hours)	Response Time (Hours)	False	False	False	False	0
5940	22	Installation Date	Installation Date	False	False	False	False	0
5940	23	Sales Date	Sales Date	False	False	False	False	0
5940	24	Last Service Date	Last Service Date	False	False	False	False	0
5940	25	Default Contract Value	Default Contract Value	False	False	False	False	0
5940	26	Default Contract Discount %	Default Contract Discount %	False	False	False	False	0
5940	33	Vendor No.	Vendor No.	False	False	False	False	0
5940	34	Vendor Item No.	Vendor Item No.	False	False	False	False	0
5940	47	No. Series	No. Series	False	False	False	False	0
5940	72	Vendor Item Name	Vendor Item Name	False	False	False	False	0
5940	75	Preferred Resource	Preferred Resource	False	False	False	False	0
5940	76	Variant Code	Variant Code	False	False	False	False	0
5940	85	Service Price Group Code	Service Price Group Code	False	False	False	False	0
5940	86	Default Contract Cost	Default Contract Cost	False	False	False	False	0
5940	88	Search Description	Search Description	False	False	False	False	0
5940	104	Sales/Serv. Shpt. Document No.	Sales/Serv. Shpt. Document No.	False	False	False	False	0
5940	105	Sales/Serv. Shpt. Line No.	Sales/Serv. Shpt. Line No.	False	False	False	False	0
5940	106	Shipment Type	Shipment Type	False	False	False	False	0
5940	5445557	Status (Purchase)	Status (Purchase)	False	False	False	False	0
5940	5445558	Linked With	Linked with:	False	False	False	False	0
5940	5445559	Fixed Asset No.	Fixed Asset No.	False	False	False	False	0
5940	5445562	Service Item Model Code	Model	False	False	False	False	0
5940	5445563	Service Item Model Description	Model Description	False	False	False	False	0
5940	5445564	Picture	Picture	False	False	False	False	0
5940	5445565	Status (Sales)	Status (Sales)	False	False	False	False	0
5940	5445567	HP	HP	False	False	False	False	0
5940	5445568	KW	KW	False	False	False	False	0
5940	5445569	License Plate	License Plate	False	False	False	False	0
5940	5445570	Health And Safety Measures	Health And Safety Measures	False	False	False	False	0
5940	5445571	Technical Inspection Agency	General Inspection	False	False	False	False	0
5940	5445572	Technical Inspection Agency 2	General Inspection 2	False	False	False	False	0
5940	5445573	Year of construction	Year of Construction	False	False	False	False	0
5940	5445574	Customer Machine No.	Customer Machine No.	False	False	False	False	0
5940	5445575	VDMA	VDMA	False	False	False	False	0
5940	5445576	Service Customer No.	Service Customer No.	False	False	False	False	0
5940	5445577	Responsibility Center	Responsibility Center	False	False	False	False	0
5940	5445578	Operating Hours	Operating Hours	False	False	False	False	0
5940	5445582	Purch. Order No.	Purch. Order No.	False	False	False	False	0
5940	5445583	Sales Order No.	Sales Order No.	False	False	False	False	0
5940	5445584	Receipt Date	Receipt Date	False	False	False	False	0
5940	5445585	Expected Receipt Date	Expected Receipt Date	False	False	False	False	0
5940	5445586	Vehicle Operating Lic. Vend.	Vehicle Operating License From Vendor	False	False	False	False	0
5940	5445587	Vehicle Operating Lic. Cust.	Vehicle Operating License To Customer	False	False	False	False	0
5940	5445588	Engine Ident. No.	Engine Ident. No.	False	False	False	False	0
5940	5445589	Engine Type	Engine Type	False	False	False	False	0
5940	5445590	Registration Date	Registration Date	False	False	False	False	0
5940	5445591	No. In Pre System	No. In Pre System	False	False	False	False	0
5940	5445592	Purchaser Code	Purchaser Code	False	False	False	False	0
5940	5445594	Salesperson Code	Salesperson Code	False	False	False	False	0
5940	5445596	Manufacturer Code	Brand Code	False	False	False	False	0
5940	5445597	Manufacturer Name	Brand Name	False	False	False	False	0
5940	5445598	Service Item Group Description	Family Description	False	False	False	False	0
5940	5445599	Tires (Front)	Wheels (Front)	False	False	False	False	0
5940	5445600	State Front Tires %	State Front Tires %	False	False	False	False	0
5940	5445601	Tires (Rear)	Tires (Rear)	False	False	False	False	0
5940	5445602	State Rear Tires %	State Rear Tires %	False	False	False	False	0
5940	5445603	Transmission Ident. No.	Transmission Ident. No.	False	False	False	False	0
5940	5445604	Make Tires (Front)	Make Tires (Front)	False	False	False	False	0
5940	5445605	Make Tires (Rear)	Make Tires (Rear)	False	False	False	False	0
5940	5445606	Contact No.	Contact No.	False	False	False	False	0
5940	5445617	Service Item as Service	Machine as Service	False	False	False	False	0
5940	5445618	Rental Pay Scale Group Code	Rental Pay Scale Group Code	False	False	False	False	0
5940	5445627	Own Homepage	Own Homepage	False	False	False	False	0
5940	5445628	Internet Market Place	Internet Market Place	False	False	False	False	0
5940	5445647	Shortcut Dimension 1 Code	Shortcut Dimension 1 Code	False	False	False	False	0
5940	5445648	Shortcut Dimension 2 Code	Shortcut Dimension 2 Code	False	False	False	False	0
5940	5445649	Shortcut Dimension 3 Code	Shortcut Dimension 3 Code	False	False	False	False	0
5940	5445650	Shortcut Dimension 4 Code	Shortcut Dimension 4 Code	False	False	False	False	0
5940	5445651	Shortcut Dimension 5 Code	Shortcut Dimension 5 Code	False	False	False	False	0
5940	5445652	Shortcut Dimension 6 Code	Shortcut Dimension 6 Code	False	False	False	False	0
5940	5445653	Shortcut Dimension 7 Code	Shortcut Dimension 7 Code	False	False	False	False	0
5940	5445654	Shortcut Dimension 8 Code	Shortcut Dimension 8 Code	False	False	False	False	0
5940	5445672	Direct Unit Cost	Direct Unit Cost	False	False	False	False	0
5940	5445677	Location Address	Location Address	False	False	False	False	0
5940	5445678	Location Post Code	Location Post Code	False	False	False	False	0
5940	5445679	Location City	Location City	False	False	False	False	0
5940	5445680	Current Location	Location of Machine	False	False	False	False	0
5940	5445687	Trade No.	Trade No.	False	False	False	False	0
5940	5445688	Location Code	Location Code	False	False	False	False	0
5940	5445689	Bin Code	Bin Code	False	False	False	False	0
5940	5445690	Created Item Ledg. Entry No.	Created by Item Ledg. Entry No.	False	False	False	False	0
5940	5445697	Financing Status Code	Financing Status Code	False	False	False	False	0
5940	5445698	Financing Type Code	Financing Type Code	False	False	False	False	0
5940	5445699	Financing Partner Code	Financing Partner Code	False	False	False	False	0
5940	5445700	Financing Finishing Date	Financing Finishing Date	False	False	False	False	0
5940	5445701	Purch. Receipt Date	Purch. Receipt Date	False	False	False	False	0
5940	5445702	Fixed Financing	Fixed Financing	False	False	False	False	0
5940	5445707	Wizard Step	Wizard Step	False	False	False	False	0
5940	5445708	Created by Item No.	Created by Item No.	False	False	False	False	0
5940	5445710	Def. Analysis Rev. Report Name	Def. Analysis Review Report Name for Calc. Review	False	False	False	False	0
5940	5445717	License Plate Code	License Plate Code	False	False	False	False	0
5940	5445718	Lic. Plate Country/Region Code	License Plate Country/Region Code	False	False	False	False	0
5940	5445719	Smart Farming	Smart Farming	False	False	False	False	0
5940	5445728	Base Machine Code	Base Machine Code	False	False	False	False	0
5940	5445729	Item Category Code	Item Category Code	False	False	False	False	0
5940	5445730	Status Code	Status Code	False	False	False	False	0
5940	5445732	Additional Status	Additional Status	False	False	False	False	0
5940	5445750	Differential Taxation	Differential Taxation (§25a)	False	False	False	False	0
5940	5445751	Agency Machine	Agency Machine	False	False	False	False	0
5940	5445752	G/L Account No.	G/L Account No.	False	False	False	False	0
5940	5445755	Calc. Fixed Asset No.	Calc. Fixed Asset No.	False	False	False	False	0
5940	5445757	Ownership Status	Ownership Status	False	False	False	False	0
5940	5445758	Rental Location Code	Current Rental Location Code	False	False	False	False	0
5940	5446180	Trackunit ID	Trackunit ID	False	False	False	False	0
5940	5446181	Trackunit Serial Number	Trackunit Serial Number	False	False	False	False	0
5940	5446182	Trackunit Timestamp	Timestamp	False	False	False	False	0
5940	5446183	Trackunit Hyperlink	Trackunit Hyperlink	False	False	False	False	0
5940	5446188	JD Link Telematic ID	JD Link Telematic ID	False	False	False	False	0
5940	5446189	JD Link Telematic Serial No.	JD Link Telematic Serial No.	False	False	False	False	0
5940	5446190	Kobelco Unit ID	Kobelco Telematik ID	False	False	False	False	0
5940	5446191	Kobelco Unit Serial No.	Kobelco Telematic Serial No.	False	False	False	False	0
5940	5446207	John Deere Profile Id	JD Profile Id	False	False	False	False	0
5940	5446208	Series	Series	False	False	False	False	0
5940	5446210	Contact Company No.	Contact Company No.	False	False	False	False	0
5940	5446211	Warr. Powertrain Start Date	Ext. Warranty Powertrain Starting Date	False	False	False	False	0
5940	5446212	Warr. Powertrain End Date	Ext. Warranty Powertrain Ending Date	False	False	False	False	0
5940	5446213	Warr. Comprehensive Start Date	Ext. Warranty Comprehensive Starting Date	False	False	False	False	0
5940	5446214	Warr. Comprehensive End Date	Ext. Warranty Comprehensive Ending Date	False	False	False	False	0
5940	5446217	PowerGard Deductible Amount	PowerGard Deductible Amount	False	False	False	False	0
5940	5446218	PowerGard Max. Hours	PowerGard Max. Hours	False	False	False	False	0
5940	5446219	DCP Activated	DCP Activated	False	False	False	False	0
5940	5446220	DCP Activated at	DCP Activated at	False	False	False	False	0
5940	5446225	Estimated Unit Cost	Estimated Unit Cost	False	False	False	False	0
5940	5446226	Fixed Sales Price	Fixed Sales Price	False	False	False	False	0
5940	5446230	Available for Sale	Available for Sale	False	False	False	False	0
5940	5446231	Available for Demo	Available for Demo	False	False	False	False	0
5940	5446232	Available for Rental	Available for Rental	False	False	False	False	0
5940	5446233	Summarized Information	Summarized Information	False	False	False	False	0
5940	5446234	Vendor Order No.	Vendor Order No.	False	False	False	False	0
5940	5446235	Length (cm)	Length (cm)	False	False	False	False	0
5940	5446236	Width (cm)	Width (cm)	False	False	False	False	0
5940	5446237	Height (cm)	Height (cm)	False	False	False	False	0
5940	5446238	Size (LxWxH cm)	Size (LxWxH cm)	False	False	False	False	0
5940	5446239	Gross Weight (kg)	Gross Weight (kg)	False	False	False	False	0
5940	5446313	Sub Category	Sub Group	False	False	False	False	0
5940	5446314	Sub Category No.	Sub Category No.	False	False	False	False	0
5940	5446315	Company Name	Company Name	False	False	False	False	0
5940	5446390	MPO Machine No.	MPO Machine No.	False	False	False	False	0
5940	5446391	Internet Sales Unit Price	Internet Sales Unit Price	False	False	False	False	0
5940	15000600	EQM Type	Type	False	False	False	False	0
5940	15000601	EQM Object No.	Object No.	False	False	False	False	0

Back to parent section

Table 5445685 — Series

Series will be provided with the corresponding base machine codes (BMC) by John Deere and can be imported periodically into John Deere DBS. This automation will also create all series which are marked as current in the file.

Back to parent section

Table 5445754 — Counter Type

Code	Description
OH	Operating Hours

Back to parent section

Table 5446015 — Warranty Claim Type

Code	Description	PIP	Split Payment	JD Claim Type
ZNRM	Normal Claim	False	False	ZNRM
ZPAR	Parts Claim	False	False	ZPAR
ZPEP	PEP Claim	True	True	ZPIP
ZPIP	PIP Claim	True	False	ZPIP
ZSPA	Special Allowance Claim	False	True	ZSPA
ZZBT	Battery Claim	False	False	ZZBT
ZZMK	Marketing Claim	False	False	ZZMK
ZZTK	Track Claim	False	False	ZZTK

Back to parent section

Table 5446016 — Warranty Failure Mode

Code	Description
1	Bent/Twisted/Misaligned
10	Electrical Connection
11	Electrical Failure
12	Improper Fit
13	Lack of Power
14	Leaked
15	Oil Consumption
16	Omitted/Missing
17	Other (Requires Explanation)
18	Out of Adjustment
19	Overheated
2	Blown
20	Pin Hole/Porous
21	Pressure Low/High
22	Routing
23	Scored/Grooved
24	Short/Shorted
25	Slipping
26	Software/Reprogram
27	Stripped
28	Stuck/Seized
29	Vibration
3	Broken/Cracked
30	Worn
31	Wrong Part Installed
4	Burned Out/Up
5	Calibration
6	Loose
7	Collapsed/Plugged
8	Corroded/Pitted
9	Cut

Back to parent section

Table 5446017 — Warranty Ownership Status

Code	Description
1	Sold
2	In Stock
3	Rental
4	Demo

Back to parent section

Table 5446018 — Warranty Downtime

Code	Description
10	No Downtime
20	Less than 4 Hours of Downtime
30	Less than 1 Day of Downtime
40	Greater than 1 Day of Downtime
50	Greater than 1 Week of Downtime
60	Unknown

Back to parent section

Table 5446020 — Warranty Service Interval

Code	Description
BRKN	BREAK-IN
INST	INSTALLATION
MNT1	FIRST MAINTENANCE
MNT2	SECOND MAINTENANCE
MNT3	THIRD MAINTENANCE
MNT4	FOURTH MAINTENANCE
MNT5	FIFTH MAINTENANCE
MNT6	SIXTH MAINTENANCE
MNT7	SEVENTH MAINTENANCE
MNT8	EIGHTH MAINTENANCE
PRMO	PROMOTIONAL

Back to parent section

Table 5446024 — Warranty Use Indicator

Code	Description
ACRE	Acres
D	Days
H	Hours
HECTAR	Hectares
HRS	Separator Hours
KM	Kilometers
MILE	Miles
PC	Bales

Back to parent section

Table 5446161 — Quote Status

Code	Description	Finished	Initial Value	Order Status
ACCEPTED	Quote accepted	True	False	False
CREATED	Quote created	False	True	False
DECLINED	Quote declined	False	False	False
IN PROCESS	In Process	False	False	False
ORDER	Order Status	False	False	True

Back to parent section

Table 5446165 — Warranty Type

Code	Description
B	Basic Warranty
C	Wear Assurance
D	Default Warranty
E	Engine Warranty
F	Main Frame
G	Extended Warranty (Engine)
H	Extended Warranty (Powertrain & Hydraulic)
J	JD Promise
M	Emissions Warranty
P	Extended Warranty (Powertrain)
Q	Limited Basic
S	Structureall
U	Factory Undercarriage
V	Max Life
W	Wet Turn
X	Extended Warranty (Comprehensive)

Back to parent section

Table 5446186 — Service Location

Code	Description
ESTIMATED	Called customer estimated
OUT	Site work
WAITING O/N	Waiting order number
WORKSHOP	Workshop

Back to parent section

Table 5446208 — JD Interface

Code	Description	Description 2	Filename	Interface Version
CREDITMEMO	Credit Memos	E-Mail Import
DEBITMEMO	Debit Memos	E-Mail Import
DPM_SM	DPM Stock Management	DTF Export	DLR2JD_DPMEXT_%1_%2_%3_%4.EAME	1.3
DPMORD	JDPrism Order Interface			1.0
DPMXFER	JDPrism Transfer Interface			1.0
PARTS_LOCATOR	Parts Locator	DTF Export	DLR2JD_%1_%2.DAT	1.0
PARTSADVISOR	Import Parts Advisor	Import	%1.xml	1.0
PARTSINV	Parts Invoices	E-Mail Import
PARTSRECEIPT	Parts Receipts	DTF Import
PMMANAGE	Parts Management Data	DTF Export	DLR2JD_%1%2%3_%4.DAT
PRICEFILE_DELTA	Import delta price		*.DAT
PRICEFILE_FULL	Import full price		*.DAT
REQUISITIONS	Requistion Work Sheets	DTF Import	*.EAME	1.0
TS_INTERFACE	TS Interface
TS-PROGRAM	TS-Program Import
WAITING O/N
WARRCRMEMO	Warranty Credit Memos	E-Mail Import
WHOLEGOODS	Wholegood Invoices	E-Mail Import
WORKSHOP

Back to parent section

Table 5446209 — JD Field

Interface Code	Record Type	Field No.	Fieldname	Transfer
DPM_SM	Account / Warehouse Header Rec	1	Record Code	True
DPM_SM	Account / Warehouse Header Rec	2	Dealer Account	True
DPM_SM	Account / Warehouse Header Rec	3	DBS Warehouse / Franchise	True
DPM_SM	Account / Warehouse Header Rec	4	Fiscal Month	True
DPM_SM	Account / Warehouse Header Rec	5	Next parts month-end date	False
DPM_SM	Account / Warehouse Header Rec	6	Warehouse / Franchise Type	True
DPM_SM	Account / Warehouse Header Rec	7	Where data is to be loaded	True
DPM_SM	File Header Record	1	Record Code	True
DPM_SM	File Header Record	2	Date of extract	True
DPM_SM	File Header Record	3	Time of extract	True
DPM_SM	File Header Record	4	Type of extract	True
DPM_SM	File Header Record	5	Interface Version	True
DPM_SM	File Header Record	6	DBS Name	True
DPM_SM	File Header Record	7	DBS Version	True
DPM_SM	File Header Record	8	Order Coordination data	False
DPM_SM	File Header Record	9	Transfer Coordination data	False
DPM_SM	Part Detail Record	1	Record Code	True
DPM_SM	Part Detail Record	2	Part Number	True
DPM_SM	Part Detail Record	3	Available Quantity	True
DPM_SM	Part Detail Record	4	On Order Quantity	True
DPM_SM	Part Detail Record	5	Reserve Quantity - Work Orders	True
DPM_SM	Part Detail Record	6	Reserve Quantity - Parts Tickets	True
DPM_SM	Part Detail Record	7	Current MTD Sales	True
DPM_SM	Part Detail Record	8	Current MTD Demands	True
DPM_SM	Part Detail Record	9	Current MTD Lost Sales	True
DPM_SM	Part Detail Record	10	Current MTD Lost Demands	True
DPM_SM	Part Detail Record	11	Dealer PPP (Parts Per Package)	True
DPM_SM	Part Detail Record	12	Bin location	True
DPM_SM	Part Detail Record	13	Alternate bin location	True
DPM_SM	Part Detail Record	14	Vendor Part Cost	False
DPM_SM	Part Detail Record	15	Vendor package quantity	False
DPM_SM	Part Detail Record	16	Vendor Group Code	False
DPM_SM	Part Detail Record	17	Vendor substituation information	False
DPM_SM	Part Detail Record	18	Pricing Base (JD Parts)	True
DPM_SM	Part Detail Record	19	Pricing additive (JD Parts)	True
DPM_SM	Part Detail Record	20	Dealer Price (JD Parts)	False
DPM_SM	Part Detail Record	21	Order Formula Code (OFC)	False
DPM_SM	Part Detail Record	22	Delete Indicator	False
DPM_SM	Part Detail Record	23	Reserved Hits – Work Orders	True
DPM_SM	Part Detail Record	24	Reserved Hits – Part Tickets	True
DPM_SM	Part Detail Record	25	Average Cost	True
DPM_SM	Part Detail Record	26	Start of initialization record fields	True
DPM_SM	Part Detail Record	27	Part description	True
DPM_SM	Part Detail Record	28	Dealer Part falsete	False
DPM_SM	Part Detail Record	29	Order Indicator	True
DPM_SM	Part Detail Record	30	Date Added	True
DPM_SM	Part Detail Record	31	Dealer Group Code	True
DPM_SM	Part Detail Record	32	Minimum Order Quantity	False
DPM_SM	Part Detail Record	33	Maximum Order Quantity	False
DPM_SM	Part Detail Record	34	No. of monthly history buckets incl in this record	True
DPM_SM	Part Detail Record	35	Pieces in set	False
DPM_SM	Part Detail Record	36	Sales 1 Month ago	True
DPM_SM	Part Detail Record	37	Demand 1 Month ago	True
DPM_SM	Part Detail Record	38	Lost Sales 1 Month ago	False
DPM_SM	Part Detail Record	39	Lost Demand 1 Month ago	False
DPM_SM	Part Detail Record	40	Sales 2 Months ago	True
DPM_SM	Part Detail Record	41	Demand 2 Months ago	True
DPM_SM	Part Detail Record	42	Lost Sales 2 Months ago	False
DPM_SM	Part Detail Record	43	Lost Demand 2 Months ago	False
DPM_SM	Part Detail Record	44	Sales 3 Months ago	True
DPM_SM	Part Detail Record	45	Demand 3 Months ago	True
DPM_SM	Part Detail Record	46	Lost Sales 3 Months ago	False
DPM_SM	Part Detail Record	47	Lost Demand 3 Months ago	False
DPM_SM	Part Detail Record	48	Sales 4 Months ago	True
DPM_SM	Part Detail Record	49	Demand 4 Months ago	True
DPM_SM	Part Detail Record	50	Lost Sales 4 Months ago	False
DPM_SM	Part Detail Record	51	Lost Demand 4 Months ago	False
DPM_SM	Part Detail Record	52	Sales 5 Months ago	True
DPM_SM	Part Detail Record	53	Demand 5 Months ago	True
DPM_SM	Part Detail Record	54	Lost Sales 5 Months ago	False
DPM_SM	Part Detail Record	55	Lost Demand 5 Months ago	False
DPM_SM	Part Detail Record	56	Sales 6 Months ago	True
DPM_SM	Part Detail Record	57	Demand 6 Months ago	True
DPM_SM	Part Detail Record	58	Lost Sales 6 Months ago	False
DPM_SM	Part Detail Record	59	Lost Demand 6 Months ago	False
DPM_SM	Part Detail Record	60	Sales 7 Months ago	True
DPM_SM	Part Detail Record	61	Demand 7 Months ago	True
DPM_SM	Part Detail Record	62	Lost Sales 7 Months ago	False
DPM_SM	Part Detail Record	63	Lost Demand 7 Months ago	False
DPM_SM	Part Detail Record	64	Sales 8 Months ago	True
DPM_SM	Part Detail Record	65	Demand 8 Months ago	True
DPM_SM	Part Detail Record	66	Lost Sales 8 Months ago	False
DPM_SM	Part Detail Record	67	Lost Demand 8 Months ago	False
DPM_SM	Part Detail Record	68	Sales 9 Months ago	True
DPM_SM	Part Detail Record	69	Demand 9 Months ago	True
DPM_SM	Part Detail Record	70	Lost Sales 9 Months ago	False
DPM_SM	Part Detail Record	71	Lost Demand 9 Months ago	False
DPM_SM	Part Detail Record	72	Sales 10 Months ago	True
DPM_SM	Part Detail Record	73	Demand 10 Months ago	True
DPM_SM	Part Detail Record	74	Lost Sales 10 Months ago	False
DPM_SM	Part Detail Record	75	Lost Demand 10 Months ago	False
DPM_SM	Part Detail Record	76	Sales 11 Months ago	True
DPM_SM	Part Detail Record	77	Demand 11 Months ago	True
DPM_SM	Part Detail Record	78	Lost Sales 11 Months ago	False
DPM_SM	Part Detail Record	79	Lost Demand 11 Months ago	False
DPM_SM	Part Detail Record	80	Sales 12 Months ago	True
DPM_SM	Part Detail Record	81	Demand 12 Months ago	True
DPM_SM	Part Detail Record	82	Lost Sales 12 Months ago	False
DPM_SM	Part Detail Record	83	Lost Demand 12 Months ago	False
DPM_SM	Part Detail Record	84	Sales 13 Months ago	True
DPM_SM	Part Detail Record	85	Demand 13 Months ago	True
DPM_SM	Part Detail Record	86	Lost Sales 13 Months ago	False
DPM_SM	Part Detail Record	87	Lost Demand 13 Months ago	False
DPM_SM	Part Detail Record	88	Sales 14 Months ago	True
DPM_SM	Part Detail Record	89	Demand 14 Months ago	True
DPM_SM	Part Detail Record	90	Lost Sales 14 Months ago	False
DPM_SM	Part Detail Record	91	Lost Demand 14 Months ago	False
DPM_SM	Part Detail Record	92	Sales 15 Months ago	True
DPM_SM	Part Detail Record	93	Demand 15 Months ago	True
DPM_SM	Part Detail Record	94	Lost Sales 15 Months ago	False
DPM_SM	Part Detail Record	95	Lost Demand 15 Months ago	False
DPM_SM	Part Detail Record	96	Sales 16 Months ago	True
DPM_SM	Part Detail Record	97	Demand 16 Months ago	True
DPM_SM	Part Detail Record	98	Lost Sales 16 Months ago	False
DPM_SM	Part Detail Record	99	Lost Demand 16 Months ago	False
DPM_SM	Part Detail Record	100	Sales 17 Months ago	True
DPM_SM	Part Detail Record	101	Demand 17 Months ago	True
DPM_SM	Part Detail Record	102	Lost Sales 17 Months ago	False
DPM_SM	Part Detail Record	103	Lost Demand 17 Months ago	False
DPM_SM	Part Detail Record	104	Sales 18 Months ago	True
DPM_SM	Part Detail Record	105	Demand 18 Months ago	True
DPM_SM	Part Detail Record	106	Lost Sales 18 Months ago	False
DPM_SM	Part Detail Record	107	Lost Demand 18 Months ago	False
DPM_SM	Part Detail Record	108	Sales 19 Months ago	True
DPM_SM	Part Detail Record	109	Demand 19 Months ago	True
DPM_SM	Part Detail Record	110	Lost Sales 19 Months ago	False
DPM_SM	Part Detail Record	111	Lost Demand 19 Months ago	False
DPM_SM	Part Detail Record	112	Sales 20 Months ago	True
DPM_SM	Part Detail Record	113	Demand 20 Months ago	True
DPM_SM	Part Detail Record	114	Lost Sales 20 Months ago	False
DPM_SM	Part Detail Record	115	Lost Demand 20 Months ago	False
DPM_SM	Part Detail Record	116	Sales 21 Months ago	True
DPM_SM	Part Detail Record	117	Demand 21 Months ago	True
DPM_SM	Part Detail Record	118	Lost Sales 21 Months ago	False
DPM_SM	Part Detail Record	119	Lost Demand 21 Months ago	False
DPM_SM	Part Detail Record	120	Sales 22 Months ago	True
DPM_SM	Part Detail Record	121	Demand 22 Months ago	True
DPM_SM	Part Detail Record	122	Lost Sales 22 Months ago	False
DPM_SM	Part Detail Record	123	Lost Demand 22 Months ago	False
DPM_SM	Part Detail Record	124	Sales 23 Months ago	True
DPM_SM	Part Detail Record	125	Demand 23 Months ago	True
DPM_SM	Part Detail Record	126	Lost Sales 23 Months ago	False
DPM_SM	Part Detail Record	127	Lost Demand 23 Months ago	False
DPM_SM	Part Detail Record	128	Sales 24 Months ago	True
DPM_SM	Part Detail Record	129	Demand 24 Months ago	True
DPM_SM	Part Detail Record	130	Lost Sales 24 Months ago	False
DPM_SM	Part Detail Record	131	Lost Demand 24 Months ago	False
DPM_SM	Part Detail Record	132	Sales 25 Months ago	True
DPM_SM	Part Detail Record	133	Demand 25 Months ago	True
DPM_SM	Part Detail Record	134	Lost Sales 25 Months ago	False
DPM_SM	Part Detail Record	135	Lost Demand 25 Months ago	False
DPM_SM	Part Detail Record	136	Sales 26 Months ago	True
DPM_SM	Part Detail Record	137	Demand 26 Months ago	True
DPM_SM	Part Detail Record	138	Lost Sales 26 Months ago	False
DPM_SM	Part Detail Record	139	Lost Demand 26 Months ago	False
DPM_SM	Part Detail Record	140	Sales 27 Months ago	True
DPM_SM	Part Detail Record	141	Demand 27 Months ago	True
DPM_SM	Part Detail Record	142	Lost Sales 27 Months ago	False
DPM_SM	Part Detail Record	143	Lost Demand 27 Months ago	False
DPM_SM	Part Detail Record	144	Sales 28 Months ago	True
DPM_SM	Part Detail Record	145	Demand 28 Months ago	True
DPM_SM	Part Detail Record	146	Lost Sales 28 Months ago	False
DPM_SM	Part Detail Record	147	Lost Demand 28 Months ago	False
DPM_SM	Part Detail Record	148	Sales 29 Months ago	True
DPM_SM	Part Detail Record	149	Demand 29 Months ago	True
DPM_SM	Part Detail Record	150	Lost Sales 29 Months ago	False
DPM_SM	Part Detail Record	151	Lost Demand 29 Months ago	False
DPM_SM	Part Detail Record	152	Sales 30 Months ago	True
DPM_SM	Part Detail Record	153	Demand 30 Months ago	True
DPM_SM	Part Detail Record	154	Lost Sales 30 Months ago	False
DPM_SM	Part Detail Record	155	Lost Demand 30 Months ago	False
DPM_SM	Part Detail Record	156	Sales 31 Months ago	True
DPM_SM	Part Detail Record	157	Demand 31 Months ago	True
DPM_SM	Part Detail Record	158	Lost Sales 31 Months ago	False
DPM_SM	Part Detail Record	159	Lost Demand 31 Months ago	False
DPM_SM	Part Detail Record	160	Sales 32 Months ago	True
DPM_SM	Part Detail Record	161	Demand 32 Months ago	True
DPM_SM	Part Detail Record	162	Lost Sales 32 Months ago	False
DPM_SM	Part Detail Record	163	Lost Demand 32 Months ago	False
DPM_SM	Part Detail Record	164	Sales 33 Months ago	True
DPM_SM	Part Detail Record	165	Demand 33 Months ago	True
DPM_SM	Part Detail Record	166	Lost Sales 33 Months ago	False
DPM_SM	Part Detail Record	167	Lost Demand 33 Months ago	False
DPM_SM	Part Detail Record	168	Sales 34 Months ago	True
DPM_SM	Part Detail Record	169	Demand 34 Months ago	True
DPM_SM	Part Detail Record	170	Lost Sales 34 Months ago	False
DPM_SM	Part Detail Record	171	Lost Demand 34 Months ago	False
DPM_SM	Part Detail Record	172	Sales 35 Months ago	True
DPM_SM	Part Detail Record	173	Demand 35 Months ago	True
DPM_SM	Part Detail Record	174	Lost Sales 35 Months ago	False
DPM_SM	Part Detail Record	175	Lost Demand 35 Months ago	False
DPM_SM	Part Detail Record	176	Sales 36 Months ago	True
DPM_SM	Part Detail Record	177	Demand 36 Months ago	True
DPM_SM	Part Detail Record	178	Lost Sales 36 Months ago	False
DPM_SM	Part Detail Record	179	Lost Demand 36 Months ago	False
DPM_SM	Part Detail Record	180	Sales 1 Year ago	True
DPM_SM	Part Detail Record	181	Demand 1 Year ago	True
DPM_SM	Part Detail Record	182	Lost Sales 1 Year ago	False
DPM_SM	Part Detail Record	183	Lost Demand 1 Year ago	False
DPM_SM	Part Detail Record	184	Sales 2 Years ago	True
DPM_SM	Part Detail Record	185	Demand 2 Years ago	True
DPM_SM	Part Detail Record	186	Lost Sales 2 Years ago	False
DPM_SM	Part Detail Record	187	Lost Demand 2 Years ago	False
DPM_SM	Part Detail Record	188	Sales 3 Years ago	True
DPM_SM	Part Detail Record	189	Demand 3 Years ago	True
DPM_SM	Part Detail Record	190	Lost Sales 3 Years ago	False
DPM_SM	Part Detail Record	191	Lost Demand 3 Years ago	False
DPM_SM	Part Detail Record	192	Sales 4 Years ago	True
DPM_SM	Part Detail Record	193	Demand 4 Years ago	True
DPM_SM	Part Detail Record	194	Lost Sales 4 Years ago	False
DPM_SM	Part Detail Record	195	Lost Demand 4 Years ago	False
DPM_SM	Part Detail Record	196	Sales 5 Years ago	True
DPM_SM	Part Detail Record	197	Demand 5 Years ago	True
DPM_SM	Part Detail Record	198	Lost Sales 5 Years ago	False
DPM_SM	Part Detail Record	199	Lost Demand 5 Years ago	False

Back to parent section

Table 5446215 — JD Quote Lost Reason

JD ID	Description	Close Opportunity Code
10	Product performance
11	Product availability
12	Product specifications, features or attachments
13	Product knowledge (demonstration)
14	Residual value
15	Trade-in offer
16	Loyalty to competitor brand or dealer
17	Price value ratio
18	Financing Conditions
19	Cost of ownership (parts, maintenance, service)
20	Others
7	Customer support
8	Product quality
9	Customer support

Back to parent section

Table 5446218 — JD Quote Status

ID	Description	Activity Code
1	Quoted
14	Open Project
16	Closed - Lost
17	Closed - No Buy
18	Closed - Buy UE
2	Expired
4	Sold
ID	Description

Back to parent section

Table 5446225 — JD Critical Code

Code	Description
11	Periodic Service and Consumable and/or Competitive Parts
12	Machine-Down, Less Than 2 Hours to Install
13	Dealer-Fabricated Parts
14	Machine-Down, More Than 2 Hours to Install
15	Wear/Repair
20	Product Re-Life
21	Hardware
50	Slow-Moving CC 20
51	Slow-Moving CC 11
52	Slow-Moving CC 12
54	Slow-Moving CC 14
55	Slow-Moving CC 15
90	Auto PIP
91	Optional PIP
99	Merchandised Parts

Back to parent section

Table 5446229 — JD Import Selection

ID	Type	Name
5446220	Codeunit	Initial Price List
5446221	Codeunit	Price List
5446222	Codeunit	Substitutions
5446223	Codeunit	Reman
5446224	Codeunit	Commodity Codes
5446225	Codeunit	Base Machine Codes
5446226	Codeunit	Non JD Prod Hirarachy

Back to parent section

Table 5446236 — JD Magazine

Code	Description	Include Magazine
A	Test	True
ARI	Arimai	False
B	Test Include	True
BOR	BOROZDA	True
BRA	Brazda	True
BUR	SKIBA	True
CM1	CAMPYMEC-Cultivos Extensivos	False
CM2	CAMPYMEC-Cultivos Especiales	False
FAR	FARA	True
FF1	LURF-ACKERBAU	False
FF2	FLURF-FUTTERBAU	True
FF3	FLURF-ACKERBAU (JDIN - DEX)	False
FF4	FLURF-ACKERBAU (nur 34)	False
FRN	FARAN	False
FUR	FUREN	False
FW1	FURROW ARABLEHEAD	False
FW2	FURROW MIXED FARM	False
GEE	EL ESTILO JD (ES)	False
GLA	L.APPROCHE JD (F)	False
GND	JD GolfNyt (DK)	False
GOA	JD APPROACH (E)	False
GOB	JD APPROACH (NL_B)	False
GOC	JD APPROACH (CSR)	False
GOH	JD APPROACH (NL)	False
GOI	JD APPROACH (I)	False
GON	JD GOLF NEWS (D)	False
GOY	JD GOLFNYTT (S)	False
JDR	JOHN DEERE REPORT	False
KBE	Keep GREEN (BE - NL (Fagadis))	False
KBF	KEEP GREEN (BE_F)	False
KCD	Keep GREEN (D/CH)	False
KCZ	Keep GREEN (CZECH)	False
KDE	Keep GREEN (D)	False
KDK	Keep GREEN (DK)	False
KES	KEEP GREEN (ES)	False
KEX	Keep GREEN (EEX - JDIN)	False
KFI	Keep GREEN (FIN)	False
KFR	Keep GREEN (F)	False
KGA	Keep Green (F/CH)	False
KGB	Keep GREEN (UK.IE)	False
KGD	Keep Green (D/AT)	False
KIT	Keep GREEN (IT)	False
KLX	Keep GREEN (LUX)	False
KNL	Keep GREEN (NL)	False
KSE	Keep GREEN (SE)	False
PSE	JDPS POWER SOURCE (E)	False
PSF	JDPS POWER SOURCE (F)	False
PSG	JDPS POWER SOURCE (DE)	False
PSI	JDPS POWER SOURCE (IT)	False
PSS	JDPS POWER SOURCE (ES)	False
SI1	LE SILLON-CULTURE	False
SI2	LE SILLON-ELEVAGE	False
SI3	LE SILLON VIGNE/VERGER	False
SOA	Il SOLCO Allevatori	False
SOL	IL SOLCO	False
SOP	Il SOLCO Specializzati	False
SUL	SULCO	False
VAK	VAKO	False
VO1	DEVOOR-AKKERBOUW	False
VO2	DEVOOR-VEEHOUDERIJ	False

Back to parent section

Table 5446237 — JD Branch

Code	Description
1	DEERE & COMPANY ATLANTA
22	JOHN DEERE FRANCE
27	JOHN DEERE DISTRIBUTION GERMANY
29	JOHN DEERE SOUTH AFRICA
2B	SARAN POWER SYSTEMS
31	JOHN DEERE UNITED KINGDOM
32	JOHN DEERE S. A. SPAIN
34	DEERE & COMPANY EUROPEAN OFFICE
3R	John Deere Russia
41	JOHN DEERE ITALIANA
42	SVENSKA JOHN DEERE
44	JD CORPORATE OFFICE FRANCE
48	JOHN DEERE INTERNATIONAL
4P	John Deere Poland
6M	John Deere Turkey
7W	JOHN DEERE WATER
90	DEERE & COMPANY USA
CC	JOHN DEERE ARC-LES-GRAY
CD	JOHN DEERE USINE DE SARAN
CE	JOHN DEERE IBERICA S.A.
CG	JOHN DEERE WERKE BRUCHSAL
L	JOHN DEERE WERKE MANNHEIM
TT	JOHN DEERE TEST BRANCH
Z	JOHN DEERE WERKE ZWEIBRÜCKEN

Back to parent section

Table 5446243 — JD PIP Type

Code	Description
FASF	Fix-as-Fail
MALF	Mandatory
OPT	Optional
PEP	Product Enhancement Program
SAFT	Safety

Back to parent section

Table 5446244 — JD Policy Allowance Type

Code	Description
1	Dealer Administered
10	Wet Turn Assurance
11	Structural
2	Goodwill
3	Product
4	Experimental/Engineering
5	Sales
6	Processing Policy
7	Service Parts Failure
8	FIU
9	Wear Assurance

Back to parent section

Table 5446247 — JD Category

Code	Description
01S	Oil
03S	Cotton lube
04S	Coolant
05S	Batteries
06S	Paint
11S	Small engine - TURF
14S	Cutting and bagging parts TURF
20S	Hitachi Mining Parts
21S	Cutters & Shredders
23S	Sweeps & shovels
26S	Filters - All Makes
27S	Plow parts
28S	Application Equipment
2LS	Disk blades
31S	Planter parts
32S	Drill and seeder parts
33S	Forage Harvester and Header Parts
34S	Pull Type Forage Harvester Parts
35S	Hay/cutting parts
36S	Cotton stripper parts
38S	Combine and header parts
39S	Cotton picker parts
40S	Engine parts
41S	Engine kits
42S	Hydraulics
43S	Chemicals
44S	Tractor parts
45S	Reman Rotating Electrical and AC Components
46S	Reman Fuel Injection
48S	Reman Engine Components
49S	Reman Hydraulics
4CS	DEF & Supporting Equipment
4DS	Grease
50S	Filters
52S	Reman Engines
55S	Chain-roller & other
56S	Hardware
57S	Hardware-Bulk
58S	Forestry
60S	Bucket teeth
71S	Cutting edges
81S	Undercarriage, PDC Stocked
90S	Scraper chain
92S	Bearings
AIS	A&I - All Makes
CBS	C&F Bearings
CCS	Attachment, Crop Care
DTS	Drivetrain
ENS	Engines
F0S	Portfolio Extension Parts
GTS	Golf and TURF
HCS	Attachment, Other
HFS	Attachment, Hay & Forage
HHS	Portable Power Equipment
HPS	Attachment, Harvesting
HWS	Home and Workshop Products
IGS	ISG/AMS Parts
ISS	Attachment, ISG
J1S	Turf Filters
J4S	Battery accessories
J5S	Chain
J6S	Driveline parts
J7S	Electrical
J8S	Fluid analysis
J9S	Fuel solutions
JAS	Hose production equipment
JBS	JDPS Belts
JCS	Hydraulic hose assemblies
JDS	Hydraulics - Other
JES	Linkage parts
JFS	Low pressure hose & accessories
JGS	Quick hitches
JHS	Engine other
JJS	Promotional items
JKS	Publications
JNS	Clutches, chains, and sprockets - TURF
JPS	Other - TURF
JRS	Hydraulics
JTS	Other
JUS	Other - factory
JVS	Hydraulic hose and fittings
JXS	Ag Belts
JYS	Service Tools
JZS	Merchandising
L0S	Apparel, Caps & Footwear - Licensed
L4S	Toys & Kids Accessories - Licensed
L5S	Other - Licensed Products
MKS	Maintenance Kits - TURF
NFS	Engine fuel
OFS	Other - factory
OMS	Other - JDM
PMS	Attachment, Platform Management Services
RAS	Radios
RDS	Reman Drive Train
RES	Reman Electronics
RTS	Rubber Tracks
TFS	Turf Belts
THS	Sugar Cane Harvester Parts
TLS	Sugar Cane Loader Parts
TPS	Attachment, Tractor Platform
TSS	Scraper Parts
TUS	Attachment, Turf and Utility
TWS	Tires and wheels - TURF
UPS	Undercarriage, PDC Stocked - Other

Back to parent section

Table 5446250 — JD Base Machine Code

JD Base Machine Codes will be provided with the corresponding base machine codes by John Deere and can be imported periodically into John Deere DBS. This automation will also create all machine models which are marked as current in the file.

Back to parent section

Table 15000606 — EQM Rental Text

Code	Description
DIFF_OH	Difference for operating hours
FOH	Free Operating Hours
OH	Operating Hours
RENT-CONT	Rental Contact
RENT-CONTR	Rental Contract
RENT-CUSTP	Customer Project
REP-DIFF	Difference Reported Hours
REP-FREEH	Reported Free Hours
REP-REPH	Reported Hours

Back to parent section

Table 15000634 — EQM Object Price Term

This table has to be filled on the EQM Rental Price Terms (15000631) list and then configured in the EQM Price Terms Object (15000604) table.

Code	Description	Type	Quantity	Reported Hours
D_RATE	Day(s)	Day	1	False
DAY	Day(s)	Day	1	False
FIX PRICE	Fix Price	Total	1	False
HOUR	Hour	Hour	1	False
M_RATE	Month(s)	Day	1	False
MONTH	Month(s)	Month	1	False
R-HOUR	Rep. Hours	Hour	1	True
W_RATE	Week(s)	Day	1	False
WEEK	Week(s)	Week	1	False

Back to parent section

Table 15000745 — EQM Report Selections

Usage	Sequence	Report ID	Use for Email Attachment	Use for Email Body
R.Quote	1	5445758	True	False
R.Order	1	205	True	False
R.Invoice	1	5445759	True	False
R.Cr.Memo	1	5445760	True	False
R.Contract Quote	1	5445758	True	False
R.Contract	1	5445757	True	False
R.Cash Invoice	1	5445759	True	False
R.Shipment	1	5445761	True	False
R.Return	1	5445762	True	False
R.Equipment Status	1	15000797	True	False
RCL.Inquiry	1	15000862	True	False
RCL.Picking List	1	15000864	True	False
RCL.Order	1	15000861	True	False
R.Deposit Receipt	1	5445764	True	False
W.Order	1	15000871	True	False
W.Invoice	1	15000872	True	False
W.Cr.Memo	1	15000873	True	False
W.Work Order	1	15000875	True	False
W.Order Pick Instruction	1	15000874	True	False
W.Quote	1	15000876	True	False
R.Pick Order	1	15000886	True	False
R.Shipment Order	1	15000887	True	False
R.Collection Order	1	15000888	True	False
P.Pick Order	1	15000892	True	False
P.Shipment Order	1	5445761	True	False
P.Collection Order	1	5445762	True	False
Off-Rent Confirmation	1	15000865	True	False
Invoice Draft	1	5445768	True	False

Back to parent section

Table 15000751 — EQM Rental Codes Setup

Primary Key	Transferred to Order	Rental Closed	Reserved	Off-Rent	Available	On-Rent	Invoiced	Expected Further Rental	Returned	Bitmap	Reserved2	Off-Rent3	Available4	On-Rent5	Invoiced6	Expected Further Rental7	Returned8
	IN INVOICE	CLOSED	RESERVED	OFF-RENT	AVAILABLE	ON-RENT	INVOICED-TO	ON-RENT EXP.RETURN	RETURNED

Important

Some of the fields are predefined in John Deere DBS and should not be modified individually.

Back to parent section

Table 15000752 — EQM Rental Cal. Codes Setup

Code	Status Code	Status Text
001	RESERVED	RESERVED
002	DELIVERED	DELIVERED
003	ON-RENT	ON-RENT
004	OFF-RENT	OFF-RENT
005	RETURNED	RETURNED
007	RESERVED EXP.RETURN	RESERVED EXP.RETURN
008	DELIVERED EXP.RETURN	DELIVERED EXP.RETURN
009	ON-RENT EXP.RETURN	ON-RENT EXP.RETURN
010	INVOICED-TO	INVOICED-TO
011	PLANNED SERVICE	PLANNED SERVICE
012	SERVICE	SERVICE
100	LIMITED RENTAL	LIMITED RENTAL
101	INFINITE RENTAL	INFINITE RENTAL

Back to parent section

DBS Setup Tables — Step 2

Tip

All of the following tables can be imported via RapidStart packages. For this, proceed as follows:

Download the RapidStart package (DBS STEP 2.rapidstart) from TRASER Sharepoint (You must be a member of the TRASER JD DBS Partnerchannel.).

Open the Configuration Packages page in John Deere DBS.

In the header, click on HOME > Import Package.

Select the RapidStart package DBS STEP 2.rapidstart and confirm.

In the header, click on HOME > Apply Package.

The package is now applied, and the values are automatically entered.

Note

In case a value in the tables states the value true, the corresponding check box is selected.
In case a value in the tables states the value false, the corresponding check box is cleared.

Sorting	Table ID	Table Name	Comment/Dependent on
2	82	Item Journal Template	No. Series, Source Code
2	200	Work Type	Unit of Measure
2	242	Source Code Setup	Source Code
2	245	Requisition Wksh. Name	Req. Wksh. Template
2	309	No. Series Line	No. Series
2	311	Sales & Receivables Setup	No.Series, Dimension
2	312	Purchases & Payables Setup	No.Series
2	313	Inventory Setup	No. Series, Dimension
2	314	Resources Setup	No. Series
2	354	Default Dimension Priority	Source Code
2	905	Assembly Setup	No. Series
2	5064	Interaction Template	Interaction Group
2	5079	Marketing Setup	No. Series, Business Relation, Salutation, Sales Cycle
2	5218	Human Resources Setup	No. Series, Human Resource Unit of Measure
2	5603	FA Setup	No. Series
2	5769	Warehouse Setup	No. Series
2	5903	Service Order Type	Work Type,
2	5911	Service Mgt. Setup	No. Series
2	5927	Repair Status	Service Status Priority Setup
2	5445587	Default Dimension per Field	Dimension
2	5445659	Service Item Model	Brand, Family, Series
2	5445677	License Plate Setup	Country/Region
2	5446120	Catalog Import Setup	No. Series
2	5446220	JD Profile Brand	Brand
2	5446226	JD Critical Code Line	JD Critical Code
2	5446240	JD Commodity Category Code	JD Category
2	5446245	JD Warranty Labor Type	Work Type
2	15000600	EQM Rental Setup	No. Series, EQM Price Term, Base Calendar, EQM Rental Text
2	15000636	EQM Object Journal Template	Source Code, No. Series
2	15000652	EQM Object Setup	No. Series, Dimension
2	15000733	EQM Reclass Setup	No. Series

Back to parent section

Table 82 — Item Journal Template

Name	Description	Test Report ID	Page ID	Posting Report ID	Force Posting Report	Type	Source Code	Recurring	No. Series	Whse. Register Report ID	Increment Batch Name
ADJMT	Adjustment Journal	702	40	703	False	Item	ITEMJNL	False	INV-IJNL-GEN	7303	False
ITEM	Item journal	702	40	703	False	Item	ITEMJNL	False		7303	False
REVAL	Revaluation Journal	5812	5803	5805	False	Revaluation	REVALJNL	False	INV-IJNL-REVAL	7303	False

Back to parent section

Table 200 — Work Type

Code	Description	Unit of Measure Code	Relevant for Time Tracking
PRESENT	Not Recording Hours/Present	HOUR	False
STD LABOUR	Standard Labour	HOUR	True
TECH SPEC	Technician Specialized	HOUR	False
WAR ACCESS	Access Time	HOUR	False
WAR CLEAN	Clean Up	HOUR	False
WAR DIAG	Diagnosis	HOUR	True
WAR DIV	Driving Time	HOUR	False
WAR REM	Removal	HOUR	False
WAR REP	Repair	HOUR	True
WAR SERV	Special Service	HOUR	False
WAR WELD	Welding	HOUR	False

Back to parent section

Table 242 — Source Code Setup

Primary Key	Sales	Purchases	Inventory Post Cost	Exchange Rate Adjmt.	Post Recognition	Post Value	Close Income Statement	Consolidation	General Journal	Sales Journal	Purchase Journal	Cash Receipt Journal	Payment Journal	Item Journal	Resource Journal	Job Journal	Sales Entry Application	Purchase Entry Application	VAT Settlement	Compress G/L	Compress VAT Entries	Compress Cust. Ledger	Compress Vend. Ledger	Compress Item Ledger	Compress Res. Ledger	Compress Job Ledger	Item Reclass. Journal	Phys. Inventory Journal	Compress Bank Acc. Ledger	Compress Check Ledger	Financially Voided Check	Finance Charge Memo	Reminder	Deleted Document	Adjust Add. Reporting Currency	Trans. Bank Rec. to Gen. Jnl.	IC General Journal	Unapplied Empl. Entry Appln.	Unapplied Sales Entry Appln.	Unapplied Purch. Entry Appln.	Reversal	Employee Entry Application	Payment Reconciliation Journal	Cash Flow Worksheet	Assembly	Job G/L Journal	Job G/L WIP	G/L Entry to CA	Cost Journal	Cost Allocation	Transfer Budget to Actual	Consumption Journal	Output Journal	Flushing	Capacity Journal	Production Journal	Fixed Asset Journal	Fixed Asset G/L Journal	Insurance Journal	Compress FA Ledger	Compress Maintenance Ledger	Compress Insurance Ledger	Transfer	Revaluation Journal	Adjust Cost	Phys. Invt. Orders	Service Management	Compress Item Budget	Whse. Item Journal	Whse. Phys. Invt. Journal	Whse. Reclassification Journal	Whse. Put-away	Whse. Pick	Whse. Movement	Compress Whse. Entries	Object BOM Journal	Rental Journal	Object Reclass. Journal	Reclass Doc.	Rental Terminate Journal	Rental	Object Journal	Object	Object Rented In	Object Counter Journal	Workshop Order	Rental Return	Work Purchases	EQM Service Header	Functional Test	Pick Order	Deliver Order	Collection Order	Control Test
	SALES	PURCHASES	INVTPCOST	EXCHRATADJ			CLSINCOME	CONSOLID	GENJNL	SALESJNL	PURCHJNL	CASHRECJNL	PAYMENTJNL	ITEMJNL	RESJNL	JOBJNL	SALESAPPL	PURCHAPPL	VATSTMT	COMPRGL	COMPRVAT	COMPRCUST	COMPRVEND		COMPRRES	COMPRJOB	RECLASSJNL	PHYSINVJNL	COMPRBANK	COMPRCHECK	FINVOIDCHK	FINCHRG	REMINDER	DELETE	ADJADDCURR	BANKREC	INTERCOMP	UNAPPEMPL	UNAPPSALES	UNAPPPURCH	REVERSAL	EMPLAPPL	PAYMTRECON	CFWKSH	ASSEMBLY	JOBGLJNL	JOBGLWIP	GL	CAJOUR	ALLOC	TRABUD	CONSUMPJNL	POINOUTJNL	FLUSHING	CAPACITJNL	PRODORDER	FAJNL	FAGLJNL	INSJNL	COMPRFA	COMPRMAINT	COMPRINS	TRANSFER	REVALJNL	INVTADJMT	INVTORDER	SERVICE	COMPRIBUDG	WHITEM	WHPHYSINVT	WHRCLSSJNL	WHPUTAWAY	WHPICK	WHMOVEMENT	COMPRWHSE		RENTJNL	OBJRECJNL	RNTRECLASS	RENTTRMJNL	RNT	OBJJNL	OBJECT	OBJRERENT	OBJCOUNTJN	WSORDER	RNTRETURN	WSPURCHORD	WSSERVHEAD	WSFUNCTEST	RNTPICK	RNTDELIV	RNTCOLL

Back to parent section

Table 309 — No. Series Line

This table is completely customizable to accommodate for the specific requirements of each dealer. A TRASER default setup is implemented in the RapidStart package to show the variety and specific properties of number series.

Back to parent section

Table 311 — Sales & Receivables Setup

Primary Key	Discount Posting	Credit Warnings	Stockout Warning	Shipment on Invoice	Invoice Rounding	Ext. Doc. No. Mandatory	Customer Nos.	Quote Nos.	Order Nos.	Invoice Nos.	Posted Invoice Nos.	Credit Memo Nos.	Posted Credit Memo Nos.	Posted Shipment Nos.	Reminder Nos.	Issued Reminder Nos.	Fin. Chrg. Memo Nos.	Issued Fin. Chrg. M. Nos.	Posted Prepmt. Inv. Nos.	Posted Prepmt. Cr. Memo Nos.	Blanket Order Nos.	Calc. Inv. Discount	Appln. between Currencies	Copy Comments Blanket to Order	Copy Comments Order to Invoice	Copy Comments Order to Shpt.	Allow VAT Difference	Calc. Inv. Disc. per VAT ID	Logo Position on Documents	Check Prepmt. when Posting	Prepmt. Auto Update Frequency	Default Posting Date	Default Quantity to Ship	Archive Quotes and Orders	Post with Job Queue	Job Queue Category Code	Job Queue Priority for Post	Post & Print with Job Queue	Job Q. Prio. for Post & Print	Notify On Success	VAT Bus. Posting Gr. (Price)	Direct Debit Mandate Nos.	Allow Document Deletion Before	Default Item Quantity	Create Item from Description	Archive Quotes	Archive Orders	Archive Blanket Orders	Archive Return Orders	Create Item from Item No.	Copy Customer Name to Entries	Batch Archiving Quotes	Ignore Updated Addresses	Skip Manual Reservation	Insert Std. Sales Lines Mode	Insert Std. Lines on Quotes	Insert Std. Lines on Orders	Insert Std. Lines on Invoices	Insert Std. Lines on Cr. Memos	Quote Validity Calculation	Write-in Product Type	Write-in Product No.	Posted Return Receipt Nos.	Copy Cmts Ret.Ord. to Ret.Rcpt	Copy Cmts Ret.Ord. to Cr. Memo	Return Order Nos.	Return Receipt on Credit Memo	Exact Cost Reversing Mandatory	Customer Group Dimension Code	Salesperson Dimension Code	Freight G/L Acc. No.	Invoice Fee Amount	Invoice Fee Account	Invoice Fee Posting Group	Invoice Fee Unit of Measure Code	Combine Method for New Customer
	All Discounts	Both Warnings	True	True	False	False	S-CUST	S-QUO	S-ORD	S-INV	S-INV+	S-CR	S-CR+	S-SHPT	S-REM	S-REM+	S-FIN	S-FIN+	S-INV+	S-CR+	S-BLK	False	None	True	True	True	True	False	No Logo	True	Never	Work Date	Remainder	False	False		1000	False	1000	False		S-DDM		False	False	Always	True	False	False	False	False	False	False	False	Manual	False	False	False	False		Item		S-RCPT	True	True	S-RETORD	True	True	CUSTOMERGROUP	SALESPERSON		0				....Customer Project

Important

Some of the fields are predefined in John Deere DBS and should not be modified individually.

Back to parent section

Table 312 — Purchases & Payables Setup

Primary Key	Discount Posting	Receipt on Invoice	Invoice Rounding	Ext. Doc. No. Mandatory	Vendor Nos.	Quote Nos.	Order Nos.	Invoice Nos.	Posted Invoice Nos.	Credit Memo Nos.	Posted Credit Memo Nos.	Posted Receipt Nos.	Blanket Order Nos.	Calc. Inv. Discount	Appln. between Currencies	Copy Comments Blanket to Order	Copy Comments Order to Invoice	Copy Comments Order to Receipt	Allow VAT Difference	Calc. Inv. Disc. per VAT ID	Posted Prepmt. Inv. Nos.	Posted Prepmt. Cr. Memo Nos.	Check Prepmt. when Posting	Prepmt. Auto Update Frequency	Default Posting Date	Default Qty. to Receive	Archive Quotes and Orders	Post with Job Queue	Job Queue Category Code	Job Queue Priority for Post	Post & Print with Job Queue	Job Q. Prio. for Post & Print	Notify On Success	Allow Document Deletion Before	Archive Quotes	Archive Orders	Archive Blanket Orders	Archive Return Orders	Ignore Updated Addresses	Create Item from Item No.	Copy Vendor Name to Entries	Insert Std. Purch. Lines Mode	Insert Std. Lines on Quotes	Insert Std. Lines on Orders	Insert Std. Lines on Invoices	Insert Std. Lines on Cr. Memos	Debit Acc. for Non-Item Lines	Credit Acc. for Non-Item Lines	Posted Return Shpt. Nos.	Copy Cmts Ret.Ord. to Ret.Shpt	Copy Cmts Ret.Ord. to Cr. Memo	Return Order Nos.	Return Shipment on Credit Memo	Exact Cost Reversing Mandatory
	All Discounts	True	False	True	P-VEND	P-QUO	P-ORD	P-INV	P-INV+	P-CR	P-CR+	P-RCPT	P-BLK	True	None	True	True	True	True	False	P-INV+	P-CR+	True	Never	Work Date	Remainder	False	False		1000	False	1000	False		Always	True	False	False	False	False	False	Manual	False	False	False	False			P-SHPT	True	True	P-RETORD	True	True

Important

Some of the fields are predefined in John Deere DBS and should not be modified individually.

Back to parent section

Table 313 — Inventory Setup

Primary Key	Automatic Cost Posting	Location Mandatory	Item Nos.	Automatic Cost Adjustment	Prevent Negative Inventory	Skip Prompt to Create Item	Copy Item Descr. to Entries	Transfer Order Nos.	Posted Transfer Shpt. Nos.	Posted Transfer Rcpt. Nos.	Copy Comments Order to Shpt.	Copy Comments Order to Rcpt.	Catalog Item Nos.	Outbound Whse. Handling Time	Inbound Whse. Handling Time	Expected Cost Posting to G/L	Default Costing Method	Average Cost Calc. Type	Average Cost Period	Phys. Invt. Order Nos.	Posted Phys. Invt. Order Nos.	Item Group Dimension Code	Inventory Put-away Nos.	Inventory Pick Nos.	Posted Invt. Put-away Nos.	Posted Invt. Pick Nos.	Inventory Movement Nos.	Registered Invt. Movement Nos.	Internal Movement Nos.
	True	True	INV-ITEM	Always	True	False	False	INV-T-ORD	INV-T-SHPT	INV-T-RCPT	True	True	INV-NS-ITEM			True	Average	Item & Location & Variant	Accounting Period				INV-I-PUT	INV-I-PICK	INV-I-PUT+	INV-I-PICK+	INV-I-MOVEMENT	INV-I-MOVE+	INV-INT-MOVE

Important

Some of the fields are predefined in John Deere DBS and should not be modified individually.

Back to parent section

Table 314 — Resources Setup

Primary Key	Resource Nos.	Time Sheet Nos.	Time Sheet First Weekday	Time Sheet by Job Approval	Pin Code Nos.	Employment Nos.
	SM-RES	SM-TS	Monday	Never

Important

Some of the fields are predefined in John Deere DBS and should not be modified individually.

Back to parent section

Table 354 — Default Dimension Priority

Source Code	Table ID	Priority
PURCHASES	13	2
PURCHASES	23	6
PURCHASES	27	3
PURCHASES	5600	4
PURCHASES	5903	1
PURCHASES	5940	5
PURCHJNL	23	1
PURCHJNL	27	2
RNT	13	3
RNT	18	7
RNT	27	4
RNT	156	1
RNT	5600	5
RNT	5903	2
RNT	5940	6
SALES	13	3
SALES	18	7
SALES	27	4
SALES	156	1
SALES	5600	5
SALES	5903	2
SALES	5940	6
SALESJNL	18	1
SALESJNL	27	2
SERVICE	13	3
SERVICE	18	7
SERVICE	27	4
SERVICE	156	1
SERVICE	5600	5
SERVICE	5903	2
SERVICE	5940	6

Back to parent section

Table 905 — Assembly Setup

Primary Key	Stockout Warning	Assembly Order Nos.	Assembly Quote Nos.	Blanket Assembly Order Nos.	Posted Assembly Order Nos.	Copy Component Dimensions from	Default Location for Orders	Copy Comments when Posting	Create Movements Automatically
	True	A-ORD	A-QUO	A-BLK	A-ORD+	Item/Resource Card		True	True

Important

Some of the fields are predefined in John Deere DBS and should not be modified individually.

Back to parent section

Table 5064 — Interaction Template

Code	Interaction Group Code	Description	Unit Cost (LCY)	Unit Duration (Min.)	Information Flow	Initiated By	Campaign No.	Campaign Target	Campaign Response	Correspondence Type (Default)	Language Code (Default)	Wizard Action	Ignore Contact Corres. Type
DROPBOX	SYSTEM	File Dropbox	0	0				False	False			Import	True

Back to parent section

Table 5079 — Marketing Setup

Primary Key	Contact Nos.	Campaign Nos.	Segment Nos.	Task Nos.	Opportunity Nos.	Bus. Rel. Code for Customers	Bus. Rel. Code for Vendors	Bus. Rel. Code for Bank Accs.	Inherit Salesperson Code	Inherit Territory Code	Inherit Country/Region Code	Inherit Language Code	Inherit Address Details	Inherit Communication Details	Default Salesperson Code	Default Territory Code	Default Country/Region Code	Default Language Code	Default Sales Cycle Code	Attachment Storage Type	Attachment Storage Location	Autosearch for Duplicates	Search Hit %	Maintain Dupl. Search Strings	Mergefield Language ID	Def. Company Salutation Code	Default Person Salutation Code	Default Correspondence Type	Queue Folder Path	Queue Folder UID	Storage Folder Path	Storage Folder UID	Default Task Date Calculation	Autodiscovery Email Address	Email Batch Size	Exchange Service URL	Exchange Account User Name	Exchange Account Password Key	Sync with Microsoft Graph	WebHook Run Notification As	Cust. Template Company Code	Cust. Template Person Code	Offer Template Nos.
	M-CONT	M-CAMP	M-SEGM	M-TASK	M-OPP	CUST	VEND	BANK	True	True	True	True	True	True					STANDARD	Embedded		True	60	True		COMPANY	UNISEX	Email							0			{00000000-0000-0000-0000-000000000000}	False	{00000000-0000-0000-0000-000000000000}			INV-I-MOVEMENT

Important

Some of the fields are predefined in John Deere DBS and should not be modified individually.

Back to parent section

Table 5218 — Human Resources Setup

Primary Key	Employee Nos.	Base Unit of Measure	Automatically Create Resource
	HR-EMP	DAY	False

Important

Some of the fields are predefined in John Deere DBS and should not be modified individually.

Back to parent section

Table 5603 — FA Setup

Primary Key	Allow Posting to Main Assets	Default Depr. Book	Allow FA Posting From	Allow FA Posting To	Insurance Depr. Book	Automatic Insurance Posting	Fixed Asset Nos.	Insurance Nos.
	False					False	F-FA	F-INS

Important

Some of the fields are predefined in John Deere DBS and should not be modified individually.

Back to parent section

Table 5769 — Warehouse Setup

Primary Key	Whse. Receipt Nos.	Whse. Put-away Nos.	Whse. Pick Nos.	Whse. Ship Nos.	Registered Whse. Pick Nos.	Registered Whse. Put-away Nos.	Require Receive	Require Put-away	Require Pick	Require Shipment	Last Whse. Posting Ref. No.	Receipt Posting Policy	Shipment Posting Policy	Posted Whse. Receipt Nos.	Posted Whse. Shipment Nos.	Whse. Internal Put-away Nos.	Whse. Internal Pick Nos.	Whse. Movement Nos.	Registered Whse. Movement Nos.
	WMS-RCPT	WMS-PUT	WMS-PICK	WMS-SHIP	WMS-PICK+	WMS-PUT+	False	False	False	False	0	Posting errors are not processed	Posting errors are not processed	WMS-RCPT+	WMS-SHIP+	WMS-PAO	WMS-PIO	WMS-MOV	WMS-MOV+

Important

Some of the fields are predefined in John Deere DBS and should not be modified individually.

Back to parent section

Table 5903 — Service Order Type

The data provided with the RapiStart package is to serve as demo data. This demo data can be used for first trainings. Service order types should be analyzed and individually set up with the dealer to fit their business requirements. It is possible to define dimensions for each order type. This could be useful for setting up a cost accounting or some other reporting requests of the customer.

|Name|Explanation|
|||
|Code|This code is an abbreviation for the order type.|
|Description|Description of the order type|
|Service Order Type|If this Boolean is true, the order type is available in service documents.|
|Sales Order Type|If this Boolean is true, the order type is available in sales documents.|
|Purchase Order Type|If this Boolean is true, the order type is available in purchase documents.|
|Rental Order Type|If this Boolean is true, the order type is available in rental documents.|
|Advanced Pricing|If this Boolean is true, advanced pricing is activated for this order type. This means, for example, order code surcharges will be calculated. This should always be activated for John Deere DBS to run correctly.|
|Surcharge %|This field allows to define a surcharge in percent that will be applied when the order type is used in a document.|
|Hide Purchase Price|If this Boolean is true the Unit Cost column in the lines is hidden. Can be used for order types used at a workshop counter in customer contact.|
|Calculate Foreman Surcharges|This defines if foreman surcharges should be calculated. Works only for service order types.|
|Warranty|If this Boolean is true, the order type can be used for warranty service orders and the subsequent creation of warranty claims.|
|Powergard|Will mark the service order type as Powergard Warranty. When trying to close a warranty claim, John Deere DBS will check if an invoice for the deductible amount already exists, and inform the user if not.|
|Default Work Type Code (Machine Line)|You can define a work type here that will always be used by default if this order type is selected.|
|Responsibility Center|When assigning a Responsibility Center, the order type is only available in documents with the same responsibility center.|
|Payment Terms Code|Defining this value for an order type will overwrite the default values coming from the customer/vendor.|
|Shipment Method Code|Defining this value for an order type will overwrite the default values coming from the customer/vendor.|
|Payment Method Code|Defining a this value for an order type will overwrite the default values coming from the customer/vendor.|
|Bill-to Customer No.|If a customer is selected here, this will overwrite the Bill-to Customer No. value in the sales, service, or rental document header.|
|Is Customer No. Internal|This FlowField shows if the Bill-to Customer No. value entered for the order type is marked as Internal.|
|Internal Invoicing|If this Boolean is true, no customer ledger entries will be created for the document. Instead, the amount will be posted to the Internal Cost Applied Account.|
|Capitalized Service|Can only be selected if the service order type has internal invoicing. If so, each resource line in service orders will be set to Line Action = Capitalized Service by default which will lead to revaluating machine with the resource line amount.|
|Prepopulate Attach Action|This is a comfort functionality. If selected, for a service order type, then each item will be set to Line Action = Attach by default. This will revalue the machine with the line amount.|
|Gen. Bus. Posting Group|If this group is selected here, this will overwrite the values coming from the customer/vendor into the document header.|
|Gen. Prod. Post. Grp.|If this group is selected here, this will default all document lines to this value, no matter the information coming from the master data record of that line.|
|VAT Bus. Posting Group| If this group is selected here, this will overwrite the values coming from the customer/vendor into the document header.|
|VAT Prod. Posting Group|If this group is selected here, this will default all document lines to this value, no matter the information coming from the master data record of that line.|
|Internal Cost Applied Account|This field specifies the G/L account needed if the order type is marked as Internal Invoicing.|
|Differential Taxation|If this Boolean is true, differential taxation is used. This is a specific tax scheme in Germany for used machinery where only the difference between unit cost and unit price is used as a basis for VAT.|
|Price includes VAT|If this Boolean is true, the unit price in the document will show values including the VAT amount.|
|Rental Checklist Description|This allows users to predefine a checklist for rental order types that needs to be filled in the rental department when this order type is used.|
|Date Text in Rental Doc.|If this Boolean is true, start and ending date of the rent will be printed as text lines in the document.|
|Counter Text in Rental Doc.|If this Boolean is true, the current counter level will be printed as text lines in the document.|
|Rental Days Text in Rental Doc.|If this Boolean is true, the rental days will be printed as text lines in the document.|
|Vacancy Text in Rental Doc.|If this Boolean is true, the vacancy text will be printed as text lines in the document.|
|Business Domain|With this field, the order type can be assigned to a business domain.|
|Counter Sale|If a customer is using the TRASER Mobile Warehouse App and two-level warehouse shipments (incl. commissioning), this Boolean will suppress the commissioning part of postings, etc. for this order type. This is useful in over-the-counter sales scenarios.|
|Operating Hours mandatory|If this Boolean is true and a technician starts tracking time on the job via TSR Time Tracking, they will be prompted once a day to enter the machine operating hours.|
|Print Template Code|This field allows to define a print template per service order type. With this, certain printing options can be predefined for service orders.|
|Invoice No. Series|This field allows users to define differing invoice number series for different service order types. For example, you might be mandated by law to enforce a different numbering for internal orders.|
|Credit Memo No. Series|This field allows users to define differing credit memo number series for different service order types. For example, you might be mandated by law to enforce a different numbering for internal orders.|
|Shipment No. Series|This field allows users to define differing shipment number series for different service order types. For example, you might be mandated by law to enforce a different numbering for internal orders.|

Back to parent section

Table 5911 — Service Mgt. Setup

Primary Key	Fault Reporting Level	Link Service to Service Item	Salesperson Mandatory	Warranty Disc. % (Parts)	Warranty Disc. % (Labor)	Contract Rsp. Time Mandatory	Service Order Starting Fee	Register Contract Changes	Contract Inv. Line Text Code	Contract Line Inv. Text Code	Contract Inv. Period Text Code	Contract Credit Line Text Code	Send First Warning To	Send Second Warning To	Send Third Warning To	First Warning Within (Hours)	Second Warning Within (Hours)	Third Warning Within (Hours)	Next Service Calc. Method	Service Order Type Mandatory	Service Zones Option	Service Order Start Mandatory	Service Order Finish Mandatory	Resource Skills Option	One Service Item Line/Order	Unit of Measure Mandatory	Fault Reason Code Mandatory	Contract Serv. Ord. Max. Days	Last Contract Service Date	Work Type Code Mandatory	Logo Position on Documents	Use Contract Cancel Reason	Default Response Time (Hours)	Default Warranty Duration	Service Invoice Nos.	Contract Invoice Nos.	Service Item Nos.	Service Order Nos.	Service Contract Nos.	Contract Template Nos.	Troubleshooting Nos.	Prepaid Posting Document Nos.	Loaner Nos.	Serv. Job Responsibility Code	Contract Value Calc. Method	Contract Value %	Service Quote Nos.	Posted Service Invoice Nos.	Posted Serv. Credit Memo Nos.	Posted Service Shipment Nos.	Shipment on Invoice	Skip Manual Reservation	Copy Comments Order to Invoice	Copy Comments Order to Shpt.	Service Credit Memo Nos.	Copy Time Sheet to Order	Base Calendar Code	Contract Credit Memo Nos.
	None	True	False	0	0	False		False								16	8	2	Planned	True	Not Used	False	False	Not Used	True	False	False	0		False	No Logo	False	0		SM-INV	SM-INV	SM-MACH	SM-ORD	SM-CONTRAC	SM-CNTTEMP		SM-INV+			None	0	SM-QUO	SM-INV+	SM-CR+	SM-SHIP+	True	False	True	True	SM-CR	True	7D	SM-CR

Important

Some of the fields are predefined in John Deere DBS and should not be modified individually.

Back to parent section

Table 5927 — Repair Status

Code	Description	Service Order Status	Priority	Initial	Partly Serviced	In Process	Finished	Referred	Spare Part Ordered	Spare Part Received	Waiting for Customer	Quote Finished	Posting Allowed	Pending Status Allowed	In Process Status Allowed	Finished Status Allowed	On Hold Status Allowed	Show Order Additional Cost Card	Reviewed	Scheduled	Relevant for Service	Relevant for Servicesync	On Hold	Notify for Mandatory Fields
COMPLETE	Service is Completed	In Process	High	False	False	False	True	False	False	True	False	False	True	True	True	True	True	False	False	False	False	False	False	False
HOLD PARTS	Service on Hold for Parts	On Hold	Medium Low	False	False	False	False	False	True	False	False	False	False	True	True	False	True	False	False	False	False	False	False	False
HOLD PRIO	Service on Hold for Prioity Job	On Hold	Medium Low	False	False	False	False	False	False	False	False	False	False	True	True	False	True	False	False	False	False	False	False	False
HOLD TECH	Service on Hold for Technical Reasons	On Hold	Medium Low	False	False	False	False	False	False	False	False	False	False	True	True	False	True	False	False	False	False	False	False	False
IN PROCESS	Service in Process	In Process	High	False	False	True	False	False	False	False	True	False	False	True	True	True	True	False	False	False	False	False	False	False
REVIEWED	Service Reviewed with Customer	In Process	High	False	False	False	False	False	False	False	False	False	True	True	True	True	True	False	True	False	False	False	False	False
SCHEDULED	Service Scheduled	Pending	Medium High	False	False	False	False	False	False	False	False	False	False	True	True	False	True	False	False	True	False	False	False	False
UNSCHEDULE	Service Unscheduled	Pending	Medium High	True	False	False	False	False	False	False	False	False	False	True	True	False	True	False	False	False	False	False	False	False

Back to parent section

Table 5445587 — Default Dimension per Field

Table No.	Fieldno.	Dimension Code	Value Posting	Account Type Default Dim.
13	1	SALESPERSON	Same Code	False
27	5701	BRAND	Same Code	False
27	5702	PRODUCTGROUP	Same Code	False
27	5900	FAMILY	Same Code	False
27	5445562	MODEL	Same Code	False
27	5446062	COMMODITY	Code Mandatory	False
5071	1	SALESCAMPAIGN	Same Code	False
5714	14	LOCATION/OUTLET	Code Mandatory	False
5903	1	ORDER TYPE	Same Code	False
5940	1	MACHINE	Same Code	False
5940	3	FAMILY	Code Mandatory	False
5940	76	VARIANT	Code Mandatory	False
5940	5445562	MODEL	Code Mandatory	False
5940	5445596	BRAND	Code Mandatory	False

Back to parent section

Table 5445659 — Service Item Model

Machine Models will be provided with the corresponding base machine codes by John Deere and can be imported periodically into John Deere DBS. This automation will also create all machine models which are marked as current in the file.

Back to parent section

Table 5445677 — License Plate Setup

Country/Region Code	Code	Name	License Plate Format	Default
AT	A	Austria	## ######	True
BE	B	Belgium	#-###-###	True
BG	BG	Bulgaria	## #### ##	True
CH	CH	Switzerland	##•######	True
CY	CY	Cyprus	### ###	True
CZ	CZ	Czech Republic	### ####	True
DE	D	Germany	### ## ####	True
DK	DK	Denmark	## ## ###	True
EE	EST	Estonia	### ##	True
EL	GR	Greece	###-####	True
ES	E	Spain	#### ###	True
FI	FIN	Finland	###•###	True
FR	F	France	##-###-##!##	True
GB	GB	Great Britain	#### ###	True
HR	HR	Croatia	## ####-##	True
HU	H	Hungary	###-###	True
IE	IRL	Ireland	###-##-#####	True
IT	I	Italy	## #####!##	True
LT	LT	Lithuania	### ###	True
LU	L	Luxembourg	## ####	True
LV	LV	Latvia	##-####	True
MT	M	Malta	###•###	True
NL	NL	Netherlands	#-###-##	True
PL	PL	Poland	### #####	True
PT	P	Portugal	##•##•##!####	True
RO	RO	Romania	## ### ###	True
SE	S	Sweden	### ###	True
SI	SLO	Slovenia	## ##-###	True
SK	SK	Slovakia	## #####	True

Back to parent section

Table 5446120 — Catalog Import Setup

Primary Key	Sheet Nos.	Template Nos.	Upload Path	Source Directory Path	Last Source Directory Path	Sync. Description	Sync. Description 2
	INV-SHEET					True	True

Important

Some of the fields are predefined in John Deere DBS and should not be modified individually.

Back to parent section

Table 5446220 — JD Profile Brand

This table is part of the RapidStart package and must not be modified.

Table 5446226 — JD Critical Code Line

This table provides standard codes from John Deere which are part of the RapidStart package.

Back to parent section

Table 5446240 — JD Commodity Category Code

This table provides standard codes from John Deere which are part of the RapidStart package.

Back to parent section

Table 5446245 — JD Warranty Labor Type

|This table provides standard labor types from John Deere which are part of the RapidStart package. They are needed for processing warranty claims.

Back to parent section

Table 15000600 — EQM Rental Setup

These fields are basic settings for EQM/rent and only needed if using the rental functionality in John Deere DBS. Further setup is made together with the dealer.

Important

Some of the fields are predefined in John Deere DBS and should not be modified individually.

Back to parent section

Table 15000652 — EQM Object Setup

Primary Key	Object Nos.	Rounding Method	Rounding Precision	Fixed Asset Integration	Cost Center Dimension	Hierarchy Number Nos.	Object Dimension	Object Type Dimension	Object Group Dimension	Global Object No.	Object Group Nos.	Object Type Nos.	Change Ownership Nos.	Related Sales Cost Dimension	Automatic Cost Posting	Assembly Object Nos.	Re-Rent Nos.	Item No. as Object Type Dim.	Base Calendar Code	Make FA per Purchase Item	FA Item Posting Type Setup	Check Serial No. Redundance	Location as Cost Center Method	Bulk Depr. at Disposal Method	New FA Item Creation Method	Comp. Reclass Jnl. Templ. Name	Comp. Reclass Jnl. Batch Name	Comp. Post Reclass	Reclass Rental Warning Level	Rental Contract Dimension	Customer Dimension	Owning Dep. for Bulk Items	Corp. Depreciation Book Code	Tax Depreciation Book Code	Non-Editbl. Current Location Code	Filter Object Components	Filter Object Status	Use Agg. Type Calendar	Distribution Entry as Correction	Item No. as Object Dimension	Update Owning Location on Return	Format Date	Update Current Location Only in Transfer Order	Change Current Location Nos.	Leased Equip. Depr. Book Code
	R-OBJ	Nearest	0.00001	False		True	MACHINE	RENTALTARIFF	FAMILY	False	R-OBJGR	R-OBJTYP	R-CHOWN		True			False	7D	False	Write-Down	False	Current Location	Original	Per Purchase			False							False	False	False	False	False	False	False	ddmmyy	True	R-CHINVT

Important

Some of the fields are predefined in John Deere DBS and should not be modified individually.

Back to parent section

Individual Setup Tables

The individual setup tables should contain regional or dealer specific information and can be set up by the local NAV partner. The tables are divided into four tiers and do not contain any specific values, with the exception of the tables Customer and Item.

Individual Setup Tables — Tier 1
Individual Setup Tables — Tier 2
Individual Setup Tables — Tier 3
Individual Setup Tables — Tier 4

Individual Setup Tables — Tier 1

Sorting	Table ID	Table Name	Comment/Dependent on
Tier 1	3	Payment Terms
Tier 1	4	Currency
Tier 1	13	Salesperson/Purchaser
Tier 1	14	Location
Tier 1	15	G/L Account
Tier 1	18	Customer
Tier 1	23	Vendor
Tier 1	27	Item
Tier 1	79	Company Information
Tier 1	94	Inventory Posting Group
Tier 1	152	Resource Group
Tier 1	156	Resources	Mandatory resources Default Warranty Resource, Deductible Amount Resource
Tier 1	200	Work Type
Tier 1	225	Post Code
Tier 1	292	Reminder Terms
Tier 1	323	VAT Business Posting Group
Tier 1	324	VAT Product Posting Group
Tier 1	341	Item Discount Group
Tier 1	5607	FA Class
Tier 1	5611	Depreciation Book
Tier 1	5622	FA Reclass. Journal Template
Tier 1	5626	Maintenance
Tier 1	5633	Insurance Journal Template	No. Series, Source Code
Tier 1	5904	Family
Tier 1	5910	Service Hour
Tier 1	5954	Work-Hour Template
Tier 1	7600	Base Calendar
Tier 1	5445558	Traser Setup
Tier 1	5445559	Traser User Setup
Tier 1	5445575	Catalog
Tier 1	5445683	Series
Tier 1	5445710	Calc. Discount Type
Tier 1	5445732	Extra Hours Setup
Tier 1	5445857	Document Setup
Tier 1	5446207	John Deere Setup
Tier 1	5446209	JD Field
Tier 1	5446212	JD Dealer Nos.	Vendor, Responsibility Center, Req. Wksh. Template, Requisition Wksh. Name, G/L Account
Tier 1	15000624	EQM Price Term
Tier 1	15000760	EQM Rent.Inv. Sequence Header

Back to parent section

Table 18 — Customer

This table can be filled with individual records. In the screenshot you can see checkbox Internal Customer which must be used for your internal company customer to post internal documents against.
Another field called Skip DPM Transfer will lead to a situation that these documents for this customer will not be considered for JD functionality of DPM exports.

Important

Please consider that there is a field Customer Type which we have hidden from profiles, where there is also a value Internal Customer. We have developed that this can't be set manually, because it will lead to a system behavior in our attached rental module we are not supporting.

Back to parent section

Table 27 — Item

This table can be filled individually and there are no restrictions or recommendations for the John Deere DBS.

Important

We are filling additional fields for system internal information/search routines i.e.,running the modify trigger, so please consider to eventually manually fill these fields in your migration routine.

Back to parent section

Table 156 — Resources

Resources will be set up individually at a later stage but the two resources presented here are useful and required in the first place to set all other tables up.

Back to parent section

Table 5445558 — Traser Setup

The data provided with the RapidStart package is intended as demo data for first trainings, etc. The TRASER Setup has numerous ways to change behavior of John Deere DBS for certain functionalities. Additionally, it contains setups that are mandatory, if certain functionality needs to be used. This is individual per customer and must be a result of analysis workshops and testing.

Note

Please note that not all fields are fully described as they are either not relevant for basic setup or seldomly used. In case you need more information about a specific field, do not hesitate to ask your TRASER Software GmbH consultant for help.

The table consists of the following FastTabs:

General
General Ledger
Docs
Customer
Service
Machine
Ext. Attributes
Forecast Calculation
Calculation Preview
TempVision
Warehouse
Purchase
Sales
Requisition Line per Order
Add-Ins
Source Code Setup
Dimensions
Nonstock Item
Purch. Document Mgt.
Trade-Ins
Mach. Community Mgt.
Rental
Transport

Back to parent section

Table 5445558 — Traser Setup: 'General' FastTab

Field	Description
Don't Set Document and Posting Date at Posting	If selected, the request page with Document Date and Posting Date, that shows in NAV standard when using Post is suppressed.
Check User Perm. At Posting	This field enables the permission functionality on the TRASER User Setup page for the different modules.
Show Purch. Work. <> Ship. Date	If selected, John Deere DBS message that the workdate is not equal to the shipment date in current purchase order is shown as in default Microsoft Dynamics 365 Business Central.
Show Sales Work. <> Ship. Date	If selected, John Deere DBS message that the workdate is not equal to the shipment date in current sales order is shown as in default Microsoft Dynamics 365 Business Central.
Show Serv. Work. <> Ship. Date	If selected, John Deere DBS message that the workdate is not equal to the shipment date in current service order is shown as in default Microsoft Dynamics 365 Business Central.
Print Certificate of Supply Automatically	If selected, the certificate of supply is automatically printed, when posting a shipment, where this applies.
Reason Code for WIP	Defines the Reason Code that is used for every WIP posting in the service department.

Back to parent section

Table 5445558 — Traser Setup: 'General Ledger' FastTab

Field	Description
Position Account Class	Defines which digit of the G/L Account No. define the account class. So for example if set to 2 then the 2nd digit of the G/L account number will define the account class.
Used Parts Tax %	Used Parts Tax is a specific tax under German law.
VAT Prod. Posting Group (Differential Taxation)	Defines the VAT Prod. Posting Group with 0% VAT that will be used on Sales Order where a machine is sold, for which differential taxation applies.
Automatic VAT Reg. No. Check	If selected, John Deere DBS will automatically check after entering a VAT registration No. if it is valid.
Financing
Financing Nos.	Defines the number series for financing.
Financing Dimension Code	Defines the dimension code that will be used for financing.
Financing Gen. Jnl. Template Name	Defines the general journal template used for financing.
Financing Gen. Jnl. Batch Name	Defines the general journal batch task used for financing.
Source Code Financing	Defines the source code that will be used for everything related to the financing module.
Fixed Assets
Gen. Jnl. Template Name	Defines the general journal template that will be used for the G/L postings when using the FA wizard to rebook a machine from current assets to fixed assets.
Gen. Jnl. Batch Name	Defines the general journal batch task that will be used for the G/L postings when using the FA wizard to rebook a machine from current assets to fixed assets.
FA Journal Templ. Name	Defines the fixed asset journal template that will be used for the FA postings when using the FA wizard to rebook a machine from current assets to fixed assets.
FA Journal Batch Name	Defines the fixed asset journal batch task that will be used for the FA postings when using the FA wizard to rebook a machine from current assets to fixed assets.
Item Journal Template Name	Defines the item journal template that will be used for the item ledger postings when using the FA wizard to rebook a machine from current assets to fixed assets.
Item Journal Batch Name	Defines the item journal batch that will be used for the item ledger postings when using the FA wizard to rebook a machine from current assets to fixed assets.
Source Code Component Posting	Defines the source code that will be used for any component related entries in John Deere DBS.
Default Reason Code	Defines the reason code that will be written into any entries and registers created by the FA wizard.
FA No. Wizard Source	No. Series: will use the defined number series for freshly created fixed assets Manually: Fficxed asset number will be entered manually Machine No.: the FA wizard will create fixed assets with same number as the machine number.
No. Series FA from Wizard	This defines the number series that will be used when fixed assets are created in the background using the FA wizard to rebook machines from current assets to fixed assets. This number series will only be used if the FA No. Wizard Source field is set to option No. Series.

Back to parent section

Table 5445558 — Traser Setup: 'Docs' FastTab

Field	Description
Do not print 0 quantity lines	If selected, then in each service/sales document, lines without a quantity will not be printed.
Default Show Address	If selected, then TSR report request pages will have the Boolean Show return address set to TRUE by default.
Address Separator	Defines the character that will separate name, address, city information of return address, since in TSR report this is printed in one line.
Delete Posted Documents	This field defines if it is possible to delete posted documents in current John Deere DBS.
Default Language Code Payment Term	Defines the default language that should be used when printing an ext. text in the payment terms position.
Default Text Code Payment Terms	Allows the user to define a default text code that will be printed in all documents if the document header does not hold a text code. It is also possible to define an ext. text per Payment Term.
Print Description 2	If selected, TSR reports will also print Description 2 fields.
E-Mail Options	This field contains the options to describe which e-mail address will be used for sending an e-mail to the customer: Standard Sell-to Customer Sell-to Contact or Standard Sell-to Contact or Sell-to Customer
Always show Ship-To Address on Sales Invoice	This field defines that the Ship-To Address will always be shown on a sales invoice.
Always show Ship-To Address on Service Invoice	This field defines that the Ship-To Address will always be shown on a service invoice.
Always show Ship-To Address on Rental Invoice	This field defines that the Ship-To Address will always be shown on a rental invoice.
Resize Picture on Import	This field defines, whether imported pictures will be resized.
Update Document Text on Posting	If selected, then the posting of a document will check and update texts from the assigned document texts.

Back to parent section

Table 5445558 — Traser Setup: 'Customer' FastTab

Field	Description
Def. Invoice Copies	Allows users to define a default number of invoice copies that will be printed additionally when printing an invoice.
Def. Shipment Copies	Allows users to define a default number of shipment copies that will be printed additionally when printing an invoice.
Def. Credit Memo Copies	Allows users to define a default number of credit memo copies that will be printed additionally when printing an invoice.
Check Cash Cust. Posting	If selected, users have to confirm each time they select a customer marked as Cash Customer in any open document (exception: in PoS documents, this confirmation does not happen).
Calc. Customer Statement Starting Date	Defines a date formula that will prefill the starting date of the customer statement report for you, whenever it is executed in John Deere DBS. So for example `-1Y` will result in a customer statement for the last year.

Back to parent section

Service

Field	Description
Hide Machine Availability	If selected, the standard Microsoft Dynamics 365 Business Central notification that is displayed when the Available Qty. vlaue of an item line is not enough will be suppressed in service documents.
Do not show 100% Discount
Warning if Unit Price is zero while posting for Service	If selected, John Deere DBS checks (when all jobs have Repair Status = Reviewed) if there are service lines with a price of zero. If yes, John Deere DBS displays a warning. Additionally, during the posting process, users get the same warning if there are service lines with zero-price.
Default Work Type Code (Machine Line)	Fills in service item lines in any service order with this value by default.
Synch. Drop Shipment for Service Lines
Default Qty. to Ship	Remainder: If selected, Qty. to Ship in service lines will be filled with remaining Qty. Blank: If selected, the Qty. to Ship in service lines will stay empty.
Responsibility Center Mandatory (Service)	If activated, Resp. Center needs a value in the service header, otherwise an error is displayed while posting.
Don't print Service Shipment	If selected, the service shipment note is not printed.
Additional Order Cost Card Code
Calculate Foreman Surcharge
Foreman Surcharge Code
Set Repair Status Automatically at Shipping	If activated, a specific repair status will be set after shipping.
Repair Status Code	Defines the repair status which is set when the service order is shipped.
Set Start and End Date by TempVision
Archiving Service	Defines when you want to archive service quotes/orders Never: Never archive Question: message when deleting or make order Always: always archive when deleting or making order.
Hide Lines Manually
Set Work Order Type Desc.
Delete Service Orders Delayed
Reason Code is mandatory for Service Archiving
Show Credit Limit Warning Only Once
One Machine per Service Contract	When this is set to true, users can only use one machine per service contract -> has to be defined in the Service Contract Header then.
Show Service Notification in Service Document
Set Repair Status automatically after Dime Resource Allocation	If activated, a specific repair status will be set after shipping allocating resources in Dime.Scheduler.
Repair Status Code	Defines the repair status which is set when resources are allocated in Dime.Scheduler.
Enable Service Partial Invoice Check
Hide Calc. Price and Cost Factboxes
Clear Quantity to Ship
Use Annual Amount in Service Contracts
Component Calculation Base	Unit Cost: Attaching parts to machine will base the revaluation during the component posting on unit cost of the part Unit Price: Attaching parts to machine will base the revaluation during the component posting on unit price of the part.
Gen. Prod. Posting Group for Capitalized Service	Defines a default value for capitalized service service lines for general product posting groups.
Reason Code for Capitalized Service	Defines the reason code for capitalized service entries.
Keeping Duration
Standard Jobs
Default Resource Code	Defines a default resource for standard job calculation.
Default Work Type Code	Defines the default work type for standard jobs.
Labour on Documents
Show Labour As	First Position: labor will be printed before part lines in service documents Last Position: labor will be printed after part lines in service documents.
Group Labour By	None: each resource line is printed separately. Only Total Sum: resource lines will be accumulated, and only a total is printed. Total Sum and Resource Groups: resource lines will be accumulated per resource group and a sum is printed each. Total Sum and Work Type: resource lines will be accumulated per work type and a sum is printed each.
Labour Description on Document	Users can define free text as to how labor lines will be printed when sums are used.
Labour Charge Description on Document
Service Picking List
Default Pick. List Lines in Machine Worksheet
Machine Worksheet
Default Complaint Lines in Machine Worksheet
Default Fault Lines in Machine Worksheet
Default Solution Lines in Machine Worksheet
Default Comment Lines in Machine Worksheet
Default Hint Lines in Machine Worksheet
Barcode Type
Attachment/Detachment
Service Order Nos.
Customer No.
Service Order Type
Warranty
Warranty Claim Nos.	Defines the number series which is used for warranty claims.
Sync. Service to Warranty
Show Warranty Warning
Approval Automation
Approve Resource
Approve Job
Approve Service
Approve Absence
Approve Assembly Order
Buffer Service Notification
Buffer in Days
Buffer in Operating Hours

Back to parent section

Machine

Field	Description
New	Defines the variant code identifying New Machines. These variant codes can for example be used for differentiating inventory accounts for New/Used machinery.
Used	Defines the variant code identifying Used Machines. These variant codes can for example be used for differentiating inventory accounts for New/Used machinery.
Initial Machine Status	Defines which status from the service item status table to use when a new machine record is created.
Machine Status for Scrap	Defines which status from the service item status table to use when a machine is scrapped; This means as linked with a fixed asset and the fixed asset was sold with a unit price of zero.
Machine Status for Sale	Defines which status from the service item status table to use when a machine was sold.
Default Machine Status at Return Postings	Defines which status from the service item status table to use when a machine was returned.
Machine Status for Trade-In	Defines which status from the service item status table to use when a sales trade-in is invoice for a machine.
Print Comp. Lines before Data
Notify missing Fields
Machine Description	Allows user to select how the Description of a machine record will be automatically filled by John Deere DBS: Brand + Family + Model Brand + Model.
Delete Machine on Sales Cr. Memo
Warning if Financing Exists	If activated, John Deere DBS will notify the user when a machine is selected in a sales document and a financing record exists for this machine.
Default Allocate to Calculation Review at Agency
Don't clear Serial No. by clearing Item No.
Don't Overwrite warranty starting date
Check if Open Service Orders Exist
Use Extended Warranty
Standard Base Warranty Code
Calc. Offer Currency
Revaluation
Revaluation Journal Template Name
Revaluation Journal Batch Name
Default Values
Default Item Tracking Code
Default Item Template Code	Defines the item template used when John Deere DBS automatically creates a machine record and must create a corresponding new item record, or when the user clicks on New Item in the machine record. The automatic creation of machine and/or item record happens, for example, when an offer is won or when a stock order is released.
Default Base Unit of Measure
Variant Code Update
Variant Code Update Item Journal Template Name
Variant Code Update Item Journal Batch Name
Variant Code Update Source Code Component Posting
Variant Code Update Reason Code
Variant Code Update Entry Description

Back to parent section

Ext. Attributes

Field	Description
Print in Sales	If selected, the extended attributes set up in the machine are printed in sales orders.
Print in Purchase	If selected, the extended attributes set up in the machine are printed in purchase orders.
Print in Rental	If selected, the extended attributes set up in the machine are printed in rental documents.

Back to parent section

Forecast Calculation

Field	Description
Default VAT Prod. Posting Group
Service Order Type for Differential Taxation
Code for new Calc. in Calc. Projects
Surcharge %
Default Gross Profit %
Default Item for Config. Lines from Forecast
Deactivate Approval

Back to parent section

Calculation Preview

Field	Description
Max. Pmt. Disc. % possible
Activate Rental Return on Investment
Default Startdate for Calc. Reviews
Analysis Review Report Name
Default Analysis Review Report Name for EAC
Default Analysis Review Report Name for Trade-In AC
Code for New Calc. in Calc. Projects
Life Cycle of Review Projects
Default Allocate to Calc. Preview (Sales)
Default Allocate to Calc. Preview (Purchase)
Default Allocate to Calc. Preview (Service)
Equipment Templates Def. Series

Back to parent section

TempVision

Field	Description
Type of Time Sheet Description
Resource Unit of Measure Hours
Labour Rounding Precision
DS TempVision Integration
Dime.Scheduler Absence Description
Time Tracking
Resource Present Time Desc.
Res. Present Work Type Code
Working Hours

Back to parent section

Warehouse

Field	Description
Set Shipment Date in Sales Line to WORKDATE
Posting Date at item undo
Gen. Bus. Posting Group Gross Price
Reason Code Mandatory
Delete Warehouse Receipts after posting
Stock Stacking Due Period
Create Stockkeeping Unit
Mobile Warehouse activated
Default Bin Code for Sales Lines
Default Bin Code for Service Lines
Calculate Item Availability Without Purchase Orders
Default Due Date Formula (Shopping Basket)
Activate devaluation
Stockkeeping Unit
Create Per
Default Zone Code
Default Bin Type Code
Synchronize Vendor No. in Stockkeeping Unit

Back to parent section

Purchase

Field	Description
Warning if unit price is zero while posting for Purchase
Release Purch Order while Printing
Confirm Synchronization between purchase and sales/service
Vendor Shipment No. Mandatory
Clear Vendor Shipment No. after Shipping
Clear Vendor Invoice No. After Invoicing
Don't overwrite Document Date
Item Line Without Order Reference
Default Bill-to Adress
Pay-to/Buy-from Item Price Finding
Responsibility Center Mandatory (Purchase)	If activated, John Deere DBS will check on posting of any purchase document if the responsibility center in the header was filled.
Return Reason Mandatory

Back to parent section

Sales

Field	Description
Contact Person No. Series
Contact Drop Box Interaction Templ. Code
Warning if unit price is zero while posting for Sales	If activated, users will be warned when posting a line where the unit price is zero.
Synch. Drop Shipment for Sales Lines
Create Shipment Info Text in Sales Order for partial deliveries	If activated, a partial delivery will lead to a text line being created in the corresponding sales order holding the shipment number of the shipment.
Insert Order No. in Combine Invoice	If activated and using the Combine Shipment functionality for creating invoices, there will be text lines in the invoices showing from which sales orders the shipments were combined.
Registration No./VAT Reg. No. Mandatory at Credit Memo	If activated, the posting of any credit memo in John Deere DBS is only possible if the corresponding master data record of the header has a registration number / VAT registration number.
Responsibility Center Mandatory (Sales)	If activated, John Deere DBS will check on posting of any sales document if the responsibility center was filled in the header.
Discount Calculation
Return Reason Mandatory
Campaign end warning
Default Reason Code by Posting	Defines the default reason code that will be used when posting a sales document.
Default Lost Sales/Service Reason Code
Default Transfer Order Order Type	Allows the user to define a default order code in the order code table that will always be used for transfer orders.
Finance Disclaimer standard Text Code
Customers Rack Bin Code
Tender Contract No. Series	Defines specific number series for Tender Contracts.
Machine in multiple Sales Documents
Hide Lines Manually	If activated, the Boolean Hide Line in sales lines will be editable. This allows users to select document lines that should not be printed.
Quote Expiration
Close Opportunity Code Mandatory	If set to true, a close opportunity code is mandatory when closing an opportunity (e.g., when marking an opportunity as lost, John Deere DBS asks the user for a reason why it was lost).
Win
Lost
No-Buy

Back to parent section

Requisition Line per Order

Field	Description
Transfer Attached to Line No.
Open in Req. Line Vendor
Open Item Vendors in Req. Line
Clear Purchasing Code at deleting allocation
Sorting for Req. Wksh. Lines
Ship-to addresses
Activate showing ship-to address after validating customer no. in sales header per user
Save Sales Ship-To Addresses
Code for new Ship-To Addresses

Back to parent section

Add-Ins

Field	Description
Install Add-Ins at Start for every User	If selected, all add-ins will automatically be installed of all users when John Deere DBS is first started.

Back to parent section

Source Code Setup

Field	Description
Machine Ledger Entry
Sales	Defines the source code for all sales-related entries in the machine ledger entries.
Purchase	Defines the source code for all purchase-related entries in the machine ledger entries.
Service Management	Defines the source code for all service management-related entries in the machine ledger entries.
Inventory Change	Defines the source code for all item ledger-related entries in the machine ledger entries.
Inventory Value Change	Defines the source code for all revaluation-related entries in the machine ledger entries.

Back to parent section

Dimensions

Field

Description

Dimensions for Charge (Item)

This field allows to define how dimension value entries are generated for item charges:
Item: the item charge will have the same dimension values as the item of the respective document line the item charge was assigned to.
Charge(Item): the item charge will use its own dimension setup.
Request at allocation: users will have to select if item or item charge dimensions should be used with each item charge assignment.

Location Dimension Code

Back to parent section

Nonstock Item

Field	Description
Nonstock Item Surcharge
Modify Surcharged Items
Source Default Item Disc. Group
Allow Editing Prices from Nonstock Items
Standard Rounding Method
Default Change Unit Price %
Default Change Unit Cost %

Back to parent section

Purch. Document Mgt.

Field	Description
Activate Purch. Document Mgt.
Separate G/L Entries
Default Document Rcpt. Date
Print Barcode

Back to parent section

Trade-Ins

Field	Description
Trade-In Nos.	Defines specific number series for trade-ins.
Pstd. Trade-In Nos. (Receipt)	Defines specific number series for posted trade-in receipts.
Pst. Trade-In Nos.	Defines specific number series for posted trade-ins.
Customer No. at Machine	This customer will be written into the machine record when receiving a trade-in.
Create Prev. Owner at Posting
Automatic revaluation of Trade-Ins

Back to parent section

Mach. Community Mgt.

|Field|Description|
|Activate Machine Community Mgt.|Only if selected, machine community functionality of John Deere DBS 365 is available.|
|Machine Community G/L Account No.|Defines the reconciliation account that will be used for splitting up document postings.|
|Print First Invoice|If selected, also the original header document will be printed together with split documents.|

Back to parent section

Rental

Field	Description
Insurance Price Term Code
Insurance Price Term
Insurance Unit of Measure Code
Insurance Unit of Measure
Don't Reserve Rental Quote Line
Responsibility Center Mandatory (Rental)
Return Reason Mandatory
Rental Checklist Source
Insurance in Rental Reports
Default Rental Counter Type
Activate Extra Hours Mgt.
Invoicing
Def. Gen. Prod. Posting Group
Def. VAT Prod. Posting Group
Def. VAT Prod. Posting Group Rental
Def. Inventory Posting Group
Def. Gen. Prod. Posting Grp. Int. Rental
Def. Gen. Prod. Posting Grp. Ext. Rental
Def. Gen. Prod. Posting Grp. Hire
Def. Gen. Prod. Posting Grp. Leasing
Def. Gen. Prod. Posting Grp. Write Up
Defaults
Rental Object Type Source
Counter Type Operating Hours
Credit % on Early Return
Std. Rental Charge Days
Debit on Return Day
Price Term
Use Advanced Mgt. Calendar
Default Func. Test
Use Hourly Rent
Def. Mandatory Counter on Return
Ship-to addresses
Save Rental Ship-To Addresses
Machine Ledger Entry
Rental
Notify to Enter Counter in Rental Contract
Delete Machine with Object
Check if Rental Price is Zero
Caption “Ship-to Address” in Rental Contract
Full Charge of Insurance while using Stand-By Charge
Don't create a rental object from object type "Item"
Synch. Serv. Item, FA, Object
Open Object Sales Price Card

Back to parent section

Transport

Field	Description
Transport Quote Nos.
Transport Order Nos.
Machine No.

Back to parent section

Table 5445559 — Traser User Setup

In this table, general user settings are made for John Deere DBS.

Note

Field	Description
Create Item
Create Machine
Allow Change of Trade No.	Only if this is activated, users can change the trade number of a machine.
Show Ship-To Address after validating customer no. in sales header	If this checkbox is selected and if more than one Ship-To Address exists for the selected customer, John Deere DBS will ask the user to select a Ship-To Address via showing all of them after entering the customer.
Allow to change Serial No.	Only if this is activated, users can change the serial number of a machine.
Block Customer
Purchaser Code
Purchase Permissions
Salesperson Code
Sales Manager
Sales Admin
Warranty Admin
Sales Permissions
Service Permissions
Rental Permissions
Person in Charge Code
Responsibility Center
Filter Lists to TRASER User Setup Responsibility Center
Area Manager Responsibility Centers
Filter Lists to TRASER Order Type Filter
Suspend Dimension Update
Service Order Type
Sales Order Type
Purchase Order Type
Rental Order Type
Sales Documents
Purchase Documents
Rental Documents
Service Documents
Worksheet Template Name
Journal Batch Name
Shopping Basket-Worksheet Template Name
Shopping Basket-Journal Template Name
Calculation Offer Release
Calculation Review Release
Set Calculation Permissions
Show Printer Dialog
Show Item Instructions
Show Machine Instructions
Display Direct Unit Cost
Print Barcode (Purch. Doc.)
Person In Charge (Reminder)
Person In Charge (Finance Charge Memo)
Disable Create Rental Order
Analysis Review Report Name Filter
Profile ID
Spare Part Calculation
Time of Calculation
SignPad connection
SignPad IP connection
SignPad IP Address Port
Allow manual editing Commission Entry
Allow manual close/open of Commission Entry
Allow edit profit in Service Item for Commission
Kobelco Interface

Back to parent section

Table 5446207 — John Deere Setup

In this table, John Deere-specific settings are made for John Deere DBS.

Note

The table consists of the following FastTabs:

General
Dealer Nos.
Manufacturer Minimum Margin
DPM Stock Mgt. Export
Import Requisitions
Parts Receipts
JD Prism Interface
PM Manage Export
Import Documents
Parts Locator
Parts Advisor Import
Import of the price list
Import TS Programs
PM Link
Parts Information
Profile Interface
GPC Interface (Online Configurator)
IBS Interface (Incentive Bulletin System)
Warranty Interface
DFA
JD Link
Authorized Parts Returns
OrderStatus Interface
Interfaces

Back to parent section

General

Field	Description
Main Dealer No.
Unique Dealer Account
Brand Code
Default Order Type MD
Microsoft Dynamics NAV Version No.
Download Poll Result File
Upload Poll Result File
Price Currency
Activate OKTA
Refresh Access Token before Expiration (Minutes)
Default Warranty Claim Type
John Deere Customer No.

Back to parent section

Dealer Nos.

Field	Description
Dealer No.
Responsibility Center
Warehouse No.
Vendor No. Spare Parts
Vendor No. Machine
Vendor No. (Debit Memo)
Template Name John Deere Req. Wksh.
Journal Batch Name John Deere Req. Wksh.
Journal Batch Name John Deere Req. Wksh.
G/L Account No. (Add. Fee)
Transfer

Back to parent section

Manufacturer Minimum Margin

Field	Description
Item Category Code
Brand Code
Description
Manufacturer Name
Category Description
Minimum Margin

Back to parent section

DPM Stock Mgt. Export

Field	Description
Activate Stock Mgt. Export
Data Load Location
Pricing Base
Send Non-Deere Parts
Sparepart Invt. Post.Grp. Code

Back to parent section

Import Requisitions

Field	Description
Activate Import Electr. Requisitions
Order Type Stock Order

Back to parent section

Parts Receipts

Field	Description
Activate Parts Receipts

Back to parent section

JD Prism Interface

Field	Description
JD Prism Interface Active

Back to parent section

PM Manage Export

Field	Description
Activate PMManage
PMManage Split To

Back to parent section

Import Documents

Field	Description
Activate Import Documents
Def. Item Charge for Parts Invoices
Def. Item Charge for Boxing
Def. Item charge for Machine Inv./Cr. M.
Default Item Template Code
Activate Import Machine Invoices
Activate Import Machine Cr.Memos
Activate Warranty Credit Memos
Activate Import Debit Memos

Back to parent section

Parts Locator

Field	Description
Activate Parts Locator
Last used Item Ledger Entry
Last used Warehouse Entry
Parts Locator File Option
Next Export Date

Back to parent section

Parts Advisor Import

Field	Description
Activate Parts Advisor Import

Back to parent section

Import of the price list

Field	Description
Default Unit of Measure per Piece
Default Unit of Measure per Package
Default Item Template Code
Default Core Variant Code

Back to parent section

Import TS Programs

Field	Description
Activate Import TS Programs
TS Program Interface Code
Highlight Expiring TS Programm (Duration)
Only Items sold within last (duration)
Default TS Order Type

Back to parent section

PM Link

Field	Description
Activate PMLink
Okta Interface code
PMLink Url
PMLink Order Status Url
PMLink Vendor
JD Bin Code for Cumulated Purchase Line
Auto Fill Qty. Per Package Code

Back to parent section

Parts Information

Field	Description
Activate Parts Information
Okta Interface Code
Webservice Url
Parts Information Vendor

Back to parent section

Profile Interface

Field	Description
Profile Interface active
Profile Webservice Url

Back to parent section

GPC Interface (Online Configurator)

Field	Description
GPC Interface Active
Okta Interface Code
GPC Webservice Url
GPC Cart Link
Country Code for GPC
Language Code for GPC
Dealer Net Price Discount %

Back to parent section

IBS Interface (Incentive Bulletin System)

Field	Description
IBS Interface Active
Okta Interface Code
IBS Webservice URL
IBS Discount Type
IBS Country
IBS Locale

Back to parent section

Warranty Interface

Field	Description
Warranty Interface Active
Warranty Processing Method
Okta Interface Code
Use Dealer Doc. Nos. For Posted Invoices
Document No. Series
Warranty Webservice Url
Warranty Default Resource
Warranty Portal Url
Parts Adjustment Resource No.
Total Adjustment Resource No.
Default Material Code
Customer Invoice Service Order Type
Customer Credit Memo Resource No.
Deductible Service Order Type
Deductible Amount Resource No.
Job Queue Autom. Claim Update
Warranty Job Queue User Active
Warranty Job Queue User

Back to parent section

DFA

Field	Description
Source Dealer No.
Schedule Name
DFA Export Folder
DFA Division Code

Back to parent section

JD Link

Field	Description
JD Link Interface Active
Okta interface Code
JD Link API URl
MyJohnDeere API URl
Delete data older as

Back to parent section

Authorized Parts Returns

Field	Description
Active
Vendor

Back to parent section

OrderStatus Interface

Field	Description
OrderStatus Interface Active
OrderStatus Interface Code

Back to parent section

Interfaces

Field	Description
Code
Description
Description 2
Filename
File Directory
Archive Directory
Interface Version

Back to parent section

Individual Setup Tables — Tier 2

Sorting	Table ID	Table Name	Comment/Dependent on
Tier 2	80	Gen. Journal Template	No. Series
Tier 2	82	Item Journal Template	No. Series
Tier 2	92	Customer Posting Group	G/L Account
Tier 2	93	Vendor Posting Group	G/L Account
Tier 2	98	General Ledger Setup	No. Series, Dimension
Tier 2	232	Gen. Journal Batch	No. Series, G/L Account
Tier 2	233	Item Journal Batch	No. Series
Tier 2	245	Requisition Wksh. Name	Req. Wksh. Template
Tier 2	250	Gen. Business Posting Group	VAT Business Posting Group
Tier 2	251	Gen. Product Posting Group	VAT Product Posting Group
Tier 2	289	Payment Method	G/L Account, Bank Account
Tier 2	293	Reminder Level
Tier 2	311	Sales & Receivables Setup	VAT Business Posting Group
Tier 2	312	Purchases & Payables Setup
Tier 2	313	Inventory Setup
Tier 2	325	VAT Posting Setup	VAT Business Posting Group, VAT Product Posting Group, G/L Account
Tier 2	800	Online Map Setup	Online Map Parameter Setup
2	5206	Cause of Absence	Human Resource Unit of Measure
Tier 2	5605	FA Journal Setup	FA Journal Template, FA Journal Batch, Gen. Journal Template, Gen. Journal Batch, Insurance Journal Template, Insurance Journal Batch
Tier 2	5606	FA Posting Group	G/L Account
Tier 2	5619	FA Journal Template	No. Series, Source Code
Tier 2	5623	FA Reclass. Journal Batch	FA Reclass. Journal Template
Tier 2	5634	Insurance Journal Batch	No. Series, Insurance Journal Template
Tier 2	5714	Responsibility Center	Location, Dimension
Tier 2	5718	Nonstock Item	Vendor, Brand, Config. Template Header
Tier 2	5720	Brand	Vendor
Tier 2	5742	Transfer Route	Location
Tier 2	5813	Inventory Posting Setup	Location, G/L Account, Inventory Posting Group
Tier 2	5911	Service Mgt. Setup	No. Series, Base Calendar
Tier 2	5940	Machine
Tier 2	5973	Service Contract Account Group
Tier 2	5996	Standard Service Code	Work Type
Tier 2	7002	Sales Price	Item, Customer, Customer Price Group, etc.
Tier 2	7004	Sales Line Discount	Item, Customer, Customer Price Group, etc.
Tier 2	7012	Purchase Price	Item, Vendor
Tier 2	7014	Purchase Line Discount	Item, Vendor
Tier 2	7301	Warehouse Employee	Location, User
Tier 2	7354	Bin	Location
Tier 2	7601	Base Calendar Change	Base Calendar
Tier 2	8618	Config. Template Header
Tier 2	5445560	TRASER Filter Setup	Repair Status, Service Order Type
Tier 2	5445572	Standard Job
Tier 2	5445580	Order Code Line	Order Type
Tier 2	5445659	Service Item Model	Brand, Family, Series
Tier 2	5445757	Rental Pay Scale Group	Family
Tier 2	5446145	Barcode Setup	VAT Business Posting Group
Tier 2	5446208	JD Interface
Tier 2	15000600	EQM Rental Setup	No. Series, EQM Price Term, Base Calendar
Tier 2	15000622	EQM Loc. Cost Center Comb.	Location, Dimension Value
Tier 2	15000669	EQM Rental Line Discount	EQM Object Card
Tier 2	15000744	EQM Price Term Translation	EQM Price Term
Tier 2	15000761	EQM Rental Inv. Sequence Line	EQM Rent.Inv. Sequence Header

Back to parent section

Table 245 — Requisition Wksh. Name

Worksheet Template Name	Name	Description	TS-Program Master Worksheet	Responsibility Center (Central Ordering)
REQ	BASKET	Shopping Basket Worksheet	False

Back to parent section

Table 800 — Online Map Setup

Primary Key	Map Parameter Setup Code	Distance In	Route
	BING	Kilometers	Quickest

Important

Some of the fields are predefined in John Deere DBS and should not be modified individually.

Back to parent section

Table 5206 — Cause of Absence

Code	Description	Unit of Measure Code
DAYOFF	Day Off	HOUR
HOLIDAY	Holiday	DAY
SICK	Sick	HOUR

Back to parent section

Individual Setup Tables — Tier 3

Sorting	Table ID	Table Name	Comment/Dependent on
Tier 3	252	General Posting Setup	G/L Account, Gen. Business Posting Group, Gen. Product Posting Group
Tier 3	294	Reminder Text
Tier 3	329	Currency for Reminder Level	Currency, Reminder Level
Tier 3	5608	FA Subclass	FA Class, FA Posting Group
Tier 3	5620	FA Journal Batch	No. Series, FA Journal Template
Tier 3	5800	Item Charge	Gen. Product Posting Group
Tier 3	5997	Standard Service Line	Standard Service Code, Item, Resource, Nonstock Item
Tier 3	8619	Config. Template Line	Config. Template Header
Tier 3	5445559	TRASER User Setup	User
Tier 3	5445724	Calc. Mark-Up Setup	Brand, Family, Series, Model
Tier 3	15000603	EQM Rental Price

Back to parent section

Table 8619 — Config. Template Line

This table is customizable by dealers. Below entries serve as a reference and first high-level setup:

Data Template Code	Line No.	Type	Field ID	Field Name	Table ID	Mandatory	Default Value	Skip Relation Check	Language ID
MACHINES	10000	Field	8	Base Unit of Measure	27	False	PCS	False	1033
MACHINES	20000	Field	21	Costing Method	27	False	Specific	False	1033
MACHINES	30000	Field	5702	Item Category Code	27	False	MACHINES	False	1033
MACHINES	40000	Field	91	Gen. Prod. Posting Group	27	False	MACHINES	False	1033
MACHINES	50000	Field	11	Inventory Posting Group	27	False	MACHINES	False	1033
MACHINES	60000	Field	99	VAT Prod. Posting Group	27	False	19	False	1033
MACHINES	70000	Field	6500	Item Tracking Code	27	False	SNALL	False	1033
PARTS	5000	Field	8	Base Unit of Measure	27	True	PCS	False	1033
PARTS	10000	Field	91	Gen. Prod. Posting Group	27	True		False	1033
PARTS	20000	Field	99	VAT Prod. Posting Group	27	True		False	1033
PARTS	30000	Field	11	Inventory Posting Group	27	True		False	1033
PARTS	40000	Field	21	Costing Method	27	True	Average	False	1033
PARTS	50000	Field	5702	Item Category Code	27	True	PARTS	False	1033

Important

As shown in the table above, the added fields are mandatory to fill to fulfill all needs which we are expecting from a configuration template being used in John Deere DBS. Blank Default Value fields need to be filled by the national partner.

Back to parent section

Individual Setup Tables — Tier 4

The optional setup tables should contain regional or dealer specific information and can be set up by the local NAV partner:

Sorting	Table ID	Table Name	Comment/Dependent on
Tier 4	5968	Service Contract Template	Payment Terms, Responsibility Center, Service Contract Account Group, Standard Service Code, Service Location, Service Order Type, Brand, Family, Series, Model
Tier 4	15000637	EQM Object Journal Setup	User, EQM Object Journal Template, EQM Object Journal Batch
Tier 4	5	Finance Charge Terms
Tier 4	6	Customer Price Group
Tier 4	7	Standard Text
Tier 4	10	Shipment Method
Tier 4	11	Country/Region Translation
Tier 4	19	Cust. Invoice Disc.
Tier 4	24	Vendor Invoice Disc.
Tier 4	60	Document Sending Profile
Tier 4	84	Acc. Schedule Name	s
Tier 4	85	Acc. Schedule Line
Tier 4	91	User Setup
Tier 4	98	General Ledger Setup	Reporting (& Application)
Tier 4	204	Unit of Measure	Add optional values
Tier 4	284	Area
Tier 4	291	Shipping Agent
Tier 4	560	VAT Clause
Tier 4	843	Cash Flow Setup	G/L Account, No. Series
Tier 4	856	Cash Flow Report Selection
Tier 4	5083	Team
Tier 4	5087	Profile Questionnaire Header
Tier 4	5088	Profile Questionnaire Line
Tier 4	5095	Duplicate Search String Setup
Tier 4	5790	Shipping Agent Services	Shipping Agent
Tier 4	5957	Service Zone
Tier 4	7303	Bin Type
Tier 4	7307	Put-away Template Header
Tier 4	7381	Phys. Invt. Counting Period
Tier 4	5445581	Ext. Default Dimension	Dimension
Tier 4	5445597	Nonstock Item Surcharge	Vendor No., Customer Price Group, Brand, Item Disc. Group, Item Category
Tier 4	5445660	Service Interval
Tier 4	5445686	Brand Item Disc. Group	Brand, Item Disc. Group
Tier 4	5445927	Shopping Basket Setup	Brand
Tier 4	5446146	BulkSMS Setup
Tier 4	5446166	Business Domain
Tier 4	5446167	Business Domain Payment Term	Payment Terms, Payment Method, Business Domain
Tier 4	5446249	Service Print Template
Tier 4	5446253	Warehouse Receipt Sorting	Repair Status, Order Type
Tier 4	15000604	EQM Object Status Template	EQM Object Type
Tier 4	15000612	EQM Rental Group
Tier 4	15000613	EQM Rental Template
Tier 4	15000629	EQM Addition on Termination	EQM Object Type, Resource, Item
Tier 4	15000631	EQM Addition on Start
Tier 4	15000645	EQM Rental Insurance
Tier 4	15000670	EQM Object Discount Group
Tier 4	15008712	EQM Mandatory Bin Setup	Location, EQM Object Type

Back to parent section

Table 15000637 — EQM Object Journal Setup

User ID	FA Jnl. Template Name	FA Jnl. Batch Name	Bal. Value Jnl. Template Name	Bal. Value Jnl. Batch Name	In/Out Transfer Template Name	In/Out Transfer Batch Name	Terminate FA Jnl. Templ. Name	Terminate FA Jnl. Batch Name
					OBJECT	DEFAULT

The marked fields have to be empty following the John Deere DBS process.

Back to parent section