Doc Apex Tables

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