- Created by Rick Eggleston (Unlicensed), last modified on Feb 07, 2020
You are viewing an old version of this page. View the current version.
Compare with Current View Page History
« Previous Version 4 Next »
GL Account Mapping to HOSPITAL_CHARGE_ADMIN
HOSPITAL_CHARGE_ADMIN is the database table that contains all financial transactions, for all hospital accounts. The following table contains the mapping of financial accounts, and account types, to the transaction TYPES in the HOSPITAL_CHARGE_ADMIN table. It also contains information on how the transactions affect account balances by increasing, or decreasing the balance, and whether the transaction is considered to be a credit or debit. HOSPITAL_CHARGE_ADMIN contains foreign key references to many ancillary tables that are also listed.
Mapping
| FINANCIAL REPORT | ACCOUNT GROUP | ACCOUNT TYPE | TYPE CHARGE_ADMIN::ADJUSTMENT | CHARGE ADMIN SIGN | EFFECT ON ACCT | DR / CR | ANCILLARY TABLES | EXAMPLES | ||
|---|---|---|---|---|---|---|---|---|---|---|
| Balance Sheet | Asset | A/R | A_R_PAYMENT | (+) | Decrease | CR | CHARGE_ADMIN ORDERARTRANSACTIONS | |||
| Income Statement | Expense | Discounts | ADJUSTMENT::OPEN_ORDER | (-) | Increase | DR | ADJUSTMENT ORDER_ITEM_MODIFIER ADJUSTMENT_ITEMS | Discounts such as: LDA/RDA, Behavior, Promotional, Instructional, Packages, Clinical Research, Wellness Packages, Employee/Student, Credit Adjustments such as: Administrative, Returned Items, Charged-In-Error. | ||
| Income Statement | Revenue | Price Increase | ADJUSTMENT::INVOICE_PRICE_INCREASE | (+) | Increase | CR | ADJUSTMENT CHARGE_ADMIN | System-generated adjustment that results from the 'Subtotal' of a charge on an order being manually increased by the User. | ||
| Income Statement | Revenue | Price Decrease | ADJUSTMENT::INVOICE_PRICE_DECREASE | (-) | Decrease | DR | ADJUSTMENT CHARGE_ADMIN | System-generated adjustment that results from the 'Subtotal' of a charge on an order being manually decreased by the User. | ||
| Income Statement | Revenue | Interest Charges Assessed | ADJUSTMENT::INTEREST | (+) | Increase | CR | CHARGE_ADMIN ADJUSTMENT | Interest: CHARGE_ADMIN::TYPE = ADJUSTMENT CHARGE_ADMIN +----> ADJUSTMENT +--- ---> ADJ_TYPE::ADJUSTMENT_TYPE = INTEREST | ||
| Income Statement | Revenue | Interest Charges Reversal | ADJUSTMENT::INTEREST | (-) | Decrease | DR | CHARGE_ADMIN ADJUSTMENT | Interest Reversal (unpaid): CHARGE_ADMIN::TYPE = ADJUSTMENT | ||
| Income Statement | Revenue | Interest Charges Reversal | CREDIT_MEMO | (-) | Decrease | DR | CHARGE_ADMIN | Interest Reversal (paid): CHARGE_ADMIN::TYPE = CREDIT_MEMO (if interest that has been paid is reversed, resulting in a credit memo). | ||
| Income Statement | Revenue | Late Fee Reversal | ADJUSTMENT::LATE_FEE | (-) | Decrease | DR | CHARGE_ADMIN ADJUSTMENT | Late Fee Reversal: CHARGE_ADMIN::TYPE = ADJUSTMENT | ||
| Income Statement | Expense | Client Discount Volume Discount | ADJUSTMENT::PRODUCT | (-) | Increase | DR | CHARGE_ADMIN ADJUSTMENT ORDER_ITEM_MODIFIER | System-generated adjustments that are created when a product is added to the order. These adjustments depend on the product setup, and hospital setup. Client Discount Adjustment - resulting from a price set multiplier less than 1.00. Volume Discount Adjustment - resulting from a sufficient dollar volume and associations with a volume discount. Product Debit Adjustment Reversal - resulting from the reversal of a PRODUCT debit adjustment. | ||
| Income Statement | Revenue | Minimum Price Product Markup | ADJUSTMENT::PRODUCT | (+) | Increase | CR | CHARGE_ADMIN ADJUSTMENT ORDER_ITEM_MODIFIER | System-generated adjustments that are created when a product is added to the order. These adjustments depend on the product setup, and hospital setup. Client Markup Adjustment - resulting from a price set multiplier greater than 1.00. Minimum Price Adjustment - resulting from a 'Minimum Price' that is greater than the product pricing basis, plus markup, minus discounts. Product Markup Adjustment - resulting from a 'Markup' multiplier greater than 1.00 Product Credit Adjustment Reversal - resulting from the reversal of a PRODUCT credit adjustment. | ||
| Income Statement | Revenue | Sales of products and services | CHARGE | (+) | Increase | CR | ORDER_ITEM CHARGE_ADMIN | Results from a product (or service) being added to an order. The transaction is added to CHARGE_ADMIN, from ORDER_ITEMS when the order is closed. Amount = product's pricing basis x markup x quantity. | ||
| Balance Sheet | Liability | Client Credit Credit Memo | CREDIT_MEMO | (+) | Increase | CR | CHARGE_ADMIN CREDIT_MEMO | |||
| Balance Sheet | Liability | Application of a client credit or credit memo | CREDIT_MEMO_APPLIED | (-) | Decrease | DR | CHARGE_ADMIN CREDIT_MEMO | |||
| Balance Sheet | Asset | Debit Memo | DEBIT_MEMO | (+) | Increase | DR | CHARGE_ADMIN DEBIT_MEMO | |||
| Income Statement | Revenue | Late Fees Assessed | DEBIT_MEMO::LATE_FEE | (+) | Increase | CR | CHARGE_ADMIN DEBIT_MEMO ADJUSTMENT | Late Fees: CHARGE_ADMIN::TYPE = DEBIT_MEMO CHARGE_ADMIN +---> DEBIT_MEMO +---> ADJUSTMENT +-- ---> ADJ_TYPE::ADJUSTMENT_TYPE = LATE_FEE | ||
| Balance Sheet | Liability | Client Deposit | N/A | N/A | Increase | CR | CLIENT_DEPOSIT | |||
| Balance Sheet | Liability | DEPOSIT_APPLIED | (-) | Decrease | DR | CHARGE_ADMIN CLIENT_DEPOSIT | ||||
| Income Statement | Revenue | Service Fee | MODIFIER | (+) | Increase | CR | ORDER_ITEM_MODIFIER | |||
| Balance Sheet | Liability | Prepaid Sales | PACKAGE | (+) | Increase | CR | CLIENT_PATIENT_PKG CLIENT_PKG_ITEM | |||
| Balance Sheet | Liability | Prepaid Taxes | PREPAID_TAX | (-) | Decrease | DR | PKG_ITEM_TAX_LINK | Created, when a package item is 'used' on and order, to transfer the tax liability account from the client, to the taxing jurisdiction. | ||
| Balance Sheet | Liability | Prepaid Taxes | PREPAID_TAX | (+) | Increase | CR | PKG_ITEM_TAX_LINK | Created for items in a package, when the package is added to the order. | ||
| Balance Sheet | Liability | Prepayments applied to charges and A/R | PREPAID_APPLIED | (-) | Decrease | DR | CLIENT_PATIENT_PKG CLIENT_PKG_ITEM | |||
| Balance Sheet | Asset | Cash, A/R | PREPAID | (-) | Increase | DR | PAYMENT DEBIT_MEMO ORDERAR_TRANS | |||
| Balance Sheet | Liability | Taxes Due | TAX | (+) | Increase | CR | ||||
| TAX_ADJUSTMENT | ||||||||||
| Balance Sheet | Liability | Tax Exemption Credit | TAX_EXEMPTION | (-) | Decrease | DR | CHARGE_ADMIN ADJUSTMENT | |||
| Balance Sheet | Liability | Tax Exemption Reversal (Debit) | TAX_EXEMPTION | (+) | Increase | CR | CHARGE_ADMIN ADJUSTMENT | |||
| ADJUSTMENT::PAYMENT | Corrections to payments that have been posted; such as: Wrong payment type, Returned Check, Incorrect Payment Amount. | |||||||||
| ADJUSTMENT::REFUND | ||||||||||
| ADJUSTMENT::REFUND_REVERSAL | ||||||||||
| ADJUSTMENT::CLIENT_CREDIT | ||||||||||
| ADJUSTMENT::DEPOSIT | ||||||||||
| ADJUSTMENT::CREDIT_MEMO | ||||||||||
| ADJUSTMENT::DEBIT_MEMO | ||||||||||
| ADJUSTMENT::WRITE_OFF | ||||||||||
| ADJUSTMENT::WRITE_OFF_REVERSAL | ||||||||||
| ADJUSTMENT::ASAQ | ||||||||||
| ADJUSTMENT::ASAQ_UNREPORTED | ||||||||||
| ADJUSTMENT::TAX_EXEMPTION_CR | ||||||||||
| ADJUSTMENT::TAX_EXEMPTION_DR | ||||||||||
| ADJUSTMENT::PACKAGE |
VetView Wiki Most recent releases of VetView: Version 4.2.5 Hotfix (Released 10/31/2024)
To see commonly used terms in VetView Hospital, please visit our Hospital Glossary of Terms.
Contents
- No labels