home *** CD-ROM | disk | FTP | other *** search
/ Jason Aller Floppy Collection / 160.img / A4V11B-2.ZIP / REPORT.ZIP / INVOICES.I4A < prev    next >
Encoding:
Text File  |  1989-11-17  |  2.6 KB  |  134 lines
  1. A4,0,1,0
  2. View data from all databases in set
  3. 0
  4. 17
  5. 1,0,3,22,0,0,67,5,10,10,1,0,0
  6. N
  7.  
  8. 63
  9. INV_HEAD
  10. INV_NO
  11. 1,0,4,22,0,1,67,5,10,10,1,0,0
  12. N
  13.  
  14. 63
  15. INV_HEAD
  16. CUST_ID
  17. 1,0,5,22,0,2,68,8,10,10,1,2,0
  18. 1
  19.  
  20. 63
  21. INV_HEAD
  22. DATE
  23. 1,0,9,54,1,4,67,13,25,25,1,0,0
  24. N
  25.  
  26. 95
  27. CUSTOMER
  28. CITY
  29. 1,0,5,54,1,0,67,5,25,25,1,0,0
  30. N
  31.  
  32. 95
  33. CUSTOMER
  34. CUST_ID
  35. 1,0,6,54,1,1,67,25,25,25,1,0,0
  36. N
  37.  
  38. 95
  39. CUSTOMER
  40. COMPANY
  41. 1,0,7,54,1,2,67,20,25,25,1,0,0
  42. N
  43.  
  44. 95
  45. CUSTOMER
  46. ADDRESS1
  47. 1,0,8,54,1,3,67,11,25,25,1,0,0
  48. N
  49.  
  50. 95
  51. CUSTOMER
  52. ADDRESS2
  53. 1,0,10,54,1,5,67,2,25,25,1,0,0
  54. N
  55.  
  56. 95
  57. CUSTOMER
  58. STATE
  59. 1,0,11,54,1,6,67,5,25,25,1,0,0
  60. N
  61.  
  62. 95
  63. CUSTOMER
  64. ZIP
  65. 1,0,13,24,2,0,67,5,5,5,1,0,0
  66. N
  67.  
  68. 31
  69. LINEITEM
  70. INV_NO
  71. 1,0,14,24,2,1,67,2,5,5,1,0,0
  72. N
  73.  
  74. 31
  75. LINEITEM
  76. LINE
  77. 1,0,15,24,2,2,78,10,5,5,1,0,0
  78. N
  79.  
  80. 31
  81. LINEITEM
  82. QTY
  83. 1,0,16,24,2,3,67,5,5,5,1,0,0
  84. N
  85.  
  86. 31
  87. LINEITEM
  88. PART_NO
  89. 1,0,19,40,3,0,67,5,39,39,1,0,0
  90. N
  91.  
  92. 47
  93. PARTS
  94. PART_NO
  95. 1,0,20,40,3,1,67,40,39,39,1,0,0
  96. N
  97.  
  98. 47
  99. PARTS
  100. DESC
  101. 1,0,21,40,3,2,78,10,39,39,1,0,2
  102. N
  103.  
  104. if(PARTS->UNIT_PRICE < 10, 47, 174)
  105. PARTS
  106. UNIT_PRICE
  107. 1
  108. !░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░Invoice Set░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
  109. #┌─INV_HEAD─────────────────────┐
  110. !┌── Invoice Number :             │                                              
  111. !│ │ Customer Id    :       ────────┐  ┌─CUSTOMER───────────────────────────────┐
  112. !│ │ Invoice Date   :             │ │  │ Customer Id:                           │
  113. !│ └──────────────────────────────┘ └─│ Company    :                           │
  114. !│                                     │ Address 1  :                           │
  115. !│                                     │ Address 2  :                           │
  116. !│                                     │ City       :                           │
  117. !│                                     │ State      :                           │
  118. !│                                     │ Zip        :                           │
  119. !│   ╔═LINEITEM════════════════════╗   └────────────────────────────────────────┘
  120. !└──║ Invoice Number :            ║                                             
  121. %║ Lineitem Number:            ║
  122. %║ Quantity       :            ║
  123. !┌──── Part Number    :            ║
  124. !│   ╚═════════════════════════════╝
  125. !│                       ┌─PARTS────────────────────────────────────────────────┐
  126. !└──────────────────────│ Part Number:                                         │
  127. 9│ Description:                                         │
  128. 9│ Price      :                                         │
  129. 9└──────────────────────────────────────────────────────┘
  130. 1,0,1,2,1,1,1
  131. 1,49,1,0,1,49,0,0,1
  132.  
  133. 0,0,0,0,1,66
  134.