<< Click to Display Table of Contents >> Navigation: PaXcel - functions > Customer Functions > SLDetail() |
SLDetail( Company, Account, FieldToReturn )
This function will return required field from the selected customer account.
The arguments are as follows:
Company: This is the path to your Pastel data directory. For example:
c:\PastelData\_demo would enable you to retrieve information from the Pastel Partner demo company
Account: The customer account number to return the field value for
FieldToReturn: This must be one of the following keywords
Field to return |
Keyword |
Customer Name Debtor Category Address 1 Address 2 Address 3 Address 4 Address 5 Vat Reference Discount Last Credit Last Amount Blocked Open Item EU Country Code Currency Code Credit Limit Price List Price List Name User Defined 1 User Defined 2 User Defined 3 User Defined 4 User Defined 5 Freight Method Ship Loyalty Programme Loyalty Card Cash Account Delivery Address 1 Delivery Address 2 Delivery Address 3 Delivery Address 4 Delivery Address 5 Salesman code Salesman name Contact name Telephone Cell phone Fax Number Email Address Monthly Terms Payment Terms *Creation Date |
Name Category Address1 Address2 Address3 Address4 Address5 VatRef Discount LastCredit LastAmount Blocked OpenItem CountryCode Currency Credit PriceList PriceName User1 User2 User3 User4 User5 Freight Ship LProg LCard CashAccount DelAddr1 DelAddr2 DelAddr3 DelAddr4 DelAddr5 Salesman SalesmanName Contact Telephone Cellphone Fax MonthTerms Terms CreateDate |
#Contact Documents #Email Documents #Email Statement |
ContactDocs EmailDocs ContactStmt EmailStmt |
*Sole Proprieor |
SoleProprietor |
*Customer Name |
CustName |
*Customer Surname |
CustSurName |
*Customer ID |
CustID |
*Bank Name |
BankName |
*Bank Type |
BankType |
*Bank Branch |
BankBranch |
*Bank Account No. |
BankAccNumber |
*Bank Account Relation |
BankRelation |
*Third Party ID |
ThirdPartyID |
*Passport Number |
PassportNumber |
*Creation date will only return information from Pastel 2007 data onwards.If your account existed prior to the new field being available the creation date will hold the conversion date from the older version to the version with the creation date field.
#Fields available from Sage Pastel Partner version 12.1.2 onwards
*Fields available from Sage Pastel Partner version 12.1.6 onwards
To return the customer name
SLDetail( "c:\PastelData\_demo", "ACK001","Name" )
To return the Customer main telephone number
SLDetail( "c:\PastelData\_demo", "ACK001", "Telephone" )
|