This article covers what comes out of the box with your ComputerEase STAC Connector for AR Invoice data mapping.
Note: Any requests for this STAC Recipe to do anything that is not described below will require additional scoping and potentially additional hours to create a custom STAC.
AR Import Data Mapping Chart
|ComputerEase Field||Data Type||Field Description||ServiceTrade Data Mapping|
|<cusnum>||string||Valid ComputerEase Customer Number.||company_computerease_id|
|<invnum>||string||If left blank, ComputerEase assigns the next invoice number.||ServiceTrade Invoice Number|
If your company uses multiple AR departments, this would be the department your company wants for this invoice.
If left blank, it would be the default dept.
|Single Entity Mapping (Ex. dept mapped to ServiceTrade Invoice office)|
|<jobnum>||string||If your company wants to post revenue to a job.||
|<taxnum>||string||If left blank, the taxnum would default to the taxnum in your company's master file, if any.||
|<invdate>||date||Should be left blank during import.||
|<duedate>||date||If left blank, ComputerEase would calculate based on the customer terms.||
||Mapped by ServiceTrade Payment terms|
|<pricecode>||string||1-6,0=cost||Single Entity Mapping|
|<salesacct>||string||Income GL account||
Double Entity Mapping
Example: Office & Job Type, Job Type & 1st Service Line
|<ponum>||string||PO Number provided by the customer who requested service||customerPo|
|<blurb>||string||Additional invoice description.||
|<description>||string||Invoice Description||Single Entity mapping|
|<source>||string||"ST" - **optional|
|<salesrepid>||string||Needs to be valid CE Sales Rep||user_computerease_id of ServiceTrade Job Salesperson|
Note: Any fields not listed here are currently not supported via the standard Connector. Please inquire with your Account Manager about customization needs so that we can determine whether your request is feasible.
- Single Entity Mapping: We can tie this to a single ServiceTrade data point.
- Double Entity Mapping: We can determine this value based on up to two ServiceTrade data points.
Please sign in to leave a comment.