BCTOP Table Info

ARGLTRAN.DBF
Field Type Sample Sample Sample
SOURCE Text CM INV CR
DESCRIP Text CREDIT MEMO INVOICE CASH RECEIPT

FOXUSER.DBF
Field Type Sample Sample Sample
TYPE Text PREF2.5 PREF2.5 PREF2.5
ID Text WINDCMD WINDBROW WINDBROW
NAME Text WOTECHF SYSLOG
READONLY Boolean 0 0 0
CKVAL Number 44235 33451 41069
DATA Memo ЪЪ1┤ E * " 129 C#+ 11015 C 4<_K_e_y_:_ _[Enter to select Technician Code...WOTECHFTechcodeWOTECHFTechname hK #C$+C D3:C?FC KRCPPPW^ PRESS ENTER FOR DETAIL, ESC TO QUITSYSLOGCompanySYSLOGDateSYSLOGTimeSYSLOGNameSYSLOGErrsource
UPDATED Date 20000104 20250701 20211223

SYSDBF.DBF
Field Type Sample Sample Sample
FILENAME Text APBUYRF APBUYRF APBUYRF
TYPE Text D F F
FIELD_NAME Text BUYER NAME
FIELD_NEW Text
FIELD_TYPE Text C C
FIELD_LEN Number 2 12
FIELD_NLEN Number
FIELD_DEC Number 0 0
BCTOPONLY Text
DESCRIP Text
CUSTOM Text
SKIP Text
DATE Date 19881125 19881125 19881125
FLAG Text
FOR Text
DESCRIP2 Text BUYER TABLE

SYSPASS.DBF
Field Type Sample Sample Sample
NAME Text DAN JOHN LOI
PASSWORD Text гамеожер йц лои
ARPASS Boolean 1 1 1
APPASS Boolean 1 1 1
SOPASS Boolean 1 1 1
POPASS Boolean 1 1 1
ROPASS Boolean 1 1 1
WOPASS Boolean 1 1 1
PAPASS Boolean 1 1 1
UTPASS Boolean 1 1 1
GLPASS Boolean 1 1 1
TMPASS Boolean 1 1 1
ACTIVE Boolean 0 0 0
LEVEL Number 1 0 0
LDATE Date
LOGINDATE Date
LOGINTIME Text
WARE Text
INTADDR Text
COMP Text
N_ID Text
S_ID Text

SYSPASS9.DBF
Field Type Sample Sample Sample
NAME Text DAN JOHN LOI
PASSWORD Text гамеожер йц лои
ARPASS Boolean 1 1 1
APPASS Boolean 1 1 1
SOPASS Boolean 1 1 1
POPASS Boolean 1 1 1
ROPASS Boolean 1 1 1
WOPASS Boolean 1 1 1
PAPASS Boolean 1 1 1
UTPASS Boolean 1 1 1
GLPASS Boolean 1 1 1
TMPASS Boolean 1 1 1
ACTIVE Boolean 0 0 0
LEVEL Number 1 0 0
LDATE Text
LOGINDATE Text
LOGINTIME Text
WARE Text
INTADDR Text
COMP Text
N_ID Text
S_ID Text

SYSPRINT.DBF
Field Type Sample Sample Sample
PRINTER Text EPSON HP LASER FAX
COMP Text  (s17.1H
CCOMP Text  (s10H
ITALIC Text 4 (s1S
CITALIC Text 5 (s0S
EMP Text E (s3B
CEMP Text F (s0B
UND Text -1 &d0D
CUND Text -0 &d@
ELITE Text M
CELITE Text E
EXP Text  (s5H
CEXP Text  (s10H
DOUBLE Text G
PICA Text P
COLOR Text r1
CCOLOR Text r0
PAGE Text &l64F
TOP Text &l0E

SYSRESET.DBF
Field Type Sample Sample Sample
COMPANY Text 02 02 02
DATE Date 20000107 20000104 20000105
TIME Text 15:27:02 15:00:36 14:33:38
NAME Text BILL ANN TERESA
PRG Text POMANT POMANT SOREPX
ID Text PO82197 PO80437 SO26323
COMPLETE Text S S S
UNQNO Text 17 12 38

SYSTYPE.DBF
Field Type Sample Sample Sample
TYPE Text S T C
MODULE Text PO PO PO
DESCRIP Text STRAIGHT PURCHASE FROM VENDOR TBE (AS IS) PURCHASE CUSTOMER REPAIR
ONORDERFLD Text ONORDER
QTYFLD Text ONHAND TBE
COSTFLD Text COST REQ6
ASKINSP Text Y N Y
ASKSPECIAL Text Y N N
USEDINWO Text N N Y
USEDINPO Text Y Y Y

AP/APBUYR03.DBF
Field Type Sample Sample Sample
BUYER Text 00 JC RS
NAME Text DEFAULT JOHN RITA
DESCRIP Text
PCOM Number 0 0 0
RCOM Number 0 0 0
XCOM Number 0 0 0
WCOM Number 0 0 0
TBECOM Number 0 0 0

AP/APCHCK03.DBF
Field Type Sample Sample Sample
PINVNO Text 32724 00059531 2372
PVENDNO Text 010512 011698 012560
PCOMPANY Text ADVANCED DATA TECHNOLOGY AMERY COMPUTER TECHNOLOGY ATLANTIC MANUFACTURING
PPRIORITY Text 2 2 2
APRPAY Number 140 207.44 1528
AMT1099 Number 0 0 0
REF Text 202449 202348 15330
CHECKNO Number 57238 57239 57240
CHECKDATE Date 19950407 19950407 19950407
TYP1099 Text
CHKACC Text 11200- 11200- 11200-
APSTAT Text Y Y Y
NAME Text

AP/APGLTR03.DBF
Field Type Sample Sample Sample
BATCH Text 000 000 000
PERIOD Text 12 12 12
BEGIN Text 05/04/90 05/04/90 05/04/90
END Text 07/27/92 07/27/92 07/27/92
ACCOUNT Text 01530- 06530- 03130-
AMOUNT Number 3679.56 383590.16 -3823.58

AP/APMAST03.DBF
Field Type Sample Sample Sample
PINVNO Text
PVENDNO Text
PCOMPANY Text
PADDRESS1 Text
PADDRESS2 Text
PCITY Text
PSTATE Text
PZIP Text
PPRIORITY Text
PDISC Number
PDAYS Number
PNET Number
PURDATE Date
DUEDATE Date
DISDATE Date
DISCOUNT Number
PURAMT Number
PAIDAMT Number
DISAMT Number
ADJAMT Number
APRPAY Number
APRDIS Number
APRADJ Number
AMT1099 Number
BUYER Text
CURRENT Text
REF Text
CHECKNO Number
CHECKDATE Date
APACC Text
CHKACC Text
TYP1099 Text
SIGNATURE Number 0
ALTDIS Text
NAME Text
TYPE Text
ACTIONCODE Text
BATCH Text
PDATE Date

AP/APPASS03.DBF
Field Type Sample Sample Sample
NAME Text усер ко йохн
PASSWORD Text усер ко йц
ACCESS Text YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY YYYYYYYYYYYYYYYYYYYYYYYYYYYNNNNNNNNNNNNNNNNNNNNNNNNNNNNN

AP/APRECO03.DBF
Field Type Sample Sample Sample
PVENDNO Text
PCOMPANY Text Balance Forward for 10200-
AMOUNT Number 0
CHECKNO Number 0
CHECKDATE Date
APSTAT Text B
CHKACC Text 10200-
CLEARED Text Y
BANKDATE Date 19950427

AP/APVCOD03.DBF
Field Type Sample Sample Sample
VENDCODE Text 0000
DESCRIP Text DEFAULT

AP/APVEND03.DBF
Field Type Sample Sample Sample
VENDNO Text MAX001 HAR001 SPR001
COMPANY Text MAXTOR HARTFORD COMPUTER SPRINGBOARD TECH. CORP.
CONTACT Text TAMARA NIKKI BINKLEY AL REGINA
TITLE Text SALES X110 ANN COSTA/SALES
ADDRESS1 Text 2191 ZANKER RD. 5550 PRAIRIE STONE PKWY 1 FEDERAL ST.
ADDRESS2 Text 3RD FLOOR ATT: LINCOLN ST GATE
CITY Text SAN JOSE HOFFMAN ESTATES SPRINGFIELD
STATE Text CA IL MA
ZIP Text 95131 60192 01105
PHONE Text 800/262-9867 847/827-5900 800/830-6275
CODE Text
CTYPE Text REP PUR WAR
BUYER Text 00 WB WB
PRIORITY Text 2 2 2
LPAYDATE Date
LRECDATE Date
TAX Number 0 0 0
LIMIT Number 0 0 0
DEBIT Number 0 0 0
BALANCE Number
YTDPUR Number 0 0 564
YTDPAY Number 0 0 0
YTDDIS Number 0 0 0
YTD1099 Number 0 0 0
LPAYAMT Number 0 0 0
APRDIS Number
APRPAY Number 0 0 0
OPENPO Number 0 0
TYP1099 Text
DEFACCT Text - - -
TAXPID Text 0000 000000 04-3182774
PTERMS Text CREDIT CARD CREDIT CARD
PDISC Number 0 0 0
PDAYS Number 0 0 0
PNET Number 1 1 0
SIGNATURE Number 5 2 10
NAME Text JOHN JOHN JOHN
DATE Date 19950904 19950904 19950904
LTDPUR Number
LTDPAY Number
LTDDIS Number
LTD1099 Number
PHONE1 Text 408-432-1700 413-272-4077
FAX Text 408-922-2085 (RMA) 847-827-5924 413-272-4089
RCOMPANY Text
RADDRESS1 Text
RADDRESS2 Text
RCITY Text
RSTATE Text
RZIP Text
CNTRYCODE Text USA USA USA
COUNTRY Text USA USA USA
ACCTNO Text 000
YTDREC Number 0 320
LTDREC Number
INTADDR Text
RCOUNTRY Text
INTADDR2 Text

AP/APVNOT03.DBF
Field Type Sample Sample Sample
VENDNO Text MAI001 DAT004 IBM001
NOTE Memo CONTRA ACCOUNT ACCT# 11585 CUSTOMER # 4718464
NOTEA Memo

AP/APYCHK03.DBF
Field Type Sample Sample Sample
PINVNO Text 155540 2339 2340
PVENDNO Text 011587 012560 012560
PCOMPANY Text AMERICAN BUSINESS CAPITAL ATLANTIC MANUFACTURING ATLANTIC MANUFACTURING
PPRIORITY Text 2 2 2
APRPAY Number 700 261 336
AMT1099 Number 0 0 0
REF Text 16158 15330 15330
CHECKNO Number 57066 57067 57067
CHECKDATE Date 19950324 19950324 19950324
TYP1099 Text
CHKACC Text 11200- 11200- 11200-
APSTAT Text
NAME Text

AP/APYMST03.DBF
Field Type Sample Sample Sample
PINVNO Text
PVENDNO Text
PCOMPANY Text
PADDRESS1 Text
PADDRESS2 Text
PCITY Text
PSTATE Text
PZIP Text
PPRIORITY Text
PDISC Number
PDAYS Number
PNET Number
PURDATE Date
DUEDATE Date
DISDATE Date
DISCOUNT Number
PURAMT Number
PAIDAMT Number
DISAMT Number
ADJAMT Number
APRPAY Number
APRDIS Number
APRADJ Number
AMT1099 Number
BUYER Text
CURRENT Text
REF Text
CHECKNO Number
CHECKDATE Date
APACC Text
CHKACC Text
TYP1099 Text
SIGNATURE Number 0
ALTDIS Text
NAME Text
TYPE Text
ACTIONCODE Text
BATCH Text
PDATE Date

AR/ARADDR03.DBF
Field Type Sample Sample Sample
INVNO Text 7000 7001 7002
BICOMPANY Text INACOM INACOM INTELLIGENT SYSTEMS GROUP
BIADDR1 Text 10810 FARNAM DRIVE 10810 FARNAM DRIVE 6840 HAYVENHURST AVENUE
BIADDR2 Text
BIADDR3 Text OMAHA, NE 68154 OMAHA, NE 68154 VAN NUYS, CA 91410
SHCOMPANY Text LMI RECEIVING WAREHOUSE LMI RECEIVING WAREHOUSE HW ELECTRONICS
SHADDR1 Text 6269 EAST SHELBY DRIVE 6269 EAST SHELBY DRIVE 6855 HAYVENHURST AVENUE
SHADDR2 Text
SHADDR3 Text MEMPHIS, TN 38115 MEMPHIS, TN 38115 VAN NUYS, CA 91406
COUNTRY Text USA USA USA
PHONE Text

AR/ARAREC03.DBF
Field Type Sample Sample Sample
INVNO Text 7001 7002 7003
INVDTE Date 19951025 19951025 19951025
CUSTNO Text INA001 ISG001 COM001
COMPANY Text INACOM INTELLIGENT SYSTEMS GROUP COMPU FIX
SALESMN Text
PONUM Text 1305 44139 1306
REFNO Text
DTEPAID Date
TAX Number 0 0 0
ITOTAL Number 105 44 66
DISCOUNT Number
AMTPAID Number 0 0 0
IBAL Number 105 44 66
PTERMS Text NET 30 NET 30 NET 30
PDISC Number 0 0 0
PDAYS Number 0 0 0
PNET Number 30 30 30
GLAREC Text DEF DEF DEF
PWSHIP Text

AR/ARBCJL03.DBF
Field Type Sample Sample Sample
ITEM Text LA400A2 LA400A2 LA400A2
LOC Text O I O
TDATE Date 20000104 20000104 20000104
TIME Text 14:29:56 14:29:56 14:30:27
OQTY Number 49 7 46
NQTY Number 48 8 47
NAME Text ANN ANN ANN
REFNO Text SO26626
PROGRAM1 Text POINSPUP POINSPUP P0UPBINB
PROGRAM2 Text P0UPBIN1 P0UPBIN1 P0UPBIN1
WARE Text
BIN Text WARE INSP WARE

AR/ARBINL03.DBF
Field Type Sample Sample Sample
BIN Text WARE TBE MRB
DESCRIP Text WAREHOUSE (ON HAND) TO BE EVALUATED MATERIAL REVIEW BOARD
LOC Text O T M
MAXQTY Number
BINTYPE Text
CURQTY Number

AR/ARCASH03.DBF
Field Type Sample Sample Sample
INVNO Text 7385 7385 7494
INVDTE Date 19960208 19960208 19960217
CUSTNO Text MCR001 MCR001 DAT001
COMPANY Text MICRO CENTER MICRO CENTER DATA VISIONS
SALESMN Text 00
PONUM Text Open Credit Ref. Open Credit Ref. Open Credit Ref.
DISCOUNT Number
AMTPAID Number 75 -75 4640
DTEPAID Date 19960208 19960208 19960217
REFNO Text **7533 **7533 **7648
APCODE Text
GLAREC Text DEF DEF DEF
BATCH Text
NAME Text RITA RITA JOHN
CHKACC Text

AR/ARCJNL03.DBF
Field Type Sample Sample Sample
ITEM Text LA400A2 LA400A2 66051
LOC Text O O O
TDATE Date 20000104 20000104 20000104
TIME Text 14:29:56 14:30:28 14:46:03
OCOST Number 496.92 526.74 155.13
NCOST Number 526.74 526.74 145
OQTY Number 10 11 0
NQTY Number 11 7 1
UPCOSTEA Number 825 526.74 145
NAME Text ANN ANN ANN
REFNO Text SO26626
PROGRAM1 Text POINSP SOMENU L0BULK
PROGRAM2 Text POINSPUP SOINV POINSPUP
WARE Text
BONHAND Number 10 11 0
BONHCOST Number 496.916 526.742 155.125
BINSPCT Number 8 8 9
BTBE Number 0 0 0
BTBECOST Number 0 0 0
BMRB Number 0 0 0
BMRBCOST Number 0 0 0
BSCRAP Number 9 9 0
BSCRCOST Number 0 0 0
AONHAND Number 11 7 1
AONHCOST Number 526.742 526.742 145
AINSPCT Number 8 8 9
ATBE Number 0 0 0
ATBECOST Number 0 0 0
AMRB Number 0 0 0
AMRBCOST Number 0 0 0
ASCRAP Number 9 9 0
ASCRCOST Number 0 0 0

AR/ARCLAS03.DBF
Field Type Sample Sample Sample
CLASS Text 0000 MDM HD
DESCRIP Text 5/14X4FOAM MODEM HARD DRIVE
SALESQ Text
SERVER Text

AR/ARCNOT03.DBF
Field Type Sample Sample Sample
CUSTNO Text S&R001/1 LDI001 WAL001
DATE Date
NAME Text
NOTE Memo MUST INCLUDE J2006 FORM BEFORE SHIPPING!!!!!!!!! ALWAYS SHOW CUSTOMER PART NUMBERS ON OUTSIDE OF BOXES-ADVISE IMMEDIATELY ON ANY DISCREPENCIES STEVE MILLER WILL CALL IN WHEN THEY HAVE PRODUCT TO BRING IN FOR REPAIR. USE PO#SCLM04630 AS BLANKET PO. DO NOT PUT -X AFTER PO TO INDICATE RELEASE. MUST USE PO # ONLY!
NOTEA Memo

AR/ARCNTR03.DBF
Field Type Sample Sample Sample
COUNTRY Text U.S.
CURRENCY Text DOLLARS
EXRATE Number 1
CODE Text

AR/ARCOMM03.DBF
Field Type Sample Sample Sample
INVNO Text 7025 7027 7033
COMMENT Text WAY BILL# 369144064 EMERY AIR BILL# 1500490387 WAY BILL#369144053

AR/ARCONT03.DBF
Field Type Sample Sample Sample
CUSTNO Text S&R001/5 ISG001 NOR001
SHIPTO Text
CONTACT Text
TITLE Text
PHONE Text
EXTN Text
MAILCODES Text
NOTES Text
NAME Text TERI LINDA TOM
DATE Date 19960620 19970512 19970701
INTADDR Text

AR/ARCSNT03.DBF
Field Type Sample Sample Sample
CUSTNO Text S&R001 CALT001 S&R151
NOTE1 Text PLEASE PUT PART # ON OUTSIDE OF BOX
NOTE2 Text
NOTE3 Text
NOTE4 Text

AR/ARCUST03.DBF
Field Type Sample Sample Sample
CUSTNO Text DAT001 XSR001 CAL001
COMPANY Text **DO NOT USE** OLD S&R -DO NOT USE!!!!! California State University--Chico
CONTACT Text DO NOT USE SANDRA Skip Frisbee
TITLE Text OWNER PRES
ADDRESS1 Text 134 VIENTO DR. Do not use KNDL, Room 208 Mail Stop 243
ADDRESS2 Text
CITY Text FREMONT HOUSTON Chico
STATE Text CA TX CA
ZIP Text 94536 77024 95929
PHONE Text 510/796-3583 713/663-7020 916/898-4199
TERR Text
INDUST Text 00 00 01
SALESMN Text JC SL 00
SOURCE Text
CODE Text SR
TYPE Text 01
PTERMS Text NET 30 NET 30 NET 30
PDISC Number 0 0 0
PDAYS Number 30 30 0
PNET Number
SVC Number 0 0 0
LDATE Date 20010814 20031007 19951027
LASTPAY Date 19961114
ENTERED Date 19950904 19950904 19951009
LIMIT Number 120000 20000 0
DISC Number 0 0 0
BALANCE Number 4155293.69 1216828.41 95
YTDSLS Number 4174747.44 1202511 95
ONORDER Number 0 716 289
CREDIT Number 19283.78 0 0
LPYMT Number 22381.28 0 0
LSALE Number 85.32 2000 85
TAX Number 0 0 8.25
GLLINK Text DEF
COMMID Text
COMMENT Text DAT001/6 BANCTEC,SILVERSPRINGS CLOSED-SHIP TO DALLAS!!!!!!!! Get tax code.
SIGNATURE Number 8 12 2
LTDSLS Number 0 0 0
NAME Text ANN TERESA ANN
DATE Date 19950904 19950904 19951009
RESALENO Text
FRTACCT Text * 124852637 *
SHIPVIA Text TBA AIRBORNE 2ND UPS GROUND
COUNTRY Text UsA USA
PHONE1 Text
FAX Text 5107965003 713/663-6108
FRTTERM Text PPD COLL PPD
BUYER Text MARINA SANDRA Skip F.
REPLEAD Number 0 0 0
SHCOMPANY Text DATA VISIONS S&R RESOURCES California State University Chico
SHADDR1 Text 134 VIENTO AVE SSKU 118F Mailstop 415
SHADDR2 Text
SHADDR3 Text FREMONT, CA 94536 Chico CA 95929
SHCOUNTRY Text USA USA
CONTRACT Text
CNTRYCODE Text
ORGLINE Text N N N
INTADDR Text
CWARDAY Number

AR/ARGLAC03.DBF
Field Type Sample Sample Sample
GLCODE Text DEF
DESCR Text DEFAULT
ACTIVITY Text N
ARECV Text 11030-
CASHR Text 11010-
INVTS Text 11050-
INVTM Text 11051-
LIABT Text 23210-
COSTS Text 51001-010
COSTM Text 51010-090
COSTA Text 11070-
INCOS Text 41010-010
INCOM Text 41010-090
INCOA Text 41025-010
WOADJ Text 11070-010
WOAST Text 11052-
COSTSHIP Text -
COSTW Text 51010-040
COSTX Text 51010-030
COSTR Text 51010-050
COSTRX Text 51010-060
COSTRW Text 51010-070
COSTNR Text 51010-080
INCOSHIP Text 41020-
INCOX Text 41010-030
INCOR Text 41010-050
INCORX Text 41010-060
INCOW Text 41010-040
INCORW Text 41010-070
INCONR Text 41010-080
CLRACT Text 80000-

AR/ARIMFG03.DBF
Field Type Sample Sample Sample
MFG Text 00000 GDC IBM
DESCRIP Text PLUS HARD CARD GENERAL DATACOM IBM

AR/ARINOT03.DBF
Field Type Sample Sample Sample
ITEM Text PCKG TPDPAL1001 HDDDEC1002
SIGNATURE Number
NOTE Memo instapacking of monitor ARCHIVE EAX4350 EXTERNAL WITH ARCHIVE 4320 BY QUANTUM (LPS 540S)
NOTEA Memo

AR/ARINVO00.DBF
Field Type Sample Sample Sample
INVNO Text 7000 7001 7002
INVDTE Text 10/26/95 10/25/95 10/25/95
CUSTNO Text INA001 INA001 ISG001
COMPANY Text INACOM INACOM INTELLIGENT SYSTEMS GROUP
SALESMN Text SL
PONUM Text Verbal 1305 44139
REFNO Text
TAXRATE Number 0 0 0
TAX Number 0 0 0
ITOTAL Number 95 105 44
IBAL Number 95 105 44
TOSW Text X X X
SHIPVIA Text vered UPS BLUE UPS GROUND
FOB Text CHATSWORTH CHATSWORTH CHATSWORTH
ORDTE Text 10/26/95 10/23/95 10/17/95
ORNUM Text 2049 2049 2034
PTERMS Text NET 30 NET 30 NET 30
GLAREC Text DEF DEF DEF
MAINT Text C
PRTID Text P P P
COMMID Text
BUYER Text
NAME Text JOHN JOHN JOHN
FRTACCT Text
TERR Text
TAXCODE Text 00 00 00
FRTBILL Text

AR/ARINVO03.DBF
Field Type Sample Sample Sample
INVNO Text 7000 7001 7002
INVDTE Date 19951026 19951025 19951025
CUSTNO Text INA001 INA001 ISG001
COMPANY Text INACOM INACOM INTELLIGENT SYSTEMS GROUP
SALESMN Text SL
PONUM Text Verbal 1305 44139
REFNO Text
TAXRATE Number 0 0 0
TAX Number 0 0 0
ITOTAL Number 95 105 44
IBAL Number 95 105 44
TOSW Text X X X
SHIPVIA Text vered UPS BLUE UPS GROUND
FOB Text CHATSWORTH CHATSWORTH CHATSWORTH
ORDTE Date 19951026 19951023 19951017
ORNUM Text 2049 2049 2034
PTERMS Text NET 30 NET 30 NET 30
GLAREC Text DEF DEF DEF
MAINT Text C
PRTID Text P P P
COMMID Text
BUYER Text
NAME Text JOHN JOHN JOHN
FRTACCT Text
TERR Text
TAXCODE Text 00 00 00
FRTBILL Text
PROJECT Text
RETBILL Text
NOTE Memo
INVTIME Text

AR/ARINVT03.DBF
Field Type Sample Sample Sample
ITEM Text SHIP RESTOCK CR-SHIP
CLASS Text 0000 MIS 0000
DESCRIP Text Shipping Charge and Handling RE-STOCK FEE / GOOD MATERIAL RETURN SHIPPING CREDIT
COST Number 0 0 0
ONHAND Number 0 0 0
ONORDER Number 0 0 0
ALOC Number 0 0 0
BO Number 0 0 0
INSPCT Number 0 0 0
MRB Number 0 0 0
TBE Number 0 0 0
PRICE Number 0 0 0
PRICE2 Number 0 0 0
LEVEL2 Number 0 0 0
PRICE3 Number 0 0 0
LEVEL3 Number 0 0 0
PTDQTY Number 0 0 0
YTDQTY Number 0 0 0
PTDSLS Number 0 0 0
YTDSLS Number 0 0 0
UNITMS Text PU EA
DISCRATE Number 0 0 0
CODE Text
SEQ Text 8000 WARE
LDATE Date 20001120 19940824
LASTORDR Date 20010312 19960702
ORDERPT Number 0 0 0
ORDERQTY Number 0 0 0
SUPPLIER Text
VPARTNO Text
LEAD Number 0 0 0
GLLINK Text DEF DEF DEF
DECNUM Number 0 0 0
TAXCODE Text N N N
STKCODE Text N N N
BCNCODE Text N N N
SIGNATURE Number 1 7 0
WEIGHT Number 0 0 0
REQ1 Number 0 0 0
REC1 Number 0 0 0
REQ2 Number 0 0 0
REC2 Number 0 0 0
REQ3 Number 4 0 0
REC3 Number 0 0 0
REQ4 Number 0 0 0
REC4 Number 0 0 0
REQ5 Number 0 0 0
REC5 Number 0
REQ6 Number 0
REC6 Number
NAME Text HO DEMO
DATE Date 19891103 19900609
BIN Text
INSPCODE Text N N N
LTDQTY Number -9 0 0
LTDSLS Number -71 0 0
REPLEAD Number 0 0
PROLEAD Number 0 5
INHOUSE Text N
WOTYPE Text
REPINSCODE Text N
REPLACEPN Text
TBEONORDER Number
TBEALOC Number
TBEBO Number 0
TBEPRICE Number
TBEORDERPT Number
WOSTTN Text
WOTECH Text
MFG Text DAS MIS DAS
UNITS Number 0 0 0
TTYPE Text MIS
BCNCOST Text N
TBESEQ Text TBE TBE
MRBSEQ Text MRB MRB
INSSEQ Text INSP INSP
SCRSEQ Text SCRP
MSER Text N
CHWAR Text Y
PERP Text
PERPCOST Number
PERPQTY Number
POTYPE Text
CONSSEQ Text
SWARDAYS Number 0
RWARDAYS Number 0
INTRXTQ Number
INTRXTC Number
RJT Text

AR/ARITCF03.DBF
Field Type Sample Sample Sample
ITEM Text ST-225N W01 ST-225N
CREF Text W01 ST-225N SX
PRIORITY Number

AR/ARITRN03.DBF
Field Type Sample Sample Sample
ITEM Text VT340GA MISC HDDSUN1001
CLASS Text MON 0000 HDD
REF Text SOREPX . Beg. Inv. Balance
DESCRIP Text DEC VT340-G2 MISC PACKAGING CHARGES SUN 370-1546 1 GIG SCSI 3 1/2"
COST Number 0 15 0
QTY Number 1 20 1
SUPPLIER Text DAT001 .
CODE Text
SEQ Text WARE WARE
TDATE Date 19960105 19960105 19960108
GLASST Text DEF
BCNCODE Text I N
TYPE Text T O O
NAME Text JOHN JOHN JOHN
PURNO Text 2437
LINENO Number 1 0
FROMSEQ Text
WARE Text
TOWARE Text

AR/ARITYP03.DBF
Field Type Sample Sample Sample
TYPE Text 00000 XGA HDD
DESCRIP Text DEFAULT PART TYPE XGA 14" HARD DRIVE

AR/ARIVBN03.DBF
Field Type Sample Sample Sample
ITEM Text FDDAPP1007 FDDAPP1007 HDDSEA1013
BIN Text INSP WARE INSP
LOC Text I O I
QTY Number 2 100 0
LQTY Number
LDATE Date
WARE Text

AR/ARJRNL03.DBF
Field Type Sample Sample Sample
WHAT Text MAINT MAINT MAINT
FROM Text UT)2-D UT)2-D UT)1-G
TO Text 03/13/95
DATE Date 19950310 19950310 19950313
TIME Text 10:27:44 13:41:56 16:44:39
WHO Text KO KO KO
WHERE Text SYSCHDBF SYSCHDBF TMPURGE
DESCRIP Text UPDATE DBF STRUCTURE UPDATE DBF STRUCTURE PURGE E-MAIL

AR/ARPASS03.DBF
Field Type Sample Sample Sample
NAME Text усер ко йохн
PASSWORD Text усер ко йц
ACCESS Text YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY YYYYYYYYYYYYYYYYYYYYYYYYYYYYNNNNNNNNNNNNNNNNNNNNNNNNNNNN YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY

AR/ARSCOM03.DBF
Field Type Sample Sample Sample
COMMID Text AIR WAY EQ
COMMENT Text AIRBILL # WAYBILL # EVALUATE AND QUOTE BEFORE REPAIR.

AR/ARSCRP03.DBF
Field Type Sample Sample Sample
ITEM Text VT340GA MONITC1001 CT220
CLASS Text MON MON MON
REF Text REPX JCB275 REPX JCB274 REPX JCB382
DESCRIP Text DEC VT340-G2 CT220 MONITOR INT CT220 COLOR MONITOR AO336974
COST Number 0 0 0
QTY Number 1 1 1
SUPPLIER Text
CODE Text N N N
SEQ Text SCRP SCRP SCRP
TDATE Date 19960105 19960105 19960105
GLASST Text
BCNCODE Text I I I
TYPE Text S S S
NAME Text JOHN JOHN JOHN
BINLOC Text
PURNO Text
LINENO Number
WARE Text

AR/ARSTAT03.DBF
Field Type Sample Sample Sample
STATE Text AL AK AZ
NAME Text ALABAMA ALASKA ARIZONA
SHIPTAX Text N N N

AR/ARTERM03.DBF
Field Type Sample Sample Sample
CODE Text NET 30 NET 15 NET 5
NDAYS Number 30 15 5
APP Text
EAPP Text

AR/ARTRAN03.DBF
Field Type Sample Sample Sample
INVNO Text 7001 7001 7002
CUSTNO Text INA001 INA001 ISG001
ITEM Text SHIP PCBAPP1114 POWDEL1001
DESCRIP Text Shipping Charge and Handling APPLE LASERWRITER II NT I/O BD DELL POWER SUPPLY
SALESMN Text
TAXRATE Number 0 0 0
COST Number 0 0 0
UNITPR Number 10 95 39
QTYORD Number 1 1 1
QTYSHP Number 1 1 1
INVDTE Date 19951025 19951025 19951025
PONUM Text Our S.O. No. 2049 Our S.O. No. 2049 Our S.O. No. 2034
EXTTAX Number 0 0 0
EXTPRICE Number 10 95 39
TERR Text
DISC Number 0 0 0
STKCODE Text N Y Y
GLSALE Text DEF DEF DEF
GLASST Text DEF DEF DEF
BATCH Text
ORGQTY Number 1 1 1
BO Number 0 0 0
BCNCODE Text N I I
LINENO Number 2 3 1
TYPE Text N R R
MESS Text
RFB Text
CUSTPN Text
UPCHARGE Text N N
ORGLINE Number
WARE Text

AR/ARTRMG03.DBF
Field Type Sample Sample Sample
INVNO Text 7020 7029 7029
MESSAGE Text previously worked on-broken traces previously worked on
PSO Text Y Y Y
PIN Text Y Y Y
LINENO Number 4 6 6

AR/INLIST03.DBF
Field Type Sample Sample Sample
ITEM Text MBDAPP1049 MBDIBM1012 MBDIBM1012
DESCRIP Text 661-0746 MOTHERBOARD PB 160/165/180 IBM VALUE POINT 6384 486/SX IBM VALUE POINT 6384 486/SX
BCN Text SRB031 SRE968 SRE969
BCNCODE Text I I I
SERIALNO Text SRB031 SRE968 SRE969
DATERCVD Date 19951004 19951004 19951004
QUANTITY Number 1 1 1
PURNO Text
VENDNO Text
COSTEA Number
RCODE Text R R R
SCODE Text R R R
STKCODE Text A Y Y
NOTE1 Text
LINENO Number
NAME Text JOHN JOHN JOHN
VREF Text
VPACKSLIP Text
RECVRNUM Number
RQDATE Date 19951004 19951004 19951004
SOLINENO Number 8 7 7
SONO Text 2010 2010 2010
SEQ Text
PRICEA Number 97.5 82.5 82.5
CUSTNO Text S&R001 S&R001 S&R001
TYPE Text R R R
NOTE2 Text
WARRDAYS Number
UPCHARGE Text
USONO Text
USOLINENO Number
WARE Text
SIGNATURE Text

AR/OULIST03.DBF
Field Type Sample Sample Sample
ITEM Text MBDAPP1049 MBDIBM1012 MBDIBM1012
DESCRIP Text 661-0746 MOTHERBOARD PB 160/165/180 IBM VALUE POINT 6384 486/SX IBM VALUE POINT 6384 486/SX
BCN Text SRB031 SRE968 SRE969
BCNCODE Text I I I
SERIALNO Text SRB031 SRE968 SRE969
DATESHPD Date 19951004 19951004 19951004
QUANTITY Number 1 1 1
INVNO Text @WO2 @WO3 @WO3
SONO Text 2010 2010 2010
CUSTNO Text S&R001 S&R001 S&R001
PRICEA Number 0 0 0
RCODE Text Y Y Y
SCODE Text C C C
STKCODE Text Y Y Y
LINENO Number 1 2 1
NAME Text JOHN JOHN JOHN
NOTE1 Text
RQDATE Date 19951004 19951004 19951004
SOLINENO Number 8 7 7
SEQ Text
COSTEA Number
VENDNO Text
TYPE Text ═ ═ ═
NOTE2 Text
WARRDAYS Number
UPCHARGE Text
WARE Text

GL/GLACNT03.DBF
Field Type Sample Sample Sample
GLACNT Text 11000-000 11000- 11100-000
GLDESC Text CASH ON HAND CASH ON HAND CHECKING ACCOUNT #034636
GLSTAT Text I A I
GLTYPE Text A1 A1 A1
GLCATAG Text CC
GLCOLU Text 3 3 5
GLSEQ Text 1 1 1 1 1 1
GLPTDB Number 0 0 0
GLYTDB Number 0 0 0
GLCURB Number 0 0 0
GLATYPE Text M
GLAFIG Number 0
GLAPER Number 0
GLAACT Text
GLMBUD Text 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
GLPBAL Text 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
GLDACT Text
GLDPCT Text
GLINDEX Text 1A1 111000 1A1 111000 1A1 111100
GLCOMP Text 02 02 02
SIGNATURE Number 1
GLRATIO Text

GL/GLLAST03.DBF
Field Type Sample Sample Sample
GLACNT Text 11000-000 11000- 11100-000
GLBUD1 Number
GLBUD2 Number
GLBUD3 Number
GLBUD4 Number
GLBUD5 Number
GLBUD6 Number
GLBUD7 Number
GLBUD8 Number
GLBUD9 Number
GLBUD10 Number
GLBUD11 Number
GLBUD12 Number
GLBUD13 Number
GLBAL1 Number
GLBAL2 Number
GLBAL3 Number
GLBAL4 Number
GLBAL5 Number
GLBAL6 Number
GLBAL7 Number
GLBAL8 Number
GLBAL9 Number
GLBAL10 Number
GLBAL11 Number
GLBAL12 Number
GLBAL13 Number
GLCOMP Text 02 02 02

GL/GLPASS03.DBF
Field Type Sample Sample Sample
NAME Text усер ко йохн
PASSWORD Text усер ко йц
ACCESS Text YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY YYYYYYYYYYYYYYYYYYYYYYNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN

GL/GLTYPE03.DBF
Field Type Sample Sample Sample
GLTYPE Text A1 L1 E1
GLDESC Text ASSETS LIABILITIES EQUITY
GLSEQ Text 1 1 1
GLLOW Text 00001 20000 30000
GLUPP Text 19000 29999 39999

PO/POADDR03.DBF
Field Type Sample Sample Sample
PURNO Text 2002 7103 7106
TOCOMPANY Text CU DIGITAL ICN PRC
TOADDR1 Text 406 N. LINCOLN AVE. 2045-B SO BARRINGTON AVE 9233 ETON AVE.
TOADDR2 Text
TOADDR3 Text URBANA, IL 61801 LOS ANGELES, CA 90025 CHATSWORTH, CA 91311
SHCOMPANY Text US SPRINT JCEnterprises DEC
SHADDR1 Text USE DATA VISION PACKER 21354 Nordhoff St. #110 USE DATA VISION PACKER
SHADDR2 Text Chatsworth, Calif. 91311
SHADDR3 Text
COUNTRY Text

PO/POCOMM03.DBF
Field Type Sample Sample Sample
PURNO Text 7110 7115 7115
COMMENT Text JAN-PLEASE CALL IF YOU HAVE ANY QUESTIONS. MUST SHIP TODAY! JC PLEASE SHIP BY FRIDAY, DEC 22. PLEASE CALL OR FAX WITH S/N AND WAY BILL# THANK YOU! JC

PO/POINUP03.DBF
Field Type Sample Sample Sample
ITEM Text PCBDEC1018 CABCDC1001 MISCDC1001
CLASS Text PCB CAB MIS
REF Text 7173/ 1 7557/ 1 7711/ 1
DESCRIP Text 25 PIN CONN CDC 0081537401 11.5 CABLE 73586002 CDC SPINDLE (300MB)
COST Number 15 50 250
QTY Number 10 1 1
SUPPLIER Text DEC001 BOT001 NOR001
CODE Text P P P
SEQ Text WARE WARE WARE
TDATE Date 19960111 19960326 19960418
GLASST Text
BCNCODE Text
TYPE Text
NAME Text JOHN JOHN JOHN
WARE Text

PO/POMAST03.DBF
Field Type Sample Sample Sample
PURNO Text WO1 WO2 WO3
VENDNO Text
COMPANY Text
TOSW Text
TAXRATE Number
PURAMT Number 0 0 0
RECAMT Number 0 0
PURDATE Date 19951004 19951004 19951004
REQDATE Date 19951004 19951004 19951004
SHIPVIA Text
FOB Text
FREIGHT Text
BUYER Text
PTERMS Text
PDISC Number
PDAYS Number
PNET Number
REMARKS Text
CONFIRM Text
MAINT Text A
PRTID Text P
COMMID Text
CURRENT Text
SIGNATURE Number 2 0 0
NAME Text JOHN JOHN JOHN
LASTRECVR Number 1 2
NOTE Memo
APRVDBY Text
PAIDAMT Number
POSTAMT Number
PACKCODE Text

PO/POPASS03.DBF
Field Type Sample Sample Sample
NAME Text усер ко йохн
PASSWORD Text усер ко йц
ACCESS Text YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYNNNNNNN

PO/PORECP03.DBF
Field Type Sample Sample Sample
PURNO Text WO11 WO12 WO13
VENDNO Text
ITEM Text MBDCPQ1010 6610775 PCBAPP1028
DESCRIP Text COMPAQ LITE 386/25 MAIN BOARD 661-0775 APPLE LWIIG MAIN LOGIC BD 661-0533 VIDEO CD MACII EST HIRES 8
RECQTY Number 1 1 1
INSQTY Number
REJQTY Number
RECDATE Date 19951009 19951009 19951009
COST Number 0 0 0
BCNCODE Text I I I
LINENO Number 1 1 1
TYPE Text C C C
STATUS Text P P P
NAME Text JOHN JOHN JOHN
RECVRNUM Number 1 1 1
PACKSLIP Text FROM WORK ORDER FROM WORK ORDER FROM WORK ORDER
VENDREF Text IN HOUSE IN HOUSE IN HOUSE
CLASS Text MBD MBD PCB
UPCHARGE Text
WARE Text
RECTIME Text

PO/POREJT03.DBF
Field Type Sample Sample Sample
ITEM Text NT5C90NP 84G2269 NTNX51LF
DESCRIP Text NORTEL NT5C90NP MINI SYST 3000/48 IBM 1.44MB FD FE-M5191-01 AR631869 HP D2806A 15" MONITOR
BCN Text 7056820 7057108 7058188
BCNCODE Text I I I
SERIALNO Text NNTM60G1PY1S K1634099411 KR52308658
DATESHPD Date 20000112 20000201 20000223
QUANTITY Number 1 1 1
INVNO Text R10 R11 R12
SONO Text 81942 82381 82651
CUSTNO Text DIV002 BOT001 ABT001
PRICEA Number 0 0 0
RCODE Text F F F
SCODE Text
STKCODE Text Y T Y
LINENO Number 1 2 1
NAME Text ANN JEREMY TERESA
NOTE1 Text SCRAP PER JC 01/12/00 received n/r from vendor
RQDATE Date 20000112 20000128 20000221
SOLINENO Number
SEQ Text
COSTEA Number
VENDNO Text
TYPE Text S R S
NOTE2 Text
WARRDAYS Number

PO/POSCOM03.DBF
Field Type Sample Sample Sample
COMMID Text WARR REP RMA
COMMENT Text WARRANTY REPLACEMENT/REPAIR ON RMA # FOR REPAIR ON RMA# RMA #

PO/POSMSG03.DBF
Field Type Sample Sample Sample
MSGID Text SRG599 RET RET
MESSAGE Text NEED UPCHARGE FOR PART GOOD MATERIAL RETURN ON RMA #
PPO Text Y Y Y

PO/POTOSO03.DBF
Field Type Sample Sample Sample
SONO Text 31851 36370 36269
DATE Date 20010208 20011015 20010925
NAME Text RITA TERESA RITA

PO/POTRAN03.DBF
Field Type Sample Sample Sample
PURNO Text WO1 WO2 WO3
ITEM Text MODAPP1008 MBDAPP1049 MBDIBM1012
DESCRIP Text S&R219048 APPLE TOKEN RING 4/16 BD 661-0746 MOTHERBOARD PB 160/165/180 IBM VALUE POINT 6384 486/SX
VENDNO Text
VPARTNO Text
COST Number 0 0
QTY Number 0 1 1
ORDDATE Date 19951004 19951004 19951004
RECQTY Number 0 1 1
RECDATE Date 19980129 19960122
REQDATE Date 19951004 19951004 19951004
DEPT Text
REQNO Text
DISC Number
TAXRATE Number
EXTTAX Number
EXTCOST Number 0 0
BCNCODE Text I I I
LINENO Number 0 1 1
TYPE Text C ═ ═
NAME Text JOHN TERESA JOHN
MESS Text
CLASS Text MOD MBD MBD
SONO Text
SOLINENO Number
COND Text
INSP Text
ORGCOST Number
RFB Text
WARRDAYS Number
UPCHARGE Text
WARE Text
DUEQTY Number
SIGNATURE Number
SELQTY Number

PO/POTRAN99.DBF
Field Type Sample Sample Sample
PURNO Text WO1 WO2 WO3
ITEM Text MODAPP1008 MBDAPP1049 MBDIBM1012
DESCRIP Text S&R219048 APPLE TOKEN RING 4/16 BD 661-0746 MOTHERBOARD PB 160/165/180 IBM VALUE POINT 6384 486/SX
VENDNO Text
VPARTNO Text
COST Number 0 0
QTY Number 0 1 1
ORDDATE Text 10/04/95 10/04/95 10/04/95
RECQTY Number 0 1 1
RECDATE Text 01/29/98 01/22/96
REQDATE Text 10/04/95 10/04/95 10/04/95
DEPT Text
REQNO Text
DISC Number
TAXRATE Number
EXTTAX Number
EXTCOST Number 0 0
BCNCODE Text I I I
LINENO Number 0 1 1
TYPE Text C ═ ═
NAME Text JOHN TERESA JOHN
MESS Text
CLASS Text MOD MBD MBD
SONO Text
SOLINENO Number
COND Text
INSP Text
ORGCOST Number
RFB Text
WARRDAYS Number
UPCHARGE Text
WARE Text

PO/POTRMG03.DBF
Field Type Sample Sample Sample
PURNO Text WO70 WO74 2002
MESSAGE Text QTY ACTUALLY RECIEVED RECIEVED-NOT ON ORIGINAL ORDER DROP SHIP TO NORTEL CUSTOMER
PPO Text Y Y N
LINENO Number 1 1 1

SO/SOADDR03.DBF
Field Type Sample Sample Sample
SONO Text 2004 2006 2007
BICOMPANY Text S&R RESOURCES S&R RESOURCES S&R RESOURCES
BIADDR1 Text 3400 BISSONNET 3400 BISSONNET 3400 BISSONNET
BIADDR2 Text SUITE 201 SUITE 201 SUITE 201
BIADDR3 Text HOUSTON, TX 77005-2153 HOUSTON, TX 77005-2153 HOUSTON, TX 77005-2153
SHCOMPANY Text BANCTEC SERVICE CORP. BANK ONE BANCTEC SERVICE CORP.
SHADDR1 Text 4435 SPRING VALLEY 3846 N. 27TH AVE. 4435 SPRING VALLEY
SHADDR2 Text
SHADDR3 Text DALLAS, TX 75244 PHOENIX, AZ 85017 DALLAS, TX 75244
COUNTRY Text USA USA USA
PHONE Text

SO/SOCOMM03.DBF
Field Type Sample Sample Sample
SONO Text 2048 2048 2048
COMMENT Text

SO/SOCTYP03.DBF
Field Type Sample Sample Sample
CUSTTYPE Text 0000 01
DESCRIP Text DEFAULT TAXABLE

SO/SODISC03.DBF
Field Type Sample Sample Sample
SONO Text 1212 1212 1212
PONUM Text PONUM PONUM PONUM
LINENO Number 2 2 2
CUSTNO Text STH STH STH
ITEM Text 123 123 123
SERIALNO Text W3R432 WER WER
BCN Text WER WRE RWE
DATERCVD Text 12/31/93 11/01/93 01/03/93
CLASS Text ASD ASD ASD
CHKDATE Text
CHKTIME Text

SO/SOMAST03.DBF
Field Type Sample Sample Sample
SONO Text x 2006 2007
CUSTNO Text S&R001 S&R001 S&R001
COMPANY Text S&R RESOURCES S&R RESOURCES S&R RESOURCES
TOSW Text X X X
SODATE Date 19951002 19951004 19951004
ORDATE Date 19951002 19951004 19951004
SHIPVIA Text UPS GROUND UPS GROUND UPS GROUND
FOB Text CHATSWORTH CHATSWORTH CHATSWORTH
SALESMN Text JC JC JC
BUYER Text SANDRA SANDRA SANDRA
PTERMS Text NET 30 NET 30 NET 30
PDISC Number 0 0 0
PDAYS Number 30 30 30
PNET Number 30 30 30
TAXRATE Number 0 0 0
TPRICE Number 0 0 0
TTAX Number 0 0 0
SPRICE Number 297.5
PONUM Text 7023-B 6659-A 7039-A-A
ORNUM Text None None None
MAINT Text
PRTID Text P
COPYID Text
GLAREC Text DEF DEF DEF
COMMID Text
CURRENT Text
SIGNATURE Number 0 0 0
SHIPSTATUS Text STD STD STD
ENTEREDBY Text JOHN JOHN JOHN
FRTTERM Text PPD PPD PPD
PDATE Date 20240717 19951026
PTIME Text 10:23:19 09:31:51
PNAME Text MELISSA BILL
PRELEASE Number 0 0 0
FRTACCT Text
TAXCODE Text 00 00 00
NOTE Memo
SCUSTNO Text
SOTIME Text
LASTRECVR Number

SO/SOORDQ03.DBF
Field Type Sample Sample Sample
SONO Text 1569 1211 1621
INDATE Date 19930608 19930823 19930915
INNAME Text KO KO KO
SOCHECK Text Y N Y
SONAME Text
SODATE Date
ACCHECK Text Y N Y
ACNAME Text RITA ANN
ACDATE Date 20001120 20010226
SIGNATURE Number 0 0 0

SO/SOPASS03.DBF
Field Type Sample Sample Sample
NAME Text усер ко йохн
PASSWORD Text усер ко йц
ACCESS Text YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY

SO/SOSBCN03.DBF
Field Type Sample Sample Sample
SONO Text 1212 1212 1212
LINENO Number 2 2 2
SERIALNO Text ERWERWEREWR 45454 RFSD
BCN Text EWREWREWR 3434553 FDG
RCVD Text Y
ITEM Text

SO/SOSCOM03.DBF
Field Type Sample Sample Sample
COMMID Text AIR C W
COMMENT Text AIRBILL # AIRBILL # WAYBILL #

SO/SOSHVA03.DBF
Field Type Sample Sample Sample
SHIPVIA Text FED X P1 UPS GROUND UPS RED
DESCRIP Text FEDERAL EXPR. PRIORITY 1 UPS GROUND TRAK UPS NEXT DAY AIR RED LABEL

SO/SOSLMN03.DBF
Field Type Sample Sample Sample
SALESMN Text 00 BM MJ
NAME Text JOHN BOB M MARINA
DESCRIP Text
RCOM Number 0 0 0
RXCOM Number 0 0 0
RWCOM Number 0 0 0
XCOM Number 0 0 0
WCOM Number 0 0 0
SCOM Number 0 0 0
MARKR Number

SO/SOSMSG03.DBF
Field Type Sample Sample Sample
MSGID Text DEC DOA EXCH
MESSAGE Text GOOD MATERIAL RETURN DOA RETURN EXCHANGE UNIT
PSO Text Y Y Y
PIN Text Y Y Y

SO/SOSRCE03.DBF
Field Type Sample Sample Sample
SOURCE Text 00
DESCRIP Text DEFAULT

SO/SOSYSP03.DBF
Field Type Sample Sample Sample
NAME Text ко демо хо
PASSWORD Text ко демо хо
ACCESS Text YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY

SO/SOTERR03.DBF
Field Type Sample Sample Sample
TERRITORY Text 00 01
DESCRIP Text DOMESTIC INTERNATIONAL

SO/SOTRAN03.DBF
Field Type Sample Sample Sample
SONO Text 2004 2004 2004
CUSTNO Text S&R001 S&R001 S&R001
ITEM Text MBDAPP1043 MBDCPQ1001 SHIP
DESCRIP Text * ZERO OUT BY *ANN * ZERO OUT BY *ANN Shipping Charge and Handling
SALESMN Text JC JC JC
CLASS Text MBD MBD 0000
SEQ Text WARE WARE 8000
TAXRATE Number 0 0
COST Number 0 0 0
PRICE Number 112.5 105
QTY Number 0 0 1
ORDATE Date 19951002 19951002 19951002
RQDATE Date 19991206 19991206 19951002
TOTSHIP Number
SHIPQTY Number
SHIPDATE Date
EXTTAX Number 0 0
EXTPRICE Number 0 0
DISC Number 0 0
TERR Text
STKCODE Text Y Y N
MACODE Text
GLSALE Text DEF DEF DEF
GLASST Text DEF DEF DEF
TOSHIP Number 0 0
BO Number 0 0
TYPE Text R R N
BCNCODE Text I I N
LINENO Number 1 2 3
QTYRCVD Number
NAME Text JOHN JOHN JOHN
PDATE Date
PTIME Text
PNAME Text
PRELEASE Number 0 0 0
MESS Text
PURNO Text
POLINENO Number
COND Text
RFB Text
WARRDAYS Number 0 0
CUSTPN Text
PSQTY Number
UPCHARGE Text N N
ORGLINE Number 0 0
PRINTQ Text
WARE Text
RETCODE Text

SO/SOTRMG03.DBF
Field Type Sample Sample Sample
SONO Text 2025 2025 2007
MESSAGE Text QTY ACTUALLY RECIEVED RECIEVED-NOT ON ORIGINAL ORDER previously worked on
PSO Text Y Y Y
PIN Text Y Y Y
LINENO Number 2 7 6

SO/SOTTAX03.DBF
Field Type Sample Sample Sample
CODE Text 00 01 02
RATE Number 0 8.25 7.55
DESCRIP Text DEFAULT LOS ANGELES

SO/SOUSLS03.DBF
Field Type Sample Sample Sample
CODE Text HYON HYON
SALESMN Text 00 00

SO/SOYSHP03.DBF
Field Type Sample Sample Sample
SONO Text 2049 2049 2034
CUSTNO Text INA001 INA001 ISG001
ITEM Text SHIP PCBAPP1114 POWDEL1001
DESCRIP Text Shipping Charge and Handling APPLE LASERWRITER II NT I/O BD DELL POWER SUPPLY
SALESMN Text
CLASS Text 0000 PCB POW
SEQ Text 8000 WARE WARE
TAXRATE Number 0 0 0
COST Number 0 0 0
PRICE Number 10 95 39
QTY Number 1 1 1
SHIPQTY Number 1 1 1
SHIPDATE Date 19951025 19951025 19951025
EXTTAX Number 0 0 0
EXTPRICE Number 10 95 39
DISC Number 0 0 0
TERR Text
GLSALE Text DEF DEF DEF
GLASST Text DEF DEF DEF
ORGQTY Number 1 1 1
BO Number 0 0 0
INVN Text 7001 7001 7002
BCNCODE Text N I I
LINENO Number 2 3 1
TYPE Text N R R
NAME Text JOHN JOHN JOHN
PONUM Text 1305 1305 44139
RFB Text
WARRDAYS Number 0 0 0
CUSTPN Text
UPCHARGE Text N N
ORGLINE Number
WARE Text

WO/WOFAIL03.DBF
Field Type Sample Sample Sample
DESCRIP Text UNIT DAMAGED BEYOND REPAIR TOO MANY BROKEN TRACES BOARD BURNT BEYOND REPAIR
RNO Number 0 1 2
CODE Text NR1 NR2 NR3
ALTCODE Text

WO/WOINVT03.DBF
Field Type Sample Sample Sample
ITEM Text MBDAPP1049 MBDAPP1002 MODAPP1006
STATIONID Text APPL APPL APPL
LTDRQTY Number
LTDCQTY Number
LTDPQTY Number
YTDRQTY Number
YTDCQTY Number 33 15 7
YTDPQTY Number
RQTY Number
CQTY Number 33 15 7
PQTY Number
RAVGTIME Number
CAVGTIME Number 0.01 0.01 0
PAVGTIME Number

WO/WOITRN03.DBF
Field Type Sample Sample Sample
ITEM Text NT4X00AG 6611022 HDDMAX1005
CLASS Text HDD MBD HDD
BCN Text JCA978
DESCRIP Text DDU ASSEMBLY, NORTEL 661-1022 LOGIC BOARD POWER MAC 6100 MAXTOR XT4380E 348MB
COST Number 0 0 0
QTY Number 3 1 -1
FROM Text T O O
TO Text
PURNO Text WO934 WO1673 WO2333
TDATE Date 19960221 19960411 19960523
GLASST Text DEF
BCNCODE Text I I N
TYPE Text R O C
NAME Text LOI JOHN DAN
STRIPBCN Text JCA978
LINENO Number 1 1 1
FROMSEQ Text WARE
WARE Text
REQNO Text
STRIPITEM Text

WO/WOMAST03.DBF
Field Type Sample Sample Sample
PURNO Text WO509 WO1582 WO1527
WONO Text 5 6 7
BCN Text JCBJCB1 SRG728 SRG661
ITEM Text PCBNOR1001 MBDAPP1049 MBDAPP1002
SONO Text 2512 3525 3553
TYPE Text C C C
CUSTNO Text DAT001 S&R001 S&R001
STATUS Text C C C
QTY Number 1 1 1
BCNCODE Text I I I
RQDATE Date 19960108 19960408 19960404
ORDATE Date 19960108 19960328 19960401
DATEIN Date 19960108 19960408 19960404
SHIPDATE Date 19960217 19960409 19960412
SERIALNO Text MD251462 2278856RM
LINENO Number 1 1 1
SCODE Text G G G
STATIONID Text IBM APPL APPL
TOTTIME Number 0.02 0
TOTCOST Number 0 0 0
TECHNAME Text LOI LOI LOI
SIGNATURE Number 0 0 0
RFB Text
TOTPRICE Number 0 0 0
SYMPCODE Text
NOTEA Memo
NSYMPCODE Text

WO/WOPASS03.DBF
Field Type Sample Sample Sample
NAME Text усер ко йохн
PASSWORD Text усер ко йц
ACCESS Text YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYNNNNNNN

WO/WORPCD03.DBF
Field Type Sample Sample Sample
DESCRIP Text REPLACED CRT FIXED BAD SOLDER REPLACED BAD I.C.
RNO Number 0 1 2
CODE Text FIX1 FIX2 FIX3
ALTCODE Text

WO/WOSTTN03.DBF
Field Type Sample Sample Sample
STATIONID Text APPL IBM COMP
LOCATION Text APPLE IBM COMPAQ
DESCRIP Text APPLE BOARD REPAIR IBM BOARD REPAIR COMPAQ BOARD REPAIR
PTDTIME Number 0 0 0
PTDPCOST Number 0 0 0
PTDLCOST Number 0 0 0
PTDPRICE Number 0 0 0
PTDQTY Number 0 0 0
YTDTIME Number 0 0 0
YTDPCOST Number 0 0 0
YTDLCOST Number 0 0 0
YTDPRICE Number 0 0 0
YTDQTY Number 0 0 0
LTDTIME Number 0 0 0
LTDPCOST Number 0 0 0
LTDLCOST Number 0 0 0
LTDPRICE Number 0 0 0
LTDQTY Number 0 0 0
UPDCODE Text L L L
MAXHRS Number 0 0 0
COSTHR Number 0 0 0

WO/WOTECH03.DBF
Field Type Sample Sample Sample
TECHCODE Text LT DJ AO
TECHNAME Text LOI DAN ALBERTO
DESCRIP Text ALBERTO OCHOA
LEVEL Text 101 1
PTDHRWORK Number 18258.49 1444.37 0
YTDHRWORK Number 6760.62 0.5 0
LTDHRWORK Number 0 0 0
PTDPRICE Number 0 0 0
YTDPRICE Number 0 0 0
LTDPRICE Number 0 0 0
LBRPRICE Number 0 0 0
STARTDATE Date 19951001 19960101 19960201
WAGE Number 0 0 0

WO/WOTOSO03.DBF
Field Type Sample Sample Sample
SONO Text 2012 2014
DATE Date 19951009 19951009
NAME Text JOHN JOHN

WO/WOTRAN03.DBF
Field Type Sample Sample Sample
WONO Text 5 5 6
BCN Text JCBJCB1 JCBJCB1 SRG728
ITEM Text PCBNOR1001 PCBNOR1001 MBDAPP1049
TECHCODE Text LT LT LT
STATIONID Text IBM IBM APPL
TIMEIN Text 09:28:52 15:07:46 12:07:27
TIMEOUT Text 09:28:52 15:07:46 05:27:07
DATEIN Date 19960108 19960217 19960409
DATEOUT Date 19960108 19960217 19960410
LTOUT Text 04/10/9605:26:51
TOTTIME Number 0.02
STATUS Text C C C
FLAG Text H G W
UPDCODE Text L
TYPE Text C C C
REPCODE Text
NOTE Memo NO PROBLEM FOUND.
FAILCODE Text
DIAGCODE Text
TRNUM Number
NDIAGCODE Text
NFAILCODE Text
NREPCODE Text

WO/WOTRPT03.DBF
Field Type Sample Sample Sample
WONO Text 846 840 851
PITEM Text HDDMAX1005 HDDMAX1005 HDDMAX1005
QTY Number 1 1 1
COST Number 85 85 85
BCN Text JCE891 JCE890 JCE892
TECHCODE Text LT LT LT
STATIONID Text LAB LAB LAB
STATUS Text C C C
TRNUM Number 1631 1621 1664
IDATE Date 19960523 19960523 19960523
PRICE Number 0 0 0

[an error occurred while processing this directive] BCTOP Table Info

BCTOP Table Info

[!! #define xbdatatypes #xbdatatypes #define samples "3" /* #foreach table ( "AR/ARINVO03" "AR/ARTRAN03" "AR/OULIST03" "WO/WOMAST03" "WO/WOTRAN03" "SO/SOYSHP03" "SO/SOMAST03" "SO/SOTRAN03" ) */ #define _unused_tables ( "FONTS.DBF" "P_CODES.DBF" "SYSDATA.DBF" "SYSQUE.DBF" "RO/ROPASS03.DBF" ) #define _empty_tables ( "FOXHELP.DBF" "SYSHELP.DBF" "SYSISOB.DBF" "SYSISO.DBF" "TM/TMBCAR03.DBF" "TM/TMCONT03.DBF" "TM/TMCUST03.DBF" "TM/TMGRID03.DBF" "TM/TMGUSR03.DBF" "TM/TMKEYR03.DBF" "TM/TMKEYS03.DBF" "TM/TMLETR03.DBF" "TM/TMMAIL03.DBF" "TM/TMNFAX03.DBF" "TM/TMPASS03.DBF" "TM/TMTCAR03.DBF" "TM/TMUSER03.DBF" "SYSLOG.DBF" "AR100003.DBF" "AP/APDIST03.DBF" "AP/APGLLK03.DBF" "AP/APSHIP03.DBF" "AP/APVCLS03" "AP/APVOID03.DBF" "AP/APVCLS03.DBF" "AP/APYDST03.DBF" "AR/AR100003.DBF" "AR/ARBJNL03.DBF" "AR/ARCNIT03.DBF" "AR/ARCNMN03.DBF" "AR/ARECOU03.DBF" "AR/AREXPL03.DBF" "AR/ARGLLK03.DBF" "AR/ARIMAG03.DBF" "AR/ARPADD03.DBF" "AR/ARPINV03.DBF" "AR/ARPTRA03.DBF" "AR/ARSINV03.DBF" "AR/ARSMSG03.DBF" "AR/ARTRGL03.DBF" "AR/ARUCLS03.DBF" "AR/ARUGRP03.DBF" "AR/ARWARQ03.DBF" "AR/ARYADR03.DBF" "AR/ARYARE03.DBF" "AR/ARYBOR03.DBF" "AR/ARYCOM03.DBF" "AR/ARYCSH03.DBF" "AR/ARYINV03.DBF" "AR/ARYITR03.DBF" "AR/ARYTMG03.DBF" "AR/ARYTRN03.DBF" "AR/INYLST03.DBF" "AR/OUPLIS03.DBF" "AR/OUYLST03.DBF" "GL/GLENTR03.DBF" "GL/GLFIND03.DBF" "GL/GLFINM03.DBF" "GL/GLRECR03.DBF" "GL/GLYENT03.DBF" "PO/POCONC03.DBF" "PO/POCONS03.DBF" "PO/POPRCH03.DBF" "PO/POPROJ03.DBF" "PO/PORCVQ03.DBF" "PO/POYADR03.DBF" "PO/POYCOM03.DBF" "PO/POYIUP03.DBF" "PO/POYMST03.DBF" "PO/POYRCP03.DBF" "PO/POYTMG03.DBF" "PO/POYTRN03.DBF" "RO/ROCUHI03.DBF" "RO/ROHIST03.DBF" "RO/ROPNSA03.DBF" "SO/SOBMAS03.DBF" "SO/SOBTRA03.DBF" "SO/SOMAIL03.DBF" "SO/SOQUOT03.DBF" "SO/SOSGRP03.DBF" "SO/SOYADR03.DBF" "SO/SOYBMS03.DBF" "SO/SOYBTR03.DBF" "SO/SOYCOM03.DBF" "SO/SOYMST03.DBF" "SO/SOYTMG03.DBF" "SO/SOYTRN03.DBF" "SO/SOYYSH03.DBF" "WO/WOASMB03.DBF" "WO/WOASTR03.DBF" "WO/WOBULK03.DBF" "WO/WODIAG03.DBF" "WO/WOSMSG03.DBF" "WO/WOSTRP03.DBF" "WO/WOSYMP03.DBF" "WO/WOYMST03.DBF" "WO/WOYTPT03.DBF" "WO/WOYTRN03.DBF" ) #define tables ( "ARGLTRAN.DBF" "FOXUSER.DBF" "SYSDBF.DBF" "SYSPASS.DBF" "SYSPASS9.DBF" "SYSPRINT.DBF" "SYSRESET.DBF" "SYSTYPE.DBF" "AP/APBUYR03.DBF" "AP/APCHCK03.DBF" "AP/APGLTR03.DBF" "AP/APMAST03.DBF" "AP/APPASS03.DBF" "AP/APRECO03.DBF" "AP/APVCOD03.DBF" "AP/APVEND03.DBF" "AP/APVNOT03.DBF" "AP/APYCHK03.DBF" "AP/APYMST03.DBF" "AR/ARADDR03.DBF" "AR/ARAREC03.DBF" "AR/ARBCJL03.DBF" "AR/ARBINL03.DBF" "AR/ARCASH03.DBF" "AR/ARCJNL03.DBF" "AR/ARCLAS03.DBF" "AR/ARCNOT03.DBF" "AR/ARCNTR03.DBF" "AR/ARCOMM03.DBF" "AR/ARCONT03.DBF" "AR/ARCSNT03.DBF" "AR/ARCUST03.DBF" "AR/ARGLAC03.DBF" "AR/ARIMFG03.DBF" "AR/ARINOT03.DBF" "AR/ARINVO00.DBF" "AR/ARINVO03.DBF" "AR/ARINVT03.DBF" "AR/ARITCF03.DBF" "AR/ARITRN03.DBF" "AR/ARITYP03.DBF" "AR/ARIVBN03.DBF" "AR/ARJRNL03.DBF" "AR/ARPASS03.DBF" "AR/ARSCOM03.DBF" "AR/ARSCRP03.DBF" "AR/ARSTAT03.DBF" "AR/ARTERM03.DBF" "AR/ARTRAN03.DBF" "AR/ARTRMG03.DBF" "AR/INLIST03.DBF" "AR/OULIST03.DBF" "GL/GLACNT03.DBF" "GL/GLLAST03.DBF" "GL/GLPASS03.DBF" "GL/GLTYPE03.DBF" "PO/POADDR03.DBF" "PO/POCOMM03.DBF" "PO/POINUP03.DBF" "PO/POMAST03.DBF" "PO/POPASS03.DBF" "PO/PORECP03.DBF" "PO/POREJT03.DBF" "PO/POSCOM03.DBF" "PO/POSMSG03.DBF" "PO/POTOSO03.DBF" "PO/POTRAN03.DBF" "PO/POTRAN99.DBF" "PO/POTRMG03.DBF" "SO/SOADDR03.DBF" "SO/SOCOMM03.DBF" "SO/SOCTYP03.DBF" "SO/SODISC03.DBF" "SO/SOMAST03.DBF" "SO/SOORDQ03.DBF" "SO/SOPASS03.DBF" "SO/SOSBCN03.DBF" "SO/SOSCOM03.DBF" "SO/SOSHVA03.DBF" "SO/SOSLMN03.DBF" "SO/SOSMSG03.DBF" "SO/SOSRCE03.DBF" "SO/SOSYSP03.DBF" "SO/SOTERR03.DBF" "SO/SOTRAN03.DBF" "SO/SOTRMG03.DBF" "SO/SOTTAX03.DBF" "SO/SOUSLS03.DBF" "SO/SOYSHP03.DBF" "WO/WOFAIL03.DBF" "WO/WOINVT03.DBF" "WO/WOITRN03.DBF" "WO/WOMAST03.DBF" "WO/WOPASS03.DBF" "WO/WORPCD03.DBF" "WO/WOSTTN03.DBF" "WO/WOTECH03.DBF" "WO/WOTOSO03.DBF" "WO/WOTRAN03.DBF" "WO/WOTRPT03.DBF" ) #define dbh #xbconnect "/volume1/Library/Bctop/dist" #foreach table tables !!> [!! #define sth #xbprepare dbh { "SELECT * from " table } #undefine samplerecords #define sampnum "0" #while #sizeof #assign record #trim #xbfetchrow sth { #inc sampnum #if #gt sampnum samples #break #push samplerecords record } !!] [!!#repeat samples!!> [!! #define count 0 #while #ne count fields`size { #params < types fields > ( #xbfieldtypes sth, #xbfieldnames sth ) #define field fields:[count] #define type types:[count] !!> [!! #repeat samples !!> [!! #xbfinish sth !!]

[!!table!!]
Field TypeSample
[!!field!!] [!!#ifelse #defined xbdatatypes.[type] { xbdatatypes.[type] } { "Unknown Type(" type ")" } !!] [!! samplerecords:[:repeat]:[count] !!]