'cust_bill_pkg_detail' => {
'columns' => [
- 'detailnum', 'serial', '', '', '', '',
+ 'detailnum', 'serial', '', '', '', '',
'billpkgnum', 'int', 'NULL', '', '', '', # should not be nullable
'pkgnum', 'int', 'NULL', '', '', '', # deprecated
'invnum', 'int', 'NULL', '', '', '', # deprecated
[ 'usernum' ], [ 'agent_pkgid' ],
['order_date'], [ 'start_date' ], ['setup'], ['bill'],
['last_bill'], ['susp'], ['adjourn'], ['cancel'],
- ['expire'], ['contract_end'], ['change_date'], ['no_auto'],
+ ['expire'], ['contract_end'], ['change_date'],
+ ['no_auto'],
+ #['contactnum'],
+ ['salesnum'],
+ #['uncancel_pkgnum'],
+ #['change_pkgnum'], ['change_locationnum'],
+ #['change_custnum'],
+ ['main_pkgnum'],
+ #['pkglinknum'], ['change_to_pkgnum'],
],
},