Share
ReportHi,
I want to get transfer number column in the inventtrans table. Which table and field should I join in order to achieve this?
Thanks
You’re offline. This is a read only version of the page.
20
Hi,
I want to get transfer number column in the inventtrans table. Which table and field should I join in order to achieve this?
Thanks
As I told you in my first reply, the relation is stored in multiple tables with names starting with InventTransOriginTransfer. For example. threre is InventTransOriginTransfer. Depending on your business requirements, you need to select either one of them or all.
You can join them with InventTrans via InventTransOrigin fields.
Hi,
I want something like this.
select a.ITEMID,a.STATUSISSUE,a.QTY,b.TRANSFERID from InventTrans as a join "b table" on a."keyfield"=b."keyfield"
I need the "b" table name and keyfield to join both tables.
Thanks
I don't understand your new problem. I thought you already have InventTrans, therefore you already have StatusIssue column as well.
But I need the statusissue column also from inventtranstable
The relation is stored in InventTransOriginTransfer* tables. Rather then dealing with those tables by yourself, consider something this:
All responses (
Answers (
InventTransferLine transferLine = inventTrans.inventTransOrigin.originator() as InventTransferLine;
if (transferLine)
{
info(transferLine.TransferId);
}
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156