Database Fields (69)

• CODEMAST.CODE
• CODEMAST.DESCRIPTION
• CODEMAST.RECNUM
• CODEMAST.TYPE
• CODETYPE.COMMENT
• CODETYPE.DESCRIPTION
• CODETYPE.RECNUM
• CODETYPE.TYPE
• CUSTOMER.ADDRESS
• CUSTOMER.BALANCE
• CUSTOMER.CITY
• CUSTOMER.COMMENTS
• CUSTOMER.CREDIT_LIMIT
• CUSTOMER.CUSTOMER_NUMBER
• CUSTOMER.EMAIL_ADDRESS
• CUSTOMER.FAX_NUMBER
• CUSTOMER.NAME
• CUSTOMER.PHONE_NUMBER
• CUSTOMER.PURCHASES
• CUSTOMER.RECNUM
• CUSTOMER.STATE
• CUSTOMER.STATUS
• CUSTOMER.ZIP
• INVT.DESCRIPTION
• INVT.ITEM_ID
• INVT.ON_HAND
• INVT.RECNUM
• INVT.UNIT_PRICE
• INVT.VENDOR_ID
• INVT.VENDOR_PART_ID
• ORDERDTL.DETAIL_NUMBER
• ORDERDTL.EXTENDED_PRICE
• ORDERDTL.ITEM_ID
• ORDERDTL.ORDER_NUMBER
• ORDERDTL.PRICE
• ORDERDTL.QTY_ORDERED
• ORDERDTL.RECNUM
• ORDERHEA.CUSTOMER_NUMBER
• ORDERHEA.LAST_DETAIL_NUM
• ORDERHEA.ORDERED_BY
• ORDERHEA.ORDER_DATE
• ORDERHEA.ORDER_NUMBER
• ORDERHEA.ORDER_TOTAL
• ORDERHEA.RECNUM
• ORDERHEA.SALESPERSON_ID
• ORDERHEA.SHIP_VIA
• ORDERHEA.TERMS
• ORDSYS.CUST_NUMBER
• ORDSYS.ORDER_NUMBER
• ORDSYS.RECNUM
• ORDSYS.VENDOR_NUMBER
• SALESP.ID
• SALESP.NAME
• SALESP.RECNUM
• USERS.FULL_NAME
• USERS.LAST_LOGIN
• USERS.LOGINNAME
• USERS.PASSWORD
• USERS.RECNUM
• USERS.RIGHTS
• VENDOR.ADDRESS
• VENDOR.CITY
• VENDOR.FAX_NUMBER
• VENDOR.ID
• VENDOR.NAME
• VENDOR.PHONE_NUMBER
• VENDOR.RECNUM
• VENDOR.STATE
• VENDOR.ZIP