Page Comparison

Panel

borderColor	blue
bgColor	#B3D4FF
borderWidth	1
borderStyle	solid

GL Account Mapping to HOSPITAL_CHARGE_ADMIN

Excerpt

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 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.

Info
Refer to the 'Inventory and Accounting Definitions' page for the definition of terms found in the table below.

Income StatementRevenueMinimum Price
Product MarkupADJUSTMENT::PRODUCT(+)IncreaseCRCHARGE_ADMIN
ADJUSTMENT
ORDER_ITEM_MODIFIERSystem-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 StatementRevenueSales of products and servicesCHARGE(+)IncreaseCRORDER_ITEM
CHARGE_ADMINResults 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 SheetLiabilityClient Credit
Credit MemoCREDIT

Panel

borderColor	blue
bgColor	#B3D4FF
borderWidth	1
borderStyle	solid

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

Contra Revenue	Sales Discounts, Returns, and Allowances	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	Contra 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	Contra Revenue	Interest Charges Reversal	ADJUSTMENT::INTEREST	(-)	Decrease	DR

CHARGE_ADMIN

ADJUSTMENT

Interest Reversal (unpaid):
CHARGE_ADMIN::TYPE = ADJUSTMENT

Income Statement

Balance Sheet

Revenue

Liability

Interest Charges Reversal

CREDIT_MEMO

(-)

Decrease

DR

CHARGE

CREDIT_

ADMIN

MEMO	Interest Reversal (paid): CHARGE_ADMIN::TYPE = CREDIT_MEMO (if interest that has been paid is reversed, resulting in a credit memo).
Income Statement	Contra Revenue	Late Fee Reversal	ADJUSTMENT::LATE_FEE	(-)	Decrease	DR

CHARGE_ADMIN

ADJUSTMENT	Late Fee Reversal: CHARGE_ADMIN::TYPE = ADJUSTMENT
Income Statement

Expense

Contra Revenue

Client Discount

Volume Discount

Product Debit Reversal

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

Client Markup

Minimum Price

Product Markup

Product Credit Reversal

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

ADJUSTMENT

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

Client Credits result from an adjustment made to charge, or debit memo, that has been paid.

Credit Memos are posted via the Accounting screen → Credit/Debit Memo tab.

Balance Sheet

Liability

Client

DepositN/AN/AIncreaseCRCLIENT_DEPOSITBalance SheetLiabilityDEPOSIT

Credit Applied

Credit Memo Applied

CREDIT_MEMO_APPLIED

(-)

Decrease

DR

CHARGE_ADMIN
CLIENT_DEPOSITIncome StatementRevenueADJUSTMENT::REFUNDADJUSTMENT::REFUND_REVERSALADJUSTMENT::CLIENT_

Service FeeMODIFIER(+)IncreaseCRORDER_ITEM_MODIFIERBalance SheetLiabilityPrepaid SalesPACKAGE(+)IncreaseCRCLIENT_PATIENT_PKG
CLIENT_PKG_ITEMBalance SheetLiabilityPrepayments applied to charges and A/RPREPAID_APPLIED(-)DecreaseDRCLIENT_PATIENT_PKG
CLIENT_PKG_ITEMBalance SheetAssetCash, A/RPREPAID(-)IncreaseDRPAYMENT
DEBIT_MEMO
ORDERAR_TRANSBalance SheetLiabilityTaxes DueTAX(+)IncreaseCRTAX_ADJUSTMENTBalance SheetLiabilityTax Exemption CreditTAX_EXEMPTION(-)DecreaseDRCHARGE_ADMIN
ADJUSTMENTBalance SheetLiabilityTax Exemption Reversal (Debit)TAX_EXEMPTION(+)IncreaseCRCHARGE_ADMIN
ADJUSTMENTADJUSTMENT::PAYMENTCorrections to payments that have been posted; such as: Wrong payment type, Returned Check, Incorrect Payment Amount.

CREDIT

ADJUSTMENT::DEPOSITADJUSTMENT::CREDIT

_MEMO

ADJUSTMENT::

DEBIT_MEMO

ADJUSTMENT::WRITE_OFFADJUSTMENT::WRITE_OFF_REVERSALADJUSTMENT::ASAQADJUSTMENT::ASAQ_UNREPORTEDADJUSTMENT::TAX_EXEMPTION_CRADJUSTMENT::TAX_EXEMPTION_DRADJUSTMENT::PACKAGE

FINANCIAL
REPORTACCOUNT
GROUPACCOUNT TYPETYPE
CHARGE_ADMIN::ADJUSTMENTCHARGE
ADMIN
SIGNEFFECT
ON ACCTDR / CRANCILLARY TABLESEXAMPLESBalance SheetAssetA/RA_R_PAYMENT(+)DecreaseCRCHARGE_ADMIN
ORDERARTRANSACTIONSIncome StatementExpenseDiscountsADJUSTMENT::OPEN_ORDER(-)IncreaseDRADJUSTMENT
ORDER_ITEM_MODIFIER
ADJUSTMENT_ITEMSDiscounts 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 StatementRevenuePrice IncreaseADJUSTMENT::INVOICE_PRICE_INCREASE(+)IncreaseCRADJUSTMENT
CHARGE_ADMINSystem-generated adjustment that results from the 'Subtotal' of a charge on an order being manually increased by the User.Income StatementRevenuePrice DecreaseADJUSTMENT::INVOICE_PRICE_DECREASE(-)DecreaseDRADJUSTMENT
CHARGE_ADMINSystem-generated adjustment that results from the 'Subtotal' of a charge on an order being manually decreased by the User.Income StatementRevenueInterest Charges AssessedADJUSTMENT::INTEREST(+)IncreaseCRCHARGE_ADMIN
ADJUSTMENTInterest:
CHARGE_ADMIN::TYPE = ADJUSTMENT
CHARGE_ADMIN +----> ADJUSTMENT +---
---> ADJ_TYPE::ADJUSTMENT_TYPE = INTERESTIncome StatementRevenueInterest Charges ReversalADJUSTMENT::INTEREST(-)DecreaseDRCHARGE_ADMIN
ADJUSTMENTInterest Reversal (unpaid):
CHARGE_ADMIN::TYPE = ADJUSTMENTIncome StatementRevenueInterest Charges ReversalCREDIT_MEMO(-)DecreaseDRCHARGE_ADMINInterest Reversal (paid):
CHARGE_ADMIN::TYPE = CREDIT_MEMO
(if interest that has been paid is reversed, resulting in a credit memo).Income StatementRevenueLate Fee ReversalADJUSTMENT::LATE_FEE(-)DecreaseDRCHARGE_ADMIN
ADJUSTMENTLate Fee Reversal:
CHARGE_ADMIN::TYPE = ADJUSTMENTIncome StatementExpenseClient Discount
Volume DiscountADJUSTMENT::PRODUCT(-)IncreaseDRCHARGE_ADMIN
ADJUSTMENT
ORDER_ITEM_MODIFIERSystem-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.

ORDERARTRANSACTIONS	Client Credits, and Credit Memos, can be applied to order balances, and debit memos, via the Cashier screen.
Income Statement	Revenue	Debit Memo	DEBIT_MEMO	(+)	Increase

CR

DR

CHARGE

DEBIT_

ADMIN
CREDIT_MEMOBalance SheetLiabilityApplication of a client credit or credit memoCREDIT_MEMO_APPLIED(-)DecreaseDRCHARGE_ADMIN
CREDIT_MEMOBalance SheetAssetDebit MemoDEBIT_MEMO(+)IncreaseDRCHARGE_ADMIN
DEBIT_MEMO

MEMO	Debit Memos are posted via the Accounting screen - Credit/Debit Memo tab.
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

Increase

CR

CLIENT_DEPOSIT

PAYMENT

Client Deposits are posted via the Cashier screen.

Balance Sheet

Liability

Deposits Applied

DEPOSIT_APPLIED

(-)

Decrease

DR

CHARGE

CLIENT_

ADMIN

DEPOSIT

CLIENT_DEPOSIT

DEBIT_MEMO

ORDERARTRANSACTIONS

Client Deposits can be applied to order balances, or debit memos, via the Cashier screen.

Income Statement

Revenue

Service Fee

MODIFIER

(+)

Increase

CR

ORDER_ITEM_MODIFIER

Products and services can be configured to include another product as an add-on service fee.

Balance Sheet

Liability

Prepaid Sales

Unearned Income

PACKAGE_CHARGE

(+)

Increase

CR

CLIENT_PATIENT_PKG

CLIENT_PKG_ITEM

Balance SheetLiabilityPrepaid TaxesPREPAID_TAX(-)DecreaseDRPKG_ITEM_TAX_LINKCreated, when a package item is 'used' on and order, to transfer the tax liability account from the client, to the taxing jurisdiction.Balance SheetLiabilityPrepaid TaxesPREPAID_TAX(+)IncreaseCRPKG_ITEM_TAX_LINKCreated for items in a package, when the package is added to the orderPREPAID

The price of a billing package is captured as 'Unearned Income' liability when the order closes. As package items are used/sold, the liability is converted to revenue.
Balance Sheet	Contra Liability

Prepayments applied to charges and A/R(-

Prepayment Applied

PREPAYMENT_APPLIED

(-)

Decrease

DR

CLIENT_PATIENT_PKG

CLIENT_PKG_ITEM

As billing package items are used/sold, the unearned income is reduced by amount of prepayment allocated to the item. The package discount amount reduces sales revenue.

Balance Sheet

AssetCash, A/RPREPAIDPAYMENT
DEBIT_MEMO
ORDERAR_TRANS

Liability

Taxes Due

TAX

(+)

Increase

DR

CR
Balance Sheet	Contra Liability

Taxes Due

Tax Adjustments

TAX_ADJUSTMENT

(

+

-)

Increase

Decrease

CR

DR

TAX_

ADJUSTMENT	When a closed-order adjustment affects the taxable revenue of a charge, the tax amount is adjusted.
Balance Sheet	Contra Liability	Tax Exemption Credit	TAX_EXEMPTION	(-)	Decrease	DR	ADJUSTMENT

CHARGE

CREDIT_

ADMIN
ADJUSTMENT

MEMO	Tax exemptions reduce the amount to be collected from the client. If tax has been paid, an exemption may result in a client credit.
Balance Sheet	Liability	Tax Exemption Reversal (Debit)	TAX_EXEMPTION	(+)	Increase	CR

CHARGE_ADMIN

ADJUSTMENT

ORDERARTRANSACTION
	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

Insert excerpt

	UG:Setup & Admin Guides
	UG:Setup & Admin Guides
nopanel	true

To see commonly used terms in VetView Hospital, please visit our Hospital Glossary of Terms

Info

title	Definitions

Refer to the 'Inventory and Accounting Definitions' wiki page for the definition of inventory and accounting terms, and for details about fields and controls.

Panel

title	Contents

Table of Contents

Versions Compared

Old Version 3

New Version Current

Key

GL Account Mapping to HOSPITAL_CHARGE_ADMIN

Mapping