I Need an SQL script changing to include the SYSDOCUMENTTYPE table, the joins
- or -
Post a project like this2846
$$$
- Posted:
- Proposals: 6
- Remote
- #1176699
- Awarded
Description
Experience Level: Expert
General information for the business: sql
Description of every module: just the joins in my script are required. I wish to add a column for the transaction type, the script is written - this is the only requirement.
Description of requirements/functionality: sql
Extra notes: SELECT
SLcustomeraccount.CustomerAccountName,
SLcustomeraccount.CustomerAccountNumber,
SLPostedCustomerTran.TransactionReference,
--SLPostedCustomerTran.AllocatedValue,
SLPostedCustomerTran.TaxValue,
SLPostedCustomerTran.GoodsValueInAccountCurrency,
SLPostedCustomerTran.DiscountValue,
SLPostedCustomerTran.PostedDate,
--SLCustomerAccount.PaymentTermsInDays,
--SLpostedcustomertran.fullsettlementperiodindays,
--SLAllocationHeader.AllocationDate,
TransactionReference
from SLPostedCustomerTran
left join SLCustomerAccount on SLCustomerAccount.SLCustomerAccountID = SLPostedCustomerTran.SLCustomerAccountID
--left join TransactionType on TransactionType.TransactionGroupID = SLPostedCustomerTran.SYSTraderTranTypeID
left join SLAllocationTran on SLAllocationTran.SLPostedCustomerTranID = SLPostedCustomerTran.SLPostedCustomerTranID
--left join SLAllocationHeader on SLAllocationHeader.SLAllocationHeaderID = SLAllocationTran.SLAllocationHeaderID
--left join SLAllocationType on SLAllocationType.SLAllocationTypeID = SLAllocationHeader.SLAllocationTypeID
where SLcustomeraccount.CustomerAccountNumber = '1324633'
Description of every module: just the joins in my script are required. I wish to add a column for the transaction type, the script is written - this is the only requirement.
Description of requirements/functionality: sql
Extra notes: SELECT
SLcustomeraccount.CustomerAccountName,
SLcustomeraccount.CustomerAccountNumber,
SLPostedCustomerTran.TransactionReference,
--SLPostedCustomerTran.AllocatedValue,
SLPostedCustomerTran.TaxValue,
SLPostedCustomerTran.GoodsValueInAccountCurrency,
SLPostedCustomerTran.DiscountValue,
SLPostedCustomerTran.PostedDate,
--SLCustomerAccount.PaymentTermsInDays,
--SLpostedcustomertran.fullsettlementperiodindays,
--SLAllocationHeader.AllocationDate,
TransactionReference
from SLPostedCustomerTran
left join SLCustomerAccount on SLCustomerAccount.SLCustomerAccountID = SLPostedCustomerTran.SLCustomerAccountID
--left join TransactionType on TransactionType.TransactionGroupID = SLPostedCustomerTran.SYSTraderTranTypeID
left join SLAllocationTran on SLAllocationTran.SLPostedCustomerTranID = SLPostedCustomerTran.SLPostedCustomerTranID
--left join SLAllocationHeader on SLAllocationHeader.SLAllocationHeaderID = SLAllocationTran.SLAllocationHeaderID
--left join SLAllocationType on SLAllocationType.SLAllocationTypeID = SLAllocationHeader.SLAllocationTypeID
where SLcustomeraccount.CustomerAccountNumber = '1324633'
Neil A.
100% (1)Projects Completed
2
Freelancers worked with
2
Projects awarded
100%
Last project
5 Jun 2016
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
What type of Database is it?
-
What type of database is it?
-
Hi Neil, Judging by the query comments style it looks like this is related to MS SQL Server Transact-SQL. Could you please confirm this is the case? Cheers, Tom
-
Hi. What database are you using? Is it Microsoft SQL server? And what is your time frame and budget for this task?
Thanks for your clarifications!
7799776976177574
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies