FILE UVTRANS.DOC - STRUCTURE OF UVTRANS.DBF Files # 4 and 5
==============================================================================
FILE NAME................:UVTRANS.DBF Total records in the file: 55
FILE TYPE................:Type III Length of each record....: 925
LAST UPDATE..............: 1/23/96 Fields per record........: 48
FIELD TYPE POS LEN DESCRIPTION
============= ===== ===== === ==============================================
1. ITEMNO Char 002-011 10 The Vendor's Item Number
2. ITEMDESC Char 012-030 19 Vendor Description - Main Cat First
3 DIMENSIONS Char 031-033 3 Largest dimension - usually inches
4. UNITMEASUR Char 034-035 2 Units of largest dim - IN, FT, CM
5. FABCODE Char 036-050 15 Fabric Code or equiv - this line item
6. FABCOLOR Char 051-069 19 Fabric Color (alpha) - this line item
7. OPTION1 Char 070-109 40 First Option selection - free text
8. OPTION2 Char 110-149 40 Second Option selection - free text
9. OPTION3 Char 150-189 40 Third Option selection - free text
10. OPTION4 Char 190-229 40 Fourth Option selection - free text
11. OPTION5 Char 230-269 40 Fifth Option selection - free text
12. OPTION6 Char 270-309 40 Sixth Option selection - free text
13. OPTION7 Char 310-349 40 Seventh Option selection - free text
14. OPTION8 Char 350-389 40 Eighth Option selection - free text
15. OPTION9 Char 390-429 40 Nineth Option selection - free text
16. OPTION10 Char 430-469 40 Tenth Option selection - free text
17. OPTION11 Char 470-509 40 Eleventh Option selection - free text
18. OPTION12 Char 510-549 40 Twelfth Option selection - free text
19. OPTION13 Char 550-589 40 Thirteenth Option selection - free text
20. OPTION14 Char 590-629 40 Fourteenth Option selection - free text
21. OPTION15 Char 630-669 40 Fifteenth Option selection - free text
22. OPTION16 Char 670-709 40 Sixteenth Option selection - free text
23. RETPRICE Char 710-717 8 Our selling price - this item (nominal)
24. DELIVDATE Char 718-725 8 Date physically received by us
25. FLAGTHREE Char 726-733 8 Date ordered by customer
26. FLAGFOUR Char 734-741 8 vacant
27. MEMOADDRES Char 742-751 10 Memo field record address - if any
28. PONO Char 752-756 5 Purchase Order Number - usually ORDERNO
29. VEN Char 757-759 3 VEN code - who to order from
30. DELDATEREQ Char 760-767 8 Delivery Date Required - at order time
31. QUAN Char 768-770 3 Quantity ordered - this line item
32. RESTRICTED Char 771-771 1 Are there restrictions on this item?(1 = yes)
33. COSTDOL Char 772-779 8 Our cost this line item if known
34. ORDERNO Char 780-784 5 Our Sales Order Number
35. TAGFOR Char 785-799 15 Customer name - this item
36. SENDORDFLG Char 800-800 1 1-send to rep 2-send to factory Y-ordered
37. DROPSHPFLG Char 801-801 1 Drop Shipment Flag - Y if yes
38. OPTIONSFLG Char 802-802 1 Are there options on this item? (Y if Yes)
39. DELIVTOCUS Char 803-810 8 Date Delivered to customer-Turns on Compflag if
40. ORDNOLNNO Char 811-813 3 Line item this item of total non null
41. ORDNOLNTOT Char 814-816 3 Total line items on this sales order
42. UPHFLAG Char 817-817 1 Is this an upholstered item?
43. DSHIPTOLN1 Char 818-853 36 Drop Shipment Name - If any
44. DSHIPTOLN2 Char 854-889 36 Drop Shipment Addr - If any
45. DSHIPTOCIT Char 890-914 25 Drop Shipment City - If any
46. DSHIPTOST Char 915-916 2 Drop Shipment State- If any
47. DSHIPTOZ5 Char 917-921 5 Drop Shipment Zip5 - If any
48. DSHIPTOZ4 Char 922-925 4 Drop Shipment Zip4 - If any
INDEXES: ON ORDERNO (UVTRANS.NDX)
ON VEN (UVTRANS1.NDX)
On Order Completion, UVTrans records could be broken apart.
All delivered orders could be saved in VTRANS.DBF for reference -
If any option info, saved in VOPTIONS.DBF, linked by ORDERNO (34) and ITEMNO
delivered orders numbering over 100 are removed from UVTrans, oldest first.