| InvoiceID | int(11) |
|
|
|
| TimeStamp | timestamp |
|
|
current_timestamp()
|
| UserName | varchar(20) |
|
|
|
| BranchOffice | varchar(20) |
|
|
|
| InvoiceDate | date |
|
|
|
| CustomerID | int(11) |
|
|
|
| AmtPay | double |
|
|
|
| Currency | varchar(10) |
|
|
|
| Exchange | double |
|
|
|
| Ref_PO | varchar(10) |
|
|
|
| StaffID | int(11) |
|
|
|
| ComisionerID | int(11) |
|
|
|
| StaffFee | double |
|
|
|
| ComisionerFee | double |
|
|
|
| DatePay | date |
|
|
|
| UserNTm | varchar(100) |
|
|
|
