Introduction
The following is a full list of the commands recognised by Spindle Document Distribution.
The list is split into commands that take a value, such as ACCOUNTREF (e.g. ##ACCOUNTREF ABB001##) and those that do not because they have an inherent value, such as SPUSEREMAIL, which is the email address entered into User Settings in Spindle Document Distribution tools.
Commands that do not take a value
| Command | Comments |
| COMPUTER | The hostname of the machine running the process |
| DATE | The current date, in the format specified in Windows control panel |
| DATEFRIDAY | The date of the next Friday |
| DATEMONDAY | The date of the next Monday |
| DATESATURDAY | The date of the next Saturday |
| DATESUNDAY | The date of the next Sunday |
| DATETHURSDAY | The date of the next Thursday |
| DATETUESDAY | The date of the next Tuesday |
| DATEWEDNESDAY | The date of the next Wednesday |
| DAYL | The current day of the week, in long format, e.g Wednesday |
| DAYN | The current day of the month, as a number |
| DAYS | The current day of the week, in short format, e.g Wed |
| ENDDOC | Deprecated. this functionality was replaced by the split command |
| MONTHL | The current month, in long format, e.g. November |
| MONTHN | The number of the current month, e.g. 11 (note: 01 from January to September) |
| MONTHS | The current month, in short format, e.g. Nov |
| PAYTHEM | Used to specify the location of a paythem button |
| PAYTHEMURL | Contains the URL for the paythem link, can be used in email body text. |
| SENTTYPE | Contains the method of distribution (print, fax, email) |
| SPCOMPANY | The user's company name as set in User Settings |
| SPUSEREMAIL | The user's email address as set in User Settings |
| SPUSERFAX | The user's fax number as set in User Settings |
| SPUSERNAME | The user's name as set in User Settings |
| SPUSERTEL | The user's telephone number as set in User Settings |
| SPUSERWEBSITE | The user's company website as set in User Settings |
| TIME | The current time |
| USER | The logged-in windows user name |
| YEARL | The current year, in 4-digit format, e.g. 2021 |
| YEARS | The current year, in 2-digit format, e.g. 21 |
Commands that take a value
| Full List | Sample Command |
| ACCOUNTREF | ##ACCOUNTREF ABB001## |
| AMOUNT | ##AMOUNT 165.87## |
| ATTACH | ##ATTACH Invoice 123456.pdf## |
| ATTACHDIR | ##ATTACHDIR \\Server\Share\Invoice_Archive## |
| BC01 | ##BC01 12344567## |
| BC02 | as BC01 |
| BC03 | as BC01 |
| BC04 | as BC01 |
| BC05 | as BC01 |
| BC06 | as BC01 |
| BC07 | as BC01 |
| BC08 | as BC01 |
| BC09 | as BC01 |
| BC10 | as BC01 |
| BC11 | as BC01 |
| BC12 | as BC01 |
| BC13 | as BC01 |
| BC14 | as BC01 |
| BC15 | as BC01 |
| BC16 | as BC01 |
| BC17 | as BC01 |
| BC18 | as BC01 |
| BC19 | as BC01 |
| BC20 | as BC01 |
| BC21 | as BC01 |
| BC22 | as BC01 |
| BC23 | as BC01 |
| BC24 | as BC01 |
| BC25 | as BC01 |
| BC26 | as BC01 |
| BC27 | as BC01 |
| BC28 | as BC01 |
| BC29 | as BC01 |
| BC30 | as BC01 |
| BILLADD1 | ##BILLADD1 P/O BOX123## |
| BILLADD2 | ##BILLADD2 123 Street Road## |
| BILLADD3 | ##BILLADD3 Laneton## |
| BILLCITY | ##BILLCITY Roadville## |
| BILLCOUNTRY | ##BILLCOUNTRY UK## |
| BILLCOUNTY | ##BILLCOUNTY Roadchestershire## |
| BILLEMAIL | ##BILLEMAIL maureen.duffy@abbeyretail.com## |
| BILLFAX | ##BILLFAX 012 3245604## |
| BILLFNAME | ##BILLFNAME Maureen## |
| BILLLNAME | ##BILLLNAME Duffy## |
| BILLPOSTCODE | ##BILLPOSTCODE RD1 2AB## |
| BILLSTATE | ##BILLSTATE Lanetonia## |
| BILLTEL | ##BILLTEL 012 32165484## |
| BILLZIP | ##BILLZIP 12345-1234## |
| CFG | ##CFG SalesInvoices## |
| COMPANY | ##COMPANY Homestyle Kitchens## |
| CRMCOMPANY | ##CRMCOMPANY CRMCOMPANY## |
| CRMFNAME | ##CRMFNAME CRMFNAME## |
| CRMSNAME | ##CRMSNAME CRMSNAME## |
| CURRENCY | ##CURRENCY CURRENCY## |
| DBVAR01 | ##DBVAR01 DBVAR01## |
| DBVAR02 | ##DBVAR02 DBVAR02## |
| DBVAR03 | ##DBVAR03 DBVAR03## |
| DBVAR04 | ##DBVAR04 DBVAR04## |
| DBVAR05 | ##DBVAR05 DBVAR05## |
| DBVAR06 | ##DBVAR06 DBVAR06## |
| DBVAR07 | ##DBVAR07 DBVAR07## |
| DBVAR08 | ##DBVAR08 DBVAR08## |
| DBVAR09 | ##DBVAR09 DBVAR09## |
| DBVAR10 | ##DBVAR10 DBVAR10## |
| DBVAR11 | ##DBVAR11 DBVAR11## |
| DBVAR12 | ##DBVAR12 DBVAR12## |
| DBVAR13 | ##DBVAR13 DBVAR13## |
| DBVAR14 | ##DBVAR14 DBVAR14## |
| DBVAR15 | ##DBVAR15 DBVAR15## |
| DBVAR16 | ##DBVAR16 DBVAR16## |
| DBVAR17 | ##DBVAR17 DBVAR17## |
| DBVAR18 | ##DBVAR18 DBVAR18## |
| DBVAR19 | ##DBVAR19 DBVAR19## |
| DBVAR20 | ##DBVAR20 DBVAR20## |
| DBVAR21 | ##DBVAR21 DBVAR21## |
| DBVAR22 | ##DBVAR22 DBVAR22## |
| DBVAR23 | ##DBVAR23 DBVAR23## |
| DBVAR24 | ##DBVAR24 DBVAR24## |
| DBVAR25 | ##DBVAR25 DBVAR25## |
| DBVAR26 | ##DBVAR26 DBVAR26## |
| DBVAR27 | ##DBVAR27 DBVAR27## |
| DBVAR28 | ##DBVAR28 DBVAR28## |
| DBVAR29 | ##DBVAR29 DBVAR29## |
| DBVAR30 | ##DBVAR30 DBVAR30## |
| DOCUMENTNO | ##DOCUMENTNO DOCUMENTNO## |
| ##EMAIL EMAIL## | |
| ERPCOMPANY | ##ERPCOMPANY ERPCOMPANY## |
| FAX | ##FAX FAX## |
| FORM | ##FORM FORM## |
| NAME | ##NAME NAME## |
| MVAR | ##MVAR ...## |
| OVERFORM | ##OVERFORM OVERFORM## |
| PDFPASSWORD | ##PDFPASSWORD PDFPASSWORD## |
| PREF | ##PREF PREF## |
| REFERENCENO | ##REFERENCENO REFERENCENO## |
| SDCATTACH | ##SDCATTACH SDCATTACH## |
| SDCBARCODE | ##SDCBARCODE SDCBARCODE## |
| SHIPADD1 | ##SHIPADD1 SHIPADD1## |
| SHIPADD2 | ##SHIPADD2 SHIPADD2## |
| SHIPCITY | ##SHIPCITY SHIPCITY## |
| SHIPCOUNTRY | ##SHIPCOUNTRY SHIPCOUNTRY## |
| SHIPEMAIL | ##SHIPEMAIL SHIPEMAIL## |
| SHIPFAX | ##SHIPFAX SHIPFAX## |
| SHIPFNAME | ##SHIPFNAME SHIPFNAME## |
| SHIPLNAME | ##SHIPLNAME SHIPLNAME## |
| SHIPSTATE | ##SHIPSTATE SHIPSTATE## |
| SHIPTEL | ##SHIPTEL SHIPTEL## |
| SHIPZIP | ##SHIPZIP SHIPZIP## |
| SMTPPASSWORD | ##SMTPPASSWORD SMTPPASSWORD## |
| TAXAMOUNT | ##TAXAMOUNT TAXAMOUNT## |
| VAR1 | ##VAR1 VAR1## |
| VAR2 | ##VAR2 VAR2## |
| VAR3 | ##VAR3 VAR3## |
| VAR4 | ##VAR4 VAR4## |
| VAR5 | ##VAR5 VAR5## |
| VAR6 | ##VAR6 VAR6## |
| VAR7 | ##VAR7 VAR7## |
| VAR8 | ##VAR8 VAR8## |
| VAR9 | ##VAR9 VAR9## |
| VAR10 | ##VAR10 VAR10## |
| VAR11 | ##VAR11 VAR11## |
| VAR12 | ##VAR12 VAR12## |
| VAR13 | ##VAR13 VAR13## |
| VAR14 | ##VAR14 VAR14## |
| VAR15 | ##VAR15 VAR15## |
| VAR16 | ##VAR16 VAR16## |
| VAR17 | ##VAR17 VAR17## |
| VAR18 | ##VAR18 VAR18## |
| VAR19 | ##VAR19 VAR19## |
| VAR20 | ##VAR20 VAR20## |
| VAR21 | ##VAR21 VAR21## |
| VAR22 | ##VAR22 VAR22## |
| VAR23 | ##VAR23 VAR23## |
| VAR24 | ##VAR24 VAR24## |
| VAR25 | ##VAR25 VAR25## |
| VAR26 | ##VAR26 VAR26## |
| VAR27 | ##VAR27 VAR27## |
| VAR28 | ##VAR28 VAR28## |
| VAR29 | ##VAR29 VAR29## |
| VAR30 | ##VAR30 VAR30## |
| VAR31 | ##VAR31 VAR31## |
| VAR32 | ##VAR32 VAR32## |
| VAR33 | ##VAR33 VAR33## |
| VAR34 | ##VAR34 VAR34## |
| VAR35 | ##VAR35 VAR35## |
| VAR36 | ##VAR36 VAR36## |
| VAR37 | ##VAR37 VAR37## |
| VAR38 | ##VAR38 VAR38## |
| VAR39 | ##VAR39 VAR39## |
| VAR40 | ##VAR40 VAR40## |
| VAR41 | ##VAR41 VAR41## |
| VAR42 | ##VAR42 VAR42## |
| VAR43 | ##VAR43 VAR43## |
| VAR44 | ##VAR44 VAR44## |
| VAR45 | ##VAR45 VAR45## |
| VAR46 | ##VAR46 VAR46## |
| VAR47 | ##VAR47 VAR47## |
| VAR48 | ##VAR48 VAR48## |
| VAR49 | ##VAR49 VAR49## |
| VAR50 | ##VAR50 VAR50## |
Knowledge Base Article Details
| Related Product | Spindle Document Distribution, Spindle Document Management |
| Ref Number | KBA-02-02-043 |
| Document Date | 16-11-2021 |
| Original Author | Vince Hodgson |
| Document Version | v1.0 |
| Last updated | 16-11-2021 |
| Update Author | Vince Hodgson |