Versions Compared

Old Version 6

changes.mady.by.user Fran Mico

Saved on

compared with

New Version Current

changes.mady.by.user Richard Turnbull

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

DocList_Finance_ApexEnrol_EstimateUnposted_ProformaSaleCre

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

AnchorDoc_Apex_Estimate_ProformaDoc_Apex_Estimate_ProformaDoc_Apex_Estimate_ProformaImage Removed