In order to bring you the best possible user experience, this site uses Javascript. If you are seeing this message, it is likely that the Javascript option in your browser is disabled. For optimal viewing of this site, please ensure that Javascript is enabled for your browser.
Login  |   On Demand  |   Home  |   qad.com




QDoc Data Files
The QDoc data file is generated in QGen. The following is an excerpt of the maintainSalesOrder.dat file using the QDoc 1.0 specification. The bold numbers are QGen sequence numbers and are the beginnings of lines. Lines where three periods appear (...) show where lines have been removed for simplicity. A description of relevant document contents follows the file excerpt. See QGen for details.
1000,"salesOrder",1,"Start/End Iteration","f4","a","so_nbr", "soNbr#0:a021","soNbr","Order",yes,no,0,"x(8)","CHARACTER", "so_mstr","RETURN",yes,no,no,no,"","","",yes,yes, "iedPortTransh#0:a051"
2000,"",1,"None","","a","so_cust","soCust#0:a021","soCust", "Sold-To",no,no,0,"x(8)","CHARACTER","so_mstr","RETURN",yes,no, no,no,"","","",yes,yes,""
3000,"",1,"None","","a","so_bill","soBill#0:a021","soBill", "Bill To",no,no,0,"x(8)","CHARACTER","so_mstr","RETURN",yes,no, no,no,"","","",yes,yes,""
4000,"",1,"None","","a","so_ship","soShip#0:a021","soShip", "Ship-To",no,no,0,"x(8)","CHARACTER","so_mstr","RETURN",yes,no, no,no,"","","",yes,yes,""
4100,"",1,"None","",?,"yn","yn#0:1","yn",?,no,no,0,"yes/no", "LOGICAL",?,"RETURN",yes,no,no,no,"","","",yes,yes,""
4200,"",1,"None","","new_ship","ad_name", "adName#0:new_ship041","adName","Name",no,no,0,"x(28)", "CHARACTER","ad_mstr","RETURN",yes,no,no,no,"","","",yes,yes,""
4300,"",1,"None","","new_ship","ad_line1", "adLine1#0:new_ship041","adLine1","Address",no,no,0,"x(28)", "CHARACTER","ad_mstr","RETURN",yes,no,no,no,"","","",yes,yes,""
...
 
58000,"transComment",2,"Start/End Iteration","f4","cmmt01", "cd_ref", "cdRef#0:cmmt01021","cdRef","Master Reference",no,no, 0,"x(40)","CHARACTER","cd_det","return",yes,no,no,no,"","","", yes,yes,"cdRef#0:cmmt01021"
59000,"salesOrderDetail",2,"Start/End Iteration","f4:f4","c", "line","line#0:c051","line"," Ln",yes,no,0,">>9","INTEGER",?, "return",yes,no,yes,no,"f4","S","return",yes,yes,
"cdType#0:cmmt01021"
59100,"allocationDetail",3,"Start/End Iteration","f4","alloc", "lad_loc","ladLoc#0:alloc1091","ladLoc","Location",yes,no,0, "x(8)","CHARACTER","lad_det","RETURN",yes,no,no,no,"","","", yes,yes,"ladQtyAll#0:alloc1091"
59200,"",3,"None","","alloc","lad_lot","ladLot#0:alloc1091", "ladLot","Lot/Serial",no,no,0,"x(18)","CHARACTER","lad_det", "RETURN",yes,no,no,no,"","","",yes,yes,""
...
68400,"features",3,"Start/End Iteration","f4","w", "work2_feature","work2Feature#0:w491","work2Feature","Feature",yes,no,0,"->>>,>>9.9<<<<<<","CHARACTER","work2_list","RETURN" ,yes,no,no,yes,"","","",yes,yes,"work2NetPrice#0:w091"
68500,"configuredItemDetail",4,"Start/End Iteration","f4", "w","work2_comp","work2Comp#0:w091","work2Comp","Item Number" ,yes,no,0,"->>>,>>9.9<<<<<<","CHARACTER","work2_list","RETURN" ,yes,no,no,yes,"","","",yes,yes,"work2NetPrice#0:w091"
...
145000,"",2,"None","","a","ied_region","iedRegion#0:a051", "iedRegion","Region of Origin/Dest",no,no,0,"x(3)","CHARACTER" ,"ied_det","RETURN",yes,no,no,no,"","","",yes,yes,""
146000,"",2,"None","","a","ied_port_transh","iedPortTransh#0:a051","iedPortTransh","Port of Transshipment",no,no,0,"x(8)", "CHARACTER","ied_det","RETURN",yes,no,no,no,"","","",yes,yes,""
Each sequence number represents a field. The sequence numbers reflect the program hierarchy. The numbers ascend in increments of 1000 if the fields are in their own frames or require the Go key to proceed. At 4000, where a separate frame is encountered, the fields within the frame ascend in increments of 100. A frame encountered inside this frame would increment in 10’s, and another inside that would increment in 1’s.
The first entry (1000) includes a name (salesOrder), the iteration (1), and the identifier (Start/End Iteration). It also includes the key required to leave the iteration (F4).
Other entries do not include names until 58000. This is the standard Transaction Comments entry in QDoc specification 1.0. It starts and ends an iteration, and so is iteration number 2. The next entry, 5900, named salesOrderDetail, is also iteration 2. This is because the comments iteration is already complete by the time you reach this field. The allocationDetail iteration, 59100, and all the fields associated with it, is numbered iteration 3 because it occurs inside the salesOrderDetail iteration.
The other iterations in the program—features and configuredItemDetail— are shown. Then there is a break until the last two entries in the file.