Chip 1999 June

home *** CD-ROM | disk | FTP | other *** search

/ Chip 1999 June / Chip_1999-06_cd.bin / sharewar / dns / DNSSYS.CMP / DNSDICT.DAT < prev next >

Wrap

Text File | 1996-08-17 | 17.8 KB | 335 lines

* PC DataNet * Distributor Networking System * (Amway(R) Version) * Data Dictionary File Structures * DBFDEF SYSTEM Creating System Information File * Structure for SYSTEM.DBF Last update: 02/08/93 * ───────────────┬────────┬───────────┬───────────── * Field Name │ Type │ Width │ Decimals * ───────────────┴────────┴───────────┴───────────── FNLPT N 1 0 FNTERM N 1 0 FNPORT N 2 0 FNBAUD N 6 0 FNPARITY N 2 0 FNWORD N 1 0 FNSTOP N 1 0 FCMODEM C 40 0 FLECHO L 1 0 FLAUTOANS L 1 0 FLDUPLEX L 1 0 FLXONXOFF L 1 0 FLCARRIER L 1 0 FLTONE L 1 0 FLRTSCTS L 1 0 FLMDMCODE N 8 2 FLDTRDSR L 1 0 FNMAXROW N 2 0 FNIRQ1 N 8 0 FNIRQ2 N 8 0 FNIRQ3 N 8 0 FNIRQ4 N 8 0 FNIRQ5 N 8 0 FNIRQ6 N 8 0 FNIRQ7 N 8 0 FNIRQ8 N 8 0 FNBASEIO1 N 8 0 FNBASEIO2 N 8 0 FNBASEIO3 N 8 0 FNBASEIO4 N 8 0 FNBASEIO5 N 8 0 FNBASEIO6 N 8 0 FNBASEIO7 N 8 0 FNBASEIO8 N 8 0 DDNAME C 15 0 DDADA C 7 0 DNS_LUSED D 8 0 RETENTION N 2 0 BUDATE D 8 0 INVBUDATE D 8 0 ENDDEF DBFDEF NETWORK Creating General Customer Information File * Structure for NETWORK.DBF Last update: 02/08/93 * ───────────────┬────────┬───────────┬───────────── * Field Name │ Type │ Width │ Decimals * ───────────────┴────────┴───────────┴───────────── ACCOUNT C 7 0 DIST_NAME C 30 0 LEVEL N 2 0 SPON_NAME C 30 0 SPON_NO C 7 0 LEG_ADANUM C 7 0 LEG C 15 0 BUS_NAME C 30 0 STREET C 30 0 BOX_APT C 30 0 CITY C 21 0 STATE C 2 0 ZIP C 5 0 PHONE1 C 10 0 PHONE2 C 10 0 JOINED D 8 0 FNAME1 C 12 0 FNAME2 C 12 0 LNAME1 C 15 0 LNAME2 C 15 0 DEL C 1 0 BALANCE N 9 2 PV_MTD N 9 2 BV_MTD N 9 2 PV_MONTH1 N 9 2 PV_MONTH2 N 9 2 PV_MONTH3 N 9 2 BV_MONTH1 N 9 2 BV_MONTH2 N 9 2 BV_MONTH3 N 9 2 PASSWORD C 8 0 COMMENTS M 10 0 TAXRATE N 6 3 SHRATE N 3 1 ORDERS_MTD N 2 0 LASTORDER D 8 0 MTDINV N 9 2 MTDPMT N 9 2 WHL_MTD N 9 2 RTL_MTD N 9 2 TOTINV N 9 2 TOTPMT N 9 2 ENDDEF DBFDEF AMORDERS Creating the Orders File * Structure for AMORDERS.DBF Last update: 02/08/93 * ───────────────┬────────┬───────────┬───────────── * Field Name │ Type │ Width │ Decimals * ───────────────┴────────┴───────────┴───────────── ACCOUNT C 7 0 INVOICE C 5 0 INVDATE D 8 0 STATUS C 9 0 INVAMOUNT N 9 2 NUM_ITEMS N 3 0 ITEMS_BO N 3 0 ADJUSTMENT N 7 2 BALANCE N 9 2 PMTDATE D 8 0 PMTAMOUNT N 9 2 DESCRIP C 40 0 ORDERTYPE C 1 0 CMPOSIT_NO C 5 0 TAX N 7 2 SHIPPING N 7 2 ORIG_ORDNO C 5 0 PV N 9 2 BV N 9 2 WHSL N 9 2 RTL N 9 2 INVPOSTED L 1 0 PMTPOSTED L 1 0 ORDER_SENT N 1 0 SENT_DATE D 8 0 NOTES M 10 0 ENDDEF DBFDEF AMITEMS Creating the Items File * Structure for AMITEMS.DBF Last update: 02/08/93 * ───────────────┬────────┬───────────┬───────────── * Field Name │ Type │ Width │ Decimals * ───────────────┴────────┴───────────┴───────────── INVOICE C 5 0 PARTNUMBER C 9 0 CATEGORY C 1 0 SIZE C 4 0 STATUS C 1 0 QTY_ORD N 4 0 QTY_SHIP N 4 0 QTY_BO N 4 0 PV N 9 2 BV N 9 2 WHSL N 9 2 RTL N 9 2 TAXABLE L 1 0 TAXRATE N 5 3 SHIPPING N 7 2 SPEC C 5 0 ENDDEF DBFDEF AMINVENT Checking the Inventory Database * Structure for AMINVENT.DBF Last update: 02/08/93 * ───────────────┬────────┬───────────┬───────────── * Field Name │ Type │ Width │ Decimals * ───────────────┴────────┴───────────┴───────────── SECTION C 1 0 CATEGORY C 1 0 STOCK_NO C 9 0 EACHES_NO C 9 0 DESCRIP C 40 0 COMN_NAME C 20 0 EACHES L 1 0 SIZE_CODE C 5 0 PACK_CASE N 3 0 WO_UNIT C 5 0 WO_PRICE N 9 2 TAXABLE L 1 0 CASE_DISC N 3 0 CASE_LOT C 5 0 UNIT_PV N 9 2 UNIT_BV N 9 2 UNIT_COST N 9 2 UNIT_RTL N 9 2 CASE_PV N 9 2 CASE_BV N 9 2 CASE_COST N 9 2 CASE_RTL N 9 2 FOOTNOTE N 2 0 EACHESCOST N 9 2 DESCRIP2 C 40 0 SUBCAT C 2 0 ENDDEF DBFDEF FOOTNOTE Creating Footnotes File * Structure for FOOTNOTE.DBF Last update: 02/08/93 * ───────────────┬────────┬───────────┬───────────── * Field Name │ Type │ Width │ Decimals * ───────────────┴────────┴───────────┴───────────── MSG_TEXT C 78 0 ENDDEF DBFDEF DNSHELP Creating the Online Help Database * Structure for DNSHELP.DBF Last update: 02/08/93 * ───────────────┬────────┬───────────┬───────────── * Field Name │ Type │ Width │ Decimals * ───────────────┴────────┴───────────┴───────────── DHELPID C 30 0 DHELPTEXT M 10 0 ENDDEF DBFDEF MRGORDRS Creating Merged Orders Link File * Structure for MRGORDRS.DBF Last update: 02/08/93 * ───────────────┬────────┬───────────┬───────────── * Field Name │ Type │ Width │ Decimals * ───────────────┴────────┴───────────┴───────────── PARENTORD C 5 0 CHILDORD C 5 0 ENDDEF DBFDEF PROSPECT Creating the Prospect Information Database * Structure for PROSPECT.DBF Last update: 02/08/93 * ───────────────┬────────┬───────────┬───────────── * Field Name │ Type │ Width │ Decimals * ───────────────┴────────┴───────────┴───────────── FNAME1 C 12 0 LNAME1 C 15 0 FNAME2 C 12 0 LNAME2 C 15 0 BUS_NAME C 30 0 PHONE1 C 10 0 PHONE2 C 10 0 STREET C 30 0 BOX_APT C 30 0 CITY C 21 0 STATE C 2 0 ZIP C 5 0 DMNOTES M 10 0 ENDDEF DBFDEF EXPENSE Creating Expenses & Schedule File * Structure for EXPENSE.DBF Last update: 02/08/93 * ───────────────┬────────┬───────────┬───────────── * Field Name │ Type │ Width │ Decimals * ───────────────┴────────┴───────────┴───────────── EXPDATE D 8 0 TRANS N 9 2 LODGING N 9 2 MEALS N 9 2 AUTO N 9 2 MISC N 9 2 OTHER N 9 2 MILES N 4 0 TOTALEXP N 9 2 EXPMEMO M 10 0 SCHMEMO M 10 0 ENDDEF DBFDEF SHOPPING Creating the Shopping List Database * Structure for SHOPPING.DBF Last update: 04/05/95 * ───────────────┬────────┬───────────┬───────────── * Field Name │ Type │ Width │ Decimals * ───────────────┴────────┴───────────┴───────────── QTY N 3 0 ITEMNAME C 20 0 STOCK_NO C 9 0 ENDDEF DBFDEF PHONE Creating Phone Database File * Structure for PHONE.DBF Last update: 02/21/93 * ───────────────┬────────┬───────────┬───────────── * Field Name │ Type │ Width │ Decimals * ───────────────┴────────┴───────────┴───────────── FNBAUD N 6 0 FNPARITY N 2 0 FNWORD N 1 0 FNSTOP N 1 0 FCNAME C 31 0 FCPHONE C 15 0 FMNOTES M 10 0 ENDDEF DBFDEF TAXGRPS Creating Database File for Tax Groups * Structure for TAXGRPS.DBF Last update: 06/22/96 * ───────────────┬────────┬───────────┬───────────── * Field Name │ Type │ Width │ Decimals * ───────────────┴────────┴───────────┴───────────── GROUP_NO C 1 0 TAXRATE N 5 3 COMMENT C 25 0 ENDDEF DBFDEF SHGRPS Creating Database File for Shipping Groups * Structure for SHGRPS.DBF Last update: 06/22/96 * ───────────────┬────────┬───────────┬───────────── * Field Name │ Type │ Width │ Decimals * ───────────────┴────────┴───────────┴───────────── GROUP_NO C 1 0 AMOUNT N 6 2 COMMENT C 25 0 ENDDEF DBFDEF SUBCAT Creating Database File for Subcategories * Structure for SUBCAT.DBF Last update: 07/06/96 * ───────────────┬────────┬───────────┬───────────── * Field Name │ Type │ Width │ Decimals * ───────────────┴────────┴───────────┴───────────── NUM C 2 0 SUBCAT C 40 0 ENDDEF * Construct Index files for DNS databases * Database Index IndexKey Text Display * ─────────────────────────────────────────────────────────────────────────────── NDXDEF NETWORK AMNACCT ACCOUNT Indexing Network file on Account No NDXDEF NETWORK AMNLNAME UPPER(LNAME1) Indexing Network file on Last Name NDXDEF NETWORK AMNLEG LEG_ADANUM Indexing Network file on Leg NDXDEF NETWORK AMNLEVEL LEVEL Indexing Network file on Level NDXDEF AMORDERS AMOACCT ACCOUNT Indexing Orders file on Account No NDXDEF AMORDERS AMOINV INVOICE Indexing Orders file on Invoice NDXDEF AMITEMS AMIINV INVOICE Indexing Items file on Invoice NDXDEF MRGORDRS PARENT PARENTORD Indexing Merge file on Parent NDXDEF MRGORDRS CHILD CHILDORD Indexing Merge file on Child NDXDEF EXPENSE EXPENSE DTOS(EXPDATE) Indexing Expense file on Date NDXDEF PROSPECT PROSPECT UPPER(LNAME1) Indexing Prospect file on Last Name NDXDEF DNSHELP DNSHELP DHELPID Indexing Help file NDXDEF AMINVENT AMISTKNO STOCK_NO Indexing Inventory file on Stock No NDXDEF AMINVENT AMCOMNAM UPPER(COMN_NAME) Indexing Inventory file on Common name NDXDEF AMINVENT AMIDESC UPPER(DESCRIP) Indexing Inventory file on Description NDXDEF AMINVENT AMSECCAT SECTION+CATEGORY Indexing Inventory file on Section NDXDEF AMINVENT AMCATSEC CATEGORY+SECTION Indexing Inventory file on Category NDXDEF SHOPPING SHNAME ITEMNAME Indexing Shopping List file on Item Name ENDFILE