VismaBusiness
Overview
We generally create order files whenever there are new, processed orders, but some customers prefer to receive files with orders for the last X days (then we can also add shipment tracking info, etc).
Product file(s) are generally created once a day.
EDI Order format
Unless you have specific requirements, our standard order file looks like this:
8; 2;
H; ; OrderID; 1; Order total; 137; Customer number; Company (billing); Address (billing); Department (billing); Attention (billing); ; Postcode (billing); City (billing); ; DealerCompanyName; DealerAddress; ; ; ; Dealer ZIP/City ; ; Order date (YYYYMMDD); ; ; ; ; ; ; Customer reference; Email; ; ; ; ; ; ; ; ; 1; ; ; ; ; ; ; ; ; ; Company (shipping); Address (shipping); Department (shipping); Attention (shipping); ; Postcode (shipping); City (shipping); OurRef; YourRef; ; ReqNo ; ; SalesPersonNo; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; -1;
L; 1; MfgSKU; Product name; Qty; Price; Cost; Cost; ; ; ; ; ; ; Order date (YYYYMMDD); ; ; ; ;Distributor number ; ; ; ; ;Internal user number Visma; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;Manufacturer; Distributor; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;
L; 2; VismaFreightSKU; FreightText; 1; Delivery cost; 0 ; 0 ; ; ; ; ; ; ; Order date (YYYYMMDD); ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;
L; 3; -; Payment method; 1; ; 0 ; 0 ; ; ; ; ; ; ; Order date (YYYYMMDD); ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;
L; 4; -; Admin comment; 1; ; 0 ; 0 ; ; ; ; ; ; ; Order date (YYYYMMDD); ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;
L; 5; -; Customer comment; 1; ; 0 ; 0 ; ; ; ; ; ; ; Order date (YYYYMMDD); ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;
L1 - product - will be repeated as many times as there are product lines in the order.
Payment method, admin comment, customer comment are optional, and not that common to include.
Product file
short version
@Prod (ProdNo, Descr, ProdGr, ProdTp, StSaleUn, ProdPrGr, SpecFunc, ExcPrint, EditPref, EdFmt, ExpStr, PrM2b, WageSrt, DesMrg, NrmStc, ProcMt)
"417756-421" "HP ProLiant DL140 R03 Xeon 5110" "1" "0" "0" "0" "0" "16384" "512" "0" "0" "0" "" "0" "0" "67108864"
Complete Product file
@Prod (ProdNo, Descr, ProdGr, ProdTp, StSaleUn, ProdPrGr, SpecFunc, ExcPrint, EditPref, EdFmt, ExpStr, PrM2b, WageSrt, DesMrg, NrmStc, ProcMt, AgrAct, NWgtU, TareU, VolU, CusStNo, RepProd, R1, R2, R3, R4, R5, R6, Gr, Gr2, Gr3, Gr4, Gr5, Gr6, Inf, Inf2, Inf3, Inf4, Inf5, Inf6, ExArr, ExQty, NoteNm, CstPrAdd, GrSep, EUStatNo, ProdTp2, FrNo, ToNo, Factor3, InvoPlLn, Rsp, Buyer, ProdPrG2, ProdPrG3, LgtU, WdtU, HgtU, AreaU, Measure, StUnRt, Gr7, Gr8, Gr9, Gr10, Gr11, Gr12, Inf7, Inf8, ProdTp3, ProdTp4, TrInf1, TrInf2, Rsp2, PrUn, PrNo, DensU, TrTp, TrAm, PrM1b, PrM1c, PrM2c, PrM3b, PrM3c, PrM4b, PrM4c, PrM5b, PrM5c, PictNo, TrInf3, TrInf4, OldPNo, SPrAdd, EANItmNo, ProdPro, PrCatNo, PrCatNo2, NwProdNo, WebPg2, PgElNo, R7, R8, R9, R10, R11, R12, WfId, PLDNo, PLDFlow, Free1, Free2, Free3, Free4, PrCatNo3, PrCatNo4, PrCatNo5, PrCatNo6, AgrProc, NxtSerNo, WageRtNo, PrK)
"417756-421" "HP ProLiant DL140 R03 Xeon 5110" "1" "0" "0" "0" "0" "16384" "512" "0" "0" "0" "" "0" "0" "67108864" "0" "0" "0" "0" "" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "" "" "" "" "" "" "0" "0" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "" "" "0" "0" "" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "" "" "" "" "0" "" "0" "0" "0" "" "" "0" "" "" "" "" "" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0"
Customers
@Actor (=Custno, nm,ad1, ad2, ad3, ad4, Pno, PArea, Ctry, CustPrGR, Inf7, Phone, MailAd)
"20005" "testfirma AS" "GATE 1" "Postboks 1" "ad3" "ad4" "3200" "sandefjord" "47" "3" "webmercs" "33445566" "tst@kjlhok.no"