Special Derived Bookmarks - IRBS_Help

Home > Appendices > Appendix 1 - Bookmarks > Special Derived Bookmarks

Special Derived Bookmarks


TableName ItemName ItemDesc Notes

POVENDORADDRESS PO Vendor Address

STMBAL Statement Balance

STMDUEDATE Statement Due Date

STMINVAMT Statement Invoice Amount

STMINVID Statement Invoice ID

STMINVITEM Statement Invoice Item

STMPAYAMT Statement Payment Amount

STMPAYDATES Statement Payment Dates

STMPAYITEM Statement Payment Item

STMPAYREF Statement Payment Reference

STMTOTINV Statement Total Invoice

STMTOTPAY Statement Total Payment

TOTALINVDUE Total Invoice Due

VENDORADDRESS Vendor Address

VENDORFAX Vendor Fax

VENDORNAME Vendor Name

VENDORPHONE Vendor Phone

VENDORREP Vendor Sales Rep
Job ALLOWANCE Allowance A list of allowance descriptions for the job. One allowance per row. Best used in a 2 column table with the ALLOWANCEAMT in the other column since the Description and Amount will match each other on the same row.
Job ALLOWANCEAMT Allowance Amount A list of allowance amounts for the job. One allowance amount per row. Best used in a second column in a table with the ALLOWANCE in the first column since the Description and Amount will match each other on the same row.
Job BILLADDRESS1LINE Billing Address on 1 Line The Job Billing address formatted as one single line.
Job COMPANY Company
Job CONTRACTSIGNERNAME Contract Signer Name
Job CONTRACTSIGNERTITLE Contract Signer Title
Job ENDMONTHDATE End Month Date
Job EXTN1 Primary Contact Phone Extn
Job EXTN2 Secondary Contact Phone Extn
Job FIRSTNAME1 Primary Contact First Name First Name of the Primary Job Contact.
Job FIRSTNAME2 Secondary Contact First Name First Name of the Secondary Job Contact.
Job FIRSTNAMESALUTATION Primary Contact Salutation Salutation for the Primary Job Contact.
Job FIRSTPERSON Primary Contact Salutation for the Secondary Job Contact.
Job HOMEPHONE1 Primary Contact Home Phone Home Phone of Primary Job Contact.
Job HOMEPHONE2 Secondary Contact Home Phone Home Phone of Secondary Job Contact.
Job JOBACTUALAMTTEXT Job Actual Amount Text Job Actual Amount spelled out in text\words.
Job JOBADDRESS Job Address Job Address formatted as multi-line address.
Job JOBADDRESS1LINE Job Address on 1 Line Job Address formatted as one single-line.
Job JOBBALANCEAMTTEXT Job Balance Amount Text Job Balance spelled out in text\words.
Job JOBCONTACTFIRSTNAMES Primary & Secondary Firstname(s) Only First Name(s) only of Primary and Secondary Job Contact(s).
Job JOBCONTRACTAMTTEXT Job Contract Amount Text Job Contract Amount spelled out in text\words.
Job JOBDEPTDESC Job Department Description Job Department Description.
Job JOBDESIGNCREDITSAMTTEXT Job Design Credits Amount Text Job Design Credit Amount spelled out in text\words.
Job JOBESTIMATEPHASEDESC Job Estimate Phase Description
Job JOBESTIMATEPHASEPRICE Job Estimate Phase Total
Job JOBEXCLUSIONS Job Exclusions
Job JOBLEADSTATUSDESC Job Lead Test Status Description Job Lead Tes Status Description.
Job JOBPROJECTTYPEDESC Job Project Type Description Job Project Type Description.
Job JOBSALESPERSON Job Salesperson(s) Name(s) of Job Salesperson(s)
Job JOBVENDORS Job Vendors and Subs Contact Info
Job LASTNAME1 Primary Contact Last Name Last Name of the Primary Job Contact.
Job LASTNAME2 Secondary Contact Last Name Last Name of the Secondary Job Contact.
Job LEADCARPASSIGNED Lead Carpenter Assigned Name of Lead Carpenter Assigne to the Job.
Job LEADCARPCELL Lead Carpenter Mobile Mobile Phone number of the Lead Carpenter
Job LEADCARPNEXTEL Lead Carpenter Nextel
Job LEADCARPWORKEMAIL Lead Carpenter Work Email
Job LEADCARPWORKEXTN Lead Carpenter Work Extn
Job LEADCARPWORKPHONE Lead Carpenter Work Phone
Job MAILADDRESS Mail Address
Job MOBILE1 Primary Contact Mobile
Job MOBILE2 Secondary Contact Mobile
Job PAYBREAKDOWN Pay Breakdown
Job PAYBREAKDOWNAMT Pay Breakdown Amount
Job PAYITEMS Payment Items
Job PAYITEMSAMT Payment Items Amount
Job PERSONADDRESS1 Primary Contact Address
Job PERSONADDRESS1ONELINE Primary Person Address on 1 Line
Job PERSONADDRESS2 Secondary Contact Address
Job PERSONADDRESS2ONELINE Secondary Person Address on 1 Line
Job POCONTACTNAME PO Contact Name
Job PRODMGRASSIGNED Production Manager Assigned
Job PRODMGRCELL Production Manager Mobile
Job PRODMGRWORKEMAIL Production Manager Work Email
Job PRODMGRWORKEXTN Production Manager Work Extn
Job PRODMGRWORKPHONE Production Manager Work Phone
Job PRODNEXTEL Production Manager Nextel
Job PROJECTMGRASSIGNED Project Manager Assigned
Job PROJECTMGRCELL Project Manager Mobile
Job PROJECTMGRNEXTEL Project Manager Nextel
Job PROJECTMGRWORKEMAIL Project Manager Work Email
Job PROJECTMGRWORKEXTN Project Manager Work Extn
Job PROJECTMGRWORKPHONE Project Manager Work Phone
Job RETAINERFEEDOLLAR Retainer Fee Amount
Job RETAINERFEETEXT Retainer Fee Amount Text
Job SALUTATION Salutation
Job SECONDPERSON Secondary Contact
Job STARTMONTHDATE Start Month Date
Job TENANT Tenant
Job WORKEMAIL1 Primary Contact Work Email
Job WORKEMAIL2 Secondary Contact Work Email
Job WORKERNAME Worker Name
Job WORKFAX1 Primary Contact Work Fax
Job WORKFAX2 Secondary Contact Work Fax
Job WORKPHONE1 Primary Contact Work Phone
Job WORKPHONE2 Secondary Contact Work Phone
JobChangeOrder CHANGEORDERSALESPERSON CO/MP Salesperson(s)
JobChangeOrder CO/MPCONTRACTSIGNERNAME CO/MP Contract Signer Name
JobChangeOrder CO/MPCONTRACTSIGNERTITLE CO/MP Contract Signer Title
JobChangeOrder CO/MPDESIGNFEES CO/MP Design Fees
JobChangeOrder CO/MPDESIGNFEETEXT CO/MP Design Fees Text
JobChangeOrder COPAYITEMS CO-MP Payment Items
JobChangeOrder COPAYITEMSAMT CO-MP Payment Items Amount
JobDesignAgreement DESIGNDESC Design Agreement Description
JobDesignAgreement DESIGNFEE Design Agreement Fee
JobDesignAgreement DESIGNFEETEXT Design Agreement Fee Text
JobDesignAgreement DESIGNMAXAMTTEXT Design Agreement Max Amount Text
JobDesignAgreement DESIGNSALESPERSON Design Agreement Salesperson
JobDesignAgreement MAXAMT Design Agreement Max Amount
JobDesignAgreement PAYBREAKDOWN Payment Breakdown Description
JobDesignAgreement PAYBREAKDOWNAMT Payment Breakdown Amount
JobEstimate ESTIMATEINFO Estimate Info
JobInvoice INVAMT Invoice Items Amount
JobInvoice INVDUE Invoice Due
JobInvoice INVITEM Invoice Items
JobInvoice INVPAID Invoice Paid
JobQuote QDATE Quote Date
JobQuote QFQTY Quote Freetext Qty
JobQuote QFREEAMT Quote Freetext Amount
JobQuote QFREEDESC Quote Freetext Description
JobQuote QIAMT Quote Item Amount
JobQuote QICATID Quote Item Category
JobQuote QICOST Quote Item Cost
JobQuote QIDESC Quote Item Description
JobQuote QILINE Quote Item Line No
JobQuote QIPROD Quote Item Product
JobQuote QIQTY Quote Item Qty
JobQuote QIUOM Quote Item UOM
JobQuote QSHIPTO Quote Ship To
JobQuote QTOTAMT Quote Item Total Amount
PO PDATE PO Date
PO PERMITOFFICE Permit Office
PO PFQTY PO Freetext Qty
PO PFREEAMT PO Freetext Amount
PO PFREEDESC PO Freetext Description
PO PIAMT PO Item Amount
PO PICATID PO Item Category
PO PICOST PO Item Cost
PO PIDESC PO Item Description
PO PILINE PO Item Line No
PO PIPROD PO Item Product
PO PIQTY PO Item Qty
PO PIUOM PO Item UOM
PO POMESSAGES PO Messages
PO POPERMITS PO Permits
PO PREF PO Reference
PO PSHIPTO PO Ship To
PO PSHIPVIA PO Ship Via
PO PTERMS Payment Terms
System COMPANYADDRESS Company Address
System COMPANYFAX Company Main Fax
System COMPANYNAME License Company Name
System COMPANYPHONE Company Main Phone
System LONGSYSDATE Long System Date

See also

Main and Sub Datasource