|
Lines 2681-2687
CREATE TABLE `accountlines` (
Link Here
|
| 2681 |
`accounttype` varchar(5) default NULL, |
2681 |
`accounttype` varchar(5) default NULL, |
| 2682 |
`payment_type` varchar(80) default NULL, -- optional authorised value PAYMENT_TYPE |
2682 |
`payment_type` varchar(80) default NULL, -- optional authorised value PAYMENT_TYPE |
| 2683 |
`amountoutstanding` decimal(28,6) default NULL, |
2683 |
`amountoutstanding` decimal(28,6) default NULL, |
| 2684 |
`lastincrement` decimal(28,6) default NULL, |
|
|
| 2685 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
2684 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
| 2686 |
`note` MEDIUMTEXT NULL default NULL, |
2685 |
`note` MEDIUMTEXT NULL default NULL, |
| 2687 |
`manager_id` int(11) NULL, |
2686 |
`manager_id` int(11) NULL, |
| 2688 |
- |
|
|