Doc Apex Tables

Owned by Richard Turnbull
Last updated: Apr 29, 2024
3 min read

  • 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 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.

 

List_Finance_Enrol_Unposted_SaleCre

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.

 

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.