home *** CD-ROM | disk | FTP | other *** search
/ Jason Aller Floppy Collection / 160.img / A4V11B-2.ZIP / BWSAMPLE.ZIP / ALPHAVID.I4A < prev    next >
Encoding:
Text File  |  1989-11-17  |  3.8 KB  |  376 lines

  1. A4,0,1,0
  2. Alpha Video Invoice
  3. 4
  4. TAX
  5. SUBTOTAL * (TAXRATE/100)
  6. INVPRICE
  7. IIF(TRIM(INV_TYPE)="Sale",AVMOVIES->SALEPRICE,IF(TRIM(INV_TYPE)="Rental",AVMOVIES->RENTPRICE,0))
  8. INVSUBC
  9. INVPRICE*QUANTITY
  10. INVTOTC
  11. INVSUBC+TAX
  12. 23
  13. 1,0,6,9,0,0,67,4,4,4,1,0,0
  14. N
  15.  
  16.  
  17. AVSALES2
  18. INV_NO
  19. 1,0,7,9,0,2,67,6,6,6,1,0,0
  20. N
  21.  
  22.  
  23. AVSALES2
  24. INV_TYPE
  25. 1,0,8,9,0,1,68,8,10,10,1,2,0
  26. 1
  27.  
  28.  
  29. AVSALES2
  30. INV_DATE
  31. 1,0,7,26,0,3,67,4,4,4,1,0,0
  32. N
  33.  
  34.  
  35. AVSALES2
  36. CUST_ID
  37. 1,0,16,4,0,4,67,4,4,4,1,0,0
  38. N
  39.  
  40.  
  41. AVSALES2
  42. TAPE_ID
  43. 1,0,16,68,0,5,78,3,3,3,1,2,0
  44. N
  45.  
  46.  
  47. AVSALES2
  48. QUANTITY
  49. 1,0,18,66,0,7,78,5,5,5,1,2,2
  50. N
  51.  
  52.  
  53. AVSALES2
  54. TAXRATE
  55. 1,0,18,74,255,0,78,8,5,5,1,2,2
  56. N
  57.  
  58.  
  59. CALC
  60. TAX
  61. 1,0,7,35,1,1,67,4,4,4,1,0,0
  62. N
  63.  
  64.  
  65. AVPATRON
  66. SALUTATION
  67. 1,0,7,41,1,2,67,10,10,10,1,0,0
  68. N
  69.  
  70.  
  71. AVPATRON
  72. FIRSTNAME
  73. 1,0,7,58,1,3,67,15,15,15,1,0,0
  74. N
  75.  
  76.  
  77. AVPATRON
  78. LASTNAME
  79. 1,0,9,35,1,4,67,20,20,20,1,0,0
  80. N
  81.  
  82.  
  83. AVPATRON
  84. ADDRESS1
  85. 1,0,10,35,1,5,67,20,20,20,1,0,0
  86. N
  87.  
  88.  
  89. AVPATRON
  90. ADDRESS2
  91. 1,0,11,35,1,6,67,15,15,15,1,0,0
  92. N
  93.  
  94.  
  95. AVPATRON
  96. CITY
  97. 1,0,11,52,1,7,67,2,2,2,1,0,0
  98. N
  99.  
  100.  
  101. AVPATRON
  102. STATE
  103. 1,0,11,56,1,8,67,5,5,5,1,0,0
  104. N
  105.  
  106.  
  107. AVPATRON
  108. ZIP
  109. 1,0,9,65,1,9,67,14,14,14,1,0,0
  110. N
  111.  
  112.  
  113. AVPATRON
  114. HOMEPHONE
  115. 1,0,16,10,2,1,67,40,40,20,2,0,0
  116. X
  117.  
  118.  
  119. AVMOVIES
  120. TAPE_TITLE
  121. 1,0,16,32,2,3,67,20,20,20,1,0,0
  122. N
  123.  
  124.  
  125. AVMOVIES
  126. SUBJECT
  127. 1,0,16,54,2,6,67,5,5,5,1,0,0
  128. N
  129.  
  130.  
  131. AVMOVIES
  132. TAPETYPE
  133. 1,0,16,61,255,1,78,8,6,6,1,2,2
  134. N
  135.  
  136.  
  137. CALC
  138. INVPRICE
  139. 1,0,16,73,255,2,78,8,6,6,1,2,2
  140. N
  141.  
  142.  
  143. CALC
  144. INVSUBC
  145. 1,0,19,71,255,3,78,8,8,8,1,2,2
  146. N
  147.  
  148.  
  149. CALC
  150. INVTOTC
  151. 10
  152. !┌──────────────────────────────────────────────────────────────────────────────┐
  153. !│ ALPHA VIDEO......................................"The Best In Entertainment" │
  154. !└──────────────────────────────────────────────────────────────────────────────┘
  155. !┌─ INVOICE ─────────┐ ┌─ CUSTOMER ─────────────────────────────────────────────┐
  156. !│                   │ │  No.      Sal.  First Name       Last Name             │
  157. !│  No.:             │ │                                                        │
  158. !│ Type:             │ │                                                        │
  159. !│ Date:             │ │                                                        │
  160. !│                   │ │  Address:                        Phone:                │
  161. !│                   │ │                                                        │
  162. !│                   │ │     City:                                              │
  163. !└───────────────────┘ └────────────────────────────────────────────────────────┘
  164. !┌─ TAPE ───────────────────────────────────────────────────────────────────────┐
  165. !│  No.   Title                 Subject               Type   Price  Quan Total  │
  166. !│                                                                              │
  167. !│                                                                              │
  168. !│                                                                              │
  169. !│                                                           Tax:      %        │
  170. !│                                                        Grand Total:          │
  171. !└──────────────────────────────────────────────────────────────────────────────┘
  172. q
  173. q
  174. !
  175. !
  176. !
  177. !
  178. !
  179. !
  180. !
  181. !
  182. !
  183. !
  184. !
  185. !
  186. !
  187. !
  188. !
  189. !
  190. !
  191. !
  192. !
  193. !
  194. !
  195. !
  196. !
  197. !
  198. !
  199. !
  200. !
  201. !
  202. !
  203. !
  204. !
  205. !
  206. !
  207. !
  208. !
  209. !
  210. !
  211. !
  212. !
  213. !
  214. !
  215. !
  216. !
  217. !
  218. !
  219. !
  220. !
  221. !
  222. !
  223. !
  224. !
  225. !
  226. !
  227. !
  228. !
  229. !
  230. !
  231. !
  232. !
  233. !
  234. !
  235. !
  236. !
  237. !
  238. !
  239. !
  240. !
  241. !
  242. !
  243. !
  244. !
  245. !
  246. !
  247. !
  248. !
  249. !
  250. !
  251. !
  252. !
  253. !
  254. !
  255. !
  256. !
  257. !
  258. !
  259. !
  260. !
  261. !
  262. !
  263. !
  264. !
  265. !
  266. !
  267. !
  268. !
  269. !
  270. !
  271. !
  272. !
  273. !
  274. !
  275. !
  276. !
  277. !
  278. !
  279. !
  280. !
  281. !
  282. !
  283. !
  284. !
  285. !
  286. !
  287. !
  288. !
  289. !
  290. !
  291. !
  292. !
  293. !
  294. !
  295. !
  296. !
  297. !
  298. !
  299. !
  300. !
  301. !
  302. !
  303. !
  304. !
  305. !
  306. !
  307. !
  308. !
  309. !
  310. !
  311. !
  312. !
  313. !
  314. !
  315. !
  316. !
  317. !
  318. !
  319. !
  320. !
  321. !
  322. !
  323. !
  324. !
  325. !
  326. !
  327. !
  328. !
  329. !
  330. !
  331. !
  332. !
  333. !
  334. !
  335. !
  336. !
  337. !
  338. !
  339. !
  340. !
  341. !
  342. !
  343. !
  344. !
  345. !
  346. !
  347. !
  348. !
  349. !
  350. !
  351. !
  352. !
  353. !
  354. !
  355. !
  356. !
  357. !
  358. !
  359. !
  360. !
  361. !
  362. !
  363. !
  364. !
  365. !
  366. !
  367. !
  368. !
  369. !
  370. !
  371. !
  372. 1,0,1,0,1,1,0
  373. 1,49,1,0,1,49,0,0,1
  374.  
  375. 0,0,0,0,1,66
  376.