Difference between revisions of "Data Import Destinations"

From Catalyst
Jump to: navigation, search
(See Also)
m
 
(3 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 
== Summary ==
 
== 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.  
+
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 ==
 
== 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.  
+
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
 
* {{DataValue|LDAD}} - Account Address File
 
** Use this destination for importing new or editing existing customers and suppliers.
 
** Use this destination for importing new or editing existing customers and suppliers.
  
* {{DataValue|LDCC}} - Sales/Purchase Cost Centres  
+
* {{DataValue|LDCC}} - Sales/Purchase Cost Centres
 
** Use this destination for importing new or editing existing Sales or Purchase Cost Centres.
 
** Use this destination for importing new or editing existing Sales or Purchase Cost Centres.
  
* {{DataValue|LDNC}} - Nominal Centres  
+
* {{DataValue|LDNC}} - Nominal Centres
 
** Use this destination for importing new or editing existing Nominal Centres.
 
** Use this destination for importing new or editing existing Nominal Centres.
  
Line 21: Line 21:
 
** Use this destination for importing transactions against customer or supplier accounts.
 
** Use this destination for importing transactions against customer or supplier accounts.
  
* {{DataValue|OPOR}} - Order Processing Orders  
+
* {{DataValue|OPOR}} - Order Processing Orders
 
** Use this destination for importing new or editing existing sales or purchase orders.
 
** Use this destination for importing new or editing existing sales or purchase orders.
  
 
* {{DataValue|PRPE}} - Payroll Employee File
 
* {{DataValue|PRPE}} - Payroll Employee File
** Use this destination for importing new or editing existing employees in the payroll system.  
+
** Use this destination for importing new or editing existing employees in the payroll system.
  
 
* {{DataValue|PRPX}} - Payroll Transaction File
 
* {{DataValue|PRPX}} - Payroll Transaction File
Line 33: Line 33:
 
** Use this destination for importing Attributes, Interests, Features and Job Types.
 
** Use this destination for importing Attributes, Interests, Features and Job Types.
  
* {{DataValue|SPPR}} - Sales Prospecting Prospects  
+
* {{DataValue|SPPR}} - Sales Prospecting Prospects
 
** Use this destination for importing new or editing existing Prospects and contacts against them.
 
** Use this destination for importing new or editing existing Prospects and contacts against them.
 +
 +
* {{DataValue|STDP}} - Stock Depot File
 +
** Use this destination for importing new or editing existing Stock Depots.
 +
 +
* {{DataValue|STHD}} - Stock Shadow Group File
 +
** Use this destination for importing new or editing existing Stock Shadow groups and discounts.
  
 
* {{DataValue|STPT}} - Stock Parts File
 
* {{DataValue|STPT}} - Stock Parts File
 
** Use this destination for importing new or editing existing Stock components and associations.
 
** Use this destination for importing new or editing existing Stock components and associations.
  
* {{DataValue|STSA}} - Stock Applications  
+
* {{DataValue|STSA}} - Stock Applications
 
** Use this destination for importing new or editing existing Stock applications.
 
** Use this destination for importing new or editing existing Stock applications.
  
* {{DataValue|STSD}} - Stock Shadow File  
+
* {{DataValue|STSD}} - Stock Shadow File
 
** Use this destination for importing new or editing existing stock items into the Shadow file.
 
** Use this destination for importing new or editing existing stock items into the Shadow file.
  
* {{DataValue|STSE}} - Stock Alternatives  
+
* {{DataValue|STSE}} - Stock Alternatives
 
** Use this destination for importing new or editing existing stock stock alternatives.
 
** Use this destination for importing new or editing existing stock stock alternatives.
  
* {{DataValue|STSH}} - Stock History File  
+
* {{DataValue|STSH}} - Stock History File
 
** Use this destination for importing to the stock history.
 
** Use this destination for importing to the stock history.
  
Line 54: Line 60:
 
** Use this destination for importing stock invoices to the system
 
** Use this destination for importing stock invoices to the system
  
* {{DataValue|STSP}} - Stock Supplier File  
+
* {{DataValue|STSP}} - Stock Supplier File
 
** Use this destination for importing stock codes against a particular supplier.
 
** Use this destination for importing stock codes against a particular supplier.
  
Line 61: Line 67:
  
 
* {{DataValue|TCTC}} - Transport Costings
 
* {{DataValue|TCTC}} - Transport Costings
** Use this destination for importing costs against transport vehicles.  
+
** Use this destination for importing costs against transport vehicles.
  
* {{DataValue|TITI}} - Logistics Management  
+
* {{DataValue|TITI}} - Logistics Management
 
** Use this destination for importing new or editing existing tickets in Logistics Management.
 
** Use this destination for importing new or editing existing tickets in Logistics Management.
  
* {{DataValue|VSVE}} - Vehicle Sales Vehicle File
+
* {{DataValue|VSVE}} - Unit Sales Unit File
** Use this destination for importing new or editing existing vehicles.
+
** Use this destination for importing new or editing existing units.
  
* {{DataValue|VSVM}} - Vehicle Model File  
+
* {{DataValue|VSVM}} - Unit Model File
** Use this destination for importing new or editing existing vehicle models.  
+
** Use this destination for importing new or editing existing unit models.
  
* {{DataValue|VSVX}} - Vehicle Expenses File
+
* {{DataValue|VSVX}} - Unit Expenses File
** Use this destination for importing expenses against a vehicle.  
+
** Use this destination for importing expenses against a unit.
  
* {{DataValue|WSJB}} - Workshop Job File  
+
* {{DataValue|WSJB}} - Workshop Job File
 
** Use this destination for importing new or editing existing workshop jobs.
 
** Use this destination for importing new or editing existing workshop jobs.
  
== See Also ==
+
== See also ==
 
* [[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_Tags|Data Import, Destinations, Import}}
+
{{KB_Tags|data import, destinations, import}}
 
{{KB_IM}}
 
{{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