Data entity extension for Vendor party base type

(0) Share

Report

Posted on by Rich

392

We've created a data entity to provide details of vendor transactions, and one of the fields required on the data entity is the vendor type (organisation or person). Party base type doesn't seem to be a database field (happy to be told I'm missing something), so we've ended up with a computed field in the data entity that feels more clunky than I'd like. Other than better use of SysComputedColumn to construct the outer joins, anyone have a smoother way to get this please?

public class CUSVendorTransactionEntity extends common
{
    public static server str VendorPartyType()
    {
        DataEntityName  dataEntityName= tablestr(CUSVendorTransactionEntity);
        str             AccountNum;
        str             qry;

        accountNum = SysComputedColumn::returnField(DataEntityName, identifierstr(VendTrans), fieldstr(VendTrans, AccountNum));

        qry = strFmt("select case when dpn.[recid] is null then 'Organisation' else 'Person' end from [VENDTABLE] vt inner join [DIRPARTYTABLE] dpt on vt.[PARTY] = dpt.[RECID] left outer join [DIRPERSONNAME] dpn on dpt.[RECID] = dpn.[PERSON] where vt.[ACCOUNTNUM] = %1", accountNum);

        return qry;
    }

}

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

André Arnaud de Cal... 304,553 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi Rich,

The party type is indeed not a database field. It is using an instance table ID as part of the table inheritance. You can consider using the same logic as Microsoft used themselves on the DirPartyBaseEntity:

private static str partyType() { /********************************************* The following is an example of what the query string will look like, table id's may vary: CASE DirPartyTable.InstanceRelationType WHEN 11840 THEN 'Person' WHEN 1910 THEN 'Organization' WHEN 8099 THEN 'LegalEntity' WHEN 7525 THEN 'OperatingUnit' WHEN 6237 THEN 'Team' ELSE '' END *********************************************/ Map partyTypesMap = DirUtility::getPartyTypeNames(); return SysComputedColumn::switch( SysComputedColumn::comparisonField(tableStr(DirPartyBaseEntity), tableStr(DirPartyTable), fieldStr(DirPartyTable, InstanceRelationType)), partyTypesMap, SysComputedColumn::returnLiteral('')); }

Was this reply helpful? Yes No
Rich 392 on at

Like (0)

Report
Copy link

Link copied!

Thanks André. Good reminder that there's normally a precedent somewhere.

Was this reply helpful? Yes No