0 rows


Column Type Size Nulls Auto Default Children Parents Comments
invoiceid INT 10 null
aqinvoice_adjustments.invoiceid aqinvoice_adjustments_fk_invoiceidC
aqorders.invoiceid aqorders_ibfk_3N

ID of the invoice, primary key

invoicenumber LONGTEXT 2147483647 null

Name of invoice

booksellerid INT 10 null aqinvoices_fk_aqbookselleridC

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_budgetidN

foreign key to aqbudgets, link the shipment cost to a budget

message_id INT 10 null edifact_msg_fkN

foreign key to edifact invoice message


Constraint Name Type Sort Column(s)
PRIMARY 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