Perubahan Tabel

BY IN Spa & Salon System Comments Off on Perubahan Tabel

Beberapa perubahan tabel:

tblBooking
Price (LongInt)
Reg (Text 20)

tblInvoice
Status (Text 20)

tblInvoiceDetail
Discount (LongInt)
BookingDate (Date/Time)
Start (Date/Time)
End (Date/Time)
Theraphist (Text 50)

tblProduct1
ProductID (Text 8)
Name (Text 50)
Unit (Text 50)
Stock (Double)
Remarks (Memo)

tblReg
Reg (Text 10)
RegDate (Date/Time)
PackageID (Text 8)
PackageName (Text 100)
Price (LongInt)
Paid (LongInt)
Saldo (LongInt)
TotalSession (LongInt)
Remarks (Text 255)
CustomerID (Text 5)

tblRegDetail
Reg (Text 10)
InvoiceNo (Text 20)
Total (LongInt)

tblStockCard1
TransDate (Date/Time)
TransNo (Text 20)
ProductID (Text 8)
ProductName (Text 50)
Type (Text 50)
Qty (LongInt)
Stock (Double)
Remarks (Text 255)




Comments are closed.