OpenPetra
Free Administration Software for Non-Profits
Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess Class Reference

the invoice (which is also an offer at a certain stage) More...

Inheritance diagram for Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess:
Ict.Common.Data.TTypedDataAccess

Public Types

enum  eSubmitChangesOperations { eUpdate = 1 , eDelete = 2 , eInsert = 4 , eAll = 7 }
 enumeration of operations that can be selected for SubmitChanges More...
 

Static Public Member Functions

static void LoadAll (DataSet ADataSet, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 this method is called by all overloads More...
 
static void LoadAll (DataSet AData, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadAll (DataSet AData, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadAll (StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static AArInvoiceTable LoadAll (TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadAll (StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceRow LoadByPrimaryKey (DataSet ADataSet, Int32 ALedgerNumber, Int32 AKey, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 this method is called by all overloads More...
 
static AArInvoiceRow LoadByPrimaryKey (DataSet AData, Int32 ALedgerNumber, Int32 AKey, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceRow LoadByPrimaryKey (DataSet AData, Int32 ALedgerNumber, Int32 AKey, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadByPrimaryKey (Int32 ALedgerNumber, Int32 AKey, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static AArInvoiceTable LoadByPrimaryKey (Int32 ALedgerNumber, Int32 AKey, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadByPrimaryKey (Int32 ALedgerNumber, Int32 AKey, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadUsingTemplate (DataSet ADataSet, AArInvoiceRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 this method is called by all overloads More...
 
static void LoadUsingTemplate (DataSet AData, AArInvoiceRow ATemplateRow, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadUsingTemplate (DataSet AData, AArInvoiceRow ATemplateRow, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadUsingTemplate (AArInvoiceRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static AArInvoiceTable LoadUsingTemplate (AArInvoiceRow ATemplateRow, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadUsingTemplate (AArInvoiceRow ATemplateRow, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadUsingTemplate (AArInvoiceRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadUsingTemplate (DataSet ADataSet, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 this method is called by all overloads More...
 
static void LoadUsingTemplate (DataSet AData, TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadUsingTemplate (DataSet AData, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadUsingTemplate (TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static AArInvoiceTable LoadUsingTemplate (TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadUsingTemplate (TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static int CountAll (TDBTransaction ATransaction)
 this method is called by all overloads More...
 
static bool Exists (Int32 ALedgerNumber, Int32 AKey, TDBTransaction ATransaction)
 check if a row exists by using the primary key More...
 
static int CountUsingTemplate (AArInvoiceRow ATemplateRow, StringCollection ATemplateOperators, TDBTransaction ATransaction)
 this method is called by all overloads More...
 
static int CountUsingTemplate (TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 this method is called by all overloads More...
 
static void LoadViaPPartner (DataSet ADataSet, Int64 APartnerKey, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static void LoadViaPPartner (DataSet AData, Int64 APartnerKey, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaPPartner (DataSet AData, Int64 APartnerKey, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaPPartner (Int64 APartnerKey, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static AArInvoiceTable LoadViaPPartner (Int64 APartnerKey, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaPPartner (Int64 APartnerKey, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaPPartnerTemplate (DataSet ADataSet, PPartnerRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static void LoadViaPPartnerTemplate (DataSet AData, PPartnerRow ATemplateRow, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaPPartnerTemplate (DataSet AData, PPartnerRow ATemplateRow, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaPPartnerTemplate (PPartnerRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static AArInvoiceTable LoadViaPPartnerTemplate (PPartnerRow ATemplateRow, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaPPartnerTemplate (PPartnerRow ATemplateRow, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaPPartnerTemplate (PPartnerRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaPPartnerTemplate (DataSet ADataSet, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static void LoadViaPPartnerTemplate (DataSet AData, TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaPPartnerTemplate (DataSet AData, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaPPartnerTemplate (TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static AArInvoiceTable LoadViaPPartnerTemplate (TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaPPartnerTemplate (TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static int CountViaPPartner (Int64 APartnerKey, TDBTransaction ATransaction)
 auto generated More...
 
static int CountViaPPartnerTemplate (PPartnerRow ATemplateRow, StringCollection ATemplateOperators, TDBTransaction ATransaction)
 auto generated More...
 
static int CountViaPPartnerTemplate (TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaATaxTable (DataSet ADataSet, Int32 ALedgerNumber, String ATaxTypeCode, String ATaxRateCode, System.DateTime ATaxValidFrom, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static void LoadViaATaxTable (DataSet AData, Int32 ALedgerNumber, String ATaxTypeCode, String ATaxRateCode, System.DateTime ATaxValidFrom, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaATaxTable (DataSet AData, Int32 ALedgerNumber, String ATaxTypeCode, String ATaxRateCode, System.DateTime ATaxValidFrom, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaATaxTable (Int32 ALedgerNumber, String ATaxTypeCode, String ATaxRateCode, System.DateTime ATaxValidFrom, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static AArInvoiceTable LoadViaATaxTable (Int32 ALedgerNumber, String ATaxTypeCode, String ATaxRateCode, System.DateTime ATaxValidFrom, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaATaxTable (Int32 ALedgerNumber, String ATaxTypeCode, String ATaxRateCode, System.DateTime ATaxValidFrom, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaATaxTableTemplate (DataSet ADataSet, ATaxTableRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static void LoadViaATaxTableTemplate (DataSet AData, ATaxTableRow ATemplateRow, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaATaxTableTemplate (DataSet AData, ATaxTableRow ATemplateRow, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaATaxTableTemplate (ATaxTableRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static AArInvoiceTable LoadViaATaxTableTemplate (ATaxTableRow ATemplateRow, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaATaxTableTemplate (ATaxTableRow ATemplateRow, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaATaxTableTemplate (ATaxTableRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaATaxTableTemplate (DataSet ADataSet, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static void LoadViaATaxTableTemplate (DataSet AData, TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaATaxTableTemplate (DataSet AData, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaATaxTableTemplate (TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static AArInvoiceTable LoadViaATaxTableTemplate (TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaATaxTableTemplate (TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static int CountViaATaxTable (Int32 ALedgerNumber, String ATaxTypeCode, String ATaxRateCode, System.DateTime ATaxValidFrom, TDBTransaction ATransaction)
 auto generated More...
 
static int CountViaATaxTableTemplate (ATaxTableRow ATemplateRow, StringCollection ATemplateOperators, TDBTransaction ATransaction)
 auto generated More...
 
static int CountViaATaxTableTemplate (TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaALedger (DataSet ADataSet, Int32 ALedgerNumber, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static void LoadViaALedger (DataSet AData, Int32 ALedgerNumber, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaALedger (DataSet AData, Int32 ALedgerNumber, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaALedger (Int32 ALedgerNumber, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static AArInvoiceTable LoadViaALedger (Int32 ALedgerNumber, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaALedger (Int32 ALedgerNumber, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaALedgerTemplate (DataSet ADataSet, ALedgerRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static void LoadViaALedgerTemplate (DataSet AData, ALedgerRow ATemplateRow, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaALedgerTemplate (DataSet AData, ALedgerRow ATemplateRow, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaALedgerTemplate (ALedgerRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static AArInvoiceTable LoadViaALedgerTemplate (ALedgerRow ATemplateRow, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaALedgerTemplate (ALedgerRow ATemplateRow, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaALedgerTemplate (ALedgerRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaALedgerTemplate (DataSet ADataSet, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static void LoadViaALedgerTemplate (DataSet AData, TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaALedgerTemplate (DataSet AData, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaALedgerTemplate (TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static AArInvoiceTable LoadViaALedgerTemplate (TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaALedgerTemplate (TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static int CountViaALedger (Int32 ALedgerNumber, TDBTransaction ATransaction)
 auto generated More...
 
static int CountViaALedgerTemplate (ALedgerRow ATemplateRow, StringCollection ATemplateOperators, TDBTransaction ATransaction)
 auto generated More...
 
static int CountViaALedgerTemplate (TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaATaxType (DataSet ADataSet, String ATaxTypeCode, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static void LoadViaATaxType (DataSet AData, String ATaxTypeCode, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaATaxType (DataSet AData, String ATaxTypeCode, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaATaxType (String ATaxTypeCode, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static AArInvoiceTable LoadViaATaxType (String ATaxTypeCode, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaATaxType (String ATaxTypeCode, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaATaxTypeTemplate (DataSet ADataSet, ATaxTypeRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static void LoadViaATaxTypeTemplate (DataSet AData, ATaxTypeRow ATemplateRow, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaATaxTypeTemplate (DataSet AData, ATaxTypeRow ATemplateRow, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaATaxTypeTemplate (ATaxTypeRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static AArInvoiceTable LoadViaATaxTypeTemplate (ATaxTypeRow ATemplateRow, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaATaxTypeTemplate (ATaxTypeRow ATemplateRow, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaATaxTypeTemplate (ATaxTypeRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaATaxTypeTemplate (DataSet ADataSet, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static void LoadViaATaxTypeTemplate (DataSet AData, TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaATaxTypeTemplate (DataSet AData, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaATaxTypeTemplate (TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static AArInvoiceTable LoadViaATaxTypeTemplate (TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaATaxTypeTemplate (TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static int CountViaATaxType (String ATaxTypeCode, TDBTransaction ATransaction)
 auto generated More...
 
static int CountViaATaxTypeTemplate (ATaxTypeRow ATemplateRow, StringCollection ATemplateOperators, TDBTransaction ATransaction)
 auto generated More...
 
static int CountViaATaxTypeTemplate (TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaACurrency (DataSet ADataSet, String ACurrencyCode, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static void LoadViaACurrency (DataSet AData, String ACurrencyCode, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaACurrency (DataSet AData, String ACurrencyCode, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaACurrency (String ACurrencyCode, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static AArInvoiceTable LoadViaACurrency (String ACurrencyCode, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaACurrency (String ACurrencyCode, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaACurrencyTemplate (DataSet ADataSet, ACurrencyRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static void LoadViaACurrencyTemplate (DataSet AData, ACurrencyRow ATemplateRow, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaACurrencyTemplate (DataSet AData, ACurrencyRow ATemplateRow, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaACurrencyTemplate (ACurrencyRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static AArInvoiceTable LoadViaACurrencyTemplate (ACurrencyRow ATemplateRow, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaACurrencyTemplate (ACurrencyRow ATemplateRow, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaACurrencyTemplate (ACurrencyRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaACurrencyTemplate (DataSet ADataSet, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static void LoadViaACurrencyTemplate (DataSet AData, TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaACurrencyTemplate (DataSet AData, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaACurrencyTemplate (TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static AArInvoiceTable LoadViaACurrencyTemplate (TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaACurrencyTemplate (TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static int CountViaACurrency (String ACurrencyCode, TDBTransaction ATransaction)
 auto generated More...
 
static int CountViaACurrencyTemplate (ACurrencyRow ATemplateRow, StringCollection ATemplateOperators, TDBTransaction ATransaction)
 auto generated More...
 
static int CountViaACurrencyTemplate (TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaAArDiscount (DataSet ADataSet, String AArDiscountCode, System.DateTime AArDateValidFrom, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated LoadViaLinkTable More...
 
static void LoadViaAArDiscount (DataSet AData, String AArDiscountCode, System.DateTime AArDateValidFrom, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaAArDiscount (DataSet AData, String AArDiscountCode, System.DateTime AArDateValidFrom, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaAArDiscount (String AArDiscountCode, System.DateTime AArDateValidFrom, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static AArInvoiceTable LoadViaAArDiscount (String AArDiscountCode, System.DateTime AArDateValidFrom, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaAArDiscount (String AArDiscountCode, System.DateTime AArDateValidFrom, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaAArDiscountTemplate (DataSet ADataSet, AArDiscountRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static void LoadViaAArDiscountTemplate (DataSet AData, AArDiscountRow ATemplateRow, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaAArDiscountTemplate (DataSet AData, AArDiscountRow ATemplateRow, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaAArDiscountTemplate (AArDiscountRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static AArInvoiceTable LoadViaAArDiscountTemplate (AArDiscountRow ATemplateRow, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaAArDiscountTemplate (AArDiscountRow ATemplateRow, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaAArDiscountTemplate (AArDiscountRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaAArDiscountTemplate (DataSet ADataSet, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static void LoadViaAArDiscountTemplate (DataSet AData, TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaAArDiscountTemplate (DataSet AData, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaAArDiscountTemplate (TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static AArInvoiceTable LoadViaAArDiscountTemplate (TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 auto generated More...
 
static AArInvoiceTable LoadViaAArDiscountTemplate (TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static int CountViaAArDiscount (String AArDiscountCode, System.DateTime AArDateValidFrom, TDBTransaction ATransaction)
 auto generated CountViaLinkTable More...
 
static int CountViaAArDiscountTemplate (AArDiscountRow ATemplateRow, StringCollection ATemplateOperators, TDBTransaction ATransaction)
 auto generated More...
 
static int CountViaAArDiscountTemplate (TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 auto generated More...
 
static void DeleteByPrimaryKey (Int32 ALedgerNumber, Int32 AKey, TDBTransaction ATransaction)
 auto generated More...
 
static void DeleteUsingTemplate (AArInvoiceRow ATemplateRow, StringCollection ATemplateOperators, TDBTransaction ATransaction)
 auto generated More...
 
static void DeleteUsingTemplate (TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 auto generated More...
 
static void SubmitChanges (AArInvoiceTable ATable, TDBTransaction ATransaction)
 Auto generated code ... More...
 
static void AddOrModifyRecord (Int32 ALedgerNumber, Int32 AKey, AArInvoiceTable ATable, AArInvoiceRow ANewRow, bool ADoNotOverwrite, TDBTransaction ATransaction)
 
static bool NoDefaultColumn (String AColumnName)
 This function returns true if the column name is not one of the special columns, that are written automatically: modified date and by, created date and by, modification id More...
 
static void GetStoredModification (short ATableId, string[] AColumnNames, int[] APrimKeyColumnOrdList, DataRow ADataRow, DB.TDBTransaction ATransaction, out DateTime AModificationID, out String AModifiedBy, out System.DateTime AModifiedDate, bool ATreatRowAsAdded=false)
 This function returns the modification details of a row More...
 
static void InsertRow (short ATableId, ref DataRow ADataRow, String ACurrentUser, StringBuilder AInsertStatement, List< OdbcParameter >AInsertParameters)
 This function is called by the DataStore (SubmitChanges). it will not update the modification id. More...
 
static void InsertRow (short ATableId, ref DataRow ADataRow, TDBTransaction ATransaction, String ACurrentUser, bool ATreatRowAsAdded)
 This function is called by the DataStore (SubmitChanges). it will update the modification id. More...
 
static void UpdateRow (short ATableId, bool AThrowAwayAfterSubmitChanges, ref DataRow ADataRow, DB.TDBTransaction ATransaction, String ACurrentUser)
 This function is called by the DataStore (SubmitChanges) More...
 
static void DeleteRow (short ATableId, DataRow ADataRow, DB.TDBTransaction ATransaction)
 This function is called by the DataStore (SubmitChanges) More...
 
static String GenerateSelectClause (StringCollection AFieldList, short ATableID, bool AIncludeTableNames=false)
 This function expects a StringCollection that can be filled, empty or nil. It also needs the list of the primary key columns, because otherwise the returned row will fail the constraints. It will return a proper Select Clause. More...
 
static String GenerateSelectClauseLong (String ATableName, StringCollection AFieldList, short ATableId)
 This function expects a StringCollection that can be filled, empty or nil. It also needs the list of the primary key columns, because otherwise the returned row will fail the constraints. It will prefix all fields with the given tablename. needed for selecting from join statements. It will return a proper Select Clause. If a field has already a dot in the name, the ATablename is not put before it: That way you can do SUM(PUB_table.p_something). More...
 
static String GenerateWhereClause (string[] AColumnNames, DataRow ADataRow, StringCollection ATemplateOperators)
 This function expects an empty table that contains all existing columns, and a datarow that has a string or an empty value for each column. It will return a Where clause, using the given values. More...
 
static String GenerateWhereClause (string[] AColumnNames, DataRow ADataRow)
 This function expects an empty table that contains all existing columns, and a datarow that has a string or an empty value for each column. It will return a Where clause, using the given values. More...
 
static String GenerateWhereClause (TSearchCriteria[] ASearchCriteria)
 This function expects an empty table that contains all existing columns, and search criteria. It will return a Where clause, using the given values. More...
 
static String GenerateWhereClauseFromPrimaryKey (short ATableId)
 this function generates a where clause for the primary key of the given table More...
 
static String GenerateWhereClauseFromUniqueKey (short ATableId)
 this function generates a where clause for the unique key of the given table More...
 
static String GenerateWhereClauseLong (String ATableName, short ATableId, DataRow ADataRow, StringCollection ATemplateOperators)
 This function expects a string list of all existing columns, and a datarow that has a value or an empty value for each column. It will return a Where clause, using the given values. It does not contain the WHERE keyword. It uses the long form, table.fieldname More...
 
static String GenerateWhereClauseLong (String ATableName, TSearchCriteria[] ASearchCriteria)
 This function expects a string list of all existing columns, and a criteria list of values to search for. It will return a Where clause, using the given values. It does not contain the WHERE keyword. It uses the long form, table.fieldname More...
 
static String GenerateWhereClauseLong (String ATableName, short ATableId, DataRow ADataRow)
 This function expects a string array with the names of all existing columns, and a datarow that has a value or an empty value for each column. It will return a Where clause, using the given values. It does not contain the WHERE keyword. It uses the long form, table.fieldname More...
 
static String GenerateOrderByClause (StringCollection AOrderBy)
 This function expects a list of string, where the first string is either "order by" or "group by", and the rest of the string is e.g. "p_partner.p_partner_key_n ASC" It will return the appropriate part of the sql query More...
 
static OdbcParameter CreateOdbcParameter (short ATableId, Int32 AColumnNr, Type AType)
 This function creates an odbc parameter with the correct type, based on the obj which comes from a DataRow More...
 
static System.Object GetSafeValue (DataRow ADataRow, System.Int32 AColumnNr, DataRowVersion AVersion)
 This function returns either a valid object or System.DBNull; this is necessary because mono sometimes has a nil pointer in the DataRow for the original version etc. More...
 
static System.Object GetSafeValue (DataRow ADataRow, String AColumnName, DataRowVersion AVersion)
 This function returns either a valid object or System.DBNull; this is necessary because mono sometimes has a nil pointer in the DataRow for the original version etc. More...
 
static bool NotEquals (DataRow ADataRow, System.Int32 AColumnNr, ref System.Object ACurrentValue)
 Compare the original and the current value of a column in a datarow. Make sure some mono specific troubles are worked around. More...
 
static OdbcParameter[] GetParametersForWhereClause (short ATableId, DataRow ADataRow)
 This function provides the actual parameters for the GenerateWhereClause uses only the values that are not DBNULL More...
 
static OdbcParameter[] GetParametersForWhereClause (short ATableNumber, TSearchCriteria[] ASearchCriteria)
 This function provides the actual parameters for the GenerateWhereClause More...
 
static OdbcParameter[] GetParametersForWhereClauseWithPrimaryKey (short ATableId, DataRow ADataRow)
 This function provides the actual parameters for the GenerateWhereClause uses only the values that are not DBNULL More...
 
static List< OdbcParameter > GetParametersForInsertClause (short ATableId, ref DataRow ADataRow, Int32 ANumberDBColumns, String ACurrentUser, bool AIncludeDefaultColumns)
 This function provides the actual parameters for the GenerateInsertClause uses only the values that are not DBNULL adds the next modification ID More...
 
static OdbcParameter[] GetParametersForUpdateClause (short ATableId, ref DataRow ADataRow, int[] APrimaryKeyColumnOrd, Int32 ANumberDBColumns, String ACurrentUser)
 This function provides the actual parameters for the GenerateUpdateClause uses only the values that are changed (comparing the current and the original version of the row) More...
 
static OdbcParameter[] GetParametersForDeleteClause (short ATableId, DataRow ADataRow, int[] APrimaryKeyColumnOrd)
 This function provides the actual parameters for the GenerateDeleteClause it uses the OriginalVersion of the primary key values More...
 
static String GenerateInsertClause (String ATableName, string[] AColumnNames, DataRow ADataRow, bool AIncludeDefaultColumns)
 This function expects an empty table that contains all existing columns, and a datarow that has a value or an empty value for each column. It will return a complete INSERT Clause. More...
 
static String GenerateUpdateClause (String ATableName, string[] AColumnNames, DataRow ADataRow, int[] APrimKeyColumnOrdList)
 This function expects an empty table that contains all existing columns, and a datarow that has a value or an empty value for each column. More...
 
static DataRow LoadByPrimaryKey (short ATableId, DataSet ADataSet, System.Object[] APrimaryKeyValues, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 load data row by primary key into a dataset More...
 
static DataRow LoadByPrimaryKey (short ATableId, TTypedDataTable ADataTable, System.Object[] APrimaryKeyValues, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 different version for data table More...
 
static void LoadByUniqueKey (short ATableId, DataSet ADataSet, System.Object[] AUniqueKeyValues, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 load data row by unique key into a dataset More...
 
static void LoadByUniqueKey (short ATableId, TTypedDataTable ADataTable, System.Object[] AUniqueKeyValues, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 different version for data table More...
 
static void LoadViaForeignKey (short ATableId, short AOtherTableId, DataSet ADataSet, string[] AThisFieldNames, System.Object[] AForeignKeyValues, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 load data for the current table via a foreign key, eg. load all extracts created by user x More...
 
static void LoadViaForeignKey (short ATableId, short AOtherTableId, TTypedDataTable ADataTable, string[] AThisFieldNames, System.Object[] AForeignKeyValues, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 load data for the current table via a foreign key, eg. load all extracts created by user x More...
 
static void LoadViaForeignKey (short ATableId, short AOtherTableId, DataSet ADataSet, string[] AThisFieldNames, DataRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 Load via other table, using template values. More...
 
static void LoadViaForeignKey (short ATableId, short AOtherTableId, TTypedDataTable ADataTable, string[] AThisFieldNames, DataRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 Load via other table, using template values. More...
 
static void LoadViaForeignKey (short ATableId, short AOtherTableId, DataSet ADataSet, string[] AThisFieldNames, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 Load via other table, using template values. More...
 
static void LoadViaForeignKey (short ATableId, short AOtherTableId, TTypedDataTable ADataTable, string[] AThisFieldNames, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 Load via other table, using template values. More...
 
static int CountViaForeignKey (short ATableId, short AOtherTableId, string[] AThisFieldNames, System.Object[] AForeignKeyValues, TDBTransaction ATransaction)
 count the rows by the values of a foreign key More...
 
static int CountViaForeignKey (short ATableId, short AOtherTableId, string[] AThisFieldNames, DataRow ATemplateRow, StringCollection ATemplateOperators, TDBTransaction ATransaction)
 count the rows by the values of a foreign key More...
 
static int CountViaForeignKey (short ATableId, short AOtherTableId, string[] AThisFieldNames, TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 count the rows by the values of a foreign key More...
 
static void DeleteByPrimaryKey (short ATableId, System.Object[] APrimaryKeyValues, TDBTransaction ATransaction)
 delete by primary key values More...
 
static bool Exists (short ATableId, System.Object[] APrimaryKeyValues, TDBTransaction ATransaction)
 check if row exists with the primary key More...
 
static bool ExistsUniqueKey (short ATableId, System.Object[] AUniqueKeyValues, TDBTransaction ATransaction)
 check if row exists with the unique key More...
 
static void LoadUsingTemplate (short ATableID, DataSet ADataSet, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 loads all rows matching certain search criteria into a dataset More...
 
static void LoadUsingTemplate (short ATableID, TTypedDataTable ATypedTableToLoad, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 loads all rows matching certain search criteria into a typed data table More...
 
static void LoadUsingTemplate (short ATableId, DataSet ADataSet, DataRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 load using a template row More...
 
static void LoadUsingTemplate (short ATableId, TTypedDataTable ADataTable, DataRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 load using a template row More...
 
static void DeleteUsingTemplate (short ATableId, DataRow ATemplateRow, StringCollection ATemplateOperators, TDBTransaction ATransaction)
 delete all rows matching the given row More...
 
static void DeleteUsingTemplate (short ATableId, TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 delete all rows matching the search criteria More...
 
static void SubmitChanges (TTypedDataTable ATable, TDBTransaction ATransaction, eSubmitChangesOperations ASelectedOperations, string AUserId, string ASequenceName, string ASequenceField)
 submit those rows in the table that have been modified or created or deleted More...
 
static void SubmitChanges (TTypedDataTable ATable, TDBTransaction ATransaction, string AUserId, string ASequenceName, string ASequenceField)
 overloaded version without ASelectedOperations More...
 
static void SubmitChanges (TTypedDataTable ATable, TDBTransaction ATransaction, string AUserId)
 overloaded version without sequence More...
 
static void SubmitChanges (TTypedDataTable ATable, TDBTransaction ATransaction, eSubmitChangesOperations ASelectedOperations, string AUserId)
 overloaded version without sequence, but with ASelectedOperations More...
 
static TVerificationResultCollection BuildVerificationResultCollectionFromRefTables (string AThisTable, string AThisTableLabel, Dictionary< string, object >APKInfo, List< TRowReferenceInfo >AReferences, TResultSeverity AResultSeverity=TResultSeverity.Resv_Critical)
 Builds a TVerificationResultCollection from DB Table references created by a cascading count Method. It will contain only a single TVerificationResult. More...
 

Static Public Attributes

const string DATATABLENAME = "AArInvoice"
 CamelCase version of table name. More...
 
const string DBTABLENAME = "a_ar_invoice"
 original table name in database More...
 
const string MODIFICATION_ID = "s_modification_id_t"
 name of the column used for tracking changes, one ID per change More...
 
const string MODIFIED_BY = "s_modified_by_c"
 who has last modified the row More...
 
const string MODIFIED_DATE = "s_date_modified_d"
 when was the last change to the row More...
 
const string CREATED_BY = "s_created_by_c"
 who has originally created this row More...
 
const string CREATED_DATE = "s_date_created_d"
 when was this row originally created More...
 
static readonly DateTime MODIFICATION_ID_DELETEDROW_INDICATOR = DateTime.MaxValue
 indicates whether a row has been deleted More...
 

Detailed Description

the invoice (which is also an offer at a certain stage)

Member Enumeration Documentation

◆ eSubmitChangesOperations

enumeration of operations that can be selected for SubmitChanges

Enumerator
eUpdate 

update records

eDelete 

delete records

eInsert 

add new records

eAll 

execute all operations, no matter if it is update, delete, insert

Member Function Documentation

◆ AddOrModifyRecord()

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.AddOrModifyRecord ( Int32  ALedgerNumber,
Int32  AKey,
AArInvoiceTable  ATable,
AArInvoiceRow  ANewRow,
bool  ADoNotOverwrite,
TDBTransaction  ATransaction 
)
inlinestatic

If a record with this primary key already exists in the database, that record will be updated. otherwise a new record will be added.

◆ BuildVerificationResultCollectionFromRefTables()

static TVerificationResultCollection Ict.Common.Data.TTypedDataAccess.BuildVerificationResultCollectionFromRefTables ( string  AThisTable,
string  AThisTableLabel,
Dictionary< string, object >  APKInfo,
List< TRowReferenceInfo AReferences,
TResultSeverity  AResultSeverity = TResultSeverity.Resv_Critical 
)
inlinestaticinherited

Builds a TVerificationResultCollection from DB Table references created by a cascading count Method. It will contain only a single TVerificationResult.

Returns
TVerificationResultCollection from DB Table references created by a cascading count Method. In case AReferences does not contain elements a TVerificationResultCollection containing no elements will be returned.
Parameters
AThisTableName of the DB Table (as in the DB) that the references point to.
AThisTableLabelLabel (='friendly name' for the user) of the DB Table that the references point to.
APKInfoDictionary<T, T> consisting of a string-object pair for each Primary Key Column. The string (Key) is the Label ('friendly name' for the user) of the PK Column and the object (Value) holds the actual data of the PK Column.
AReferencesA List<T> of TRowReferenceInfo objects that contain information about the DB Table references created by a cascading count Method.
AResultSeverityAllows the specification of a TResultSeverity for the TVerificationResult that gets added to the return value. (Default=TResultSeverity.Resv_Critical.)
Returns
A TVerificationResultCollection containing a single TVerificationResult that contains information about DB Table references created by a cascading count Method.

◆ CountAll()

static int Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.CountAll ( TDBTransaction  ATransaction)
inlinestatic

this method is called by all overloads

◆ CountUsingTemplate() [1/2]

static int Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.CountUsingTemplate ( AArInvoiceRow  ATemplateRow,
StringCollection  ATemplateOperators,
TDBTransaction  ATransaction 
)
inlinestatic

this method is called by all overloads

◆ CountUsingTemplate() [2/2]

static int Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.CountUsingTemplate ( TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestatic

this method is called by all overloads

◆ CountViaAArDiscount()

static int Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.CountViaAArDiscount ( String  AArDiscountCode,
System.DateTime  AArDateValidFrom,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated CountViaLinkTable

◆ CountViaAArDiscountTemplate() [1/2]

static int Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.CountViaAArDiscountTemplate ( AArDiscountRow  ATemplateRow,
StringCollection  ATemplateOperators,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ CountViaAArDiscountTemplate() [2/2]

static int Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.CountViaAArDiscountTemplate ( TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ CountViaACurrency()

static int Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.CountViaACurrency ( String  ACurrencyCode,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ CountViaACurrencyTemplate() [1/2]

static int Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.CountViaACurrencyTemplate ( ACurrencyRow  ATemplateRow,
StringCollection  ATemplateOperators,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ CountViaACurrencyTemplate() [2/2]

static int Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.CountViaACurrencyTemplate ( TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ CountViaALedger()

static int Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.CountViaALedger ( Int32  ALedgerNumber,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ CountViaALedgerTemplate() [1/2]

static int Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.CountViaALedgerTemplate ( ALedgerRow  ATemplateRow,
StringCollection  ATemplateOperators,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ CountViaALedgerTemplate() [2/2]

static int Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.CountViaALedgerTemplate ( TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ CountViaATaxTable()

static int Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.CountViaATaxTable ( Int32  ALedgerNumber,
String  ATaxTypeCode,
String  ATaxRateCode,
System.DateTime  ATaxValidFrom,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ CountViaATaxTableTemplate() [1/2]

static int Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.CountViaATaxTableTemplate ( ATaxTableRow  ATemplateRow,
StringCollection  ATemplateOperators,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ CountViaATaxTableTemplate() [2/2]

static int Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.CountViaATaxTableTemplate ( TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ CountViaATaxType()

static int Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.CountViaATaxType ( String  ATaxTypeCode,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ CountViaATaxTypeTemplate() [1/2]

static int Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.CountViaATaxTypeTemplate ( ATaxTypeRow  ATemplateRow,
StringCollection  ATemplateOperators,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ CountViaATaxTypeTemplate() [2/2]

static int Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.CountViaATaxTypeTemplate ( TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ CountViaForeignKey() [1/3]

static int Ict.Common.Data.TTypedDataAccess.CountViaForeignKey ( short  ATableId,
short  AOtherTableId,
string[]  AThisFieldNames,
DataRow  ATemplateRow,
StringCollection  ATemplateOperators,
TDBTransaction  ATransaction 
)
inlinestaticinherited

count the rows by the values of a foreign key

◆ CountViaForeignKey() [2/3]

static int Ict.Common.Data.TTypedDataAccess.CountViaForeignKey ( short  ATableId,
short  AOtherTableId,
string[]  AThisFieldNames,
System.Object[]  AForeignKeyValues,
TDBTransaction  ATransaction 
)
inlinestaticinherited

count the rows by the values of a foreign key

◆ CountViaForeignKey() [3/3]

static int Ict.Common.Data.TTypedDataAccess.CountViaForeignKey ( short  ATableId,
short  AOtherTableId,
string[]  AThisFieldNames,
TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestaticinherited

count the rows by the values of a foreign key

◆ CountViaPPartner()

static int Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.CountViaPPartner ( Int64  APartnerKey,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ CountViaPPartnerTemplate() [1/2]

static int Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.CountViaPPartnerTemplate ( PPartnerRow  ATemplateRow,
StringCollection  ATemplateOperators,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ CountViaPPartnerTemplate() [2/2]

static int Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.CountViaPPartnerTemplate ( TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ CreateOdbcParameter()

static OdbcParameter Ict.Common.Data.TTypedDataAccess.CreateOdbcParameter ( short  ATableId,
Int32  AColumnNr,
Type  AType 
)
inlinestaticinherited

This function creates an odbc parameter with the correct type, based on the obj which comes from a DataRow

Parameters
ATableIdTable that we are operating on
AColumnNrwhich column should the parameter be generated for
ATypethe value that needs to be converted to OdbcParameter
Returns
the Odbc parameter

◆ DeleteByPrimaryKey() [1/2]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.DeleteByPrimaryKey ( Int32  ALedgerNumber,
Int32  AKey,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ DeleteByPrimaryKey() [2/2]

static void Ict.Common.Data.TTypedDataAccess.DeleteByPrimaryKey ( short  ATableId,
System.Object[]  APrimaryKeyValues,
TDBTransaction  ATransaction 
)
inlinestaticinherited

delete by primary key values

Parameters
ATableId
APrimaryKeyValues
ATransaction

◆ DeleteRow()

static void Ict.Common.Data.TTypedDataAccess.DeleteRow ( short  ATableId,
DataRow  ADataRow,
DB.TDBTransaction  ATransaction 
)
inlinestaticinherited

This function is called by the DataStore (SubmitChanges)

Returns
void

◆ DeleteUsingTemplate() [1/4]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.DeleteUsingTemplate ( AArInvoiceRow  ATemplateRow,
StringCollection  ATemplateOperators,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ DeleteUsingTemplate() [2/4]

static void Ict.Common.Data.TTypedDataAccess.DeleteUsingTemplate ( short  ATableId,
DataRow  ATemplateRow,
StringCollection  ATemplateOperators,
TDBTransaction  ATransaction 
)
inlinestaticinherited

delete all rows matching the given row

Parameters
ATableId
ATemplateRow
ATemplateOperators
ATransaction

◆ DeleteUsingTemplate() [3/4]

static void Ict.Common.Data.TTypedDataAccess.DeleteUsingTemplate ( short  ATableId,
TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestaticinherited

delete all rows matching the search criteria

Parameters
ATableIdspecify which typed table is used
ASearchCriteria
ATransaction

◆ DeleteUsingTemplate() [4/4]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.DeleteUsingTemplate ( TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ Exists() [1/2]

static bool Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.Exists ( Int32  ALedgerNumber,
Int32  AKey,
TDBTransaction  ATransaction 
)
inlinestatic

check if a row exists by using the primary key

◆ Exists() [2/2]

static bool Ict.Common.Data.TTypedDataAccess.Exists ( short  ATableId,
System.Object[]  APrimaryKeyValues,
TDBTransaction  ATransaction 
)
inlinestaticinherited

check if row exists with the primary key

Parameters
ATableId
APrimaryKeyValues
ATransaction

◆ ExistsUniqueKey()

static bool Ict.Common.Data.TTypedDataAccess.ExistsUniqueKey ( short  ATableId,
System.Object[]  AUniqueKeyValues,
TDBTransaction  ATransaction 
)
inlinestaticinherited

check if row exists with the unique key

Parameters
ATableId
AUniqueKeyValues
ATransaction

◆ GenerateInsertClause()

static String Ict.Common.Data.TTypedDataAccess.GenerateInsertClause ( String  ATableName,
string[]  AColumnNames,
DataRow  ADataRow,
bool  AIncludeDefaultColumns 
)
inlinestaticinherited

This function expects an empty table that contains all existing columns, and a datarow that has a value or an empty value for each column. It will return a complete INSERT Clause.

Returns
the INSERT statement

◆ GenerateOrderByClause()

static String Ict.Common.Data.TTypedDataAccess.GenerateOrderByClause ( StringCollection  AOrderBy)
inlinestaticinherited

This function expects a list of string, where the first string is either "order by" or "group by", and the rest of the string is e.g. "p_partner.p_partner_key_n ASC" It will return the appropriate part of the sql query

Parameters
AOrderByString list with instructions how to order or group the result
Returns
the order by / group by clause

◆ GenerateSelectClause()

static String Ict.Common.Data.TTypedDataAccess.GenerateSelectClause ( StringCollection  AFieldList,
short  ATableID,
bool  AIncludeTableNames = false 
)
inlinestaticinherited

This function expects a StringCollection that can be filled, empty or nil. It also needs the list of the primary key columns, because otherwise the returned row will fail the constraints. It will return a proper Select Clause.

Returns
the Select Clause

◆ GenerateSelectClauseLong()

static String Ict.Common.Data.TTypedDataAccess.GenerateSelectClauseLong ( String  ATableName,
StringCollection  AFieldList,
short  ATableId 
)
inlinestaticinherited

This function expects a StringCollection that can be filled, empty or nil. It also needs the list of the primary key columns, because otherwise the returned row will fail the constraints. It will prefix all fields with the given tablename. needed for selecting from join statements. It will return a proper Select Clause. If a field has already a dot in the name, the ATablename is not put before it: That way you can do SUM(PUB_table.p_something).

Returns
the Select Clause

◆ GenerateUpdateClause()

static String Ict.Common.Data.TTypedDataAccess.GenerateUpdateClause ( String  ATableName,
string[]  AColumnNames,
DataRow  ADataRow,
int[]  APrimKeyColumnOrdList 
)
inlinestaticinherited

This function expects an empty table that contains all existing columns, and a datarow that has a value or an empty value for each column.

Returns
the UPDATE statement

◆ GenerateWhereClause() [1/3]

static String Ict.Common.Data.TTypedDataAccess.GenerateWhereClause ( string[]  AColumnNames,
DataRow  ADataRow 
)
inlinestaticinherited

This function expects an empty table that contains all existing columns, and a datarow that has a string or an empty value for each column. It will return a Where clause, using the given values.

Returns
the Where Clause

◆ GenerateWhereClause() [2/3]

static String Ict.Common.Data.TTypedDataAccess.GenerateWhereClause ( string[]  AColumnNames,
DataRow  ADataRow,
StringCollection  ATemplateOperators 
)
inlinestaticinherited

This function expects an empty table that contains all existing columns, and a datarow that has a string or an empty value for each column. It will return a Where clause, using the given values.

Parameters
AColumnNamesthe column names
ADataRowthe data row with the the columns for the where clause
ATemplateOperatorsEvery template field can have an operator; the default version always used = or LIKE
Returns
the Where Clause

◆ GenerateWhereClause() [3/3]

static String Ict.Common.Data.TTypedDataAccess.GenerateWhereClause ( TSearchCriteria[]  ASearchCriteria)
inlinestaticinherited

This function expects an empty table that contains all existing columns, and search criteria. It will return a Where clause, using the given values.

Parameters
ASearchCriteria
Returns
the Where Clause

◆ GenerateWhereClauseFromPrimaryKey()

static String Ict.Common.Data.TTypedDataAccess.GenerateWhereClauseFromPrimaryKey ( short  ATableId)
inlinestaticinherited

this function generates a where clause for the primary key of the given table

Parameters
ATableId
Returns

◆ GenerateWhereClauseFromUniqueKey()

static String Ict.Common.Data.TTypedDataAccess.GenerateWhereClauseFromUniqueKey ( short  ATableId)
inlinestaticinherited

this function generates a where clause for the unique key of the given table

Parameters
ATableId
Returns

◆ GenerateWhereClauseLong() [1/3]

static String Ict.Common.Data.TTypedDataAccess.GenerateWhereClauseLong ( String  ATableName,
short  ATableId,
DataRow  ADataRow 
)
inlinestaticinherited

This function expects a string array with the names of all existing columns, and a datarow that has a value or an empty value for each column. It will return a Where clause, using the given values. It does not contain the WHERE keyword. It uses the long form, table.fieldname

Parameters
ATableNamethe table that the where clause is generated for
ATableIdid of the table to get the list of all columns of that table
ADataRowcontains the values for the where clause
Returns
the Where Clause

◆ GenerateWhereClauseLong() [2/3]

static String Ict.Common.Data.TTypedDataAccess.GenerateWhereClauseLong ( String  ATableName,
short  ATableId,
DataRow  ADataRow,
StringCollection  ATemplateOperators 
)
inlinestaticinherited

This function expects a string list of all existing columns, and a datarow that has a value or an empty value for each column. It will return a Where clause, using the given values. It does not contain the WHERE keyword. It uses the long form, table.fieldname

Parameters
ATableNamethe table that the where clause is generated for
ATableIdid of the table to get the list of all columns of that table
ADataRowcontains the values for the where clause
ATemplateOperatorsEvery template field can have an operator; the default version always used = or LIKE
Returns
the Where Clause

◆ GenerateWhereClauseLong() [3/3]

static String Ict.Common.Data.TTypedDataAccess.GenerateWhereClauseLong ( String  ATableName,
TSearchCriteria[]  ASearchCriteria 
)
inlinestaticinherited

This function expects a string list of all existing columns, and a criteria list of values to search for. It will return a Where clause, using the given values. It does not contain the WHERE keyword. It uses the long form, table.fieldname

Parameters
ATableNamethe table that the where clause is generated for
ASearchCriteria
Returns
the Where Clause

◆ GetParametersForDeleteClause()

static OdbcParameter[] Ict.Common.Data.TTypedDataAccess.GetParametersForDeleteClause ( short  ATableId,
DataRow  ADataRow,
int[]  APrimaryKeyColumnOrd 
)
inlinestaticinherited

This function provides the actual parameters for the GenerateDeleteClause it uses the OriginalVersion of the primary key values

Parameters
ATableId
ADataRowvalues that are used as parameters
APrimaryKeyColumnOrdhas the order numbers of the columns that make up the primary key
Returns
an array of OdbcParameters

◆ GetParametersForInsertClause()

static List< OdbcParameter > Ict.Common.Data.TTypedDataAccess.GetParametersForInsertClause ( short  ATableId,
ref DataRow  ADataRow,
Int32  ANumberDBColumns,
String  ACurrentUser,
bool  AIncludeDefaultColumns 
)
inlinestaticinherited

This function provides the actual parameters for the GenerateInsertClause uses only the values that are not DBNULL adds the next modification ID

Parameters
ATableId
ADataRowvalues that are used as parameters
ANumberDBColumnsthe number of columns of this row that should be stored in the database; that allows some columns to be added temporarily, e.g. PPartnerLocation.BestAddress in PartnerEdit Dataset
ACurrentUserfor setting modified by
AIncludeDefaultColumnsonly useful when saving many rows in one query
Returns
an array of OdbcParameters

◆ GetParametersForUpdateClause()

static OdbcParameter[] Ict.Common.Data.TTypedDataAccess.GetParametersForUpdateClause ( short  ATableId,
ref DataRow  ADataRow,
int[]  APrimaryKeyColumnOrd,
Int32  ANumberDBColumns,
String  ACurrentUser 
)
inlinestaticinherited

This function provides the actual parameters for the GenerateUpdateClause uses only the values that are changed (comparing the current and the original version of the row)

Parameters
ATableId
ADataRowvalues that are used as parameters
APrimaryKeyColumnOrdcan be empty; is needed for the UPDATE WHERE statement; it has the order numbers of the columns that make up the primary key
ANumberDBColumnsthe number of columns of this row that should be stored in the database; that allows some columns to be added temporarily, e.g. PPartnerLocation.BestAddress in PartnerEdit Dataset
ACurrentUserfor setting modified by
Returns
an array of OdbcParameters

◆ GetParametersForWhereClause() [1/2]

static OdbcParameter[] Ict.Common.Data.TTypedDataAccess.GetParametersForWhereClause ( short  ATableId,
DataRow  ADataRow 
)
inlinestaticinherited

This function provides the actual parameters for the GenerateWhereClause uses only the values that are not DBNULL

Returns
an array of OdbcParameters

◆ GetParametersForWhereClause() [2/2]

static OdbcParameter[] Ict.Common.Data.TTypedDataAccess.GetParametersForWhereClause ( short  ATableNumber,
TSearchCriteria[]  ASearchCriteria 
)
inlinestaticinherited

This function provides the actual parameters for the GenerateWhereClause

Returns
an array of OdbcParameters

◆ GetParametersForWhereClauseWithPrimaryKey()

static OdbcParameter[] Ict.Common.Data.TTypedDataAccess.GetParametersForWhereClauseWithPrimaryKey ( short  ATableId,
DataRow  ADataRow 
)
inlinestaticinherited

This function provides the actual parameters for the GenerateWhereClause uses only the values that are not DBNULL

Parameters
ADataRowvalues that are used as parameters
ATableIdidentifier of the table to get the primary key from it
Returns
an array of OdbcParameters

◆ GetSafeValue() [1/2]

static System.Object Ict.Common.Data.TTypedDataAccess.GetSafeValue ( DataRow  ADataRow,
String  AColumnName,
DataRowVersion  AVersion 
)
inlinestaticinherited

This function returns either a valid object or System.DBNull; this is necessary because mono sometimes has a nil pointer in the DataRow for the original version etc.

Returns
either a valid object or System.DBNull

◆ GetSafeValue() [2/2]

static System.Object Ict.Common.Data.TTypedDataAccess.GetSafeValue ( DataRow  ADataRow,
System.Int32  AColumnNr,
DataRowVersion  AVersion 
)
inlinestaticinherited

This function returns either a valid object or System.DBNull; this is necessary because mono sometimes has a nil pointer in the DataRow for the original version etc.

Returns
either a valid object or System.DBNull

◆ GetStoredModification()

static void Ict.Common.Data.TTypedDataAccess.GetStoredModification ( short  ATableId,
string[]  AColumnNames,
int[]  APrimKeyColumnOrdList,
DataRow  ADataRow,
DB.TDBTransaction  ATransaction,
out DateTime  AModificationID,
out String  AModifiedBy,
out System.DateTime  AModifiedDate,
bool  ATreatRowAsAdded = false 
)
inlinestaticinherited

This function returns the modification details of a row

Returns
void

◆ InsertRow() [1/2]

static void Ict.Common.Data.TTypedDataAccess.InsertRow ( short  ATableId,
ref DataRow  ADataRow,
String  ACurrentUser,
StringBuilder  AInsertStatement,
List< OdbcParameter >  AInsertParameters 
)
inlinestaticinherited

This function is called by the DataStore (SubmitChanges). it will not update the modification id.

◆ InsertRow() [2/2]

static void Ict.Common.Data.TTypedDataAccess.InsertRow ( short  ATableId,
ref DataRow  ADataRow,
TDBTransaction  ATransaction,
String  ACurrentUser,
bool  ATreatRowAsAdded 
)
inlinestaticinherited

This function is called by the DataStore (SubmitChanges). it will update the modification id.

◆ LoadAll() [1/6]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadAll ( DataSet  AData,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadAll() [2/6]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadAll ( DataSet  AData,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadAll() [3/6]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadAll ( DataSet  ADataSet,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

this method is called by all overloads

◆ LoadAll() [4/6]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadAll ( StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadAll() [5/6]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadAll ( StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadAll() [6/6]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadAll ( TDBTransaction  ATransaction)
inlinestatic

auto generated

◆ LoadByPrimaryKey() [1/8]

static AArInvoiceRow Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadByPrimaryKey ( DataSet  AData,
Int32  ALedgerNumber,
Int32  AKey,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadByPrimaryKey() [2/8]

static AArInvoiceRow Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadByPrimaryKey ( DataSet  AData,
Int32  ALedgerNumber,
Int32  AKey,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadByPrimaryKey() [3/8]

static AArInvoiceRow Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadByPrimaryKey ( DataSet  ADataSet,
Int32  ALedgerNumber,
Int32  AKey,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

this method is called by all overloads

◆ LoadByPrimaryKey() [4/8]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadByPrimaryKey ( Int32  ALedgerNumber,
Int32  AKey,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadByPrimaryKey() [5/8]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadByPrimaryKey ( Int32  ALedgerNumber,
Int32  AKey,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadByPrimaryKey() [6/8]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadByPrimaryKey ( Int32  ALedgerNumber,
Int32  AKey,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadByPrimaryKey() [7/8]

static DataRow Ict.Common.Data.TTypedDataAccess.LoadByPrimaryKey ( short  ATableId,
DataSet  ADataSet,
System.Object[]  APrimaryKeyValues,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestaticinherited

load data row by primary key into a dataset

Parameters
ATableId
ADataSet
APrimaryKeyValues
AFieldList
ATransaction
AOrderBy
AStartRecord
AMaxRecords

◆ LoadByPrimaryKey() [8/8]

static DataRow Ict.Common.Data.TTypedDataAccess.LoadByPrimaryKey ( short  ATableId,
TTypedDataTable  ADataTable,
System.Object[]  APrimaryKeyValues,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestaticinherited

different version for data table

◆ LoadByUniqueKey() [1/2]

static void Ict.Common.Data.TTypedDataAccess.LoadByUniqueKey ( short  ATableId,
DataSet  ADataSet,
System.Object[]  AUniqueKeyValues,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestaticinherited

load data row by unique key into a dataset

Parameters
ATableId
ADataSet
AUniqueKeyValues
AFieldList
ATransaction
AOrderBy
AStartRecord
AMaxRecords

◆ LoadByUniqueKey() [2/2]

static void Ict.Common.Data.TTypedDataAccess.LoadByUniqueKey ( short  ATableId,
TTypedDataTable  ADataTable,
System.Object[]  AUniqueKeyValues,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestaticinherited

different version for data table

◆ LoadUsingTemplate() [1/17]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadUsingTemplate ( AArInvoiceRow  ATemplateRow,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadUsingTemplate() [2/17]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadUsingTemplate ( AArInvoiceRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadUsingTemplate() [3/17]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadUsingTemplate ( AArInvoiceRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadUsingTemplate() [4/17]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadUsingTemplate ( AArInvoiceRow  ATemplateRow,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadUsingTemplate() [5/17]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadUsingTemplate ( DataSet  AData,
AArInvoiceRow  ATemplateRow,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadUsingTemplate() [6/17]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadUsingTemplate ( DataSet  AData,
AArInvoiceRow  ATemplateRow,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadUsingTemplate() [7/17]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadUsingTemplate ( DataSet  AData,
TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadUsingTemplate() [8/17]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadUsingTemplate ( DataSet  AData,
TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadUsingTemplate() [9/17]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadUsingTemplate ( DataSet  ADataSet,
AArInvoiceRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

this method is called by all overloads

◆ LoadUsingTemplate() [10/17]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadUsingTemplate ( DataSet  ADataSet,
TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

this method is called by all overloads

◆ LoadUsingTemplate() [11/17]

static void Ict.Common.Data.TTypedDataAccess.LoadUsingTemplate ( short  ATableId,
DataSet  ADataSet,
DataRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestaticinherited

load using a template row

◆ LoadUsingTemplate() [12/17]

static void Ict.Common.Data.TTypedDataAccess.LoadUsingTemplate ( short  ATableID,
DataSet  ADataSet,
TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestaticinherited

loads all rows matching certain search criteria into a dataset

Parameters
ATableIDspecify which typed table is used
ADataSetthe result will be added to this dataset
ASearchCriteria
AFieldListfields to load from the database table
ATransaction
AOrderBy
AStartRecord
AMaxRecords

◆ LoadUsingTemplate() [13/17]

static void Ict.Common.Data.TTypedDataAccess.LoadUsingTemplate ( short  ATableId,
TTypedDataTable  ADataTable,
DataRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestaticinherited

load using a template row

◆ LoadUsingTemplate() [14/17]

static void Ict.Common.Data.TTypedDataAccess.LoadUsingTemplate ( short  ATableID,
TTypedDataTable  ATypedTableToLoad,
TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestaticinherited

loads all rows matching certain search criteria into a typed data table

Parameters
ATableIDspecify which typed table is used
ATypedTableToLoadpre condition: has to have an object of the typed table
ASearchCriteria
AFieldList
ATransaction
AOrderBy
AStartRecord
AMaxRecords

◆ LoadUsingTemplate() [15/17]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadUsingTemplate ( TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadUsingTemplate() [16/17]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadUsingTemplate ( TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadUsingTemplate() [17/17]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadUsingTemplate ( TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaAArDiscount() [1/6]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaAArDiscount ( DataSet  AData,
String  AArDiscountCode,
System.DateTime  AArDateValidFrom,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaAArDiscount() [2/6]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaAArDiscount ( DataSet  AData,
String  AArDiscountCode,
System.DateTime  AArDateValidFrom,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaAArDiscount() [3/6]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaAArDiscount ( DataSet  ADataSet,
String  AArDiscountCode,
System.DateTime  AArDateValidFrom,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated LoadViaLinkTable

◆ LoadViaAArDiscount() [4/6]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaAArDiscount ( String  AArDiscountCode,
System.DateTime  AArDateValidFrom,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaAArDiscount() [5/6]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaAArDiscount ( String  AArDiscountCode,
System.DateTime  AArDateValidFrom,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaAArDiscount() [6/6]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaAArDiscount ( String  AArDiscountCode,
System.DateTime  AArDateValidFrom,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaAArDiscountTemplate() [1/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaAArDiscountTemplate ( AArDiscountRow  ATemplateRow,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaAArDiscountTemplate() [2/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaAArDiscountTemplate ( AArDiscountRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaAArDiscountTemplate() [3/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaAArDiscountTemplate ( AArDiscountRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaAArDiscountTemplate() [4/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaAArDiscountTemplate ( AArDiscountRow  ATemplateRow,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaAArDiscountTemplate() [5/13]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaAArDiscountTemplate ( DataSet  AData,
AArDiscountRow  ATemplateRow,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaAArDiscountTemplate() [6/13]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaAArDiscountTemplate ( DataSet  AData,
AArDiscountRow  ATemplateRow,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaAArDiscountTemplate() [7/13]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaAArDiscountTemplate ( DataSet  AData,
TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaAArDiscountTemplate() [8/13]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaAArDiscountTemplate ( DataSet  AData,
TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaAArDiscountTemplate() [9/13]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaAArDiscountTemplate ( DataSet  ADataSet,
AArDiscountRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaAArDiscountTemplate() [10/13]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaAArDiscountTemplate ( DataSet  ADataSet,
TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaAArDiscountTemplate() [11/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaAArDiscountTemplate ( TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaAArDiscountTemplate() [12/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaAArDiscountTemplate ( TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaAArDiscountTemplate() [13/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaAArDiscountTemplate ( TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaACurrency() [1/6]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaACurrency ( DataSet  AData,
String  ACurrencyCode,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaACurrency() [2/6]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaACurrency ( DataSet  AData,
String  ACurrencyCode,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaACurrency() [3/6]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaACurrency ( DataSet  ADataSet,
String  ACurrencyCode,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaACurrency() [4/6]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaACurrency ( String  ACurrencyCode,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaACurrency() [5/6]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaACurrency ( String  ACurrencyCode,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaACurrency() [6/6]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaACurrency ( String  ACurrencyCode,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaACurrencyTemplate() [1/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaACurrencyTemplate ( ACurrencyRow  ATemplateRow,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaACurrencyTemplate() [2/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaACurrencyTemplate ( ACurrencyRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaACurrencyTemplate() [3/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaACurrencyTemplate ( ACurrencyRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaACurrencyTemplate() [4/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaACurrencyTemplate ( ACurrencyRow  ATemplateRow,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaACurrencyTemplate() [5/13]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaACurrencyTemplate ( DataSet  AData,
ACurrencyRow  ATemplateRow,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaACurrencyTemplate() [6/13]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaACurrencyTemplate ( DataSet  AData,
ACurrencyRow  ATemplateRow,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaACurrencyTemplate() [7/13]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaACurrencyTemplate ( DataSet  AData,
TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaACurrencyTemplate() [8/13]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaACurrencyTemplate ( DataSet  AData,
TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaACurrencyTemplate() [9/13]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaACurrencyTemplate ( DataSet  ADataSet,
ACurrencyRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaACurrencyTemplate() [10/13]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaACurrencyTemplate ( DataSet  ADataSet,
TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaACurrencyTemplate() [11/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaACurrencyTemplate ( TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaACurrencyTemplate() [12/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaACurrencyTemplate ( TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaACurrencyTemplate() [13/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaACurrencyTemplate ( TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaALedger() [1/6]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaALedger ( DataSet  AData,
Int32  ALedgerNumber,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaALedger() [2/6]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaALedger ( DataSet  AData,
Int32  ALedgerNumber,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaALedger() [3/6]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaALedger ( DataSet  ADataSet,
Int32  ALedgerNumber,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaALedger() [4/6]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaALedger ( Int32  ALedgerNumber,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaALedger() [5/6]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaALedger ( Int32  ALedgerNumber,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaALedger() [6/6]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaALedger ( Int32  ALedgerNumber,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaALedgerTemplate() [1/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaALedgerTemplate ( ALedgerRow  ATemplateRow,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaALedgerTemplate() [2/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaALedgerTemplate ( ALedgerRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaALedgerTemplate() [3/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaALedgerTemplate ( ALedgerRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaALedgerTemplate() [4/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaALedgerTemplate ( ALedgerRow  ATemplateRow,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaALedgerTemplate() [5/13]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaALedgerTemplate ( DataSet  AData,
ALedgerRow  ATemplateRow,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaALedgerTemplate() [6/13]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaALedgerTemplate ( DataSet  AData,
ALedgerRow  ATemplateRow,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaALedgerTemplate() [7/13]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaALedgerTemplate ( DataSet  AData,
TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaALedgerTemplate() [8/13]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaALedgerTemplate ( DataSet  AData,
TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaALedgerTemplate() [9/13]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaALedgerTemplate ( DataSet  ADataSet,
ALedgerRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaALedgerTemplate() [10/13]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaALedgerTemplate ( DataSet  ADataSet,
TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaALedgerTemplate() [11/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaALedgerTemplate ( TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaALedgerTemplate() [12/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaALedgerTemplate ( TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaALedgerTemplate() [13/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaALedgerTemplate ( TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaATaxTable() [1/6]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaATaxTable ( DataSet  AData,
Int32  ALedgerNumber,
String  ATaxTypeCode,
String  ATaxRateCode,
System.DateTime  ATaxValidFrom,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaATaxTable() [2/6]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaATaxTable ( DataSet  AData,
Int32  ALedgerNumber,
String  ATaxTypeCode,
String  ATaxRateCode,
System.DateTime  ATaxValidFrom,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaATaxTable() [3/6]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaATaxTable ( DataSet  ADataSet,
Int32  ALedgerNumber,
String  ATaxTypeCode,
String  ATaxRateCode,
System.DateTime  ATaxValidFrom,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaATaxTable() [4/6]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaATaxTable ( Int32  ALedgerNumber,
String  ATaxTypeCode,
String  ATaxRateCode,
System.DateTime  ATaxValidFrom,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaATaxTable() [5/6]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaATaxTable ( Int32  ALedgerNumber,
String  ATaxTypeCode,
String  ATaxRateCode,
System.DateTime  ATaxValidFrom,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaATaxTable() [6/6]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaATaxTable ( Int32  ALedgerNumber,
String  ATaxTypeCode,
String  ATaxRateCode,
System.DateTime  ATaxValidFrom,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaATaxTableTemplate() [1/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaATaxTableTemplate ( ATaxTableRow  ATemplateRow,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaATaxTableTemplate() [2/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaATaxTableTemplate ( ATaxTableRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaATaxTableTemplate() [3/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaATaxTableTemplate ( ATaxTableRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaATaxTableTemplate() [4/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaATaxTableTemplate ( ATaxTableRow  ATemplateRow,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaATaxTableTemplate() [5/13]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaATaxTableTemplate ( DataSet  AData,
ATaxTableRow  ATemplateRow,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaATaxTableTemplate() [6/13]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaATaxTableTemplate ( DataSet  AData,
ATaxTableRow  ATemplateRow,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaATaxTableTemplate() [7/13]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaATaxTableTemplate ( DataSet  AData,
TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaATaxTableTemplate() [8/13]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaATaxTableTemplate ( DataSet  AData,
TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaATaxTableTemplate() [9/13]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaATaxTableTemplate ( DataSet  ADataSet,
ATaxTableRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaATaxTableTemplate() [10/13]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaATaxTableTemplate ( DataSet  ADataSet,
TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaATaxTableTemplate() [11/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaATaxTableTemplate ( TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaATaxTableTemplate() [12/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaATaxTableTemplate ( TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaATaxTableTemplate() [13/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaATaxTableTemplate ( TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaATaxType() [1/6]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaATaxType ( DataSet  AData,
String  ATaxTypeCode,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaATaxType() [2/6]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaATaxType ( DataSet  AData,
String  ATaxTypeCode,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaATaxType() [3/6]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaATaxType ( DataSet  ADataSet,
String  ATaxTypeCode,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaATaxType() [4/6]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaATaxType ( String  ATaxTypeCode,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaATaxType() [5/6]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaATaxType ( String  ATaxTypeCode,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaATaxType() [6/6]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaATaxType ( String  ATaxTypeCode,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaATaxTypeTemplate() [1/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaATaxTypeTemplate ( ATaxTypeRow  ATemplateRow,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaATaxTypeTemplate() [2/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaATaxTypeTemplate ( ATaxTypeRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaATaxTypeTemplate() [3/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaATaxTypeTemplate ( ATaxTypeRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaATaxTypeTemplate() [4/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaATaxTypeTemplate ( ATaxTypeRow  ATemplateRow,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaATaxTypeTemplate() [5/13]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaATaxTypeTemplate ( DataSet  AData,
ATaxTypeRow  ATemplateRow,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaATaxTypeTemplate() [6/13]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaATaxTypeTemplate ( DataSet  AData,
ATaxTypeRow  ATemplateRow,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaATaxTypeTemplate() [7/13]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaATaxTypeTemplate ( DataSet  AData,
TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaATaxTypeTemplate() [8/13]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaATaxTypeTemplate ( DataSet  AData,
TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaATaxTypeTemplate() [9/13]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaATaxTypeTemplate ( DataSet  ADataSet,
ATaxTypeRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaATaxTypeTemplate() [10/13]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaATaxTypeTemplate ( DataSet  ADataSet,
TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaATaxTypeTemplate() [11/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaATaxTypeTemplate ( TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaATaxTypeTemplate() [12/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaATaxTypeTemplate ( TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaATaxTypeTemplate() [13/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaATaxTypeTemplate ( TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaForeignKey() [1/6]

static void Ict.Common.Data.TTypedDataAccess.LoadViaForeignKey ( short  ATableId,
short  AOtherTableId,
DataSet  ADataSet,
string[]  AThisFieldNames,
DataRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestaticinherited

Load via other table, using template values.

◆ LoadViaForeignKey() [2/6]

static void Ict.Common.Data.TTypedDataAccess.LoadViaForeignKey ( short  ATableId,
short  AOtherTableId,
DataSet  ADataSet,
string[]  AThisFieldNames,
System.Object[]  AForeignKeyValues,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestaticinherited

load data for the current table via a foreign key, eg. load all extracts created by user x

◆ LoadViaForeignKey() [3/6]

static void Ict.Common.Data.TTypedDataAccess.LoadViaForeignKey ( short  ATableId,
short  AOtherTableId,
DataSet  ADataSet,
string[]  AThisFieldNames,
TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestaticinherited

Load via other table, using template values.

◆ LoadViaForeignKey() [4/6]

static void Ict.Common.Data.TTypedDataAccess.LoadViaForeignKey ( short  ATableId,
short  AOtherTableId,
TTypedDataTable  ADataTable,
string[]  AThisFieldNames,
DataRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestaticinherited

Load via other table, using template values.

◆ LoadViaForeignKey() [5/6]

static void Ict.Common.Data.TTypedDataAccess.LoadViaForeignKey ( short  ATableId,
short  AOtherTableId,
TTypedDataTable  ADataTable,
string[]  AThisFieldNames,
System.Object[]  AForeignKeyValues,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestaticinherited

load data for the current table via a foreign key, eg. load all extracts created by user x

◆ LoadViaForeignKey() [6/6]

static void Ict.Common.Data.TTypedDataAccess.LoadViaForeignKey ( short  ATableId,
short  AOtherTableId,
TTypedDataTable  ADataTable,
string[]  AThisFieldNames,
TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestaticinherited

Load via other table, using template values.

◆ LoadViaPPartner() [1/6]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaPPartner ( DataSet  AData,
Int64  APartnerKey,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaPPartner() [2/6]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaPPartner ( DataSet  AData,
Int64  APartnerKey,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaPPartner() [3/6]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaPPartner ( DataSet  ADataSet,
Int64  APartnerKey,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaPPartner() [4/6]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaPPartner ( Int64  APartnerKey,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaPPartner() [5/6]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaPPartner ( Int64  APartnerKey,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaPPartner() [6/6]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaPPartner ( Int64  APartnerKey,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaPPartnerTemplate() [1/13]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaPPartnerTemplate ( DataSet  AData,
PPartnerRow  ATemplateRow,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaPPartnerTemplate() [2/13]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaPPartnerTemplate ( DataSet  AData,
PPartnerRow  ATemplateRow,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaPPartnerTemplate() [3/13]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaPPartnerTemplate ( DataSet  AData,
TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaPPartnerTemplate() [4/13]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaPPartnerTemplate ( DataSet  AData,
TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaPPartnerTemplate() [5/13]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaPPartnerTemplate ( DataSet  ADataSet,
PPartnerRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaPPartnerTemplate() [6/13]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaPPartnerTemplate ( DataSet  ADataSet,
TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaPPartnerTemplate() [7/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaPPartnerTemplate ( PPartnerRow  ATemplateRow,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaPPartnerTemplate() [8/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaPPartnerTemplate ( PPartnerRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaPPartnerTemplate() [9/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaPPartnerTemplate ( PPartnerRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaPPartnerTemplate() [10/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaPPartnerTemplate ( PPartnerRow  ATemplateRow,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaPPartnerTemplate() [11/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaPPartnerTemplate ( TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaPPartnerTemplate() [12/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaPPartnerTemplate ( TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaPPartnerTemplate() [13/13]

static AArInvoiceTable Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.LoadViaPPartnerTemplate ( TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ NoDefaultColumn()

static bool Ict.Common.Data.TTypedDataAccess.NoDefaultColumn ( String  AColumnName)
inlinestaticinherited

This function returns true if the column name is not one of the special columns, that are written automatically: modified date and by, created date and by, modification id

Returns
true if this is no special auto column

◆ NotEquals()

static bool Ict.Common.Data.TTypedDataAccess.NotEquals ( DataRow  ADataRow,
System.Int32  AColumnNr,
ref System.Object  ACurrentValue 
)
inlinestaticinherited

Compare the original and the current value of a column in a datarow. Make sure some mono specific troubles are worked around.

Returns
result of comparison

◆ SubmitChanges() [1/5]

static void Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.SubmitChanges ( AArInvoiceTable  ATable,
TDBTransaction  ATransaction 
)
inlinestatic

Auto generated code ...

Parameters
ATable
ATransaction

◆ SubmitChanges() [2/5]

static void Ict.Common.Data.TTypedDataAccess.SubmitChanges ( TTypedDataTable  ATable,
TDBTransaction  ATransaction,
eSubmitChangesOperations  ASelectedOperations,
string  AUserId 
)
inlinestaticinherited

overloaded version without sequence, but with ASelectedOperations

◆ SubmitChanges() [3/5]

static void Ict.Common.Data.TTypedDataAccess.SubmitChanges ( TTypedDataTable  ATable,
TDBTransaction  ATransaction,
eSubmitChangesOperations  ASelectedOperations,
string  AUserId,
string  ASequenceName,
string  ASequenceField 
)
inlinestaticinherited

submit those rows in the table that have been modified or created or deleted

Parameters
ATable
ATransaction
ASelectedOperations
AUserIdthe current user, for auditing
ASequenceName
ASequenceField
Returns

◆ SubmitChanges() [4/5]

static void Ict.Common.Data.TTypedDataAccess.SubmitChanges ( TTypedDataTable  ATable,
TDBTransaction  ATransaction,
string  AUserId 
)
inlinestaticinherited

overloaded version without sequence

◆ SubmitChanges() [5/5]

static void Ict.Common.Data.TTypedDataAccess.SubmitChanges ( TTypedDataTable  ATable,
TDBTransaction  ATransaction,
string  AUserId,
string  ASequenceName,
string  ASequenceField 
)
inlinestaticinherited

overloaded version without ASelectedOperations

◆ UpdateRow()

static void Ict.Common.Data.TTypedDataAccess.UpdateRow ( short  ATableId,
bool  AThrowAwayAfterSubmitChanges,
ref DataRow  ADataRow,
DB.TDBTransaction  ATransaction,
String  ACurrentUser 
)
inlinestaticinherited

This function is called by the DataStore (SubmitChanges)

Returns
void

Member Data Documentation

◆ CREATED_BY

const string Ict.Common.Data.TTypedDataAccess.CREATED_BY = "s_created_by_c"
staticinherited

who has originally created this row

◆ CREATED_DATE

const string Ict.Common.Data.TTypedDataAccess.CREATED_DATE = "s_date_created_d"
staticinherited

when was this row originally created

◆ DATATABLENAME

const string Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.DATATABLENAME = "AArInvoice"
static

CamelCase version of table name.

◆ DBTABLENAME

const string Ict.Petra.Server.MFinance.AR.Data.Access.AArInvoiceAccess.DBTABLENAME = "a_ar_invoice"
static

original table name in database

◆ MODIFICATION_ID

const string Ict.Common.Data.TTypedDataAccess.MODIFICATION_ID = "s_modification_id_t"
staticinherited

name of the column used for tracking changes, one ID per change

◆ MODIFICATION_ID_DELETEDROW_INDICATOR

readonly DateTime Ict.Common.Data.TTypedDataAccess.MODIFICATION_ID_DELETEDROW_INDICATOR = DateTime.MaxValue
staticinherited

indicates whether a row has been deleted

◆ MODIFIED_BY

const string Ict.Common.Data.TTypedDataAccess.MODIFIED_BY = "s_modified_by_c"
staticinherited

who has last modified the row

◆ MODIFIED_DATE

const string Ict.Common.Data.TTypedDataAccess.MODIFIED_DATE = "s_date_modified_d"
staticinherited

when was the last change to the row


The documentation for this class was generated from the following file: