aqinvoices

0 rows


Columns

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
invoicenumber LONGTEXT 2147483647 null
booksellerid INT 10 null
aqbooksellers.id aqinvoices_fk_aqbookselleridC
shipmentdate DATE 10 √ null
billingdate DATE 10 √ null
closedate DATE 10 √ null
shipmentcost DECIMAL 28,6 √ null
shipmentcost_budgetid INT 10 √ null
aqbudgets.budget_id aqinvoices_fk_shipmentcost_budgetidN
message_id INT 10 √ null
edifact_messages.id edifact_msg_fkN

foreign key to edifact invoice message

Indexes

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

Relationships

Close relationships within degrees of separation