21 |
21 |
mtime => { type => 'timestamp', default => 'now()', not_null => 1 },
|
22 |
22 |
obsolete => { type => 'boolean', default => 'false', not_null => 1 },
|
23 |
23 |
recipients => { type => 'text', not_null => 1 },
|
24 |
|
record_type => { type => 'enum', check_in => [ 'sales_order', 'purchase_order', 'sales_quotation', 'request_quotation', 'purchase_quotation_intake', 'sales_order_intake', 'sales_delivery_order', 'purchase_delivery_order', 'supplier_delivery_order', 'rma_delivery_order', 'sales_reclamation', 'purchase_reclamation', 'invoice', 'invoice_for_advance_payment', 'invoice_for_advance_payment_storno', 'final_invoice', 'invoice_storno', 'credit_note', 'credit_note_storno', 'purchase_invoice', 'purchase_credit_note', 'ap_transaction', 'ar_transaction', 'gl_transaction' ], db_type => 'email_journal_record_type' },
|
|
24 |
record_type => { type => 'enum', check_in => [ 'sales_order', 'purchase_order', 'sales_quotation', 'request_quotation', 'purchase_quotation_intake', 'sales_order_intake', 'sales_delivery_order', 'purchase_delivery_order', 'supplier_delivery_order', 'rma_delivery_order', 'sales_reclamation', 'purchase_reclamation', 'invoice', 'invoice_for_advance_payment', 'invoice_for_advance_payment_storno', 'final_invoice', 'invoice_storno', 'credit_note', 'credit_note_storno', 'purchase_invoice', 'purchase_credit_note', 'ap_transaction', 'ar_transaction', 'gl_transaction', 'purchase_order_confirmation' ], db_type => 'email_journal_record_type' },
|
25 |
25 |
sender_id => { type => 'integer' },
|
26 |
26 |
sent_on => { type => 'timestamp', default => 'now()', not_null => 1 },
|
27 |
27 |
status => { type => 'enum', check_in => [ 'sent', 'send_failed', 'imported' ], db_type => 'email_journal_status', not_null => 1 },
|
EmailJournal: Belegtype um Lieferantenauftragsbestätigung erweitert