ePages 6.10 - DE_EPAGES/DHL/API/Table/DHLProductList.pm

Package DE_EPAGES::DHL::API::Table::DHLProductList

interface for table DHLProductList

@EXPORT_OK
InsertDHLProductList
UpdateDHLProductList
DeleteDHLProductList
GetAllPKeyDHLProductLists
GetAllInfoDHLProductLists
GetInfoDHLProductList
ExistsDHLProductList
GetPKeyDHLProductListsByWeightKgMin
GetInfoDHLProductListsByWeightKgMin
GetPKeyDHLProductListsByWeightKgMax
GetInfoDHLProductListsByWeightKgMax
GetPKeyDHLProductListsByLengthCmMin
GetInfoDHLProductListsByLengthCmMin
GetPKeyDHLProductListsByLengthCmMax
GetInfoDHLProductListsByLengthCmMax
GetPKeyDHLProductListsByWidthCmMin
GetInfoDHLProductListsByWidthCmMin
GetPKeyDHLProductListsByWidthCmMax
GetInfoDHLProductListsByWidthCmMax
GetPKeyDHLProductListsByHeightCmMin
GetInfoDHLProductListsByHeightCmMin
GetPKeyDHLProductListsByHeightCmMax
GetInfoDHLProductListsByHeightCmMax
GetPKeyDHLProductListsByLengthWidthHeightCmMin
GetInfoDHLProductListsByLengthWidthHeightCmMin
GetPKeyDHLProductListsByLengthWidthHeightCmMax
GetInfoDHLProductListsByLengthWidthHeightCmMax
GetPKeyDHLProductListsByValidFrom
GetInfoDHLProductListsByValidFrom
GetPKeyDHLProductListsByValidTo
GetInfoDHLProductListsByValidTo
GetPKeyDHLProductListsByProductID
GetInfoDHLProductListsByProductID

Functions

DeleteDHLProductList
ExistsDHLProductList
GetAllInfoDHLProductLists
GetAllPKeyDHLProductLists
GetInfoDHLProductList
GetInfoDHLProductListsByHeightCmMax
GetInfoDHLProductListsByHeightCmMin
GetInfoDHLProductListsByLengthCmMax
GetInfoDHLProductListsByLengthCmMin
GetInfoDHLProductListsByLengthWidthHeightCmMax
GetInfoDHLProductListsByLengthWidthHeightCmMin
GetInfoDHLProductListsByProductID
GetInfoDHLProductListsByValidFrom
GetInfoDHLProductListsByValidTo
GetInfoDHLProductListsByWeightKgMax
GetInfoDHLProductListsByWeightKgMin
GetInfoDHLProductListsByWidthCmMax
GetInfoDHLProductListsByWidthCmMin
GetPKeyDHLProductListsByHeightCmMax
GetPKeyDHLProductListsByHeightCmMin
GetPKeyDHLProductListsByLengthCmMax
GetPKeyDHLProductListsByLengthCmMin
GetPKeyDHLProductListsByLengthWidthHeightCmMax
GetPKeyDHLProductListsByLengthWidthHeightCmMin
GetPKeyDHLProductListsByProductID
GetPKeyDHLProductListsByValidFrom
GetPKeyDHLProductListsByValidTo
GetPKeyDHLProductListsByWeightKgMax
GetPKeyDHLProductListsByWeightKgMin
GetPKeyDHLProductListsByWidthCmMax
GetPKeyDHLProductListsByWidthCmMin
InsertDHLProductList
UpdateDHLProductList

DeleteDHLProductList

Deletes a(n) DHLProductList.

Syntax
DeleteDHLProductList($DHLProductListID);
DeleteDHLProductList($hDHLProductList); # if $hDHLProductList includes DHLProductListID
Input
$DHLProductListID (int)
Internal ID of the DHL Product (primary key)

ExistsDHLProductList

Returns true if the DHLProductList exists.

Syntax
$exists = ExistsDHLProductList($DHLProductListID);
Input
$DHLProductListID (int)
Internal ID of the DHL Product
Return
$exists (boolean)
1/0 the DHLProductList exists (yes/no)

GetAllInfoDHLProductLists

Returns all objects of DHLProductList.

Syntax
$ahDHLProductLists = GetAllInfoDHLProductLists();
Return
$ahDHLProductLists (reference to array of hashes)
with following keys:
  • DHLProductListID - Internal ID of the DHL Product (primary key)- int
  • ProductID - DHL product list xml tag: id - varchar(255)
  • Supplier - DHL product list xml tag: anbieter (optional)- varchar(255)
  • DisplayName - DHL product list xml tag: anzeigename (optional)- varchar(255)
  • DisplayText - DHL product list xml tag: anzeigetext (optional)- varchar(255)
  • PictureURL - DHL product list xml tag: bildUrl (optional)- varchar(255)
  • ValidFrom - DHL product list xml tag: gueltigvon (optional)- datetime
  • ValidTo - DHL product list xml tag: gueltigbis (optional)- datetime
  • WeightKgMin - DHL product list xml tag: gewichtKgMin (optional)- float
  • WeightKgMax - DHL product list xml tag: gewichtKgMax (optional)- float
  • LengthCmMin - DHL product list xml tag: laengeCmMin (optional)- float
  • LengthCmMax - DHL product list xml tag: laengeCmMax (optional)- float
  • WidthCmMin - DHL product list xml tag: breiteCmMin (optional)- float
  • WidthCmMax - DHL product list xml tag: breiteCmMax (optional)- float
  • HeightCmMin - DHL product list xml tag: hoeheCmMin (optional)- float
  • HeightCmMax - DHL product list xml tag: hoeheCmMax (optional)- float
  • LengthWidthHeightCmMin - DHL product list xml tag: laengeBreiteHoeheCmMin (optional)- float
  • LengthWidthHeightCmMax - DHL product list xml tag: laengeBreiteHoeheCmMax (optional)- float
  • URL - DHL product list xml tag: url (optional)- varchar(255)
  • TOS - DHL product list xml tag: agb (optional)- varchar(255)
  • PrintAdvice - DHL product list xml tag: druckhinweis (optional)- varchar(255)

GetAllPKeyDHLProductLists

Returns all DHLProductList identifiers.

Syntax
$aDHLProductListIDs = GetAllPKeyDHLProductLists();
Return
$aDHLProductListIDs (reference to array of int)
Internal ID of the DHL Product

GetInfoDHLProductList

Returns the DHLProductList by identifier.

Syntax
$hDHLProductList = GetInfoDHLProductList($DHLProductListID);
Input
$DHLProductListID (int)
Internal ID of the DHL Product (primary key)
Return
$hDHLProductList (reference to hash)
with following keys:
  • DHLProductListID - Internal ID of the DHL Product (primary key)- int
  • ProductID - DHL product list xml tag: id - varchar(255)
  • Supplier - DHL product list xml tag: anbieter (optional)- varchar(255)
  • DisplayName - DHL product list xml tag: anzeigename (optional)- varchar(255)
  • DisplayText - DHL product list xml tag: anzeigetext (optional)- varchar(255)
  • PictureURL - DHL product list xml tag: bildUrl (optional)- varchar(255)
  • ValidFrom - DHL product list xml tag: gueltigvon (optional)- datetime
  • ValidTo - DHL product list xml tag: gueltigbis (optional)- datetime
  • WeightKgMin - DHL product list xml tag: gewichtKgMin (optional)- float
  • WeightKgMax - DHL product list xml tag: gewichtKgMax (optional)- float
  • LengthCmMin - DHL product list xml tag: laengeCmMin (optional)- float
  • LengthCmMax - DHL product list xml tag: laengeCmMax (optional)- float
  • WidthCmMin - DHL product list xml tag: breiteCmMin (optional)- float
  • WidthCmMax - DHL product list xml tag: breiteCmMax (optional)- float
  • HeightCmMin - DHL product list xml tag: hoeheCmMin (optional)- float
  • HeightCmMax - DHL product list xml tag: hoeheCmMax (optional)- float
  • LengthWidthHeightCmMin - DHL product list xml tag: laengeBreiteHoeheCmMin (optional)- float
  • LengthWidthHeightCmMax - DHL product list xml tag: laengeBreiteHoeheCmMax (optional)- float
  • URL - DHL product list xml tag: url (optional)- varchar(255)
  • TOS - DHL product list xml tag: agb (optional)- varchar(255)
  • PrintAdvice - DHL product list xml tag: druckhinweis (optional)- varchar(255)

GetInfoDHLProductListsByHeightCmMax

Returns objects of DHLProductList by alternate key HeightCmMax.

Syntax
$ahDHLProductLists = GetInfoDHLProductListsByHeightCmMax($HeightCmMax);
Input
$HeightCmMax (float)
DHL product list xml tag: hoeheCmMax
Return
$ahDHLProductLists (reference to array of hashes)
with following keys:
  • DHLProductListID - Internal ID of the DHL Product (primary key)- int
  • ProductID - DHL product list xml tag: id - varchar(255)
  • Supplier - DHL product list xml tag: anbieter (optional)- varchar(255)
  • DisplayName - DHL product list xml tag: anzeigename (optional)- varchar(255)
  • DisplayText - DHL product list xml tag: anzeigetext (optional)- varchar(255)
  • PictureURL - DHL product list xml tag: bildUrl (optional)- varchar(255)
  • ValidFrom - DHL product list xml tag: gueltigvon (optional)- datetime
  • ValidTo - DHL product list xml tag: gueltigbis (optional)- datetime
  • WeightKgMin - DHL product list xml tag: gewichtKgMin (optional)- float
  • WeightKgMax - DHL product list xml tag: gewichtKgMax (optional)- float
  • LengthCmMin - DHL product list xml tag: laengeCmMin (optional)- float
  • LengthCmMax - DHL product list xml tag: laengeCmMax (optional)- float
  • WidthCmMin - DHL product list xml tag: breiteCmMin (optional)- float
  • WidthCmMax - DHL product list xml tag: breiteCmMax (optional)- float
  • HeightCmMin - DHL product list xml tag: hoeheCmMin (optional)- float
  • HeightCmMax - DHL product list xml tag: hoeheCmMax (optional)- float
  • LengthWidthHeightCmMin - DHL product list xml tag: laengeBreiteHoeheCmMin (optional)- float
  • LengthWidthHeightCmMax - DHL product list xml tag: laengeBreiteHoeheCmMax (optional)- float
  • URL - DHL product list xml tag: url (optional)- varchar(255)
  • TOS - DHL product list xml tag: agb (optional)- varchar(255)
  • PrintAdvice - DHL product list xml tag: druckhinweis (optional)- varchar(255)

GetInfoDHLProductListsByHeightCmMin

Returns objects of DHLProductList by alternate key HeightCmMin.

Syntax
$ahDHLProductLists = GetInfoDHLProductListsByHeightCmMin($HeightCmMin);
Input
$HeightCmMin (float)
DHL product list xml tag: hoeheCmMin
Return
$ahDHLProductLists (reference to array of hashes)
with following keys:
  • DHLProductListID - Internal ID of the DHL Product (primary key)- int
  • ProductID - DHL product list xml tag: id - varchar(255)
  • Supplier - DHL product list xml tag: anbieter (optional)- varchar(255)
  • DisplayName - DHL product list xml tag: anzeigename (optional)- varchar(255)
  • DisplayText - DHL product list xml tag: anzeigetext (optional)- varchar(255)
  • PictureURL - DHL product list xml tag: bildUrl (optional)- varchar(255)
  • ValidFrom - DHL product list xml tag: gueltigvon (optional)- datetime
  • ValidTo - DHL product list xml tag: gueltigbis (optional)- datetime
  • WeightKgMin - DHL product list xml tag: gewichtKgMin (optional)- float
  • WeightKgMax - DHL product list xml tag: gewichtKgMax (optional)- float
  • LengthCmMin - DHL product list xml tag: laengeCmMin (optional)- float
  • LengthCmMax - DHL product list xml tag: laengeCmMax (optional)- float
  • WidthCmMin - DHL product list xml tag: breiteCmMin (optional)- float
  • WidthCmMax - DHL product list xml tag: breiteCmMax (optional)- float
  • HeightCmMin - DHL product list xml tag: hoeheCmMin (optional)- float
  • HeightCmMax - DHL product list xml tag: hoeheCmMax (optional)- float
  • LengthWidthHeightCmMin - DHL product list xml tag: laengeBreiteHoeheCmMin (optional)- float
  • LengthWidthHeightCmMax - DHL product list xml tag: laengeBreiteHoeheCmMax (optional)- float
  • URL - DHL product list xml tag: url (optional)- varchar(255)
  • TOS - DHL product list xml tag: agb (optional)- varchar(255)
  • PrintAdvice - DHL product list xml tag: druckhinweis (optional)- varchar(255)

GetInfoDHLProductListsByLengthCmMax

Returns objects of DHLProductList by alternate key LengthCmMax.

Syntax
$ahDHLProductLists = GetInfoDHLProductListsByLengthCmMax($LengthCmMax);
Input
$LengthCmMax (float)
DHL product list xml tag: laengeCmMax
Return
$ahDHLProductLists (reference to array of hashes)
with following keys:
  • DHLProductListID - Internal ID of the DHL Product (primary key)- int
  • ProductID - DHL product list xml tag: id - varchar(255)
  • Supplier - DHL product list xml tag: anbieter (optional)- varchar(255)
  • DisplayName - DHL product list xml tag: anzeigename (optional)- varchar(255)
  • DisplayText - DHL product list xml tag: anzeigetext (optional)- varchar(255)
  • PictureURL - DHL product list xml tag: bildUrl (optional)- varchar(255)
  • ValidFrom - DHL product list xml tag: gueltigvon (optional)- datetime
  • ValidTo - DHL product list xml tag: gueltigbis (optional)- datetime
  • WeightKgMin - DHL product list xml tag: gewichtKgMin (optional)- float
  • WeightKgMax - DHL product list xml tag: gewichtKgMax (optional)- float
  • LengthCmMin - DHL product list xml tag: laengeCmMin (optional)- float
  • LengthCmMax - DHL product list xml tag: laengeCmMax (optional)- float
  • WidthCmMin - DHL product list xml tag: breiteCmMin (optional)- float
  • WidthCmMax - DHL product list xml tag: breiteCmMax (optional)- float
  • HeightCmMin - DHL product list xml tag: hoeheCmMin (optional)- float
  • HeightCmMax - DHL product list xml tag: hoeheCmMax (optional)- float
  • LengthWidthHeightCmMin - DHL product list xml tag: laengeBreiteHoeheCmMin (optional)- float
  • LengthWidthHeightCmMax - DHL product list xml tag: laengeBreiteHoeheCmMax (optional)- float
  • URL - DHL product list xml tag: url (optional)- varchar(255)
  • TOS - DHL product list xml tag: agb (optional)- varchar(255)
  • PrintAdvice - DHL product list xml tag: druckhinweis (optional)- varchar(255)

GetInfoDHLProductListsByLengthCmMin

Returns objects of DHLProductList by alternate key LengthCmMin.

Syntax
$ahDHLProductLists = GetInfoDHLProductListsByLengthCmMin($LengthCmMin);
Input
$LengthCmMin (float)
DHL product list xml tag: laengeCmMin
Return
$ahDHLProductLists (reference to array of hashes)
with following keys:
  • DHLProductListID - Internal ID of the DHL Product (primary key)- int
  • ProductID - DHL product list xml tag: id - varchar(255)
  • Supplier - DHL product list xml tag: anbieter (optional)- varchar(255)
  • DisplayName - DHL product list xml tag: anzeigename (optional)- varchar(255)
  • DisplayText - DHL product list xml tag: anzeigetext (optional)- varchar(255)
  • PictureURL - DHL product list xml tag: bildUrl (optional)- varchar(255)
  • ValidFrom - DHL product list xml tag: gueltigvon (optional)- datetime
  • ValidTo - DHL product list xml tag: gueltigbis (optional)- datetime
  • WeightKgMin - DHL product list xml tag: gewichtKgMin (optional)- float
  • WeightKgMax - DHL product list xml tag: gewichtKgMax (optional)- float
  • LengthCmMin - DHL product list xml tag: laengeCmMin (optional)- float
  • LengthCmMax - DHL product list xml tag: laengeCmMax (optional)- float
  • WidthCmMin - DHL product list xml tag: breiteCmMin (optional)- float
  • WidthCmMax - DHL product list xml tag: breiteCmMax (optional)- float
  • HeightCmMin - DHL product list xml tag: hoeheCmMin (optional)- float
  • HeightCmMax - DHL product list xml tag: hoeheCmMax (optional)- float
  • LengthWidthHeightCmMin - DHL product list xml tag: laengeBreiteHoeheCmMin (optional)- float
  • LengthWidthHeightCmMax - DHL product list xml tag: laengeBreiteHoeheCmMax (optional)- float
  • URL - DHL product list xml tag: url (optional)- varchar(255)
  • TOS - DHL product list xml tag: agb (optional)- varchar(255)
  • PrintAdvice - DHL product list xml tag: druckhinweis (optional)- varchar(255)

GetInfoDHLProductListsByLengthWidthHeightCmMax

Returns objects of DHLProductList by alternate key LengthWidthHeightCmMax.

Syntax
$ahDHLProductLists = GetInfoDHLProductListsByLengthWidthHeightCmMax($LengthWidthHeightCmMax);
Input
$LengthWidthHeightCmMax (float)
DHL product list xml tag: laengeBreiteHoeheCmMax
Return
$ahDHLProductLists (reference to array of hashes)
with following keys:
  • DHLProductListID - Internal ID of the DHL Product (primary key)- int
  • ProductID - DHL product list xml tag: id - varchar(255)
  • Supplier - DHL product list xml tag: anbieter (optional)- varchar(255)
  • DisplayName - DHL product list xml tag: anzeigename (optional)- varchar(255)
  • DisplayText - DHL product list xml tag: anzeigetext (optional)- varchar(255)
  • PictureURL - DHL product list xml tag: bildUrl (optional)- varchar(255)
  • ValidFrom - DHL product list xml tag: gueltigvon (optional)- datetime
  • ValidTo - DHL product list xml tag: gueltigbis (optional)- datetime
  • WeightKgMin - DHL product list xml tag: gewichtKgMin (optional)- float
  • WeightKgMax - DHL product list xml tag: gewichtKgMax (optional)- float
  • LengthCmMin - DHL product list xml tag: laengeCmMin (optional)- float
  • LengthCmMax - DHL product list xml tag: laengeCmMax (optional)- float
  • WidthCmMin - DHL product list xml tag: breiteCmMin (optional)- float
  • WidthCmMax - DHL product list xml tag: breiteCmMax (optional)- float
  • HeightCmMin - DHL product list xml tag: hoeheCmMin (optional)- float
  • HeightCmMax - DHL product list xml tag: hoeheCmMax (optional)- float
  • LengthWidthHeightCmMin - DHL product list xml tag: laengeBreiteHoeheCmMin (optional)- float
  • LengthWidthHeightCmMax - DHL product list xml tag: laengeBreiteHoeheCmMax (optional)- float
  • URL - DHL product list xml tag: url (optional)- varchar(255)
  • TOS - DHL product list xml tag: agb (optional)- varchar(255)
  • PrintAdvice - DHL product list xml tag: druckhinweis (optional)- varchar(255)

GetInfoDHLProductListsByLengthWidthHeightCmMin

Returns objects of DHLProductList by alternate key LengthWidthHeightCmMin.

Syntax
$ahDHLProductLists = GetInfoDHLProductListsByLengthWidthHeightCmMin($LengthWidthHeightCmMin);
Input
$LengthWidthHeightCmMin (float)
DHL product list xml tag: laengeBreiteHoeheCmMin
Return
$ahDHLProductLists (reference to array of hashes)
with following keys:
  • DHLProductListID - Internal ID of the DHL Product (primary key)- int
  • ProductID - DHL product list xml tag: id - varchar(255)
  • Supplier - DHL product list xml tag: anbieter (optional)- varchar(255)
  • DisplayName - DHL product list xml tag: anzeigename (optional)- varchar(255)
  • DisplayText - DHL product list xml tag: anzeigetext (optional)- varchar(255)
  • PictureURL - DHL product list xml tag: bildUrl (optional)- varchar(255)
  • ValidFrom - DHL product list xml tag: gueltigvon (optional)- datetime
  • ValidTo - DHL product list xml tag: gueltigbis (optional)- datetime
  • WeightKgMin - DHL product list xml tag: gewichtKgMin (optional)- float
  • WeightKgMax - DHL product list xml tag: gewichtKgMax (optional)- float
  • LengthCmMin - DHL product list xml tag: laengeCmMin (optional)- float
  • LengthCmMax - DHL product list xml tag: laengeCmMax (optional)- float
  • WidthCmMin - DHL product list xml tag: breiteCmMin (optional)- float
  • WidthCmMax - DHL product list xml tag: breiteCmMax (optional)- float
  • HeightCmMin - DHL product list xml tag: hoeheCmMin (optional)- float
  • HeightCmMax - DHL product list xml tag: hoeheCmMax (optional)- float
  • LengthWidthHeightCmMin - DHL product list xml tag: laengeBreiteHoeheCmMin (optional)- float
  • LengthWidthHeightCmMax - DHL product list xml tag: laengeBreiteHoeheCmMax (optional)- float
  • URL - DHL product list xml tag: url (optional)- varchar(255)
  • TOS - DHL product list xml tag: agb (optional)- varchar(255)
  • PrintAdvice - DHL product list xml tag: druckhinweis (optional)- varchar(255)

GetInfoDHLProductListsByProductID

Returns objects of DHLProductList by alternate key ProductID.

Syntax
$ahDHLProductLists = GetInfoDHLProductListsByProductID($ProductID);
Input
$ProductID (varchar(255))
DHL product list xml tag: id
Return
$ahDHLProductLists (reference to array of hashes)
with following keys:
  • DHLProductListID - Internal ID of the DHL Product (primary key)- int
  • ProductID - DHL product list xml tag: id - varchar(255)
  • Supplier - DHL product list xml tag: anbieter (optional)- varchar(255)
  • DisplayName - DHL product list xml tag: anzeigename (optional)- varchar(255)
  • DisplayText - DHL product list xml tag: anzeigetext (optional)- varchar(255)
  • PictureURL - DHL product list xml tag: bildUrl (optional)- varchar(255)
  • ValidFrom - DHL product list xml tag: gueltigvon (optional)- datetime
  • ValidTo - DHL product list xml tag: gueltigbis (optional)- datetime
  • WeightKgMin - DHL product list xml tag: gewichtKgMin (optional)- float
  • WeightKgMax - DHL product list xml tag: gewichtKgMax (optional)- float
  • LengthCmMin - DHL product list xml tag: laengeCmMin (optional)- float
  • LengthCmMax - DHL product list xml tag: laengeCmMax (optional)- float
  • WidthCmMin - DHL product list xml tag: breiteCmMin (optional)- float
  • WidthCmMax - DHL product list xml tag: breiteCmMax (optional)- float
  • HeightCmMin - DHL product list xml tag: hoeheCmMin (optional)- float
  • HeightCmMax - DHL product list xml tag: hoeheCmMax (optional)- float
  • LengthWidthHeightCmMin - DHL product list xml tag: laengeBreiteHoeheCmMin (optional)- float
  • LengthWidthHeightCmMax - DHL product list xml tag: laengeBreiteHoeheCmMax (optional)- float
  • URL - DHL product list xml tag: url (optional)- varchar(255)
  • TOS - DHL product list xml tag: agb (optional)- varchar(255)
  • PrintAdvice - DHL product list xml tag: druckhinweis (optional)- varchar(255)

GetInfoDHLProductListsByValidFrom

Returns objects of DHLProductList by alternate key ValidFrom.

Syntax
$ahDHLProductLists = GetInfoDHLProductListsByValidFrom($ValidFrom);
Input
$ValidFrom (datetime)
DHL product list xml tag: gueltigvon
Return
$ahDHLProductLists (reference to array of hashes)
with following keys:
  • DHLProductListID - Internal ID of the DHL Product (primary key)- int
  • ProductID - DHL product list xml tag: id - varchar(255)
  • Supplier - DHL product list xml tag: anbieter (optional)- varchar(255)
  • DisplayName - DHL product list xml tag: anzeigename (optional)- varchar(255)
  • DisplayText - DHL product list xml tag: anzeigetext (optional)- varchar(255)
  • PictureURL - DHL product list xml tag: bildUrl (optional)- varchar(255)
  • ValidFrom - DHL product list xml tag: gueltigvon (optional)- datetime
  • ValidTo - DHL product list xml tag: gueltigbis (optional)- datetime
  • WeightKgMin - DHL product list xml tag: gewichtKgMin (optional)- float
  • WeightKgMax - DHL product list xml tag: gewichtKgMax (optional)- float
  • LengthCmMin - DHL product list xml tag: laengeCmMin (optional)- float
  • LengthCmMax - DHL product list xml tag: laengeCmMax (optional)- float
  • WidthCmMin - DHL product list xml tag: breiteCmMin (optional)- float
  • WidthCmMax - DHL product list xml tag: breiteCmMax (optional)- float
  • HeightCmMin - DHL product list xml tag: hoeheCmMin (optional)- float
  • HeightCmMax - DHL product list xml tag: hoeheCmMax (optional)- float
  • LengthWidthHeightCmMin - DHL product list xml tag: laengeBreiteHoeheCmMin (optional)- float
  • LengthWidthHeightCmMax - DHL product list xml tag: laengeBreiteHoeheCmMax (optional)- float
  • URL - DHL product list xml tag: url (optional)- varchar(255)
  • TOS - DHL product list xml tag: agb (optional)- varchar(255)
  • PrintAdvice - DHL product list xml tag: druckhinweis (optional)- varchar(255)

GetInfoDHLProductListsByValidTo

Returns objects of DHLProductList by alternate key ValidTo.

Syntax
$ahDHLProductLists = GetInfoDHLProductListsByValidTo($ValidTo);
Input
$ValidTo (datetime)
DHL product list xml tag: gueltigbis
Return
$ahDHLProductLists (reference to array of hashes)
with following keys:
  • DHLProductListID - Internal ID of the DHL Product (primary key)- int
  • ProductID - DHL product list xml tag: id - varchar(255)
  • Supplier - DHL product list xml tag: anbieter (optional)- varchar(255)
  • DisplayName - DHL product list xml tag: anzeigename (optional)- varchar(255)
  • DisplayText - DHL product list xml tag: anzeigetext (optional)- varchar(255)
  • PictureURL - DHL product list xml tag: bildUrl (optional)- varchar(255)
  • ValidFrom - DHL product list xml tag: gueltigvon (optional)- datetime
  • ValidTo - DHL product list xml tag: gueltigbis (optional)- datetime
  • WeightKgMin - DHL product list xml tag: gewichtKgMin (optional)- float
  • WeightKgMax - DHL product list xml tag: gewichtKgMax (optional)- float
  • LengthCmMin - DHL product list xml tag: laengeCmMin (optional)- float
  • LengthCmMax - DHL product list xml tag: laengeCmMax (optional)- float
  • WidthCmMin - DHL product list xml tag: breiteCmMin (optional)- float
  • WidthCmMax - DHL product list xml tag: breiteCmMax (optional)- float
  • HeightCmMin - DHL product list xml tag: hoeheCmMin (optional)- float
  • HeightCmMax - DHL product list xml tag: hoeheCmMax (optional)- float
  • LengthWidthHeightCmMin - DHL product list xml tag: laengeBreiteHoeheCmMin (optional)- float
  • LengthWidthHeightCmMax - DHL product list xml tag: laengeBreiteHoeheCmMax (optional)- float
  • URL - DHL product list xml tag: url (optional)- varchar(255)
  • TOS - DHL product list xml tag: agb (optional)- varchar(255)
  • PrintAdvice - DHL product list xml tag: druckhinweis (optional)- varchar(255)

GetInfoDHLProductListsByWeightKgMax

Returns objects of DHLProductList by alternate key WeightKgMax.

Syntax
$ahDHLProductLists = GetInfoDHLProductListsByWeightKgMax($WeightKgMax);
Input
$WeightKgMax (float)
DHL product list xml tag: gewichtKgMax
Return
$ahDHLProductLists (reference to array of hashes)
with following keys:
  • DHLProductListID - Internal ID of the DHL Product (primary key)- int
  • ProductID - DHL product list xml tag: id - varchar(255)
  • Supplier - DHL product list xml tag: anbieter (optional)- varchar(255)
  • DisplayName - DHL product list xml tag: anzeigename (optional)- varchar(255)
  • DisplayText - DHL product list xml tag: anzeigetext (optional)- varchar(255)
  • PictureURL - DHL product list xml tag: bildUrl (optional)- varchar(255)
  • ValidFrom - DHL product list xml tag: gueltigvon (optional)- datetime
  • ValidTo - DHL product list xml tag: gueltigbis (optional)- datetime
  • WeightKgMin - DHL product list xml tag: gewichtKgMin (optional)- float
  • WeightKgMax - DHL product list xml tag: gewichtKgMax (optional)- float
  • LengthCmMin - DHL product list xml tag: laengeCmMin (optional)- float
  • LengthCmMax - DHL product list xml tag: laengeCmMax (optional)- float
  • WidthCmMin - DHL product list xml tag: breiteCmMin (optional)- float
  • WidthCmMax - DHL product list xml tag: breiteCmMax (optional)- float
  • HeightCmMin - DHL product list xml tag: hoeheCmMin (optional)- float
  • HeightCmMax - DHL product list xml tag: hoeheCmMax (optional)- float
  • LengthWidthHeightCmMin - DHL product list xml tag: laengeBreiteHoeheCmMin (optional)- float
  • LengthWidthHeightCmMax - DHL product list xml tag: laengeBreiteHoeheCmMax (optional)- float
  • URL - DHL product list xml tag: url (optional)- varchar(255)
  • TOS - DHL product list xml tag: agb (optional)- varchar(255)
  • PrintAdvice - DHL product list xml tag: druckhinweis (optional)- varchar(255)

GetInfoDHLProductListsByWeightKgMin

Returns objects of DHLProductList by alternate key WeightKgMin.

Syntax
$ahDHLProductLists = GetInfoDHLProductListsByWeightKgMin($WeightKgMin);
Input
$WeightKgMin (float)
DHL product list xml tag: gewichtKgMin
Return
$ahDHLProductLists (reference to array of hashes)
with following keys:
  • DHLProductListID - Internal ID of the DHL Product (primary key)- int
  • ProductID - DHL product list xml tag: id - varchar(255)
  • Supplier - DHL product list xml tag: anbieter (optional)- varchar(255)
  • DisplayName - DHL product list xml tag: anzeigename (optional)- varchar(255)
  • DisplayText - DHL product list xml tag: anzeigetext (optional)- varchar(255)
  • PictureURL - DHL product list xml tag: bildUrl (optional)- varchar(255)
  • ValidFrom - DHL product list xml tag: gueltigvon (optional)- datetime
  • ValidTo - DHL product list xml tag: gueltigbis (optional)- datetime
  • WeightKgMin - DHL product list xml tag: gewichtKgMin (optional)- float
  • WeightKgMax - DHL product list xml tag: gewichtKgMax (optional)- float
  • LengthCmMin - DHL product list xml tag: laengeCmMin (optional)- float
  • LengthCmMax - DHL product list xml tag: laengeCmMax (optional)- float
  • WidthCmMin - DHL product list xml tag: breiteCmMin (optional)- float
  • WidthCmMax - DHL product list xml tag: breiteCmMax (optional)- float
  • HeightCmMin - DHL product list xml tag: hoeheCmMin (optional)- float
  • HeightCmMax - DHL product list xml tag: hoeheCmMax (optional)- float
  • LengthWidthHeightCmMin - DHL product list xml tag: laengeBreiteHoeheCmMin (optional)- float
  • LengthWidthHeightCmMax - DHL product list xml tag: laengeBreiteHoeheCmMax (optional)- float
  • URL - DHL product list xml tag: url (optional)- varchar(255)
  • TOS - DHL product list xml tag: agb (optional)- varchar(255)
  • PrintAdvice - DHL product list xml tag: druckhinweis (optional)- varchar(255)

GetInfoDHLProductListsByWidthCmMax

Returns objects of DHLProductList by alternate key WidthCmMax.

Syntax
$ahDHLProductLists = GetInfoDHLProductListsByWidthCmMax($WidthCmMax);
Input
$WidthCmMax (float)
DHL product list xml tag: breiteCmMax
Return
$ahDHLProductLists (reference to array of hashes)
with following keys:
  • DHLProductListID - Internal ID of the DHL Product (primary key)- int
  • ProductID - DHL product list xml tag: id - varchar(255)
  • Supplier - DHL product list xml tag: anbieter (optional)- varchar(255)
  • DisplayName - DHL product list xml tag: anzeigename (optional)- varchar(255)
  • DisplayText - DHL product list xml tag: anzeigetext (optional)- varchar(255)
  • PictureURL - DHL product list xml tag: bildUrl (optional)- varchar(255)
  • ValidFrom - DHL product list xml tag: gueltigvon (optional)- datetime
  • ValidTo - DHL product list xml tag: gueltigbis (optional)- datetime
  • WeightKgMin - DHL product list xml tag: gewichtKgMin (optional)- float
  • WeightKgMax - DHL product list xml tag: gewichtKgMax (optional)- float
  • LengthCmMin - DHL product list xml tag: laengeCmMin (optional)- float
  • LengthCmMax - DHL product list xml tag: laengeCmMax (optional)- float
  • WidthCmMin - DHL product list xml tag: breiteCmMin (optional)- float
  • WidthCmMax - DHL product list xml tag: breiteCmMax (optional)- float
  • HeightCmMin - DHL product list xml tag: hoeheCmMin (optional)- float
  • HeightCmMax - DHL product list xml tag: hoeheCmMax (optional)- float
  • LengthWidthHeightCmMin - DHL product list xml tag: laengeBreiteHoeheCmMin (optional)- float
  • LengthWidthHeightCmMax - DHL product list xml tag: laengeBreiteHoeheCmMax (optional)- float
  • URL - DHL product list xml tag: url (optional)- varchar(255)
  • TOS - DHL product list xml tag: agb (optional)- varchar(255)
  • PrintAdvice - DHL product list xml tag: druckhinweis (optional)- varchar(255)

GetInfoDHLProductListsByWidthCmMin

Returns objects of DHLProductList by alternate key WidthCmMin.

Syntax
$ahDHLProductLists = GetInfoDHLProductListsByWidthCmMin($WidthCmMin);
Input
$WidthCmMin (float)
DHL product list xml tag: breiteCmMin
Return
$ahDHLProductLists (reference to array of hashes)
with following keys:
  • DHLProductListID - Internal ID of the DHL Product (primary key)- int
  • ProductID - DHL product list xml tag: id - varchar(255)
  • Supplier - DHL product list xml tag: anbieter (optional)- varchar(255)
  • DisplayName - DHL product list xml tag: anzeigename (optional)- varchar(255)
  • DisplayText - DHL product list xml tag: anzeigetext (optional)- varchar(255)
  • PictureURL - DHL product list xml tag: bildUrl (optional)- varchar(255)
  • ValidFrom - DHL product list xml tag: gueltigvon (optional)- datetime
  • ValidTo - DHL product list xml tag: gueltigbis (optional)- datetime
  • WeightKgMin - DHL product list xml tag: gewichtKgMin (optional)- float
  • WeightKgMax - DHL product list xml tag: gewichtKgMax (optional)- float
  • LengthCmMin - DHL product list xml tag: laengeCmMin (optional)- float
  • LengthCmMax - DHL product list xml tag: laengeCmMax (optional)- float
  • WidthCmMin - DHL product list xml tag: breiteCmMin (optional)- float
  • WidthCmMax - DHL product list xml tag: breiteCmMax (optional)- float
  • HeightCmMin - DHL product list xml tag: hoeheCmMin (optional)- float
  • HeightCmMax - DHL product list xml tag: hoeheCmMax (optional)- float
  • LengthWidthHeightCmMin - DHL product list xml tag: laengeBreiteHoeheCmMin (optional)- float
  • LengthWidthHeightCmMax - DHL product list xml tag: laengeBreiteHoeheCmMax (optional)- float
  • URL - DHL product list xml tag: url (optional)- varchar(255)
  • TOS - DHL product list xml tag: agb (optional)- varchar(255)
  • PrintAdvice - DHL product list xml tag: druckhinweis (optional)- varchar(255)

GetPKeyDHLProductListsByHeightCmMax

Returns primary keys of DHLProductList by alternate key HeightCmMax.

Syntax
$aKeys = GetPKeyDHLProductListsByHeightCmMax($HeightCmMax);
Input
$HeightCmMax (float)
DHL product list xml tag: hoeheCmMax
Return
$aKeys (reference to array of int)
Internal ID of the DHL Product (primary key)

GetPKeyDHLProductListsByHeightCmMin

Returns primary keys of DHLProductList by alternate key HeightCmMin.

Syntax
$aKeys = GetPKeyDHLProductListsByHeightCmMin($HeightCmMin);
Input
$HeightCmMin (float)
DHL product list xml tag: hoeheCmMin
Return
$aKeys (reference to array of int)
Internal ID of the DHL Product (primary key)

GetPKeyDHLProductListsByLengthCmMax

Returns primary keys of DHLProductList by alternate key LengthCmMax.

Syntax
$aKeys = GetPKeyDHLProductListsByLengthCmMax($LengthCmMax);
Input
$LengthCmMax (float)
DHL product list xml tag: laengeCmMax
Return
$aKeys (reference to array of int)
Internal ID of the DHL Product (primary key)

GetPKeyDHLProductListsByLengthCmMin

Returns primary keys of DHLProductList by alternate key LengthCmMin.

Syntax
$aKeys = GetPKeyDHLProductListsByLengthCmMin($LengthCmMin);
Input
$LengthCmMin (float)
DHL product list xml tag: laengeCmMin
Return
$aKeys (reference to array of int)
Internal ID of the DHL Product (primary key)

GetPKeyDHLProductListsByLengthWidthHeightCmMax

Returns primary keys of DHLProductList by alternate key LengthWidthHeightCmMax.

Syntax
$aKeys = GetPKeyDHLProductListsByLengthWidthHeightCmMax($LengthWidthHeightCmMax);
Input
$LengthWidthHeightCmMax (float)
DHL product list xml tag: laengeBreiteHoeheCmMax
Return
$aKeys (reference to array of int)
Internal ID of the DHL Product (primary key)

GetPKeyDHLProductListsByLengthWidthHeightCmMin

Returns primary keys of DHLProductList by alternate key LengthWidthHeightCmMin.

Syntax
$aKeys = GetPKeyDHLProductListsByLengthWidthHeightCmMin($LengthWidthHeightCmMin);
Input
$LengthWidthHeightCmMin (float)
DHL product list xml tag: laengeBreiteHoeheCmMin
Return
$aKeys (reference to array of int)
Internal ID of the DHL Product (primary key)

GetPKeyDHLProductListsByProductID

Returns primary keys of DHLProductList by alternate key ProductID.

Syntax
$aKeys = GetPKeyDHLProductListsByProductID($ProductID);
Input
$ProductID (varchar(255))
DHL product list xml tag: id
Return
$aKeys (reference to array of int)
Internal ID of the DHL Product (primary key)

GetPKeyDHLProductListsByValidFrom

Returns primary keys of DHLProductList by alternate key ValidFrom.

Syntax
$aKeys = GetPKeyDHLProductListsByValidFrom($ValidFrom);
Input
$ValidFrom (datetime)
DHL product list xml tag: gueltigvon
Return
$aKeys (reference to array of int)
Internal ID of the DHL Product (primary key)

GetPKeyDHLProductListsByValidTo

Returns primary keys of DHLProductList by alternate key ValidTo.

Syntax
$aKeys = GetPKeyDHLProductListsByValidTo($ValidTo);
Input
$ValidTo (datetime)
DHL product list xml tag: gueltigbis
Return
$aKeys (reference to array of int)
Internal ID of the DHL Product (primary key)

GetPKeyDHLProductListsByWeightKgMax

Returns primary keys of DHLProductList by alternate key WeightKgMax.

Syntax
$aKeys = GetPKeyDHLProductListsByWeightKgMax($WeightKgMax);
Input
$WeightKgMax (float)
DHL product list xml tag: gewichtKgMax
Return
$aKeys (reference to array of int)
Internal ID of the DHL Product (primary key)

GetPKeyDHLProductListsByWeightKgMin

Returns primary keys of DHLProductList by alternate key WeightKgMin.

Syntax
$aKeys = GetPKeyDHLProductListsByWeightKgMin($WeightKgMin);
Input
$WeightKgMin (float)
DHL product list xml tag: gewichtKgMin
Return
$aKeys (reference to array of int)
Internal ID of the DHL Product (primary key)

GetPKeyDHLProductListsByWidthCmMax

Returns primary keys of DHLProductList by alternate key WidthCmMax.

Syntax
$aKeys = GetPKeyDHLProductListsByWidthCmMax($WidthCmMax);
Input
$WidthCmMax (float)
DHL product list xml tag: breiteCmMax
Return
$aKeys (reference to array of int)
Internal ID of the DHL Product (primary key)

GetPKeyDHLProductListsByWidthCmMin

Returns primary keys of DHLProductList by alternate key WidthCmMin.

Syntax
$aKeys = GetPKeyDHLProductListsByWidthCmMin($WidthCmMin);
Input
$WidthCmMin (float)
DHL product list xml tag: breiteCmMin
Return
$aKeys (reference to array of int)
Internal ID of the DHL Product (primary key)

InsertDHLProductList

Creates an entry of DHLProductList.

Syntax
$DHLProductListID = InsertDHLProductList($hDHLProductList);
Input
$hDHLProductList (reference to hash)
with following keys:
  • DHLProductListID - Internal ID of the DHL Product (primary key)(optional)- int
  • ProductID - DHL product list xml tag: id - varchar(255)
  • Supplier - DHL product list xml tag: anbieter (optional)- varchar(255)
  • DisplayName - DHL product list xml tag: anzeigename (optional)- varchar(255)
  • DisplayText - DHL product list xml tag: anzeigetext (optional)- varchar(255)
  • PictureURL - DHL product list xml tag: bildUrl (optional)- varchar(255)
  • ValidFrom - DHL product list xml tag: gueltigvon (optional)- datetime
  • ValidTo - DHL product list xml tag: gueltigbis (optional)- datetime
  • WeightKgMin - DHL product list xml tag: gewichtKgMin (optional)- float
  • WeightKgMax - DHL product list xml tag: gewichtKgMax (optional)- float
  • LengthCmMin - DHL product list xml tag: laengeCmMin (optional)- float
  • LengthCmMax - DHL product list xml tag: laengeCmMax (optional)- float
  • WidthCmMin - DHL product list xml tag: breiteCmMin (optional)- float
  • WidthCmMax - DHL product list xml tag: breiteCmMax (optional)- float
  • HeightCmMin - DHL product list xml tag: hoeheCmMin (optional)- float
  • HeightCmMax - DHL product list xml tag: hoeheCmMax (optional)- float
  • LengthWidthHeightCmMin - DHL product list xml tag: laengeBreiteHoeheCmMin (optional)- float
  • LengthWidthHeightCmMax - DHL product list xml tag: laengeBreiteHoeheCmMax (optional)- float
  • URL - DHL product list xml tag: url (optional)- varchar(255)
  • TOS - DHL product list xml tag: agb (optional)- varchar(255)
  • PrintAdvice - DHL product list xml tag: druckhinweis (optional)- varchar(255)
Return
$DHLProductListID (int)
Internal ID of the DHL Product (primary key)

UpdateDHLProductList

Updates a(n) DHLProductList if any element was changed.

Syntax
UpdateDHLProductList($DHLProductListID, $hDHLProductList);
UpdateDHLProductList($hDHLProductList); # if $hDHLProductList includes DHLProductListID
Input
$DHLProductListID (int)
Internal ID of the DHL Product (primary key)
$hDHLProductList (reference to hash)
with following keys:
  • ProductID - DHL product list xml tag: id - varchar(255)
  • Supplier - DHL product list xml tag: anbieter (optional)- varchar(255)
  • DisplayName - DHL product list xml tag: anzeigename (optional)- varchar(255)
  • DisplayText - DHL product list xml tag: anzeigetext (optional)- varchar(255)
  • PictureURL - DHL product list xml tag: bildUrl (optional)- varchar(255)
  • ValidFrom - DHL product list xml tag: gueltigvon (optional)- datetime
  • ValidTo - DHL product list xml tag: gueltigbis (optional)- datetime
  • WeightKgMin - DHL product list xml tag: gewichtKgMin (optional)- float
  • WeightKgMax - DHL product list xml tag: gewichtKgMax (optional)- float
  • LengthCmMin - DHL product list xml tag: laengeCmMin (optional)- float
  • LengthCmMax - DHL product list xml tag: laengeCmMax (optional)- float
  • WidthCmMin - DHL product list xml tag: breiteCmMin (optional)- float
  • WidthCmMax - DHL product list xml tag: breiteCmMax (optional)- float
  • HeightCmMin - DHL product list xml tag: hoeheCmMin (optional)- float
  • HeightCmMax - DHL product list xml tag: hoeheCmMax (optional)- float
  • LengthWidthHeightCmMin - DHL product list xml tag: laengeBreiteHoeheCmMin (optional)- float
  • LengthWidthHeightCmMax - DHL product list xml tag: laengeBreiteHoeheCmMax (optional)- float
  • URL - DHL product list xml tag: url (optional)- varchar(255)
  • TOS - DHL product list xml tag: agb (optional)- varchar(255)
  • PrintAdvice - DHL product list xml tag: druckhinweis (optional)- varchar(255)