VIEW : CUSTOMERS DEF.SEQ: DBID:1 FNR: 45 COMMAND: I T L DB NAME F LENG S D REMARK - - - -- -----------bottom------------ - ---- - - ------------------ 1 CU CUSTOMER A 8.0 D G 1 SZ STATEZIP 2 ST STATE A 2.0 D 2 ZI ZIPCODE N 5.0 1 CY COUNTRY A 20.0 D 1 PH TELEPHONE A 12.0 1 NA NAME A 60.0 1 CN CONTACT A 30.0 1 AD STREETADDRESS A 40.0 1 CI CITY A 25.0 1 FO FIRSTORDERDATE N 6.0 P 1 SL SIGNATURE-LIST 2 LI LIMIT N 14.2 2 SI SIGNATURE A 30.0 M 1 BR BRANCH-OFFICE A 25.0 1 SP STATE-ZIPLAST2 A 4.0 1 SB ZIPLAST2 N 2.0
VIEW : EMPLOYEE DEF.SEQ: DBID:1 FNR: 46 COMMAND: I T L DB NAME F LENG S D REMARK - - - -- ------------all-------------- - ---- - - ------------------ 1 ID EMPID N 6.0 D 1 HD HIREDATE N 6.0 1 SA SALARY N 7.2 1 DP DEPT A 6.0 1 JC JOBCODE N 5.0 D 1 SX SEX A 1.0 1 BD BIRTHDATE N 6.0 1 LN LASTNAME A 18.0 D 1 FN FIRSTNAME A 15.0 1 MN MIDDLENAME A 15.0 1 PH PHONE A 4.0
VIEW : INVOICE DEF.SEQ: DBID:1 FNR: 47 COMMAND: I T L DB NAME F LENG S D REMARK - - - -- ------------all-------------- - ---- - - ------------------ 1 IB INVOICENUM N 5.0 D 1 BT BILLEDTO A 8.0 1 AM AMTBILLED N 14.2 D 1 CY COUNTRY A 20.0 D 1 AU AMOUNTINUS N 10.2 1 BB BILLEDBY N 6.0 D 1 BO BILLEDON N 6.0 1 PO PAIDON N 6.0 D 1 CX COMPUTEREXCHANGE F 8.0 F
VIEW : ORDER DEF.SEQ: DBID:1 FNR: 48 COMMAND: I T L DB NAME F LENG S D REMARK - - - -- ------------all-------------- - ---- - - ------------------ 1 ON ORDERNUM N 5.0 D 1 SN STOCKNUM N 4.0 1 LN LENGTH N 4.0 1 FC FABRICCHARGES N 10.2 1 ST SHIPTO A 8.0 D 1 DO DATEORDERED N 6.0 1 DS SHIPPED N 6.0 1 TB TAKENBY N 6.0 1 PB PROCESSEDBY N 6.0 1 SF SPECIALINSTRUCTION A 1.0