ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Database Structure
2
Sheet NameFieldField TypeData SourceAccess RightsRemarks
3
CustomersCustomer IDAuto-GenerateAuto-GenerateSalesC-XXXX
4
Customer NameTextManual InputSales
5
PhonePhoneManual InputSales
6
Email AddressE-mailManual InputSales
7
Post CodeNumericManual InputSales3+2
8
Shipping AddressTextManual InputSales
9
Past Order IDAuto-GenerateRetrieve from Purchase OrderSales
10
Past Order AmountMoneyRetrieve from Purchase OrderSales
11
Total Order AmountMoneySummarize "Past Order Amount"Sales
12
13
ProductProduct IDAuto-GenerateAuto-GenerateSales
14
Product NameTextManual InputSales
15
DescriptionTextManual InputSales
16
ImageImage UploadManual InputSales
17
CostMoneyManual InputSales
18
PriceMoneyManual InputSales$##,###
19
20
Purchase OrderCustomer IDLinked Select from "Customer" sheetSales/Logistics
21
Customer NameLoadedLoaded based on value in "Customer ID" fieldSales/Logistics
22
PhoneLoadedLoaded based on value in "Customer ID" fieldSales/Logistics
23
Email AddressLoadedLoaded based on value in "Customer ID" fieldSales/Logistics
24
Post CodeLoadedLoaded based on value in "Customer ID" fieldSales/Logistics
25
Shipping AddressLoadedLoaded based on value in "Customer ID" fieldSales/Logistics
26
Product NameTextSelect from "Product" sheetSales/Logistics
27
QuantityNumericManual InputSales/Logistics
28
Unit PriceMoneyLoaded based on value in "Product Name" fieldSales/Logistics
29
SubtotalMoneyFormulas CalculationSales/Logistics
30
TotalMoneyFormulas CalculationSales/Logistics
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100