XML eGateway Import: Stock Entity
The Stock Entity represents Stock records. Note this entity has many required elements.
FieldName |
DataType |
Length |
DefaultValue |
Notes |
stAltCode |
String |
16 |
Alt search ref |
|
stAnalysisCode |
String |
10 |
Default Job Analysis code |
|
stBalSheetGL |
Integer |
|
† |
Required stock value GL |
stBarCode |
String |
20 |
Bar code |
|
stBinLocation |
String |
8 |
Bin location ref |
|
stCode |
String |
16 |
Exchequer Stock code |
|
stCOSGL |
Integer |
|
† |
Required |
stCostCentre |
String |
3 |
† |
Exchequer Cost Centre Default Analysis |
stCostPriceCur |
Integer |
1 |
Cost Price currency |
|
stDatedNotes_AlarmDate |
Date |
♦ | Add date notes to account |
|
stDatedNotes_Note |
String |
65 |
♦ | Add date notes to account |
stDatedNotes_User |
String |
10 |
♦ | Add date notes to account |
stDefaultLineType |
Integer |
|
Default line type when adding transaction 0-4 Usually 0 |
|
stDepartment |
String |
3 |
† |
Exchequer Default Department Analysis |
stDesc1 |
String |
35 |
Required |
|
stDesc2 |
String |
35 |
||
stDesc3 |
String |
35 |
||
stDesc4 |
String |
35 |
||
stDesc5 |
String |
35 |
||
stDesc6 |
String |
35 |
||
stGeneralNotes |
STRING |
999 |
General notes Not exported if CSV First 500 chrs, "<br/>" is used for new line This gets appended to notes on every update |
|
stImageFile |
String |
30 |
||
stLinkDoc1_Description |
String |
60 |
♦ | Add Linked document |
stLinkDoc1_FileName |
String |
84 |
♦ | Add Linked document |
stLinkDoc2_Description |
String |
60 |
♦ | Add Linked document |
stLinkDoc2_FileName |
String |
84 |
♦ | Add Linked document |
stLocation |
String |
3 |
† |
Default location code |
stOLECode |
String |
6 |
♦ | If different from system settings then will change company |
stPandLGL |
Integer |
|
† |
Required, Closing/Write off GL on Profit & Loss |
stParentCode |
String |
16 |
Required, Parent code in tree |
|
stPriceBandA_Currency |
Integer |
|
1 |
Price Band Currency |
stPriceBandA_Price |
Decimal |
|
Price Band Price |
|
stPriceBandB_Currency |
Integer |
|
1 |
Price Band Currency |
stPriceBandB_Price |
Decimal |
|
Price Band Price |
|
stPriceBandC_Currency |
Integer |
|
1 |
Price Band Currency |
stPriceBandC_Price |
Decimal |
|
Price Band Price |
|
stPriceBandD_Currency |
Integer |
|
1 |
Price Band Currency |
stPriceBandD_Price |
Decimal |
|
Price Band Price |
|
stPriceBandE_Currency |
Integer |
|
1 |
Price Band Currency |
stPriceBandE_Price |
Decimal |
|
Price Band Price |
|
stPriceBandF_Currency |
Integer |
|
1 |
Price Band Currency |
stPriceBandF_Price |
Decimal |
|
Price Band Price |
|
stPriceBandG_Currency |
Integer |
|
1 |
Price Band Currency |
stPriceBandG_Price |
Decimal |
|
Price Band Price |
|
stPriceBandH_Currency |
Integer |
|
1 |
Price Band Currency |
stPriceBandH_Price |
Decimal |
|
Price Band Price |
|
stPricingMethod |
Integer |
|
0 |
0=StockUnit,1=SalesUnit,2=SplitPack |
stPurchaseReturnGL |
Integer |
|
† |
Required if returns module enabled |
stPurchUnits |
Decimal |
|
Qty Multiplier |
|
stQtyMax |
Decimal |
|
Reorder Max |
|
stQtyMin |
Decimal |
|
Reorder Min |
|
stReorderCostCentre |
String |
3 |
||
stReorderCur |
Integer |
|
||
stReorderDepartment |
String |
3 |
||
stReorderPrice |
Decimal |
|
||
stReorderQty |
Decimal |
|
||
stRestockCharge |
Decimal |
|
Returns Restock charge |
|
stRestockFlag |
Boolean |
|
Returns 0=Value,1=Percent |
|
stSalesGL |
Integer |
|
† |
Write off GL on Profit & Loss |
stSalesReturnGL |
Integer |
|
† |
Required if returns module enabled |
stSalesUnits |
Decimal |
|
1 |
Qty Multiplier |
stSalesWarrantyLength |
Integer |
|
Returns Warranty Length |
|
stSalesWarrantyUnits |
Integer |
|
Returns Warranty unit1 0=Days,1=Weeks, 2=Months,3=Years |
|
stShowKitOnPurchase |
Boolean |
|
Take price from BOM |
|
stShowKitOnSales |
Boolean |
|
Take price from BOM |
|
stShowQtyAsPacks |
Boolean |
|
||
stSupplier |
String |
20 |
Default Supplier, Customer Code 6chars but 20 if MatchOnID=acAltCode |
|
stTypeSt |
String |
4 |
Export Only |
text version of stType for export Prod,Head,Desc,BOM |
stType |
String |
1 |
Required 0 =Group,1 =Product,2 =Description, 3 =Bill of Materials,4 =Discontinued |
|
stUnitOfPurch |
String |
10 |
each |
Description of units e.g. each, metre |
stUnitOfSale |
String |
10 |
each |
Description of units e.g. each, metre |
stUnitOfStock |
String |
10 |
each |
Description of units e.g. each, metre |
stUseForEbus |
Boolean |
|
Allow Web Called "Include on Web" in system |
|
stUseKitPrice |
Boolean |
|
Take price from BOM |
|
stUserField1 |
String |
20 |
User defined |
|
stUserField2 |
String |
20 |
User defined |
|
stUserField3-10 |
String |
30 |
User defined |
|
stUsesBins |
Boolean |
|
Use Multi bin flg |
|
stValMethSt |
String |
5 |
Export Only |
text version of stValuationMethod for export Cost,Avg,Stand,FIFO,LIFO,Ser,SerA |
stValuationMethod |
Integer |
|
0=Standard,1=LastCost,2=FIFO,3=LIFO, 4=Average,5=Serial/Batch,6=Serial/Batch Avg |
|
stVATCode |
String |
1 |
S † |
Exchequer Default VAT code |
stWebPrevCatalog |
String |
20 |
||
stWIPGL |
Integer |
|
† |
Required Work in progress GL |
stWOPAssemblyDays |
Integer |
|
for WOP |
|
stWOPAssemblyHours |
Integer |
|
for WOP |
|
stWOPAssemblyMins |
Integer |
|
for WOP |
|
stWOPAutoCalcTime |
Boolean |
|
for WOP |
|
stWOPIssuedWIPGL |
Integer |
|
† |
Required, for WOP |
stWOPMinEconBuild |
Decimal |
|
for WOP |
|
stWOPRoLeadTime |
Integer |
|
for WOP |
† = These fields are defined as string in DTD to allow for conversion in PostTrans
♦ Not exported in Pro version, import only
For Example, for Exchequer Software Stock Record insert/update, in XML
<?xml version="1.0" ?>
<ExchequerData>
<Stock>
<!-- Create/Update Exchequer Stock record, in XML -->
<!-- Required Fields -->
<stCode>MYXTEST03</stCode>
<stDesc1>My TEst Stock Item</stDesc1>
<!-- Fill in required GL Codes -->
<stCOSGL>990</stCOSGL>
<stPandLGL>990</stPandLGL>
<stSalesGL>990</stSalesGL>
<stWIPGL>990</stWIPGL>
<stBalSheetGL>990</stBalSheetGL>
<stPurchaseReturnGL>990</stPurchaseReturnGL>
<stSalesReturnGL>990</stSalesReturnGL>
<!-- Position in stock tree -->
<stParentCode>ELECTRICAL</stParentCode>
<!-- Valuation method 0=Standard,1=LastCost,2=FIFO,3=LIFO,
4=Average,5=Serial/Batch,6=Serial/Batch Avg -->
<stValuationMethod>0</stValuationMethod>
<!-- Optional Fields -->
<stDesc2>Second line</stDesc2>
<stPriceBandA_Price>12.50</stPriceBandA_Price>
<stPriceBandB_Price>11.50</stPriceBandB_Price>
<stGeneralNotes>General Note can be imported against the Transaction</stGeneralNotes>
<!-- Add linked document, note PATH+Filename must not exceed 84 chrs -->
<stLinkDoc1_FileName>D:\example\Contract.txt</stLinkDoc1_FileName>
<stLinkDoc1_Description>Specification</stLinkDoc1_Description>
<!-- Add an alarm to document -->
<stDatedNotes_AlarmDate>2005-05-31</stDatedNotes_AlarmDate>
<stDatedNotes_Note>Get Stock urgent</stDatedNotes_Note>
<stDatedNotes_User>MANAGER</stDatedNotes_User>
</Stock>
</ExchequerData>
More examples included with test program
Long external account numbers
if < MatchSupplierOnID>acAltCode</ MatchSupplierOnID> is on system settings, then XML eGateway will lookup the Exchequer supplier code, based on supplier 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 |
stDatedNote |
String |
|
Last 5 lines of dated notes |
stLastUsed |
Date |
|
Date stock had a movement/amend |
stNextPORDate |
Date |
|
Next POR Due date. 01/01/1900 if none |
stParent1 |
String |
16 |
Top Group, in stock tree, the stock item is in |
stParent2 |
String |
16 |
Second Group, in stock tree, the stock item is in |
stParent3 |
String |
16 |
Third Group, in stock tree, the stock item is in |
stParent4 |
String |
16 |
Forth Group, in stock tree, the stock item is in |
stParent5 |
String |
16 |
Fifth Group, in stock tree, the stock item is in |
stParent6 |
String |
16 |
Sixth Group, in stock tree, the stock item is in |
stQtyFree |
Double |
|
Free to sell |
stQtyInStock |
Double |
|
Qty in stock, but these could be allocated or being processed |
stQtyOnOrder |
Double |
|
Qty on Order on POR's |