Spreadsheet For Expenses 33281 | Qbdt Data Dictionary

Partial file snippet.
           Transaction Type     Field                       QuickBooks Form - Field Description
           Bank Statement       Bank Account *              (12)
           Bank Statement       Transaction Date            (12)
           Bank Statement       Payee *                     (12)
           Bank Statement       Chk No.                     (12)
           Bank Statement       Account *                   (12)
           Bank Statement       Amount *                    (12)
           Bank Statement       Memo                        (12)
           Bank Statement       Class                       (12)
           Bank Statement       Billable                    (12)
           Bank Statement       Billable Entity             (12)
           Bill                 Vendor *                    Bill - Vendor
           Bill                 Transaction Date            Bill - Date
           Bill                 RefNumber *                 Bill - Ref. No.
           Bill                 Bill Due                    Bill - Bill Due
           Bill                 Terms                       Bill - Terms
           Bill                 Memo                        Bill - Memo
           Bill                 Address Line1               Bill - Address Box
           Bill                 Address Line2               Bill - Address Box
           Bill                 Address Line3               Bill - Address Box
           Bill                 Address Line4               Bill - Address Box
           Bill                 Address City                Bill - Address Box
           Bill                 Address State               Bill - Address Box
           Bill                 Address PostalCode          Bill - Address Box
           Bill                 Address Country             Bill - Address Box
           Bill                 Vendor Acct No              Bill - Account Number
           Bill                 Expenses Account            Bill Expenses Tab - Account
           Bill                 Expenses Amount             Bill Expenses Tab - Amount
           Bill                 Expenses Memo               Bill Expenses Tab - Memo
           Bill                 Expenses Class              Bill Expenses Tab - Class
           Bill                 Expenses Customer           Bill Expenses Tab - Customer:Job
           Bill                 Expenses Billable           Bill Expenses Tab - Billable?
           Bill                 Items Item                  Bill Items Tab - Items
           Bill                 Items Qty                   Bill Items Tab - Qty
           Bill                 Items Description           Bill Items Tab - Description
           Bill                 Items Cost                  Bill Items Tab - Cost
           Bill                 Items Class                 Bill Items Tab - Class
           Bill                 Items Customer              Bill Items Tab - Customer:Job
           Bill                 Items Billable              Bill Items Tab - Billable?
           Bill                 Unit of Measure             Bill Items Tab - U/M
           Bill                 AP Account                  Vendor Information- Account
           Bill                 Currency                    Bill - Amount Due
           Bill                 Exchange Rate               Bill - Exhange Rate
           Bill                 Inventory Site              Bill Items Tab-Site
           Bill                 Inventory Bin               Bill Items Tab-Bin
           Bill                 Serial/Lot Number          Bill Items Tab-Serial/Lot Number
           Bill Payment         Payee *                    Pay Bills - Vendor
           Bill Payment         Transaction Date           Payment Summary - Payment Date
           Bill Payment         Apply to Bill RefNumber    Pay Bills - Ref. No.
           Bill Payment         Payment Method *           Pay Bills - Method
           Bill Payment         Bank Account               Pay Bills - Account
           Bill Payment         Credit Card Account        Pay Bills - Account
           Bill Payment         RefNumber *
           Bill Payment         Amount *                   Pay Bills - Amt. to Pay
           Bill Payment         Memo                       Check - Memo
           Bill Payment         Discount Amount            Pay Bill Discounts and Credits - Amount of Discount
           Bill Payment         Discount Account           Pay Bill Discounts and Credits - Discount Account
           Bill Payment         To Be Printed              Check - To be printed
           Bill Payment         Exchange Rate
           Check                Bank Account *             Vendor Information- Account
           Check                Payee *                    Check - Pay to the Order of
           Check                Transaction Date           Check - Date 
           Check                RefNumber *                Check - No.
           Check                Memo                       Check - Memo
           Check                Address Line1              Check - Address Box
           Check                Address Line2              Check - Address Box
           Check                Address Line3              Check - Address Box
           Check                Address Line4              Check - Address Box
           Check                Address City               Check - Address Box
           Check                Address State              Check - Address Box
           Check                Address PostalCode         Check - Address Box
           Check                Address Country            Check - Address Box
           Check                Vendor Acct No             Check - Account Number
           Check                Expenses Account           Check Expenses Tab - Account
           Check                Expenses Amount            Check Expenses Tab - Amount
           Check                Expenses Memo              Check Expenses Tab - Memo
           Check                Expenses Class             Check Expenses Tab - Class
           Check                Expenses Customer          Check Expenses Tab - Customer:Job
           Check                Expenses Billable          Check Expenses Tab - Billable
           Check                Items Item                 Check Items Tab - Item
           Check                Items Qty                  Check Items Tab - Qty
           Check                Items Description          Check Items Tab - Description 
           Check                Items Cost                 Check Items Tab - Cost
           Check                Items Class                Check Items Tab - Class
           Check                Items Customer             Check Items Tab - Customer:Job
           Check                Unit of Measure            Check Items Tab - U/M
           Check                Items Billable             Check Items Tab - Billable?
           Check                Currency                   Check - Pay to the Order of
           Check                Exchange Rate              Check - Exhange Rate
           Check                Inventory Site             Check Items Tab-Site
            Check                 Inventory Bin                Check Items Tab-Bin
            Check                 Serial/Lot Number            Check Items Tab-Serial/Lot Number
            Credit Card Charge    Credit Card Account *        Credit Card Charges -  Credit Card
            Credit Card Charge    Payee *                      Credit Card Charges - Purchased From
            Credit Card Charge    Transaction Date             Credit Card Charges - Date
            Credit Card Charge    RefNumber *                  Credit Card Charges - Ref No.
            Credit Card Charge    Memo                         Credit Card Charges -  Memo
            Credit Card Charge    Address Line1                Vendor - Name and Address
            Credit Card Charge    Address Line2                Vendor - Name and Address
            Credit Card Charge    Address Line3                Vendor - Name and Address
            Credit Card Charge    Address Line4                Vendor - Name and Address
            Credit Card Charge    Address City                 Vendor - Name and Address
            Credit Card Charge    Address State                Vendor - Name and Address
            Credit Card Charge    Address PostalCode           Vendor - Name and Address
            Credit Card Charge    Address Country              Vendor - Name and Address
            Credit Card Charge    Expenses Account             Credit Card Charges Expenses Tab - Account
            Credit Card Charge    Expenses Amount              Credit Card Charges Expenses Tab - Amount
            Credit Card Charge    Expenses Memo                Credit Card Charges Expenses Tab - Memo
            Credit Card Charge    Expenses Class               Credit Card Charges Expenses Tab - Class
            Credit Card Charge    Expenses Customer            Credit Card Charges Expenses Tab - Customer:Job
            Credit Card Charge    Expenses Billable            Credit Card Charges Expenses Tab - Billable
            Credit Card Charge    Items Item                   Credit Card Charges Items Tab - Item
            Credit Card Charge    Items Qty                    Credit Card Charges Items Tab - Qty
            Credit Card Charge    Items Description            Credit Card Charges Items Tab - Description
            Credit Card Charge    Items Cost                   Credit Card Charges Items Tab - Cost
            Credit Card Charge    Items Class                  Credit Card Charges Items Tab - Class
            Credit Card Charge    Items Customer               Credit Card Charges Items Tab - Customer:Job
            Credit Card Charge    Items Billable               Credit Card Charges Items Tab - Billable?
            Credit Card Charge    Currency                     Credit Card Charges - Amount
            Credit Card Charge    Exchange Rate                Credit Card Charges - Exchange Rate
            Credit Card Charge    Inventory Site               Credit Card Charges Items Tab-Site
            Credit Card Charge    Inventory Bin                Credit Card Charges Items Tab-Bin
            Credit Card Charge    Serial/Lot Number            Check Items Tab-Serial/Lot Number
            Credit Card Credit    Credit Card Account *        Credit Card Refund -  Credit Card
            Credit Card Credit    Payee *                      Credit Card Refund - Purchased From
            Credit Card Credit    Transaction Date             Credit Card Refund - Date
            Credit Card Credit    RefNumber *                  Credit Card Refund- Ref No.
            Credit Card Credit    Memo                         Credit Card Refund -  Memo
            Credit Card Credit    Address Line1                Vendor - Name and Address
            Credit Card Credit    Address Line2                Vendor - Name and Address
            Credit Card Credit    Address Line3                Vendor - Name and Address
            Credit Card Credit    Address Line4                Vendor - Name and Address
            Credit Card Credit    Address City                 Vendor - Name and Address
            Credit Card Credit    Address State                Vendor - Name and Address
            Credit Card Credit    Address PostalCode           Vendor - Name and Address
            Credit Card Credit     Address Country               Vendor - Name and Address
            Credit Card Credit     Expenses Account              Credit Card Credits Expenses Tab - Account
            Credit Card Credit     Expenses Amount               Credit Card Credits Expenses Tab - Amount
            Credit Card Credit     Expenses Memo                 Credit Card Credits Expenses Tab - Memo
            Credit Card Credit     Expenses Class                Credit Card Credits Expenses Tab - Class
            Credit Card Credit     Expenses Customer             Credit Card Credits Expenses Tab - Customer:Job
            Credit Card Credit     Expenses Billable             Credit Card Credits Expenses Tab - Billable
            Credit Card Credit     Items Item                    Credit Card Credits Items Tab - Item
            Credit Card Credit     Items Qty                     Credit Card Credits Items Tab - Qty
            Credit Card Credit     Items Description             Credit Card Credits Items Tab - Description
            Credit Card Credit     Items Cost                    Credit Card Credits Items Tab - Cost
            Credit Card Credit     Items Class                   Credit Card Credits Items Tab - Class
            Credit Card Credit     Items Customer                Credit Card Credits Items Tab - Customer:Job
            Credit Card Credit     Items Billable                Credit Card Credits Items Tab - Billable?
            Credit Card Credit     Currency                      Credit Card Credit - Amount
            Credit Card Credit     Exchange Rate                 Credit card Credit - Exchange Rate
            Credit Card Credit     Inventory Site                Credit Card Credits Items Tab-Site
            Credit Card Credit     Inventory Bin                 Credit Card Credits Items Tab-Bin
            Credit Card Credit     Serial/Lot Number             Credit Card Credits Items Tab-Serial/Lot Number
            Credit Card StatementCredit Card Account *           Credit Card Charges/Credits - Credit Card
            Credit Card StatementTransaction Date                Credit Card Charges/Credits - Date
            Credit Card StatementPayee *                         Credit Card Charges/Credits - Purchased From
            Credit Card StatementRefNumber                       Credit Card Charges/Credits - Ref No.
            Credit Card StatementAccount *                       Credit Card Charges/Credits - Expenses Tab Account
            Credit Card StatementAmount *                        Credit Card Charges/Credits - Expenses Tab Amount
            Credit Card StatementMemo                            Credit Card Charges/Credits - Memo
            Credit Card StatementClass                           Credit Card Charges/Credits - Expenses Tab Class
            Credit Card StatementBillable                        Credit Card Charges/Credits - Expenses Tab Billable
            Credit Card StatementBillable Entity                 Credit Card Charges/Credits - Expenses Tab Customer:Job
            Credit Memo            Customer *                    Credit Memos/Refunds - Customer:Job
            Credit Memo            Transaction Date              Credit Memos/Refunds - Date
            Credit Memo            RefNumber *                   Credit Memos/Refunds - Credit No.
            Credit Memo            PO Number                     Credit Memos/Refunds - P.O. No.
            Credit Memo            Terms                         Credit Memos/Refunds - Terms
            Credit Memo            Class                         Credit Memos/Refunds - Class
            Credit Memo            Template Name                 Credit Memos/Refunds - Template
            Credit Memo            To Be Printed                 Credit Memos/Refunds - To be printed
            Credit Memo            Ship Date                     Credit Memos/Refunds - Ship Date
            Credit Memo            BillTo Line1                  Credit Memos/Refunds - Customer Block
            Credit Memo            BillTo Line2                  Credit Memos/Refunds - Customer Block
            Credit Memo            BillTo Line3                  Credit Memos/Refunds - Customer Block
            Credit Memo            BillTo Line4                  Credit Memos/Refunds - Customer Block
            Credit Memo            BillTo City                   Credit Memos/Refunds - Customer Block
            Credit Memo            BillTo State                  Credit Memos/Refunds - Customer Block
            Credit Memo            BillTo PostalCode             Credit Memos/Refunds - Customer Block
The words contained in this file might help you see if this file matches what you are looking for:

...Transaction type field quickbooks form description bank statement account date payee chk no amount memo class billable entity bill vendor refnumber ref due terms address line box city state postalcode country acct number expenses tab customer customerjob items item qty cost unit of measure um ap information currency exchange rate exhange inventory site tabsite bin tabbin seriallot tabseriallot payment pay bills summary apply to method credit card amt check discount discounts and credits be printed the order charge charges purchased from name c...
Related files

Share

Help

Related files

Share

Share to social media

Help

Login Area
