Company: Link Technologies
Case No: L12394
Logged By: Sanjay (Link Technologies) on 21 Nov 2011 10:08PM
Priority: Not Applicable
Product: Other
Group: To be assigned
Time Taken: 0.00
Assigned To: Sanjay (Link Technologies)
Circulation: Sanjay
Resolve By: Monday, 21 November 2011 10:08 PM [4534 days since logged date]
Status: Closed
Subject: Extract Debtors Master File details from JIWA Database
Summary:    

Use the following SQL script to extract Debtors Master File details from JIWA Database:

select AccountNo,Name,Address1,Address2,Address3,Address4,PostCode,Country,Phone,Fax,BankName, BankAcc, BSBN, AccountName,EmailAddress,LastPurchaseDate,LastPaymentDate from db_main

Audit Notes:
If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12394 in the subject line of all emails regarding this issue.

Document size: 0.3 KB
For call complaints, please contact the Managing Director of the company using this form