XML eGateway Import: Job Entity
The Job Entity represents Job in Job costing module, which is used for detailed job costing analysis.
FieldName |
DataType |
Length |
DefaultValue |
Notes |
jrAcCode |
String |
20 |
Required, Customer Code 6chars but 20 if MatchOnID=acAltCode |
|
jrAltCode |
String |
10 |
Alt search ref for job |
|
jrChargeType |
Integer |
|
0 |
0=Time and Materials,1=Fixed Price,2=Cost Plus, 3=Non Productive |
jrCode |
String |
10 |
Exchequer Job code |
|
jrContact |
String |
25 |
Contact name |
|
jrDatedNotes_AlarmDate |
Date |
|
Add date notes to account |
|
jrDatedNotes_Note |
String |
65 |
Add date notes to account |
|
jrDatedNotes_User |
String |
10 |
Add date notes to account |
|
jrDesc |
String |
30 |
Job Description |
|
jrEndDate |
Date |
|
||
jrGeneralNotes |
STRING |
|
General notes This gets appended to notes on every update |
|
jrJobtype |
String |
3 |
Required, used for analysis This related to a list of Job Types set in Exchequer |
|
jrLinkDoc1_Description |
String |
60 |
Add Linked document |
|
jrLinkDoc1_FileName |
String |
84 |
Add Linked document |
|
jrLinkDoc2_Description |
String |
60 |
Add Linked document |
|
jrLinkDoc2_FileName |
String |
84 |
Add Linked document |
|
jrManager |
String |
25 |
||
jrMatchByExternalRef |
Boolean |
If Yes then: |
||
jrOLECode |
String |
6 |
If different from system settings then will change company |
|
jrParent |
String |
10 |
Exchequer Job Parent code in Tree |
|
jrQuotePrice |
Decimal |
|
Quoted price if fixed price |
|
jrQuotePriceCurr |
Integer |
|
1 |
|
jrRevisedEndDate |
Date |
|
||
jrSORnumber |
String |
10 |
SOR Ref |
|
jrStartDate |
Date |
|
||
jrStatus |
Integer |
|
1 |
0=Quotation,1=Active,2=Suspended,3=Completed, 4=Closed |
jrType |
Integer |
|
1 |
0=Contract,1=Job,2=Phase |
jrUserField1 |
String |
20 |
User Field |
|
jrUserField2 |
String |
20 |
User Field |
|
jrUserField3 |
String |
20 |
User Field |
|
jrUserField4 |
String |
20 |
User Field |
|
jrVATCode |
String |
1 |
S |
Exchequer Default VAT Code |
For Example, for Exchequer Software Job record insert/update:
<?xml version="1.0" ?>
<ExchequerData>
<Job>
<!-- Create/Update Exchequer Job record, in XML -->
<!-- Required Fields -->
<jrCode>MYTESTJOB</jrCode>
<!-- The account is matched based on the system setting either
acCode or acAltCode -->
<jrAcCode>ABAP01</jrAcCode>
<jrDesc>My TEst Stock Item</jrDesc>
<!-- Position in Job Tree -->
<jrParent>MAIN01</jrParent>
<!-- Job Type Analysis code -->
<jrJobtype>BM1</jrJobtype>
<!-- Optional Fields -->
<jrStartDate>2005-05-31</jrStartDate>
<jrQuotePrice>12000</jrQuotePrice>
<!-- 0=Time and Materials,1=Fixed Price,2=Cost Plus,3=Non Productive -->
<jrChargeType>1</jrChargeType>
<jrGeneralNotes>General Note can be imported against the Transaction</jrGeneralNotes>
<!-- Add linked document, note PATH+Filename must not exceed 84 chrs -->
<jrLinkDoc1_FileName>D:\example\Contract.txt</jrLinkDoc1_FileName>
<jrLinkDoc1_Description>Job Notes</jrLinkDoc1_Description>
<!-- Add an alarm to document -->
<jrDatedNotes_AlarmDate>2005-05-31</jrDatedNotes_AlarmDate>
<jrDatedNotes_Note>Set budgets for job</jrDatedNotes_Note>
<jrDatedNotes_User>MANAGER</jrDatedNotes_User>
</Job>
</ExchequerData>
More examples included with test program
Long external account numbers
if < MatchCustomerOnID>acAltCode</ MatchCustomerOnID> is on system settings, then XML eGateway will lookup the Exchequer Software customer code, based on customer Alt search code.
Export notes:
After many years of experience writing links between Exchequer and external systems we have added the following fields to our data export. More information about exporting data
FieldName | DataType | Length | Notes |
jrDatedNote |
String |
0 |
Last 5 lines of dataed notes |