'cust_bill_pkg_detail' => {
'columns' => [
- 'detailnum', 'serial', '', '', '', '',
+ 'detailnum', 'serial', '', '', '', '',
'billpkgnum', 'int', 'NULL', '', '', '', # should not be nullable
'pkgnum', 'int', 'NULL', '', '', '', # deprecated
'invnum', 'int', 'NULL', '', '', '', # deprecated
['last_bill'], ['susp'], ['adjourn'], ['cancel'],
['expire'], ['contract_end'], ['change_date'],
['no_auto'],
+ #['contactnum'],
+ ['salesnum'],
+ #['uncancel_pkgnum'],
+ #['change_pkgnum'], ['change_locationnum'],
+ #['change_custnum'],
+ ['main_pkgnum'],
+ #['pkglinknum'], ['change_to_pkgnum'],
],
'foreign_keys' => [
{ columns => [ 'custnum' ],
'columns' => [
'vendbillnum', 'serial', '', '', '', '',
'vendnum', 'int', '', '', '', '',
- '_date', @date_type, '', '',
+ #'_date', @date_type, '', '',
+ '_date', 'int', '', '', '', '',
'charged', @money_type, '', '',
],
'primary_key' => 'vendbillnum',
'columns' => [
'vendpaynum', 'serial', '', '', '', '',
'vendnum', 'int', '', '', '', '',
- '_date', @date_type, '', '',
+ #'_date', @date_type, '', '',
+ '_date', 'int', '', '', '', '',
'paid', @money_type, '', '',
],
'primary_key' => 'vendpaynum',