ePages 6.11.0 - DE_EPAGES/DHL/API/Table/DHLProdListDeliveryDest.pm

Package DE_EPAGES::DHL::API::Table::DHLProdListDeliveryDest

interface for table DHLProdListDeliveryDest

@EXPORT_OK
InsertDHLProdListDeliveryDest
UpdateDHLProdListDeliveryDest
DeleteDHLProdListDeliveryDest
GetAllPKeyDHLProdListDeliveryDests
GetAllInfoDHLProdListDeliveryDests
GetInfoDHLProdListDeliveryDest
ExistsDHLProdListDeliveryDest
GetPKeyDHLProdListDeliveryDestByDHLProductListID
GetInfoDHLProdListDeliveryDestByDHLProductListID
ExistsDHLProdListDeliveryDestByDHLProductListID
GetPKeyDHLProdListDeliveryDestsByDHLProductListID
GetInfoDHLProdListDeliveryDestsByDHLProductListID
GetPKeyDHLProdListDeliveryDestsByCountryCode
GetInfoDHLProdListDeliveryDestsByCountryCode
GetPKeyDHLProdListDeliveryDestsByCurrencyID
GetInfoDHLProdListDeliveryDestsByCurrencyID

Functions

DeleteDHLProdListDeliveryDest
ExistsDHLProdListDeliveryDest
ExistsDHLProdListDeliveryDestByDHLProductListID
GetAllInfoDHLProdListDeliveryDests
GetAllPKeyDHLProdListDeliveryDests
GetInfoDHLProdListDeliveryDest
GetInfoDHLProdListDeliveryDestByDHLProductListID
GetInfoDHLProdListDeliveryDestsByCountryCode
GetInfoDHLProdListDeliveryDestsByCurrencyID
GetInfoDHLProdListDeliveryDestsByDHLProductListID
GetPKeyDHLProdListDeliveryDestByDHLProductListID
GetPKeyDHLProdListDeliveryDestsByCountryCode
GetPKeyDHLProdListDeliveryDestsByCurrencyID
GetPKeyDHLProdListDeliveryDestsByDHLProductListID
InsertDHLProdListDeliveryDest
OnDeleteCurrency
UpdateDHLProdListDeliveryDest

DeleteDHLProdListDeliveryDest

Deletes a(n) DHLProdListDeliveryDest.

Syntax
DeleteDHLProdListDeliveryDest($DHLProdListDeliveryDestID);
DeleteDHLProdListDeliveryDest($hDHLProdListDeliveryDest); # if $hDHLProdListDeliveryDest includes DHLProdListDeliveryDestID
Input
$DHLProdListDeliveryDestID (int)
Internal ID (primary key)

ExistsDHLProdListDeliveryDest

Returns true if the DHLProdListDeliveryDest exists.

Syntax
$exists = ExistsDHLProdListDeliveryDest($DHLProdListDeliveryDestID);
Input
$DHLProdListDeliveryDestID (int)
Internal ID
Return
$exists (boolean)
1/0 the DHLProdListDeliveryDest exists (yes/no)

ExistsDHLProdListDeliveryDestByDHLProductListID

Returns true if a DHLProdListDeliveryDest by alternate keys DHLProductListID and CountryCode exists.

Syntax
$DHLProdListDeliveryDestID = ExistsDHLProdListDeliveryDestByDHLProductListID($DHLProductListID, $CountryCode);
Input
$DHLProductListID (int)
Internal ID of the DHL Product
$CountryCode (varchar(3))
DHL product list xml tag: laendercode
Return
$exists (boolean)
1/0 the u_dhlproductlistd_countrycode exists (yes/no)

GetAllInfoDHLProdListDeliveryDests

Returns all objects of DHLProdListDeliveryDest.

Syntax
$ahDHLProdListDeliveryDests = GetAllInfoDHLProdListDeliveryDests();
Return
$ahDHLProdListDeliveryDests (reference to array of hashes)
with following keys:
  • DHLProdListDeliveryDestID - Internal ID (primary key)- int
  • CountryCode - DHL product list xml tag: laendercode - varchar(3)
  • CurrencyID - Internal Currency ID (optional)- varchar(3)
  • DHLProductListID - Internal ID of the DHL Product (optional)- int
  • Exceptions - DHL product list xml tag: ausnahmen (optional)- varchar(255)
  • OverallPriceAmountEur - DHL product list xml tag: gesamtpreisBetragEur (optional)- money
  • OverallPriceDisplayName - DHL product list xml tag: gesamtpreisAnzeigename (optional)- varchar(255)
  • Declaration - DHL product list xml tag: zollerklaerung (optional)- varchar(255)
  • CN22Limit - DHL product list xml tag: CN22Limit (optional)- float
  • Endorsement - DHL product list xml tag: vorausverfuegung - bit

GetAllPKeyDHLProdListDeliveryDests

Returns all DHLProdListDeliveryDest identifiers.

Syntax
$aDHLProdListDeliveryDestIDs = GetAllPKeyDHLProdListDeliveryDests();
Return
$aDHLProdListDeliveryDestIDs (reference to array of int)
Internal ID

GetInfoDHLProdListDeliveryDest

Returns the DHLProdListDeliveryDest by identifier.

Syntax
$hDHLProdListDeliveryDest = GetInfoDHLProdListDeliveryDest($DHLProdListDeliveryDestID);
Input
$DHLProdListDeliveryDestID (int)
Internal ID (primary key)
Return
$hDHLProdListDeliveryDest (reference to hash)
with following keys:
  • DHLProdListDeliveryDestID - Internal ID (primary key)- int
  • CountryCode - DHL product list xml tag: laendercode - varchar(3)
  • CurrencyID - Internal Currency ID (optional)- varchar(3)
  • DHLProductListID - Internal ID of the DHL Product (optional)- int
  • Exceptions - DHL product list xml tag: ausnahmen (optional)- varchar(255)
  • OverallPriceAmountEur - DHL product list xml tag: gesamtpreisBetragEur (optional)- money
  • OverallPriceDisplayName - DHL product list xml tag: gesamtpreisAnzeigename (optional)- varchar(255)
  • Declaration - DHL product list xml tag: zollerklaerung (optional)- varchar(255)
  • CN22Limit - DHL product list xml tag: CN22Limit (optional)- float
  • Endorsement - DHL product list xml tag: vorausverfuegung - bit

GetInfoDHLProdListDeliveryDestByDHLProductListID

Returns the object of DHLProdListDeliveryDest by alternate keys DHLProductListID and CountryCode.

Syntax
$hDHLProdListDeliveryDest = GetInfoDHLProdListDeliveryDestByDHLProductListID($DHLProductListID, $CountryCode);
Input
$DHLProductListID (int)
Internal ID of the DHL Product (optional)
$CountryCode (varchar(3))
DHL product list xml tag: laendercode
Return
$hDHLProdListDeliveryDest (reference to hash)
with following keys:
  • DHLProdListDeliveryDestID - Internal ID (primary key)- int
  • CountryCode - DHL product list xml tag: laendercode - varchar(3)
  • CurrencyID - Internal Currency ID (optional)- varchar(3)
  • DHLProductListID - Internal ID of the DHL Product (optional)- int
  • Exceptions - DHL product list xml tag: ausnahmen (optional)- varchar(255)
  • OverallPriceAmountEur - DHL product list xml tag: gesamtpreisBetragEur (optional)- money
  • OverallPriceDisplayName - DHL product list xml tag: gesamtpreisAnzeigename (optional)- varchar(255)
  • Declaration - DHL product list xml tag: zollerklaerung (optional)- varchar(255)
  • CN22Limit - DHL product list xml tag: CN22Limit (optional)- float
  • Endorsement - DHL product list xml tag: vorausverfuegung - bit

GetInfoDHLProdListDeliveryDestsByCountryCode

Returns objects of DHLProdListDeliveryDest by alternate key CountryCode.

Syntax
$ahDHLProdListDeliveryDests = GetInfoDHLProdListDeliveryDestsByCountryCode($CountryCode);
Input
$CountryCode (varchar(3))
DHL product list xml tag: laendercode
Return
$ahDHLProdListDeliveryDests (reference to array of hashes)
with following keys:
  • DHLProdListDeliveryDestID - Internal ID (primary key)- int
  • CountryCode - DHL product list xml tag: laendercode - varchar(3)
  • CurrencyID - Internal Currency ID (optional)- varchar(3)
  • DHLProductListID - Internal ID of the DHL Product (optional)- int
  • Exceptions - DHL product list xml tag: ausnahmen (optional)- varchar(255)
  • OverallPriceAmountEur - DHL product list xml tag: gesamtpreisBetragEur (optional)- money
  • OverallPriceDisplayName - DHL product list xml tag: gesamtpreisAnzeigename (optional)- varchar(255)
  • Declaration - DHL product list xml tag: zollerklaerung (optional)- varchar(255)
  • CN22Limit - DHL product list xml tag: CN22Limit (optional)- float
  • Endorsement - DHL product list xml tag: vorausverfuegung - bit

GetInfoDHLProdListDeliveryDestsByCurrencyID

Returns objects of DHLProdListDeliveryDest by alternate key CurrencyID.

Syntax
$ahDHLProdListDeliveryDests = GetInfoDHLProdListDeliveryDestsByCurrencyID($CurrencyID);
Input
$CurrencyID (varchar(3))
Internal Currency ID
Return
$ahDHLProdListDeliveryDests (reference to array of hashes)
with following keys:
  • DHLProdListDeliveryDestID - Internal ID (primary key)- int
  • CountryCode - DHL product list xml tag: laendercode - varchar(3)
  • CurrencyID - Internal Currency ID (optional)- varchar(3)
  • DHLProductListID - Internal ID of the DHL Product (optional)- int
  • Exceptions - DHL product list xml tag: ausnahmen (optional)- varchar(255)
  • OverallPriceAmountEur - DHL product list xml tag: gesamtpreisBetragEur (optional)- money
  • OverallPriceDisplayName - DHL product list xml tag: gesamtpreisAnzeigename (optional)- varchar(255)
  • Declaration - DHL product list xml tag: zollerklaerung (optional)- varchar(255)
  • CN22Limit - DHL product list xml tag: CN22Limit (optional)- float
  • Endorsement - DHL product list xml tag: vorausverfuegung - bit

GetInfoDHLProdListDeliveryDestsByDHLProductListID

Returns objects of DHLProdListDeliveryDest by alternate keys DHLProductListID and CountryCode.

Syntax
$ahDHLProdListDeliveryDests = GetInfoDHLProdListDeliveryDestsByDHLProductListID($DHLProductListID, $CountryCode);
Input
$DHLProductListID (int)
Internal ID of the DHL Product
$CountryCode (varchar(3))
DHL product list xml tag: laendercode (optional)
Return
$ahDHLProdListDeliveryDests (reference to array of hashes)
with following keys:
  • DHLProdListDeliveryDestID - Internal ID (primary key)- int
  • CountryCode - DHL product list xml tag: laendercode - varchar(3)
  • CurrencyID - Internal Currency ID (optional)- varchar(3)
  • DHLProductListID - Internal ID of the DHL Product (optional)- int
  • Exceptions - DHL product list xml tag: ausnahmen (optional)- varchar(255)
  • OverallPriceAmountEur - DHL product list xml tag: gesamtpreisBetragEur (optional)- money
  • OverallPriceDisplayName - DHL product list xml tag: gesamtpreisAnzeigename (optional)- varchar(255)
  • Declaration - DHL product list xml tag: zollerklaerung (optional)- varchar(255)
  • CN22Limit - DHL product list xml tag: CN22Limit (optional)- float
  • Endorsement - DHL product list xml tag: vorausverfuegung - bit

GetPKeyDHLProdListDeliveryDestByDHLProductListID

Returns primary key of DHLProdListDeliveryDest by alternate keys DHLProductListID and CountryCode.

Syntax
$DHLProdListDeliveryDestID = GetPKeyDHLProdListDeliveryDestByDHLProductListID($DHLProductListID, $CountryCode);
Input
$DHLProductListID (int)
Internal ID of the DHL Product
$CountryCode (varchar(3))
DHL product list xml tag: laendercode
Return
$DHLProdListDeliveryDestID (int)
Internal ID (primary key)

GetPKeyDHLProdListDeliveryDestsByCountryCode

Returns primary keys of DHLProdListDeliveryDest by alternate key CountryCode.

Syntax
$aKeys = GetPKeyDHLProdListDeliveryDestsByCountryCode($CountryCode);
Input
$CountryCode (varchar(3))
DHL product list xml tag: laendercode
Return
$aKeys (reference to array of int)
Internal ID (primary key)

GetPKeyDHLProdListDeliveryDestsByCurrencyID

Returns primary keys of DHLProdListDeliveryDest by alternate key CurrencyID.

Syntax
$aKeys = GetPKeyDHLProdListDeliveryDestsByCurrencyID($CurrencyID);
Input
$CurrencyID (varchar(3))
Internal Currency ID
Return
$aKeys (reference to array of int)
Internal ID (primary key)

GetPKeyDHLProdListDeliveryDestsByDHLProductListID

Returns primary keys of DHLProdListDeliveryDest by alternate keys DHLProductListID and CountryCode.

Syntax
$aKeys = GetPKeyDHLProdListDeliveryDestsByDHLProductListID($DHLProductListID, $CountryCode);
Input
$DHLProductListID (int)
Internal ID of the DHL Product
$CountryCode (varchar(3))
DHL product list xml tag: laendercode (optional)
Return
$aKeys (reference to array of int)
Internal ID (primary key)

InsertDHLProdListDeliveryDest

Creates an entry of DHLProdListDeliveryDest.

Syntax
$DHLProdListDeliveryDestID = InsertDHLProdListDeliveryDest($hDHLProdListDeliveryDest);
Input
$hDHLProdListDeliveryDest (reference to hash)
with following keys:
  • DHLProdListDeliveryDestID - Internal ID (primary key)(optional)- int
  • CountryCode - DHL product list xml tag: laendercode - varchar(3)
  • CurrencyID - Internal Currency ID (optional)- varchar(3)
  • DHLProductListID - Internal ID of the DHL Product (optional)- int
  • Exceptions - DHL product list xml tag: ausnahmen (optional)- varchar(255)
  • OverallPriceAmountEur - DHL product list xml tag: gesamtpreisBetragEur (optional)- money
  • OverallPriceDisplayName - DHL product list xml tag: gesamtpreisAnzeigename (optional)- varchar(255)
  • Declaration - DHL product list xml tag: zollerklaerung (optional)- varchar(255)
  • CN22Limit - DHL product list xml tag: CN22Limit (optional)- float
  • Endorsement - DHL product list xml tag: vorausverfuegung - bit
Return
$DHLProdListDeliveryDestID (int)
Internal ID (primary key)

OnDeleteCurrency

Deletes DHLProdListDeliveryDest of this model when a(n) Currency is deleted.

Syntax
OnDeleteCurrency($hParams);
Input
$hParams (ref.hash.*)
primary key of object Currency, key is
  • CurrencyID

UpdateDHLProdListDeliveryDest

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

Syntax
UpdateDHLProdListDeliveryDest($DHLProdListDeliveryDestID, $hDHLProdListDeliveryDest);
UpdateDHLProdListDeliveryDest($hDHLProdListDeliveryDest); # if $hDHLProdListDeliveryDest includes DHLProdListDeliveryDestID
Input
$DHLProdListDeliveryDestID (int)
Internal ID (primary key)
$hDHLProdListDeliveryDest (reference to hash)
with following keys:
  • CountryCode - DHL product list xml tag: laendercode - varchar(3)
  • CurrencyID - Internal Currency ID (optional)- varchar(3)
  • DHLProductListID - Internal ID of the DHL Product (optional)- int
  • Exceptions - DHL product list xml tag: ausnahmen (optional)- varchar(255)
  • OverallPriceAmountEur - DHL product list xml tag: gesamtpreisBetragEur (optional)- money
  • OverallPriceDisplayName - DHL product list xml tag: gesamtpreisAnzeigename (optional)- varchar(255)
  • Declaration - DHL product list xml tag: zollerklaerung (optional)- varchar(255)
  • CN22Limit - DHL product list xml tag: CN22Limit (optional)- float
  • Endorsement - DHL product list xml tag: vorausverfuegung - bit