park accountanat - Laravel Schema Designer

acc_capital_sub_account

id increments
timestamps timestamps
softDeletes softDeletes
name string
user_id integer
control_account_id integer
balance_sheet_id integer
profit_loss_id integer
capital_account_id integer

acc_profit_loss_account

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
name string
code string
profit_loss_id integer
cash_flow_type_id integer
cash_flow_id integer
description_en text
description_ar text
status enum
division_id integer
place_id integer
division_place_id integer

acc_bank_account

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
name string
code string
currency_id integer
division_id integer
place_id integer
division_place_id integer
control_account_id integer
starting_balance double
iban string
have_pending_transaction boolean
credit_limit double
status enum
uncategorized_receipt integer
uncategorized_payment integer
cleared_balance double
pending_deposit double
pending_withdrawal double
actual_balance double
last_bank_reconcilliation datetime
available_credit double

acc_bank_statment

id increments
timestamps timestamps
softDeletes softDeletes
bank_account_id integer
user_id integer

acc_receipt

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
date datetime
reference string
paid_by_type enum
other_name string
customer_id integer
supplier_id integer
bank_account_id integer
description text
total double
fixed_total double
sales_invoice_id integer
out_of_balance double
amount double
title string
footer_id integer
cleared_at datetime
inventory_id integer

acc_customer

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
status enum
name string
code string
credit_limit double
currency_id integer
billing_address text
delivery_address text
email string
division_id integer
control_account_id integer
available_credit double
total_available_credit double
receipt integer
payment integer
sales_quote integer
sales_order integer
sales_invoice integer
credit_note integer
delivery_note integer
quantity_delivery integer
quantity_invoice integer
univoiced double
account_receivable double
withholding_tax double
money_status enum
place_id integer
division_place_id integer
starting_balance double
autofill_sales_invoice boolean
autofill_billable_time boolean
billable_time_hourly_rate integer
sales_invoice_due_date integer

acc_supplier

id increments
timestamps timestamps
softDeletes softDeletes

acc_item

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
name string
receipt_id integer
balance_sheet_account_id integer
profit_loss_account_id integer
quantity integer
unit_price double
total double
division_id integer
amount double
description text
discount_type enum
discount double
place_id integer
division_place_id integer
expense_claim_id integer
sales_quote_id integer
sales_order_id integer
sales_invoice_id integer
inventory_item_id integer
cost_goods_type enum
cost_goods_price double
payment_id integer
request_for_quotation boolean
purchase_quote_id integer
purchase_order_id integer
purchase_invoice_id integer
debit_note_id integer
goods_receipt_id integer
project_id integer
cost_of_goods_type enum
cost_of_goods_amount double
inventory_id integer

user

id increments
timestamps timestamps
softDeletes softDeletes

acc_history

id increments
timestamps timestamps
softDeletes softDeletes
date datetime
action enum
description text
user_id string

acc_account_transfer

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
date datetime
refrence string
description text
paid_from_bank_account_id integer
amount double
received_in_bank_account_id integer
footer_id integer
cleared_type enum
cleared_at datetime

acc_reconciliation

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
date datetime
bank_account_id integer
statement_balance double
status enum
discrepancy double

acc_footer

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
content text
code_editor text
footer_category_id integer
status enum

acc_division

id increments
timestamps timestamps
softDeletes softDeletes
name string
user_id integer
status enum

acc_expense_claim_payers

id increments
timestamps timestamps
softDeletes softDeletes
name string
balance_type enum
starting_balance double
division_id integer
user_id integer
status enum
place_id integer
division_place_id integer

acc_footer_category

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

acc_sales_quote

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
footer_id integer
customer_id integer
date datetime
expiry_date datetime
valid_days integer
reference string
billing_address text
description text
amount double
title string
status enum
sub_total double
whithholding_tax double
total double
cancelled boolean
show_item_image boolean
hide_total boolean
whithholding_tax_type enum

acc_sales_order

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
footer_id integer
customer_id integer
sales_quote_id integer
date datetime
reference string
description text
amount double
billing_address text
title string
status enum
sub_total double
whithholding_tax double
total double
cancelled boolean
show_item_image boolean
hide_total boolean
whithholding_tax_type enum
quantity_delivery integer
delivery_status enum
invoice_amount double
invoice_status enum
sales_quotes integer
closed_invoice boolean

acc_sales_invoice

id increments
timestamps timestamps
softDeletes softDeletes
status enum
user_id integer
footer_id integer
customer_id integer
date datetime
due_date datetime
due_type enum
reference string
billing_address text
description text
amount double
title string
sub_total double
whithholding_tax double
total double
cancelled boolean
show_item_image boolean
hide_total boolean
whithholding_tax_type enum
day integer
early_payment_discount double
early_payment_discount_type enum
early_payment_discount_number decimal
if_paid_within_day integer
late_payment_fee double
charge_monthly decimal
invoice_amount double
balance_due double
days_to_due_date integer
days_overdue integer
sales_quote_id integer
sales_order_id integer
inventory_id integer

acc_inventory_item

id increments
timestamps timestamps
softDeletes softDeletes

acc_cleared_balance

id increments
timestamps timestamps
softDeletes softDeletes
date datetime
transaction_id integer
bank_account_id integer
balance double

acc_cash_flow_type

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

acc_cash_flow

id increments
timestamps timestamps
softDeletes softDeletes
cash_flow_type_id integer
name string

acc_balance_sheet_account

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
name string
code string
balance_sheet_id integer
cash_flow_type_id integer
cash_flow_id integer
division_place_id integer
division_id integer
place_id integer
starting_balance double
balance_type enum
description text
balance double
status enum

acc_balance_sheet

id increments
timestamps timestamps
softDeletes softDeletes
name string
parent_id string
user_id integer

acc_profit_loss

id increments
timestamps timestamps
softDeletes softDeletes
name string
group_type enum
parent_id integer
user_id integer

acc_control_type

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
user_id integer

acc_control_account

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
name string
code string
balance_sheet_id integer
control_type_id integer
cash_flow_type_id integer
cash_flow_id integer
status enum

acc_place

id increments
timestamps timestamps
softDeletes softDeletes
name string

acc_division_place

id increments
timestamps timestamps
softDeletes softDeletes
place_id integer
division_id integer
name string
status enum

acc_expense_claim

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
date datetime
reference string
paid_by_id integer
balance_sheet_account_id integer
payee string
currency_id integer
description text
amount double
footer_id integer
paid_by_type enum

acc_currency

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
symbols_en string
symbols_ar string

acc_credit_note

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
customer_id integer
sales_invoice_id integer
inventory_id integer
footer_id integer
date datetime
reference string
description text
amount double
billing_address text
tax_inclusive boolean
amounts_are_tax_inclusive boolean
whithholding_tax_type enum
whithholding_tax double
title string

acc_late_payment

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
date datetime
customer_id integer
sales_invoice_id integer
amount double

acc_delivery_note

id increments
timestamps timestamps
softDeletes softDeletes
date datetime
reference string
sales_order_id integer
sales_invoice_id integer
customer_id integer
inventory_id integer
user_id integer
description text
quantity integer
delivery_address text
title string
footer_id integer

acc_inventory

id increments
timestamps timestamps
softDeletes softDeletes

acc_billable_time

id increments
timestamps timestamps
softDeletes softDeletes
date datetime
description text
time_spent time
customer_id integer
division_id integer
place_id integer
division_place_id integer
sales_invoice_id integer
amount double
status enum
hourly_rate double
written_off_date datetime
user_id integer

acc_whithholding_tax_receipt

id increments
timestamps timestamps
softDeletes softDeletes
date datetime
user_id integer
customer_id integer
description text
amount double

acc_capital_account

id increments
timestamps timestamps
softDeletes softDeletes
name integer
code string
control_account_id integer
division_id integer
division_place_id integer
place_id integer
starting_balance_type enum
starting_balance_amount double
status enum
user_id integer
balance_sheet_id integer
balance double

acc_special_account

id increments
timestamps timestamps
softDeletes softDeletes
name string
code string
currency_id integer
division_id integer
place_id integer
division_place_id integer
user_id integer
balance_sheet_id integer
control_account_id integer
starting_balance double
balance_type enum
status enum
balance double

acc_payment

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
date datetime
reference string
description text
bank_account_id integer
amount double
paid_by_type enum
other_name string
customer_id integer
supplier_id integer
total double
fixed_total double
out_of_balance double
purchase_invoice_id integer
title string
inventory_id integer
footer_id integer

acc_purchase_invoice

id increments
timestamps timestamps
softDeletes softDeletes

acc_debit_note

id increments
timestamps timestamps
softDeletes softDeletes

acc_goods_receipt

id increments
timestamps timestamps
softDeletes softDeletes

acc_purchase_order

id increments
timestamps timestamps
softDeletes softDeletes

acc_purchase_quote

id increments
timestamps timestamps
softDeletes softDeletes

acc_project

id increments
timestamps timestamps
softDeletes softDeletes