- MyBusinesSystem.com

Active

Invoicing adress

Street & Nr

ZIP & City & Country

Email address

Invoice Reference

Visit adress

Street & Nr

ZIP & City & Country

Email address

Phone Nr

Delivery adress

Street & Nr

ZIP & City & Country

Email address

Delivery Notes

Economy

Price List

Currency

Payment terms

VAT

Order Nr	Order Date	Load Date	Delivery Date	Invoice Date	Currency	Amount	Weight	Status	Cod Warehouse	Warehouse	Cod Client	Client Name
10000001	23-08-2023 00:00:00	31-08-2023 00:00:00	05-09-2023 00:00:00	TRUE	SEK	11120,0000	23900,0000	TRANSIT	SU2	FRIGOSCANDIA	00001	Client Name 1
10000002	05-06-2023 00:00:00	31-08-2023 00:00:00	02-09-2023 00:00:00	TRUE	SEK	7885,0000	9500,0000	DELIVERED	P50	VENDIN	00001	Client Name 1
10000003	15-05-2023 00:00:00	07-08-2023 00:00:00	22-08-2023 00:00:00	TRUE	SEK	20658,0000	15088,0000	TRANSIT	P69	CORBAS	00003	Client Name 3
10000004	04-09-2023 00:00:00	04-09-2023 00:00:00	04-09-2023 00:00:00	TRUE	SEK	36000,0000	3600,0000	DELIVERED	SU2	FRIGOSCANDIA	00004	Client Name 4
10000084	27-10-2023 00:00:00	27-10-2023 00:00:00	27-10-2023 00:00:00	FALSE	SEK	450,0000	360,0000	COMMAND	SW01	SW01 Werehouse 1	00001	Client Name 1

MBS_UserID	MBS_ClientID	MBS_ClientName	MBS_Client_SubID	MBS_Client_SubName	UserID	UserName	FName
10	1000	MyBusinessystem.com	0001	MyBusinessystem.com	00000	admin.username	admin
11	1000	MyBusinessystem.com	0001	MyBusinessystem.com	00001	test.username	TestFname
12	1011	ExampleClientName_2	090	ExampleClientSubName_1	00002	user_1
13	1011	ExampleClientName_2	090	ExampleClientSubName_1	00003	user_2
14	1011	ExampleClientName_2	090	ExampleClientSubName_1	00004	user_3
15	1011	ExampleClientName_2	090	ExampleClientSubName_1	00005	user_4
16	1011	ExampleClientName_2	090	ExampleClientSubName_1	00006	user_5
17	1011	ExampleClientName_2	090	ExampleClientSubName_1	00007	user_6
18	1011	ExampleClientName_2	090	ExampleClientSubName_1	00008	user_7
19	1011	ExampleClientName_2	090	ExampleClientSubName_1	00009	user_8
20	1011	ExampleClientName_2	090	ExampleClientSubName_1	00010	user_9
21	1011	ExampleClientName_2	090	ExampleClientSubName_1	00011	user_10
22	1011	ExampleClientName_2	090	ExampleClientSubName_1	00012	user_11
23	1011	ExampleClientName_2	090	ExampleClientSubName_1	00013	user_12
24	1011	ExampleClientName_2	090	ExampleClientSubName_1	00014	user_13
25	1011	ExampleClientName_2	090	ExampleClientSubName_1	00015	user_14
26	1011	ExampleClientName_2	073	ExampleClientSubName_1	00016	user_1

MBS_UserID	MBS_ClientID	MBS_ClientName	MBS_Client_SubID	MBS_Client_SubName	UserID	UserName	FName
10	1000	MyBusinessystem.com	0001	MyBusinessystem.com	00000	admin.username	admin
11	1000	MyBusinessystem.com	0001	MyBusinessystem.com	00001	test.username	TestFname
12	1011	ExampleClientName_2	090	ExampleClientSubName_1	00002	user_1
13	1011	ExampleClientName_2	090	ExampleClientSubName_1	00003	user_2
14	1011	ExampleClientName_2	090	ExampleClientSubName_1	00004	user_3
15	1011	ExampleClientName_2	090	ExampleClientSubName_1	00005	user_4
16	1011	ExampleClientName_2	090	ExampleClientSubName_1	00006	user_5
17	1011	ExampleClientName_2	090	ExampleClientSubName_1	00007	user_6
18	1011	ExampleClientName_2	090	ExampleClientSubName_1	00008	user_7
19	1011	ExampleClientName_2	090	ExampleClientSubName_1	00009	user_8
20	1011	ExampleClientName_2	090	ExampleClientSubName_1	00010	user_9
21	1011	ExampleClientName_2	090	ExampleClientSubName_1	00011	user_10
22	1011	ExampleClientName_2	090	ExampleClientSubName_1	00012	user_11
23	1011	ExampleClientName_2	090	ExampleClientSubName_1	00013	user_12
24	1011	ExampleClientName_2	090	ExampleClientSubName_1	00014	user_13
25	1011	ExampleClientName_2	090	ExampleClientSubName_1	00015	user_14
26	1011	ExampleClientName_2	073	ExampleClientSubName_1	00016	user_1

CodClient	ClientName	Active	Visit Street StreetNr	Visit ZIP City Country	E-mail	Phone Nr_1	Phone Nr_2	Phone Nr_3	MainActivity	AccountManager	Affiliation	Category	VAT	OrgNr	ClientShortName	VisitMunicipality	VisitCounty	VisitCounty council/region	GeneralFax	WebPage	Responsible	Status	SeasonBuyer	ClearanceSalesBuyer	Chain	MainWholesaler	ClientNrbyWholesaler	SuperClient	NationalClient	RegionalClient	ClientComment	Latitude	Longitude	ClientsCreationDate	Blocked	BlockDate	InvoiceStreet	InvoiceStreetNr	InvoiceZIP	InvoiceCity	InvoiceMunicipality	InvoiceCounty	InvoiceCounty council/region	InvoiceCountry	InvoiceEmail	InvoiceReference	CodPriceList	PriceList	CodCurrency	Currency	CodPaymentTerms	PaymentTerms	DeliveryStreet	DeliveryStreetNr	DeliveryZIP	DeliveryCity	DeliveryMunicipality	DeliveryCounty	DeliveryCounty council/region	DeliveryCountry	DeliveryEmail	DeliveryNotes
00001	Client Name 1	TRUE	Street 1 1	41104 Göteborg Sweden	example@mail.com	+46707111222	genphone2	genphone3	Hotel/motel	Account manager 1	Affiliation	Category	SE550131001101	550131-0011	ShortName	Göteborg	Västra Götaland	Västra Götaland	genfax	www.webpage.com	Responsible	A	TRUE	TRUE	Menigo	Menigo	ClientNrbyWholesaler	superclient	narionalclient	regionaleclient	ClientComment	Latitude	Longitude	01-09-2023 00:00:00	TRUE	15-08-2023 00:00:00	invoice street	invoicestreetnr	invoice zip	invoice city	invoice Mun	invoice county	invoice region	invoice country	invoice email	invoice ref	00001	Price List 1	00001	SEK	00001	30 days	delivery street	deliverystreetnr	delivery zip	delivery city	delivery mun	delivery county	delivery region	delivery country	delivery email	dellivery notes
00002	Client Name 2	FALSE	Street 2 2	41104 Göteborg Sweden	example@mail.com	+46707111222			Hotel/motel	Account Manager	Affiliation	Category	SE550131001101	550131-0011		Göteborg	Västra Götaland	Västra Götaland		www.webpage.com	Responsible	A	FALSE	FALSE	Menigo	Menigo	ClientNrbyWholesaler				ClientComment	Latitude	Longitude	01-09-2023 00:00:00	FALSE												00001	Price List 1	00001	SEK	00001	30 days
00003	Client Name 3	TRUE	Street 3 3	41104 Göteborg Sweden	example@mail.com	+46707111222			Hotel/motel	Account Manager	Affiliation	Category	SE550131001101	550131-0011		Göteborg	Västra Götaland	Västra Götaland		www.webpage.com	Responsible	A	FALSE	FALSE	Menigo	Menigo	ClientNrbyWholesaler				ClientComment	Latitude	Longitude	01-09-2023 00:00:00	FALSE												00001	Price List 1	00001	SEK	00001	30 days
00004	Client Name 4	TRUE	Street 4 4	25200 Helsingborg Sweden	example@mail.com	+46707111222			Hotel/motel	Account Manager	Affiliation	Category	SE550131001101	550131-0011		Helsingborg	Skåne	Skåne		www.webpage.com	Responsible	A	FALSE	FALSE	Menigo	Menigo	ClientNrbyWholesaler				ClientComment	Latitude	Longitude	01-09-2023 00:00:00	FALSE												00001	Price List 1	00001	SEK	00001	30 days
00005	Client Name 5	TRUE	Street 5 5	25200 Helsingborg Sweden	example@mail.com	+46707111222			Hotel/motel	Account Manager	Affiliation	Category	SE550131001101	550131-0011		Helsingborg	Skåne	Skåne		www.webpage.com	Responsible	A	FALSE	FALSE	Menigo	Menigo	ClientNrbyWholesaler				ClientComment	Latitude	Longitude	01-09-2023 00:00:00	FALSE												00001	Price List 1	00001	SEK	00001	30 days
00006	Client Name 6	TRUE	Street 6 6	25200 Helsingborg Sweden	example@mail.com	+46707111222			Hotel/motel	Account Manager	Affiliation	Category	SE550131001101	550131-0011		Helsingborg	Skåne	Skåne		www.webpage.com	Responsible	A	FALSE	FALSE	Menigo	Menigo	ClientNrbyWholesaler				ClientComment	Latitude	Longitude	01-09-2023 00:00:00	FALSE												00001	Price List 1	00001	SEK	00001	30 days
00007	Client Name 7	TRUE	Street 7 7	30104 Halmstad Sweden	example@mail.com	+46707111222			Hotel/motel	Account Manager	Affiliation	Category	SE550131001101	550131-0011		Halmstad	Halland	Halland		www.webpage.com	Responsible	A	FALSE	FALSE	Menigo	Menigo	ClientNrbyWholesaler				ClientComment	Latitude	Longitude	01-09-2023 00:00:00	FALSE												00001	Price List 1	00001	SEK	00001	30 days
00008	Client Name 8	TRUE	Street 8 8	21110 Malmö Sweden	example@mail.com	+46707111222			Hotel/motel	Account Manager	Affiliation	Category	SE550131001101	550131-0011		Malmö	Skåne	Skåne		www.webpage.com	Responsible	A	FALSE	FALSE	Menigo	Menigo	ClientNrbyWholesaler				ClientComment	Latitude	Longitude	01-09-2023 00:00:00	FALSE												00001	Price List 1	00001	SEK	00001	30 days
00009	Client Name 9	TRUE	Street 9 9	21110 Malmö Sweden	example@mail.com	+46707111222			Hotel/motel	Account Manager	Affiliation	Category	SE550131001101	550131-0011		Malmö	Skåne	Skåne		www.webpage.com	Responsible	A	FALSE	FALSE	Menigo	Menigo	ClientNrbyWholesaler				ClientComment	Latitude	Longitude	01-09-2023 00:00:00	FALSE												00001	Price List 1	00001	SEK	00001	30 days
00010	Client Name 10	TRUE	Street 10 10	21110 Malmö Sweden	example@mail.com	+46707111222			Hotel/motel	Account Manager	Affiliation	Category	SE550131001101	550131-0011		Malmö	Skåne	Skåne		www.webpage.com	Responsible	A	FALSE	FALSE	Menigo	Menigo	ClientNrbyWholesaler				ClientComment	Latitude	Longitude	01-09-2023 00:00:00	FALSE												00001	Price List 1	00001	SEK	00001	30 days
00011	Client Name 11	TRUE	Street 11 11	30104 Halmstad Sweden	example@mail.com	+46707111222			Hotel/motel	Account Manager	Affiliation	Category	SE550131001101	550131-0011		Halmstad	Halland	Halland		www.webpage.com	Responsible	A	FALSE	FALSE	Menigo	Menigo	ClientNrbyWholesaler				ClientComment	Latitude	Longitude	01-09-2023 00:00:00	FALSE												00001	Price List 1	00001	SEK	00001	30 days
00012	Client Name 12	TRUE	Street 12 12	30104 Halmstad Sweden	example@mail.com	+46707111222			Hotel/motel	Account Manager	Affiliation	Category	SE550131001101	550131-0011		Halmstad	Halland	Halland		www.webpage.com	Responsible	A	FALSE	FALSE	Menigo	Menigo	ClientNrbyWholesaler				ClientComment	Latitude	Longitude	01-09-2023 00:00:00	FALSE												00001	Price List 1	00001	SEK	00001	30 days
00013	Client Name 13	TRUE	Street 13 13	41104 Göteborg Sweden	example@mail.com	+46707111222			Hotel/motel	Account Manager	Affiliation	Category	SE550131001101	550131-0011		Göteborg	Västra Götaland	Västra Götaland		www.webpage.com	Responsible	A	FALSE	FALSE	Menigo	Menigo	ClientNrbyWholesaler				ClientComment	Latitude	Longitude	01-09-2023 00:00:00	FALSE												00001	Price List 1	00001	SEK	00001	30 days
00014	Client Name 14	TRUE	Street 14 14	41104 Göteborg Sweden	example@mail.com	+46707111222			Hotel/motel	Account Manager	Affiliation	Category	SE550131001101	550131-0011		Göteborg	Västra Götaland	Västra Götaland		www.webpage.com	Responsible	A	FALSE	FALSE	Menigo	Menigo	ClientNrbyWholesaler				ClientComment	Latitude	Longitude	01-09-2023 00:00:00	FALSE												00001	Price List 1	00001	SEK	00001	30 days
00015	Client Name 15	TRUE	Street 15 15	41104 Göteborg Sweden	example@mail.com	+46707111222			Hotel/motel	Account Manager	Affiliation	Category	SE550131001101	550131-0011		Göteborg	Västra Götaland	Västra Götaland		www.webpage.com	Responsible	A	FALSE	FALSE	Menigo	Menigo	ClientNrbyWholesaler				ClientComment	Latitude	Longitude	01-09-2023 00:00:00	FALSE												00001	Price List 1	00001	SEK	00001	30 days
00016	Client Name 16	TRUE	Street 16 16	41104 Göteborg Sweden	example@mail.com	+46707111222			Hotel/motel	Account Manager	Affiliation	Category	SE550131-0011	550131-0011		Göteborg	Västra Götaland	Västra Götaland		www.webpage.com	Responsible	A	FALSE	FALSE	Nores	Servera	ClientNrbyWholesaler				ClientComment	56.04763140956949	12.732639312744142	01-01-2021 00:00:00	FALSE	31-12-2100 00:00:00											00001	Price List 1	00001	SEK	00001	30 days
00017	Client Name 17	TRUE	Street 17 17	41104 Göteborg Sweden	example@mail.com	+46707111222			Hotel/motel	Account Manager	Affiliation	Category	SE550131-0011	550131-0011		Göteborg	Västra Götaland	Västra Götaland		www.webpage.com	Responsible	A	FALSE	FALSE	Nores	Servera	ClientNrbyWholesaler				ClientComment	56.04763140956949	12.732639312744142	01-01-2021 00:00:00	FALSE	31-12-2100 00:00:00											00001	Price List 1	00001	SEK	00001	30 days
00018	Client Name 18	TRUE	Street 18 18	41104 Göteborg Sweden	example@mail.com	+46707111222			Hotel/motel	Account Manager	Affiliation	Category	SE550131-0011	550131-0011		Göteborg	Västra Götaland	Västra Götaland		www.webpage.com	Responsible	A	FALSE	FALSE	Nores	Servera	ClientNrbyWholesaler				ClientComment	56.04763140956949	12.732639312744142	01-01-2021 00:00:00	FALSE	31-12-2100 00:00:00											00001	Price List 1	00001	SEK	00001	30 days
00019	Client Name 19	TRUE	Street 19 19	41104 Göteborg Sweden	example@mail.com	+46707111222			Hotel/motel	Account Manager	Affiliation	Category	SE550131-0011	550131-0011		Göteborg	Västra Götaland	Västra Götaland		www.webpage.com	Responsible	A	FALSE	FALSE	Nores	Servera	ClientNrbyWholesaler				ClientComment	56.04763140956949	12.732639312744142	01-01-2021 00:00:00	FALSE	31-12-2100 00:00:00											00001	Price List 1	00001	SEK	00001	30 days
CodClient	ClientName	Active	Visit Street StreetNr	Visit ZIP City Country	E-mail	Phone Nr_1	Phone Nr_2	Phone Nr_3	MainActivity	AccountManager	Affiliation	Category	VAT	OrgNr	ClientShortName	VisitMunicipality	VisitCounty	VisitCounty council/region	GeneralFax	WebPage	Responsible	Status	SeasonBuyer	ClearanceSalesBuyer	Chain	MainWholesaler	ClientNrbyWholesaler	SuperClient	NationalClient	RegionalClient	ClientComment	Latitude	Longitude	ClientsCreationDate	Blocked	BlockDate	InvoiceStreet	InvoiceStreetNr	InvoiceZIP	InvoiceCity	InvoiceMunicipality	InvoiceCounty	InvoiceCounty council/region	InvoiceCountry	InvoiceEmail	InvoiceReference	CodPriceList	PriceList	CodCurrency	Currency	CodPaymentTerms	PaymentTerms	DeliveryStreet	DeliveryStreetNr	DeliveryZIP	DeliveryCity	DeliveryMunicipality	DeliveryCounty	DeliveryCounty council/region	DeliveryCountry	DeliveryEmail	DeliveryNotes

Warehouse

CodWarehouse	Warehouse
SW01	Werehouse 1
SW02	Werehouse 2
SW03	Werehouse 3
SW04	Werehouse 4
SW05	Werehouse 5

Transport Company

Transport_companyID	Transport_company
1	Transport Company 1
2	Transport Company 2
3	Transport Company 3
4	Transport Company 4
5	Transport Company 5

Product

CodProduct	Product	Unit	Unit_weight	Unit_Price	Product
PROD1	PRODUKT1	1,0000	20,0000	25,0000	PRODUKT1
PROD2	PRODUKT2jhfosihoghi	0,0000	0,0000	0,0000	PRODUKT2jhfosihoghi
PROD3	PRODUKT3jfsla	0,0000	0,0000	0,0000	PRODUKT3jfsla
PROD4	PRODUKT4fisoifoasifndfasgasgas<	0,0000	0,0000	0,0000	PRODUKT4fisoifoasifndfasgasgas<
PROD5	PRODUKT5	0,0000	0,0000	0,0000	PRODUKT5

Quantity

Unit

Weight

Price

Total Amount

Total Weight

Product 2

CodProduct	Product	Unit	Unit_weight	Unit_Price	Product
PROD1	PRODUKT1	1,0000	20,0000	25,0000	PRODUKT1
PROD2	PRODUKT2jhfosihoghi	0,0000	0,0000	0,0000	PRODUKT2jhfosihoghi
PROD3	PRODUKT3jfsla	0,0000	0,0000	0,0000	PRODUKT3jfsla
PROD4	PRODUKT4fisoifoasifndfasgasgas<	0,0000	0,0000	0,0000	PRODUKT4fisoifoasifndfasgasgas<
PROD5	PRODUKT5	0,0000	0,0000	0,0000	PRODUKT5

Quantity 2

Unit 2

Weight 2

Price 2

Total Amount 2

Total Weight 2

Product 3

CodProduct	Product	Unit	Unit_weight	Unit_Price	Product
PROD1	PRODUKT1	1,0000	20,0000	25,0000	PRODUKT1
PROD2	PRODUKT2jhfosihoghi	0,0000	0,0000	0,0000	PRODUKT2jhfosihoghi
PROD3	PRODUKT3jfsla	0,0000	0,0000	0,0000	PRODUKT3jfsla
PROD4	PRODUKT4fisoifoasifndfasgasgas<	0,0000	0,0000	0,0000	PRODUKT4fisoifoasifndfasgasgas<
PROD5	PRODUKT5	0,0000	0,0000	0,0000	PRODUKT5

Quantity 3

Unit 3

Weight 3

Price 3

Total Amount3

Total Weight

Product 4

CodProduct	Product	Unit	Unit_weight	Unit_Price	Product
PROD1	PRODUKT1	1,0000	20,0000	25,0000	PRODUKT1
PROD2	PRODUKT2jhfosihoghi	0,0000	0,0000	0,0000	PRODUKT2jhfosihoghi
PROD3	PRODUKT3jfsla	0,0000	0,0000	0,0000	PRODUKT3jfsla
PROD4	PRODUKT4fisoifoasifndfasgasgas<	0,0000	0,0000	0,0000	PRODUKT4fisoifoasifndfasgasgas<
PROD5	PRODUKT5	0,0000	0,0000	0,0000	PRODUKT5

Quantity 4

Unit 4

Weight 4

Price 4

Total Amount 4

Total Weight 4

Product 5

CodProduct	Product	Unit	Unit_weight	Unit_Price	Product
PROD1	PRODUKT1	1,0000	20,0000	25,0000	PRODUKT1
PROD2	PRODUKT2jhfosihoghi	0,0000	0,0000	0,0000	PRODUKT2jhfosihoghi
PROD3	PRODUKT3jfsla	0,0000	0,0000	0,0000	PRODUKT3jfsla
PROD4	PRODUKT4fisoifoasifndfasgasgas<	0,0000	0,0000	0,0000	PRODUKT4fisoifoasifndfasgasgas<
PROD5	PRODUKT5	0,0000	0,0000	0,0000	PRODUKT5

Quantity5

Unit5

Weight 5

Price 5

Total Amount 5

Total Weight 5

Summa Quantity

Currency

Summa Amount

Summa Weight

Cod Product	Ordered Quanity	Unit	Unit weight	Unit Price	Total Amount	Total Weight

Cod Product	Ordered Quanity	Unit	Unit weight	Unit Price	Total Amount	Total Weight

Load Date

Delivery Date

Order Nr	CodProduct	Product	CodPackType	PackType	CodPallet	Pallet	Ordered_Qty	Loaded_Qty	Delivered_Qty	Unit	Unit_weight	Unit_Price	InvoiceAmount	InvoiceWeight	PickingCost	TransportCost
10000001	PROD1	PRODUKT1	00	Standard	30	EUR-PALLET	10	10	10	BOX	350,0000	120,0000	1200,0000	3500,0000	0,0000	0,0000
10000001	PROD2	PRODUKT2	00	Standard	30	EUR-PALLET	20	20	20	BOX	300,0000	100,0000	2000,0000	6000,0000	0,0000	0,0000
10000001	PROD3	PRODUKT3	00	Standard	30	EUR-PALLET	72	72	72	BOX	200,0000	110,0000	7920,0000	14400,0000	0,0000	0,0000
10000002	PROD4	PRODUKT4	00	Standard	30	EUR-PALLET	95	95	95	BOX	100,0000	83,0000	7885,0000	9500,0000	0,0000	0,0000
10000003	PROD5	PRODUKT5	00	Standard	30	EUR-PALLET	2112	2112	2112	BOX	3,6000	185,0000	390720,0000	7603,0000	0,0000	0,0000
10000004	PROD1	PRODUKT1	00	Standard	30	EUR-PALLET	100	100	100	BOX	3,6000	360,0000	36000,0000	3600,0000	0,0000	0,0000

Show/hide more details!

Invoicing adress

Visit adress

Delivery adress

Economy