TimeInfo Functions
Click a link to jump to examples for a specific area. Client Group Contact Staff Contact's Client Client's Contact
Function |
Description |
Calculation function syntax |
Client_Address1 |
Gets client address 1 field under Setup | Clients | Address/Phone |
TIMEINFO("Client_Address1") |
Client_Address2 |
Gets client address 2 field under Setup | Clients | Address/Phone |
TIMEINFO("Client_Address2") |
Client_Address3 |
Gets client address 3 field under Setup | Clients | Address/Phone |
TIMEINFO("Client_Address3") |
Client_AddressTypeOnLetters |
Gets the address type for letters selected under Setup | Clients | Documents |
TIMEINFO("Client_AddressUseOnLetters") |
Client_AltAddress1 |
Gets client alternate address 1 field under Setup | Clients | Alternate Address |
TIMEINFO("Client_AltAddress1") |
Client_AltAddress2 |
Gets client alternate address 2 field under Setup | Clients | Alternate Address |
TIMEINFO("Client_AltAddress2") |
Client_AltAddress3 |
Gets client alternate address 3 field under Setup | Clients | Alternate Address |
TIMEINFO("Client_AltAddress3") |
Client_AltCity |
Gets client alternative city field under Setup | Clients | Alternate Address |
TIMEINFO("Client_AltCity") |
Client_AltCountry |
Gets client alternative country field under Setup | Clients | Alternate Address |
TIMEINFO("Client_AltCountry") |
Client_AlternateCode |
Gets client alternate code field under Setup | Clients | Other Info |
TIMEINFO("Client_AlternateCode,CategoryCode") |
Client_AlternateCodeDate |
Gets client alternate code date field under Setup | Clients | Other Info |
TIMEINFO("Client_AlternateCodeDate,CategoryCode") |
Client_AlternateCodeDescription |
Gets client alternate code description field under Setup | Clients | Other Info |
TIMEINFO("Client_AlternateCodeDescription,CategoryCode") |
Client_AltName |
Gets client alternative name field under Setup | Clients | Alternate Address |
TIMEINFO("Client_AltName") |
Client_AltPostalCode |
Gets client alternative postal code field under Setup | Clients | Alternate Address |
TIMEINFO("Client_AltPostalCode") |
Client_AltProvince |
Gets client alternative province field under Setup | Clients | Alternate Address |
TIMEINFO("Client_AltProvince") |
Client_ARAging120_150 |
Gets client AR 120-150 days balance |
TIMEINFO("Client_ARAging120_150") |
Client_ARAging150_180 |
Gets client AR 150-180 days balance |
TIMEINFO("Client_ARAging150_180") |
Client_ARAging30_60 |
Gets client AR 30-60 days balance |
TIMEINFO("Client_ARAging30_60") |
Client_ARAging60_90 |
Gets client AR 60-90 days balance |
TIMEINFO("Client_ARAging60_90") |
Client_ARAging90_120 |
Gets client AR 90-120 days balance |
TIMEINFO("Client_ARAging90_120") |
Client_ARAgingCurrent |
Gets client AR current balance |
TIMEINFO("Client_ARAgingCurrent") |
Client_ARAgingOver120 |
Gets client AR over 120 days balance |
TIMEINFO("Client_ARAgingOver120") |
Client_ARAgingOver150 |
Gets client AR over 150 days balance |
TIMEINFO("Client_ARAgingOver150") |
Client_ARAgingOver180 |
Gets client AR over 180 days balance |
TIMEINFO("Client_ARAgingOver180") |
Client_ARAgingOver90 |
Gets client AR over 90 days balance |
TIMEINFO("Client_ARAgingOver90") |
Client_ARBalance |
Gets client AR balance |
TIMEINFO("Client_ARBalance") |
Client_AttentionEmail |
Gets specified client attention email field under Setup | Clients | Attention |
TIMEINFO("Client_AttentionEmail",1) |
Client_AttentionFirstName |
Gets specified client attention first name under Setup | Clients | Attention |
TIMEINFO("Client_AttentionFirstName",1) |
Client_AttentionLastName |
Gets specified client attention last name under Setup | Clients | Attention |
TIMEINFO("Client_AttentionLastName",1) |
Client_AttentionPostName |
Gets specified client attention post name under Setup | Clients | Attention |
TIMEINFO("Client_AttentionPostName",1) |
Client_AttentionPredicate |
Gets specified client attention predicate under Setup | Clients | Attention |
TIMEINFO("Client_AttentionPredicate",1) |
Client_AttentionPreName |
Gets specified client attention pre name under Setup | Clients | Attention |
TIMEINFO("Client_AttentionPreName",1) |
Client_AttentionTitle |
Gets specified client attention title under Setup | Clients | Attention |
TIMEINFO("Client_AttentionTitle",1) |
Client_City |
Gets client city under Setup | Clients | Address/Phone |
TIMEINFO("Client_City") |
Client_Country |
Gets client country under Setup | Clients | Address/Phone |
TIMEINFO("Client_Country") |
Client_CreditCardNumber |
Gets client credit card number under Setup | Clients | Billing Info |
TIMEINFO("Client_CreditCardNumber") |
Client_CreditCardType |
Gets client credit card type under Setup | Clients | Billing Info |
TIMEINFO("Client_CreditCardType") |
Client_DocumentAttentionEmail |
Gets client attention email on letters, labels, envelopes under Setup | Clients | Attention |
TIMEINFO("Client_DocumentAttentionEmail") |
Client_DocumentAttentionFirstName |
Gets client attention first name on letters, labels, envelopes under Setup | Clients | Attention |
TIMEINFO("Client_DocumentAttentionFirstName") |
Client_DocumentAttentionLastName |
Gets client attention last name on letters, labels, envelopes under Setup | Clients | Attention |
TIMEINFO("Client_DocumentAttentionLastName") |
Client_DocumentAttentionPostName |
Gets client attention post name on letters, labels, envelopes under Setup | Clients | Attention |
TIMEINFO("Client_DocumentAttentionPostName") |
Client_DocumentAttentionPredicate |
Gets client attention predicate on letters, labels, envelopes under Setup | Clients | Attention |
TIMEINFO("Client_DocumentAttentionPredicate") |
Client_DocumentAttentionPreName |
Gets client attention pre name on letters, labels, envelopes under Setup | Clients | Attention |
TIMEINFO("Client_DocumentAttentionPreName") |
Client_DocumentAttentionTitle |
Gets client attention title on letters, labels, envelopes under Setup | Clients | Attention |
TIMEINFO("Client_DocumentAttentionTitle") |
Client_Email |
Gets client email under Setup | Clients | Address/Phone |
TIMEINFO("Client_Email") |
Client_EngagementType |
Gets client engagement type under Setup | Clients | Other Info |
TIMEINFO("Client_EngagementType") |
Client_EstimatedRevenue |
Gets client estimated revenue under Setup | Clients | Billing Info |
TIMEINFO("Client_EstimatedRevenue") |
Client_GroupAddress1 |
Gets client group address 1 under Setup | Groups | Address/Phone |
TIMEINFO("Client_GroupAddress1") |
Client_GroupAddress2 |
Gets client group address 2 under Setup | Groups | Address/Phone |
TIMEINFO("Client_GroupAddress2") |
Client_GroupAddress3 |
Gets client group address 3 under Setup | Groups | Address/Phone |
TIMEINFO("Client_GroupAddress3") |
Client_GroupAltAddress1 |
Gets client group alternate address 1 under Setup | Groups | Alternate Address |
TIMEINFO("Client_GroupAltAddress1") |
Client_GroupAltAddress2 |
Gets client group alternate address 2 under Setup | Groups | Alternate Address |
TIMEINFO("Client_GroupAltAddress2") |
Client_GroupAltAddress3 |
Gets client group alternate address 3 under Setup | Groups | Alternate Address |
TIMEINFO("Client_GroupAltAddress3") |
Client_GroupAltCity |
Gets client group alternative city under Setup | Groups | Alternate Address |
TIMEINFO("Client_GroupAltCity") |
Client_GroupAltCountry |
Gets client group alternative country under Setup | Groups | Alternate Address |
TIMEINFO("Client_GroupAltCountry") |
Client_GroupAltPostalCode |
Gets client group alternative postal code under Setup | Groups | Alternate Address |
TIMEINFO("Client_GroupAltPostalCode") |
Client_GroupAltProvince |
Gets client group alternative province under Setup | Groups | Alternate Address |
TIMEINFO("Client_GroupAltProvince") |
Client_GroupCity |
Gets client group city under Setup | Groups | Address/Phone |
TIMEINFO("Client_GroupCity") |
Client_GroupCountry |
Gets client group country under Setup | Groups | Address/Phone |
TIMEINFO("Client_GroupCountry") |
Client_GroupName |
Gets client group name under Setup | Groups | Address/Phone |
TIMEINFO("Client_GroupName") |
Client_GroupNumber |
Gets client group number under Setup | Groups |
TIMEINFO("Client_GroupNumber") |
Client_GroupPostalCode |
Gets client group postal code under Setup | Groups | Address/Phone |
TIMEINFO("Client_GroupPostalCode") |
Client_GroupProvince |
Gets client group province under Setup | Groups | Address/Phone |
TIMEINFO("Client_GroupProvince") |
Client_GroupShortName |
Gets client group short name under Setup | Groups |
TIMEINFO("Client_GroupShortName") |
Client_InactiveDate |
Gets client inactive date under Setup | Clients |
TIMEINFO("Client_InactiveDate") |
Client_Manager |
Gets client manager under Setup | Clients | Other Info |
TIMEINFO("Client_Manager") |
Client_ManagerFirstName |
Gets client manager's first name under Setup | Staff |
TIMEINFO("Client_ManagerFirstName") |
Client_ManagerLastName |
Gets client manager's last name under Setup | Staff |
TIMEINFO("Client_ManagerLastName") |
Client_ManagerName |
Gets client manager's first and last name under Setup | Staff separated with a space |
TIMEINFO("Client_ManagerName") |
Client_ManagerPostName |
Gets client manager's post name under Setup | Staff |
TIMEINFO("Client_ManagerPostName") |
Client_ManagerPreName |
Gets client manager's pre name under Setup | Staff |
TIMEINFO("Client_ManagerPreName") |
Client_Name |
Gets client name under Setup | Clients |
TIMEINFO("Client_Name") |
Client_Number |
Gets client number under Setup | Clients |
TIMEINFO("Client_Number") |
Client_Partner |
Gets client partner under Setup | Clients | Other Info |
TIMEINFO("Client_Partner") |
Client_PartnerFirstName |
Gets client partner's first name under Setup | Staff |
TIMEINFO("Client_PartnerFirstName") |
Client_PartnerLastName |
Gets client partner's last name under Setup | Staff |
TIMEINFO("Client_PartnerLastName") |
Client_PartnerName |
Gets client partner's first and last name under Setup | Staff separated with a space |
TIMEINFO("Client_PartnerName") |
Client_PartnerPostName |
Gets client partner's post name under Setup | Staff |
TIMEINFO("Client_PartnerPostName") |
Client_PartnerPreName |
Gets client partner's pre name under Setup | Staff |
TIMEINFO("Client_PartnerPreName") |
Client_Phone |
Gets specified client phone under Setup | Clients | Address/Phone |
TIMEINFO("Client_Phone",1) |
Client_PostalCode |
Gets client postal code under Setup | Clients | Address/Phone |
TIMEINFO("Client_PostalCode") |
Client_PrimaryTaxRegistrationNum |
Gets client primary tax registration number under Setup | Clients | Tax Info |
TIMEINFO("Client_PrimaryTaxRegistrationNum") |
Client_PrimTaxRate |
Gets client primary tax rate under Setup | Clients | Tax Info |
TIMEINFO("Client_PrimTaxRate") |
Client_Province |
Gets client province under Setup | Clients | Address/Phone |
TIMEINFO("Client_Province") |
Client_SecondaryTaxExemptionNum |
Gets client secondary tax exemption number under Setup | Clients | Tax Info |
TIMEINFO("Client_SecondaryTaxExemptionNum") |
Client_SecTaxRate |
Gets client secondary tax rate under Setup | Clients | Tax Info |
TIMEINFO("Client_SecTaxRate") |
Client_ShortName |
Gets client short name under Setup | Clients |
TIMEINFO("Client_ShortName") |
Client_ShowAttention |
Indicates if client shows attention line on documents under Setup | Clients | Attention |
TIMEINFO("Client_ShowAttention") |
Client_SIC |
Gets client SIC under Setup | Clients | Other Info |
TIMEINFO("Client_SIC") |
Client_SIN |
Gets client SIN under Setup | Clients | Other Info |
TIMEINFO("Client_SIN") |
Client_StartDate |
Gets client start date under Setup | Clients |
TIMEINFO("Client_StartDate") |
Client_Status |
Gets client status under Setup | Clients | Other Info |
TIMEINFO("Client_Status") |
Client_Type |
Gets client type under Setup | Clients |
TIMEINFO("Client_Type") |
Client_WebSite |
Gets client web site under Setup | Clients | Address/Phone |
TIMEINFO("Client_WebSite") |
Client_WIPBalance |
Gets client WIP balance |
TIMEINFO("Client_WIPBalance") |
Client_WIPLimit |
Gets client WIP limit |
TIMEINFO("Client_WIPLimit") |
Client_YearEnd |
Gets client year end under Setup | Clients | Other Info |
TIMEINFO("Client_YearEnd") |
|
||
Group_Address1 |
Gets group address 1 under Setup | Groups | Address/Phone |
TIMEINFO("Group_Address1") |
Group_Address2 |
Gets group address 2 under Setup | Groups | Address/Phone |
TIMEINFO("Group_Address2") |
Group_Address3 |
Gets group address 3 under Setup | Groups | Address/Phone |
TIMEINFO("Group_Address3") |
Group_AddressTypeOnLetters |
Gets the address type for letters selected under Setup | Groups | Documents |
TIMEINFO("Group_AddressTypeOnLetters") |
Group_AltAddress1 |
Gets group alternate address 1 under Setup | Groups | Alternate Address |
TIMEINFO("Group_AltAddress1") |
Group_AltAddress2 |
Gets group alternate address 2 under Setup | Groups | Alternate Address |
TIMEINFO("Group_AltAddress2") |
Group_AltAddress3 |
Gets group alternate address 3 under Setup | Groups | Alternate Address |
TIMEINFO("Group_AltAddress3") |
Group_AltCity |
Gets group alternative city under Setup | Groups | Alternate Address |
TIMEINFO("Group_AltCity") |
Group_AltCountry |
Gets group alternative country under Setup | Groups | Alternate Address |
TIMEINFO("Group_AltCountry") |
Group_AlternateCode |
Gets group alternate code under Setup | Groups | Other Info |
TIMEINFO("Group_AlternateCode,CategoryCode") |
Group_AlternateCodeDate |
Gets group alternate code date under Setup | Groups | Other Info |
TIMEINFO("Group_AlternateCodeDate,CategoryCode") |
Group_AlternateCodeDescription |
Gets group alternate code description under Setup | Groups | Other Info |
TIMEINFO("Group_AlternateCodeDescription,CategoryCode") |
Group_AltName |
Gets group alternative name under Setup | Groups | Alternate Address |
TIMEINFO("Group_AltName") |
Group_AltPostalCode |
Gets group alternative postal code under Setup | Groups | Alternate Address |
TIMEINFO("Group_AltPostalCode") |
Group_AltProvince |
Gets group alternative province under Setup | Groups | Alternate Address |
TIMEINFO("Group_AltProvince") |
Group_ARAging120_150 |
Gets group AR 120-150 days balance |
TIMEINFO("Group_ARAging120_150") |
Group_ARAging150_180 |
Gets group AR 150-180 days balance |
TIMEINFO("Group_ARAging150_180") |
Group_ARAging30_60 |
Gets group AR 30-60 days balance |
TIMEINFO("Group_ARAging30_60") |
Group_ARAging60_90 |
Gets group AR 60-90 days balance |
TIMEINFO("Group_ARAging60_90") |
Group_ARAging90_120 |
Gets group AR 90-120 days balance |
TIMEINFO("Group_ARAging90_120") |
Group_ARAgingCurrent |
Gets group AR current balance |
TIMEINFO("Group_ARAgingCurrent") |
Group_ARAgingOver120 |
Gets group AR over 120 days balance |
TIMEINFO("Group_ARAgingOver120") |
Group_ARAgingOver150 |
Gets group AR over 150 days balance |
TIMEINFO("Group_ARAgingOver150") |
Group_ARAgingOver180 |
Gets group AR over 180 days balance |
TIMEINFO("Group_ARAgingOver180") |
Group_ARAgingOver90 |
Gets group AR over 90 days balance |
TIMEINFO("Group_ARAgingOver90") |
Group_ARBalance |
Gets group AR balance |
TIMEINFO("Group_ARBalance") |
Group_AttentionEmail |
Gets specified group attention email under Setup | Groups | Attention |
TIMEINFO("Group_AttentionEmail",1) |
Group_AttentionFirstName |
Gets specified group attention first name under Setup | Groups | Attention |
TIMEINFO("Group_AttentionFirstName",1) |
Group_AttentionLastName |
Gets specified group attention last name under Setup | Groups | Attention |
TIMEINFO("Group_AttentionLastName",1) |
Group_AttentionPostName |
Gets specified group attention post name under Setup | Groups | Attention |
TIMEINFO("Group_AttentionPostName",1) |
Group_AttentionPredicate |
Gets specified group attention predicate under Setup | Groups | Attention |
TIMEINFO("Group_AttentionPredicate",1) |
Group_AttentionPreName |
Gets specified group attention pre name under Setup | Groups | Attention |
TIMEINFO("Group_AttentionPreName",1) |
Group_AttentionTitle |
Gets specified group attention title under Setup | Groups | Attention |
TIMEINFO("Group_AttentionTitle",1) |
Group_City |
Gets group city under Setup | Groups | Address/Phone |
TIMEINFO("Group_City") |
Group_Country |
Gets group country under Setup | Groups | Address/Phone |
TIMEINFO("Group_Country") |
Group_CreditCardNumber |
Gets group credit card number under Setup | Groups | Billing Info |
TIMEINFO("Group_CreditCardNumber") |
Group_CreditCardType |
Gets group credit card type under Setup | Groups | Billing Info |
TIMEINFO("Group_CreditCardType") |
Group_DocumentAttentionEmail |
Gets group attention email on letters, labels, envelopes under Setup | Groups | Attention |
TIMEINFO("Group_DocumentAttentionEmail") |
Group_DocumentAttentionFirstName |
Gets group attention first name on letters, labels, envelopes under Setup | Groups | Attention |
TIMEINFO("Group_DocumentAttentionFirstName") |
Group_DocumentAttentionLastName |
Gets group attention last name on letters, labels, envelopes under Setup | Groups | Attention |
TIMEINFO("Group_DocumentAttentionLastName") |
Group_DocumentAttentionPostName |
Gets group attention post name on letters, labels, envelopes under Setup | Groups | Attention |
TIMEINFO("Group_DocumentAttentionPostName") |
Group_DocumentAttentionPredicate |
Gets group attention predicate on letters, labels, envelopes under Setup | Groups | Attention |
TIMEINFO("Group_DocumentAttentionPredicate") |
Group_DocumentAttentionPreName |
Gets group attention pre name on letters, labels, envelopes under Setup | Groups | Attention |
TIMEINFO("Group_DocumentAttentionPreName") |
Group_DocumentAttentionTitle |
Gets group attention title on letters, labels, envelopes under Setup | Groups | Attention |
TIMEINFO("Group_DocumentAttentionTitle") |
Group_Email |
Gets group email under Setup | Groups | Address/Phone |
TIMEINFO("Group_Email") |
Group_EngagementType |
Gets group engagement type under Setup | Groups |
TIMEINFO("Group_EngagementType") |
Group_EstimatedRevenue |
Gets group estimated revenue under Setup | Groups | Billing Info |
TIMEINFO("Group_EstimatedRevenue") |
Group_InactiveDate |
Gets group inactive date under Setup | Groups |
TIMEINFO("Group_InactiveDate") |
Group_Manager |
Gets group manager under Setup | Groups | Other Info |
TIMEINFO("Group_Manager") |
Group_ManagerFirstName |
Gets group manager first name under Setup | Staff |
TIMEINFO("Group_ManagerFirstName") |
Group_ManagerLastName |
Gets group manager last name under Setup | Staff |
TIMEINFO("Group_ManagerLastName") |
Group_ManagerName |
Gets group manager user name under Setup | Staff |
TIMEINFO("Group_ManagerName") |
Group_ManagerPostName |
Gets group manager post name under Setup | Staff |
TIMEINFO("Group_ManagerPostName") |
Group_ManagerPreName |
Gets group manager pre name under Setup | Staff |
TIMEINFO("Group_ManagerPreName") |
Group_Name |
Gets group name under Setup | Groups |
TIMEINFO("Group_Name") |
Group_Number |
Gets group number under Setup | Groups |
TIMEINFO("Group_Number") |
Group_Partner |
Gets group partner under Setup | Groups | Other Info |
TIMEINFO("Group_Partner") |
Group_PartnerFirstName |
Gets group partner first name under Setup | Staff |
TIMEINFO("Group_PartnerFirstName") |
Group_PartnerLastName |
Gets group partner last name under Setup | Staff |
TIMEINFO("Group_PartnerLastName") |
Group_PartnerName |
Gets group partner name under Setup | Staff |
TIMEINFO("Group_PartnerName") |
Group_PartnerPostName |
Gets group partner post name under Setup | Staff |
TIMEINFO("Group_PartnerPostName") |
Group_PartnerPreName |
Gets group partner pre name under Setup | Staff |
TIMEINFO("Group_PartnerPreName") |
Group_Phone |
Gets specified group phone under Setup | Groups | Address/Phone |
TIMEINFO("Group_Phone",1) |
Group_PostalCode |
Gets group postal code under Setup | Groups | Address/Phone |
TIMEINFO("Group_PostalCode") |
Group_PrimaryTaxRegistrationNum |
Gets group primary tax registration number under Setup | Groups | Tax Info |
TIMEINFO("Group_PrimaryTaxRegistrationNum") |
Group_PrimTaxRate |
Gets group primary tax rate under Setup | Groups | Tax Info |
TIMEINFO("Group_PrimTaxRate") |
Group_Province |
Gets group province under Setup | Groups | Address/Phone |
TIMEINFO("Group_Province") |
Group_SecondaryTaxExemptionNum |
Gets group secondary tax exemption number under Setup | Groups | Tax Info |
TIMEINFO("Group_SecondaryTaxExemptionNum") |
Group_SecTaxRate |
Gets group secondary tax rate under Setup | Groups | Tax Info |
TIMEINFO("Group_SecTaxRate") |
Group_ShortName |
Gets group short name under Setup | Groups |
TIMEINFO("Group_ShortName") |
Group_ShowAttention |
Indicates if group shows attention line on documents under Setup | Groups | Attention |
TIMEINFO("Client_ShowAttention") |
Group_SIC |
Gets group SIC under Setup | Groups | Other Info |
TIMEINFO("Group_SIC") |
Group_SIN |
Gets group SIN under Setup | Groups | Other Info |
TIMEINFO("Group_SIN") |
Group_StartDate |
Gets group start date under Setup | Groups |
TIMEINFO("Group_StartDate") |
Group_Status |
Gets group status under Setup | Groups |
TIMEINFO("Group_Status") |
Group_Type |
Gets group type under Setup | Groups |
TIMEINFO("Group_Type") |
Group_WebSite |
Gets group web site under Setup | Groups | Address/Phone |
TIMEINFO("Group_WebSite") |
Group_WIPBalance |
Gets group WIP balance |
TIMEINFO("Group_WIPBalance") |
Group_YearEnd |
Gets group year end under Setup | Groups | Other Info |
TIMEINFO("Group_YearEnd") |
|
||
Contact_Address1 |
Gets contact address 1 under Setup | Contacts | Address/Phone |
TIMEINFO("Contact_Address1") |
Contact_Address2 |
Gets contact address 2 under Setup | Contacts | Address/Phone |
TIMEINFO("Contact_Address2") |
Contact_Address3 |
Gets contact address 3 under Setup | Contacts | Address/Phone |
TIMEINFO("Contact_Address3") |
Contact_AlternateCode |
Gets contact alternate code under Setup | Contacts | Other Info |
TIMEINFO("Contact_AlternateCode,CategoryCode") |
Contact_AlternateCodeDate |
Gets contact alternate code date under Setup | Contacts | Other Info |
TIMEINFO("Contact_AlternateCodeDate,CategoryCode") |
Contact_AlternateCodeDescription |
Gets contact alternate code description under Setup | Contacts | Other Info |
TIMEINFO("Contact_AlternateCodeDescription,CategoryCode") |
Contact_AttentionEmail |
Gets contact attention email under Setup | Contacts | Attention |
TIMEINFO("Contact_AttentionEmail") |
Contact_AttentionFirstName |
Gets contact attention first name under Setup | Contacts | Attention |
TIMEINFO("Contact_AttentionFirstName") |
Contact_AttentionLastName |
Gets contact attention last name under Setup | Contacts | Attention |
TIMEINFO("Contact_AttentionLastName") |
Contact_AttentionPostName |
Gets contact attention post name under Setup | Contacts | Attention |
TIMEINFO("Contact_AttentionPostName") |
Contact_AttentionPreName |
Gets contact attention pre name under Setup | Contacts | Attention |
TIMEINFO("Contact_AttentionPreName") |
Contact_AttentionTitle |
Gets contact attention title under Setup | Contacts | Attention |
TIMEINFO("Contact_AttentionTitle") |
Contact_City |
Gets contact city under Setup | Contacts | Address/Phone |
TIMEINFO("Contact_City") |
Contact_Country |
Gets contact country under Setup | Contacts | Address/Phone |
TIMEINFO("Contact_Country") |
Contact_Email |
Gets contact email under Setup | Contacts | Address/Phone |
TIMEINFO("Contact_Email") |
Contact_Name |
Gets contact name under Setup | Contacts |
TIMEINFO("Contact_Name") |
Contact_Number |
Gets contact number under Setup | Contacts |
TIMEINFO("Contact_Number") |
Contact_Phone |
Gets specified contact phone under Setup | Contacts | Address/Phone |
TIMEINFO("Contact_Phone",1) |
Contact_PostalCode |
Gets contact postal code under Setup | Contacts | Address/Phone |
TIMEINFO("Contact_PostalCode") |
Contact_Province |
Gets contact province under Setup | Contacts | Address/Phone |
TIMEINFO("Contact_Province") |
Contact_ShortName |
Gets contact short name under Setup | Contacts |
TIMEINFO("Contact_ShortName") |
Contact_Type |
Gets contact type under Setup | Contacts |
TIMEINFO("Contact_Type") |
Contact_WebSite |
Gets contact web site under Setup | Contacts | Address/Phone |
TIMEINFO("Contact_WebSite") |
|
||
Staff_Address1 |
Gets staff address 1 under Setup | Staff | Address/Phone |
TIMEINFO("Staff_Address1") |
Staff_Address2 |
Gets staff address 2 under Setup | Staff | Address/Phone |
TIMEINFO("Staff_Address2") |
Staff_City |
Gets staff city under Setup | Staff | Address/Phone |
TIMEINFO("Staff_City") |
Staff_CostRate |
Gets staff cost rate under Setup | Staff | Rates |
TIMEINFO("Staff_CostRate") |
Staff_Country |
Gets staff country under Setup | Staff | Address/Phone |
TIMEINFO("Staff_Country") |
Staff_Department |
Gets staff department under Setup | Staff | Profile |
TIMEINFO("Staff_Department") |
Staff_Email |
Gets staff email under Setup | Staff | Address/Phone |
TIMEINFO("Staff_Email") |
Staff_FirstName |
Gets staff first name under Setup | Staff |
TIMEINFO("Staff_FirstName") |
Staff_InactiveDate |
Gets staff inactive date under Setup | Staff |
TIMEINFO("Staff_InactiveDate") |
Staff_LastName |
Gets staff last name under Setup | Staff |
TIMEINFO("Staff_LastName") |
Staff_Manager |
Gets staff manager under Setup | Staff | Profile |
TIMEINFO("Staff_Manager") |
Staff_ManagerFirstName |
Gets staff manager's first name under Setup | Staff |
TIMEINFO("Staff_ManagerFirstName") |
Staff_ManagerLastName |
Gets staff manager's last name under Setup | Staff |
TIMEINFO("Staff_ManagerLastName") |
Staff_ManagerName |
Gets staff manager's first and last name under Setup | Staff separated by a space |
TIMEINFO("Staff_ManagerName") |
Staff_ManagerPostName |
Gets staff manager's post name under Setup | Staff |
TIMEINFO("Staff_ManagerPostName") |
Staff_ManagerPreName |
Gets staff manager's pre name under Setup | Staff |
TIMEINFO("Staff_ManagerPreName") |
Staff_Name |
Gets staff user name under Setup | Staff |
TIMEINFO("Staff_Name") |
Staff_Number |
Gets staff number under Setup | Staff |
TIMEINFO("Staff_Number") |
Staff_Office |
Gets staff office under Setup | Staff | Profile |
TIMEINFO("Staff_Office") |
Staff_OvertimeRate |
Gets staff overtime rate under Setup | Staff | Rates |
TIMEINFO("Staff_OvertimeRate") |
Staff_Partner |
Gets staff partner under Setup | Staff | Profile |
TIMEINFO("Staff_Partner") |
Staff_PartnerFirstName |
Gets staff partner's first name under Setup | Staff |
TIMEINFO("Staff_PartnerFirstName") |
Staff_PartnerLastName |
Gets staff partner's last name under Setup | Staff |
TIMEINFO("Staff_PartnerLastName") |
Staff_PartnerName |
Gets staff partner's first and last name under Setup | Staff separated by a space |
TIMEINFO("Staff_PartnerName") |
Staff_PartnerPostName |
Gets staff partner's post name under Setup | Staff |
TIMEINFO("Staff_PartnerPostName") |
Staff_PartnerPreName |
Gets staff partner's pre name under Setup | Staff |
TIMEINFO("Staff_PartnerPreName") |
Staff_Phone |
Gets staff phone under Setup | Staff | Address/Phone |
TIMEINFO("Staff_Phone",1) |
Staff_PostalCode |
Gets staff postal code under Setup | Staff | Address/Phone |
TIMEINFO("Staff_PostalCode") |
Staff_PostName |
Gets staff post name under Setup | Staff |
TIMEINFO("Staff_PostName") |
Staff_PreName |
Gets staff pre name under Setup | Staff |
TIMEINFO("Staff_PreName") |
Staff_Province |
Gets staff province under Setup | Staff | Address/Phone |
TIMEINFO("Staff_Province") |
Staff_SIN |
Gets staff SIN under Setup | Staff |
TIMEINFO("Staff_SIN") |
Staff_StandardRate |
Gets staff standard rate under Setup | Staff | Rates |
TIMEINFO("Staff_StandardRate") |
Staff_StartDate |
Gets staff start date under Setup | Staff |
TIMEINFO("Staff_StartDate") |
Staff_Type |
Gets staff type under Setup | Staff |
TIMEINFO("Staff_Type") |
|
||
Note: Assigned Contacts are under Setup | Clients | Contacts |
||
Contacts_ClientAddress |
Gets specified client address fields under Setup | Clients | Address/Phone for the assigned Contacts |
TIMEINFO("Contacts_ClientAddress1") |
Contacts_ClientAddressTypeOnLetters |
Gets the address type for letters under Setup | Clients | Documents for the assigned Contacts |
TIMEINFO("Contacts_ClientAddressTypeOnLetters") |
Contacts_ClientAltAddress |
Gets specified client alternate address fields under Setup | Clients | Alternate Address for the assigned Contacts |
TIMEINFO("Contacts_ClientAltAddress1") |
Contacts_ClientAltCity Contacts_ClientAltCountry Contacts_ClientAltName Contacts_ClientAltPostalCode Contacts_ClientAltProvince |
Gets client alternate address information under Setup | Clients | Alternate Address for the assigned Contacts |
TIMEINFO("Contacts_ClientAltCity") |
Contacts_ClientAlternateCode, CategoryCode Contacts_ClientAlternateCodeDate, CategoryCode Contacts_ClientAlternateCodeDescription, CategoryCode |
Gets specified client alternate codes information with category code under Setup | Clients | Other Info for the assigned Contacts |
TIMEINFO("Contacts_ClientAlternateCode", "CategoryCode") |
Contacts_ClientARAging120_150 |
Gets client AR 120-150 days balance for the assigned Contacts |
TIMEINFO("Contacts_ClientARAging120_150") |
Contacts_ClientARAging150_180 |
Gets client AR 150-180 days balance for the assigned Contacts |
TIMEINFO("Contacts_ClientARAging150_180") |
Contacts_ClientARAging30_60 |
Gets client AR 30-60 days balance for the assigned Contacts |
TIMEINFO("Contacts_ClientARAging30_60") |
Contacts_ClientARAging60_90 |
Gets client AR 60-90 days balance for the assigned Contacts |
TIMEINFO("Contacts_ClientARAging60_90") |
Contacts_ClientARAging90_120 |
Gets client AR 90-120 days balance for the assigned Contacts |
TIMEINFO("Contacts_ClientARAging90_120") |
Contacts_ClientARAgingCurrent |
Gets client current balance for the assigned Contacts |
TIMEINFO("Contacts_ClientARAgingCurrent") |
Contacts_ClientARAgingOver120 |
Gets client AR over 120 days balance for the assigned Contacts |
TIMEINFO("Contacts_ClientARAgingOver120") |
Contacts_ClientARAgingOver150 |
Gets client AR over 150 days balance for the assigned Contacts |
TIMEINFO("Contacts_ClientARAgingOver150") |
Contacts_ClientARAgingOver180 |
Gets client AR over 180 days balance for the assigned Contacts |
TIMEINFO("Contacts_ClientARAgingOver180") |
Contacts_ClientARAgingOver30 |
Gets client AR over 30 days balance for the assigned Contacts |
TIMEINFO("Contacts_ClientARAgingOver30") |
Contacts_ClientARAgingOver60 |
Gets client AR over 60 days balance for the assigned Contacts |
TIMEINFO("Contacts_ClientARAgingOver60") |
Contacts_ClientARAgingOver90 |
Gets client AR over 90 days balance for the assigned Contacts |
TIMEINFO("Contacts_ClientARAgingOver90") |
Contacts_ClientARBalance |
Gets client AR balance for the assigned Contacts |
TIMEINFO("Contacts_ClientARBalance") |
Contacts_ClientAttentionEmail |
Gets specified client attention email field under Setup | Clients | Attention for the assigned Contacts |
TIMEINFO("Contacts_ClientAttentionEmail",1) |
Contacts_ClientAttentionFirstName |
Gets specified client attention first name field under Setup | Clients | Attention for the assigned Contacts |
TIMEINFO("Contacts_ClientAttentionFirstName",1) |
Contacts_ClientAttentionLastName |
Gets specified client attention last name field under Setup | Clients | Attention for the assigned Contacts |
TIMEINFO("Contacts_ClientAttentionLastName",1) |
Contacts_ClientAttentionPostName |
Gets specified client attention post name field under Setup | Clients | Attention for the assigned Contacts |
TIMEINFO("Contacts_ClientAttentionPostName",1) |
Contacts_ClientAttentionPredicate |
Gets specified client attention predicate field under Setup | Clients | Attention for the assigned Contacts |
TIMEINFO("Contacts_ClientAttentionPredicate",1) |
Contacts_ClientAttentionTitle |
Gets specified client attention title field under Setup | Clients | Attention for the assigned Contacts |
TIMEINFO("Contacts_ClientAttentionTitle",1) |
Contacts_ClientBillingDetails |
Gets client value for Billing Level of Detail under Setup | Clients | Billing Info for the assigned Contacts |
TIMEINFO("Contacts_ClientBillingDetails") |
Contacts_ClientCalculateInterest |
Gets client value for Calculate Recurring Interest under Setup | Clients | Billing Info for the assigned Contacts |
TIMEINFO("Contacts_ClientCalculateInterest") |
Contacts_ClientCity |
Gets client city under Setup | Clients | Address/Phone for the assigned Contacts |
TIMEINFO("Contacts_ClientCity") |
Contacts_ClientCountry |
Gets client country under Setup |Clients | Address/Phone for the assigned Contacts |
TIMEINFO("Contacts_ClientCountry") |
Contacts_ClientCreditCardExpiryDate Contacts_ClientCreditCardNumber Contacts_ClientCreditCardType |
Gets specified client Credit Card information under Setup | Clients | Billing Info for the assigned Contacts |
TIMEINFO("Contacts_ClientCreditCardExpiryDate") |
Contacts_ClientCreditDate Contacts_ClientCreditLimit Contacts_ClientCreditNumber Contacts_ClientCreditRate |
Gets specified client Other Credit information under Setup | Clients | Billing Info for the assigned Contacts |
TIMEINFO("Contacts_ClientCreditDate") |
Contacts_ClientDefaultProject |
Gets client default project under Setup | Clients for the assigned Contacts |
TIMEINFO("Contacts_ClientDefaultProject") |
Contacts_ClientDocumentAttentionEmail Contacts_ClientDocumentAttentionFirstName Contacts_ClientDocumentAttentionLastName Contacts_ClientDocumentAttentionPostName Contacts_ClientDocumentAttentionPredicate Contacts_ClientDocumentAttentionPreName Contacts_ClientDocumentAttentionTitle |
Gets specified client document attention information under Setup | Clients | Attention for the assigned Contacts |
TIMEINFO("Contacts_ClientDocumentAttentionEmail") |
Contacts_ClientEmail |
Gets client email under Setup | Clients | Address/Phone for the assigned Contacts |
TIMEINFO("Contacts_ClientEmail") |
Contacts_ClientEngagementType |
Gets client engagement type under Setup | Clients | Other Info for the assigned Contacts |
TIMEINFO("Contacts_ClientEngagementType") |
Contacts_ClientEstimatedRevenue |
Gets client estimated revenue under Setup | Clients | Billing Info for the assigned Contacts |
TIMEINFO("Contacts_ClientEstimatedRevenue") |
Contacts_ClientFileLocation |
Gets client file location under Setup | Clients | Other Info for the assigned Contacts |
TIMEINFO("Contacts_ClientFileLocation") |
Contacts_ClientGenerateStatement |
Gets client value for Generate Statements field under Setup | Clients | Billing Info for the assigned Contacts |
TIMEINFO("Contacts_ClientGenerateStatement") |
Contacts_ClientGroupAddress |
Gets specified client group address fields under Setup | Groups | Address/Phone for the assigned Contacts |
TIMEINFO("Contacts_ClientGroupAddress1") |
Contacts_ClientGroupAltAddress |
Gets specified client group alternate address fields under Setup | Groups | Alternate Address for the assigned Contacts |
TIMEINFO("Contacts_ClientGroupAltAddress1") |
Contacts_ClientGroupAltCity Contacts_ClientGroupAltCountry Contacts_ClientGroupAltName Contacts_ClientGroupAltPostalCode Contacts_ClientGroupAltProvince |
Gets client group alternate address information under Setup | Groups | Alternate Address for the assigned Contacts |
TIMEINFO("Contacts_ClientGroupAltCity") |
Contacts_ClientGroupCity Contacts_ClientGroupCountry Contacts_ClientGroupPostalCode Contacts_ClientGroupProvince |
Gets specified client group address information under Setup | Groups | Address/Phone for the assigned Contacts |
TIMEINFO("Contacts_ClientGroupCity") |
Contacts_ClientGroupName Contacts_ClientGroupNumber Contacts_ClientGroupShortName |
Gets client group identification under Setup | Groups for the assigned Contacts |
TIMEINFO("Contacts_ClientGroupName") |
Contacts_ClientInactiveDate |
Gets client inactive date under Setup | Clients for the assigned Contacts |
TIMEINFO("Contacts_ClientInactiveDate") |
Contacts_ClientIsGroup |
|
TIMEINFO("Contacts_ClientIsGroup") |
Contacts_ClientManager Contacts_ClientManagerFirsName Contacts_ClientManagerLastName Contacts_ClientManagerName Contacts_ClientManagerPostName Contacts_ClientManagerPreName |
Gets manager information assigned to the client under Setup | Clients | Staff for the assigned Contacts |
TIMEINFO("Contacts_ClientManager") |
Contacts_ClientMemo |
Gets client memo under Setup | Clients | Memos for the assigned Contacts |
TIMEINFO("Contacts_ClientMemo") |
Contacts_ClientName |
Gets client name under Setup | Clients for the assigned Contacts |
TIMEINFO("Contacts_ClientName") |
Contacts_ClientPartner Contacts_ClientPartnerFirstName Contacts_ClientPartnerLastName Contacts_ClientPartnerName Contacts_ClientPartnerPostName Contacts_ClientPartnerPreName |
Gets partner information assigned to the client under Setup | Clients | Staff for the assigned Contacts |
TIMEINFO("Contacts_ClientPartner") |
Contacts_ClientPhone |
Gets client phone information under Setup | Clients | Address/Phone for the assigned Contacts where, 1 - Business phone number 2 - Business fax number 3 - Home phone number 4 - Cellular phone number |
TIMEINFO("Contacts_ClientPhone",1) |
Contacts_ClientPostalCode |
Gets client postal code under Setup | Clients | Address/Phone for the assigned Contacts |
TIMEINFO("Contacts_ClientPostalCode") |
Contacts_ClientPreparedBy Contacts_ClientPreparedByDate |
Gets information for staff that prepared client work under Setup | Clients | Other Info for the assigned Contacts |
TIMEINFO("Contacts_ClientPreparedBy") |
Contacts_ClientPrimaryTaxRegistrationNum |
Gets client tax code registration number under Setup | Clients | Tax Info for the assigned Contacts |
TIMEINFO("Contacts_ClientPrimaryTaxRegistrationNum") |
Contacts_ClientPrimTaxRate |
Gets client primary tax rate under Setup | Clients | Tax Info for the assigned Contacts |
TIMEINFO("Contacts_ClientPrimTaxRate") |
Contacts_ClientProvince |
Gets client province/state under Setup | Clients | Address/Phone for the assigned Contacts |
TIMEINFO("Contacts_ClientProvince") |
Contacts_ClientReviewedBy Contacts_ClientReviewedByDate |
Gets information for staff that reviewed client work under Setup | Clients | Other Info for the assigned Contacts |
TIMEINFO("Contacts_ClientReviewedBy") |
Contacts_ClientSecondaryTaxExemptionNum |
Gets client tax code exemption number under Setup | Clients | Tax Info for the assigned Contacts |
TIMEINFO("Contacts_ClientSecondaryTaxExemptionNum") |
Contacts_ClientSecTaxRate |
Gets client secondary tax rate under Setup | Clients | Tax Info for the assigned Contacts |
TIMEINFO("Contacts_ClientSecTaxRate") |
Contacts_ClientShortName |
Gets client short name under Setup | Clients for the assigned Contacts |
TIMEINFO("Contacts_ClientShortName") |
Contacts_ClientShowAttention |
Gets client value for Show Attention Line on Documents under Setup | Clients | Attention for the assigned Contacts |
TIMEINFO("Contacts_ClientShowAttention") |
Contacts_ClientSIC |
Gets client standard industrial code under Setup | Clients | Other Info for the assigned Contacts |
TIMEINFO("Contacts_ClientSIC") |
Contacts_ClientSIN |
Gets client social security code (social insurance number) under Setup | Clients | Other Info for the assigned Contacts |
TIMEINFO("Contacts_ClientSIN") |
Contacts_ClientStartDate |
Gets client start date under Setup | Clients for the assigned Contacts |
TIMEINFO("Contacts_ClientStartDate") |
Contacts_ClientStatus |
Gets client status under Setup | Clients | Other Info for the assigned Contacts |
TIMEINFO("Contacts_ClientStatus") |
Contacts_ClientType |
Gets client type under Setup | Clients for the assigned Contacts |
TIMEINFO("Contacts_ClientType") |
Contacts_ClientUseWorkCodeTaxRate |
Gets client value for Use Workcode Tax Rate under Setup | Clients | Tax Info for the assigned Contacts |
TIMEINFO("Contacts_ClientUseWorkCodeTaxRate") |
Contacts_ClientWebSite |
Gets client website under Setup | Clients | Address/Phone for the assigned Contacts |
TIMEINFO("Contacts_ClientWebSite") |
Contacts_ClientWIPBalance Contacts_ClientWIPLimit |
Gets client WIP information under Setup | Clients | Billing Info for the assigned Contacts |
TIMEINFO("Contacts_ClientWIPBalance") |
Contacts_ClientYearEnd |
Gets client year end information under Setup | Clients | Other Info for the assigned Contacts |
TIMEINFO("Contacts_ClientYearEnd") |
|
||
Note: Assigned Clients are under Setup | Contacts | Contacts... | Client/Group |
||
Clients_ContactAddress |
Gets contacts address fields under Setup | Contacts | Contacts... | Address/Phone for the assigned Clients |
TIMEINFO("Clients_ContactAddress1") |
Clients_ContactAlternateCode, Clients_ContactCategoryCode |
Gets contacts alternate codes information with category code under Setup | Contacts | Contacts... | Other Info for the assigned Clients |
TIMEINFO("Clients_ContactAlternateCode", "CategoryCode") |
Clients_ContactCity |
Gets contacts locale information under Setup | Contacts | Contacts... | Address/Phone for the assigned Clients |
TIMEINFO("Clients_ContactCity") |
Clients_ContactCompanyName |
Gets the corresponding contact company name (if applicable) under Setup | Contacts | Contact Companies... | Contacts for the assigned Clients |
TIMEINFO("Clients_ContactCompanyName") |
Clients_ContactEmail |
Gets the contact email address under Setup | Contacts | Contacts... for the assigned Clients |
TIMEINFO("Clients_ContactEmail") |
Clients_ContactFirstName Clients_ContactLastName Clients_ContactName Clients_ContactPostName Clients_ContactPreName |
Gets contact name information under Setup | Contacts | Contacts... for the assigned Clients |
TIMEINFO("Clients_ContactFirstName") |
Clients_ContactMemo |
Gets contact memos under Setup | Contacts | Contacts... | Memos for the assigned Clients |
TIMEINFO("Clients_ContactMemo") |
Clients_ContactPhone |
Gets contact phone information under Setup | Contacts | Contacts... | Address/Phone for the assigned Clients where, 1 - Business phone number 2 - Business fax number 3 - Home phone number 4 - Cellular phone number |
TIMEINFO("Clients_ContactPhone", 1) |
Clients_ContactTitle Clients_ContactType |
Gets contact title and type under Setup | Contacts | Contacts... for the assigned Clients |
TIMEINFO("Clients_ContactTitle") |
Clients_ContactWebSite |
Gets contact website under Setup | Contacts | Contacts... | Address/Phone for the assigned Clients |
TIMEINFO("Clients_ContactWebSite") |