Importing into the SalesPad Mobile GP catalog tables

There are two tables that will need to have data imported into them in order to successfully add catalog items to be used in SalesPad Mobile GP via SQL import. The data in the second table, spgpm.CatalogItemDefinition, is reliant on the data in the first table, spgpm.Catalog, so the Catalog table must be populated first.

• spgpm.Catalog
  • Catalog_ID
    • This is an identity column; it should not require any interaction from a user.
    • This field does not allow duplicate values. If they are present, errors could occur.
  • Catalog_Name
    • There is a 50 character limit.
    • This is the name of the catalog as it will be displayed in the Mobile Console.
    • It allows null values, however, null values should be avoided for proper processing.
  • Customer_Num
    • There is a 50 character limit.
    • It must be a valid GP customer number.
    • It contains the customer number that this catalog will be used for.
    • It allows null values, however, null values should be avoided for proper processing.
  • Doc_ID
    • There is a 50 character limit.
    • It must be a valid GP Sales Doc Type.
    • The catalog will apply for this document ID.
    • It allows null values, however, null values should be avoided for proper processing.
  • Description
    • There is a 255 character limit.
    • It contains the description of the catalog in the database.
    • It allows null values.
  • Customer_Name
    • There is a 255 character limit.
    • It is the name associated with the Customer entered in the Customer_Num field.
    • It allows null values.
• spgpm.CatalogLineItemDefinition
  • CatalogLineItem_ID
    • It is an integer value.
    • This is an identity column; it should not require any interaction from a user.
    • This field does not allow duplicate values. If they are present, errors could occur.
  • Catalog_ID
    • It is an integer value.
    • This column identifies the catalog with which the line is associated; it must match the appropriated Catalog_ID value from spgpm.Catalog.
    • This column contributes to the primary key on the table; there cannot be a line with the same combination of CatalogLineItem_ID and Catalog_ID.
  • Item_Number
    • There is a 50 character limit.
    • It must be a valid GP Item Number.
    • This is the item number for the catalog line being imported.
    • It allows null values, however, null values should be avoided for proper processing.
  • Par_Qty
    • It is a numeric value allowing 19 characters before the decimal place and 5 after.
    • This column is the core column built in for custom purposes. Most environments will not utilize it.
    • It does not allow nulls. The default value is 0.
  • Item_Description
    • There is a 255 character limit.
    • It is the item description associated with the catalog line’s item number.
    • It allows null values.
  • Seq
    • It is an integer.
    • It controls the order in which items occur on screen.
    • Multiple lines with an identical combination of Catalog ID and Seq are not allowed.
    • It does not allow null values.
  • Item_Short_Name
    • There is a 255 character limit.
    • It contains the Short Description of this item.
    • It allows null values.