Report · Truy xuất dữ liệu
4 report export theo template · CHO CHOT thuộc GD1 hay GD2
Chi tiet: moi TSCC / moi lan giao dich = 1 dong · Tong hop: moi HDCC / lan gan nhat = 1 dong
Report Khach hang (TEMPLATE KH)
Ho so KH + SL HDCC, du no den ngay truy xuat, tong lai+phi phai thu/da thu/chua thu
| Ma KH | Ten KH | CCCD | Hang | SL HDCC | Du no | Lai+Phi phai thu | Da thu | Chua thu |
|---|---|---|---|---|---|---|---|---|
| KH-0001 | Nguyen Van An | 079086001234 | Gold | 2 | 10.000.000 | 693.000 | 450.000 | 243.000 |
| KH-0002 | Tran Thi Binh | 079086005678 | Chuan | 1 | 25.000.000 | 1.125.000 | 0 | 1.125.000 |
Lich su dieu chinh KH ▼ bam de dong/mo
| Ma KH | Thoi diem | User thuc hien | Truong | Gia tri cu | Gia tri moi | User duyet |
|---|---|---|---|---|---|---|
| KH-0001 | 15/08/2026 09:30 | Nguyen Thi Mai (TVV) | SDT | 0901 xxx 888 | 0912 xxx 222 | — |
| KH-0002 | 10/08/2026 14:15 | Tran Van Hung (Admin) | Dia chi lien he | 123 Nguyen Hue, Q1 | 456 Le Loi, Q3 | Le Quoc Bao (Admin) |
De xuat Mona: log tach moi lan 1 dong, report gom khi xuat · CHO CHOT gom 1 dong hay tach
Report Hop dong cam co (TEMPLATE HDCC)
Toan bo vong doi HD — lai/phi phai thu/da thu/con phai thu, tang-giam lai phi, han muc giai ngan con lai, chuoc hang, tem niem phong, SBT
~84 cot — preview chi hien cot chinh, export day du
| Ma HD | Ma KH | Trang thai | Loai GD | Ngay tao | Du no | Lai phai thu | Phi phai thu | Da thu | Con phai thu | Han muc GN con lai | SBT |
|---|---|---|---|---|---|---|---|---|---|---|---|
| HD002201 | KH-0001 | Dang hieu luc | Cam moi | 01/08/2026 | 10.000.000 | 450.000 | 180.000 | 0 | 630.000 | 5.000.000 | — |
Cac cot khong hien thi trong preview: chuoc hang (user de xuat/duyet, hinh thuc tra, chinh chu/uy quyen, phi BQTS phat sinh them), tem niem phong + ma tem sau doi, hinh thuc thanh toan
CHO CHOT Cot "khung lai & phi ky han gan nhat" — y nghia chua ro
CHO CHOT Nghiep vu doi tem niem phong ("ma tem sau khi doi")
Report Tai san cam co (TEMPLATE TSCC)
Chi tiet tai san theo HD
| Ma HD | Loai TSCC | Tuoi vang | TL vang (chi) | TL tong (chi) | PP dinh gia | Tri gia TSCC | Ty le cam | Han muc TS | Tho KT | Hinh thuc KD | Quyen SH |
|---|---|---|---|---|---|---|---|---|---|---|---|
| HD002201 | Nu trang TL | 99.9 | 3.750 | 4.200 | Thi truong | 15.000.000 | 85% | 12.750.000 | Le Hoang (NV034) | Tho cua hang | Chinh chu |
Report Gia han (TEMPLATE GIA HAN)
Du no truoc/sau, vay them, tra bot, tai dinh gia, ky moi, SBT, ly do tu choi
| Ma HD | Lan GH | Loai GH | Du no truoc | Vay them | Tra bot | Du no sau | Tri gia TDG | Han muc sau TDG | Ky moi (ngay) | Lai suat moi | SBT | Trang thai | Ly do tu choi |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| HD002201 | 1 | GH thuong | 10.000.000 | — | — | 10.000.000 | — | — | 30 | 1.5 | UNC-2345 | Da duyet | — |
Luu y: Cac truong trong report la NGUON THAM CHIEU cho data model: moi truong xuat hien o day phai luu duoc trong DB.
CHO CHOT 4 report template thuoc GD1 hay GD2 (chua co trong timeline)
CHO CHOT So chung tu thu gop hay tach theo giao dich