aqinvoices

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
invoiceid INT 10 √ null
aqinvoice_adjustments.invoiceid aqinvoice_adjustments_fk_invoiceid C
aqorders.invoiceid aqorders_ibfk_3 N

ID of the invoice, primary key
invoicenumber LONGTEXT 2147483647 null

Name of invoice
booksellerid INT 10 null
aqbooksellers.id aqinvoices_fk_aqbooksellerid C

foreign key to aqbooksellers
shipmentdate DATE 10 √ NULL

date of shipment
billingdate DATE 10 √ NULL

date of billing
closedate DATE 10 √ NULL

invoice close date, NULL means the invoice is open
shipmentcost DECIMAL 28,6 √ NULL

shipment cost
shipmentcost_budgetid INT 10 √ NULL
aqbudgets.budget_id aqinvoices_fk_shipmentcost_budgetid N

foreign key to aqbudgets, link the shipment cost to a budget
message_id INT 10 √ NULL
edifact_messages.id edifact_msg_fk N

foreign key to edifact invoice message

Indexes

Constraint Name Type Sort Column(s)
aqinvoices_s_pk Primary key Asc invoiceid
aqinvoices_fk_aqbooksellerid Performance Asc booksellerid
aqinvoices_fk_shipmentcost_budgetid Performance Asc shipmentcost_budgetid
edifact_msg_fk Performance Asc message_id
PRIMARY Must be unique Asc invoiceid

Relationships

Close relationships within degrees of separation