TimeInfo Functions for Documents
Click a link to jump to examples for a specific area. Billing Invoices Credit Notes Miscellaneous Invoices Statements Tax Invoices
Property |
Description |
Calculation function syntax |
|
|
|
BillingCode_BillingCodeDescription |
Gets the description of the billing code applied to the invoice. |
TIMEINFO("BillingCode_BillingCodeDescription") |
BillingCode_BillingCodeExDescription |
Gets the extended description of the billing code applied to the invoice. |
TIMEINFO("BillingCode_BillingCodeExDescription") |
BillingCode_BillingCodeNo |
Gets the billing code number of the code applied to the invoice. |
TIMEINFO("BillingCode_BillingCodeNo") |
Client_AddressTypeOnInvoices |
Gets the type of address used on invoices. Returns: |
TIMEINFO("Client_AddressTypeOnInvoices") |
Client_DisplayClassDescription |
Gets the client classification code description. Returns: |
TIMEINFO("Client_DisplayClassDescription") |
Client_DisplayClassMemo |
Gets whether or not the client displays its classification memo. Returns: |
TIMEINFO("Client_DisplayClassMemo") |
Client_DisplayClassSubtotal |
Gets whether or not the client displays its classification code subtotal. Returns: |
TIMEINFO("Client_DisplayClassSubtotal") |
Client_DisplayProject |
Gets whether or not the client displays its project title. Returns: |
TIMEINFO("Client_DisplayProject") |
Client_DisplayProjectSubtotal |
Gets whether or not the client displays its project subtotal. Returns: |
TIMEINFO("Client_DisplayProjectSubtotal") |
Client_DisplaySubproject |
Gets whether or not the client displays its subproject title. Returns: |
TIMEINFO("Client_DisplaySubproject") |
Client_DisplaySubprojectSubtotal |
Gets whether or not the client displays its subproject subtotal. Returns: |
TIMEINFO("Client_DisplaySubprojectSubtotal") |
Client_DisplaySubtotalDescription |
Gets whether or not the client displays a description on its subtotals. Returns: |
TIMEINFO("Client_DisplaySubtotalDescription") |
Client_DisplayTransactionAmount |
Gets whether or not the client displays its transaction amount. Returns: |
TIMEINFO("Client_DisplayTransactionAmount") |
Client_DisplayTransactionDate |
Gets whether or not the client displays its transaction date. Returns: |
TIMEINFO("Client_DisplayTransactionDate") |
Client_DisplayTransactionDescription |
Gets whether or not the client displays its transaction description. Returns: |
TIMEINFO("Client_DisplayTransactionDescription") |
Client_DisplayTransactionRate |
Gets whether or not the client displays its transaction rate. Returns: |
TIMEINFO("Client_DisplayTransactionRate") |
Client_DisplayTransactionStaff |
Gets whether or not the client displays its transaction staff. Returns: |
TIMEINFO("Client_DisplayTransactionStaff") |
Client_DisplayTransactionUnits |
Gets whether or not the client displays its transaction hours/units. Returns: |
TIMEINFO("Client_DisplayTransactionUnits") |
Client_DisplayWorkCodeDescription |
Gets whether or not the client displays its work code description. Returns: |
TIMEINFO("Client_DisplayWorkCodeDescription") |
Client_DisplayWorkCodeMemo |
Gets whether or not the client displays its work code memo. Returns: |
TIMEINFO("Client_DisplayWorkCodeMemo") |
Client_DisplayWorkCodeSubtotal |
Gets whether or not the client displays its work code subtotal. Returns: |
TIMEINFO("Client_DisplayWorkCodeSubtotal") |
Client_DisplayWorkCodeTaxAmount |
Gets whether or not the client displays its work code tax amount columns. Returns: |
TIMEINFO("Client_DisplayWorkCodeTaxAmount") |
Client_UseWorkcodeTaxRate |
Gets whether or not the client uses its work code tax rate. |
TIMEINFO("Client_UseWorkcodeTaxRate") |
Code_BillingCodeBriefDescription |
Gets the billing code short description for the code entered as a parameter. |
TIMEINFO("Code_BillingCodeBriefDescription","Code") |
Code_BillingCodeDescription |
Gets the billing code description for the code entered as a parameter. Used in the basic invoice. |
TIMEINFO("Code_BillingCodeDescription","Code") |
Code_ClassCodeBriefDescription |
Gets the classification code short description for the code entered as a parameter. |
TIMEINFO("Code_ClassCodeBriefDescription","Code") |
Code_ClassCodeDescription |
Gets the classification code description for the code entered as a parameter. Used in the basic invoice. |
TIMEINFO("Code_ClassCodeDescription","Code") |
Code_WorkCodeBriefDescription |
Gets the work code short description for the code entered as a parameter. |
TIMEINFO("Code_WorkCodeBriefDescription","Code") |
Code_WorkCodeDescription |
Gets the work code description for the code entered as a parameter. Used in the basic invoice. |
TIMEINFO("Code_WorkCodeDescription","Code") |
GL_Amount |
Gets the invoice amount without taxes. Range covers N/A to proposed invoices. |
TIMEINFO("GL_Amount") |
GL_PrimTaxAmount |
Gets the invoice primary tax amount. Range covers N/A to proposed invoices. |
TIMEINFO("GL_PrimTaxAmount") |
GL_SecTaxAmount |
Gets the invoice secondary tax amount. Range covers N/A to proposed invoices. |
TIMEINFO("GL_SecTaxAmount") |
InCharges_StaffNo |
Gets the project/subproject in charge staff number. |
TIMEINFO("InCharges_StaffNo") |
Project_ProjectDescription |
Gets the project description for the current project code. |
TIMEINFO("Project_ProjectDescription") |
Project_ProjectNo |
Gets the project number for the current project code. |
TIMEINFO("Project_ProjectNo") |
RC_Amount |
Gets the invoice amount with taxes. Range covers N/A to proposed invoices. |
TIMEINFO("RC_Amount") |
RC_Date |
Gets the invoice date. |
TIMEINFO("RC_Date") |
RC_ReferenceNo |
Gets the invoice number. |
TIMEINFO("RC_ReferenceNo") |
RC_Source |
Gets the invoice source. Returns WP for Final and Interim WIP invoices and is blank for Miscellaneous invoices, Proposed invoices and Credit Notes. |
TIMEINFO("RC_Source") |
Subproject_SubprojectDescription |
Gets the subproject description for the invoice. |
TIMEINFO("Subproject_SubprojectDescription") |
Subproject_SubprojectNo |
Gets the subproject number for the invoice. |
TIMEINFO("Subproject_SubprojectNo") |
TeamLeaders_StaffNo |
Gets the project/subproject team leader. |
TIMEINFO("TeamLeaders_StaffNo") |
WIP_Amount |
Gets the invoice amount without taxes. |
TIMEINFO("WIP_Amount") |
WIP_BilledToInvoiceNo |
Gets final invoice number to which was billed WIP invoice (Interim invoices only) |
TIMEINFO("WIP_BilledToInvoiceNo") |
WIP_Date |
Gets the invoice date. |
TIMEINFO("WIP_Date") |
WIP_ExpensesSubtotal |
Gets the final invoice expenses subtotal. |
TIMEINFO("WIP_ExpensesSubtotal") |
WIP_InterimBillingAmount |
Gets the final invoice interim billing amount. |
TIMEINFO("WIP_InterimBillingAmount") |
WIP_Memo |
Gets the invoice memo. |
TIMEINFO("WIP_Memo") |
WIP_PrimTaxAmount |
Gets the invoice primary tax amount. |
TIMEINFO("WIP_PrimTaxAmount") |
WIP_ReferenceNo |
Gets the invoice reference number. |
TIMEINFO("WIP_ReferenceNo") |
WIP_SecTaxAmount |
Gets the invoice secondary tax amount. |
TIMEINFO("WIP_SecTaxAmount") |
WIP_TimeSubtotal |
Gets the final invoice time subtotal. |
TIMEINFO("WIP_TimeSubtotal") |
WIP_Type |
Gets the invoice type. Returns: |
TIMEINFO("WIP_Type") |
WIP_UseAFP |
Gets whether or not the invoice uses AFP (Application For Payment). Returns: |
TIMEINFO("WIP_UseAFP") |
WIP_WriteUpDownAmount |
Get the Billing from WIP Final invoice write up/down amount. |
TIMEINFO("WIP_WriteUpDownAmount") |
|
|
|
|
|
|
BillingCode_BillingCodeDescription |
Gets the description of the billing code applied to the credit note. |
TIMEINFO("BillingCode_BillingCodeDescription") |
BillingCode_BillingCodeExDescription |
Gets the extended description of the billing code applied to the credit note. |
TIMEINFO("BillingCode_BillingCodeExDescription") |
BillingCode_BillingCodeNo |
Gets the billing code number of the code applied to the credit note. |
TIMEINFO("BillingCode_BillingCodeNo") |
Client_AddressTypeOnCreditNotes |
Gets the type of address used on credit notes. Returns: |
TIMEINFO("Client_AddressTypeOnCreditNotes") |
Code_BillingCodeBriefDescription |
Gets the billing code short description for the code entered as a parameter. |
TIMEINFO("Code_BillingCodeBriefDescription","Code") |
Code_BillingCodeDescription |
Gets the billing code description for the code entered as a parameter. |
TIMEINFO("Code_BillingCodeDescription","Code") |
Code_ClassCodeBriefDescription |
Gets the classification code short description for the code entered as a parameter. |
TIMEINFO("Code_ClassCodeBriefDescription","Code") |
Code_ClassCodeDescription |
Gets the classification code description for the code entered as a parameter. |
TIMEINFO("Code_ClassCodeDescription","Code") |
Code_WorkCodeBriefDescription |
Gets the work code short description for the code entered as a parameter. |
TIMEINFO("Code_WorkCodeBriefDescription","Code") |
Code_WorkCodeDescription |
Gets the work code description for the code entered as a parameter. |
TIMEINFO("Code_WorkCodeDescription","Code") |
GL_Amount |
Gets the credit note amount without taxes. |
TIMEINFO("GL_Amount") |
GL_PrimTaxAmount |
Gets the credit note primary tax amount. |
TIMEINFO("GL_PrimTaxAmount") |
GL_SecTaxAmount |
Gets the credit note secondary tax amount. |
TIMEINFO("GL_SecTaxAmount") |
InCharges_StaffNo |
Gets the project/subproject in charge staff number. |
TIMEINFO("InCharges_StaffNo") |
Group_AddressTypeOnCreditNotes |
Gets the type of address used on credit notes. Returns: |
TIMEINFO("Group_AddressTypeOnCreditNotes") |
Project_ProjectDescription |
Gets the project description for the current project code. |
TIMEINFO("Project_ProjectDescription") |
Project_ProjectNo |
Gets the project number for the current project code. |
TIMEINFO("Project_ProjectNo") |
RC_Amount |
Gets the credit note amount with taxes. |
TIMEINFO("RC_Amount") |
RC_CreditNote |
Gets whether or not this is a credit note. Returns: |
TIMEINFO("RC_CreditNote") |
RC_Date |
Gets the credit note date. |
TIMEINFO("RC_Date") |
RC_Memo |
Gets the credit note memo. |
TIMEINFO("RC_Memo") |
RC_Reference |
Gets the credit note reference. |
TIMEINFO("RC_Reference") |
RC_ReferenceNo |
Gets the credit note reference number. |
TIMEINFO("RC_ReferenceNo") |
RC_UseAFP |
Gets whether or not this credit note uses AFP (Application For Payment). Returns: |
TIMEINFO("RC_UseAFP") |
Subproject_SubprojectDescription |
Gets the subproject description for the credit note. |
TIMEINFO("Subproject_SubprojectDescription") |
Subproject_SubprojectNo |
Gets the subproject number for the credit note. |
TIMEINFO("Subproject_SubprojectNo") |
TeamLeaders_StaffNo |
Gets the project/subproject team leader. |
TIMEINFO("TeamLeaders_StaffNo") |
|
|
|
|
|
|
BillingCode_BillingCodeDescription |
Gets the description of the billing code applied to the invoice. |
TIMEINFO("BillingCode_BillingCodeDescription") |
BillingCode_BillingCodeExDescription |
Gets the extended description of the billing code applied to the invoice. |
TIMEINFO("BillingCode_BillingCodeExDescription") |
BillingCode_BillingCodeNo |
Gets the billing code number of the code applied to the invoice. |
TIMEINFO("BillingCode_BillingCodeNo") |
Client_AddressTypeOnInvoices |
Gets the type of address used on invoices. Returns: |
TIMEINFO("Client_AddressTypeOnInvoices") |
Code_BillingCodeBriefDescription |
Gets the billing code short description for the code entered as a parameter. |
TIMEINFO("Code_BillingCodeBriefDescription","Code") |
Code_BillingCodeDescription |
Gets the billing code description for the code entered as a parameter. |
TIMEINFO("Code_BillingCodeDescription","Code") |
Code_ClassCodeBriefDescription |
Gets the classification code short description for the code entered as a parameter. |
TIMEINFO("Code_ClassCodeBriefDescription","Code") |
Code_ClassCodeDescription |
Gets the classification code description for the code entered as a parameter. |
TIMEINFO("Code_ClassCodeDescription","Code") |
Code_WorkCodeBriefDescription |
Gets the work code short description for the code entered as a parameter. |
TIMEINFO("Code_WorkCodeBriefDescription","Code") |
Code_WorkCodeDescription |
Gets the work code description for the code entered as a parameter. |
TIMEINFO("Code_WorkCodeDescription","Code") |
GL_Amount |
Gets the invoice amount without taxes. Range covers N/A to proposed invoices. |
TIMEINFO("GL_Amount") |
GL_PrimTaxAmount |
Gets the invoice primary tax amount. Range covers N/A to proposed invoices. |
TIMEINFO("GL_PrimTaxAmount") |
GL_SecTaxAmount |
Gets the invoice secondary tax amount. Range covers N/A to proposed invoices. |
TIMEINFO("GL_SecTaxAmount") |
InCharges_StaffNo |
Gets the project/subproject in charge staff number. |
TIMEINFO("InCharges_StaffNo") |
Project_ProjectDescription |
Gets the project description for the current project code. |
TIMEINFO("Project_ProjectDescription") |
Project_ProjectNo |
Gets the project number for the current project code. |
TIMEINFO("Project_ProjectNo") |
RC_Amount |
Gets the invoice amount with taxes. |
TIMEINFO("RC_Amount") |
RC_Date |
Gets the invoice date. |
TIMEINFO("RC_Date") |
RC_Memo |
Gets the invoice memo. |
TIMEINFO("RC_Memo") |
RC_Miscellaneous |
Gets whether or not this is a miscellaneous invoice. Returns: |
TIMEINFO("RC_Miscellaneous") |
RC_Reference |
Gets the invoice reference. |
TIMEINFO("RC_Reference") |
RC_ReferenceNo |
Gets the invoice reference number. |
TIMEINFO("RC_ReferenceNo") |
RC_UseAFP |
Gets whether or not this invoice uses AFP (Application For Payment). Returns: |
TIMEINFO("RC_UseAFP") |
Subproject_SubprojectDescription |
Gets the subproject description for the invoice. |
TIMEINFO("Subproject_SubprojectDescription") |
Subproject_SubprojectNo |
Gets the subproject number for the invoice. |
TIMEINFO("Subproject_SubprojectNo") |
TeamLeaders_StaffNo |
Gets the project/subproject team leader. |
TIMEINFO("TeamLeaders_StaffNo") |
|
|
|
|
|
|
Client_AddressTypeOnStatements |
Gets the type of address used on statements. Returns: |
TIMEINFO("Client_AddressTypeOnStatements") |
Statement_AgingTitle120_150 |
Gets the title used in statements for the 120-150 day column. |
TIMEINFO("Statement_AgingTitle120_150") |
Statement_AgingTitle150_180 |
Gets the title used in statements for the 150-180 day column. |
TIMEINFO("Statement_AgingTitle150_180") |
Statement_AgingTitle30_60 |
Gets the title used in statements for the 30-60 day column. |
TIMEINFO("Statement_AgingTitle30_60") |
Statement_AgingTitle60_90 |
Gets the title used in statements for the 60-90 day column. |
TIMEINFO("Statement_AgingTitle60_90") |
Statement_AgingTitle90_120 |
Gets the title used in statements for the 90-120 day column. |
TIMEINFO("Statement_AgingTitle90_120") |
Statement_AgingTitleCurrent |
Gets the title used in statements for the current column. |
TIMEINFO("Statement_AgingTitleCurrent") |
Statement_AgingTitleOver120 |
Gets the title used in statements for the over 120 day column. |
TIMEINFO("Statement_AgingTitleOver120") |
Statement_AgingTitleOver150 |
Gets the title used in statements for the over 150 day column. |
TIMEINFO("Statement_AgingTitleOver150") |
Statement_AgingTitleOver180 |
Gets the title used in statements for the over 180 day column. |
TIMEINFO("Statement_AgingTitleOver180") |
Statement_AgingTitleOver90 |
Gets the title used in statements for the over 90 day column. |
TIMEINFO("Statement_AgingTitleOver90") |
Statement_DateFrom |
Gets statement From date. |
TIMEINFO("Statement_DateFrom") |
Statement_DateTo |
Gets statement To date. |
TIMEINFO("Statement_DateTo") |
Statement_Detailed |
Gets whether or not the statement is detailed. Returns: |
TIMEINFO("Statement_Detailed") |
Statement_HasStatements |
Gets whether or not the group statement has client statements. Returns: |
TIMEINFO("Statement_HasStatements") |
Statement_NumberAgingColumns |
Gets the number of aging columns for the statement. |
TIMEINFO("Statement_NumberAgingColumns") |
Statement_WithMemos |
Gets whether or not the statement has memos. Returns: |
TIMEINFO("Statement_WithMemos") |
|
|
|
|
|
|
BillingCode_BillingCodeDescription |
Gets the description of the billing code applied to the invoice. |
TIMEINFO("BillingCode_BillingCodeDescription") |
BillingCode_BillingCodeExDescription |
Gets the extended description of the billing code applied to the invoice. |
TIMEINFO("BillingCode_BillingCodeExDescription") |
BillingCode_BillingCodeNo |
Gets the billing code number of the code applied to the invoice. |
TIMEINFO("BillingCode_BillingCodeNo") |
Client_AddressTypeOnInvoices |
Gets the type of address used on invoices. Returns: |
TIMEINFO("Client_AddressTypeOnInvoices") |
Code_BillingCodeBriefDescription |
Gets the billing code short description for the code entered as a parameter. |
TIMEINFO("Code_BillingCodeBriefDescription","Code") |
Code_BillingCodeDescription |
Gets the billing code description for the code entered as a parameter. |
TIMEINFO("Code_BillingCodeDescription","Code") |
Code_ClassCodeBriefDescription |
Gets the classification code short description for the code entered as a parameter. |
TIMEINFO("Code_ClassCodeBriefDescription","Code") |
Code_ClassCodeDescription |
Gets the classification code description for the code entered as a parameter. |
TIMEINFO("Code_ClassCodeDescription","Code") |
Code_WorkCodeBriefDescription |
Gets the work code short description for the code entered as a parameter. |
TIMEINFO("Code_WorkCodeBriefDescription","Code") |
Code_WorkCodeDescription |
Gets the work code description for the code entered as a parameter. |
TIMEINFO("Code_WorkCodeDescription","Code") |
GL_Amount |
Gets the invoice amount without taxes. Range covers N/A to proposed invoices. |
TIMEINFO("GL_Amount") |
GL_PrimTaxAmount |
Gets the invoice primary tax amount. Range covers N/A to proposed invoices. |
TIMEINFO("GL_PrimTaxAmount") |
GL_SecTaxAmount |
Gets the invoice secondary tax amount. Range covers N/A to proposed invoices. |
TIMEINFO("GL_SecTaxAmount") |
InCharges_StaffNo |
Gets the project/subproject in charge staff number. |
TIMEINFO("InCharges_StaffNo") |
RC_AFPNo |
Gets the AFP (Application For Payment) number. |
TIMEINFO("RC_AFPNo") |
RC_Amount |
Gets the invoice amount with taxes. |
TIMEINFO("RC_Amount") |
RC_Date |
Gets the invoice date. |
TIMEINFO("RC_Date") |
RC_Memo |
Gets the invoice memo. |
TIMEINFO("RC_Memo") |
RC_ReferenceNo |
Gets the invoice reference number. |
TIMEINFO("RC_ReferenceNo") |
RC_TaxInvoice |
Gets whether or not this is a tax invoice. Returns: |
TIMEINFO("RC_TaxInvoice") |
RC_UseAFP |
Gets whether or not this invoice uses AFP (Application For Payment). Returns: |
TIMEINFO("RC_UseAFP") |
Subproject_SubprojectNo |
Gets the subproject number for the invoice. |
TIMEINFO("Subproject_SubprojectNo") |