Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

  • A range of tables have been built in Schoolworks to pull through tables of data that you may find helpful to display on your documents. Different to regular mergefields, they can create create rows of data for each record in the desired object.

  • A common example of this is on a proforma or invoice document, where it is desirable to show a summary table of all the bookings a student has made.

Doc Apex Table Before Merge:

Doc Apex Table After Merge:

  • The name of the table must be on the line directly above the table, and the table must have a header row. The resulting rows are added under the header row.

  • They can be used on documents looking at all areas of the system, but typically are used in the Bookings, Enrolments and Document Finance Header data groups.

  • There are a number of these tables and all have different fields that are available to display.

    • Below is a list of all available together with a summary of their use and the fields available:

Doc Apex Table Name

Doc Apex Table New Name

Summary

Fields available

Doc_Apex_Accommodation_Fee

Please contact Support for further details.

Doc_Apex_Accomm_Account_Pref

Please contact Support for further details.

Doc_Apex_Account_Bank_Details

Please contact Support for further details.

Doc_Apex_Account_Statement

Please contact Support for further details.

Doc_Apex_Account_StatementTest

Please contact Support for further details.

Doc_Apex_Account_Statement_UnAllocated

Please contact Support for further details.

Doc_Apex_Account_Statement_UnallocatedTe

Please contact Support for further details.

Doc_Apex_AgentGross_Credit

Please contact Support for further details.

Doc_Apex_AgentNet_Invoice

Please contact Support for further details.

Doc_Apex_Agent_Pro_Forma

Please contact Support for further details.

Doc_Apex_Booking_Specific_Course

Please contact Support for further details.

Doc_Apex_Course_Accomm_Fees_FeesPaid

Please contact Support for further details.

Doc_Apex_Enrolconf_Accom

Lists all Accommodation Bookings made on the Enrolment.

Doc_Apex_Enrolconf_Course

Lists all Course Bookings made on the Enrolment.

Doc_Apex_Enrolconf_Holiday

Lists all Holidays entered on the Enrolment.

Doc_Apex_Enrolconf_IT

Lists all Individual Tuition Bookings made on the Enrolment.

Doc_Apex_Enrolconf_Xfer

Lists all Transfer Bookings made on the Enrolment.

Student Account Name: {!studentName}
Student Account ID: {!studentId}
Transfer Type: {!type}
Transfer Date: {!date}
Trasnfer Time: {!time}
Flight Number: {!flightNumber}
Flight Time: {!flightTime}
Carrier: {!carrierName}
Name: {!name}
Code: {!code}
DepFrom: {!depFrom}
TravTo: {!travTo}
Location: {!location}
Supplier: {!supplier}
PriceItem Name: {!priceItemName}
PriceItem Code: {!priceItemCode}

Doc_Apex_Enrolment_Bookings

Lists all Bookings made on the Enrolment.

Doc_Apex_Finance_Account_Balance

Please contact Support for further details.

Doc_Apex_Finance_Account_BalanceTest

Please contact Support for further details.

Doc_Apex_Finance_Enrolment_Balance

Please contact Support for further details.

Doc_Apex_Finance_Header

Please contact Support for further details.

Doc_Apex_Finance_HeaderTest

Please contact Support for further details.

Doc_Apex_Finance_Ref_Account_Statement

Please contact Support for further details.

Doc_Apex_Finance_Ref_Stu

Please contact Support for further details.

Doc_Apex_Group_Arrival_Transfer

Please contact Support for further details.

Doc_Apex_Group_Departure_Transfer

Please contact Support for further details.

Doc_Apex_Group_Enrolment_Accommodation

Please contact Support for further details.

Doc_Apex_Group_Enrolment_Students

Please contact Support for further details.

Doc_Apex_Multi_Currency_Totals

Please contact Support for further details.

Doc_Apex_Student_Accomm

Please contact Support for further details.

Doc_Apex_Student_Current_Classes

Please contact Support for further details.

Doc_Apex_Student_Invoice

Please contact Support for further details.

Doc_Apex_Student_Pro_Forma

Please contact Support for further details.

Doc_Apex_Student_Receipt

Please contact Support for further details.

Doc_Apex_Student_Receipt_Detail

Please contact Support for further details.

Doc_Apex_Student_Starting_Next_Week

Please contact Support for further details.

Doc_Apex_Student_Starting_Next_WeekTest

Please contact Support for further details.

Doc_Apex_Student_Timetables

Please contact Support for further details.

Doc_Apex_Student_Weekly_Classes

Please contact Support for further details.

Doc_Apex_Tables_Test

Please contact Support for further details.

Doc_Apex_Text_Forward_Booking

Please contact Support for further details.

Doc_Apex_Estimate_Proforma

N/A

Returns a list of non deleted Sale/CreSale journals.

All API field names (standard, custom and lookup relationships) from Finance_Journal__c or Finance_Journal_Temp__c.

Document Templates Examples

Doc_Apex_Estimate_Proforma

  • No labels

Can’t find what you need?
  • Try searching for keywords at the top of the screen, or browse the full wiki contents in the left-hand panel.
  • If you need further support, please login to your Service Desk account and raise a support ticket here or email full details to support@schoolworks.co.uk.
  • Full details of Schoolworks Support Best Practice and Process can be found here.