...
| Info | ||
|---|---|---|
| ||
SQL taskları harici bir veritabanında işlem yaparlar, Table alanlarında direk tablo ismi kullanmanız gerekir, EBIFlow veri şemalarından bağımsız çalışırlar. |
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
<SqlInsert Connection="$(ConnectionString)" Table="PAYMENT">
<Columns>
<Column Name="RecordID">
<Value>NewGuid</Value>
</Column>
<Column Name="RelationId">
<Evaluate Target="None" Culture="">/*/EFATURA/KAYITNO</Evaluate>
</Column>
<Column Name="TransacionCategory">
<Evaluate Target="None" Culture="">/*/EFATURA/EVRAKSERI</Evaluate>
</Column>
<Column Name="TransacionNumber">
<Evaluate Target="None" Culture="">/*/EFATURA/EVRAKSIRA</Evaluate>
</Column>
<Column Name="CompanyCode">
<Evaluate Target="None" Culture="">/*/EFATURA/TEDARIKCIKODU</Evaluate>
</Column>
<Column Name="DocumentType">
<Value>0</Value>
</Column>
<Column Name="Currency">
<Evaluate Target="None" Culture="">/*/EFATURA/KURSEMBOL</Evaluate>
</Column>
<Column Name="ExchangeRate">
<Value>1</Value>
</Column>
<Column Name="Total">
<Evaluate Target="None" Culture="">/*/SabitBilgi/Tutar</Evaluate>
</Column>
<Column Name="PaymentNumber">
<Evaluate Target="None" Culture="">/*/SabitBilgi/OdemeDokumanNumarasi</Evaluate>
</Column>
<Column Name="AccountCode">
<Evaluate Target="None" Culture="">/*/SabitBilgi/Banka</Evaluate>
</Column>
<Column Name="DebitCredit">
<Value>0</Value>
</Column>
<Column Name="FirmCode">
<Evaluate Target="None" Culture="">/*/EFATURA/FIRMAKODU</Evaluate>
</Column>
<Column Name="CreateUser">
<Evaluate Target="None" Culture="">/*/EFATURA/OLUSTURANKULLANICI</Evaluate>
</Column>
<Column Name="PaymentDate">
<Value Target="Date">Now</Value>
</Column>
<Column Name="CreateDate">
<Value Target="Date">Now</Value>
</Column>
<Column Name="FlowNumber">
<Value>$(InstanceNumber)</Value>
</Column>
</Columns>
</SqlInsert> |
Ayrıca Bakınız
...