DEFINE TEMP-TABLE Payload NO-UNDO
	FIELD StructureVersion AS CHARACTER 
		XML-NODE-TYPE "ATTRIBUTE" 
	FIELD Comments AS CHARACTER 
		XML-NODE-TYPE "ATTRIBUTE" 
	FIELD WholesalerID AS CHARACTER 
		XML-NODE-TYPE "ATTRIBUTE" 
	FIELD Payload_id AS RECID 
		XML-NODE-TYPE "HIDDEN" .

DEFINE TEMP-TABLE Period NO-UNDO
	FIELD PeriodType AS CHARACTER 
		XML-NODE-TYPE "ATTRIBUTE" 
	FIELD DateFrom AS CHAR
		XML-NODE-TYPE "ATTRIBUTE" 
	FIELD DateTo AS CHAR 
		XML-NODE-TYPE "ATTRIBUTE" 
	FIELD TotalRecordsCount AS DECIMAL 
		DECIMALS 0 
		XML-DATA-TYPE "integer" XML-NODE-TYPE "ATTRIBUTE" 
	FIELD TotalVolume AS DECIMAL 
		XML-NODE-TYPE "ATTRIBUTE" 
	FIELD PeriodNumber AS DECIMAL 
		DECIMALS 0 
		XML-DATA-TYPE "integer" XML-NODE-TYPE "ATTRIBUTE" 
	FIELD Comments AS CHARACTER 
		XML-NODE-TYPE "ATTRIBUTE" 
	FIELD Payload_id AS RECID 
		XML-NODE-TYPE "HIDDEN" 
	FIELD Period_id AS RECID 
		XML-NODE-TYPE "HIDDEN" .

DEFINE TEMP-TABLE Outlets NO-UNDO
	FIELD Comments AS CHARACTER 
		XML-NODE-TYPE "HIDDEN" 
	FIELD Payload_id AS RECID 
		XML-NODE-TYPE "HIDDEN" 
	FIELD Period_id AS RECID 
		XML-NODE-TYPE "HIDDEN" 
	FIELD Outlets_id AS RECID 
		XML-NODE-TYPE "HIDDEN" .

DEFINE TEMP-TABLE OutletEntry NO-UNDO
	FIELD Comments AS CHARACTER 
		XML-NODE-TYPE "HIDDEN" 
	FIELD Outlets_id AS RECID 
		XML-NODE-TYPE "HIDDEN"
	FIELD OutletEntry_id AS RECID 
		XML-NODE-TYPE "HIDDEN" .

DEFINE TEMP-TABLE DeliverTo NO-UNDO
	FIELD OutletNumber AS CHARACTER 
	FIELD Name1 AS CHARACTER 
	FIELD Name2 AS CHARACTER 
	FIELD ContactPerson AS CHARACTER 
	FIELD Address1 AS CHARACTER 
	FIELD Address2 AS CHARACTER 
	FIELD PostalCode AS CHARACTER 
	FIELD City AS CHARACTER 
	FIELD Telephone1 AS CHARACTER 
	FIELD Telephone2 AS CHARACTER 
	FIELD Fax AS CHARACTER 
	FIELD Email AS CHARACTER 
	FIELD VatNumber AS CHARACTER 
	FIELD KeyAccount AS CHARACTER 
	FIELD Channel AS CHARACTER 
	FIELD OutletEntry_id AS RECID 
		XML-NODE-TYPE "HIDDEN"
	FIELD DeliverTo_Id AS RECID 
		XML-NODE-TYPE "HIDDEN"
		
       INDEX DeliverTo-k1 IS PRIMARY
            OutletNumber.

DEFINE TEMP-TABLE BillTo NO-UNDO
	FIELD OutletNumber AS CHARACTER 
	FIELD Name1 AS CHARACTER 
	FIELD Name2 AS CHARACTER 
	FIELD ContactPerson AS CHARACTER 
	FIELD Address1 AS CHARACTER 
	FIELD Address2 AS CHARACTER 
	FIELD PostalCode AS CHARACTER 
	FIELD City AS CHARACTER 
	FIELD Telephone1 AS CHARACTER 
	FIELD Telephone2 AS CHARACTER 
	FIELD Fax AS CHARACTER 
	FIELD Email AS CHARACTER 
	FIELD VatNumber AS CHARACTER 
	FIELD KeyAccount AS CHARACTER 
	FIELD Channel AS CHARACTER 
	FIELD DeliverTo_id AS RECID 
		XML-NODE-TYPE "HIDDEN" 
	FIELD OutletEntry_id AS RECID 
		XML-NODE-TYPE "HIDDEN" .

DEFINE TEMP-TABLE Sales NO-UNDO
	FIELD TransactionType AS CHARACTER 
		XML-NODE-TYPE "ATTRIBUTE" 
	FIELD Period_id AS RECID 
		XML-NODE-TYPE "HIDDEN" 
	FIELD Sales_id AS RECID 
		XML-NODE-TYPE "HIDDEN" .

DEFINE TEMP-TABLE Transaction1 NO-UNDO
	XML-NODE-NAME "Transaction" 
	FIELD Comments AS CHARACTER 
		XML-NODE-TYPE "ATTRIBUTE" 
	FIELD OutletNumber AS CHARACTER 
	FIELD DeliveryDate AS CHAR 
	FIELD OrderNumberHbc AS CHARACTER 
	FIELD InvoiceNumber AS CHARACTER 
	FIELD Sales_id AS RECID 
		XML-NODE-TYPE "HIDDEN" 
	FIELD Transaction_id AS RECID 
		XML-NODE-TYPE "HIDDEN" .

DEFINE TEMP-TABLE TransactionDetails NO-UNDO
	FIELD ProductNumber AS CHARACTER 
	FIELD Quantity AS DECIMAL 
	FIELD Price AS DECIMAL 
	FIELD Transaction_id AS RECID 
		XML-NODE-TYPE "HIDDEN" 
	FIELD TransactionDetails_id AS RECID 
		XML-NODE-TYPE "HIDDEN" .

DEFINE TEMP-TABLE Products NO-UNDO
	FIELD Period_id AS RECID 
		XML-NODE-TYPE "HIDDEN" 
	FIELD Products_id AS RECID 
		XML-NODE-TYPE "HIDDEN" .

DEFINE TEMP-TABLE ProductEntry NO-UNDO
	FIELD Comments AS CHARACTER 
		XML-NODE-TYPE "ATTRIBUTE" 
	FIELD ProductNumber AS CHARACTER 
	FIELD ProductName AS CHARACTER 
	FIELD UnitOfQuantity AS CHARACTER 
	FIELD ArticleNameHbc AS CHARACTER 
	FIELD ArticleNumberHbc AS CHARACTER 
	FIELD EanConsumerUnit AS CHARACTER 
	FIELD EanMultipack AS CHARACTER 
	FIELD EanTradeUnit AS CHARACTER 
	FIELD ProductRemarks AS CHARACTER 
	FIELD PurchasePrice AS DECIMAL 
	FIELD PackageSizeLitres AS DECIMAL 
	FIELD SalesUnit AS CHARACTER 
	FIELD PackageType AS CHARACTER 
	FIELD Subunits AS CHARACTER 
	FIELD Products_id AS RECID 
		XML-NODE-TYPE "HIDDEN" 
	FIELD ProductEntry_id AS RECID 
		XML-NODE-TYPE "HIDDEN" .

DEFINE DATASET PayloadDS  
/* 	FOR Payload, Period, Outlets, OutletEntry, DeliverTo, BillTo, Products, ProductEntry, Sales, Transaction1, TransactionDetails */
	FOR Payload, Period, Outlets, OutletEntry, DeliverTo, Products, ProductEntry, Sales, Transaction1, TransactionDetails
	
	DATA-RELATION RELATION1 FOR Payload, Period
		RELATION-FIELDS (Payload_id, Payload_id) NESTED
		
	DATA-RELATION RELATION2 FOR Period, Outlets
		RELATION-FIELDS (Payload_id,Payload_id, Period_id, Period_id) NESTED
		
	DATA-RELATION RELATION3 FOR Outlets, OutletEntry
		RELATION-FIELDS (Outlets_id, Outlets_id) NESTED
		
	DATA-RELATION RELATION4 FOR OutletEntry, DeliverTo
		RELATION-FIELDS (OutletEntry_Id, OutletEntry_id) NESTED
		
/* 	DATA-RELATION RELATION5 FOR OutletEntry, BillTo */
/* 		RELATION-FIELDS  (OutletEntry_Id, OutletEntry_id) */
/* 	DATA-RELATION RELATION5 FOR DeliverTo, BillTo */
/* 		RELATION-FIELDS  (OutletEntry_Id, OutletEntry_id, DeliverTo_Id, DeliverTo_Id ) NESTED */
		
	DATA-RELATION RELATION6 FOR Period, Sales
		RELATION-FIELDS (Period_id, Period_id) NESTED
		
	DATA-RELATION RELATION7 FOR Sales, Transaction1
		RELATION-FIELDS (Sales_Id, Sales_id) NESTED
		
	DATA-RELATION RELATION8 FOR Transaction1, TransactionDetails
		RELATION-FIELDS (Transaction_id, Transaction_id) NESTED
		
	DATA-RELATION RELATION9 FOR Period, Products
		RELATION-FIELDS (Period_id, Period_id) NESTED

	DATA-RELATION RELATION10 FOR Products, ProductEntry
		RELATION-FIELDS (Products_id, Products_id) NESTED.