Orange County NC Website
Browse       Search
DocuSign Envelope ID: 1CCA18DC-6CC1-428C-A15D-5173EE24B471 0 <br /> 0 <br /> 0 <br /> c <br /> Cn <br /> Financial Tables: <br /> m <br /> permit fee—Holds the details for fees associated to permits. CID <br /> 0 <br /> -a <br /> CID <br /> plan fee—Holds the details for fees associated to plans. <br /> CO <br /> 0 <br /> payment—Records representing funds received. n <br /> 1P <br /> payment reversal—Records representing funds going back to a customer(or voided). The types of transactions here would likely be voids, NSFs, and refunds. <br /> These should be linked back to the original payment record that they are reversing. <br /> N <br /> TI <br /> permit payment detail—records the amount applied to each individual fee (line item)within a payment. Cri <br /> 0 <br /> plan payment detail—records the amount applied to each individual fee (line item)within a payment. <br /> n <br /> J <br /> 03 <br /> permit payment reversal detail—records the amount applied to each individual fee (line item) within a reversal. 4 <br /> CO <br /> CO <br /> plan payment reversal detail—records the amount applied to each individual fee (line item)within a reversal. <br /> payment <br /> permit_payment_detail 4 payment_id plan—payment_detail plan—fee <br /> rmit fee permit fee_id <br /> — `dl receipt—number J plan_fee_id C6Ian fee id <br /> � <br /> permit_fee_id <dI payment_id I plan_nimber per payment_method �I payment_id <br /> permit number paid amount fee type <br /> J J check—number � paid_amount <br /> fee_type <br /> Jpayment amourt J fee amount <br /> fee_amwnt <br /> J payment_date J fee date <br /> Jfee date <br /> created by user J created_by_user <br /> created_try_user <br /> Jinprt_va'ue � eg-transaction_id J input_value <br /> J egfee_id payment—rite J eg_fee_id <br /> Jfee—note <br /> fee note <br /> perm lit—pa yment_reversal_detail plan—payment—reversal—detail <br /> ,,I permit fee_id payment_reve real plan fee_id <br /> J payment_reversal_id QI payment_reversal_id <br /> 4 payment_reversal ld 4� <br /> J reversal type <br /> reversed amount J reversed_amwnt <br /> Jreceipt—number <br /> Jreversal_amount <br /> reversal date <br /> Jcreated_by user <br /> Jpayment_id <br /> Jeg-transaction ld <br /> reversal_ncte <br />