ERP 欄位 彈出內容 或 下拉內容 的限制條件 面面觀

S_Resource_Manufacturing IsManufacturingResource='Y'

C_DocType Customer Return C_DocType.DocBaseType IN ('MMR') AND IsSOTrx='Y'

C_DocType Vendor Return C_DocType.DocBaseType IN ('MMS') AND IsSOTrx='N'
C_DocType Customer RMA C_DocType.DocBaseType IN ('SOO', 'POO') AND C_DocType.DocSubTypeSO='RM' AND C_DocType.AD_Client_ID=@#AD_Client_ID@ AND IsSOTrx='Y'

C_DocType Vendor RMA C_DocType.DocBaseType IN ('SOO', 'POO') AND C_DocType.DocSubTypeSO='RM' AND C_DocType.AD_Client_ID=@#AD_Client_ID@ AND IsSOTrx='N'

M_RMA in M_InOut (Complete and IsSOTrx) (IsSOTrx='@IsSOTrx@' AND DocStatus='CO')
M_RMALine of RMA M_RMALine.M_RMA_ID=@M_RMA_ID@

C_DunningLevel of Dunning C_DunningLevel.C_Dunning_ID=@C_Dunning_ID@
C_DunningLevel of Dunning - restrict to level of dunning C_DunningLevel.C_Dunning_ID=@C_Dunning_ID@ AND
((SELECT C_DunningLevel_ID FROM C_DunningRun WHERE C_DunningRun.C_DunningRun_ID=@C_DunningRun_ID@) IS NULL OR
C_DunningLevel.C_DunningLevel_ID IN (SELECT C_DunningLevel_ID FROM C_DunningRun WHERE C_DunningRun.C_DunningRun_ID=@C_DunningRun_ID@))
Tender Type - not Cash AD_Ref_List.Value <> 'X'
C_BPartner - Manufacturer C_BPartner.IsActive='Y' AND C_BPartner.IsManufacturer='Y'
DD_OrderLine of Order DD_OrderLine.DD_Order_ID=@DD_Order_ID@