SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Debit and credit process?


Debit and credit process?

Author
Message
naila-330342
naila-330342
SSC-Enthusiastic
SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)

Group: General Forum Members
Points: 194 Visits: 1

How to define Debt and credit process in Payment ?

Its my payment module So how to declare Debit and credit process .

Payment:

I am not much known about making the database .its my first experience .I have done some work but I want that some one check my work .Is it correct or not ? OR its relations and its primary keys are correct .please help me about payment data and check this .Is it payment data is fully normalized or Not?

We make a Point of sale system for a mobiles. it’s a online application that’s keep all records in database.

In Payment process we make seven tables that’s are our entities in ERD such as

  • Payment: (it’s a main table)
  • Payment Types

  • Cash Payment
  • Security Payment
  • Invoice Payment
  • Bill Payment
  • CreditCardPayment
  • ChequePayment

Payment table is the main table and that are linked with other tables.

Some data types are bigint, and varchar

· Payment Table : (mobileNo,customerNo,paymentId,customerName,referenceNo,paymentBalance,payCode,payDescription,amount,cerditCardName,paymentDate)

· PaymentTypes: (typeId,paymentId,typeName)

· BillPayment: (paymentId,billPaymentDate,dealerCode,billBalance)

· CashPayment: (paymentId,cashPaymentDate,cashReceipt,

depositedInBank,cashInHand)

· SecurityPayment: (paymentId,currentDeposit)

· CerditCardPayment: (paymentId,expirationDate,authorizationCode)

· InvoicePayment: (paymentId,invoiceBalance,invoicePaymentDate)

· ChequePayment: (paymentId,locOut,bankName,branch)

We make the relations are

· chequePayment: primary key goes to the payment Table and make a Foreign key in payment Table.

· In Payment Type Table we declare a “typeId “ is a primary key and “paymentId” is a composite Key because payment table relate to the payment types .payment types are “cashPayment,Billpayment,creditCardPayment”

· CerditCardPayment: paymentId is the primary key in the cerditCardPayment and forigen key in the Payment table

· cashPayment ,SecurityPayment ,billPayment,InvoicePayment are all have paymentID as a primary key and its foreign key represent in the payment table.


Marshall Smith
Marshall Smith
SSC-Addicted
SSC-Addicted (443 reputation)SSC-Addicted (443 reputation)SSC-Addicted (443 reputation)SSC-Addicted (443 reputation)SSC-Addicted (443 reputation)SSC-Addicted (443 reputation)SSC-Addicted (443 reputation)SSC-Addicted (443 reputation)

Group: General Forum Members
Points: 443 Visits: 11
The simplest way is to record a credit as a negative "payment" amount. If your need for credits is fairly simple, that's a good way to go. It's simple, straightforward, and useful.

OTOH, in many businesses, debits and credits are actually different entities, and need to be handled differently. In that case, you'd just want to build a Credit table, with a very similar structure to the Payment table here. It will make some of your calculations of current balances a little trickier, as you'll have to join the tables. But, if they are different entities, it is best to separate them into different tables.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search