PO Template (RDL) custom invoice setup

Overview

Summary

This guide will show the process of downloading and editing a base template RDL file for Purchase Orders Invoice customization.

Prerequisites

Microsoft SQL Server 2008 Reporting Services Report Builder 2.0

Template File :

Instructions:

Step 1

Download and install the Microsoft SQL Server 2008 Reporting Services Report Builder 2.0 from the link
Download the MICROSOFT® REPORT VIEWER 2015 RUNTIME from the link
Sometimes Report Builder wants SQLSysClrTypes.msi dependencies depending on the system
Download the Microsoft Report Viewer 2010 Redistributable if required

Step 2

Download the following RDL Template file in order to use the MS Report Builder for customization

Step 3

Double click the RDL file which should result in the MS Builder loading and loading the Report

Step 4

The default template has most of the required fields already included on the report
If the fields are not required you can simply select the textbox and the parameter and delete them
Similar if they are not in the report layout you desire you can move and drag the textbox and or parameter to your desired location

Step 5

If you require any additional parameters that are not included, these parameters can be selected from the Report Data -> Parameters

Step 6

To add an image you can select the image place holder, right click and then import a new Company logo.

Step 7

You can also alter any textbox for any static text like

Delivery Times
ABN
Terms and Connections
Accounts Payable

Step 8

Once you have your RDL Template in the desired Layout, click Save
Then Copy the *.RDL file to the Bepoz\Data directory
Open Backoffice and navigate to Venue Store and Tills
Edit the Venue Settings -> Flags Tab
Set the PO Template to the Company Invoice Format
This can then be tested by created a dummy PO with a few product lines and pressing the "Print Purchase Order" option.

List of all available parameters

All Report DataTable Columns N.B. All String Values		All Report Parameter Fields N.B. All String Values

0	AccountNumber	0	PONumber
1	StoreId	1	OrderDate
2	StoreName	2	DeliveryDate
3	ExportCode1	3	SupplierName
4	ExportCode2	4	SupplierAddress1
5	Units	5	SupplierAddress2,
6	TotalUnits	6	SupplierPhone
7	UnitsName	7	SupplierFax
8	Cases	8	SupplierEmail
9	CasesName	9	VenueNameABN
10	CaseQty	10	VenuePhone
11	Qty	11	VenueFax
12	QtyName	12	VenueEmail
13	ProductID	13	MailingAddress1
14	ProdNumber	14	MailingAddress2
15	SupplierCode	15	DeliveryAddress1
16	ProductName	16	DeliveryAddress2
17	ProductLongName	17	POHeader_iPOHeaderID
18	UnitPriceEx	18	POHeader_dtDateUpdated
19	QtyPriceEx	19	POHeader_iVenueID
20	AmountEx	20	POHeader_iSupplierID
21	ProductTaxRate	21	POHeader_iOperatorID
22	UnitPriceInc	22	POHeader_iOpAuthID
23	QtyPriceInc	23	POHeader_iOpRecvID
24	AmountInc	24	POHeader_sSupplierRepName
25	POLine_iPOHeaderID	25	POHeader_sSupplierPromotion
26	POLine_dtDateUpdated	26	POHeader_sOurOrderNum
27	POLine_iLineID	27	POHeader_sOurAccountNum
28	POLine_dtFirstReceiveDate	28	POHeader_iDelCommentID
29	POLine_dtLastReceiveDate	29	POHeader_dtPurchaseDate
30	POLine_bPOLineStatus	30	POHeader_dtDeliveryDate
31	POLine_bPOExportStatus	31	POHeader_sSuppInvoiceNum
32	POLine_iSupplierID	32	POHeader_saSuppRefNum_0
33	POLine_iProductID	33	POHeader_saSuppRefNum_1
34	POLine_iSupplierItemID	34	POHeader_iINVCommentID
35	POLine_iStoreID	35	POHeader_dsInvoiceDueDate
36	POLine_iOtherStoreID	36	POHeader_iPOHeaderFlag
37	POLine_iStockVarID	37	POHeader_dtFirstReceiveDate
38	POLine_sSupplierNumber	38	POHeader_dtLastReceiveDate
39	POLine_sDescription	39	POHeader_bPOStatus
40	POLine_sUnitName	40	POHeader_bPOExportStatus
41	POLine_sCasename	41	POHeader_bPOLinkPOMode
42	POLine_bStockType	42	POHeader_iItemCount
43	POLine_iStockTypeQty	43	POHeader_dbInvoiceTotalInc
44	POLine_iCaseQty	44	POHeader_dbInvoiceTotalEx
45	POLine_isCostTaxType	45	POHeader_dbaInvoiceTax_0
46	POLine_dbOrderedUnits	46	POHeader_dbaInvoiceTax_1
47	POLine_dbOrderedCases	47	POHeader_dbaInvoiceTax_2
48	POLine_dbOrderedEachEx	48	POHeader_dbaInvoiceTax_3
49	POLine_dbReceivedUnits	49	POHeader_dbaInvoiceTax_4
50	POLine_dbReceivedCases	50	POHeader_dbaInvoiceTax_5
51	POLine_dbRecvPendEachEx	51	POHeader_dbaInvoiceTax_6
52	POLine_dbReceivedEachEx	52	POHeader_dbaInvoiceTax_7
53	POLine_dbReceivedTotalEx	53	POHeader_dbaInvoiceTax_8
54	POLine_dbReceivedTotalInc	54	POHeader_dbaInvoiceCostTax_0
55	POLine_dbReceivedFreight	55	POHeader_dbaInvoiceCostTax_1
56	POLine_dbReceivedDiscount	56	POHeader_dbaInvoiceCostTax_2
57	POLine_dbCancelledQty	57	POHeader_dbaInvoiceCostTax_3
58	POLine_saBarcode_0	58	POHeader_dbaInvoiceCostTax_4
59	POLine_saBarcode_1	59	POHeader_dbInvoiceRounding
60	POLine_saBarcode_2	60	POHeader_dbInvoiceFreight
61	POLine_saBarcode_3	61	POHeader_dbInvoiceFinance
62	POLine_iPackCommentID	62	POHeader_dbInvoiceDiscount
63	POLine_iPOLineFlag	63	POHeader_dbSettlementDisc
64	ReqLine_iReqLineID	64	POHeader_dbExtraItemsCharge
65	ReqLine_iReqHeaderID	65	POHeader_dbLineItemTotalEx
66	ReqLine_dtDateUpdated	66	POHeader_dbLineItemTotalInc
67	ReqLine_iLineID	67	POHeader_dtStockApplyDate
68	ReqLine_dtFirstReceiveDate	68	POHeader_blStockToBeApplied
69	ReqLine_dtLastReceiveDate	69	POHeader_iFinanceTaxed
70	ReqLine_bPOLineStatus	70	POHeader_iSupplierRating
71	ReqLine_bPOExportStatus	71	POHeader_blIsTemplate
72	ReqLine_iSupplierID	72	Supplier_iSupplierID
73	ReqLine_iProductID	73	Supplier_dtDateUpdated
74	ReqLine_iSupplierItemID	74	Supplier_iParentID
75	ReqLine_iStoreID	75	Supplier_sName
76	ReqLine_iOtherStoreID	76	Supplier_sSupplierNum
77	ReqLine_iStockVarID	77	Supplier_iIsParent
78	ReqLine_sSupplierNumber	78	Supplier_sDocLink
79	ReqLine_sDescription	79	Supplier_saExportCode_0
80	ReqLine_sUnitName	80	Supplier_saExportCode_1
81	ReqLine_sCasename	81	Supplier_saExportCode_2
82	ReqLine_bStockType	82	Supplier_blInactive
83	ReqLine_iStockTypeQty	83	Supplier_blUseParentSettings
84	ReqLine_iCaseQty	84	Supplier_iAddressID
85	ReqLine_isCostTaxType	85	Supplier_iCommentID
86	ReqLine_dbOrderedUnits	86	Supplier_dtDateTimeCreated
87	ReqLine_dbOrderedCases	87	Supplier_dtDateTimeLastPurchase
88	ReqLine_dbOrderedEachEx	88	Supplier_iTaxType
89	ReqLine_dbReceivedUnits	89	Supplier_iDeliveryCommentID
90	ReqLine_dbReceivedCases	90	Supplier_bInvDueDays
91	ReqLine_dbRecvPendEachEx	91	Supplier_blPOReqSuppNum
92	ReqLine_dbReceivedEachEx	92	Supplier_blBarcodeOKasNum
93	ReqLine_dbReceivedTotalEx	93	Supplier_blPromptExistingPO
94	ReqLine_dbReceivedTotalInc	94	Supplier_iCostPercentAudit
95	ReqLine_dbReceivedFreight	95	Supplier_sDefAccountNum
96	ReqLine_dbReceivedDiscount	96	Supplier_iaSupplierFlag_0
97	ReqLine_dbCancelledQty	97	Supplier_iaSupplierFlag_1
98	ReqLine_saBarcode_0	98	Supplier_balCustomFlag_0
99	ReqLine_saBarcode_1	99	Supplier_balCustomFlag_1
100	ReqLine_saBarcode_2	100	Supplier_balCustomFlag_2
101	ReqLine_saBarcode_3	101	Supplier_balCustomFlag_3
102	ReqLine_iPackCommentID	102	Supplier_balCustomFlag_4
103	ReqLine_iPOHeaderID	103	Supplier_balCustomFlag_5
104	ReqLine_iPOLineID	104	Supplier_balCustomFlag_6
105	ReqLine_dbPurchasingUnits	105	Supplier_balCustomFlag_7
106	ReqLine_dbPurchasingCases	106	Supplier_balCustomFlag_8
107	ReqLine_dbXferredUnits	107	Supplier_balCustomFlag_9
108	ReqLine_dbXferredCases	108	Supplier_balCustomFlag_10
109	ReqLine_dbManufacturingUnits	109	Supplier_iaCustomNum_0
110	ReqLine_dbManufacturingCases	110	Supplier_iaCustomNum_1
111	Store_iStoreID	111	Supplier_iaCustomNum_2
112	Store_dtDateUpdated	112	Supplier_iaCustomNum_3
113	Store_iStoreGroup	113	Supplier_iaCustomNum_4
114	Store_sName	114	Supplier_iaCustomNum_5
115	Store_iVenueID	115	Supplier_dtaCustomDate_0
116	Store_iOtherID	116	Supplier_dtaCustomDate_1
117	Store_iXferHoldStoreID	117	Supplier_dtaCustomDate_2
118	Store_saExportCode_0	118	Supplier_dtaCustomDate_3
119	Store_saExportCode_1	119	Supplier_dtaCustomDate_4
120	Store_saExportCode_2	120	Supplier_dtaCustomDate_5
121	Store_blProductsOK	121	Supplier_saCustomText_0
122	Store_iPrerequisiteID	122	Supplier_saCustomText_1
123	Store_iaFlags0	123	Supplier_saCustomText_2
124	Store_iaFlags1	124	Supplier_saCustomText_3
125	Store_iRedeemPercent	125	Supplier_saCustomText_4
126	Store_iRestockedFrom	126	Supplier_saCustomText_5
127	Store_iaAltStoreType0	127	Supplier_saCustomText_6
128	Store_iaAltStoreType1	128	Supplier_saCustomText_7
129	Store_iaAltStoreType2	129	Supplier_saCustomText_8
130	Store_iaAltStoreType3	130	Supplier_saCustomText_9
131	Store_iaReqStoreType0	131	Supplier_saCustomText_10
132	Store_iaReqStoreType1	132	Supplier_saCustomText_11
133	Store_iaReqStoreType2	133	Supplier_saCustomText_12
134	Store_iaReqStoreType3	134	Supplier_saCustomText_13
135	Store_iaReqStoreType4	135	Supplier_saCustomText_14
136	Store_iaReqStoreType5	136	Supplier_saCustomText_15
137	Store_iaReqStoreType6	137	Supplier_saCustomText_16
138	Store_iaReqStoreType7	138	Supplier_saCustomText_17
139	Store_baBasePricePrice_0	139	Supplier_saCustomText_18
140	Store_baBasePricePrice_1	140	Supplier_saCustomText_19
141	Store_baBasePricePrice_2	141	Supplier_saCustomText_20
142	Store_baBasePricePrice_3	142	SupplierAddress_iAddressID
143	Store_baBasePricePrice_4	143	SupplierAddress_dtDateUpdated
144	Store_baBasePricePrice_5	144	SupplierAddress_saOtherName_0
145	Store_baBasePricePrice_6	145	SupplierAddress_saOtherName_1
146	Store_baBasePricePrice_7	146	SupplierAddress_saOtherName_2
147	Store_baBasePricePrice_8	147	SupplierAddress_saStreet_0
148	Store_iaBaseStorePrice_0	148	SupplierAddress_saStreet_1
149	Store_iaBaseStorePrice_1	149	SupplierAddress_saStreet_2
150	Store_iaBaseStorePrice_2	150	SupplierAddress_saStreet_3
151	Store_iaBaseStorePrice_3	151	SupplierAddress_sCity
152	Store_iaBaseStorePrice_4	152	SupplierAddress_sState
153	Store_iaBaseStorePrice_5	153	SupplierAddress_sCountry
154	Store_iaBaseStorePrice_6	154	SupplierAddress_sPCode
155	Store_iaBaseStorePrice_7	155	SupplierAddress_sPhoneHome
156	Store_iaBaseStorePrice_8	156	SupplierAddress_sPhoneWork
157	Store_sTillScrollMsg	157	SupplierAddress_sFax
158	Store_sTillLogonMsg	158	SupplierAddress_sMobile
159	Store_sTillLogoffMsg	159	SupplierAddress_sEmail1st
160	Store_blUseSortforMargin	160	SupplierAddress_sEmail2nd
161	Store_iaDefMarginType0	161	SupplierAddress_sFaceBook
162	Store_iaDefMarginType1	162	SupplierAddress_saPostalStreet_0
163	Store_iaDefMarginType2	163	SupplierAddress_saPostalStreet_1
164	Store_iaDefMarginType3	164	SupplierAddress_saPostalStreet_2
165	Store_iaDefMarginType4	165	SupplierAddress_saPostalStreet_3
166	Store_iaDefMarginType5	166	SupplierAddress_sPostalCity
167	Store_iaDefMarginType6	167	SupplierAddress_sPostalState
168	Store_iaDefMarginType7	168	SupplierAddress_sPostalCountry
169	Store_iaDefMarginType8	169	SupplierAddress_sPostalPCode
170	Store_iaDefMarginType9	170	SupplierAddress_sSpare
171	Store_iaDefMarginType10	171	VenueAddress_iAddressID
172	Store_iaDefMarginType11	172	VenueAddress_dtDateUpdated
173	Store_iaDefMarginType12	173	VenueAddress_saOtherName_0
174	Store_iaDefMarginType13	174	VenueAddress_saOtherName_1
175	Store_iaDefMarginType14	175	VenueAddress_saOtherName_2
176	Store_iaDefMarginType15	176	VenueAddress_saStreet_0
177	Store_iaDefMarginType16	177	VenueAddress_saStreet_1
178	Store_iaDefMarginType17	178	VenueAddress_saStreet_2
179	Store_iaDefMarginType18	179	VenueAddress_saStreet_3
180	Store_iaDefMarginType19	180	VenueAddress_sCity
181	Store_iaDefMarginType20	181	VenueAddress_sState
182	Store_iaDefMarginType21	182	VenueAddress_sCountry
183	Store_iaDefMarginType22	183	VenueAddress_sPCode
184	Store_iaDefMarginType23	184	VenueAddress_sPhoneHome
185	Store_iaDefMarginType24	185	VenueAddress_sPhoneWork
186	Store_iaDefMarginType25	186	VenueAddress_sFax
187	Store_iaDefMarginType26	187	VenueAddress_sMobile
188	Store_iaDefMarginType27	188	VenueAddress_sEmail1st
189	Store_iaDefMarginType28	189	VenueAddress_sEmail2nd
190	Store_iaDefMarginType29	190	VenueAddress_sFaceBook
191	Store_iTableGroupOffset	191	VenueAddress_saPostalStreet_0
192	Store_iTableGroupsUsed	192	VenueAddress_saPostalStreet_1
193	Store_balCustomFlag_0	193	VenueAddress_saPostalStreet_2
194	Store_balCustomFlag_1	194	VenueAddress_saPostalStreet_3
195	Store_balCustomFlag_2	195	VenueAddress_sPostalCity
196	Store_balCustomFlag_3	196	VenueAddress_sPostalState
197	Store_balCustomFlag_4	197	VenueAddress_sPostalCountry
198	Store_balCustomFlag_5	198	VenueAddress_sPostalPCode
199	Store_balCustomFlag_6	199	VenueAddress_sSpare
200	Store_balCustomFlag_7	200	RequestedBy_iOperatorID
201	Store_balCustomFlag_8	201	RequestedBy_dtDateUpdated
202	Store_balCustomFlag_9	202	RequestedBy_iParentID
203	Store_balCustomFlag_10	203	RequestedBy_sFirstName
204	Store_iaCustomNum_0	204	RequestedBy_sLastName
205	Store_iaCustomNum_1	205	RequestedBy_iAddressID
206	Store_iaCustomNum_2	206	RequestedBy_iIsParent
207	Store_iaCustomNum_3	207	RequestedBy_sDocLink
208	Store_iaCustomNum_4	208	RequestedBy_sOpNumber
209	Store_iaCustomNum_5	209	RequestedBy_sCardNumber
210	Store_dtaCustomDate_0	210	RequestedBy_sPassword
211	Store_dtaCustomDate_1	211	RequestedBy_saLastPassword0
212	Store_dtaCustomDate_2	212	RequestedBy_saLastPassword1
213	Store_dtaCustomDate_3	213	RequestedBy_saLastPassword2
214	Store_dtaCustomDate_4	214	RequestedBy_saLastPassword3
215	Store_dtaCustomDate_5	215	RequestedBy_dtPasswordChanged
216	Store_saCustomText_0	216	RequestedBy_bPasswordConsErr
217	Store_saCustomText_1	217	RequestedBy_dtLockout
218	Store_saCustomText_2	218	RequestedBy_saExportCode_0
219	Store_saCustomText_3	219	RequestedBy_saExportCode_1
220	Store_saCustomText_4	220	RequestedBy_saExportCode_2
221	Store_saCustomText_5	221	RequestedBy_iCommentId
222	Store_saCustomText_6	222	RequestedBy_dtDateTimeCreated
223	Store_saCustomText_7	223	RequestedBy_dtDateTimeLastSale
224	Store_saCustomText_8	224	RequestedBy_iLastShiftLogon
225	Store_saCustomText_9	225	RequestedBy_sPictureFile
226	Store_saCustomText_10	226	RequestedBy_iImageID
227	Store_isXferPriceSource	227	RequestedBy_sPagerNo
228	Product_iProductID	228	RequestedBy_bCashdrawNumber
229	Product_dtDateUpdated	229	RequestedBy_iCashdrawShiftId
230	Product_iParentId	230	RequestedBy_iCashdrawTillId
231	Product_sName	231	RequestedBy_iCashdrawClockID
232	Product_sLongName	232	RequestedBy_blDoNotEmail
233	Product_sName2nd	233	RequestedBy_blDoNotSMS
234	Product_sProdNumber	234	RequestedBy_blInactive
235	Product_dtDateTimeCreated	235	RequestedBy_dtDateTimeInactive
236	Product_sPictureFile	236	RequestedBy_blUseParentSettings
237	Product_iImageID	237	RequestedBy_isAllowedVenueID
238	Product_iCommentId	238	RequestedBy_bDefaultTreeStyle_
239	Product_iRecipeId	239	RequestedBy_iViewProductID
240	Product_isCondimentCount	240	RequestedBy_iEditProductID
241	Product_iIsParent	241	RequestedBy_iEditPriceProductID
242	Product_sDocLink	242	RequestedBy_iViewNegStoreID
243	Product_sScreenMedia	243	RequestedBy_iAllowTillNegStoreID
244	Product_saExportCode_0	244	RequestedBy_blOperateTill
245	Product_saExportCode_1	245	RequestedBy_blManagerFunc
246	Product_saExportCode_2	246	RequestedBy_blManagerOverride
247	Product_saExportCode_3	247	RequestedBy_blExitTill
248	Product_saExportCode_4	248	RequestedBy_blCancelOrder
249	Product_blInactive	249	RequestedBy_blMinusItems
250	Product_dtDateTimeInactive	250	RequestedBy_blCreditSales
251	Product_blUseParentSettings	251	RequestedBy_blNoSale
252	Product_blScaleProduct	252	RequestedBy_blForceTender
253	Product_blNoRecieptPrint	253	RequestedBy_blAddScanAllowed
254	Product_blProductHidden	254	RequestedBy_blTableCreate
255	Product_blNonStocked	255	RequestedBy_blTableSales
256	Product_blFlowMetered	256	RequestedBy_blTableNoMinusItems
257	Product_blNoOverSell	257	RequestedBy_blTablePayments
258	Product_blManufactured	258	RequestedBy_blTableClose
259	Product_blPartialQty	259	RequestedBy_blAccountCreate
260	Product_blNoReorder	260	RequestedBy_blAccountSales
261	Product_blFoodStamp	261	RequestedBy_blAccountCharge
262	Product_iaProdFlag_0	262	RequestedBy_blAccountCredit
263	Product_iaProdFlag_1	263	RequestedBy_blAccountNegPay
264	Product_bProdMode	264	RequestedBy_blRedeemPoints
265	Product_bProdType	265	RequestedBy_blRedeemCash
266	Product_bProdSort	266	RequestedBy_blStockFunctions
267	Product_bStoreType	267	RequestedBy_blStockView
268	Product_bReqStoreType	268	RequestedBy_blMultipleHold
269	Product_bDefaultSize	269	RequestedBy_blDiscFixedOk
270	Product_iPrnProfileID	270	RequestedBy_blDiscEntryOk
271	Product_iPrerequisiteID	271	RequestedBy_blGamingCash
272	Product_isMaxSalesQty	272	RequestedBy_blCardAuthorisations
273	Product_isCostTaxType	273	RequestedBy_blTableClearItem
274	Product_bStockType	274	RequestedBy_blTableMapMaintenance
275	Product_iStockTypeQty	275	RequestedBy_blDataRulesMaintenance
276	Product_sUnitName	276	RequestedBy_blTableWaiter
277	Product_iCaseQty	277	RequestedBy_blTableOnlyMine
278	Product_sCaseName	278	RequestedBy_blSendOpListMsg
279	Product_saSizeName_0	279	RequestedBy_blSendSmsMsg
280	Product_saSizeName_1	280	RequestedBy_blSendEmailMsg
281	Product_saSizeName_2	281	RequestedBy_blBackOfficeUse
282	Product_saSizeName_3	282	RequestedBy_blProductAdd
283	Product_saSizeName_4	283	RequestedBy_blProductEdit
284	Product_saSizeName_5	284	RequestedBy_blProductView
285	Product_saSizeName_6	285	RequestedBy_blSizesEdit
286	Product_saSizeName_7	286	RequestedBy_blPricesEdit
287	Product_saSizeName_8	287	RequestedBy_blProdStoreAddDelete
288	Product_saSizeName_9	288	RequestedBy_blProdStoreEdit
289	Product_saSizeName_10	289	RequestedBy_blOperatorsCreate
290	Product_saSizeNameSec_0	290	RequestedBy_blOperatorsModify
291	Product_saSizeNameSec_1	291	RequestedBy_blOperatorsView
292	Product_saSizeNameSec_2	292	RequestedBy_blAccountsModify
293	Product_saSizeNameSec_3	293	RequestedBy_blAccountsView
294	Product_saSizeNameSec_4	294	RequestedBy_blReportCash
295	Product_saSizeNameSec_5	295	RequestedBy_blReportStock
296	Product_saSizeNameSec_6	296	RequestedBy_blReportProducts
297	Product_saSizeNameSec_7	297	RequestedBy_blReportAccounts
298	Product_saSizeNameSec_8	298	RequestedBy_blUseSetup
299	Product_saSizeNameSec_9	299	RequestedBy_blUseSystemSetup
300	Product_saSizeNameSec_10	300	RequestedBy_blViewCosts
301	Product_iaSizeQty_0	301	RequestedBy_blGlobalRepUse
302	Product_iaSizeQty_1	302	RequestedBy_blGlobalRepSave
303	Product_iaSizeQty_2	303	RequestedBy_blStockAdjust
304	Product_iaSizeQty_3	304	RequestedBy_blStockXfer
305	Product_iaSizeQty_4	305	RequestedBy_blStockXferPost
306	Product_iaSizeQty_5	306	RequestedBy_blStockXferRecv
307	Product_iaSizeQty_6	307	RequestedBy_blStockXferHO
308	Product_iaSizeQty_7	308	RequestedBy_blStockXferVenues
309	Product_iaSizeQty_8	309	RequestedBy_blStockCreatePO
310	Product_iaSizeQty_9	310	RequestedBy_blStockPostPO
311	Product_iaSizeQty_10	311	RequestedBy_blStockRecvPO
312	Product_baSizeStockType_0	312	RequestedBy_blStockRecvPend
313	Product_baSizeStockType_1	313	RequestedBy_blStockRecvManual
314	Product_baSizeStockType_2	314	RequestedBy_blStockViewVenues
315	Product_baSizeStockType_3	315	RequestedBy_blViewsCreate
316	Product_baSizeStockType_4	316	RequestedBy_blViewsEdit
317	Product_baSizeStockType_5	317	RequestedBy_blViewsDelete
318	Product_baSizeStockType_6	318	RequestedBy_blViewsFormulas
319	Product_baSizeStockType_7	319	RequestedBy_blViewsShowAll
320	Product_baSizeStockType_8	320	RequestedBy_blViewsAlterMineOnly
321	Product_baSizeStockType_9	321	RequestedBy_bViewsDefaultOwner
322	Product_baSizeStockType_10	322	RequestedBy_blMemberJoin
323	Product_balSizeNonDisc_0	323	RequestedBy_blMemberRenew
324	Product_balSizeNonDisc_1	324	RequestedBy_blMemberAdmin
325	Product_balSizeNonDisc_2	325	RequestedBy_blMemberShipOnly
326	Product_balSizeNonDisc_3	326	RequestedBy_iRaffleOpPrivilege
327	Product_balSizeNonDisc_4	327	RequestedBy_iPOOrderLimit
328	Product_balSizeNonDisc_5	328	RequestedBy_iPORecvVarPercent
329	Product_balSizeNonDisc_6	329	RequestedBy_iPOLineRecvVarPercent
330	Product_balSizeNonDisc_7	330	RequestedBy_iPOAuthFlag
331	Product_balSizeNonDisc_8	331	RequestedBy_iaOpFlag_0
332	Product_balSizeNonDisc_9	332	RequestedBy_iaOpFlag_1
333	Product_balSizeNonDisc_10	333	RequestedBy_iaOpFlag_2
334	Product_balCustomFlag_0	334	RequestedBy_iaOpFlag_3
335	Product_balCustomFlag_1	335	RequestedBy_iaOpFlag_4
336	Product_balCustomFlag_2	336	RequestedBy_iOpPrivFlags
337	Product_balCustomFlag_3	337	RequestedBy_balCustomFlag_0
338	Product_balCustomFlag_4	338	RequestedBy_balCustomFlag_1
339	Product_balCustomFlag_5	339	RequestedBy_balCustomFlag_2
340	Product_balCustomFlag_6	340	RequestedBy_balCustomFlag_3
341	Product_balCustomFlag_7	341	RequestedBy_balCustomFlag_4
342	Product_balCustomFlag_8	342	RequestedBy_balCustomFlag_5
343	Product_balCustomFlag_9	343	RequestedBy_balCustomFlag_6
344	Product_balCustomFlag_10	344	RequestedBy_balCustomFlag_7
345	Product_iaCustomNum_0	345	RequestedBy_balCustomFlag_8
346	Product_iaCustomNum_1	346	RequestedBy_balCustomFlag_9
347	Product_iaCustomNum_2	347	RequestedBy_balCustomFlag_10
348	Product_iaCustomNum_3	348	RequestedBy_iaCustomNum_0
349	Product_iaCustomNum_4	349	RequestedBy_iaCustomNum_1
350	Product_iaCustomNum_5	350	RequestedBy_iaCustomNum_2
351	Product_dtaCustomDate_0	351	RequestedBy_iaCustomNum_3
352	Product_dtaCustomDate_1	352	RequestedBy_iaCustomNum_4
353	Product_dtaCustomDate_2	353	RequestedBy_iaCustomNum_5
354	Product_dtaCustomDate_3	354	RequestedBy_dtaCustomDate_0
355	Product_dtaCustomDate_4	355	RequestedBy_dtaCustomDate_1
356	Product_dtaCustomDate_5	356	RequestedBy_dtaCustomDate_2
357	Product_saCustomText_0	357	RequestedBy_dtaCustomDate_3
358	Product_saCustomText_1	358	RequestedBy_dtaCustomDate_4
359	Product_saCustomText_2	359	RequestedBy_dtaCustomDate_5
360	Product_saCustomText_3	360	RequestedBy_saCustomText_0
361	Product_saCustomText_4	361	RequestedBy_saCustomText_1
362	Product_saCustomText_5	362	RequestedBy_saCustomText_2
363	Product_saCustomText_6	363	RequestedBy_saCustomText_3
364	Product_saCustomText_7	364	RequestedBy_saCustomText_4
365	Product_saCustomText_8	365	RequestedBy_saCustomText_5
366	Product_saCustomText_9	366	RequestedBy_saCustomText_6
367	Product_saCustomText_10	367	RequestedBy_saCustomText_7
368	Product_saCustomText_11	368	RequestedBy_saCustomText_8
369	Product_saCustomText_12	369	RequestedBy_saCustomText_9
370	Product_saCustomText_13	370	RequestedBy_saCustomText_10
371	Product_saCustomText_14	371	RequestedBy_saCustomText_11
372	Product_saCustomText_15	372	RequestedBy_saCustomText_12
373	Product_saCustomText_16	373	RequestedBy_saCustomText_13
374	Product_saCustomText_17	374	RequestedBy_saCustomText_14
375	Product_saCustomText_18	375	RequestedBy_saCustomText_15
376	Product_saCustomText_19	376	RequestedBy_saCustomText_16
377	Product_saCustomText_20	377	RequestedBy_saCustomText_17
378	Product_iUsedLastWeek	378	RequestedBy_saCustomText_18
379	Product_iPrepTime	379	RequestedBy_saCustomText_19
380	Product_iaPrepTime0	380	RequestedBy_saCustomText_20
381	Product_iaPrepTime1	381	RequestedBy_sDashboard
382	Product_iaPrepTime2	382	RequestedBy_dsLastSRShiftRun
383	Product_iaPrepTime3	383	RequestedBy_dsLastSRShiftMsg
384	Product_iaPrepTime4	384	RequestedBy_dsMealBreakAlerted
385	Product_iPlateTime	385	RequestedBy_dsRestBreakAlerted
		386	RequestedBy_dsDayOTAlerted
		387	RequestedBy_dsWeekOTAlerted
		388	RequestedBy_iaUsageFlags0
		389	RequestedBy_iaUsageFlags1
		390	RequestedBy_iAppID
		391	RequestedBy_iMyBepozID
		392	RequestedBy_bGender
		393	RequestedBy_dsDateBirth
		394	RequestedBy_sPhotoUrl
		395	RequestedBy_dtMyBepozLastLoginDate
		396	RequestedBy_iMyBepozLoginQty
		397	RequestedBy_isMyBepozSyncStatus
		398	RequestedBy_dtMyBepozSyncDate
		399	RequestedBy_isMyBepozActivitySyncStatus
		400	RequestedBy_dtMyBepozActivitySyncDate
		401	AuthorisedBy_iOperatorID
		402	AuthorisedBy_dtDateUpdated
		403	AuthorisedBy_iParentID
		404	AuthorisedBy_sFirstName
		405	AuthorisedBy_sLastName
		406	AuthorisedBy_iAddressID
		407	AuthorisedBy_iIsParent
		408	AuthorisedBy_sDocLink
		409	AuthorisedBy_sOpNumber
		410	AuthorisedBy_sCardNumber
		411	AuthorisedBy_sPassword
		412	AuthorisedBy_saLastPassword0
		413	AuthorisedBy_saLastPassword1
		414	AuthorisedBy_saLastPassword2
		415	AuthorisedBy_saLastPassword3
		416	AuthorisedBy_dtPasswordChanged
		417	AuthorisedBy_bPasswordConsErr
		418	AuthorisedBy_dtLockout
		419	AuthorisedBy_saExportCode_0
		420	AuthorisedBy_saExportCode_1
		421	AuthorisedBy_saExportCode_2
		422	AuthorisedBy_iCommentId
		423	AuthorisedBy_dtDateTimeCreated
		424	AuthorisedBy_dtDateTimeLastSale
		425	AuthorisedBy_iLastShiftLogon
		426	AuthorisedBy_sPictureFile
		427	AuthorisedBy_iImageID
		428	AuthorisedBy_sPagerNo
		429	AuthorisedBy_bCashdrawNumber
		430	AuthorisedBy_iCashdrawShiftId
		431	AuthorisedBy_iCashdrawTillId
		432	AuthorisedBy_iCashdrawClockID
		433	AuthorisedBy_blDoNotEmail
		434	AuthorisedBy_blDoNotSMS
		435	AuthorisedBy_blInactive
		436	AuthorisedBy_dtDateTimeInactive
		437	AuthorisedBy_blUseParentSettings
		438	AuthorisedBy_isAllowedVenueID
		439	AuthorisedBy_bDefaultTreeStyle_
		440	AuthorisedBy_iViewProductID
		441	AuthorisedBy_iEditProductID
		442	AuthorisedBy_iEditPriceProductID
		443	AuthorisedBy_iViewNegStoreID
		444	AuthorisedBy_iAllowTillNegStoreID
		445	AuthorisedBy_blOperateTill
		446	AuthorisedBy_blManagerFunc
		447	AuthorisedBy_blManagerOverride
		448	AuthorisedBy_blExitTill
		449	AuthorisedBy_blCancelOrder
		450	AuthorisedBy_blMinusItems
		451	AuthorisedBy_blCreditSales
		452	AuthorisedBy_blNoSale
		453	AuthorisedBy_blForceTender
		454	AuthorisedBy_blAddScanAllowed
		455	AuthorisedBy_blTableCreate
		456	AuthorisedBy_blTableSales
		457	AuthorisedBy_blTableNoMinusItems
		458	AuthorisedBy_blTablePayments
		459	AuthorisedBy_blTableClose
		460	AuthorisedBy_blAccountCreate
		461	AuthorisedBy_blAccountSales
		462	AuthorisedBy_blAccountCharge
		463	AuthorisedBy_blAccountCredit
		464	AuthorisedBy_blAccountNegPay
		465	AuthorisedBy_blRedeemPoints
		466	AuthorisedBy_blRedeemCash
		467	AuthorisedBy_blStockFunctions
		468	AuthorisedBy_blStockView
		469	AuthorisedBy_blMultipleHold
		470	AuthorisedBy_blDiscFixedOk
		471	AuthorisedBy_blDiscEntryOk
		472	AuthorisedBy_blGamingCash
		473	AuthorisedBy_blCardAuthorisations
		474	AuthorisedBy_blTableClearItem
		475	AuthorisedBy_blTableMapMaintenance
		476	AuthorisedBy_blDataRulesMaintenance
		477	AuthorisedBy_blTableWaiter
		478	AuthorisedBy_blTableOnlyMine
		479	AuthorisedBy_blSendOpListMsg
		480	AuthorisedBy_blSendSmsMsg
		481	AuthorisedBy_blSendEmailMsg
		482	AuthorisedBy_blBackOfficeUse
		483	AuthorisedBy_blProductAdd
		484	AuthorisedBy_blProductEdit
		485	AuthorisedBy_blProductView
		486	AuthorisedBy_blSizesEdit
		487	AuthorisedBy_blPricesEdit
		488	AuthorisedBy_blProdStoreAddDelete
		489	AuthorisedBy_blProdStoreEdit
		490	AuthorisedBy_blOperatorsCreate
		491	AuthorisedBy_blOperatorsModify
		492	AuthorisedBy_blOperatorsView
		493	AuthorisedBy_blAccountsModify
		494	AuthorisedBy_blAccountsView
		495	AuthorisedBy_blReportCash
		496	AuthorisedBy_blReportStock
		497	AuthorisedBy_blReportProducts
		498	AuthorisedBy_blReportAccounts
		499	AuthorisedBy_blUseSetup
		500	AuthorisedBy_blUseSystemSetup
		501	AuthorisedBy_blViewCosts
		502	AuthorisedBy_blGlobalRepUse
		503	AuthorisedBy_blGlobalRepSave
		504	AuthorisedBy_blStockAdjust
		505	AuthorisedBy_blStockXfer
		506	AuthorisedBy_blStockXferPost
		507	AuthorisedBy_blStockXferRecv
		508	AuthorisedBy_blStockXferHO
		509	AuthorisedBy_blStockXferVenues
		510	AuthorisedBy_blStockCreatePO
		511	AuthorisedBy_blStockPostPO
		512	AuthorisedBy_blStockRecvPO
		513	AuthorisedBy_blStockRecvPend
		514	AuthorisedBy_blStockRecvManual
		515	AuthorisedBy_blStockViewVenues
		516	AuthorisedBy_blViewsCreate
		517	AuthorisedBy_blViewsEdit
		518	AuthorisedBy_blViewsDelete
		519	AuthorisedBy_blViewsFormulas
		520	AuthorisedBy_blViewsShowAll
		521	AuthorisedBy_blViewsAlterMineOnly
		522	AuthorisedBy_bViewsDefaultOwner
		523	AuthorisedBy_blMemberJoin
		524	AuthorisedBy_blMemberRenew
		525	AuthorisedBy_blMemberAdmin
		526	AuthorisedBy_blMemberShipOnly
		527	AuthorisedBy_iRaffleOpPrivilege
		528	AuthorisedBy_iPOOrderLimit
		529	AuthorisedBy_iPORecvVarPercent
		530	AuthorisedBy_iPOLineRecvVarPercent
		531	AuthorisedBy_iPOAuthFlag
		532	AuthorisedBy_iaOpFlag_0
		533	AuthorisedBy_iaOpFlag_1
		534	AuthorisedBy_iaOpFlag_2
		535	AuthorisedBy_iaOpFlag_3
		536	AuthorisedBy_iaOpFlag_4
		537	AuthorisedBy_iOpPrivFlags
		538	AuthorisedBy_balCustomFlag_0
		539	AuthorisedBy_balCustomFlag_1
		540	AuthorisedBy_balCustomFlag_2
		541	AuthorisedBy_balCustomFlag_3
		542	AuthorisedBy_balCustomFlag_4
		543	AuthorisedBy_balCustomFlag_5
		544	AuthorisedBy_balCustomFlag_6
		545	AuthorisedBy_balCustomFlag_7
		546	AuthorisedBy_balCustomFlag_8
		547	AuthorisedBy_balCustomFlag_9
		548	AuthorisedBy_balCustomFlag_10
		549	AuthorisedBy_iaCustomNum_0
		550	AuthorisedBy_iaCustomNum_1
		551	AuthorisedBy_iaCustomNum_2
		552	AuthorisedBy_iaCustomNum_3
		553	AuthorisedBy_iaCustomNum_4
		554	AuthorisedBy_iaCustomNum_5
		555	AuthorisedBy_dtaCustomDate_0
		556	AuthorisedBy_dtaCustomDate_1
		557	AuthorisedBy_dtaCustomDate_2
		558	AuthorisedBy_dtaCustomDate_3
		559	AuthorisedBy_dtaCustomDate_4
		560	AuthorisedBy_dtaCustomDate_5
		561	AuthorisedBy_saCustomText_0
		562	AuthorisedBy_saCustomText_1
		563	AuthorisedBy_saCustomText_2
		564	AuthorisedBy_saCustomText_3
		565	AuthorisedBy_saCustomText_4
		566	AuthorisedBy_saCustomText_5
		567	AuthorisedBy_saCustomText_6
		568	AuthorisedBy_saCustomText_7
		569	AuthorisedBy_saCustomText_8
		570	AuthorisedBy_saCustomText_9
		571	AuthorisedBy_saCustomText_10
		572	AuthorisedBy_saCustomText_11
		573	AuthorisedBy_saCustomText_12
		574	AuthorisedBy_saCustomText_13
		575	AuthorisedBy_saCustomText_14
		576	AuthorisedBy_saCustomText_15
		577	AuthorisedBy_saCustomText_16
		578	AuthorisedBy_saCustomText_17
		579	AuthorisedBy_saCustomText_18
		580	AuthorisedBy_saCustomText_19
		581	AuthorisedBy_saCustomText_20
		582	AuthorisedBy_sDashboard
		583	AuthorisedBy_dsLastSRShiftRun
		584	AuthorisedBy_dsLastSRShiftMsg
		585	AuthorisedBy_dsMealBreakAlerted
		586	AuthorisedBy_dsRestBreakAlerted
		587	AuthorisedBy_dsDayOTAlerted
		588	AuthorisedBy_dsWeekOTAlerted
		589	AuthorisedBy_iaUsageFlags0
		590	AuthorisedBy_iaUsageFlags1
		591	AuthorisedBy_iAppID
		592	AuthorisedBy_iMyBepozID
		593	AuthorisedBy_bGender
		594	AuthorisedBy_dsDateBirth
		595	AuthorisedBy_sPhotoUrl
		596	AuthorisedBy_dtMyBepozLastLoginDate
		597	AuthorisedBy_iMyBepozLoginQty
		598	AuthorisedBy_isMyBepozSyncStatus
		599	AuthorisedBy_dtMyBepozSyncDate
		600	AuthorisedBy_isMyBepozActivitySyncStatus
		601	AuthorisedBy_dtMyBepozActivitySyncDate
		602	InvoiceComment_iCommentID
		603	InvoiceComment_dtDateUpdated
		604	InvoiceComment_sComment
		605	DeliveryComment_iCommentID
		606	DeliveryComment_dtDateUpdated
		607	DeliveryComment_sComment
		608	SupplierComment_iCommentID
		609	SupplierComment_dtDateUpdated
		610	SupplierComment_sComment
		611	TotalEx
		612	TotalTax
		613	TotalInc
		614	Requested
		615	Authorised

General	PoHeader	POLine	ReqLine	Store	Product	Supplier	Address	RequestedBy	AuthrisedBy	Comment
AccountNumber	POHeader_iPOHeaderID	POLine_iPOHeaderID	POLine_iPOHeaderID	Store_iStoreID	Product_iProductID	PONumber	SupplierAddress_iAddressID	RequestedBy_iOperatorID	AuthorisedBy_iOperatorID	InvoiceComment_iCommentID
StoreId	POHeader_dtDateUpdated	POLine_dtDateUpdated	POLine_dtDateUpdated	Store_dtDateUpdated	Product_dtDateUpdated	OrderDate	SupplierAddress_dtDateUpdated	RequestedBy_dtDateUpdated	AuthorisedBy_dtDateUpdated	InvoiceComment_dtDateUpdated
StoreName	POHeader_iVenueID	POLine_iLineID	POLine_iLineID	Store_iStoreGroup	Product_iParentId	DeliveryDate	SupplierAddress_saOtherName_0	RequestedBy_iParentID	AuthorisedBy_iParentID	InvoiceComment_sComment
ExportCode1	POHeader_iSupplierID	POLine_dtFirstReceiveDate	POLine_dtFirstReceiveDate	Store_sName	Product_sName	SupplierName	SupplierAddress_saOtherName_1	RequestedBy_sFirstName	AuthorisedBy_sFirstName	DeliveryComment_iCommentID
ExportCode2	POHeader_iOperatorID	POLine_dtLastReceiveDate	POLine_dtLastReceiveDate	Store_iVenueID	Product_sLongName	SupplierAddress1	SupplierAddress_saOtherName_2	RequestedBy_sLastName	AuthorisedBy_sLastName	DeliveryComment_dtDateUpdated
Units	POHeader_iOpAuthID	POLine_bPOLineStatus	POLine_bPOLineStatus	Store_iOtherID	Product_sName2nd	SupplierAddress2,	SupplierAddress_saStreet_0	RequestedBy_iAddressID	AuthorisedBy_iAddressID	DeliveryComment_sComment
TotalUnits	POHeader_iOpRecvID	POLine_bPOExportStatus	POLine_bPOExportStatus	Store_iXferHoldStoreID	Product_sProdNumber	SupplierPhone	SupplierAddress_saStreet_1	RequestedBy_iIsParent	AuthorisedBy_iIsParent	SupplierComment_iCommentID
UnitsName	POHeader_sSupplierRepName	POLine_iSupplierID	POLine_iSupplierID	Store_saExportCode_0	Product_dtDateTimeCreated	SupplierFax	SupplierAddress_saStreet_2	RequestedBy_sDocLink	AuthorisedBy_sDocLink	SupplierComment_dtDateUpdated
Cases	POHeader_sSupplierPromotion	POLine_iProductID	POLine_iProductID	Store_saExportCode_1	Product_sPictureFile	SupplierEmail	SupplierAddress_saStreet_3	RequestedBy_sOpNumber	AuthorisedBy_sOpNumber	SupplierComment_sComment
CasesName	POHeader_sOurOrderNum	POLine_iSupplierItemID	POLine_iSupplierItemID	Store_saExportCode_2	Product_iImageID	VenueNameABN	SupplierAddress_sCity	RequestedBy_sCardNumber	AuthorisedBy_sCardNumber
CaseQty	POHeader_sOurAccountNum	POLine_iStoreID	POLine_iStoreID	Store_blProductsOK	Product_iCommentId	VenuePhone	SupplierAddress_sState	RequestedBy_sPassword	AuthorisedBy_sPassword
Qty	POHeader_iDelCommentID	POLine_iOtherStoreID	POLine_iOtherStoreID	Store_iPrerequisiteID	Product_iRecipeId	VenueFax	SupplierAddress_sCountry	RequestedBy_saLastPassword0	AuthorisedBy_saLastPassword0
QtyName	POHeader_dtPurchaseDate	POLine_iStockVarID	POLine_iStockVarID	Store_iaFlags0	Product_isCondimentCount	VenueEmail	SupplierAddress_sPCode	RequestedBy_saLastPassword1	AuthorisedBy_saLastPassword1
ProductID	POHeader_dtDeliveryDate	POLine_sSupplierNumber	POLine_sSupplierNumber	Store_iaFlags1	Product_iIsParent	MailingAddress1	SupplierAddress_sPhoneHome	RequestedBy_saLastPassword2	AuthorisedBy_saLastPassword2
ProdNumber	POHeader_sSuppInvoiceNum	POLine_sDescription	POLine_sDescription	Store_iRedeemPercent	Product_sDocLink	MailingAddress2	SupplierAddress_sPhoneWork	RequestedBy_saLastPassword3	AuthorisedBy_saLastPassword3
SupplierCode	POHeader_saSuppRefNum_0	POLine_sUnitName	POLine_sUnitName	Store_iRestockedFrom	Product_sScreenMedia	DeliveryAddress1	SupplierAddress_sFax	RequestedBy_dtPasswordChanged	AuthorisedBy_dtPasswordChanged
ProductName	POHeader_saSuppRefNum_1	POLine_sCasename	POLine_sCasename	Store_iaAltStoreType0	Product_saExportCode_0	DeliveryAddress2	SupplierAddress_sMobile	RequestedBy_bPasswordConsErr	AuthorisedBy_bPasswordConsErr
ProductLongName	POHeader_iINVCommentID	POLine_bStockType	POLine_bStockType	Store_iaAltStoreType1	Product_saExportCode_1	Supplier_iSupplierID	SupplierAddress_sEmail1st	RequestedBy_dtLockout	AuthorisedBy_dtLockout
UnitPriceEx	POHeader_dsInvoiceDueDate	POLine_iStockTypeQty	POLine_iStockTypeQty	Store_iaAltStoreType2	Product_saExportCode_2	Supplier_dtDateUpdated	SupplierAddress_sEmail2nd	RequestedBy_saExportCode_0	AuthorisedBy_saExportCode_0
QtyPriceEx	POHeader_iPOHeaderFlag	POLine_iCaseQty	POLine_iCaseQty	Store_iaAltStoreType3	Product_saExportCode_3	Supplier_iParentID	SupplierAddress_sFaceBook	RequestedBy_saExportCode_1	AuthorisedBy_saExportCode_1
AmountEx	POHeader_dtFirstReceiveDate	POLine_isCostTaxType	POLine_isCostTaxType	Store_iaReqStoreType0	Product_saExportCode_4	Supplier_sName	SupplierAddress_saPostalStreet_0	RequestedBy_saExportCode_2	AuthorisedBy_saExportCode_2
ProductTaxRate	POHeader_dtLastReceiveDate	POLine_dbOrderedUnits	POLine_dbOrderedUnits	Store_iaReqStoreType1	Product_blInactive	Supplier_sSupplierNum	SupplierAddress_saPostalStreet_1	RequestedBy_iCommentId	AuthorisedBy_iCommentId
UnitPriceInc	POHeader_bPOStatus	POLine_dbOrderedCases	POLine_dbOrderedCases	Store_iaReqStoreType2	Product_dtDateTimeInactive	Supplier_iIsParent	SupplierAddress_saPostalStreet_2	RequestedBy_dtDateTimeCreated	AuthorisedBy_dtDateTimeCreated
QtyPriceInc	POHeader_bPOExportStatus	POLine_dbOrderedEachEx	POLine_dbOrderedEachEx	Store_iaReqStoreType3	Product_blUseParentSettings	Supplier_sDocLink	SupplierAddress_saPostalStreet_3	RequestedBy_dtDateTimeLastSale	AuthorisedBy_dtDateTimeLastSale
AmountInc	POHeader_bPOLinkPOMode	POLine_dbReceivedUnits	POLine_dbReceivedUnits	Store_iaReqStoreType4	Product_blScaleProduct	Supplier_saExportCode_0	SupplierAddress_sPostalCity	RequestedBy_iLastShiftLogon	AuthorisedBy_iLastShiftLogon
	POHeader_iItemCount	POLine_dbReceivedCases	POLine_dbReceivedCases	Store_iaReqStoreType5	Product_blNoRecieptPrint	Supplier_saExportCode_1	SupplierAddress_sPostalState	RequestedBy_sPictureFile	AuthorisedBy_sPictureFile
	POHeader_dbInvoiceTotalInc	POLine_dbRecvPendEachEx	POLine_dbRecvPendEachEx	Store_iaReqStoreType6	Product_blProductHidden	Supplier_saExportCode_2	SupplierAddress_sPostalCountry	RequestedBy_iImageID	AuthorisedBy_iImageID
	POHeader_dbInvoiceTotalEx	POLine_dbReceivedEachEx	POLine_dbReceivedEachEx	Store_iaReqStoreType7	Product_blNonStocked	Supplier_blInactive	SupplierAddress_sPostalPCode	RequestedBy_sPagerNo	AuthorisedBy_sPagerNo
	POHeader_dbaInvoiceTax_0	POLine_dbReceivedTotalEx	POLine_dbReceivedTotalEx	Store_baBasePricePrice_0	Product_blFlowMetered	Supplier_blUseParentSettings	SupplierAddress_sSpare	RequestedBy_bCashdrawNumber	AuthorisedBy_bCashdrawNumber
	POHeader_dbaInvoiceTax_1	POLine_dbReceivedTotalInc	POLine_dbReceivedTotalInc	Store_baBasePricePrice_1	Product_blNoOverSell	Supplier_iAddressID	VenueAddress_iAddressID	RequestedBy_iCashdrawShiftId	AuthorisedBy_iCashdrawShiftId
	POHeader_dbaInvoiceTax_2	POLine_dbReceivedFreight	POLine_dbReceivedFreight	Store_baBasePricePrice_2	Product_blManufactured	Supplier_iCommentID	VenueAddress_dtDateUpdated	RequestedBy_iCashdrawTillId	AuthorisedBy_iCashdrawTillId
	POHeader_dbaInvoiceTax_3	POLine_dbReceivedDiscount	POLine_dbReceivedDiscount	Store_baBasePricePrice_3	Product_blPartialQty	Supplier_dtDateTimeCreated	VenueAddress_saOtherName_0	RequestedBy_iCashdrawClockID	AuthorisedBy_iCashdrawClockID
	POHeader_dbaInvoiceTax_4	POLine_dbCancelledQty	POLine_dbCancelledQty	Store_baBasePricePrice_4	Product_blNoReorder	Supplier_dtDateTimeLastPurchase	VenueAddress_saOtherName_1	RequestedBy_blDoNotEmail	AuthorisedBy_blDoNotEmail
	POHeader_dbaInvoiceTax_5	POLine_saBarcode_0	POLine_saBarcode_0	Store_baBasePricePrice_5	Product_blFoodStamp	Supplier_iTaxType	VenueAddress_saOtherName_2	RequestedBy_blDoNotSMS	AuthorisedBy_blDoNotSMS
	POHeader_dbaInvoiceTax_6	POLine_saBarcode_1	POLine_saBarcode_1	Store_baBasePricePrice_6	Product_iaProdFlag_0	Supplier_iDeliveryCommentID	VenueAddress_saStreet_0	RequestedBy_blInactive	AuthorisedBy_blInactive
	POHeader_dbaInvoiceTax_7	POLine_saBarcode_2	POLine_saBarcode_2	Store_baBasePricePrice_7	Product_iaProdFlag_1	Supplier_bInvDueDays	VenueAddress_saStreet_1	RequestedBy_dtDateTimeInactive	AuthorisedBy_dtDateTimeInactive
	POHeader_dbaInvoiceTax_8	POLine_saBarcode_3	POLine_saBarcode_3	Store_baBasePricePrice_8	Product_bProdMode	Supplier_blPOReqSuppNum	VenueAddress_saStreet_2	RequestedBy_blUseParentSettings	AuthorisedBy_blUseParentSettings
	POHeader_dbaInvoiceCostTax_0	POLine_iPackCommentID	POLine_iPackCommentID	Store_iaBaseStorePrice_0	Product_bProdType	Supplier_blBarcodeOKasNum	VenueAddress_saStreet_3	RequestedBy_isAllowedVenueID	AuthorisedBy_isAllowedVenueID
	POHeader_dbaInvoiceCostTax_1	POLine_iPOLineFlag	POLine_iPOLineFlag	Store_iaBaseStorePrice_1	Product_bProdSort	Supplier_blPromptExistingPO	VenueAddress_sCity	RequestedBy_bDefaultTreeStyle_	AuthorisedBy_bDefaultTreeStyle_
	POHeader_dbaInvoiceCostTax_2	ReqLine_iReqLineID	ReqLine_iReqLineID	Store_iaBaseStorePrice_2	Product_bStoreType	Supplier_iCostPercentAudit	VenueAddress_sState	RequestedBy_iViewProductID	AuthorisedBy_iViewProductID
	POHeader_dbaInvoiceCostTax_3	ReqLine_iReqHeaderID	ReqLine_iReqHeaderID	Store_iaBaseStorePrice_3	Product_bReqStoreType	Supplier_sDefAccountNum	VenueAddress_sCountry	RequestedBy_iEditProductID	AuthorisedBy_iEditProductID
	POHeader_dbaInvoiceCostTax_4	ReqLine_dtDateUpdated	ReqLine_dtDateUpdated	Store_iaBaseStorePrice_4	Product_bDefaultSize	Supplier_iaSupplierFlag_0	VenueAddress_sPCode	RequestedBy_iEditPriceProductID	AuthorisedBy_iEditPriceProductID
	POHeader_dbInvoiceRounding	ReqLine_iLineID	ReqLine_iLineID	Store_iaBaseStorePrice_5	Product_iPrnProfileID	Supplier_iaSupplierFlag_1	VenueAddress_sPhoneHome	RequestedBy_iViewNegStoreID	AuthorisedBy_iViewNegStoreID
	POHeader_dbInvoiceFreight	ReqLine_dtFirstReceiveDate	ReqLine_dtFirstReceiveDate	Store_iaBaseStorePrice_6	Product_iPrerequisiteID	Supplier_balCustomFlag_0	VenueAddress_sPhoneWork	RequestedBy_iAllowTillNegStoreID	AuthorisedBy_iAllowTillNegStoreID
	POHeader_dbInvoiceFinance	ReqLine_dtLastReceiveDate	ReqLine_dtLastReceiveDate	Store_iaBaseStorePrice_7	Product_isMaxSalesQty	Supplier_balCustomFlag_1	VenueAddress_sFax	RequestedBy_blOperateTill	AuthorisedBy_blOperateTill
	POHeader_dbInvoiceDiscount	ReqLine_bPOLineStatus	ReqLine_bPOLineStatus	Store_iaBaseStorePrice_8	Product_isCostTaxType	Supplier_balCustomFlag_2	VenueAddress_sMobile	RequestedBy_blManagerFunc	AuthorisedBy_blManagerFunc
	POHeader_dbSettlementDisc	ReqLine_bPOExportStatus	ReqLine_bPOExportStatus	Store_sTillScrollMsg	Product_bStockType	Supplier_balCustomFlag_3	VenueAddress_sEmail1st	RequestedBy_blManagerOverride	AuthorisedBy_blManagerOverride
	POHeader_dbExtraItemsCharge	ReqLine_iSupplierID	ReqLine_iSupplierID	Store_sTillLogonMsg	Product_iStockTypeQty	Supplier_balCustomFlag_4	VenueAddress_sEmail2nd	RequestedBy_blExitTill	AuthorisedBy_blExitTill
	POHeader_dbLineItemTotalEx	ReqLine_iProductID	ReqLine_iProductID	Store_sTillLogoffMsg	Product_sUnitName	Supplier_balCustomFlag_5	VenueAddress_sFaceBook	RequestedBy_blCancelOrder	AuthorisedBy_blCancelOrder
	POHeader_dbLineItemTotalInc	ReqLine_iSupplierItemID	ReqLine_iSupplierItemID	Store_blUseSortforMargin	Product_iCaseQty	Supplier_balCustomFlag_6	VenueAddress_saPostalStreet_0	RequestedBy_blMinusItems	AuthorisedBy_blMinusItems
	POHeader_dtStockApplyDate	ReqLine_iStoreID	ReqLine_iStoreID	Store_iaDefMarginType0	Product_sCaseName	Supplier_balCustomFlag_7	VenueAddress_saPostalStreet_1	RequestedBy_blCreditSales	AuthorisedBy_blCreditSales
	POHeader_blStockToBeApplied	ReqLine_iOtherStoreID	ReqLine_iOtherStoreID	Store_iaDefMarginType1	Product_saSizeName_0	Supplier_balCustomFlag_8	VenueAddress_saPostalStreet_2	RequestedBy_blNoSale	AuthorisedBy_blNoSale
	POHeader_iFinanceTaxed	ReqLine_iStockVarID	ReqLine_iStockVarID	Store_iaDefMarginType2	Product_saSizeName_1	Supplier_balCustomFlag_9	VenueAddress_saPostalStreet_3	RequestedBy_blForceTender	AuthorisedBy_blForceTender
	POHeader_iSupplierRating	ReqLine_sSupplierNumber	ReqLine_sSupplierNumber	Store_iaDefMarginType3	Product_saSizeName_2	Supplier_balCustomFlag_10	VenueAddress_sPostalCity	RequestedBy_blAddScanAllowed	AuthorisedBy_blAddScanAllowed
	POHeader_blIsTemplate	ReqLine_sDescription	ReqLine_sDescription	Store_iaDefMarginType4	Product_saSizeName_3	Supplier_iaCustomNum_0	VenueAddress_sPostalState	RequestedBy_blTableCreate	AuthorisedBy_blTableCreate
		ReqLine_sUnitName	ReqLine_sUnitName	Store_iaDefMarginType5	Product_saSizeName_4	Supplier_iaCustomNum_1	VenueAddress_sPostalCountry	RequestedBy_blTableSales	AuthorisedBy_blTableSales
		ReqLine_sCasename	ReqLine_sCasename	Store_iaDefMarginType6	Product_saSizeName_5	Supplier_iaCustomNum_2	VenueAddress_sPostalPCode	RequestedBy_blTableNoMinusItems	AuthorisedBy_blTableNoMinusItems
		ReqLine_bStockType	ReqLine_bStockType	Store_iaDefMarginType7	Product_saSizeName_6	Supplier_iaCustomNum_3	VenueAddress_sSpare	RequestedBy_blTablePayments	AuthorisedBy_blTablePayments
		ReqLine_iStockTypeQty	ReqLine_iStockTypeQty	Store_iaDefMarginType8	Product_saSizeName_7	Supplier_iaCustomNum_4		RequestedBy_blTableClose	AuthorisedBy_blTableClose
		ReqLine_iCaseQty	ReqLine_iCaseQty	Store_iaDefMarginType9	Product_saSizeName_8	Supplier_iaCustomNum_5		RequestedBy_blAccountCreate	AuthorisedBy_blAccountCreate
		ReqLine_isCostTaxType	ReqLine_isCostTaxType	Store_iaDefMarginType10	Product_saSizeName_9	Supplier_dtaCustomDate_0		RequestedBy_blAccountSales	AuthorisedBy_blAccountSales
		ReqLine_dbOrderedUnits	ReqLine_dbOrderedUnits	Store_iaDefMarginType11	Product_saSizeName_10	Supplier_dtaCustomDate_1		RequestedBy_blAccountCharge	AuthorisedBy_blAccountCharge
		ReqLine_dbOrderedCases	ReqLine_dbOrderedCases	Store_iaDefMarginType12	Product_saSizeNameSec_0	Supplier_dtaCustomDate_2		RequestedBy_blAccountCredit	AuthorisedBy_blAccountCredit
		ReqLine_dbOrderedEachEx	ReqLine_dbOrderedEachEx	Store_iaDefMarginType13	Product_saSizeNameSec_1	Supplier_dtaCustomDate_3		RequestedBy_blAccountNegPay	AuthorisedBy_blAccountNegPay
		ReqLine_dbReceivedUnits	ReqLine_dbReceivedUnits	Store_iaDefMarginType14	Product_saSizeNameSec_2	Supplier_dtaCustomDate_4		RequestedBy_blRedeemPoints	AuthorisedBy_blRedeemPoints
		ReqLine_dbReceivedCases	ReqLine_dbReceivedCases	Store_iaDefMarginType15	Product_saSizeNameSec_3	Supplier_dtaCustomDate_5		RequestedBy_blRedeemCash	AuthorisedBy_blRedeemCash
		ReqLine_dbRecvPendEachEx	ReqLine_dbRecvPendEachEx	Store_iaDefMarginType16	Product_saSizeNameSec_4	Supplier_saCustomText_0		RequestedBy_blStockFunctions	AuthorisedBy_blStockFunctions
		ReqLine_dbReceivedEachEx	ReqLine_dbReceivedEachEx	Store_iaDefMarginType17	Product_saSizeNameSec_5	Supplier_saCustomText_1		RequestedBy_blStockView	AuthorisedBy_blStockView
		ReqLine_dbReceivedTotalEx	ReqLine_dbReceivedTotalEx	Store_iaDefMarginType18	Product_saSizeNameSec_6	Supplier_saCustomText_2		RequestedBy_blMultipleHold	AuthorisedBy_blMultipleHold
		ReqLine_dbReceivedTotalInc	ReqLine_dbReceivedTotalInc	Store_iaDefMarginType19	Product_saSizeNameSec_7	Supplier_saCustomText_3		RequestedBy_blDiscFixedOk	AuthorisedBy_blDiscFixedOk
		ReqLine_dbReceivedFreight	ReqLine_dbReceivedFreight	Store_iaDefMarginType20	Product_saSizeNameSec_8	Supplier_saCustomText_4		RequestedBy_blDiscEntryOk	AuthorisedBy_blDiscEntryOk
		ReqLine_dbReceivedDiscount	ReqLine_dbReceivedDiscount	Store_iaDefMarginType21	Product_saSizeNameSec_9	Supplier_saCustomText_5		RequestedBy_blGamingCash	AuthorisedBy_blGamingCash
		ReqLine_dbCancelledQty	ReqLine_dbCancelledQty	Store_iaDefMarginType22	Product_saSizeNameSec_10	Supplier_saCustomText_6		RequestedBy_blCardAuthorisations	AuthorisedBy_blCardAuthorisations
		ReqLine_saBarcode_0	ReqLine_saBarcode_0	Store_iaDefMarginType23	Product_iaSizeQty_0	Supplier_saCustomText_7		RequestedBy_blTableClearItem	AuthorisedBy_blTableClearItem
		ReqLine_saBarcode_1	ReqLine_saBarcode_1	Store_iaDefMarginType24	Product_iaSizeQty_1	Supplier_saCustomText_8		RequestedBy_blTableMapMaintenance	AuthorisedBy_blTableMapMaintenance
		ReqLine_saBarcode_2	ReqLine_saBarcode_2	Store_iaDefMarginType25	Product_iaSizeQty_2	Supplier_saCustomText_9		RequestedBy_blDataRulesMaintenance	AuthorisedBy_blDataRulesMaintenance
		ReqLine_saBarcode_3	ReqLine_saBarcode_3	Store_iaDefMarginType26	Product_iaSizeQty_3	Supplier_saCustomText_10		RequestedBy_blTableWaiter	AuthorisedBy_blTableWaiter
		ReqLine_iPackCommentID	ReqLine_iPackCommentID	Store_iaDefMarginType27	Product_iaSizeQty_4	Supplier_saCustomText_11		RequestedBy_blTableOnlyMine	AuthorisedBy_blTableOnlyMine
		ReqLine_iPOHeaderID	ReqLine_iPOHeaderID	Store_iaDefMarginType28	Product_iaSizeQty_5	Supplier_saCustomText_12		RequestedBy_blSendOpListMsg	AuthorisedBy_blSendOpListMsg
		ReqLine_iPOLineID	ReqLine_iPOLineID	Store_iaDefMarginType29	Product_iaSizeQty_6	Supplier_saCustomText_13		RequestedBy_blSendSmsMsg	AuthorisedBy_blSendSmsMsg
		ReqLine_dbPurchasingUnits	ReqLine_dbPurchasingUnits	Store_iTableGroupOffset	Product_iaSizeQty_7	Supplier_saCustomText_14		RequestedBy_blSendEmailMsg	AuthorisedBy_blSendEmailMsg
		ReqLine_dbPurchasingCases	ReqLine_dbPurchasingCases	Store_iTableGroupsUsed	Product_iaSizeQty_8	Supplier_saCustomText_15		RequestedBy_blBackOfficeUse	AuthorisedBy_blBackOfficeUse
		ReqLine_dbXferredUnits	ReqLine_dbXferredUnits	Store_balCustomFlag_0	Product_iaSizeQty_9	Supplier_saCustomText_16		RequestedBy_blProductAdd	AuthorisedBy_blProductAdd
		ReqLine_dbXferredCases	ReqLine_dbXferredCases	Store_balCustomFlag_1	Product_iaSizeQty_10	Supplier_saCustomText_17		RequestedBy_blProductEdit	AuthorisedBy_blProductEdit
		ReqLine_dbManufacturingUnits	ReqLine_dbManufacturingUnits	Store_balCustomFlag_2	Product_baSizeStockType_0	Supplier_saCustomText_18		RequestedBy_blProductView	AuthorisedBy_blProductView
		ReqLine_dbManufacturingCases	ReqLine_dbManufacturingCases	Store_balCustomFlag_3	Product_baSizeStockType_1	Supplier_saCustomText_19		RequestedBy_blSizesEdit	AuthorisedBy_blSizesEdit
				Store_balCustomFlag_4	Product_baSizeStockType_2	Supplier_saCustomText_20		RequestedBy_blPricesEdit	AuthorisedBy_blPricesEdit
				Store_balCustomFlag_5	Product_baSizeStockType_3			RequestedBy_blProdStoreAddDelete	AuthorisedBy_blProdStoreAddDelete
				Store_balCustomFlag_6	Product_baSizeStockType_4			RequestedBy_blProdStoreEdit	AuthorisedBy_blProdStoreEdit
				Store_balCustomFlag_7	Product_baSizeStockType_5			RequestedBy_blOperatorsCreate	AuthorisedBy_blOperatorsCreate
				Store_balCustomFlag_8	Product_baSizeStockType_6			RequestedBy_blOperatorsModify	AuthorisedBy_blOperatorsModify
				Store_balCustomFlag_9	Product_baSizeStockType_7			RequestedBy_blOperatorsView	AuthorisedBy_blOperatorsView
				Store_balCustomFlag_10	Product_baSizeStockType_8			RequestedBy_blAccountsModify	AuthorisedBy_blAccountsModify
				Store_iaCustomNum_0	Product_baSizeStockType_9			RequestedBy_blAccountsView	AuthorisedBy_blAccountsView
				Store_iaCustomNum_1	Product_baSizeStockType_10			RequestedBy_blReportCash	AuthorisedBy_blReportCash
				Store_iaCustomNum_2	Product_balSizeNonDisc_0			RequestedBy_blReportStock	AuthorisedBy_blReportStock
				Store_iaCustomNum_3	Product_balSizeNonDisc_1			RequestedBy_blReportProducts	AuthorisedBy_blReportProducts
				Store_iaCustomNum_4	Product_balSizeNonDisc_2			RequestedBy_blReportAccounts	AuthorisedBy_blReportAccounts
				Store_iaCustomNum_5	Product_balSizeNonDisc_3			RequestedBy_blUseSetup	AuthorisedBy_blUseSetup
				Store_dtaCustomDate_0	Product_balSizeNonDisc_4			RequestedBy_blUseSystemSetup	AuthorisedBy_blUseSystemSetup
				Store_dtaCustomDate_1	Product_balSizeNonDisc_5			RequestedBy_blViewCosts	AuthorisedBy_blViewCosts
				Store_dtaCustomDate_2	Product_balSizeNonDisc_6			RequestedBy_blGlobalRepUse	AuthorisedBy_blGlobalRepUse
				Store_dtaCustomDate_3	Product_balSizeNonDisc_7			RequestedBy_blGlobalRepSave	AuthorisedBy_blGlobalRepSave
				Store_dtaCustomDate_4	Product_balSizeNonDisc_8			RequestedBy_blStockAdjust	AuthorisedBy_blStockAdjust
				Store_dtaCustomDate_5	Product_balSizeNonDisc_9			RequestedBy_blStockXfer	AuthorisedBy_blStockXfer
				Store_saCustomText_0	Product_balSizeNonDisc_10			RequestedBy_blStockXferPost	AuthorisedBy_blStockXferPost
				Store_saCustomText_1	Product_balCustomFlag_0			RequestedBy_blStockXferRecv	AuthorisedBy_blStockXferRecv
				Store_saCustomText_2	Product_balCustomFlag_1			RequestedBy_blStockXferHO	AuthorisedBy_blStockXferHO
				Store_saCustomText_3	Product_balCustomFlag_2			RequestedBy_blStockXferVenues	AuthorisedBy_blStockXferVenues
				Store_saCustomText_4	Product_balCustomFlag_3			RequestedBy_blStockCreatePO	AuthorisedBy_blStockCreatePO
				Store_saCustomText_5	Product_balCustomFlag_4			RequestedBy_blStockPostPO	AuthorisedBy_blStockPostPO
				Store_saCustomText_6	Product_balCustomFlag_5			RequestedBy_blStockRecvPO	AuthorisedBy_blStockRecvPO
				Store_saCustomText_7	Product_balCustomFlag_6			RequestedBy_blStockRecvPend	AuthorisedBy_blStockRecvPend
				Store_saCustomText_8	Product_balCustomFlag_7			RequestedBy_blStockRecvManual	AuthorisedBy_blStockRecvManual
				Store_saCustomText_9	Product_balCustomFlag_8			RequestedBy_blStockViewVenues	AuthorisedBy_blStockViewVenues
				Store_saCustomText_10	Product_balCustomFlag_9			RequestedBy_blViewsCreate	AuthorisedBy_blViewsCreate
				Store_isXferPriceSource	Product_balCustomFlag_10			RequestedBy_blViewsEdit	AuthorisedBy_blViewsEdit
					Product_iaCustomNum_0			RequestedBy_blViewsDelete	AuthorisedBy_blViewsDelete
					Product_iaCustomNum_1			RequestedBy_blViewsFormulas	AuthorisedBy_blViewsFormulas
					Product_iaCustomNum_2			RequestedBy_blViewsShowAll	AuthorisedBy_blViewsShowAll
					Product_iaCustomNum_3			RequestedBy_blViewsAlterMineOnly	AuthorisedBy_blViewsAlterMineOnly
					Product_iaCustomNum_4			RequestedBy_bViewsDefaultOwner	AuthorisedBy_bViewsDefaultOwner
					Product_iaCustomNum_5			RequestedBy_blMemberJoin	AuthorisedBy_blMemberJoin
					Product_dtaCustomDate_0			RequestedBy_blMemberRenew	AuthorisedBy_blMemberRenew
					Product_dtaCustomDate_1			RequestedBy_blMemberAdmin	AuthorisedBy_blMemberAdmin
					Product_dtaCustomDate_2			RequestedBy_blMemberShipOnly	AuthorisedBy_blMemberShipOnly
					Product_dtaCustomDate_3			RequestedBy_iRaffleOpPrivilege	AuthorisedBy_iRaffleOpPrivilege
					Product_dtaCustomDate_4			RequestedBy_iPOOrderLimit	AuthorisedBy_iPOOrderLimit
					Product_dtaCustomDate_5			RequestedBy_iPORecvVarPercent	AuthorisedBy_iPORecvVarPercent
					Product_saCustomText_0			RequestedBy_iPOLineRecvVarPercent	AuthorisedBy_iPOLineRecvVarPercent
					Product_saCustomText_1			RequestedBy_iPOAuthFlag	AuthorisedBy_iPOAuthFlag
					Product_saCustomText_2			RequestedBy_iaOpFlag_0	AuthorisedBy_iaOpFlag_0
					Product_saCustomText_3			RequestedBy_iaOpFlag_1	AuthorisedBy_iaOpFlag_1
					Product_saCustomText_4			RequestedBy_iaOpFlag_2	AuthorisedBy_iaOpFlag_2
					Product_saCustomText_5			RequestedBy_iaOpFlag_3	AuthorisedBy_iaOpFlag_3
					Product_saCustomText_6			RequestedBy_iaOpFlag_4	AuthorisedBy_iaOpFlag_4
					Product_saCustomText_7			RequestedBy_iOpPrivFlags	AuthorisedBy_iOpPrivFlags
					Product_saCustomText_8			RequestedBy_balCustomFlag_0	AuthorisedBy_balCustomFlag_0
					Product_saCustomText_9			RequestedBy_balCustomFlag_1	AuthorisedBy_balCustomFlag_1
					Product_saCustomText_10			RequestedBy_balCustomFlag_2	AuthorisedBy_balCustomFlag_2
					Product_saCustomText_11			RequestedBy_balCustomFlag_3	AuthorisedBy_balCustomFlag_3
					Product_saCustomText_12			RequestedBy_balCustomFlag_4	AuthorisedBy_balCustomFlag_4
					Product_saCustomText_13			RequestedBy_balCustomFlag_5	AuthorisedBy_balCustomFlag_5
					Product_saCustomText_14			RequestedBy_balCustomFlag_6	AuthorisedBy_balCustomFlag_6
					Product_saCustomText_15			RequestedBy_balCustomFlag_7	AuthorisedBy_balCustomFlag_7
					Product_saCustomText_16			RequestedBy_balCustomFlag_8	AuthorisedBy_balCustomFlag_8
					Product_saCustomText_17			RequestedBy_balCustomFlag_9	AuthorisedBy_balCustomFlag_9
					Product_saCustomText_18			RequestedBy_balCustomFlag_10	AuthorisedBy_balCustomFlag_10
					Product_saCustomText_19			RequestedBy_iaCustomNum_0	AuthorisedBy_iaCustomNum_0
					Product_saCustomText_20			RequestedBy_iaCustomNum_1	AuthorisedBy_iaCustomNum_1
					Product_iUsedLastWeek			RequestedBy_iaCustomNum_2	AuthorisedBy_iaCustomNum_2
					Product_iPrepTime			RequestedBy_iaCustomNum_3	AuthorisedBy_iaCustomNum_3
					Product_iaPrepTime0			RequestedBy_iaCustomNum_4	AuthorisedBy_iaCustomNum_4
					Product_iaPrepTime1			RequestedBy_iaCustomNum_5	AuthorisedBy_iaCustomNum_5
					Product_iaPrepTime2			RequestedBy_dtaCustomDate_0	AuthorisedBy_dtaCustomDate_0
					Product_iaPrepTime3			RequestedBy_dtaCustomDate_1	AuthorisedBy_dtaCustomDate_1
					Product_iaPrepTime4			RequestedBy_dtaCustomDate_2	AuthorisedBy_dtaCustomDate_2
					Product_iPlateTime			RequestedBy_dtaCustomDate_3	AuthorisedBy_dtaCustomDate_3
								RequestedBy_dtaCustomDate_4	AuthorisedBy_dtaCustomDate_4
								RequestedBy_dtaCustomDate_5	AuthorisedBy_dtaCustomDate_5
								RequestedBy_saCustomText_0	AuthorisedBy_saCustomText_0
								RequestedBy_saCustomText_1	AuthorisedBy_saCustomText_1
								RequestedBy_saCustomText_2	AuthorisedBy_saCustomText_2
								RequestedBy_saCustomText_3	AuthorisedBy_saCustomText_3
								RequestedBy_saCustomText_4	AuthorisedBy_saCustomText_4
								RequestedBy_saCustomText_5	AuthorisedBy_saCustomText_5
								RequestedBy_saCustomText_6	AuthorisedBy_saCustomText_6
								RequestedBy_saCustomText_7	AuthorisedBy_saCustomText_7
								RequestedBy_saCustomText_8	AuthorisedBy_saCustomText_8
								RequestedBy_saCustomText_9	AuthorisedBy_saCustomText_9
								RequestedBy_saCustomText_10	AuthorisedBy_saCustomText_10
								RequestedBy_saCustomText_11	AuthorisedBy_saCustomText_11
								RequestedBy_saCustomText_12	AuthorisedBy_saCustomText_12
								RequestedBy_saCustomText_13	AuthorisedBy_saCustomText_13
								RequestedBy_saCustomText_14	AuthorisedBy_saCustomText_14
								RequestedBy_saCustomText_15	AuthorisedBy_saCustomText_15
								RequestedBy_saCustomText_16	AuthorisedBy_saCustomText_16
								RequestedBy_saCustomText_17	AuthorisedBy_saCustomText_17
								RequestedBy_saCustomText_18	AuthorisedBy_saCustomText_18
								RequestedBy_saCustomText_19	AuthorisedBy_saCustomText_19
								RequestedBy_saCustomText_20	AuthorisedBy_saCustomText_20
								RequestedBy_sDashboard	AuthorisedBy_sDashboard
								RequestedBy_dsLastSRShiftRun	AuthorisedBy_dsLastSRShiftRun
								RequestedBy_dsLastSRShiftMsg	AuthorisedBy_dsLastSRShiftMsg
								RequestedBy_dsMealBreakAlerted	AuthorisedBy_dsMealBreakAlerted
								RequestedBy_dsRestBreakAlerted	AuthorisedBy_dsRestBreakAlerted
								RequestedBy_dsDayOTAlerted	AuthorisedBy_dsDayOTAlerted
								RequestedBy_dsWeekOTAlerted	AuthorisedBy_dsWeekOTAlerted
								RequestedBy_iaUsageFlags0	AuthorisedBy_iaUsageFlags0
								RequestedBy_iaUsageFlags1	AuthorisedBy_iaUsageFlags1
								RequestedBy_iAppID	AuthorisedBy_iAppID
								RequestedBy_iMyBepozID	AuthorisedBy_iMyBepozID
								RequestedBy_bGender	AuthorisedBy_bGender
								RequestedBy_dsDateBirth	AuthorisedBy_dsDateBirth
								RequestedBy_sPhotoUrl	AuthorisedBy_sPhotoUrl
								RequestedBy_dtMyBepozLastLoginDate	AuthorisedBy_dtMyBepozLastLoginDate
								RequestedBy_iMyBepozLoginQty	AuthorisedBy_iMyBepozLoginQty
								RequestedBy_isMyBepozSyncStatus	AuthorisedBy_isMyBepozSyncStatus
								RequestedBy_dtMyBepozSyncDate	AuthorisedBy_dtMyBepozSyncDate
								RequestedBy_isMyBepozActivitySyncStatus	AuthorisedBy_isMyBepozActivitySyncStatus
								RequestedBy_dtMyBepozActivitySyncDate	AuthorisedBy_dtMyBepozActivitySyncDate