<< Click to Display Table of Contents >> Navigation: PaXcel - functions > Supplier Functions > PLDetail() |
PLDetail( Company, Account, FieldToReturn )
This function will return the required field from the selected supplier 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 supplier 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 Last Credit Last Amount Blocked Open Item Country Code Currency Code Credit Limit User Defined 1 User Defined 2 User Defined 3 User Defined 4 User Defined 5 Freight Method Ship Delivery Address 1 Delivery Address 2 Delivery Address 3 Delivery Address 4 Delivery Address 5 Contact name Telephone Cellphone Fax Number Email Address Monthly Terms Payment Terms Default Contra A/c *Creation Date |
Name Category Address1 Address2 Address3 Address4 Address5 VatRef LastCredit LastAmount Blocked OpenItem CountryCode Currency Credit User1 User2 User3 User4 User5 Freight Ship DelAddr1 DelAddr2 DelAddr3 DelAddr4 DelAddr5 Contact Telephone Cellphone Fax MonthTerms Terms ContraAccount CreateDate |
#Sole Proprieor |
SoleProprietor |
#Supplier Name |
SupName |
#Supplier Surname |
SupSurName |
#Supplier ID |
SupID |
#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 only available from Sage Pastel Partner 12.1.6 onwards
The following will return the 2nd user defined field value for supplier COM001
PLDetail( "c:\PastelData\_demo", "COM001", "User2" )
The following will return the Telephone number of the supplier COM001
PLDetail( "c:\PastelData\_demo", "COM001", "Telephone" )
|