应收发票：添加后自动更新对应的提成比例

注意

有对应自定义字段

代码示例

--应收发票：添加后自动更新对应的提成比例
IF @object_type = '13'
	BEGIN
		IF @transaction_type = 'A'

			BEGIN
				UPDATE T1
				SET T1.U_YWYBL = T2.U_YWBL, T1.[U_JLBL] = T2.[U_JLBL], T1.[U_NQBL] = T2.[U_NQBL], T1.[U_NDBL] = T2.[U_NDBL], T1.[U_ZDXKHBL] = T2.[U_KHBL]
				, T1.[U_YJBFB] = T2.[U_YJBL], T1.[U_YWJL] = T2.U_YWJL, T1.U_NQ = T2.U_NQ
				FROM OINV T0
					INNER JOIN INV1 T1 ON T1.DocEntry = T0.DocEntry
					LEFT JOIN (
						SELECT T0.[CardCode], T0.[U_YWBL], T0.[U_JLBL], T0.[U_NQBL], T0.[U_NDBL]
							, T0.[U_KHBL], T0.[U_YJBL], T0.[U_YWJL], T0.[U_NQ]
						FROM OCRD T0
					) T2
					ON T2.CardCode = T0.CardCode
				WHERE T2.CARDCODE = T0.CardCode
					AND T0.[DocEntry] = @list_of_cols_val_tab_del;
			END;
	END