Output Data Pipelines

💡These lists show the Data Pipelines that output templates can use. A Data Pipeline is a set of data, for example, a Quotation's header details or its lines. In the Form Designer, the pipelines are the data tables in the Data Tree, and you drag their fields onto the template (see How to Add a Field to a Template).

Info

Only the pipelines of the module you output from are available. For example, a Quotation template can use the Quotation pipelines, but not the Customer Invoice pipelines.
Click Fields under a pipeline to see its field names, as the Data Tree shows them, in alphabetical order.
The lists are from the latest version of BOS Professional (26.05). Older versions can have fewer fields.

Customers and Suppliers

Customers

The following Data Pipelines can be used on Customer output templates.

Cus_All: All the customers on the list, with their category, Credit Terms and main contact.
Fields (71)
ACCNO, ACCOUNTSCONTACT, ACCOUNTSCONTACTID, ADJPERCENT, APPROVEDLIMIT, CATEGORY, CATID, CIACCESSID, COMPANY, COMPERCENT, COMTYPEID, CPNACCESSID, CRAPDATE, CREDITTERMID, CURRENCY, CURRENCYID, CUSID, CUS_PASSWORD, CUS_USERNAME, DATECREATED, DATEUPDATED, DELADDRESS, DEPOSITPERCENT, DISCOUNT, DNACCESSID, DUE, EMAIL, EXPIRYDATE, E_BILLING_CATEGORY, E_DUNS_NO, E_SEPA_CREDITOR, E_TAX_EXCEPTION, E_TIN_NO, FAX, INDUSTRYID, ITEM_ADJPERCENT, LICENSENO, LINKEDATTACHID, NOTE, POSTADDRESS, PRICELISTID, QTACCESSID, REGIONID, REGISTEREDNAME, REGNO, REP, REPCELL, REPLISTNAME, SECUREDLIMIT, SOACCESSID, STAFFID, STATEMENTCONTACT, STATEMENTCONTACTID, STATUS, SYSADDRESS, TAX_ISSUE_DATE, TAX_REG_DATE, TAX_TRN_NO, TEL, TERMS, TRADE_EXPIRY_DATE, TRADE_ISSUE_DATE, TRADE_LICENSE_NO, TRADE_LICENSING_AUT, USERCREATED, USERUPDATED, VATNO, VATTYPEID, VENDORNO, WARNING, WOACCESSID
Cus_Rec: The selected customer.
Fields (71)
ACCNO, ACCOUNTSCONTACT, ACCOUNTSCONTACTID, ADJPERCENT, APPROVEDLIMIT, CATEGORY, CATID, CIACCESSID, COMPANY, COMPERCENT, COMTYPEID, CPNACCESSID, CRAPDATE, CREDITTERMID, CURRENCY, CURRENCYID, CUSID, CUS_PASSWORD, CUS_USERNAME, DATECREATED, DATEUPDATED, DELADDRESS, DEPOSITPERCENT, DISCOUNT, DNACCESSID, DUE, EMAIL, EXPIRYDATE, E_BILLING_CATEGORY, E_DUNS_NO, E_SEPA_CREDITOR, E_TAX_EXCEPTION, E_TIN_NO, FAX, INDUSTRYID, ITEM_ADJPERCENT, LICENSENO, LINKEDATTACHID, NOTE, POSTADDRESS, PRICELISTID, QTACCESSID, REGIONID, REGISTEREDNAME, REGNO, REP, REPCELL, REPLISTNAME, SECUREDLIMIT, SOACCESSID, STAFFID, STATEMENTCONTACT, STATEMENTCONTACTID, STATUS, SYSADDRESS, TAX_ISSUE_DATE, TAX_REG_DATE, TAX_TRN_NO, TEL, TERMS, TRADE_EXPIRY_DATE, TRADE_ISSUE_DATE, TRADE_LICENSE_NO, TRADE_LICENSING_AUT, USERCREATED, USERUPDATED, VATNO, VATTYPEID, VENDORNO, WARNING, WOACCESSID
Cus_Contacts_All: All the customer's contacts, with their positions.
Fields (21)
CEL, CUSCONTACTID, CUSMAINID, EMAIL, FAX, FNAME, FOLLOWUPDATE, GROUP1, GROUP2, GROUP3, IMAGE, JOBPOSITION, LISTNAME, NEXTBIRTHDAY, NOTE, POSITIONID, SMS, SNAME, STATUSID, TEL, TITLE
Cus_Contacts_Rec: The selected contact.
Fields (21)
CEL, CUSCONTACTID, CUSMAINID, EMAIL, FAX, FNAME, FOLLOWUPDATE, GROUP1, GROUP2, GROUP3, IMAGE, JOBPOSITION, LISTNAME, NEXTBIRTHDAY, NOTE, POSITIONID, SMS, SNAME, STATUSID, TEL, TITLE
Cus_Addresses: The customer's addresses.
Fields (11)
ADDRESS, ADDRESSID, AREACODE, CITY, COUNTRY, CUSID, ISDEFAULTID, LINE1, LINE2, LOOKUP, STATE

Suppliers

The following Data Pipelines can be used on Supplier output templates.

Sup_All: All the suppliers on the list, with their category, Credit Terms and main contact.
Fields (40)
ACCNO, ACCOUNTSCONTACT, ACCOUNTSCONTACTID, BANKACCNO, BANKBRANCH, BANKNAME, BANKSWIFT, CATEGORY, CATID, COMPANY, CREDITLIMIT, CREDITTERMID, CREDITTERMS, CURRENCY, CURRENCYID, DATECREATED, DATEUPDATED, DELADDRESS, DISCOUNTPERCENT, EMAIL, FAX, ISACTIVE, LINKEDATTACHID, POSTADDRESS, PWORD, REGNO, STAGEID, STATUS, SUPACCNO, SUPID, TEL, TOTAL, TRADPARTID, USERCREATED, USERNAME, USERUPDATED, VATNO, VATTYPEID, WARNING, WEBSITE
Sup_Rec: The selected supplier.
Fields (40)
ACCNO, ACCOUNTSCONTACT, ACCOUNTSCONTACTID, BANKACCNO, BANKBRANCH, BANKNAME, BANKSWIFT, CATEGORY, CATID, COMPANY, CREDITLIMIT, CREDITTERMID, CREDITTERMS, CURRENCY, CURRENCYID, DATECREATED, DATEUPDATED, DELADDRESS, DISCOUNTPERCENT, EMAIL, FAX, ISACTIVE, LINKEDATTACHID, POSTADDRESS, PWORD, REGNO, STAGEID, STATUS, SUPACCNO, SUPID, TEL, TOTAL, TRADPARTID, USERCREATED, USERNAME, USERUPDATED, VATNO, VATTYPEID, WARNING, WEBSITE
Sup_Contacts: The supplier's contacts, with their positions.
Fields (17)
CEL, EMAIL, FAX, FNAME, FOLLOWUPDATE, IMAGE, JOBPOSITION, LISTNAME, NEXTBIRTHDAY, NOTE, POSITIONID, SMS, SNAME, SUPCONTACTID, SUPID, TEL, TITLE

Quotations and Estimates

Quotations

The following Data Pipelines can be used on Quotation output templates.

Qt_Rec: The selected Quotation's header fields, including the customer's Reg. No. as CUSREGNO.
Fields (70)
ACCNO, BASEVALUE, BASEVALUE_OLD, BRANCHID, CATEGORYID, CEL, CHECKLISTID, CONTACT, CONTACTFAX, CONTACTTEL, CONTACTTITLE, CURRENCYID, CUSCAT, CUSCATID, CUSCONTACTID, CUSFAX, CUSID, CUSREGNO, CUSSTATUS, CUSTEL, CUSTOMER, CUSVENDORNO, DATEUPDATED, DELADDRESS, DELIVERYID, DEPOSIT, DEPOSITPERCENT, EMAIL, ENQID, FLOWIDS, FNAME, FROMENQID, FROMQUOTEID, JOBCATEGORY, NOTE, POSTADDRESS, PRICELISTID, QUOTEBY, QUOTEDATE, QUOTEID, QUOTEKEY, QUOTEVERNO, RECURRINGID, REF1, REF2, REF3, REGISTEREDNAME, REPCELL, REPEMAIL, REPLISTNAME, REPSHORTNAME, REPSIGNATURE, SMS, SODATE, STAFFIDASSIGN, STAFFIDQUOTE, STAFFIDREP, STATUSID, TICKETID, TOTAL, TOTAL3, TOTALCURRENCY, TOTALVAT, TOTALVAT3, USERUPDATED, VATAMT, VATAMT3, VATNO, VATPERCENT, VATTYPEID
Qt_All: All the Quotations on the list.
Fields (71)
APPROVAL, APPROVEID, BASEVALUE, BASEVALUE_OLD, BRANCH, BRANCHCODE, BRANCHID, CATEGORYID, CGSTAMT, CHECKLISTID, CONTACT, CURRENCY, CURRENCYID, CUSCAT, CUSCONTACTID, CUSID, CUSREGNO, CUSTOMER, CUSVENDORNO, DATEUPDATED, DELIVERY, DELIVERYID, DEPOSIT, DEPOSITPERCENT, ENQID, FLOWIDS, FROMENQID, FROMQUOTE, FROMQUOTEID, GROUPID, IGSTAMT, JOBCATEGORY, LINKEDATTACHID, LINKSOID, LINKWOID, NOTE, ORDERID, PRICELISTID, QUOTEBY, QUOTEDATE, QUOTEID, QUOTEKEY, QUOTEVERNO, RECURRINGID, REF1, REF2, REF3, REGIONID, REGISTEREDNAME, REPSHORTNAME, REPSIGNATURE, SGSTAMT, SODATE, STAFFIDASSIGN, STAFFIDQUOTE, STAFFIDREP, STATUS, STATUSID, TICKETID, TOTAL, TOTAL3, TOTALCURRENCY, TOTALVAT, TOTALVAT3, TOTALVAT3_TEXT, TOTALVAT_TEXT, USERUPDATED, VATAMT, VATAMT3, VATPERCENT, WORKFLOWID
Qt_Items: The Quotation's lines, including the line Category as CATEGORY_QTITEM.
Fields (75)
ACCOUNTID, ADJPERCENT, ADJTYPEID, ADJUSTID, ADJUSTMENT, CATEGORY, CATEGORYID, CATEGORY_QTITEM, CCENTREID, CGSTAMT, CGSTPERCENT, CODE, DESCRIPTION, DIRECTCOST, ENQID, FIXEDCOST, FIXEDSELL, FLOWIDS, GROUPNAME, HEADER, IGSTAMT, IGSTPERCENT, IMAGE, IMAGEID, INEXID, INSTRUCTION, MARGIN, MATCATID, MATCOSTID, MATUNITID, MRTIME, NOTE, NUMBEREND, NUMBERPREFIX, NUMBERSETS, NUMBERSTART, NUMBERTOVIEW, OLD_QUOTEITEMID, ORDERID, PAGECOUNT, PRICEQTY, PROCESSID, PROFIT, QTY, QUOTEID, QUOTEITEMID, ROUNDOFFID, SGSTAMT, SGSTPERCENT, SIZEDESC, SPECIFICATION, SPEED, SPEEDQTY, STATUSID, SUBCATEGORY, SUPID, SUPPLIER, TOTAL, TOTAL1000, TOTAL3, TOTALCOST, TOTALCURRENCY, TOTALHRS, TOTALUNIT, TOTALVAT, TOTALVAT3, TYPEID, UNIT, UNITCOST, UNITID, UNITSELL, VATAMT, VATAMT3, VATPERCENT, VATTYPEID
Qt_Item_Rec: The selected Quotation line. Its SPECIFICATION field holds the estimate description.
Fields (75)
ACCOUNTID, ADJPERCENT, ADJTYPEID, ADJUSTID, ADJUSTMENT, CATEGORY, CATEGORYID, CATEGORY_QTITEM, CCENTREID, CGSTAMT, CGSTPERCENT, CODE, DESCRIPTION, DIRECTCOST, ENQID, FIXEDCOST, FIXEDSELL, FLOWIDS, GROUPNAME, HEADER, IGSTAMT, IGSTPERCENT, IMAGE, IMAGEID, INEXID, INSTRUCTION, MARGIN, MATCATID, MATCOSTID, MATUNITID, MRTIME, NOTE, NUMBEREND, NUMBERPREFIX, NUMBERSETS, NUMBERSTART, NUMBERTOVIEW, OLD_QUOTEITEMID, ORDERID, PAGECOUNT, PRICEQTY, PROCESSID, PROFIT, QTY, QUOTEID, QUOTEITEMID, ROUNDOFFID, SGSTAMT, SGSTPERCENT, SIZEDESC, SPECIFICATION, SPEED, SPEEDQTY, STATUSID, SUBCATEGORY, SUPID, SUPPLIER, TOTAL, TOTAL1000, TOTAL3, TOTALCOST, TOTALCURRENCY, TOTALHRS, TOTALUNIT, TOTALVAT, TOTALVAT3, TYPEID, UNIT, UNITCOST, UNITID, UNITSELL, VATAMT, VATAMT3, VATPERCENT, VATTYPEID
Qt_All_Items: All the Quotation lines in the Items view.
Fields (57)
ADJPERCENT, ADJTYPEID, ADJUSTMENT, CATEGORY, CATEGORYID, CATEGORYITEM, CGSTAMT, CODE, CUSCATEGORY, CUSTOMER, CUSUSERCREATED, DELIVERY, DESCRIPTION, DIRECTCOST, ENQID, ESTPRODUCT, GROUPNAME, IGSTAMT, INEXID, LINKSOID, LINKWOID, MARGIN, MATCATEGORY, ORDERID, PROFIT, QTY, QUOTEDATE, QUOTEID, QUOTEITEMID, QUOTE_TOTAL, QUOTE_TOTALVAT, QUOTE_VATAMT, REF1, REF2, REF3, REGIONID, REP, SGSTAMT, SIZEDESC, STATUSID, STATUSID_ITEM, SUBCATEGORY, TOTAL, TOTAL1000, TOTAL3, TOTALCOST, TOTALUNIT, TOTALVAT, TOTALVAT3, TYPEID, UNIT, USERCREATED, VATAMT, VATAMT3, VATPERCENT, VATTYPEID, WORKFLOWID
Qt_Items_Images: The images of the Quotation lines' materials.
Fields (2)
DESCRIPTION, IMAGE
Qt_Qty_Price: The quantities and prices of the Quotation's lines.
Fields (27)
ADJPERCENT, ADJUSTMENT, COMMISSION, COMPERCENT, COMTYPEID, FIXID, ITEM_ADJPERCENT, ITEM_ADJUSTMENT, ITEM_TOTAL, ITEM_TOTALUNIT, ITEM_TOTALVAT, ITEM_VATAMT, QTY, QUOTEITEMID, QUOTEQTYID, STATUSID, SUBTOTAL, SUBTOTALUNIT, SUBTOTAL_ADJUSTED, TOTAL, TOTAL1000, TOTALUNIT, TOTALVAT, TOTALVAT3, VATAMT, VATAMT3, VATPERCENT
Qt_Qty_Price_NoActive: The quantities and prices that are not active.
Fields (24)
ADJPERCENT, ADJUSTMENT, COMMISSION, COMPERCENT, COMTYPEID, FIXID, ITEM_ADJPERCENT, ITEM_ADJUSTMENT, ITEM_TOTAL, ITEM_TOTALUNIT, ITEM_TOTALVAT, ITEM_VATAMT, QTY, QUOTEQTYID, STATUSID, SUBTOTAL, SUBTOTALUNIT, SUBTOTAL_ADJUSTED, TOTAL, TOTAL1000, TOTALUNIT, TOTALVAT, VATAMT, VATPERCENT
Qt_Desc: The Quotation's description.
Fields (5)
CAPTION, NOTE, QUOTEDESCID, STATUSID, TYPEID
Qt_Note: The Quotation's note.
Fields (5)
CAPTION, NOTE, QUOTEDESCID, STATUSID, TYPEID
Qt_Desc_No_Note: The Quotation's description without the note.
Fields (5)
CAPTION, NOTE, QUOTEDESCID, STATUSID, TYPEID
Qt_Int_Note: The internal note.
Fields (6)
CAPTION, NOTE, QUOTEDESCID, QUOTEITEMID, STATUSID, TYPEID
Qt_Costs: The Quotation's cost lines (the Costs view).
Fields (21)
COMPANY, COSTPRICE, COSTTYPE, DESCRIPTION, ENQID, GROUPDESC, ID, ITEMNO, MARGIN, MATUNITID, PROFIT, QTY, QTYINSTOCK, QUOTEDATE, QUOTEID, RECORDID, SECTIONNAME, SELLPRICE, SERVICENAME, TOTALHRS, UNIT
QT_Cus_UDF: The customer's user-defined fields.
Qt_Approvals: The Quotation's checklist items (see Approvals).
Fields (6)
CHECKLISTTRANSID, CODE, DATEUPDATED, DESCRIPTION, NOTE, USERUPDATED

Note

On Qt_Qty_Price and Qt_Qty_Price_NoActive, these fields show the values after the item adjustment is applied, and are for output templates only: ITEM_ADJPERCENT, ITEM_ADJUSTMENT, ITEM_TOTAL, ITEM_VATAMT, ITEM_TOTALVAT and ITEM_TOTALUNIT.

Estimates

The following Data Pipelines show the estimates linked to Quotation lines (see Estimating).

Est_Qty_Price: All the prices linked to an estimate.
Fields (22)
ADJPERCENT, ADJUSTMENT, COMMISSION, COMPERCENT, COMTYPEID, FIXID, ID, ITEM_ADJPERCENT, ITEM_ADJUSTMENT, ITEM_TOTAL, ITEM_VATAMT, QTY, STATUSID, SUBTOTAL, SUBTOTAL_ADJUSTED, TOTAL, TOTAL1000, TOTALROLLUNIT, TOTALUNIT, TOTALVAT, VATAMT, VATPERCENT
Est_Qty_Price_NoActive: The prices linked to the estimate that are not active.
Fields (27)
ADJPERCENT, ADJUSTMENT, COMMISSION, COMPERCENT, COMTYPEID, FIXID, ID, ITEM_ADJPERCENT, ITEM_ADJUSTMENT, ITEM_MARGIN, ITEM_PROFIT, ITEM_TOTAL, ITEM_TOTALUNIT, ITEM_TOTALVAT, ITEM_VATAMT, QTY, STATUSID, SUBTOTAL, SUBTOTALUNIT, SUBTOTAL_ADJUSTED, TOTAL, TOTAL1000, TOTALROLLUNIT, TOTALUNIT, TOTALVAT, VATAMT, VATPERCENT
Qt_Est_Desc: The estimate description. You can also use the Qt_Item_Rec > SPECIFICATION field.
Fields (2)
CAPTION, NOTE
Qt_Est_Costing: The costing, sorted by Materials, Services and Outwork, then Part, then item.
Fields (30)
COMPITEMTYPE, COMPTYPE, CREASES, DEPTH, DESCRIPTION, DESC_FIXED, DESC_UNIT, DESC_UNIT_QTY, ESTCOSTID, FIXEDCOST, FIXEDHRS, FIXEDQTY, MINWASTEQTY, NOTE, PART, PROVIDER, QTY, TOTALCOST, TOTALHRS, TOTALPERCENT, TOTALQTY, TOTALWEIGHT, UNIT, UNITCOST, UNITHRS, UNITQTY, UNITWEIGHT, WASTEACTUALQTY, WASTEPERCENT, WIDTH
Qt_Est_All_Costs: The cost lines of all the estimates on the Quotation.
Fields (13)
COSTPRICE, COSTTYPE, DESCRIPTION, GROUPDESC, ID, ITEMNO, MARGIN, PROFIT, QTY, SECTIONNAME, SELLPRICE, TOTALHRS, UNIT
Qt_Summary: The Summary section of the estimate on a Quotation line: each row (for example, Ink, Printing, Finishing, O/Material, Total Cost, Adjustment, Commission, Total (Exc), VAT, Total (Inc), Direct Costs and Value Added) with its Amount and percentage.
Fields (4)
AMOUNT, DESCRIPTION, PERCENTAGE, TYPEID
Qt_Est_Sum: The estimate summary, in detail.
Fields (4)
AMOUNT, AMTPERCENT, CAPTION, TYPEID
Est_Int_Note: The estimate's internal notes (estimate templates).
Fields (5)
CAPTION, ESTDESCID, NOTE, ORDERID, QUOTEITEMID
Qt_PrePress: The pre-press lines of a Standard Estimate.
Fields (43)
ADJTYPEID, ADJUSTMENT, ADJUSTPERCENT, BRANCHID, CCENTREID, CCENTRENAME, COSTQTY, DESCRIPTION, DIRECTCOST, FIXEDEXTCOST, FIXEDEXTCOST_COST, INSTRUCTION, ISADJUST, ISDESC, MINCOST, MRTIME, ORDERID, PROCESSID, QTY, QTYTYPE, QTY_TYPEID, QUOTEITEMID, QUOTEREPROID, QUOTESECID, RATE, REPEATS, SECTIONNAME, SERVICE, SOURCE, SPEED, SPEEDQTY, SUBTOTAL, SUPID, SUPPLIERNAME, SUPREF, TOTAL, TOTALCOST, TOTALTIME, TOTINCVAT, TOTVAT, UNITEXTCOST, UNITEXTCOST_COST, VATPERCENT
Qt_Sections: The sections (parts) of a Standard Estimate, with their substrate and press.
Fields (136)
ADJUSTEDMATPRICE, ADJUSTID, ALLOWROTATEWSID, BASEQTY, BLEED, BWPAGES, CCENTREID, COSTBACK, COSTFRONT, CUSTOMQTYUP, DEPTH, DESCRIPTION, GRIPMARGIN, GUSSETACCROSS, GUSSETAROUND, IMAGECUTTING, IMAGEIMPO, INKCOST, INKDESCBACK, INKDESCFRONT, INKKG, INKTYPEID, INSTRUCTION, INSTRUCTIONPRINT, ISDESC, ISFRONTSAMEASBACK, ISOUTROTATED, ISROTATESECTION, ISWASHUP, KGBACK, KGFRONT, MATLISTPRICEQTY, MATPRICE, MATPRICEADJUSTPERCENT, MATPRICEID, MATUNITID, MAXPAPERDEPTH, MAXPAPERWIDTH, MINPAPERDEPTH, MINPAPERWIDTH, MRCOST, MROVERS, MROVERSPLATE, MROVERS_FIN, MRTIMEPASS, MRTIMESECTION, MRTIMESTATION, MRTIMETOTAL, ORDERID, OUTACROSS, OUTDOWN, OVERPRINTID, OVERRIDEIDOUT, OVERRIDEIDUP, OVERRIDEIDWS, PAGEACROSS, PAGEBLEED, PAGEDEPTH, PAGEDOWN, PAGEROTATEID, PAGESPINE, PAGEWIDTH, PAPCOLOURLU, PAPDESCLU, PAPERCATID, PAPERCOLOUR, PAPERDESCRIPTION, PAPERFIXEDQTY, PAPERNETTQTY, PAPERPRICEUNIT, PAPERQTY2, PAPERSIZE, PAPERTOTALCOST, PAPERTOTALQTY, PAPERTYPEID, PAPERUNIT, PAPERUNITID, PAPERWEIGHT, PAPGSMLU, PERCENTQUOTEQTY, PREPGROUP, PRESSDEFAULTID, PRESSDESCRIPTION, PRESSDIEDESCRIPTION, PRESSDIEID, PRESSID, PRESSOPTIONID, PRESSSUPID, PRINTTOTALCOST, PRINTTYPEID, QTYACROSS, QTYDOWN, QTYOUT, QTYPASSES, QTYSIGNATURES, QTYSTATIONS, QTYUP, QTY_TYPEID, QUOTEITEMID, QUOTESECID, RATE, REPEATS, ROTATEOUTID, RUNAREA, RUNCOST, RUNLENGTH, RUNOVERQTY, RUNOVERS, RUNOVERS_FIN, RUNSHEETS, RUNTIMETOTAL, RUNUNIT, RUNUNITID, SECTIONID, SHEETDEPTH, SHEETWIDTH, SIZETYPEID, SPEED, STATIONSBACK, STATIONSFRONT, SUPID, TAILMARGIN, TOTALCOST, TOTALTIME, TYPEID, UNITID, WASTEOUT, WIDTH, WIDTHMARGIN, WORKDEPTH, WORKSHEETS, WORKWIDTH, WUPCOST, WUPTIME, WUPTIMEPLATE, WUPTIMETOTAL
Qt_Finishing: The finishing lines of a Standard Estimate.
Fields (51)
ADJTYPEID, ADJUSTMENT, ADJUSTPERCENT, BRANCHID, CATEGORY, CCENTREID, CCENTRENAME, COSTQTY, DESCRIPTION, DIRECTCOST, FIXEDEXTCOST, FIXEDEXTCOST_COST, INSTRUCTION, ISADJUST, ISDESC, MINCOST, MROVERS_FIN, MRTIME, PROCESSID, QORDER, QTY, QTYFACTOR, QTYTYPE, QTYUP, QTY_TYPEID, QUOTEFINID, QUOTEITEMID, QUOTESECID, RATE, REPEATS, ROUNDUPQTY, RUNOVERS_FIN, SECTIONNAME, SERVICE, SOURCE, SPEED, SPEEDQTY, SUBTOTAL, SUPID, SUPPLIERNAME, SUPREF, TOTAL, TOTALCOST, TOTALTIME, TOTALUNIT, TOTINCVAT, TOTVAT, UNIT, UNITEXTCOST, UNITEXTCOST_COST, VATPERCENT
Qt_Other_Mat: The other materials and outsourced items of a Standard Estimate.
Fields (41)
ADJTYPEID, ADJUSTMENT, ADJUSTPERCENT, DEPTH, DESCRIPTION, INSTRUCTION, ISADJUST, ISDESC, MATCATID, MATCOSTID, MATPRICEID, MATUNITID, MINQTY, QTY, QTYFACTOR, QTYUP, QTY_TYPEID, QUOTEITEMID, QUOTEOUTID, ROUNDUPQTY, SERVICE, SERVICEID, SERVICETYPEID, SETUPQTY, SPECIFICATION, SUBTOTAL, SUPID, SUPPLIER, SUPREF, TOTAL, TOTALUNIT, TOTALVAT, UNIT, UNITID, UNITPRICE, VATAMT, VATPERCENT, WEIGHT, WEIGHT_TOTAL, WEIGHT_UNIT, WIDTH
Qt_Despatch: The packaging and despatch lines of a Standard Estimate.
Fields (54)
ADJTYPEID_PACK, ADJTYPEID_SHIP, ADJUSTMENT_PACK, ADJUSTMENT_SHIP, BRANCHID, DELADDRESS, DESCRIPTION, DIRECTCOST_PACK, DIRECTCOST_SHIP, ISADJUST_PACK, ISADJUST_SHIP, ISDESC, PACKADJPERCENT, PACKCCID, PACKCOMPANY, PACKCOSTPERPARCEL, PACKDESCRIPTION, PACKID, PACKKGPERPARCEL, PACKNAME, PACKPARCELSPERHOUR, PACKQTYPERPARCEL, PACKRATE, PACKSUPID, PACKTOTALTIME, PACKWHERE, PERCENTQUOTEQTY, QTY, QTYPARCELS, QTY_TYPEID, QUOTEITEMID, QUOTESHIPID, SHIPADJPERCENT, SHIPCOMPANY, SHIPDESCRIPTION, SHIPNAME, SHIPOPTIONID, SHIPPRICEID, SHIPRATE, SHIPWHERE, SPCCID, SPCOSTPERKG, SPCOSTPERKGFROM, SPDESCRIPTION, SPFIXEDCOST, SPSUPID, SUBTOTAL_PACK, SUBTOTAL_SHIP, SUPREF_PACK, SUPREF_SHIP, TOTAL, TOTAL_PACK, TOTAL_SHIP, WEIGHT
Qt_Suppliers: The suppliers of brokered items.
Fields (8)
COMPANY, FAX, ISACTIVE, QUOTEBROKEID, QUOTEITEMID, SUPID, SUPREF, TEL
Qt_Sup_Prices: The supplier prices of brokered items, per quantity.
Fields (7)
PRICE, QTY, QUOTEBROKEID, QUOTEFINID, QUOTEQTYID, QUOTESUBID, STATUSID

Label Printing

The following Data Pipelines can be used for Label Printing (see Label Printing).

QT_Item_Label_Printing: All the fields from the linked estimate, Die and Cylinder.
Fields (94)
CLY_CIRCUMFERENCE, CLY_DESCRIPTION, CLY_GEARTEETH, CLY_MODULE, CLY_WIDTH, COLOURCHANGE_CODE, COLOURCHANGE_DESC, COLOURCHANGE_QTY, COLOUR_CODE, COLOUR_DESC, DELIVERY_CODE, DELIVERY_DESC, DIECHARGEID, DIECUT_CODE, DIECUT_DESC, DIE_APPLICATION, DIE_COATING, DIE_CODE, DIE_DEPTH, DIE_DESCRIPTION, DIE_ENGRAVINGDEPTH, DIE_GAPACROSS, DIE_GAPAROUND, DIE_LABELDEPTH, DIE_LABELRADIUS, DIE_LABELSHAPE, DIE_LABELWIDTH, DIE_MATERIAL, DIE_PERFCUT, DIE_PERFID, DIE_PERFTIE, DIE_QTYACROSS, DIE_QTYAROUND, DIE_QTYUP, DIE_QUALITY, DIE_TITLE, DIE_TYPE, DIE_WIDTH, EMBOSS_CODE, EMBOSS_DESC, FIN_DIE_APPLICATION, FIN_DIE_COATING, FIN_DIE_CODE, FIN_DIE_DEPTH, FIN_DIE_DESCRIPTION, FIN_DIE_ENGRAVINGDEPTH, FIN_DIE_GAPACROSS, FIN_DIE_GAPAROUND, FIN_DIE_LABELDEPTH, FIN_DIE_LABELRADIUS, FIN_DIE_LABELSHAPE, FIN_DIE_LABELWIDTH, FIN_DIE_MATERIAL, FIN_DIE_PERFCUT, FIN_DIE_PERFID, FIN_DIE_PERFTIE, FIN_DIE_QTYACROSS, FIN_DIE_QTYAROUND, FIN_DIE_QTYUP, FIN_DIE_QUALITY, FIN_DIE_TITLE, FIN_DIE_TYPE, FIN_DIE_WIDTH, FOIL_CODE, FOIL_DEPTH, FOIL_DESC, FOIL_WIDTH, LAMINATE_CODE, LAMINATE_DESC, PACKAGE_CODE, PACKAGE_DESC, PACKAGE_QTYPERPACK, PLATECHANGE_CODE, PLATECHANGE_DESC, PLATECHANGE_QTY, REWINDCORE_CODE, REWINDCORE_DESC, REWIND_CODE, REWIND_DESC, REWIND_DIRECTION, REWIND_QTYACROSS, REWIND_QTYROLL, SUBSTRATENETT, SUBSTRATERUNWASTE, SUBSTRATERUNWASTEPERCENT, SUBSTRATESETUPWASTE, SUBSTRATETOTAL, SUBSTRATE_CODE, SUBSTRATE_DESC, SUBSTRATE_WIDTH, VARIABLE_CODE, VARIABLE_DESC, VARNISH_CODE, VARNISH_DESC
QT_Item_Image_Impo: The die layout (imposition) image.
Fields (1)
IMAGE
QT_Item_Image_Rewind: The rewinding direction image.
Fields (1)
IMAGE
QT_Item_Image_Artwork: The artwork images uploaded to the estimate.
Fields (1)
IMAGE
QT_Item_Image_DieFin: The die finishing image.
Fields (1)
IMAGE
WO_Label_Printing: All the fields from the linked estimate, Die and Cylinder, on Work Orders.
Fields (94)
CLY_CIRCUMFERENCE, CLY_DESCRIPTION, CLY_GEARTEETH, CLY_MODULE, CLY_WIDTH, COLOURCHANGE_CODE, COLOURCHANGE_DESC, COLOURCHANGE_QTY, COLOUR_CODE, COLOUR_DESC, DELIVERY_CODE, DELIVERY_DESC, DIECHARGEID, DIECUT_CODE, DIECUT_DESC, DIE_APPLICATION, DIE_COATING, DIE_CODE, DIE_DEPTH, DIE_DESCRIPTION, DIE_ENGRAVINGDEPTH, DIE_GAPACROSS, DIE_GAPAROUND, DIE_LABELDEPTH, DIE_LABELRADIUS, DIE_LABELSHAPE, DIE_LABELWIDTH, DIE_MATERIAL, DIE_PERFCUT, DIE_PERFID, DIE_PERFTIE, DIE_QTYACROSS, DIE_QTYAROUND, DIE_QTYUP, DIE_QUALITY, DIE_TITLE, DIE_TYPE, DIE_WIDTH, EMBOSS_CODE, EMBOSS_DESC, FIN_DIE_APPLICATION, FIN_DIE_COATING, FIN_DIE_CODE, FIN_DIE_DEPTH, FIN_DIE_DESCRIPTION, FIN_DIE_ENGRAVINGDEPTH, FIN_DIE_GAPACROSS, FIN_DIE_GAPAROUND, FIN_DIE_LABELDEPTH, FIN_DIE_LABELRADIUS, FIN_DIE_LABELSHAPE, FIN_DIE_LABELWIDTH, FIN_DIE_MATERIAL, FIN_DIE_PERFCUT, FIN_DIE_PERFID, FIN_DIE_PERFTIE, FIN_DIE_QTYACROSS, FIN_DIE_QTYAROUND, FIN_DIE_QTYUP, FIN_DIE_QUALITY, FIN_DIE_TITLE, FIN_DIE_TYPE, FIN_DIE_WIDTH, FOIL_CODE, FOIL_DEPTH, FOIL_DESC, FOIL_WIDTH, LAMINATE_CODE, LAMINATE_DESC, PACKAGE_CODE, PACKAGE_DESC, PACKAGE_QTYPERPACK, PLATECHANGE_CODE, PLATECHANGE_DESC, PLATECHANGE_QTY, REWINDCORE_CODE, REWINDCORE_DESC, REWIND_CODE, REWIND_DESC, REWIND_DIRECTION, REWIND_QTYACROSS, REWIND_QTYROLL, SUBSTRATENETT, SUBSTRATERUNWASTE, SUBSTRATERUNWASTEPERCENT, SUBSTRATESETUPWASTE, SUBSTRATETOTAL, SUBSTRATE_CODE, SUBSTRATE_DESC, SUBSTRATE_WIDTH, VARIABLE_CODE, VARIABLE_DESC, VARNISH_CODE, VARNISH_DESC
WO_Label_Image_Impo: The die layout (imposition) image, on Work Orders.
Fields (1)
IMAGE
WO_Label_Image_Rewind: The rewinding direction image, on Work Orders.
Fields (1)
IMAGE
WO_Label_Image_Artwork: The artwork images, on Work Orders.
Fields (1)
IMAGE
WO_Label_Image_DieFin: The die finishing image, on Work Orders.
Fields (1)
IMAGE

Note

On Est_Qty_Price and Est_Qty_Price_NoActive, the TOTALROLLUNIT field is the unit price (excluding VAT) for one roll. It is an indicative price only.

Corrugated Boxes and Signage

The following Data Pipelines show the Corrugated Box and Signage fields (see Corrugated Boxes and Signage).

QT_Item_Cor_Boxes: The Corrugated Box fields, with an image of the box, on Quotations.
Fields (66)
BLEED, BOXFLAP, BOXID, BOXSTYLE, BOXTYPEID, BWCOVERID, BWPAGES, BWPAGESPART, COMPIDASSEMBLE, COMPIDDEL, COMPIDDIE, COMPIDDIECUT, COMPIDPACK, COMPIDPLATE, COMPIDPRINT, COMPIDSTOCK, COVERID, CREASES, DEPTH, DESCID, DESCRIPTION, DONTROTATEID, ESTPARTID, ESTPRODPARTID, FEEDER, FLAPCREASES, FLAPPOSITIONID, FOLDING, FTDCOVERLENGTHPLUS, FTDCOVERWIDTHPLUS, GLUEFLAP, HEIGHT, IMAGEARTWORK, IMAGEIMPO, MARGIN, MARGIN2, MINSTOCKDEPTH, MINSTOCKSQM, MINSTOCKWIDTH, OLD_ESTPARTID, ORDERID, OVERRIDEBOXFLAPID, OVERRIDECREASESID, OVERRIDEID, OVERRIDESTOCKSIZEID, PARTDEPTH, PARTWIDTH, QTY, QTYACROSS, QTYDOWN, QTYPALLET, QTYTYPEID, QTYUP, QUOTEITEMID, ROTATEID, SIZEDESC, SPINE, SPLITID, STOCKDEPTH, STOCKDESCRIPTION, STOCKTYPEID, STOCKWASTEPERCENT, STOCKWIDTH, TRIMCHOP, WARNING, WIDTH
WO_Cor_Boxes: The Corrugated Box fields, on Work Orders.
Fields (41)
BOXFLAP, BOXID, BOXSTYLE, BOXTYPEID, COMPIDASSEMBLE, COMPIDDEL, COMPIDDIE, COMPIDDIECUT, COMPIDPACK, COMPIDPLATE, COMPIDPRINT, COMPIDSTOCK, COVERID, CREASES, DEPTH, ESTPARTID, FEEDER, FLAPCREASES, FLAPPOSITIONID, FOLDING, FTDCOVERLENGTHPLUS, FTDCOVERWIDTHPLUS, GLUEFLAP, HEIGHT, MARGIN, MARGIN2, MINSTOCKDEPTH, MINSTOCKSQM, MINSTOCKWIDTH, OVERRIDEBOXFLAPID, OVERRIDECREASESID, OVERRIDESTOCKSIZEID, PARTDEPTH, PARTWIDTH, QTYPALLET, QTYUP, SIZEDESC, SPLITID, TRIMCHOP, WARNING, WIDTH
DN_WO_Cor_Boxes: The Corrugated Box fields of the linked Work Order, on Delivery Notes.
Fields (41)
BOXFLAP, BOXID, BOXSTYLE, BOXTYPEID, COMPIDASSEMBLE, COMPIDDEL, COMPIDDIE, COMPIDDIECUT, COMPIDPACK, COMPIDPLATE, COMPIDPRINT, COMPIDSTOCK, COVERID, CREASES, DEPTH, ESTPARTID, FEEDER, FLAPCREASES, FLAPPOSITIONID, FOLDING, FTDCOVERLENGTHPLUS, FTDCOVERWIDTHPLUS, GLUEFLAP, HEIGHT, MARGIN, MARGIN2, MINSTOCKDEPTH, MINSTOCKSQM, MINSTOCKWIDTH, OVERRIDEBOXFLAPID, OVERRIDECREASESID, OVERRIDESTOCKSIZEID, PARTDEPTH, PARTWIDTH, QTYPALLET, QTYUP, SIZEDESC, SPLITID, TRIMCHOP, WARNING, WIDTH
QT_Item_Signage: The Signage fields, on Quotations.
Fields (64)
BLEED, BLEEDHEIGHT, BLEEDOFFSETX, BLEEDOFFSETY, BLEEDSQM, BLEEDWIDTH, BWCOVERID, BWPAGES, BWPAGESPART, COMPDRAGONTAILS, COMPEYELETS, COMPHEM, COMPIDSTOCK, COMPPACK, COMPPOCKET, COMPPRINT, COMPREINFORCING, COMPSTOCK, COMPWINDSLOTS, DEPTH, DESCID, DESCRIPTION, DONTROTATEID, ESTPARTID, ESTPRODPARTID, FINALHEIGHT, FINALSQM, FINALWIDTH, IMAGE, IMAGEARTWORK, IMAGEIMPO, OLD_ESTPARTID, ORDERID, OVERLAP, OVERRIDEID, OVERRIDEIDPRICING, PANEL, PANELOVERLAP, PANELWIDTH, PRICINGHEIGHT, PRICINGSQM, PRICINGWIDTH, QTY, QTYACROSS, QTYDOWN, QTYTYPEID, QTYUP, QUOTEITEMID, ROTATEID, SIGNAGEID, SIGNAGETYPE, SPINE, STOCKDEPTH, STOCKDESCRIPTION, STOCKTYPEID, STOCKWASTEPERCENT, STOCKWIDTH, TRIMHEIGHT, TRIMSQM, TRIMWIDTH, VISUALHEIGHT, VISUALSQM, VISUALWIDTH, WIDTH
WO_Signage: The Signage fields, on Work Orders.
Fields (64)
BLEED, BLEEDHEIGHT, BLEEDOFFSETX, BLEEDOFFSETY, BLEEDSQM, BLEEDWIDTH, BWCOVERID, BWPAGES, BWPAGESPART, COMPDRAGONTAILS, COMPEYELETS, COMPHEM, COMPIDSTOCK, COMPPACK, COMPPOCKET, COMPPRINT, COMPREINFORCING, COMPSTOCK, COMPWINDSLOTS, DEPTH, DESCID, DESCRIPTION, DONTROTATEID, ESTPARTID, ESTPRODPARTID, FINALHEIGHT, FINALSQM, FINALWIDTH, IMAGE, IMAGEARTWORK, IMAGEIMPO, OLD_ESTPARTID, ORDERID, OVERLAP, OVERRIDEID, OVERRIDEIDPRICING, PANEL, PANELOVERLAP, PANELWIDTH, PRICINGHEIGHT, PRICINGSQM, PRICINGWIDTH, QTY, QTYACROSS, QTYDOWN, QTYTYPEID, QTYUP, QUOTEITEMID, ROTATEID, SIGNAGEID, SIGNAGETYPE, SPINE, STOCKDEPTH, STOCKDESCRIPTION, STOCKTYPEID, STOCKWASTEPERCENT, STOCKWIDTH, TRIMHEIGHT, TRIMSQM, TRIMWIDTH, VISUALHEIGHT, VISUALSQM, VISUALWIDTH, WIDTH

Sales and Production

Sales Orders

The following Data Pipelines can be used on Sales Order output templates.

SO_All: All the Sales Orders.
Fields (86)
ACCNO, APPROVEDLIMIT, BASEVALUE, BASEVALUE_OLD, BRANCHID, CAMPAIGNID, CATEGORY, CATEGORYID, CGSTAMT, CHECKLISTID, CONTACT, CONTACTCEL, CONTACTFAX, CONTACTTEL, CONTACTTITLE, CREDITTERMID, CURRENCYID, CUSCATID, CUSCONTACTID, CUSFAX, CUSID, CUSNOTE, CUSORDERNO, CUSTEL, CUSTOMER, DATEREQUIRED, DATEUPDATED, DELADDRESS, DELIVERYID, DUEDATE, DUEDATE2, DUEDATE3, EDITID, EMAIL, ENQID, FLOWIDS, FOREMANID, FORMAN, FORMANLISTNAME, FROMID, FROMTYPEID, GROUPID, IGSTAMT, IMAGEID, JOBCATEGORY, NOTE, ORDERID, OUTAMT, POSTADDRESS, QTY, QUOTEDATE, QUOTEID, REF1, REF2, REF3, REGIONID, REGISTEREDNAME, REP, REPCELL, REPLISTNAME, REPSIGNATURE, SGSTAMT, SMS, SODATE, SOID, STAFFIDREP, STATUSID_SO, STATUSNOTE, STATUS_CUS, STATUS_SO, TERMS, TERMSDISPLAY, TICKETID, TOTAL, TOTAL3, TOTALCURRENCY, TOTALVAT, TOTALVAT3, USERSORDER, USERUPDATED, VATAMT, VATAMT3, VATNO, VATPERCENT, VATTYPEID, WHERENOW
SO_Rec: The selected Sales Order.
Fields (86)
ACCNO, APPROVEDLIMIT, BASEVALUE, BASEVALUE_OLD, BRANCHID, CAMPAIGNID, CATEGORY, CATEGORYID, CGSTAMT, CHECKLISTID, CONTACT, CONTACTCEL, CONTACTFAX, CONTACTTEL, CONTACTTITLE, CREDITTERMID, CURRENCYID, CUSCATID, CUSCONTACTID, CUSFAX, CUSID, CUSNOTE, CUSORDERNO, CUSTEL, CUSTOMER, DATEREQUIRED, DATEUPDATED, DELADDRESS, DELIVERYID, DUEDATE, DUEDATE2, DUEDATE3, EDITID, EMAIL, ENQID, FLOWIDS, FOREMANID, FORMAN, FORMANLISTNAME, FROMID, FROMTYPEID, GROUPID, IGSTAMT, IMAGEID, JOBCATEGORY, NOTE, ORDERID, OUTAMT, POSTADDRESS, QTY, QUOTEDATE, QUOTEID, REF1, REF2, REF3, REGIONID, REGISTEREDNAME, REP, REPCELL, REPLISTNAME, REPSIGNATURE, SGSTAMT, SMS, SODATE, SOID, STAFFIDREP, STATUSID_SO, STATUSNOTE, STATUS_CUS, STATUS_SO, TERMS, TERMSDISPLAY, TICKETID, TOTAL, TOTAL3, TOTALCURRENCY, TOTALVAT, TOTALVAT3, USERSORDER, USERUPDATED, VATAMT, VATAMT3, VATNO, VATPERCENT, VATTYPEID, WHERENOW
SO_Items_All: All the lines on the selected Sales Order.
Fields (85)
ACCOUNT, ACCOUNTID, ADJPERCENT, ADJTYPEID, ADJUSTMENT, BINREF, CAMPAIGNPRODUCTID, CATEGORY, CATEGORYID, CCENTREID, CGSTAMT, CGSTPERCENT, CODE, COSTPRICE, DELQTY, DESCRIPTION, DIRECTCOST, DUEDATE, FIXEDCOST, FIXEDSELL, FLOWIDS, FROMITEM, GROUPNAME, IGSTAMT, IGSTPERCENT, IMAGE, INEXID, INVAMT, INVDELQTY, ITEMDESC, LINKDN, LINKPO, LINKWOID, LOCATION, MARGIN, MATCATID, MATCOSTID, MATUNITID, MRPID, MRTIME, NOTE, ORDERID, OUTAMT, OUTQTY, PROCCATID, PROCESSID, PRODUCTIONTEXT, PROFIT, QTY, QTYINSTOCK, QUOTEITEMID, REFNO, ROUNDOFFID, SGSTAMT, SGSTPERCENT, SOID, SOITEMID, SPECIFICATION, SPEED, SPEEDQTY, STATUSID, STATUSID_LASTWO, STOCKID, SUBCATEGORY, SUPID, SUPPLIER, TOTAL, TOTAL3, TOTALCOST, TOTALCURRENCY, TOTALHRS, TOTALUNIT, TOTALVAT, TOTALVAT3, TRACKING, TRACKING_STR, TYPEID, UNIT, UNITCOST, UNITID, UNITQTY, VATAMT, VATAMT3, VATPERCENT, VATTYPEID
SO_Items_Rec: The selected Sales Order line.
Fields (85)
ACCOUNT, ACCOUNTID, ADJPERCENT, ADJTYPEID, ADJUSTMENT, BINREF, CAMPAIGNPRODUCTID, CATEGORY, CATEGORYID, CCENTREID, CGSTAMT, CGSTPERCENT, CODE, COSTPRICE, DELQTY, DESCRIPTION, DIRECTCOST, DUEDATE, FIXEDCOST, FIXEDSELL, FLOWIDS, FROMITEM, GROUPNAME, IGSTAMT, IGSTPERCENT, IMAGE, INEXID, INVAMT, INVDELQTY, ITEMDESC, LINKDN, LINKPO, LINKWOID, LOCATION, MARGIN, MATCATID, MATCOSTID, MATUNITID, MRPID, MRTIME, NOTE, ORDERID, OUTAMT, OUTQTY, PROCCATID, PROCESSID, PRODUCTIONTEXT, PROFIT, QTY, QTYINSTOCK, QUOTEITEMID, REFNO, ROUNDOFFID, SGSTAMT, SGSTPERCENT, SOID, SOITEMID, SPECIFICATION, SPEED, SPEEDQTY, STATUSID, STATUSID_LASTWO, STOCKID, SUBCATEGORY, SUPID, SUPPLIER, TOTAL, TOTAL3, TOTALCOST, TOTALCURRENCY, TOTALHRS, TOTALUNIT, TOTALVAT, TOTALVAT3, TRACKING, TRACKING_STR, TYPEID, UNIT, UNITCOST, UNITID, UNITQTY, VATAMT, VATAMT3, VATPERCENT, VATTYPEID
SO_Items_Stock: All the stock lines on the selected Sales Order.
Fields (67)
ACCOUNTID, ADJPERCENT, ADJTYPEID, ADJUSTMENT, BINREF, CAMPAIGNPRODUCTID, CATEGORYID, CCENTREID, CGSTAMT, CGSTPERCENT, CODE, COSTPRICE, DESCRIPTION, DIRECTCOST, DUEDATE, FIXEDCOST, FIXEDSELL, FLOWIDS, GROUPNAME, IGSTAMT, IGSTPERCENT, IMAGE, INEXID, LOCATION, MARGIN, MATCATID, MATCOSTID, MATUNITID, MRPID, MRTIME, NOTE, ORDERID, PROCCATID, PROCESSID, PROFIT, QTY, QUOTEITEMID, REFNO, ROUNDOFFID, SGSTAMT, SGSTPERCENT, SOID, SOITEMID, SPECIFICATION, SPEED, SPEEDQTY, STATUSID, STOCKID, SUPID, TOTAL, TOTAL3, TOTALCOST, TOTALCURRENCY, TOTALHRS, TOTALUNIT, TOTALVAT, TOTALVAT3, TRACKING, TYPEID, UNIT, UNITCOST, UNITID, UNITQTY, VATAMT, VATAMT3, VATPERCENT, VATTYPEID
SO_All_Items: All the Sales Order lines in the Items view.
Fields (73)
ACCOUNTID, ADJPERCENT, ADJTYPEID, ADJUSTMENT, CATEGORY, CATEGORYID, CATEGORY_ITEM, CGSTAMT, CODE, COSTPRICE, CUSCATEGORY, CUSORDERNO, CUSTOMER, CUSUSERCREATED, DELIVERY, DELQTY, DESCRIPTION, DIRECTCOST, DUEDATE, FROMITEM, FROMTRANS, GROUPNAME, IGSTAMT, INEXID, INVDELQTY, ITEMDUEDATE, LINKDN, LINKWOID, LOCATION, MARGIN, MATCATEGORY, ORDERID, OUTQTY, PROFIT, QTY, QTYINSTOCK, QUOTEITEMID, QUOTENO, REF1, REF2, REF3, REGIONID, REP, RESOLVE, SGSTAMT, SODATE, SOID, SOITEMID, STATUSID, STATUSID_LASTWO, STATUSID_SO, SUBCATEGORY, SUPID, TOTAL, TOTAL3, TOTALCOST, TOTALUNIT, TOTALVAT, TOTALVAT3, TOTALVAT_SO, TOTAL_SO, TRACKING_STR, TYPEID, UNIT, UNITCOST, UNITQTY, USERCREATED, VATAMT, VATAMT3, VATAMT_SO, VATPERCENT, VATTYPEID, WORKFLOWID
SO_Approvals: The Sales Order's checklist items.
Fields (6)
CHECKLISTTRANSID, CODE, DATEUPDATED, DESCRIPTION, NOTE, USERUPDATED

Work Orders

The following Data Pipelines can be used on Work Order output templates (worktickets).

WO_Rec: The selected Work Order.
Fields (83)
ACCNO, APPROVAL, APPROVEID, BRANCH, BRANCHID, CAMPAIGNID, CATEGORY, CATEGORYID, CHECKLISTID, CONTACTCEL, CONTACTEMAIL, CONTACTTEL, CONTROLLER, CREATEDFROM, CUSCONTACT, CUSCONTACTID, CUSID, CUSORDERNO, CUSTOMER, DATECREATED, DATEREQUIRED, DATEUPDATED, DELADDRESS, DELIVERY, DELIVERYID, DNOUTQTY, DUEDATE, DUEDATE2, DUEDATE3, EDITID, ENQID, ESTIMATOR, FLOWIDS, FROMID, FROMTRANS, FROMTYPEID, GROUPID, IMAGEID, INTERNALNOTES, LINKEDATTACHID, LINKEDMM, LINKEDPO, LOCATION, MATCODE, MATDESC, MATUNITID, NCRNO, NOTE, ORDERID, PROOFID, QTY, QUOTEID, QUOTEITEMID, QUOTENO, REFERENCE, REFERENCE_SO, REP, SIZEDESC, SOID, SPEC, STAFFIDASSIGN, STAFFIDREP, STATUS, STATUSID, STATUSID_SO, STATUSNOTE, STOCKID, SWITCHUDF1, SWITCHUDF2, SWITCHUDF3, SWITCHUDF4, SWITCHUDF5, SWITCHUDF6, TICKETID, TOTAL, TYPEID, UPDATED, USERUPDATED, USERWORDER, WARNING, WODATE, WOID, WORKFLOWID
WO_All: All the Work Orders on the list.
Fields (83)
ACCNO, APPROVAL, APPROVEID, BRANCH, BRANCHID, CAMPAIGNID, CATEGORY, CATEGORYID, CHECKLISTID, CONTACTCEL, CONTACTEMAIL, CONTACTTEL, CONTROLLER, CREATEDFROM, CUSCONTACT, CUSCONTACTID, CUSID, CUSORDERNO, CUSTOMER, DATECREATED, DATEREQUIRED, DATEUPDATED, DELADDRESS, DELIVERY, DELIVERYID, DNOUTQTY, DUEDATE, DUEDATE2, DUEDATE3, EDITID, ENQID, ESTIMATOR, FLOWIDS, FROMID, FROMTRANS, FROMTYPEID, GROUPID, IMAGEID, INTERNALNOTES, LINKEDATTACHID, LINKEDMM, LINKEDPO, LOCATION, MATCODE, MATDESC, MATUNITID, NCRNO, NOTE, ORDERID, PROOFID, QTY, QUOTEID, QUOTEITEMID, QUOTENO, REFERENCE, REFERENCE_SO, REP, SIZEDESC, SOID, SPEC, STAFFIDASSIGN, STAFFIDREP, STATUS, STATUSID, STATUSID_SO, STATUSNOTE, STOCKID, SWITCHUDF1, SWITCHUDF2, SWITCHUDF3, SWITCHUDF4, SWITCHUDF5, SWITCHUDF6, TICKETID, TOTAL, TYPEID, UPDATED, USERUPDATED, USERWORDER, WARNING, WODATE, WOID, WORKFLOWID
WO_Output: The Work Order's output lines.
Fields (47)
CAMPAIGNPRODUCTID, CODE, CONTACT, CONTACTCEL, CONTACTEMAIL, CONTACTTEL, CREDITTERMS, CUSORDERNO, DELADDRESS, DESCRIPTION, FLOWIDS, LINKEDMM, MATCATID, MATCOMPANY, MATCOSTID, MATDESCRIPTION, MATIMAGE, MATUNITID, OUTPUT, QTY, QUOTEITEMID, RATIO, REF2, REF3, REFNO, REP, REPCEL, SIZEDESC, SOCOMPANY, SODESCRIPTION, SODUEDATE, SOID, SOITEMDUEDATE, SOITEMID, SOUSER, STATUSID, STOCKID, STOCKLOCATION, TOTAL, TOTALCOST, TYPEID, UNIT, UNITID, WOID, WOID_LASTDESIGN, WOID_LASTPRODUCTION, WOOUTPUTID
WO_All_Items: All the output lines in the Output view.
Fields (40)
ASSIGNTO, CAMPAIGNPRODUCTID, CODE, CONTACT, CONTACTCEL, CONTACTEMAIL, CONTACTTEL, CUSTOMER, DATEREQUIRED, DELIVERY, DESCRIPTION, DUEDATE, FLOWIDS, LINKEDMM, MATDESCRIPTION, MATUNITID, OUTPUT, QTY, QUOTEITEMID, RATIO, REFERENCE, REFNO, REP, SODESCRIPTION, SODUEDATE, SOID, SOITEMDUEDATE, SOITEMID, STATUSID, STATUSID_WO, STOCKLOCATION, TOTALCOST, TYPEID, TYPEID_WO, UNIT, WODATE, WOID, WOID_LASTDESIGN, WOID_LASTPRODUCTION, WOOUTPUTID
WO_Output_Item_UDF: The user-defined fields linked to the output item. It only works if a stored procedure for the UDF fields exists.
Fields (1)
MATUNITID
WO_BoM: The materials on the Materials tab, with their purchase and issue details.
Fields (37)
CODE, COMPANY, COMPONENT, DESCRIPTION, FIXEDQTY, FROMID, GROUPS, IMAGE, IMAGETYPEID, INSTRUCTION, ITEMDESC, MATCATID, MATCOSTID, MATPRICEID, MATUNITID, MINQTY, MRPID, OUTQTY, QTY, QTYINSTOCK, QTY_TYPEID, STATUSID, STOCKID, STOCKLOCATION, SUPID, SUP_STOCK, TOTAL, UNIT, UNITID, UNITPRICE, UNITQTY, UPDATEID, WEIGHT, WEIGHT_TOTAL, WEIGHT_UNIT, WOBOMID, WOID
WO_BoM_Stock: The materials that come from stock.
Fields (35)
BASEUNIT, BASEUNITID, BINREF, CODE, COMPANY, COMPONENT, DESCRIPTION, FIXEDQTY, GROUPS, IMAGE, IMAGETYPEID, INSTRUCTION, MATCATID, MATPRICEID, MATUNITID, MINQTY, MRPID, QTY, QTYISSUED, QTY_TYPEID, STATUSID, STOCKID, STOCKLOCATION, STOCKOUTQTY, SUPID, TOTAL, UNIT, UNITID, UNITPRICE, UNITQTY, WEIGHT, WEIGHT_TOTAL, WEIGHT_UNIT, WOBOMID, WOID
WO_BoM_POtoOrder: The materials still to be ordered.
Fields (30)
BASEUNIT, BASEUNITID, COMPANY, COMPONENT, DESCRIPTION, FIXEDQTY, GROUPS, IMAGE, IMAGETYPEID, INSTRUCTION, MATCATID, MATPRICEID, MATUNITID, MINQTY, MRPID, QTY, QTY_TYPEID, STATUSID, STOCKID, SUPID, TOTAL, UNIT, UNITID, UNITPRICE, UNITQTY, WEIGHT, WEIGHT_TOTAL, WEIGHT_UNIT, WOBOMID, WOID
WO_BoM_Paper: The paper materials.
Fields (31)
BASEUNIT, BASEUNITID, COMPANY, COMPONENT, DESCRIPTION, FIXEDQTY, GROUPS, IMAGE, IMAGETYPEID, INSTRUCTION, MATCATID, MATPRICEID, MATUNITID, MINQTY, MRPID, PRESS, QTY, QTY_TYPEID, STATUSID, STOCKID, SUPID, TOTAL, UNIT, UNITID, UNITPRICE, UNITQTY, WEIGHT, WEIGHT_TOTAL, WEIGHT_UNIT, WOBOMID, WOID
WO_BoM_Ink: The ink materials.
Fields (31)
BASEUNIT, BASEUNITID, COMPANY, COMPONENT, DESCRIPTION, FIXEDQTY, GROUPS, IMAGE, IMAGETYPEID, INSTRUCTION, MATCATID, MATCOSTID, MATPRICEID, MATUNITID, MINQTY, MRPID, QTY, QTY_TYPEID, STATUSID, STOCKID, SUPID, TOTAL, UNIT, UNITID, UNITPRICE, UNITQTY, WEIGHT, WEIGHT_TOTAL, WEIGHT_UNIT, WOBOMID, WOID
WO_BoM_Mat: The other materials.
Fields (32)
CATEGORY, CODE, COMPANY, COMPONENT, DESCRIPTION, FIXEDQTY, FROMID, GROUPS, IMAGE, IMAGETYPEID, INSTRUCTION, MATCOSTID, MATPRICEID, MATUNITID, MINQTY, MRPID, QTY, QTY_TYPEID, STATUSID, STOCKID, SUPID, TOTAL, UNIT, UNITID, UNITPRICE, UNITQTY, UPDATEID, WEIGHT, WEIGHT_TOTAL, WEIGHT_UNIT, WOBOMID, WOID
WO_BoM_Images: The images of the Work Order's materials.
Fields (4)
DESCRIPTION, IMAGE, QTY, UNIT
WO_Svc_all: All the services on the Services tab.
Fields (32)
CCENTREID, COMPONENT, COSTCENTRE, COSTQTY, DESCRIPTION, DIRECTCOST, FIXEDCOST, GROUPS, IMAGE, IMAGETYPEID, INSTRUCTION, INTEXT, MRTIME, ORDERID, PROCESSID, PROVIDER, QTY, QTYFACTOR, QTYUP, QTY_TYPEID, RATE, SPEED, SPEEDQTY, STATUSID, SUPID, SUPPLIER, TOTAL, TOTALHRS, UNIT, UNITCOST, WOID, WOPROCID
WO_Svc_Internal: The internal services.
Fields (31)
CCENTREID, COMPONENT, COSTQTY, DESCRIPTION, DIRECTCOST, FIXEDCOST, FROMID, GROUPS, IMAGE, IMAGETYPEID, INSTRUCTION, MRTIME, ORDERID, PROCESSID, PROVIDER, QTY, QTYFACTOR, QTYUP, QTY_TYPEID, RATE, SPEED, SPEEDQTY, STATUSID, SUPID, TOTAL, TOTALHRS, UNIT, UNITCOST, UPDATEID, WOID, WOPROCID
WO_Svc_Outwork: The outsourced services (outwork).
Fields (31)
CCENTREID, COMPONENT, COSTQTY, DESCRIPTION, DIRECTCOST, FIXEDCOST, FROMID, GROUPS, IMAGE, IMAGETYPEID, INSTRUCTION, MRTIME, ORDERID, PROCESSID, QTY, QTYFACTOR, QTYUP, QTY_TYPEID, RATE, SPEED, SPEEDQTY, STATUSID, SUPID, SUPPLIER, TOTAL, TOTALHRS, UNIT, UNITCOST, UPDATEID, WOID, WOPROCID
WO_PrePress: The pre-press services.
Fields (34)
CCENTREID, COMPONENT, COSTCENTRE, COSTQTY, DESCRIPTION, DIRECTCOST, FIXEDCOST, FROMID, GROUPS, IMAGE, IMAGETYPEID, INSTRUCTION, INTEXT, MRTIME, ORDERID, PROCESSID, PROVIDER, QTY, QTYFACTOR, QTYUP, QTY_TYPEID, RATE, SPEED, SPEEDQTY, STATUSID, SUPID, SUPPLIER, TOTAL, TOTALHRS, UNIT, UNITCOST, UPDATEID, WOID, WOPROCID
WO_Printing: The printing services.
Fields (32)
CCENTREID, COMPONENT, COSTCENTRE, COSTQTY, DESCRIPTION, DIRECTCOST, FIXEDCOST, GROUPS, IMAGE, IMAGETYPEID, INSTRUCTION, INTEXT, MRTIME, ORDERID, PROCESSID, PROVIDER, QTY, QTYFACTOR, QTYUP, QTY_TYPEID, RATE, SPEED, SPEEDQTY, STATUSID, SUPID, SUPPLIER, TOTAL, TOTALHRS, UNIT, UNITCOST, WOID, WOPROCID
WO_Finishing: The finishing services.
Fields (32)
CCENTREID, COMPONENT, COSTCENTRE, COSTQTY, DESCRIPTION, DIRECTCOST, FIXEDCOST, GROUPS, IMAGE, IMAGETYPEID, INSTRUCTION, INTEXT, MRTIME, ORDERID, PROCESSID, PROVIDER, QTY, QTYFACTOR, QTYUP, QTY_TYPEID, RATE, SPEED, SPEEDQTY, STATUSID, SUPID, SUPPLIER, TOTAL, TOTALHRS, UNIT, UNITCOST, WOID, WOPROCID
WO_Fin_Linked: The finishing services linked to a part.
Fields (34)
CCENTREID, COMPONENT, COSTCENTRE, COSTQTY, DESCRIPTION, DIRECTCOST, FIXEDCOST, FROMID, GROUPS, IMAGE, IMAGETYPEID, INSTRUCTION, INTEXT, MRTIME, ORDERID, PROCESSID, PROVIDER, QTY, QTYFACTOR, QTYUP, QTY_TYPEID, RATE, SPEED, SPEEDQTY, STATUSID, SUPID, SUPPLIER, TOTAL, TOTALHRS, UNIT, UNITCOST, UPDATEID, WOID, WOPROCID
WO_Fin_Unlinked: The finishing services not linked to a part.
Fields (32)
CCENTREID, COMPONENT, COSTCENTRE, COSTQTY, DESCRIPTION, DIRECTCOST, FIXEDCOST, GROUPS, IMAGE, IMAGETYPEID, INSTRUCTION, INTEXT, MRTIME, ORDERID, PROCESSID, PROVIDER, QTY, QTYFACTOR, QTYUP, QTY_TYPEID, RATE, SPEED, SPEEDQTY, STATUSID, SUPID, SUPPLIER, TOTAL, TOTALHRS, UNIT, UNITCOST, WOID, WOPROCID
WO_Packaging: The packaging services.
Fields (32)
CCENTREID, COMPONENT, COSTCENTRE, COSTQTY, DESCRIPTION, DIRECTCOST, FIXEDCOST, GROUPS, IMAGE, IMAGETYPEID, INSTRUCTION, INTEXT, MRTIME, ORDERID, PROCESSID, PROVIDER, QTY, QTYFACTOR, QTYUP, QTY_TYPEID, RATE, SPEED, SPEEDQTY, STATUSID, SUPID, SUPPLIER, TOTAL, TOTALHRS, UNIT, UNITCOST, WOID, WOPROCID
WO_Delivery: The delivery services.
Fields (32)
CCENTREID, COMPONENT, COSTCENTRE, COSTQTY, DESCRIPTION, DIRECTCOST, FIXEDCOST, GROUPS, IMAGE, IMAGETYPEID, INSTRUCTION, INTEXT, MRTIME, ORDERID, PROCESSID, PROVIDER, QTY, QTYFACTOR, QTYUP, QTY_TYPEID, RATE, SPEED, SPEEDQTY, STATUSID, SUPID, SUPPLIER, TOTAL, TOTALHRS, UNIT, UNITCOST, WOID, WOPROCID
WO_Cutout_Images: The cutout images of the services.
Fields (4)
COMPONENT, DESCRIPTION, IMAGE, WOPROCID
WO_Cost_Sum: A cost summary of the materials, services and purchases.
Fields (1)
WOID
WO_Est_Stk: The estimated stock materials.
Fields (5)
DESCRIPTION, INSTRUCTION, PROVIDER, QTY, TOTAL
WO_Est_Svc: The estimated services.
Fields (6)
DESCRIPTION, INSTRUCTION, PROVIDER, QTY, TOTAL, TOTALHRS
WO_Est_PO: The estimated purchases.
Fields (5)
DESCRIPTION, INSTRUCTION, PROVIDER, QTY, TOTAL
WO_Act_Stk: The actual stock issued.
Fields (3)
DESCRIPTION, MATUNITID, PROVIDER
WO_Act_Svc: The actual time booked on the services.
Fields (5)
ENDDATE, PROVIDER, QTY, RATE, TOTAL
WO_Act_PO: The actual purchases on linked Purchase Orders.
Fields (4)
DESCRIPTION, PROVIDER, QTY, TOTAL
WO_Parts: The JDF Switch parts table.
Fields (38)
BLEED, BWCOVERID, BWPAGES, COLORS, COMPIDSTOCK, DEPTH, DESCRIPTION, ESTPARTID, FINISHING, ORDERID, OVERRIDEID, PAGEACROSS, PAGEBLEED, PAGEDEPTH, PAGEDOWN, PAGEROTATEID, PAGESPINE, PAGEWIDTH, PRINTING, QTY, QTYACROSS, QTYDOWN, QTYOUT, QTYOUTACROSS, QTYOUTDOWN, QTYUP, ROTATEDOUT, ROTATEID, STATUSID, STOCKDEPTH, STOCKDESCRIPTION, STOCKTYPEID, STOCKWIDTH, WIDTH, WOID, WOPARTID, WORKDEPTH, WORKWIDTH
WO_Part_Progress: The progress of the JDF Switch parts.
Fields (6)
COMPLETEID, DATECOMPLETE, NOTE, WOID, WOPARTID, WOPARTPROGRESSID
WO_Files: The JDF Switch files.
Fields (11)
DATECOMPLETE, DATECREATED, DESCRIPTION, PARENTID, STATUSID, TYPEID, URL, USERCREATED, WOFILEID, WOID, WOPARTID
WO_Attach_Images: The image attachments (Type = Image (.jpg, .png)) linked to the Work Order (see Attachments).
Fields (3)
ATTACHID, DESCRIPTION, URL
WO_Approvals: The Work Order's checklist items.
Fields (6)
CHECKLISTTRANSID, CODE, DATEUPDATED, DESCRIPTION, NOTE, USERUPDATED

Design Work Orders

The images and changes of the last Design Work Order are available on output templates through these Data Pipelines (see Design Work Orders).

WO_Design_Images: The images of the Design Work Order itself.
Fields (4)
CAPTION, IMAGE, WODESIGNIMAGEID, WOID
WO_Design_Changes: The colour and design changes of the Design Work Order itself.
Fields (7)
COLCHANGEID, COLOUR, COLOURCHANGE, DESIGNCHANGE, DESIGNCHANGEID, WODESIGNCHANGEID, WOID
WO_Output_Design_Images: The images of the last design linked to the output item.
Fields (4)
CAPTION, IMAGE, WODESIGNIMAGEID, WOID
WO_Output_Design_Changes: The colour and design changes of the last design linked to the output item.
Fields (7)
COLCHANGEID, COLOUR, COLOURCHANGE, DESIGNCHANGE, DESIGNCHANGEID, WODESIGNCHANGEID, WOID
QT_Design_Images: The images of the last design, linked to Quotation lines.
Fields (4)
CAPTION, IMAGE, WODESIGNIMAGEID, WOID
QT_Design_Changes: The changes of the last design, linked to Quotation lines.
Fields (7)
COLCHANGEID, COLOUR, COLOURCHANGE, DESIGNCHANGE, DESIGNCHANGEID, WODESIGNCHANGEID, WOID
SO_Design_Images: The images of the last design, linked to Sales Order lines.
Fields (4)
CAPTION, IMAGE, WODESIGNIMAGEID, WOID
SO_Design_Changes: The changes of the last design, linked to Sales Order lines.
Fields (7)
COLCHANGEID, COLOUR, COLOURCHANGE, DESIGNCHANGE, DESIGNCHANGEID, WODESIGNCHANGEID, WOID
PO_Design_Images: The images of the last design, linked to Purchase Order lines.
Fields (4)
CAPTION, IMAGE, WODESIGNIMAGEID, WOID
PO_Design_Changes: The changes of the last design, linked to Purchase Order lines.
Fields (7)
COLCHANGEID, COLOUR, COLOURCHANGE, DESIGNCHANGE, DESIGNCHANGEID, WODESIGNCHANGEID, WOID

Note

The pipelines that show the last Design Work Order in other modules (Quotations, Sales Orders and Purchase Orders) include fields for the date of the last colour change and design change.

Job Summary and Timekeeping

The following Data Pipelines can be used on Job Summary and Timekeeping output templates (see Job Summary).

JS_Headers: The Job Summary headings.
Fields (13)
DESCRIPTION, JOBSUMID, PARENTID, PERCENTVAR, TOTALACT, TOTALEST, TOTALVAR, TRANSID, TRANSNO, TRANSTYPE, TYPEID, UNIT, VALUEID
JS_Level2: The second level of the Job Summary.
Fields (13)
DESCRIPTION, JOBSUMID, PARENTID, PERCENTVAR, TOTALACT, TOTALEST, TOTALVAR, TRANSID, TRANSNO, TRANSTYPE, TYPEID, UNIT, VALUEID
JS_Level3: The third level of the Job Summary.
Fields (13)
DESCRIPTION, JOBSUMID, PARENTID, PERCENTVAR, TOTALACT, TOTALEST, TOTALVAR, TRANSID, TRANSNO, TRANSTYPE, TYPEID, UNIT, VALUEID
JS_Level4: The fourth level of the Job Summary.
Fields (13)
DESCRIPTION, JOBSUMID, PARENTID, PERCENTVAR, TOTALACT, TOTALEST, TOTALVAR, TRANSID, TRANSNO, TRANSTYPE, TYPEID, UNIT, VALUEID
JS_Level5: The fifth level of the Job Summary.
Fields (13)
DESCRIPTION, JOBSUMID, PARENTID, PERCENTVAR, TOTALACT, TOTALEST, TOTALVAR, TRANSID, TRANSNO, TRANSTYPE, TYPEID, UNIT, VALUEID
JS_TransMain: The transactions linked to the job.
Fields (21)
CATEGORY, CUSNAME, DUEDATE, DUE_DATE, DUE_TIME, INVDATE, LINKTYPEID, LOCATION, QTY, QTY_FORMAT, REFERENCE, SOID, STATUS, STATUSGROUPID, STATUSID, STATUSNOTE, TOTAL, TRANSDATE, TRANSID, TRANSNAME, TRANSTYPENAME
JS_CCentre: The labour cost per Cost Centre.
Fields (6)
ACTUALHOURS, CCENTREID, COSTTYPE, ESTIMATE, NAME, VARIANCE
JS_Timelog: The time logged on the job.
Fields (13)
ACTUALCOST, ACTUALTIME, CCENTREID, COSTCENTRE, COSTTYPE, ITEM, LINK, NOTE, OPERATOR, RATE, STARTDATE, TIMELOGID, TRACKING
Prod_Time: The timekeeping records.
Fields (32)
ACTUALCOST, ACTUALTIME, BRANCHID, CCENTREID, COMPANY, COSTCENTRE, ENDTIME, ITEM, LINK, NCRID, NCRNO, NOTE, OPERATERCOUNT, OPERATOR, OPERATORSTAFFID, PAUSEID, QTYDONE, QTYSPOILED, RATE, REFERENCE, SOID, SOSTAGEID, STAGE, STAGEID, STARTTIME, STATIONID, TAPAYSCALEID, TIMELOGID, TRACKINGID, USERSTAFFID, WOID, WOPROCID

Delivery Notes

The following Data Pipelines can be used on Delivery Note output templates.

DN_Rec: The selected Delivery Note.
Fields (63)
ACCNO, ASSIGNTO, BATCHES, BRANCH, BRANCHID, CAMPAIGNID, COMPANY, CONTACTCEL, CONTACTFAX, CONTACTTEL, CREDITTERMID, CUSCONTACTID, CUSID, CUSORDERNO, DATECREATED, DATEUPDATED, DELADDRESS, DELADDRESS_STR, DELDATE, DELID, DELIVERY, DELIVERYID, DUEDATE, EDITID, EMAIL, FAX, FLOWIDS, FNAME, FROMID, FROMTRANS, FROMTYPEID, GROUPID, IMAGEID, LINKEDINV, LINKEDMMI, LISTNAME, NOTES, ORDERID, PERIODID, REF1, REF2, REFNO, REGISTEREDNAME, SHORTNAME, SIGNEDID, SMS, SOID, SOID_1, STAFFIDASSIGN, STAFFIDREP, STATUS, STATUSID, STATUSNOTE, TEL, TERMS, TICKETID, USERCREATED, USERUPDATED, VATNO, WARNING, WAYBILLNO, WOID, WORKFLOWID
DN_All: All the Delivery Notes on the list. It outputs a batch in the correct order.
Fields (63)
ACCNO, ASSIGNTO, BATCHES, BRANCH, BRANCHID, CAMPAIGNID, COMPANY, CONTACTCEL, CONTACTFAX, CONTACTTEL, CREDITTERMID, CUSCONTACTID, CUSID, CUSORDERNO, DATECREATED, DATEUPDATED, DELADDRESS, DELADDRESS_STR, DELDATE, DELID, DELIVERY, DELIVERYID, DUEDATE, EDITID, EMAIL, FAX, FLOWIDS, FNAME, FROMID, FROMTRANS, FROMTYPEID, GROUPID, IMAGEID, LINKEDINV, LINKEDMMI, LISTNAME, NOTES, ORDERID, PERIODID, REF1, REF2, REFNO, REGISTEREDNAME, SHORTNAME, SIGNEDID, SMS, SOID, SOID_1, STAFFIDASSIGN, STAFFIDREP, STATUS, STATUSID, STATUSNOTE, TEL, TERMS, TICKETID, USERCREATED, USERUPDATED, VATNO, WARNING, WAYBILLNO, WOID, WORKFLOWID
DN_Items: The Delivery Note's lines.
Fields (24)
CATEGORY, CODE, DELID, DELITEMID, DESCRIPTION, FLOWIDS, FROMITEM, LINKEDMMI, MATCOSTID, MATUNITID, NOTE, ORDERID, PARCELQTY, QTY, QTYPERPARCEL, REFNO, SOITEMID, SPECIFICATION, STOCKID, SUBCATEGORY, UNIT, UNITID, WONO, WOOUTPUTID
DN_All_Items: All the Delivery Note lines in the Items view.
Fields (28)
BRANCH, CODE, CUSORDERNO, CUSTOMER, DELDATE, DELID, DELITEMID, DELIVERY, DESCRIPTION, FROMITEM, FROMTRANS, LINKEDINV_ITEM, LINKEDMMI, LINKEDMMI_ITEM, MATCATEGORY, ORDERID, PARCELQTY, QTY, QTYINV, QTYPERPARCEL, REF1, REFNO, SOID, STATUSID, SUBCATEGORY, UNIT, WAYBILLNO, WOID
DN_Signed: The signed Delivery Note. The SIGNDOC field holds the signed document (see Digitally Signed Delivery Notes).
Fields (1)
SIGNDOC
DN_WO_Rec: The linked Work Order.
Fields (58)
BRANCHID, CAMPAIGNID, CATEGORY, CATEGORYID, CHECKLISTID, CONTROLLER, CUSCONTACTID, CUSID, CUSORDERNO, DATECREATED, DATEREQUIRED, DATEUPDATED, DELADDRESS, DELIVERYID, DUEDATE, DUEDATE2, DUEDATE3, EDITID, ENQID, ESTIMATOR, FLOWIDS, FROMID, FROMTYPEID, GROUPID, IMAGEID, INTERNALNOTES, LOCATION, MATCODE, MATDESC, MATUNITID, NOTE, ORDERID, PROOFID, QTY, QUOTEID, QUOTEITEMID, REFERENCE, SOID, SPEC, STAFFIDASSIGN, STAFFIDREP, STATUS, STATUSID, STATUSNOTE, STOCKID, SWITCHUDF1, SWITCHUDF2, SWITCHUDF3, SWITCHUDF4, SWITCHUDF5, SWITCHUDF6, TICKETID, TYPEID, USERUPDATED, USERWORDER, WODATE, WOID, WORKTICKET
DN_WO_Parts: The linked Work Order's JDF Switch parts.
Fields (38)
BLEED, BWCOVERID, BWPAGES, COLORS, COMPIDSTOCK, DEPTH, DESCRIPTION, ESTPARTID, FINISHING, ORDERID, OVERRIDEID, PAGEACROSS, PAGEBLEED, PAGEDEPTH, PAGEDOWN, PAGEROTATEID, PAGESPINE, PAGEWIDTH, PRINTING, QTY, QTYACROSS, QTYDOWN, QTYOUT, QTYOUTACROSS, QTYOUTDOWN, QTYUP, ROTATEDOUT, ROTATEID, STATUSID, STOCKDEPTH, STOCKDESCRIPTION, STOCKTYPEID, STOCKWIDTH, WIDTH, WOID, WOPARTID, WORKDEPTH, WORKWIDTH

Point of Sale

The following Data Pipelines can be used on Point of Sale output templates (see Point of Sale).

POS_Rec: The selected sale.
Fields (10)
INVDATE, INVID, INVNO, NOTE, POSID, SOID, TRANSID_RECEIPT, USERQTY1, USERQTY2, USERQTY3
POS_Order: The Sales Order of the sale.
Fields (36)
ADJUSTMENT_STR, BRANCH, BRANCHID, COUNTITEM_STR, CURRENCYID, CUSACCOUNTNO, CUSID, CUSORDERNO, CUSTOMER, DELADDRESS, DOCNO, DUEDATE, EMAIL, GROUPID, LINE1, LINE2, LINE4, NOTE, POSTADDRESS, REF1, REP, SODATE, SOID, STATUSID_SO, TEL, TOTAL, TOTALVAT, TOTALVAT_STR, TOTALVAT_TEXT, TOTAL_STR, USERSORDER, VATAMT, VATAMT_STR, VATNO, VATPERCENT, VATTYPEID
POS_Items: The sale's lines.
Fields (32)
ADJPERCENT, ADJTYPEID, ADJUSTMENT, DESCRIPTION, DESCRIPTION_ITEM, DUEDATE, FIXEDCOST, INEXID, MATUNITID, MRPID, NOTE, PRICETYPEID, PROCESSID, QTY, QTY_STR, ROUNDOFFID, SOID, SOITEMID, STATUSID, TOTAL, TOTAL3, TOTAL3_STR, TOTALUNIT, TOTALVAT, TOTALVAT3, TOTAL_STR, TYPEID, UNITCOST, UNITQTY, VATAMT3, VATPERCENT, VATTYPEID
POS_NewOrder: The lines of a new Sales Order created from Point of Sale.
Fields (39)
ADJPERCENT, ADJUSTMENT, BASEUNIT, BASEUNITID, BINREF, CCENTREID, CODE, DESCRIPTION, DIRECTCOST, DUEDATE, FIXEDCOST, IMAGE, LOCATION, MATCATID, MATUNITID, MRPID, MRTIME, NOTE, ORDERID, PROCCATID, PROCESSID, QTY, REFNO, ROUNDOFFID, SOID, SOITEMID, SPECIFICATION, SPEED, SPEEDQTY, STATUSID, STOCKID, SUPID, TOTAL, TOTALHRS, TOTALUNIT, UNIT, UNITCOST, UNITID, UNITQTY
POS_Payments: The payment types.
Fields (7)
DEFAULTID, DESCRIPTION, DRACCOUNTID, POSPAYMENTTYPEID, SOPOSID, TOTAL, TOTAL3
POS_Cashup: The cash-up header.
Fields (23)
BRANCHID, CASHUPID, DATECREATED, DATEEND, DATESTART, DATEUPDATED, FLOATCLOSE, FLOATCLOSE3, FLOATDRAWN, FLOATDRAWN3, FLOATOPEN, FLOATOPEN3, FLOATRECEIVED, FLOATRECEIVED3, NOTE, STAFFIDSUPERVISOR, STAFFIDUSER, STATUSID, STATUSNOTE, SUPERVISOR, USERCOUNT, USERCREATED, USERUPDATED
POS_Cashup_Items: The transactions in the cash-up.
Fields (16)
BRANCH, COMPANY, DESCRIPTION, DOCID, DRACCOUNT, INVDATE, INVID, INVNO, ORDERID, REFERENCE, SODATE, SOID, TOTALVAT, TRANSID_RECEIPT, TRANSITEMID, USERSORDER
POS_Cashup_CashCount: The cash count (notes and coins).
Fields (9)
AMOUNT, CASHFLOATID, CASHUPID, DESCRIPTION, IMAGE, NOTESCOINSID, QTY, TOTAL, TOTAL3
POS_Cashup_Count: The count of the other payment types.
Fields (11)
CASHUPID, COUNTAMT, COUNTAMT3, DEFAULTID, DESCRIPTION, DRACCOUNTID, POSPAYMENTTYPEID, SYSTEMAMT, SYSTEMAMT3, VARAMT, VARAMT3

Purchasing and Inventory

Purchase Orders

The following Data Pipelines can be used on Purchase Order output templates.

PO_Rec: The selected Purchase Order.
Fields (87)
ACCNO, APPROVAL, APPROVEID, BASEVALUE, BASEVALUE_OLD, BRANCH, BRANCHID, CAMPAIGNID, CATEGORY, CATEGORYID, CGSTAMT, CHECKLISTID, CONTACTTEL, CREDITTERMID, CURRENCY, CURRENCYID, CUSCONTACT, CUSCONTACT_EMAIL, CUSCONTACT_TEL, CUSCONTACT_TITLE, CUSTOMER, DATEREQUIRED, DELADDRESS, DUEDATE, EDITID, EMAIL, FLOWIDS, FROMID, FROMTRANS, FROMTYPEID, GROUPID, IGSTAMT, IMAGEID, INVOICED, ISACTIVE, LINKEDATTACHID, LINKEDMM, LINKEDSI, LISTNAME, LOCATION, NCRID, NCRNO, NOTE, ORDERID, OUTSTANDING, PODATE, POID, POSTADDRESS, REFERENCE, REFNO, SGSTAMT, SMS, SOID, SOID_WO, SPECIFICATION, STATUS, STATUSID, STATUSNOTE, SUBTOTAL, SUPCONTACTID, SUPCONTACT_FNAME, SUPCONTACT_SNAME, SUPCONTACT_TITLE, SUPID, SUPPLIER, SUPWARNING, TEL, TERMS, TERMSDISPLAY, TICKETID, TOTAL, TOTAL3, TOTALCURRENCY, TOTALEXEMPT, TOTALVAT3, TOTALVAT_TEXT, USERAUTH, USERCREATED, USERUPDATED, VATAMT, VATAMT3, VATNO, VATPER, VATTYPEID, VENDORNO, WOID, WORKFLOWID
PO_All: All the Purchase Orders on the list.
Fields (87)
ACCNO, APPROVAL, APPROVEID, BASEVALUE, BASEVALUE_OLD, BRANCH, BRANCHID, CAMPAIGNID, CATEGORY, CATEGORYID, CGSTAMT, CHECKLISTID, CONTACTTEL, CREDITTERMID, CURRENCY, CURRENCYID, CUSCONTACT, CUSCONTACT_EMAIL, CUSCONTACT_TEL, CUSCONTACT_TITLE, CUSTOMER, DATEREQUIRED, DELADDRESS, DUEDATE, EDITID, EMAIL, FLOWIDS, FROMID, FROMTRANS, FROMTYPEID, GROUPID, IGSTAMT, IMAGEID, INVOICED, ISACTIVE, LINKEDATTACHID, LINKEDMM, LINKEDSI, LISTNAME, LOCATION, NCRID, NCRNO, NOTE, ORDERID, OUTSTANDING, PODATE, POID, POSTADDRESS, REFERENCE, REFNO, SGSTAMT, SMS, SOID, SOID_WO, SPECIFICATION, STATUS, STATUSID, STATUSNOTE, SUBTOTAL, SUPCONTACTID, SUPCONTACT_FNAME, SUPCONTACT_SNAME, SUPCONTACT_TITLE, SUPID, SUPPLIER, SUPWARNING, TEL, TERMS, TERMSDISPLAY, TICKETID, TOTAL, TOTAL3, TOTALCURRENCY, TOTALEXEMPT, TOTALVAT3, TOTALVAT_TEXT, USERAUTH, USERCREATED, USERUPDATED, VATAMT, VATAMT3, VATNO, VATPER, VATTYPEID, VENDORNO, WOID, WORKFLOWID
PO_Items: The Purchase Order's lines, with their receive and invoice details.
Fields (64)
ACCOUNT, ACCOUNTID, ADJTYPEID, ADJUSTAMT, ADJUSTPERCENT, ASSETID, CAMPAIGNPRODUCTID, CATEGORY, CGSTAMT, CGSTPERCENT, CODE, DATEINVOICED, DATEISSUED, DATERECEIVED, DESCRIPTION, FIXEDCOST, FLOWIDS, FROMITEM, IGSTAMT, IGSTPERCENT, IMAGE, INEXID, ISSTOCK, LINKDOC, MATPRICEID, MATUNITID, NOTE, ORDERID, OUTQTY, OUTQTY_GRV, POID, POITEMID, PROCESSID, QTY, SGSTAMT, SGSTPERCENT, SOITEMID, SPECIFICATION, STOCKID, STOCKIDLU, SUBCATEGORY, SUPINVID_ITEM, SUPREF, TOTAL, TOTAL3, TOTALCOST, TOTALCURRENCY, TOTALUNIT, TOTALVAT, TOTALVAT3, TOTALWEIGHT, TYPE, UNIT, UNITCOST, UNITID, UNITQTY, UNITWEIGHT, VATAMT, VATAMT3, VATPERCENT, VATTYPEID, WOBOMID, WOID, WOPROCID
PO_All_Items: All the Purchase Order lines in the Items view.
Fields (1)
POID
PO_Filter: The data filters.
Fields (2)
BRANCH, DATEFILTER
PO_WO_Parts: The linked Work Order's JDF Switch parts.
Fields (38)
BLEED, BWCOVERID, BWPAGES, COLORS, COMPIDSTOCK, DEPTH, DESCRIPTION, ESTPARTID, FINISHING, ORDERID, OVERRIDEID, PAGEACROSS, PAGEBLEED, PAGEDEPTH, PAGEDOWN, PAGEROTATEID, PAGESPINE, PAGEWIDTH, PRINTING, QTY, QTYACROSS, QTYDOWN, QTYOUT, QTYOUTACROSS, QTYOUTDOWN, QTYUP, ROTATEDOUT, ROTATEID, STATUSID, STOCKDEPTH, STOCKDESCRIPTION, STOCKTYPEID, STOCKWIDTH, WIDTH, WOID, WOPARTID, WORKDEPTH, WORKWIDTH
PO_Approvals: The Purchase Order's checklist items.
Fields (6)
CHECKLISTTRANSID, CODE, DATEUPDATED, DESCRIPTION, NOTE, USERUPDATED

Supplier Invoices

The following Data Pipelines can be used on Supplier Invoice output templates.

plSupInv: The selected Supplier Invoice.
Fields (85)
ACCNO, AGEING, APPROVAL, APPROVEDSUBTOTAL, APPROVEDTOTAL, APPROVEDVAT, APPROVEID, BASEVALUE, BASEVALUE_OLD, BRANCH, BRANCHID, CAMPAIGNID, CATEGORY, CATEGORYID, CGSTAMT, CHECKLISTID, COMPANY, CONTACTCEL, CONTACTTEL, CREDITTERMID, CURRENCY, CURRENCYID, DATECREATED, DATEUPDATED, DUEDATE, EDITID, FLOWIDS, FROMID, FROMTRANS, FROMTYPEID, GROUPID, IGSTAMT, IMAGEID, INSTRUCTION, INVDATE, INVOICENO, LEDGERID, LINKEDATTACHID, NOTE, NOTE2, OUTAMT, OUTSTANDING, PERIODDATE, PODATE, POMAINID, PORDEREXEMPT, PORDERREF, PORDERSUBTOTAL, PORDERSUP, PORDERTOTAL, PORDERVAT, REFERENCE, REFNO, SGSTAMT, SOID, SOID_WO, STATUS, STATUSID, STATUSID_ACCOUNTING, STATUSNOTE, STOCKMOVEMENTID, SUPCONTACT, SUPCONTACTID, SUPID, SUPINVID, SUPPLIERNAME, TERMS, TERMSDISPLAY, TICKETID, TOTAL3, TOTALCURRENCY, TOTALVAT3, TOTALVAT3_TEXT, TOTALVAT_TEXT, TRANSID, USERCREATED, USERUPDATED, VATAMT3, VATNO, VATPERCENT, VATRECONID, WARNING, WARN_ACCOUNTITEM, WOID, WORKFLOWID
plSupInvAll: All the Supplier Invoices on the list.
Fields (85)
ACCNO, AGEING, APPROVAL, APPROVEDSUBTOTAL, APPROVEDTOTAL, APPROVEDVAT, APPROVEID, BASEVALUE, BASEVALUE_OLD, BRANCH, BRANCHID, CAMPAIGNID, CATEGORY, CATEGORYID, CGSTAMT, CHECKLISTID, COMPANY, CONTACTCEL, CONTACTTEL, CREDITTERMID, CURRENCY, CURRENCYID, DATECREATED, DATEUPDATED, DUEDATE, EDITID, FLOWIDS, FROMID, FROMTRANS, FROMTYPEID, GROUPID, IGSTAMT, IMAGEID, INSTRUCTION, INVDATE, INVOICENO, LEDGERID, LINKEDATTACHID, NOTE, NOTE2, OUTAMT, OUTSTANDING, PERIODDATE, PODATE, POMAINID, PORDEREXEMPT, PORDERREF, PORDERSUBTOTAL, PORDERSUP, PORDERTOTAL, PORDERVAT, REFERENCE, REFNO, SGSTAMT, SOID, SOID_WO, STATUS, STATUSID, STATUSID_ACCOUNTING, STATUSNOTE, STOCKMOVEMENTID, SUPCONTACT, SUPCONTACTID, SUPID, SUPINVID, SUPPLIERNAME, TERMS, TERMSDISPLAY, TICKETID, TOTAL3, TOTALCURRENCY, TOTALVAT3, TOTALVAT3_TEXT, TOTALVAT_TEXT, TRANSID, USERCREATED, USERUPDATED, VATAMT3, VATNO, VATPERCENT, VATRECONID, WARNING, WARN_ACCOUNTITEM, WOID, WORKFLOWID
plSupInvItems: The Supplier Invoice's lines.
Fields (54)
ACCOUNT, ACCOUNTID, ADJTYPEID, ADJUSTAMT, ADJUSTPERCENT, ASSETID, CATEGORY, CGSTAMT, CGSTPERCENT, CODE, DESCRIPTION, FIXEDCOST, FLOWIDS, FROMITEM, IGSTAMT, IGSTPERCENT, INEXID, MATPRICEID, MATUNITID, NOTE, ORDERID, OUTQTY, POID_ITEM, POITEMID, PROCESSID, QTY, SETUPPRICE, SGSTAMT, SGSTPERCENT, SOID_ITEM, SOITEMID, STOCKID, STOCKMOVEITEMID, SUBCATEGORY, SUPINVID, SUPINVITEMID, TOTAL, TOTAL3, TOTALCOST, TOTALCURRENCY, TOTALUNIT, TOTALVAT, TOTALVAT3, UNIT, UNITCOST, UNITID, UNITQTY, VATAMT, VATAMT3, VATPERCENT, VATTYPEID, WOBOMID, WOID_ITEM, WOPROCID
SupInv_All_Items: All the Supplier Invoice lines in the Items view.
Fields (42)
ACCOUNTID, ADJTYPEID, AGEING, BRANCH, CGSTAMT, CODE, CURRENCY, DESCRIPTION, DUEDATE, FROMTRANS, IGSTAMT, INEXID, INVDATE, INVOICENO, LEDGERID, ORDERID, POID_ITEM, POMAINID, QTY, REFERENCE, SGSTAMT, SOID, SOID_ITEM, STATUSID, SUPINVID, SUPINVITEMID, SUPPLIER, TOTAL, TOTAL3, TOTALUNIT, TOTALVAT, TOTALVAT3, TRANSID, UNIT, UNITCOST, VATAMT, VATAMT3, VATPERCENT, VATTYPEID, VAT_SI, WOID, WOID_ITEM
SupInv_Approvals: The Supplier Invoice's checklist items.
Fields (6)
CHECKLISTTRANSID, CODE, DATEUPDATED, DESCRIPTION, NOTE, USERUPDATED

Supplier Debit Notes

The following Data Pipelines can be used on Supplier Debit Note output templates.

SCredit_Rec: The selected Debit Note.
Fields (71)
ACCNO, BASEVALUE, BASEVALUE_OLD, BRANCH, BRANCHID, CAMPAIGNID, CATEGORYID, CGSTAMT, COMPANY, CONTACT, CONTACTCEL, CONTACTTEL, CURRENCY, CURRENCYID, DATECREATED, DATEUPDATED, EDITID, EMAIL, FAX, FLOWIDS, FROMID, FROMTRANS, FROMTYPEID, GROUPID, IGSTAMT, IMAGEID, INVID, INVOICENO, JOBCATEGORY, LEDGERID, LINKEDMM, NOTE, OUTSTANDING, POID, POSTADDRESS, REFERENCE, SCDATE, SCMAINID, SDNNO, SGSTAMT, SMS, SOID, SOID_WO, STAFFIDUSER, STATUS, STATUSID, STATUSID_ACCOUNTING, STATUSNOTE, SUBTOTAL, SUPCONTACTID, SUPID, TEL, TICKETID, TOTAL, TOTAL3, TOTALCURRENCY, TOTALVAT3, TOTALVAT3_TEXT, TOTALVAT_TEXT, TRANSID, USERCREATED, USERUPDATED, VATAMT, VATAMT3, VATNO, VATPERCENT, VATRECONID, WARNING, WARN_ACCOUNTITEM, WOID, WORKFLOWID
SCredit_All: All the Debit Notes on the list.
Fields (71)
ACCNO, BASEVALUE, BASEVALUE_OLD, BRANCH, BRANCHID, CAMPAIGNID, CATEGORYID, CGSTAMT, COMPANY, CONTACT, CONTACTCEL, CONTACTTEL, CURRENCY, CURRENCYID, DATECREATED, DATEUPDATED, EDITID, EMAIL, FAX, FLOWIDS, FROMID, FROMTRANS, FROMTYPEID, GROUPID, IGSTAMT, IMAGEID, INVID, INVOICENO, JOBCATEGORY, LEDGERID, LINKEDMM, NOTE, OUTSTANDING, POID, POSTADDRESS, REFERENCE, SCDATE, SCMAINID, SDNNO, SGSTAMT, SMS, SOID, SOID_WO, STAFFIDUSER, STATUS, STATUSID, STATUSID_ACCOUNTING, STATUSNOTE, SUBTOTAL, SUPCONTACTID, SUPID, TEL, TICKETID, TOTAL, TOTAL3, TOTALCURRENCY, TOTALVAT3, TOTALVAT3_TEXT, TOTALVAT_TEXT, TRANSID, USERCREATED, USERUPDATED, VATAMT, VATAMT3, VATNO, VATPERCENT, VATRECONID, WARNING, WARN_ACCOUNTITEM, WOID, WORKFLOWID
SCredit_Items: The Debit Note's lines.
Fields (45)
ACCOUNT, ACCOUNTID, ADJPERCENT, ADJTYPEID, ADJUSTMENT, CGSTAMT, CGSTPERCENT, CODE, DESCRIPTION, FIXEDCOST, FLOWIDS, FROMITEM, IGSTAMT, IGSTPERCENT, INEXID, INVITEMID, MATCATEGORY, MATUNITID, MRPID, NOTE, ORDERID, PROCESSID, QTY, SCITEMID, SCMAINID, SGSTAMT, SGSTPERCENT, STATUSID, STOCKID, STOCKLOCATION, TOTAL, TOTAL3, TOTALCOST, TOTALCURRENCY, TOTALUNIT, TOTALVAT, TOTALVAT3, UNIT, UNITID, UNITPRICE, UNITQTY, VATAMT, VATAMT3, VATPERCENT, VATTYPEID
SC_All_Items: All the Debit Note lines in the Items view.
Fields (22)
BRANCH, CGSTAMT_SC, COMPANY, CONTACT, CURRENCY, DATECREATED, DATEUPDATED, IGSTAMT_SC, IMAGEID, INVID, LEDGERID, REFERENCE, SCDATE, SCMAINID, SDNNO, SGSTAMT_SC, STATUSID, TOTALCURRENCY_SC, TOTAL_SC, TRANSID, USERCREATED, VATAMT_SC

Materials Movements

The following Data Pipelines can be used on Materials Movement output templates.

plMatMove: The selected Materials Movement.
Fields (47)
APPROVAL, APPROVEID, BRANCH, BRANCHID, CAMPAIGNID, CCMAINID, CHECKLISTID, CUSID, CUSTOMER, DATEEXPIRY, DATEUPDATED, DEFAULTID, DELID, EDITID, FLOWIDS, FROMID, FROMTRANS, FROMTYPEID, GROUPID, IMAGEID, LEDGERID, NCRID, NOTE, POID, REFERENCE, SCMAINID, SOID, SOID_WO, STATUS, STATUSID, STATUSID_ACCOUNTING, STATUSID_STOCK, STATUSNOTE, STOCKDATE, STOCKMOVEMENTID, SUPID, SUPPLIER, TICKETID, TOTAL, TRANSID, TRANSTYPE, TRANSTYPEID, USERCREATED, USERUPDATED, VATRECONID, WOID, WORKFLOWID
plMatMoveAll: All the Materials Movements on the list.
Fields (47)
APPROVAL, APPROVEID, BRANCH, BRANCHID, CAMPAIGNID, CCMAINID, CHECKLISTID, CUSID, CUSTOMER, DATEEXPIRY, DATEUPDATED, DEFAULTID, DELID, EDITID, FLOWIDS, FROMID, FROMTRANS, FROMTYPEID, GROUPID, IMAGEID, LEDGERID, NCRID, NOTE, POID, REFERENCE, SCMAINID, SOID, SOID_WO, STATUS, STATUSID, STATUSID_ACCOUNTING, STATUSID_STOCK, STATUSNOTE, STOCKDATE, STOCKMOVEMENTID, SUPID, SUPPLIER, TICKETID, TOTAL, TRANSID, TRANSTYPE, TRANSTYPEID, USERCREATED, USERUPDATED, VATRECONID, WOID, WORKFLOWID
plMatMovetems: The Materials Movement's lines.
Fields (36)
CATEGORY, CCITEMID, CODE, CRACCOUNTID, CUSTOMER, DELITEMID, DESCRIPTION, DRACCOUNTID, FIXEDCOST, FLOWIDS, FROMITEM, LOCATION, MATUNITID, NOTE, ORDERID, OUTQTY, POITEMID, QTY, QTYINSTOCK, SCITEMID, SOITEMID, STOCKID, STOCKMOVEITEMID, STOCKMOVEMENTID, SUBCAT, TOTAL, TOTALUNIT, TRACKING, TRACKINGID, TRACKING_STR, UNIT, UNITCOST, UNITID, UNITQTY, WOBOMID, WOOUTPUTID
MM_Items_All: All the Materials Movement lines in the Items view.
Fields (39)
BRANCH, CAMPAIGNID, CATEGORY, CODE, CRACCOUNTID, CUSTOMER, CUSTOMERMMI, DELID, DESCRIPTION, DRACCOUNTID, FIXEDCOST, FROMITEM, FROMTRANS, LOCATION, MATUNITID, NOTE, ORDERID, POID, QTY, QTYINSTOCK, REFERENCE, SOID, STATUSID, STOCKDATE, STOCKMOVEITEMID, STOCKMOVEMENTID, SUBCAT, SUPPLIER, TOTAL, TOTALUNIT, TOTAL_MM, TRACKING, TRACKING_STR, TRANSTYPE, UNIT, UNITCOST, UNITQTY, USERCREATED, WOID
MM_Approvals: The Materials Movement's checklist items.
Fields (6)
CHECKLISTTRANSID, CODE, DATEUPDATED, DESCRIPTION, NOTE, USERUPDATED

Materials and Inventory

The following Data Pipelines can be used on Materials and Inventory output templates.

Mat_Rec: The selected material.
Fields (59)
ACCOUNTIDCOS, ACCOUNTIDINV, ACCOUNTIDSALES, ADJUSTPERCENT, APPROVAL, CATEGORY, CODE, CODEDESC, COLORID, COMPANY, COSTINGS, COUNTCOSTING, CUSADDRESS, CUSDELADDRESS, CUSID, DATACHECKID, DATAOK, DEPTH, DESCRIPTION, ESTIMATE, FORMAT_DESC, FORMAT_SPEC, HEIGHT, IMAGE, INSTRUCTION, ISADJUST, ISDESC, ISFINGOODS, LINKEDATTACHID, MATCATID, MATUNITID, MRPID, NAMEFIELD, NUMBERFIELD, NUMBERFIELD2, PHMATUNITID, PRICETYPE, PRICETYPEID, REFERENCE, ROUNDUPQTY, SHOWCUSID, SPECIFICATION, STATUSID, STATUSNOTE, STOCKCOUNT, SUBCAT, TEXTFIELD, TRACKINGID, TYPEID, UNIT, UNITID, UNITWEIGHT, USERDATEUPDATED, USERID_UPDATED, VALUES_DESC, VALUES_SPEC, WEIGHT, WEIGHT_UNIT, WIDTH
Mat_All: All the materials on the list.
Fields (59)
ACCOUNTIDCOS, ACCOUNTIDINV, ACCOUNTIDSALES, ADJUSTPERCENT, APPROVAL, CATEGORY, CODE, CODEDESC, COLORID, COMPANY, COSTINGS, COUNTCOSTING, CUSADDRESS, CUSDELADDRESS, CUSID, DATACHECKID, DATAOK, DEPTH, DESCRIPTION, ESTIMATE, FORMAT_DESC, FORMAT_SPEC, HEIGHT, IMAGE, INSTRUCTION, ISADJUST, ISDESC, ISFINGOODS, LINKEDATTACHID, MATCATID, MATUNITID, MRPID, NAMEFIELD, NUMBERFIELD, NUMBERFIELD2, PHMATUNITID, PRICETYPE, PRICETYPEID, REFERENCE, ROUNDUPQTY, SHOWCUSID, SPECIFICATION, STATUSID, STATUSNOTE, STOCKCOUNT, SUBCAT, TEXTFIELD, TRACKINGID, TYPEID, UNIT, UNITID, UNITWEIGHT, USERDATEUPDATED, USERID_UPDATED, VALUES_DESC, VALUES_SPEC, WEIGHT, WEIGHT_UNIT, WIDTH
Mat_Cat: The Material Categories.
Fields (17)
BRANCHID, DEFAULTPAPERID, DEFAULTUNIT, FORMAT_DESC, FORMAT_SPEC, ITEMCOUNT, LOCATION, LOCATIONID, MATCATID, NAME, PHCATID, POSPRINTER, POSTEMPLATE, PRICETYPEID, SHOWCUSID, TYPEID, UNIT
Mat_Sup_Prices: The material's supplier prices.
Fields (30)
ADJPERCENT, BARCODE, BASEUNIT, CURRENCYID, DISCOUNTS, ESTID, INEXID, LEADDAYS, LISTPRICE, LISTPRICEQTY, LISTPRICE_VAT, MATPRICEID, MATUNITID, MINQTY, PHMATPRICEID, PRICECURRENCY, PRICECURRENCY_VAT, SUPID, SUPPLIER, SUPREF, TOTAL, TYPEFLEXODIEID, UNIT, UNITID, UPDATED, USERUPDATED, USER_DATEUPDATED, VATTYPEID, X_BASE, X_UNIT
Mat_Units_Prices: The material's units and prices.
Fields (25)
BARCODE, COSTPRICE, COUNTCOSTING, DATEUPDATED, DUPLICATE, ESTID, INEXID, MARGIN, MARKUP, MATCOSTID, MATUNITID, PRICEQTY, QTY, QTY_FROM, QTY_TO, SELLPRICE, SELLPRICE_VAT, SETCOSTADJPERCENT, UNIT, UNITID, UPDATEID, USERUPDATED, USER_DATEUPDATED, VATPERCENT, VATTYPEID
Mat_Depend: The material's dependencies: the records on its Dependencies tab, such as the Quotations that use it (see Dependencies (tab)).
Fields (7)
CATEGORY, DESCRIPTION, ID, MATQUOTEID, QUOTENO, SPECIFICATION, STATUSID
Mat_Signages_All: All the signage materials.
Fields (52)
BLEEDHEIGHT, BLEEDOFFSETX, BLEEDOFFSETY, BLEEDSQM, BLEEDWIDTH, COMPDRAGONTAILS, COMPEYELETS, COMPHEM, COMPPACK, COMPPOCKET, COMPPRINT, COMPREINFORCING, COMPSTOCK, COMPWINDSLOTS, CUSADDRESS, CUSTOMER, DELADDRESS, ENQID, ESTPRICEID, ESTTOTALCOST, ESTTOTALSELL, ESTTOTALSQM, FINALHEIGHT, FINALSQM, FINALWIDTH, IMAGE, ITEMCODE, ITEMCOSTPRICE, ITEMDESCRIPTION, ITEMSELLPRICE, MARGIN, MATQUOTEID, MATUNITID, OVERLAP, OVERRIDEIDPRICING, PANEL, PANELOVERLAP, PANELWIDTH, PRICINGHEIGHT, PRICINGSQM, PRICINGWIDTH, PROFIT, QUOTEID, QUOTEITEMID, SIGNAGEID, SIGNAGETYPE, TRIMHEIGHT, TRIMSQM, TRIMWIDTH, VISUALHEIGHT, VISUALSQM, VISUALWIDTH
Mat_Signage_Rec: The selected signage material.
Fields (52)
BLEEDHEIGHT, BLEEDOFFSETX, BLEEDOFFSETY, BLEEDSQM, BLEEDWIDTH, COMPDRAGONTAILS, COMPEYELETS, COMPHEM, COMPPACK, COMPPOCKET, COMPPRINT, COMPREINFORCING, COMPSTOCK, COMPWINDSLOTS, CUSADDRESS, CUSTOMER, DELADDRESS, ENQID, ESTPRICEID, ESTTOTALCOST, ESTTOTALSELL, ESTTOTALSQM, FINALHEIGHT, FINALSQM, FINALWIDTH, IMAGE, ITEMCODE, ITEMCOSTPRICE, ITEMDESCRIPTION, ITEMSELLPRICE, MARGIN, MATQUOTEID, MATUNITID, OVERLAP, OVERRIDEIDPRICING, PANEL, PANELOVERLAP, PANELWIDTH, PRICINGHEIGHT, PRICINGSQM, PRICINGWIDTH, PROFIT, QUOTEID, QUOTEITEMID, SIGNAGEID, SIGNAGETYPE, TRIMHEIGHT, TRIMSQM, TRIMWIDTH, VISUALHEIGHT, VISUALSQM, VISUALWIDTH
Stk_Check: The Stock Check count.
Fields (29)
BINREF, CATEGORY, CODE, COMPANY, DATEUPDATED, DESCRIPTION, LOCATION, LOCATIONID, MATUNITID, NOTE, QTY_ACT, QTY_COUNT, QTY_COUNT_BASE, QTY_EST, QTY_EST_BASE, QTY_VAR, REFERENCE, STATUSID, STOCKCHECKCOUNTID, STOCKCHECKDATE, STOCKCHECKID, STOCKID, SUBCAT, UNITBASE, UNITCOUNT, UNITID, USERCREATED, USERDATEUPDATED, USERUPDATED
Stk_Trans: The selected Transfer Order.
Fields (36)
ADDRESSFROM, ADDRESSTO, ARRIVALDATE, COLORID, DATECREATED_TOI, DATECREATED_TOR, DATEUPDATED_TOI, DATEUPDATED_TOR, DELADDRESS, DUEDATE, IMAGEID, LEDGERID_TOI, LEDGERID_TOR, LOCATION, LOCATIONFROM, LOCATIONIDFROM, LOCATIONIDTO, LOCATIONTO, NOTE, REFERENCE, SENDDATE, STAFFIDUSER, STATUS, STATUSID, STATUSNOTE, STRMAINID, TRANSDATE, TRANSID_TOI, TRANSID_TOR, USERCREATED, USERCREATED_TOI, USERCREATED_TOR, USERUPDATED, USERUPDATED_TOI, USERUPDATED_TOR, WORKFLOWID
Stk_Trans_Items: The Transfer Order's lines.
Fields (16)
DESCRIPTION, ITEMCODE, MATUNITID, NOTE, ORDERID, QTY, QTYISSUED, QTYRECEIVED, STOCKIDFROM, STOCKIDTO, STRITEMID, STRMAINID, TOTAL, UNIT, UNITID, UNITPRICE
Svc_All: All the services.
Fields (43)
ACCOUNTIDCOS, ACCOUNTIDSALES, ADJUSTPERCENT, BRANCHID, CATEGORY, CCENTREID, CCENTRENAME, COSTQTY, COSTTYPE, DESCRIPTION, FIXEDEXTCOST, FIXEDEXTCOST_COST, FIXEDEXTCOST_VAT, INEXID, INSTRUCTION, ISACTIVE, ISADJUST, ISDESC, ISUPDATE, MINCOST, MROVERS_FIN, MRTIME, PHID, PROCCATID, PROCESSID, QTYTYPE, QTY_TYPEID, QUOTEDESCRIPTION, RATE, ROUNDUPQTY, RUNOVERS_FIN, SOURCE, SPEED, SPEEDQTY, SUPID, SUPPLIERNAME, UNIT, UNITEXTCOST, UNITEXTCOST_COST, UNITEXTCOST_VAT, UPDATED, VATPERCENT, VATTYPEID
Svc_Cat: The Service Categories.
Fields (10)
BRANCHID, COSTTYPE, ISACTIVE, ISC1000, ITEMCOUNT, NAME, PHCATID, POSPRINTER, POSTEMPLATE, PROCCATID
Inventory_Default: The Inventory Report (Default view).
Fields (35)
ADJUSTED, BINREF, CATEGORY, CODE, CUSTOMER, DESCRIPTION, DIF_QTY, DIF_VALUE, INSTOCKEND, INSTOCKSTART, LASTPOID, LASTPONO, LOCATION, MATUNITID, PRICEADJPERCENT, PRICE_CURRENT, PRICE_END, PRICE_START, QTYAVAILABLE, QTYINSTOCK, QTYMIN, QTYONORDER, QTYREORDER, QTYRESERVED, QTY_ISSUE, QTY_RECEIVE, STATUS, STOCKID, SUBCATEGORY, UNIT, VALUE_ADJUSTED, VALUE_END, VALUE_ISSUE, VALUE_RECEIVE, VALUE_START
Inventory_Trans: The Inventory Report transactions.
Fields (24)
CATEGORY, CODE, COMPANY, CUSTOMER, DESCRIPTION, DOCID, ID, ITEMID, LOCATION, MATUNITID, QTY, QTYSTOCK, REFERENCE, STATUS, STOCKTRANS, SUBCAT, TOTAL, TOTALSTOCK, TRANSDATE, TRANSTYPE, TYPEID, UNIT, UNITPRICE, USERNAME
Inventory_Checks: The Stock Checks.
Fields (23)
BINREF, CATEGORY, CODE, CUSTOMER, DESCRIPTION, LOCATION, MATUNITID, QTYMIN, QTYREORDER, SC_DATE, SC_PRICE, SC_PRICEQTY, SC_QTYACT, SC_QTYDIF, SC_QTYEST, SC_STATUSID, SC_VALUEDIF, STATUS, STOCKCHECKID, STOCKID, SUBCATEGORY, UNIT, UNITID
Inventory_Register: The inventory register.
Fields (16)
DESCRIPTION, DOCID, LOCATION, QTY, QTY_BALANCE, QTY_ISSUE, QTY_RECEIVE, QTY_TRANS, TRANSCODE, TRANSDATE, TRANSID, UNIT, UNITPRICE, UNITPRICE_TRANS, UNIT_TRANS, USERUPDATED
Inventory_Ageing: The inventory ageing.
Fields (28)
CATEGORY, CODE, CUSTOMER, DAYS120, DAYS180, DAYS30, DAYS60, DAYS90, DESCRIPTION, LOCATION, MATUNITID, REP, STATUSID, STOCKID, SUBCAT, TOTAL, TOTAL_AMOUNT, TOTAL_DAYS120, TOTAL_DAYS180, TOTAL_DAYS30, TOTAL_DAYS60, TOTAL_DAYS90, TOTAL_YEAR1, TOTAL_YEAR2, TOTAL_YEAR2PLUS, YEAR1, YEAR2, YEAR2PLUS
Inventory_Batch_Tracking: The batch tracking.
Fields (22)
AGEINGDAYS, CODE, COLORID_WO, CUSTOMER, DATEEXPIRY, DATEMMR, DESCRIPTION, MATUNITID, MMITRANS, MMRTRANS, QTYISSUED, QTYRECEIVED, REFERENCE, STATUSID, STATUS_WO, SUBCAT, TOTALCOST, TOTALQTY, TOTALVALUE, UNITCOST, UNITPRICE, WOID
Inventory_Filters: The data filters.
Fields (2)
BRANCH, DATEFILTER

Invoicing and Accounting

Customer Invoices

The following Data Pipelines can be used on Customer Invoice output templates.

CI_Rec: The selected invoice.
Fields (104)
ACCNO, ADDRESSIDBILLING, ADJAMOUNT, ADJPERCENT, ADJUSTEDTOTAL, AGEING, BASEVALUE, BASEVALUE_OLD, BILLING, BRANCH, BRANCHID, CAMPAIGNID, CATEGORY, CATEGORYID, CGSTAMT, CONTACT, CONTACTCEL, CONTACTTITLE, CREDITTERMID, CURRENCY, CURRENCYID, CUSCONTACTID, CUSFAX, CUSID, CUSNOTE, CUSORDERNO, CUSTEL, CUSTELFAX, CUSTOMER, DATECREATED, DATEUPDATED, DELADDRESS, DELID, DELIVERY, DELIVERYID, DEPOSIT, DESCRIPTION, DUEDATE, EDITID, EMAIL, EMAILCONTACT, FIRSTNAME, FLOWIDS, FROMID, FROMTRANS, FROMTYPEID, GROUPID, IGSTAMT, IMAGEID, INVDATE, INVID, INVNO, JOBCATEGORY, LEDGERID, LINKEDATTACHID, LINKEDDN, NCRNO, NOTES, OUTSTANDING, POSTADDRESS, PRINTED, REF1, REF2, REF3, REFNO, REGIONID, REGISTEREDNAME, REGNO, REP, REPNAME, REPSIGNATURE, SGSTAMT, SMS, SNAPSCAN, SODATE, SOID, STAFFIDREP, STATUS, STATUSID, STATUSID_ACCOUNTING, STATUSNOTE, SUBTOTAL, TERMS, TERMSDISPLAY, TICKETID, TOTAL, TOTAL3, TOTALCURRENCY, TOTALVAT3, TOTALVAT3_TEXT, TOTALVAT_TEXT, TRANSID, USERCREATED, USERDELETED, USERUPDATED, VATAMT, VATAMT3, VATNO, VATPER, VATRECONID, VENDORNO, WARNING, WARN_ACCOUNTITEM, WORKFLOWID
CI_All: All the invoices on the list.
Fields (104)
ACCNO, ADDRESSIDBILLING, ADJAMOUNT, ADJPERCENT, ADJUSTEDTOTAL, AGEING, BASEVALUE, BASEVALUE_OLD, BILLING, BRANCH, BRANCHID, CAMPAIGNID, CATEGORY, CATEGORYID, CGSTAMT, CONTACT, CONTACTCEL, CONTACTTITLE, CREDITTERMID, CURRENCY, CURRENCYID, CUSCONTACTID, CUSFAX, CUSID, CUSNOTE, CUSORDERNO, CUSTEL, CUSTELFAX, CUSTOMER, DATECREATED, DATEUPDATED, DELADDRESS, DELID, DELIVERY, DELIVERYID, DEPOSIT, DESCRIPTION, DUEDATE, EDITID, EMAIL, EMAILCONTACT, FIRSTNAME, FLOWIDS, FROMID, FROMTRANS, FROMTYPEID, GROUPID, IGSTAMT, IMAGEID, INVDATE, INVID, INVNO, JOBCATEGORY, LEDGERID, LINKEDATTACHID, LINKEDDN, NCRNO, NOTES, OUTSTANDING, POSTADDRESS, PRINTED, REF1, REF2, REF3, REFNO, REGIONID, REGISTEREDNAME, REGNO, REP, REPNAME, REPSIGNATURE, SGSTAMT, SMS, SNAPSCAN, SODATE, SOID, STAFFIDREP, STATUS, STATUSID, STATUSID_ACCOUNTING, STATUSNOTE, SUBTOTAL, TERMS, TERMSDISPLAY, TICKETID, TOTAL, TOTAL3, TOTALCURRENCY, TOTALVAT3, TOTALVAT3_TEXT, TOTALVAT_TEXT, TRANSID, USERCREATED, USERDELETED, USERUPDATED, VATAMT, VATAMT3, VATNO, VATPER, VATRECONID, VENDORNO, WARNING, WARN_ACCOUNTITEM, WORKFLOWID
CI_Items: The invoice's lines.
Fields (59)
ACCOUNT, ACCOUNTID, ADJAMT, ADJPERCENT, ADJTYPEID, CATEGORY, CGSTAMT, CGSTPERCENT, CODE, DELITEMID, DELNO, DESCRIPTION, DIRECTCOST, FIXEDCOST, FIXEDSELL, FLOWIDS, FROMITEM, GROUPNAME, IGSTAMT, IGSTPERCENT, INEXID, INVID, INVITEMID, LINKEDWONO, MATCOSTID, MATUNITID, NOTE, ORDERID, PROCESSID, QTY, QUOTENO, REFNO, SGSTAMT, SGSTPERCENT, SOID, SOITEMID, SPECIFICATION, STOCKID, STOCKMOVEITEMID, SUBCATEGORY, SUBTOTALCOST, TOTAL, TOTAL1000, TOTAL3, TOTALCOST, TOTALCURRENCY, TOTALUNIT, TOTALVAT, TOTALVAT3, TYPEID, UNIT, UNITCOST, UNITID, UNITQTY, UNITSELL, VATAMT, VATAMT3, VATPERCENT, VATTYPEID
CI_All_Items: All the invoice lines in the Items view.
Fields (66)
ACCOUNT, ACCOUNTID, ADJAMT, ADJPERCENT, ADJTYPEID, AGEING, BRANCH, CATEGORY, CATEGORY_ITEM, CGSTAMT, CODE, CURRENCY, CUSCATEGORY, CUSORDERNO, CUSTOMER, CUSUSERCREATED, DELID, DELITEMID, DELIVERY, DESCRIPTION, DIRECTCOST, DUEDATE, FROMITEM, FROMTRANS, IGSTAMT, INEXID, INVDATE, INVID, INVITEMID, INVNO, LEDGERID, LINKWOIDS, MARGIN, MATCATEGORY, MATUNITID, ORDERID, OUTSTANDING, PROFIT, QTY, QUOTENO, REF1, REGIONID, REP, SGSTAMT, SOID, SOITEMID, STATUSID, SUBCATEGORY, TOTAL, TOTAL3, TOTALCOST, TOTALCURRENCY, TOTALCURRENCY_INV, TOTALUNIT, TOTALVAT, TOTALVAT3, TOTALVAT_INV, TOTAL_INV, TRANSID, UNIT, USERCREATED, VATAMT, VATAMT3, VATAMT_INV, VATPERCENT, VATTYPEID
CI_Linked_Del: The Delivery Notes (and their items) linked to the invoice. If the invoice was created from a Delivery Note, only that Delivery Note is included. If it was created from a Sales Order, all the Delivery Notes linked to the Sales Order are included. The SIGNDOC field holds the signed Delivery Note.
Fields (47)
BRANCHID, CAMPAIGNID, CODE, CREDITTERMID, CUSCONTACTID, CUSID, CUSORDERNO, DATECREATED, DATEUPDATED, DELADDRESS, DELDATE, DELID, DELITEMID, DELIVERYID, DESCRIPTION, DUEDATE, FLOWIDS, FROMID, FROMTYPEID, MATCOSTID, MATUNITID, NOTE, NOTES, ORDERID, PARCELQTY, PERIODID, QTY, QTYPERPARCEL, REF1, REFNO, SIGNDOC, SOID, SOITEMID, SPECIFICATION, STAFFIDASSIGN, STAFFIDREP, STATUSID, STATUSNOTE, STOCKID, TICKETID, UNIT, UNITID, USERCREATED, USERUPDATED, WAYBILLNO, WOID, WOOUTPUTID
CI_Linked_Receipts: The receipts allocated to the invoice.
Fields (21)
ALLOCATED, ALLOCATED3, BRANCHID, COMPANYID, DOCNO, ENTRYTYPEID, NOTE, PERIODDATE, REFERENCE, TOTAL, TOTAL3, TOTALCURRENCY, TOTALVAT, TOTALVAT3, TRANSDATE, TRANSID, UNALLOCATED, UNALLOCATED3, USERCREATED, VATAMT, VATAMT3
CI_Linked_WO: The linked Work Orders.
Fields (5)
CUSORDERNO, QTY, REFERENCE, WODATE, WOID

Customer Credit Notes

The following Data Pipelines can be used on Customer Credit Note output templates.

CC_Rec: The selected Credit Note.
Fields (74)
ACCNO, ADDRESSIDBILLING, BASEVALUE, BASEVALUE_OLD, BILLING, BRANCH, BRANCHID, CAMPAIGNID, CATEGORYID, CCDATE, CCMAINID, CCNO, CGSTAMT, COMPANY, CONTACT, CONTACTCEL, CONTACTTITLE, CURRENCY, CURRENCYID, CUSCONTACTID, CUSID, DATECREATED, DATEUPDATED, EDITID, EMAIL, FAX, FLOWIDS, FROMID, FROMTRANS, FROMTYPEID, GROUPID, IGSTAMT, IMAGEID, INVID, INVNO, JOBCATEGORY, LEDGERID, LINKEDMM, NCRID, NOTE, OUTSTANDING, POSTADDRESS, REFERENCE, REGISTEREDNAME, REP, SGSTAMT, SMS, SOID, STAFFIDREP, STAFFIDUSER, STATUS, STATUSID, STATUSID_ACCOUNTING, STATUSNOTE, SUBTOTAL, TEL, TICKETID, TOTAL, TOTAL3, TOTALCURRENCY, TOTALVAT3, TOTALVAT3_TEXT, TOTALVAT_TEXT, TRANSID, USERCREATED, USERUPDATED, VATAMT, VATAMT3, VATNO, VATPERCENT, VATRECONID, WARNING, WARN_ACCOUNTITEM, WORKFLOWID
CC_All: All the Credit Notes on the list.
Fields (74)
ACCNO, ADDRESSIDBILLING, BASEVALUE, BASEVALUE_OLD, BILLING, BRANCH, BRANCHID, CAMPAIGNID, CATEGORYID, CCDATE, CCMAINID, CCNO, CGSTAMT, COMPANY, CONTACT, CONTACTCEL, CONTACTTITLE, CURRENCY, CURRENCYID, CUSCONTACTID, CUSID, DATECREATED, DATEUPDATED, EDITID, EMAIL, FAX, FLOWIDS, FROMID, FROMTRANS, FROMTYPEID, GROUPID, IGSTAMT, IMAGEID, INVID, INVNO, JOBCATEGORY, LEDGERID, LINKEDMM, NCRID, NOTE, OUTSTANDING, POSTADDRESS, REFERENCE, REGISTEREDNAME, REP, SGSTAMT, SMS, SOID, STAFFIDREP, STAFFIDUSER, STATUS, STATUSID, STATUSID_ACCOUNTING, STATUSNOTE, SUBTOTAL, TEL, TICKETID, TOTAL, TOTAL3, TOTALCURRENCY, TOTALVAT3, TOTALVAT3_TEXT, TOTALVAT_TEXT, TRANSID, USERCREATED, USERUPDATED, VATAMT, VATAMT3, VATNO, VATPERCENT, VATRECONID, WARNING, WARN_ACCOUNTITEM, WORKFLOWID
CC_Items: The Credit Note's lines.
Fields (47)
ACCOUNT, ACCOUNTID, ADJPERCENT, ADJTYPEID, ADJUSTMENT, CCITEMID, CCMAINID, CGSTAMT, CGSTPERCENT, CODE, DESCRIPTION, FIXEDCOST, FIXEDSELL, FLOWIDS, FROMITEM, IGSTAMT, IGSTPERCENT, INEXID, INVITEMID, MATCATEGORY, MATUNITID, NOTE, ORDERID, PROCESSID, QTY, SGSTAMT, SGSTPERCENT, STATUSID, STOCKID, STOCKLOCATION, TOTAL, TOTAL3, TOTALCOST, TOTALCURRENCY, TOTALUNIT, TOTALVAT, TOTALVAT3, TYPEID, UNIT, UNITCOST, UNITID, UNITPRICE, UNITQTY, VATAMT, VATAMT3, VATPERCENT, VATTYPEID
CC_All_Items: All the Credit Note lines in the Items view.
Fields (25)
BRANCH, CCDATE, CCMAINID, CCNO, CGSTAMT_CC, COMPANY, CONTACT, CURRENCY, DATECREATED, DATEUPDATED, IGSTAMT_CC, IMAGEID, INVNO, LEDGERID, OUTSTANDING, REFERENCE, REP, SGSTAMT_CC, SOID, STATUSID, TOTALCURRENCY_CC, TOTAL_CC, TRANSID, USERCREATED, VATAMT_CC

Age Analysis and Statements

The following Data Pipelines can be used on Customer and Supplier Age Analysis output templates, such as statements (see Customer Age Analysis).

CA_List: All the customers on the Customer Age Analysis.
Fields (58)
ACCNO, ACCOUNTSCONTACTID, AGEID, APPROVEDLIMIT, CATEGORY, CIACCESSID, COMPANY, COMPID, CONTACTCEL, CONTACTTEL, CPNACCESSID, CURRENCYID, CUSID, DAYS120, DAYS120_2, DAYS120_3, DAYS150, DAYS150_3, DAYS180, DAYS180_3, DAYS30, DAYS60, DAYS90, DNACCESSID, EMAIL, FAX, FIRSTNAME, LISTNAME, MTD, PENDING, PENDING3, POSTADDRESS, QTACCESSID, REGIONID, REGISTEREDNAME, REP, SECUREDLIMIT, SMS, SOACCESSID, STATEMENT_DATE, STATUS, SURNAME, TEL, TERMS, TOTAL, TYPEID, UNALLOCATED, VATNO, VENDORNO, WIP, WIP3, WOACCESSID, YEAR1, YEAR1_3, YEAR2, YEAR2PLUS, YEAR2PLUS_3, YEAR2_3
CA_Record: The selected customer.
Fields (58)
ACCNO, ACCOUNTSCONTACTID, AGEID, APPROVEDLIMIT, CATEGORY, CIACCESSID, COMPANY, COMPID, CONTACTCEL, CONTACTTEL, CPNACCESSID, CURRENCYID, CUSID, DAYS120, DAYS120_2, DAYS120_3, DAYS150, DAYS150_3, DAYS180, DAYS180_3, DAYS30, DAYS60, DAYS90, DNACCESSID, EMAIL, FAX, FIRSTNAME, LISTNAME, MTD, PENDING, PENDING3, POSTADDRESS, QTACCESSID, REGIONID, REGISTEREDNAME, REP, SECUREDLIMIT, SMS, SOACCESSID, STATEMENT_DATE, STATUS, SURNAME, TEL, TERMS, TOTAL, TYPEID, UNALLOCATED, VATNO, VENDORNO, WIP, WIP3, WOACCESSID, YEAR1, YEAR1_3, YEAR2, YEAR2PLUS, YEAR2PLUS_3, YEAR2_3
CA_Trans: The customer's transactions.
Fields (29)
AGEING, BRANCH, CATEGORY, COMPANY, COMPANYID, CONTACT, CURRENCY, DEFAULTID, DUEDATE, LEDGERID, ORDERNO, OUTSTANDING, OVERDUE, PERIOD1, PERIOD2, PERIOD3, PERIOD4, PERIOD5, PERIOD6, QTNO, REFERENCE, REP, STATUS, TERMS, TOTAL, TRANSDATE, TRANSID, TRANSNO, TRANSTYPE
CA_Filters_Default: The data filters of the default view.
Fields (6)
BRANCH, CURRENCY, DATEEND, DATEFILTER, DATESTART, REP
CA_Filters_Trans: The data filters of the transaction view.
Fields (9)
BRANCH, CURRENCY, CUSTOMER, DAYS1, DAYS2, DAYS3, DAYS4, DAYS5, REP
CA_PDC: Outstanding customer PDC cheques (see Post-dated Cheques).
Fields (14)
BRANCH, CATEGORY, COMPANY, CURRENCY, DUEDATE, ID, LEDGERID, REFERENCE, STATUS, TOTAL, TRANSDATE, TRANSID, TRANSNO, TRANSTYPE
SA_List: All the suppliers on the Supplier Age Analysis.
Fields (52)
ACCNO, AGEID, CATEGORY, COMPANY, COMPID, CREDITLIMIT, CREDITTERMID, CURRENCY, CURRENCYID, DAYS120, DAYS120_2, DAYS120_3, DAYS150, DAYS150_3, DAYS180, DAYS180_3, DAYS30, DAYS60, DAYS90, DELADDRESS, EMAIL, FAX, MTD, OVERLIMIT, PENDING, PENDING3, POSTADDRESS, PWORD, STATEMENT_DATE, STATUSID, SUPACCNO, SUPID, TEL, TERMS, TOTAL, TOTALORDERS, TOTAL_SUP, TRADPARTID, TYPEID, UNALLOCATED, USERNAME, VATNO, VATTYPEID, WEBSITE, WIP, WIP3, YEAR1, YEAR1_3, YEAR2, YEAR2PLUS, YEAR2PLUS_3, YEAR2_3
SA_Record: The selected supplier.
Fields (52)
ACCNO, AGEID, CATEGORY, COMPANY, COMPID, CREDITLIMIT, CREDITTERMID, CURRENCY, CURRENCYID, DAYS120, DAYS120_2, DAYS120_3, DAYS150, DAYS150_3, DAYS180, DAYS180_3, DAYS30, DAYS60, DAYS90, DELADDRESS, EMAIL, FAX, MTD, OVERLIMIT, PENDING, PENDING3, POSTADDRESS, PWORD, STATEMENT_DATE, STATUSID, SUPACCNO, SUPID, TEL, TERMS, TOTAL, TOTALORDERS, TOTAL_SUP, TRADPARTID, TYPEID, UNALLOCATED, USERNAME, VATNO, VATTYPEID, WEBSITE, WIP, WIP3, YEAR1, YEAR1_3, YEAR2, YEAR2PLUS, YEAR2PLUS_3, YEAR2_3
SA_Trans: The supplier's transactions.
Fields (29)
AGEING, BRANCH, CATEGORY, COMPANY, COMPANYID, CONTACT, CURRENCY, DEFAULTID, DUEDATE, LEDGERID, OUTSTANDING, OVERDUE, PAYMENTDATE, PERIOD1, PERIOD2, PERIOD3, PERIOD4, PERIOD5, PERIOD6, REFERENCE, REP, STATUS, SUPPAYMENTID, TERMS, TOTAL, TRANSDATE, TRANSID, TRANSNO, TRANSTYPE
SA_Invoices: The supplier's invoices.
Fields (12)
AGEING, DOCNO, DUEDATE, LEDGERID, NOTE, OUTSTANDING, PAID, REFERENCE, TOTAL, TOTALVAT, TRANSDATE, TRANSID
SA_Payments: The supplier's payments.
Fields (12)
ALLOCATED, DOCNO, DUEDATE, ENTRYTYPE, ENTRYTYPE_CODE, LEDGERID, NOTE, REFERENCE, TOTAL, TRANSDATE, TRANSID, UNALLOCATED
SA_Allocations: The supplier's allocations.
Fields (8)
DESCRIPTION, DOCNO, ENTRYTYPE, ENTRYTYPE_CODE, LEDGERID, REFERENCE, TOTAL, TRANSDATE
SA_Filters_Default: The data filters of the default view.
Fields (5)
BRANCH, CURRENCY, DATEEND, DATEFILTER, DATESTART
SA_Filters_Trans: The data filters of the transaction view.
Fields (8)
BRANCH, CURRENCY, DAYS1, DAYS2, DAYS3, DAYS4, DAYS5, SUPPLIER
SA_PDC: Outstanding supplier PDC cheques.
Fields (13)
BRANCH, CATEGORY, COMPANY, CURRENCY, DUEDATE, LEDGERID, REFERENCE, STATUS, TOTAL, TRANSDATE, TRANSID, TRANSNO, TRANSTYPE
AA_Invoices: The invoices on the statement.
Fields (13)
AGEING, CUSORDERNO, DOCNO, DUEDATE, LEDGERID, NOTE, OUTSTANDING, PAID, REFERENCE, TOTAL, TOTALVAT, TRANSDATE, TRANSID
AA_Receipts: The receipts on the statement.
Fields (12)
ALLOCATED, DOCNO, DUEDATE, ENTRYTYPE, ENTRYTYPE_CODE, LEDGERID, NOTE, REFERENCE, TOTAL, TRANSDATE, TRANSID, UNALLOCATED
AA_Allocations: The allocations on the statement.
Fields (8)
DESCRIPTION, DOCNO, ENTRYTYPE, ENTRYTYPE_CODE, LEDGERID, REFERENCE, TOTAL, TRANSDATE
AA_DetLedger: The detailed ledger.
Fields (18)
ALLOCATED, BALANCE, CRACCNO, CRACCOUNT, CREDIT, DEBIT, DESCRIPTION_FULL, DOCNO, DRACCNO, DRACCOUNT, ENTRYTYPE, LEDGERID, NOTE, REFERENCE, TOTAL, TRANSDATE, TRANSID, UNALLOCATED

Supplier Payments

The following Data Pipelines can be used on Supplier Payment output templates (see Supplier Payments).

SP_Rec: The selected payment.
Fields (40)
ACCOUNTID, ADJTYPEID, BANK, BANKACCNO, BANKBRANCH, BANKNAME, BANKSWIFT, BRANCH, BRANCHID, CURRENCY, CURRENCYID, DATECREATED, DATEUPDATED, DISCOUNTAMOUNT, DISCOUNTAMOUNT3, DISCOUNTPERCENT, DUEDATE, LEDGERALLOCID, LEDGERID_SD, LEDGERID_SP, NOTE, PAYMENTDATE, REFERENCE, REFNO, STATUS, STATUSID, STATUSNOTE, SUBTOTAL, SUBTOTAL3, SUPACCNO, SUPID, SUPPAYMENTID, SUPPLIER, TOTAL, TOTAL3, TRANSID_SD, TRANSID_SP, USERCREATED, USERDATEUPDATED, USERUPDATED
SP_All: All the payments on the list.
Fields (40)
ACCOUNTID, ADJTYPEID, BANK, BANKACCNO, BANKBRANCH, BANKNAME, BANKSWIFT, BRANCH, BRANCHID, CURRENCY, CURRENCYID, DATECREATED, DATEUPDATED, DISCOUNTAMOUNT, DISCOUNTAMOUNT3, DISCOUNTPERCENT, DUEDATE, LEDGERALLOCID, LEDGERID_SD, LEDGERID_SP, NOTE, PAYMENTDATE, REFERENCE, REFNO, STATUS, STATUSID, STATUSNOTE, SUBTOTAL, SUBTOTAL3, SUPACCNO, SUPID, SUPPAYMENTID, SUPPLIER, TOTAL, TOTAL3, TRANSID_SD, TRANSID_SP, USERCREATED, USERDATEUPDATED, USERUPDATED
SP_Trans: The payment's transactions.
Fields (16)
DOCID, DOCNO, DUE, DUE3, ENTRYTYPE, FROMID, REFERENCE, SUPINVID, SUPPAYMENTID, SUPPAYMENTTRANSID, TOTAL, TOTAL3, TOTALCURRENCY, TOTALVAT, TOTALVAT3, TRANSDATE
SP_Outstanding: The supplier's outstanding transactions.
Fields (11)
ALLOCATED, APPROVAL, ENTRYTYPE, ID, INVDATE, INVOICENO, LEDGERID, OUTSTANDING, REFERENCE, SUPINVID, TOTALVAT

Ledger

The following Data Pipelines can be used on Ledger output templates (see Ledger Edit Views).

Lgr_Rec: The Transaction View or the Detailed Ledger View, depending on the view that was selected.
Fields (70)
ALLOCATED, ALLOCATED3, BANKID, BASEVALUE, BRANCHCODE, BRANCHID, BRANCHID_ET, BRANCHNAME, CGSTAMT, COLORID, COMPANY, COMPANYID, COMP_ACCNO, COMP_CATEGORY, COMP_POSTADDRESS, COMP_TEL, COMP_VATNO, CONTRAID, COPYFROMID, CREDITACCOUNTID_ET, CRTYPEID, CURRENCY, CURRENCYID, DATECREATED, DATEUPDATED, DEBITACCOUNTID_ET, DEFAULTEXPID, DEFAULTID, DEFAULTPDCID, DEFAULTPDCID_LINK, DOCNO, DRTYPEID, DUEDATE, EDITID, ENTRYTYPECODE, ENTRYTYPEID, ENTRYTYPENAME, FOREXID_ET, FROMID, FROMTRANS, IGSTAMT, LEDGERID, NOTE, OVERRIDETRIALID, PERIODDATE, RECURID, REFERENCE, REP, SGSTAMT, SOID, STATUS, STATUSID, STATUSMODULEID, STATUSNOTE, TOTAL, TOTAL3, TOTALCURRENCY, TOTALVAT, TOTALVAT3, TOTALVAT_TEXT, TRANSDATE, TRANSID, TRANSID_PDC, UNALLOCATED, UNALLOCATED3, USERCREATED, USERUPDATED, VATAMT, VATAMT3, VATRECONID
Lgr_All: The Transaction View or the Detailed Ledger View, depending on the view that was selected.
Fields (70)
ALLOCATED, ALLOCATED3, BANKID, BASEVALUE, BRANCHCODE, BRANCHID, BRANCHID_ET, BRANCHNAME, CGSTAMT, COLORID, COMPANY, COMPANYID, COMP_ACCNO, COMP_CATEGORY, COMP_POSTADDRESS, COMP_TEL, COMP_VATNO, CONTRAID, COPYFROMID, CREDITACCOUNTID_ET, CRTYPEID, CURRENCY, CURRENCYID, DATECREATED, DATEUPDATED, DEBITACCOUNTID_ET, DEFAULTEXPID, DEFAULTID, DEFAULTPDCID, DEFAULTPDCID_LINK, DOCNO, DRTYPEID, DUEDATE, EDITID, ENTRYTYPECODE, ENTRYTYPEID, ENTRYTYPENAME, FOREXID_ET, FROMID, FROMTRANS, IGSTAMT, LEDGERID, NOTE, OVERRIDETRIALID, PERIODDATE, RECURID, REFERENCE, REP, SGSTAMT, SOID, STATUS, STATUSID, STATUSMODULEID, STATUSNOTE, TOTAL, TOTAL3, TOTALCURRENCY, TOTALVAT, TOTALVAT3, TOTALVAT_TEXT, TRANSDATE, TRANSID, TRANSID_PDC, UNALLOCATED, UNALLOCATED3, USERCREATED, USERUPDATED, VATAMT, VATAMT3, VATRECONID
Lgr_Items: The transaction items.
Fields (30)
ADJTYPEID, ALLOCATENO, ALLOCATETOTAL, CGSTAMT, CGSTPERCENT, CRACCNO, CRACCOUNT, CRACCOUNTID, DESCRIPTION, DRACCNO, DRACCOUNT, DRACCOUNTID, FROMID, IGSTAMT, IGSTPERCENT, ORDERID, SGSTAMT, SGSTPERCENT, TOTAL, TOTAL3, TOTALCURRENCY, TOTALVAT, TOTALVAT3, TRANSID, TRANSITEMID, VATAMT, VATAMT3, VATPERCENT, VATTYPE, VATTYPEID
Lgr_Trial: The Trial Balance sample for the selected transaction.
Fields (8)
ACCNO, ACCOUNT, CREDIT, DEBIT, DESCRIPTION, ID, ITEMID, ORDERID
Lgr_Allocation: The allocated transactions.
Fields (12)
ALLOCATED, BRANCH, DOCNO, ENTRYTYPE, LEDGERALLOCID, LEDGERID, REFERENCE, SOID, TOTALCURRENCY, TOTALVAT, TRANSDATE, TRANSID
Lgr_Outstanding: The outstanding transactions.
Fields (13)
ALLOCATED, BRANCH, DEFAULTID, DOCNO, ENTRYTYPE, LEDGERID, REFERENCE, SOID, TOTALCURRENCY, TOTALVAT, TRANSDATE, TRANSID, UNALLOCATED
Lgr_Warning: The Debit and Credit totals of the transaction, and an error warning.
Fields (3)
CREDIT, DEBIT, WARNING
Lgr_Filters: The data filters.
Fields (2)
BRANCH, DATEFILTER

Financial Statements

The following Data Pipelines can be used on the Trial Balance and the financial statements.

TrialBalance: The Trial Balance.
Fields (13)
ACCNO, ACCOUNTID, CATEGORY, CREDIT, DEBIT, DESCRIPTION, GROUP1, GROUP2, MOVEMENT, OPENING, REPORT, TOTAL, TRIALID
TrialBalance_Detail: The Trial Balance transactions. Removed in version 26.03.
Fields (16)
BALANCE, CRACCNO, CRACCOUNT, CREDIT, DEBIT, DOCID, DOCNO, DRACCNO, DRACCOUNT, ENTRYTYPE, PERIODDATE, REFERENCE, REPORT, TRANSDATE, TRANSID, TRANSITEMID
TrialBalance_Filter: The data filters.
Fields (2)
BRANCH, DATEFILTER
BS_Level1: The first level of the Statement of Financial Position.
Fields (11)
ACCNO, ACCOUNTID, BALSHTID, DESCRIPTION, GROWTH, ORDERID, PARENTID, TOTAL, TOTAL2, TOTAL2_3, TOTAL_3
BS_Level2: The second level of the Statement of Financial Position.
Fields (11)
ACCNO, ACCOUNTID, BALSHTID, DESCRIPTION, GROWTH, ORDERID, PARENTID, TOTAL, TOTAL2, TOTAL2_3, TOTAL_3
BS_Level3: The third level of the Statement of Financial Position.
Fields (11)
ACCNO, ACCOUNTID, BALSHTID, DESCRIPTION, GROWTH, ORDERID, PARENTID, TOTAL, TOTAL2, TOTAL2_3, TOTAL_3
BS_Level4: The fourth level of the Statement of Financial Position.
Fields (11)
ACCNO, ACCOUNTID, BALSHTID, DESCRIPTION, GROWTH, ORDERID, PARENTID, TOTAL, TOTAL2, TOTAL2_3, TOTAL_3
BS_Filter: The data filters.
Fields (2)
BRANCH, DATEFILTER
IS_Level1: The first level (sections) of the Statement of Profit or Loss.
Fields (59)
ACCNO, ACCOUNTID, BUDGETTOTAL, BUDGETTOTAL1, BUDGETTOTAL10, BUDGETTOTAL11, BUDGETTOTAL12, BUDGETTOTAL2, BUDGETTOTAL3, BUDGETTOTAL4, BUDGETTOTAL5, BUDGETTOTAL6, BUDGETTOTAL7, BUDGETTOTAL8, BUDGETTOTAL9, DESCRIPTION, GROWTHPERCENT, INCSTATID, ORDERID, PARENTID, PERCENT1, PERCENT10, PERCENT11, PERCENT12, PERCENT2, PERCENT3, PERCENT4, PERCENT5, PERCENT6, PERCENT7, PERCENT8, PERCENT9, PERIODCOUNTID, TOTAL, TOTAL1, TOTAL10, TOTAL10_3, TOTAL11, TOTAL11_3, TOTAL12, TOTAL12_3, TOTAL1_3, TOTAL2, TOTAL2_3, TOTAL3, TOTAL3_3, TOTAL4, TOTAL4_3, TOTAL5, TOTAL5_3, TOTAL6, TOTAL6_3, TOTAL7, TOTAL7_3, TOTAL8, TOTAL8_3, TOTAL9, TOTAL9_3, TOTAL_3
IS_Level2: The second level of the Statement of Profit or Loss.
Fields (59)
ACCNO, ACCOUNTID, BUDGETTOTAL, BUDGETTOTAL1, BUDGETTOTAL10, BUDGETTOTAL11, BUDGETTOTAL12, BUDGETTOTAL2, BUDGETTOTAL3, BUDGETTOTAL4, BUDGETTOTAL5, BUDGETTOTAL6, BUDGETTOTAL7, BUDGETTOTAL8, BUDGETTOTAL9, DESCRIPTION, GROWTHPERCENT, INCSTATID, ORDERID, PARENTID, PERCENT1, PERCENT10, PERCENT11, PERCENT12, PERCENT2, PERCENT3, PERCENT4, PERCENT5, PERCENT6, PERCENT7, PERCENT8, PERCENT9, PERIODCOUNTID, TOTAL, TOTAL1, TOTAL10, TOTAL10_3, TOTAL11, TOTAL11_3, TOTAL12, TOTAL12_3, TOTAL1_3, TOTAL2, TOTAL2_3, TOTAL3, TOTAL3_3, TOTAL4, TOTAL4_3, TOTAL5, TOTAL5_3, TOTAL6, TOTAL6_3, TOTAL7, TOTAL7_3, TOTAL8, TOTAL8_3, TOTAL9, TOTAL9_3, TOTAL_3
IS_Level3: The third level of the Statement of Profit or Loss.
Fields (59)
ACCNO, ACCOUNTID, BUDGETTOTAL, BUDGETTOTAL1, BUDGETTOTAL10, BUDGETTOTAL11, BUDGETTOTAL12, BUDGETTOTAL2, BUDGETTOTAL3, BUDGETTOTAL4, BUDGETTOTAL5, BUDGETTOTAL6, BUDGETTOTAL7, BUDGETTOTAL8, BUDGETTOTAL9, DESCRIPTION, GROWTHPERCENT, INCSTATID, ORDERID, PARENTID, PERCENT1, PERCENT10, PERCENT11, PERCENT12, PERCENT2, PERCENT3, PERCENT4, PERCENT5, PERCENT6, PERCENT7, PERCENT8, PERCENT9, PERIODCOUNTID, TOTAL, TOTAL1, TOTAL10, TOTAL10_3, TOTAL11, TOTAL11_3, TOTAL12, TOTAL12_3, TOTAL1_3, TOTAL2, TOTAL2_3, TOTAL3, TOTAL3_3, TOTAL4, TOTAL4_3, TOTAL5, TOTAL5_3, TOTAL6, TOTAL6_3, TOTAL7, TOTAL7_3, TOTAL8, TOTAL8_3, TOTAL9, TOTAL9_3, TOTAL_3
IS_Level4: The fourth level of the Statement of Profit or Loss.
Fields (59)
ACCNO, ACCOUNTID, BUDGETTOTAL, BUDGETTOTAL1, BUDGETTOTAL10, BUDGETTOTAL11, BUDGETTOTAL12, BUDGETTOTAL2, BUDGETTOTAL3, BUDGETTOTAL4, BUDGETTOTAL5, BUDGETTOTAL6, BUDGETTOTAL7, BUDGETTOTAL8, BUDGETTOTAL9, DESCRIPTION, GROWTHPERCENT, INCSTATID, ORDERID, PARENTID, PERCENT1, PERCENT10, PERCENT11, PERCENT12, PERCENT2, PERCENT3, PERCENT4, PERCENT5, PERCENT6, PERCENT7, PERCENT8, PERCENT9, PERIODCOUNTID, TOTAL, TOTAL1, TOTAL10, TOTAL10_3, TOTAL11, TOTAL11_3, TOTAL12, TOTAL12_3, TOTAL1_3, TOTAL2, TOTAL2_3, TOTAL3, TOTAL3_3, TOTAL4, TOTAL4_3, TOTAL5, TOTAL5_3, TOTAL6, TOTAL6_3, TOTAL7, TOTAL7_3, TOTAL8, TOTAL8_3, TOTAL9, TOTAL9_3, TOTAL_3
IS_Period: The periods of the Statement of Profit or Loss.
Fields (14)
DATES, PERIOD_1, PERIOD_10, PERIOD_11, PERIOD_12, PERIOD_2, PERIOD_3, PERIOD_4, PERIOD_5, PERIOD_6, PERIOD_7, PERIOD_8, PERIOD_9, TOTAL
IS_Filter: The data filters.
Fields (2)
BRANCH, DATEFILTER

VAT and Bank Reconciliation

The following Data Pipelines can be used on VAT Reconciliation and Bank Reconciliation output templates.

VAT_Header: The VAT Recon header fields.
Fields (39)
BALANCE, BALANCE3, BALANCEOUT, BALANCEOUT3, BRANCHID, CGSTBALANCE, CGSTBALANCEOUT, CGSTINPUT, CGSTINPUTOUT, CGSTOUTPUT, CGSTOUTPUTOUT, DATEEND, DATESTART, DATEUPDATED, IGSTBALANCE, IGSTBALANCEOUT, IGSTINPUT, IGSTINPUTOUT, IGSTOUTPUT, IGSTOUTPUTOUT, INPUT, INPUT3, INPUTOUT, INPUTOUT3, NOTE, OUTPUT, OUTPUT3, OUTPUTOUT, OUTPUTOUT3, SGSTBALANCE, SGSTBALANCEOUT, SGSTINPUT, SGSTINPUTOUT, SGSTOUTPUT, SGSTOUTPUTOUT, STATUSID, STATUSNOTE, USERUPDATED, VATRECONID
VAT_Transactions: The transactions included in the VAT Recon, sorted by Input/Output, Entry Type, Date, Trans No and Item No.
Fields (30)
ACCOUNTREPORT, BRANCH, CGSTAMT, CODE, COLORID, CRACCNO, CRACCOUNT, CREDIT, DEBIT, DESCRIPTION, DOCNO, DRACCNO, DRACCOUNT, ENTRYTYPE, ID, IGSTAMT, INPUT_OUTPUT, LEDGERID, ORDERID, PERIODDATE, REFERENCE, SGSTAMT, STATUS, TOTAL, TOTALVAT, TRANSDATE, TRANSID, VATAMT, VATNO, VATTYPE
VAT_Sum_ET: A summary by Entry Type.
Fields (10)
CGSTAMT, CREDIT, DEBIT, DESCRIPTION, ID, IGSTAMT, SGSTAMT, TOTAL, TOTALVAT, VATAMT
VAT_Sum_VATType: A summary by VAT Type.
Fields (10)
CGSTAMT, CREDIT, DEBIT, DESCRIPTION, ID, IGSTAMT, SGSTAMT, TOTAL, TOTALVAT, VATAMT
VAT_Filter: The Date, Branch and Status filters.
Fields (2)
BRANCH, DATEFILTER
BankRecon_Header: The bank reconciliation header.
Fields (20)
ACCOUNT, ACCOUNTID, BALANCEACTUAL, BALANCEACTUAL3, BALANCEADJUSTED, BALANCEADJUSTED3, BALANCELEDGER, BALANCELEDGER3, BANKDATE, BANKRECONID, CURRENCYID, DATEUPDATED, PENDINGCREDIT, PENDINGCREDIT3, PENDINGDEBIT, PENDINGDEBIT3, STATUSID, STATUSNOTE, USERUPDATED, VARIANCE
BankRecon_Statement: The bank statement.
Fields (14)
BALANCE, COLORID, COMPANY, CREDIT, DEBIT, DESCRIPTION, DOCNO, ENTRYTYPE, ID, LEDGERID, PERIODDATE, REFERENCE, STATUS, TRANSID
BankRecon_Ledger: The ledger transactions.
Fields (15)
BALANCE, COLORID, CRACCOUNT, CREDIT, DEBIT, DESCRIPTION, DOCNO, DRACCOUNT, ENTRYTYPE, ID, LEDGERID, PERIODDATE, REFERENCE, STATUS, TRANSID
BankRecon_Outstanding: The outstanding (unreconciled) ledger transactions.
Fields (13)
COLORID, COMPANY, DEBIT, DESCRIPTION, DOCNO, DUEDATE, ENTRYTYPE, ID, LEDGERID, PERIODDATE, REFERENCE, STATUS, TRANSID

Cost of Sales

The following Data Pipelines can be used on Cost of Sales Report output templates (see Cost of Sales Report).

CoS_Trans: The Transaction view.
Fields (29)
BRANCHID, COLORID, COMPANY, COST, CUSCAT, DIRECTCOST, DOCNO, EXPENSES, ISSUED, JOBCAT, LABOUR, LASTCIDATE, MARGIN, MARKUP, PROFIT, PURCHASES, REFERENCE, REP, RETURNED, STATUS, TOTAL, TOTALINV, TRANSDATE, TRANSID, TRANSID_SO, TRANSTYPE, VA, VAPERCENT, VARIANCE
CoS_Items: The Items view.
Fields (45)
ACTQTY, ADJPERCENT, BRANCHID, CODE, COLORID, COMPANY, COMPANYCAT, COST, DIRECTCOST, DOCNO, ESTQTY, ISSUED, ITEMID, ITEMNO, JOBCAT, LABOUR, LASTCIDATE, MARGIN, MARKUP, MATCAT, MATDESC, MATUNITID, MAT_SER, PROCID, PROFIT, PROVIDER, PURCHASES, QTY, REFERENCE, REP, RETURNED, STATUS, STOCKTRANS, SUBCAT, TOTAL, TOTALINV, TRANSDATE, TRANSID, TRANSID_SO, TRANSTYPE, UNIT, VA, VAPERCENT, VARIANCE, VARQTY
CoS_Cus: The Customer view.
Fields (20)
COMPANY, COST, CUSCAT, CUSID, DIRECTCOST, EXPENSES, ISSUED, LABOUR, MARGIN, MARKUP, OUTWORK, PROFIT, PURCHASES, REP, RETURNED, TOTAL, TOTALINV, VA, VAPERCENT, VARIANCE
CoS_Filter: The data filters.
Fields (2)
BRANCH, DATEFILTER

Office

Campaigns and Contracts

The following Data Pipelines can be used on Campaign and Contract output templates (see Campaigns & Contracts).

Campaign_Rec: The selected Campaign's header fields.
Fields (40)
APPROVAL, APPROVEID, BRANCH, BRANCHID, CAMPAIGNDATE, CAMPAIGNID, CHECKLISTID, CONTACT, CONTROLLER, CUSCONTACTID, CUSID, CUSSTATUS, CUSTOMER, DATECREATED, DATEUPDATED, EDITID, ENDDATE, ENQID, FLOWID, FLOWIDS, GROUPID, IMAGEID, ITEMSTYPEID, LINKEDATTACHID, NOTE, ORDERID, QUOTEID, REFERENCE, REP, REVIEWDATE, STAFFIDASSIGN, STAFFIDREP, STARTDATE, STATUS, STATUSID, STATUSNOTE, TICKETID, UPDATED, USERCREATED, USERUPDATED
Campaign_Items: All the items in the Campaign.
Fields (25)
AVAILABLE, CAMPAIGNID, CAMPAIGNPRODUCTID, CATEGORY, CODE, DELQTY, DESCRIPTION, DISQTY, INSTOCK, INVOICED, INVQTY, ITEMNO, MATCOSTID, MATUNITID, NOTE, ONORDER, OUTAMT, OUTQTY, QTQTY, QUOTEITEMID, RESERVED, STATUSID, SUBCAT, TOTAL, UNITPRICE
Campaign_Distribution: All the distributions in the Campaign.
Fields (13)
ADDRESS, ADDRESS_LOOKUP, CAMPAIGNID, CONTACT, CONTACTID, CUSADDRESSID, CUSIDDELIVER, CUSIDINVOICE, DELIVERTO, DISTRIBUTIONID, DUEDATE, INVOICETO, STATUSID
Campaign_DTB_Items: A child list of the items linked to the Campaign_Distribution pipeline.
Campaign_Terms: The Campaign's terms.
Fields (7)
CAMPAIGNID, CAMPAIGNTERMID, DESCRIPTION, PERIODID, QTY, QTYTYPEID, RULETYPEID
Campaign_Trans: The Campaign's transactions.
Fields (13)
COLORID, COMPANY, CONTACT, DOCNO, DUEDATE, ENQID, REFERENCE, STATUS, TOTAL, TRANSDATE, TRANSID, TRANSTYPE, TYPEID
Campaign_Contacts: The Campaign's contacts.
Fields (9)
CAMPAIGNCONTACTID, CAMPAIGNID, CELL, CONTACTID, CONTACTTYPE, EMAIL, LISTNAME, NOTIFICATIONID, TYPEID
Campaign_Links: The product links.
Fields (11)
ADDRESS, ADDRESS_LOOKUP, CODE, CONTACT, DELIVERTO, DESCRIPTION, DUEDATE, ID, INVOICETO, ITEMNO, QTY
Campaign_Note: The Campaign's notes.
Fields (2)
ACTIVITY, CRMACTIVITYID
Campaign_Approvals: The Campaign's checklist items.
Fields (6)
CHECKLISTTRANSID, CODE, DATEUPDATED, DESCRIPTION, NOTE, USERUPDATED
Campaign_Filter: The data filter.
Fields (2)
BRANCH, DATEFILTER

Service Manager

The following Data Pipelines can be used on Service Manager output templates (see Service Manager).

SM_Rec: The selected ticket.
Fields (55)
ASSIGNTO, BRANCH, BRANCHID, CATEGORY, CATEGORYID, CATEGORY_COLORID, CATEGORY_RESPONSEID, COLORID, COMPANY, COMPANYID, CONTACTID, DATECREATED, DATEREMIND, DATEUPDATED, DUECOLORID, DUEDATE, EMAIL_CONTACT, FLOWID, FNAME, FROMID, HRSDATEREMIND, LASTDAYS, LAST_CONTACT, LEADSOURCE, LINKEDATTACHID, LISTNAME, MACHINE, MOBILE_CONTACT, NOTIFICATIONID, RATING, REFERBY, REFERENCE, REP, RESPONSEHRS, SEVERITY, SEVERITYID, SNAME, STAFFIDASSIGN, STAFFIDREP, STATUS, STATUSID, STATUSNOTE, STATUS_GROUPID, TEL_CONTACT, TICKETID, TIMELOGID, TKTOTALHRS, TOTALDAYS, TYPEID, TYPES, USERCREATED, USERDATEUPDATED, USERUPDATED, VALUEANNUAL, VALUEONEOFF
SM_All: All the tickets on the list.
Fields (55)
ASSIGNTO, BRANCH, BRANCHID, CATEGORY, CATEGORYID, CATEGORY_COLORID, CATEGORY_RESPONSEID, COLORID, COMPANY, COMPANYID, CONTACTID, DATECREATED, DATEREMIND, DATEUPDATED, DUECOLORID, DUEDATE, EMAIL_CONTACT, FLOWID, FNAME, FROMID, HRSDATEREMIND, LASTDAYS, LAST_CONTACT, LEADSOURCE, LINKEDATTACHID, LISTNAME, MACHINE, MOBILE_CONTACT, NOTIFICATIONID, RATING, REFERBY, REFERENCE, REP, RESPONSEHRS, SEVERITY, SEVERITYID, SNAME, STAFFIDASSIGN, STAFFIDREP, STATUS, STATUSID, STATUSNOTE, STATUS_GROUPID, TEL_CONTACT, TICKETID, TIMELOGID, TKTOTALHRS, TOTALDAYS, TYPEID, TYPES, USERCREATED, USERDATEUPDATED, USERUPDATED, VALUEANNUAL, VALUEONEOFF
SM_Response: The ticket's responses.
Fields (4)
ACTIVITY, CRMACTIVITYID, CRMACTTEMPLATEID, USERCREATED
SM_Detail: The ticket's details.
Fields (1)
NOTE

Non-Conformance Reports

The following Data Pipelines can be used on NCR output templates (see Non-Conformance Reporting).

NCR_Rec: The selected NCR.
Fields (82)
BRANCH, BRANCHCODE, BRANCHID, CATEGORY, CATEGORYCAUSE, CATEGORYID, CLOSED, COLORID, CONTAINMENT, CORRECTION, CUSCONTACT, CUSCONTACTID, CUSID, CUSTOMER, DATECLOSE, DATECORRECTIVE, DATECREATED, DATEDUE, DATEEVALUATE, DATEINVESTIGATE, DATEPREVENTATIVE, DATEREMIND, DATEUPDATED, DEPARTMENT, DEPARTMENTID, DOCNO, DOCNO_REMAKE, EFFECTIVEID, ESTIMATED, EVALUATION, EVALUATIONBY, IMPLEMENTATIONBY, INVESTIGATIONBY, ITEMID, ITEM_DESCRIPTION, ITEM_REMAKE, LINKEDATTACHID, NCRID, NOTECAUSE, NOTECORRECTIVE, NOTEEVALUATION, NOTEPREVENTATIVE, NOTEPROBLEM, NOTERECALL, PERIOD, PREVENTEDBY, PREVENTION, PREVENTITIVEID, QTY, QTY_REMAKE, REFERENCE, REMAKECOST, SECTION, SECTIONID, STAFFASSIGN, STAFFIDASSIGN, STAFFIDCLOSE, STAFFIDCORRECTIVE, STAFFIDEVALUATE, STAFFIDINVESTIGATE, STAFFIDOWNER, STAFFIDPREVENTATIVE, STAFFOWNER, STATUS, STATUSID, STATUSNOTE, SUPCONTACT, SUPCONTACTID, SUPID, SUPPLIER, TICKETID, TOTALCOST, TOTALDIRECT, TOTALLABOUR, TRANSID, TRANSIDREWORK, TRANSTYPE, TYPEID, TYPES, USERCREATED, USERDATEUPDATED, USERUPDATED
NCR_All: All the NCRs on the list.
Fields (82)
BRANCH, BRANCHCODE, BRANCHID, CATEGORY, CATEGORYCAUSE, CATEGORYID, CLOSED, COLORID, CONTAINMENT, CORRECTION, CUSCONTACT, CUSCONTACTID, CUSID, CUSTOMER, DATECLOSE, DATECORRECTIVE, DATECREATED, DATEDUE, DATEEVALUATE, DATEINVESTIGATE, DATEPREVENTATIVE, DATEREMIND, DATEUPDATED, DEPARTMENT, DEPARTMENTID, DOCNO, DOCNO_REMAKE, EFFECTIVEID, ESTIMATED, EVALUATION, EVALUATIONBY, IMPLEMENTATIONBY, INVESTIGATIONBY, ITEMID, ITEM_DESCRIPTION, ITEM_REMAKE, LINKEDATTACHID, NCRID, NOTECAUSE, NOTECORRECTIVE, NOTEEVALUATION, NOTEPREVENTATIVE, NOTEPROBLEM, NOTERECALL, PERIOD, PREVENTEDBY, PREVENTION, PREVENTITIVEID, QTY, QTY_REMAKE, REFERENCE, REMAKECOST, SECTION, SECTIONID, STAFFASSIGN, STAFFIDASSIGN, STAFFIDCLOSE, STAFFIDCORRECTIVE, STAFFIDEVALUATE, STAFFIDINVESTIGATE, STAFFIDOWNER, STAFFIDPREVENTATIVE, STAFFOWNER, STATUS, STATUSID, STATUSNOTE, SUPCONTACT, SUPCONTACTID, SUPID, SUPPLIER, TICKETID, TOTALCOST, TOTALDIRECT, TOTALLABOUR, TRANSID, TRANSIDREWORK, TRANSTYPE, TYPEID, TYPES, USERCREATED, USERDATEUPDATED, USERUPDATED
NCR_Staff: The staff linked to the NCR.
Fields (6)
NCRID, NCRSTAFFID, NOTIFICATIONID, SHORTNAME, STAFFID, STAFFROLE
NCR_Progress: The NCR's progress.
Fields (6)
ACTIONID, DESCRIPTION, NCRID, NCRPROGRESSID, STAFFID, USERDATEUPDATED
NCR_Cost: The NCR's costs.
Fields (7)
COSTTYPEID, DOCNO, ID, REFERENCE, TOTAL, TRANSDATE, TRANSID

Workspace and Leave

The following Data Pipelines can be used on Workspace and Leave output templates (see Workspace).

WF_Main_Rec: The selected workflow.
Fields (34)
BRANCH, BRANCHCODE, BRANCHID, CONTACTID, CUSCONTACT, CUSEMAIL, CUSID, CUSSMS, CUSTOMER, DATECREATED, GROUPID, IMAGEID, MATUNITID, MODULE, MODULEID, PARENTID, PRODUCT, REF1, REF2, REF3, STAFF, STAFFEMAIL, STAFFID, STAFFSMS, STATUS, STATUSID, SUPCONTACT, SUPEMAIL, SUPID, SUPPLIER, SUPSMS, USERID, USERNAME, WORKFLOWID
WF_Main_All: All the workflows on the list.
Fields (34)
BRANCH, BRANCHCODE, BRANCHID, CONTACTID, CUSCONTACT, CUSEMAIL, CUSID, CUSSMS, CUSTOMER, DATECREATED, GROUPID, IMAGEID, MATUNITID, MODULE, MODULEID, PARENTID, PRODUCT, REF1, REF2, REF3, STAFF, STAFFEMAIL, STAFFID, STAFFSMS, STATUS, STATUSID, SUPCONTACT, SUPEMAIL, SUPID, SUPPLIER, SUPSMS, USERID, USERNAME, WORKFLOWID
WF_Items: The workflow's items.
Fields (24)
DATECREATED, LINKDOCID, LINKENQID, LINKFILENAME, NOTE, REFERENCE, REMARKS, SOURCEDOCID, SOURCEENQID, SOURCEMODULEID, TRANSCOMPANY, TRANSDATE, TRANSREF, TRANSSTATUS, TRANSTOTAL, TRANSTOTALVAT, TRANSVAT, TYPEID, USERID, USERLISTNAME, USERNAME, WFITEMID, WFTEMPID, WORKFLOWID
WF_Remind: The workflow's reminders.
Fields (11)
DUETIME, EVENTID, ISCLOSED, ISEMAIL, LISTNAME, NOTE, REMINDID, REMINDTIME, SHORTNAME, STAFFID, WORKFLOWID
WS_Remind_Rec: The selected reminder that is due.
Fields (17)
DUETIME, ENTITY, EVENTID, ISCLOSED, ISEMAIL, ITEMSTATUSID, MODULE, MODULEID, NOTE, REF1, REF2, REF3, REMINDID, REMINDTIME, STAFFID, STATUSID, WORKFLOWID
WS_Remind_All: All the reminders that are due.
Fields (17)
DUETIME, ENTITY, EVENTID, ISCLOSED, ISEMAIL, ITEMSTATUSID, MODULE, MODULEID, NOTE, REF1, REF2, REF3, REMINDID, REMINDTIME, STAFFID, STATUSID, WORKFLOWID
Leave_All: All the leave on the list (see Leave).
Fields (18)
DATECREATED, DATEEND, DATESTART, DATEUPDATED, FILENAME, LEAVELOGID, LEAVERULEID, LEAVERULE_DESC, NOTE, POSITIONID, PROOFID, SHORTNAME, STAFFID, STATUSID, STATUS_DESC, TOTALDAYS, USERCREATED, USERUPDATED

General

These Data Pipelines are available on several output templates.

Active_User: The user who is logged in, with their position and Cost Centre.
Fields (37)
BOSSID, BRANCHID, CCENTREID, CELL, DATEPROBATIONEND, DATESTARTED, DATETERMINATION, DELADDRESS, DOB, EMAIL, FNAME, HOMETEL, ID, IDNUMBER, IMAGE, ISOPERATOR, ISSALESREP, ISSYSADMIN, LISTNAME, NEXTBIRTHDAY, NOTE, POSITION, POSITIONID, POSTADDRESS, POSTADDRESS_STR, RATE, REASONTERMINATION, SEXID, SHORTNAME, SMS, SNAME, STAFFID, STATUSID, STREETADDRESS_STR, TITLE, WORKFAX, WORKTEL
plTemplates: The output templates.
Fields (3)
NAME, REPORTID, TEMPLATEFILE
Rep_Rec: The selected row of a custom report (see Custom Reports).
- Note: The fields are the columns that the custom report's SQL returns.
Rep_All: All the rows of a custom report.
- Note: The fields are the columns that the custom report's SQL returns.
Rep_Setup: The custom report setup.
Fields (18)
CATEGORYID, CHARTTYPEID, DESCRIPTION, DRILLFIELDID, DRILLMODULEID, EMAILBODY, FIELDNAMES_SERIES, FIELDNAME_CATEGORY, MODULENAME, NAME, OUTPUTID, QUERY_SQL, REPORTID, STATUS, STATUSHTMLID, TEMPLATE, TEMPLATEFILE, TEMPLATEID

Output Data Pipelines

Customers and Suppliers#

Customers#

Suppliers#

Quotations and Estimates#

Quotations#

Estimates#

Label Printing#

Corrugated Boxes and Signage#

Sales and Production#

Sales Orders#

Work Orders#

Design Work Orders#

Job Summary and Timekeeping#

Delivery Notes#

Point of Sale#

Purchasing and Inventory#

Purchase Orders#

Supplier Invoices#

Supplier Debit Notes#

Materials Movements#

Materials and Inventory#

Invoicing and Accounting#

Customer Invoices#

Customer Credit Notes#

Age Analysis and Statements#

Supplier Payments#

Ledger#

Financial Statements#

VAT and Bank Reconciliation#

Cost of Sales#

Office#

Campaigns and Contracts#

Service Manager#

Non-Conformance Reports#

Workspace and Leave#

General#

Customers and Suppliers

Customers

Suppliers

Quotations and Estimates

Quotations

Estimates

Label Printing

Corrugated Boxes and Signage

Sales and Production

Sales Orders

Work Orders

Design Work Orders

Job Summary and Timekeeping

Delivery Notes

Point of Sale

Purchasing and Inventory

Purchase Orders

Supplier Invoices

Supplier Debit Notes

Materials Movements

Materials and Inventory

Invoicing and Accounting

Customer Invoices

Customer Credit Notes

Age Analysis and Statements

Supplier Payments

Ledger

Financial Statements

VAT and Bank Reconciliation

Cost of Sales

Office

Campaigns and Contracts

Service Manager

Non-Conformance Reports

Workspace and Leave

General