X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2FSchema.pm;h=e7b3b6fc67c7db607eb23d194bc57870932d17d0;hb=67b05564568d10ee3833a87f09b752d0319934ba;hp=e63dba6f30a9eff314eaf2ceb33a87aa1a8a8c84;hpb=01c832583b09f6bb6c3ae6067187e08160424c71;p=freeside.git diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index e63dba6f3..e7b3b6fc6 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -1633,6 +1633,7 @@ sub tables_hashref { 'complimentary', 'char', 'NULL', 1, '', '', 'po_number', 'varchar', 'NULL', $char_d, '', '', 'invoice_attn', 'varchar', 'NULL', $char_d, '', '', + 'invoice_ship_address', 'char', 'NULL', 1, '', '', ], 'primary_key' => 'custnum', 'unique' => [ [ 'agentnum', 'agent_custid' ] ], @@ -1967,6 +1968,26 @@ sub tables_hashref { ], }, + 'quotation_pkg_tax' => { + 'columns' => [ + 'quotationtaxnum', 'serial', '', '', '', '', + 'quotationpkgnum', 'int', '', '', '', '', + 'itemdesc', 'varchar', '', $char_d, '', '', + 'taxnum', 'int', '', '', '', '', + 'taxtype', 'varchar', '', $char_d, '', '', + 'setup_amount', @money_type, '', '', + 'recur_amount', @money_type, '', '', + ], + 'primary_key' => 'quotationtaxnum',, + 'unique' => [], + 'index' => [ [ 'quotationpkgnum' ] ], + 'foreign_keys' => [ + { columns => [ 'quotationpkgnum' ], + table => 'quotation_pkg', + }, + ], +}, + 'cust_location' => { #'location' now that its prospects too, but... 'columns' => [ 'locationnum', 'serial', '', '', '', '',