Apple Mac2014 - Page 254

QuickBooks for Mac 2014 User’s Guide 244
Ship Via list (SHIPMETH)
Import and export files can contain the list of shipping methods you use in QuickBooks. The keyword for the Ship
Via list is SHIPMETH.
NAME
(Required) The name of the shipping method.
TIMESTAMP
(Export files only) A unique number that identifies the company file from which you
exported the Ship Via list.
REFNUM
(Export files only) A unique number that identifies an entry in the list.
Transactions (TRNS and SPL)
Import files can contain information about transactions in a QuickBooks company file. The keyword for a
transaction is TRNS; the keyword for each distribution line is SPL.
The distribution lines appear immediately below the transaction. The keyword ENDTRANS appears after the last
distribution line. In an import file, the first column for a transaction that has three distribution lines would look like
this:
TRNS
SPL
SPL
SPL
ENDTRNS
TRNSID
A unique number that identifies the transaction. QuickBooks generates this
number when you create an export file.
TIMESTAMP
(Export files only) A second unique number that works with TRNSID to identify the
transaction. QuickBooks generates this number when you create the export file.
TRNSTYPE
(Required) A keyword that identifies the type of transaction. These keywords can
appear in the TRNSTYPE field:
BILL—Bills from vendors
BILLCCARD—Bill payments you make by credit card
BILLPMT—Bills payments you make by check
BILL REFUND—Refunds from a vendor
CASH REFUND—Cash refunds you give to customers
CASH SALE—Sales receipts
CCARD REFUND—Refunds you receive on credit card charges
CHECK—Checks
CREDIT CARD—Charges you make on a credit card
CREDIT MEMO—Credit you give to customers for merchandise they return
DEPOSIT—Bank or money market deposits
GENERAL JOURNAL—General journal transactions
INVOICE—Invoices