Difference between revisions of "Data Import Destinations"

From Catalyst
Jump to: navigation, search
Line 1: Line 1:
{{Review}}
+
== Summary ==
 +
Platinum allows you to import to the majority of files within the system. This article gives a list of these destinations and the section of the system to which these relate.
  
==Summary==
+
== More Information ==
Platinum allows you to import to the majority of files within the system. Below is a list of these destinations and the section of the system these relate to.  
+
By choosing the correct destination, you will have the data fields that you want to use available to be filled in by the import.  
  
==Destinations==
+
== Destinations ==
*{{DataValue|LDAD}} - Account Address File - Use this destination for importing new or editing existing customers and suppliers.
+
* {{DataValue|LDAD}} - Account Address File
 +
** Use this destination for importing new or editing existing customers and suppliers.
  
*{{DataValue|LDCC}} - Sales/Purchase Cost Centres - Use this destination for importing new or editing existing Sales or Purchase Cost Centres.
+
* {{DataValue|LDCC}} - Sales/Purchase Cost Centres  
 +
** Use this destination for importing new or editing existing Sales or Purchase Cost Centres.
  
*{{DataValue|LDNC}} - Nominal Centres - Use this destination for importing new or editing existing Nominal Centres.
+
* {{DataValue|LDNC}} - Nominal Centres  
 +
** Use this destination for importing new or editing existing Nominal Centres.
  
*{{DataValue|LDNO}} - Nominal Transactions - Use this destination for importing transactions against Nominal Centres.
+
* {{DataValue|LDNO}} - Nominal Transactions
 +
** Use this destination for importing transactions against Nominal Centres.
  
*{{DataValue|LDTR}} - Transaction File - Use this destination for importing transactions against customer or supplier accounts.
+
* {{DataValue|LDTR}} - Transaction File
 +
** Use this destination for importing transactions against customer or supplier accounts.
  
*{{DataValue|OPOR}} - Order Processing Orders - Use this destination for importing new or editing existing sales or purchase orders.
+
* {{DataValue|OPOR}} - Order Processing Orders  
 +
** Use this destination for importing new or editing existing sales or purchase orders.
  
*{{DataValue|PRPE}} - Payroll Employee File - Use this destination for importing new or editing exisiting employees in the payroll system.  
+
* {{DataValue|PRPE}} - Payroll Employee File
 +
** Use this destination for importing new or editing existing employees in the payroll system.  
  
*{{DataValue|PRPX}} - Payroll Transaction File
+
* {{DataValue|PRPX}} - Payroll Transaction File
 +
** Use this destination for importing transactions onto the payroll system.
  
*{{DataValue|SPPR}} - Sales Prospecting Prospects - Use this destination for importing new or editing exisiting Prospects and contacts against them.
+
* {{DataValue|SPPR}} - Sales Prospecting Prospects  
 +
** Use this destination for importing new or editing existing Prospects and contacts against them.
  
*{{DataValue|STPT}} - Stock Parts File - Use this destination for importing new or editing exisiting Stock components and associations.
+
* {{DataValue|STPT}} - Stock Parts File
 +
** Use this destination for importing new or editing existing Stock components and associations.
  
*{{DataValue|STSA}} - Stock Applications - Use this destination for importing new or editing exisiting Stock applications.
+
* {{DataValue|STSA}} - Stock Applications  
 +
** Use this destination for importing new or editing existing Stock applications.
  
*{{DataValue|STSD}} - Stock Shadow File - Use this destination for importing new or editing exisiting stock items in the Shadow file.
+
* {{DataValue|STSD}} - Stock Shadow File  
 +
** Use this destination for importing new or editing existing stock items into the Shadow file.
  
*{{DataValue|STSE}} - Stock Alternatives - Use this destination for importing new or editing exisiting stock stock alternatives.
+
* {{DataValue|STSE}} - Stock Alternatives  
 +
** Use this destination for importing new or editing existing stock stock alternatives.
  
*{{DataValue|STSH}} - Stock History File - Use this destination for importing to the stock history.
+
* {{DataValue|STSH}} - Stock History File  
 +
** Use this destination for importing to the stock history.
  
*{{DataValue|STSI}} - Stock Invoice File - Use this destination for importing stock invoices to the system
+
* {{DataValue|STSI}} - Stock Invoice File
 +
** Use this destination for importing stock invoices to the system
  
*{{DataValue|STSP}} - Stock Supplier File - Use this destination for importing stock codes against a particular supplier.
+
* {{DataValue|STSP}} - Stock Supplier File  
 +
** Use this destination for importing stock codes against a particular supplier.
  
*{{DataValue|STST}} - Stock File - Use this destination for importing new or editing exisiting Stock Items in the main stock file.
+
* {{DataValue|STST}} - Stock File
 +
** Use this destination for importing new or editing existing Stock Items in the main stock file.
  
*{{DataValue|TCTC}} - Transport Costings - Use this destination for importing costs against transport vehicles.  
+
* {{DataValue|TCTC}} - Transport Costings
 +
** Use this destination for importing costs against transport vehicles.  
  
*{{DataValue|TITI}} - Logistics Management - Use this destination for importing new or editing existing tickets in Logistics Management.
+
* {{DataValue|TITI}} - Logistics Management  
 +
** Use this destination for importing new or editing existing tickets in Logistics Management.
  
*{{DataValue|VSVE}} - Vehicle Sales Vehicle File - Use this destination for importing new or editing existing vehicles.
+
* {{DataValue|VSVE}} - Vehicle Sales Vehicle File
 +
** Use this destination for importing new or editing existing vehicles.
  
*{{DataValue|VSVM}} - Vehicle Model File - Use this destination for importing new or editing existing vehicle models.  
+
* {{DataValue|VSVM}} - Vehicle Model File  
 +
** Use this destination for importing new or editing existing vehicle models.  
  
*{{DataValue|VSVX}} - Vehicle Expenses File - Use this destination for importing expenses against a vehicle.  
+
* {{DataValue|VSVX}} - Vehicle Expenses File
 +
** Use this destination for importing expenses against a vehicle.  
  
*{{DataValue|WSJB}} - Workshop Job File - Use this destination for importing new or editing existing workshop jobs.
+
* {{DataValue|WSJB}} - Workshop Job File  
 +
** Use this destination for importing new or editing existing workshop jobs.
  
==See Also==
+
== See Also ==
 
*[[Data Import - Getting Started]]
 
*[[Data Import - Getting Started]]
 
*[[How do I import a Data Import template?]]
 
*[[How do I import a Data Import template?]]
 
*[[How do I export a Data Import template?]]
 
*[[How do I export a Data Import template?]]
 
{{KB_IM}} {{KB_Tags|Data Import, Destinations, Import}}
 
{{KB_IM}} {{KB_Tags|Data Import, Destinations, Import}}

Revision as of 23:04, 12 January 2010

Summary

Platinum allows you to import to the majority of files within the system. This article gives a list of these destinations and the section of the system to which these relate.

More Information

By choosing the correct destination, you will have the data fields that you want to use available to be filled in by the import.

Destinations

  • 'LDAD' - Account Address File
    • Use this destination for importing new or editing existing customers and suppliers.
  • 'LDCC' - Sales/Purchase Cost Centres
    • Use this destination for importing new or editing existing Sales or Purchase Cost Centres.
  • 'LDNC' - Nominal Centres
    • Use this destination for importing new or editing existing Nominal Centres.
  • 'LDNO' - Nominal Transactions
    • Use this destination for importing transactions against Nominal Centres.
  • 'LDTR' - Transaction File
    • Use this destination for importing transactions against customer or supplier accounts.
  • 'OPOR' - Order Processing Orders
    • Use this destination for importing new or editing existing sales or purchase orders.
  • 'PRPE' - Payroll Employee File
    • Use this destination for importing new or editing existing employees in the payroll system.
  • 'PRPX' - Payroll Transaction File
    • Use this destination for importing transactions onto the payroll system.
  • 'SPPR' - Sales Prospecting Prospects
    • Use this destination for importing new or editing existing Prospects and contacts against them.
  • 'STPT' - Stock Parts File
    • Use this destination for importing new or editing existing Stock components and associations.
  • 'STSA' - Stock Applications
    • Use this destination for importing new or editing existing Stock applications.
  • 'STSD' - Stock Shadow File
    • Use this destination for importing new or editing existing stock items into the Shadow file.
  • 'STSE' - Stock Alternatives
    • Use this destination for importing new or editing existing stock stock alternatives.
  • 'STSH' - Stock History File
    • Use this destination for importing to the stock history.
  • 'STSI' - Stock Invoice File
    • Use this destination for importing stock invoices to the system
  • 'STSP' - Stock Supplier File
    • Use this destination for importing stock codes against a particular supplier.
  • 'STST' - Stock File
    • Use this destination for importing new or editing existing Stock Items in the main stock file.
  • 'TCTC' - Transport Costings
    • Use this destination for importing costs against transport vehicles.
  • 'TITI' - Logistics Management
    • Use this destination for importing new or editing existing tickets in Logistics Management.
  • 'VSVE' - Vehicle Sales Vehicle File
    • Use this destination for importing new or editing existing vehicles.
  • 'VSVM' - Vehicle Model File
    • Use this destination for importing new or editing existing vehicle models.
  • 'VSVX' - Vehicle Expenses File
    • Use this destination for importing expenses against a vehicle.
  • 'WSJB' - Workshop Job File
    • Use this destination for importing new or editing existing workshop jobs.

See Also


Feedback
Thank you for using our Knowledge Base, we value your feedback. Did you find this article useful? 'Yes' or 'No'
Keywords AND Misspellings
Data Import, Destinations, Import