Choosing a Sample *.DEF File

When the product was installed, the system automatically copied master *.DEF files into the Import\Master DEF Files directory—MasterAB.DEF, MasterAP.DEF, MasterAR.DEF, MasterBK.DEF, MasterFA.DEF, MasterGL.DEF, MasterInvAdj.DEF, MasterMCRATE, MasterOE.DEF, MasterPO.DEF, MasterPR.DEF, MasterT1.DEF, and MasterT3.DEF.

The master *.DEF files, which are designed to work with *.CSV data files, list all fields available for import. You can make a copy of the master *.DEF file (\Import\Master DEF Files) that applies to your import, and then customize it to fit your needs. Also, each one contains a predefined error exception file name. For more information about using the predefined error exception file, see Error Exception File.

Note that the 3rd Party Samples directory (\MIP SHARE\IMPORT\3RD PARTY SAMPLES) contains CSV (comma separated variable) and fixed-width formatted data files, and corresponding *.DEF files for importing data from other software. You can make a copy of these DEF and data files, and then customize them. Note that these sample *.DEF files do not contain a predefined error exception file name.

Alternatively, you can review and/or copy sample *.DEF and data files to get an idea of how to set up your own.

• For CSV samples, copy the *.DEF and *.CSV files from \Import\CSV Samples.
• For currency-specific CSV samples to be used with the Multicurrency module, copy the *.DEF and *.CSV files from \Import\CSV MC Samples.
• For fixed-width samples, copy the *.DEF and *.TXT files from \Import\Fixed Width Samples.

Note: These sample *.DEF files do not contain a predefined error exception file name. Only the master *.DEF files contains the predefined error exception file.

The following sample *.DEF files can be used to import the designated data:

Sample File	Header/Detail Records	Record Type	Data Imported
SampleGL.DEF	Header	COACODE	Chart of Accounts
	Header	CLOSEACCT	Closing Account Assignments
	Header	OFFSET	Offset Account Assignments
	Header/Detail	DISTCODE	Distribution Codes
	Header	CHKSPOIL	Check Spoilage
	Header	EMAILTEMPLATE	Email Template
SampleAP.DEF	Header/Detail	VENDOR	Vendors
	Header	VENDADDR_CODES	Vendor Check Address
SampleAR.DEF	Header	CUSTOMER	Customers
	Header	CUSTOMERSHIPADDR	Customer Ship Address
SampleAB.DEF	Header/Detail	CHARGECODE	Charge Codes
	Header/Detail	ONETIMECHARGES	One Time Charges
SampleBK.DEF	Header	BKREC	Bank Reconciliation Items
SampleFA.DEF	Header	DESGCODES	Designation Codes
	Header	ASSETS	Asset Codes
	Header	FATYPE	Asset Types
	Header/Detail	FADEPR	Custom Depreciation Codes
SampleInvAdj.DEF	Header/Detail	INVADJMENT	Inventory Adjustment
SampleOE.DEF	Header/Detail	OENTRY	Sales Order Entry
SampleT1.DEF	Header Header/Detail	SESSION	Session, Header, Detail Transactions
Sample T1USEDIST.DEF	Header Header/Detail	SESSION	Session Header, Detail Transactions Using Distribution Codes
SampleT3.DEF	Header Header/Detail	SESSION	Session, Header, Detail Transactions
SampleT3ENL.DEF	Header Header/Detail	SESSION	Session, Header, Detail Transactions - Encumbrance Liquidations
SampleT3USEDIST.DEF	Header Header/Detail	SESSION	Session, Header, Detail Transactions Using Distribution Codes
SampleT3JV.DEF	Header Header/Detail	SESSION	Session, Header, Detail Transactions - Journal Vouchers
SamplePO.DEF	Header	ITEMCODES	Item Codes
SamplePR.DEF	Header/Detail	DISTCODE	Distribution Codes
	Header	PGRPCODE	Processing Group Codes
	Header	EARNINGCODE	Earning Codes
	Header/Detail	BENEFITCODE	Benefit Codes
	Header	DEDUCTIONCODE	Deduction Codes
	Header/Detail	WORKCOMPCODE	Workers' Comp Codes
	Header/Detail	LEAVECODE	Leave Codes
	Header	STATETAX	State Tax Codes
	Header/Detail	LOCALTAX	Other Tax Codes
	Header/Detail	EMPLOYEE	Employee Information
	Header/Detail	TIMESHEET	Timesheet
	Header/Detail	ADJUSTBALANCES	Adjust Employee Balances

Note: We suggest that separate *.DEF and data files be set up for each record type. For example, a separate file should be set up for COACODE (Chart of Accounts Records) and VENDOR (Vendor Records).