Difference between revisions of "Data Import Destinations"

From Catalyst
Jump to: navigation, search
m
 
(6 intermediate revisions by 5 users not shown)
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|RPHF}} - Header File
 +
** Use this destination for importing Attributes, Interests, Features and Job Types.
  
*{{DataValue|STPT}} - Stock Parts File - Use this destination for importing new or editing exisiting Stock components and associations.
+
* {{DataValue|SPPR}} - Sales Prospecting Prospects
 +
** Use this destination for importing new or editing existing Prospects and contacts against them.
  
*{{DataValue|STSA}} - Stock Applications - Use this destination for importing new or editing exisiting Stock applications.
+
* {{DataValue|STDP}} - Stock Depot File
 +
** Use this destination for importing new or editing existing Stock Depots.
  
*{{DataValue|STSD}} - Stock Shadow File - Use this destination for importing new or editing exisiting stock items in the Shadow file.
+
* {{DataValue|STHD}} - Stock Shadow Group File
 +
** Use this destination for importing new or editing existing Stock Shadow groups and discounts.
  
*{{DataValue|STSE}} - Stock Alternatives  - Use this destination for importing new or editing exisiting stock stock alternatives.
+
* {{DataValue|STPT}} - Stock Parts File
 +
** Use this destination for importing new or editing existing Stock components and associations.
  
*{{DataValue|STSH}} - Stock History File - Use this destination for importing to the stock history.
+
* {{DataValue|STSA}} - Stock Applications
 +
** Use this destination for importing new or editing existing Stock applications.
  
*{{DataValue|STSI}} - Stock Invoice File - Use this destination for importing stock invoices to the system
+
* {{DataValue|STSD}} - Stock Shadow File
 +
** Use this destination for importing new or editing existing stock items into the Shadow file.
  
*{{DataValue|STSP}} - Stock Supplier File - Use this destination for importing stock codes against a particular supplier.
+
* {{DataValue|STSE}} - Stock Alternatives
 +
** Use this destination for importing new or editing existing stock stock alternatives.
  
*{{DataValue|STST}} - Stock File - Use this destination for importing new or editing exisiting Stock Items in the main stock file.
+
* {{DataValue|STSH}} - Stock History File
 +
** Use this destination for importing to the stock history.
  
*{{DataValue|TCTC}} - Transport Costings - Use this destination for importing costs against transport vehicles.
+
* {{DataValue|STSI}} - Stock Invoice File
 +
** Use this destination for importing stock invoices to the system
  
*{{DataValue|TITI}} - Logistics Management - Use this destination for importing new or editing existing tickets in Logistics Management.
+
* {{DataValue|STSP}} - Stock Supplier File
 +
** Use this destination for importing stock codes against a particular supplier.
  
*{{DataValue|VSVE}} - Vehicle Sales Vehicle File - Use this destination for importing new or editing existing vehicles.
+
* {{DataValue|STST}} - Stock File
 +
** Use this destination for importing new or editing existing Stock Items in the main stock file.
  
*{{DataValue|VSVM}} - Vehicle Model File - Use this destination for importing new or editing existing vehicle models.  
+
* {{DataValue|TCTC}} - Transport Costings
 +
** Use this destination for importing costs against transport vehicles.
  
*{{DataValue|VSVX}} - Vehicle Expenses File - Use this destination for importing expenses against a vehicle.  
+
* {{DataValue|TITI}} - Logistics Management
 +
** Use this destination for importing new or editing existing tickets in Logistics Management.
  
*{{DataValue|WSJB}} - Workshop Job File - Use this destination for importing new or editing existing workshop jobs.
+
* {{DataValue|VSVE}} - Unit Sales Unit File
 +
** Use this destination for importing new or editing existing units.
  
==See Also==
+
* {{DataValue|VSVM}} - Unit Model File
*[[Data Import - Getting Started]]
+
** Use this destination for importing new or editing existing unit models.
*[[How do I import a Data Import template?]]
+
 
*[[How do I export a Data Import template?]]
+
* {{DataValue|VSVX}} - Unit Expenses File
{{KB_IM}} {{KB_Tags|Data Import, Destinations, Import}}
+
** Use this destination for importing expenses against a unit.
 +
 
 +
* {{DataValue|WSJB}} - Workshop Job File
 +
** Use this destination for importing new or editing existing workshop jobs.
 +
 
 +
== See also ==
 +
* [[How do I import a Data Import template?]]
 +
* [[How do I export a Data Import template?]]
 +
 
 +
{{KB_Tags|data import, destinations, import}}
 +
{{KB_IM}}

Latest revision as of 16:13, 20 February 2019

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.
  • 'RPHF' - Header File
    • Use this destination for importing Attributes, Interests, Features and Job Types.
  • 'SPPR' - Sales Prospecting Prospects
    • Use this destination for importing new or editing existing Prospects and contacts against them.
  • 'STDP' - Stock Depot File
    • Use this destination for importing new or editing existing Stock Depots.
  • 'STHD' - Stock Shadow Group File
    • Use this destination for importing new or editing existing Stock Shadow groups and discounts.
  • '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' - Unit Sales Unit File
    • Use this destination for importing new or editing existing units.
  • 'VSVM' - Unit Model File
    • Use this destination for importing new or editing existing unit models.
  • 'VSVX' - Unit Expenses File
    • Use this destination for importing expenses against a unit.
  • '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