sale_advance_payment_inv

-1 rows


Description

Sales Advance Payment Invoice

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('sale_advance_payment_inv_id_seq'::regclass)
account_tax_sale_advance_payment_inv_rel.sale_advance_payment_inv_id account_tax_sale_advance_payme_sale_advance_payment_inv_id_fkey C
sale_advance_payment_inv_sale_order_rel.sale_advance_payment_inv_id sale_advance_payment_inv_sale__sale_advance_payment_inv_id_fkey C
product_id int4 10 √ null
product_product.id sale_advance_payment_inv_product_id_fkey N

Down Payment Product
currency_id int4 10 √ null
res_currency.id sale_advance_payment_inv_currency_id_fkey N

Currency
company_id int4 10 √ null
res_company.id sale_advance_payment_inv_company_id_fkey N

Company
deposit_account_id int4 10 √ null
account_account.id sale_advance_payment_inv_deposit_account_id_fkey N

Income Account
create_uid int4 10 √ null
res_users.id sale_advance_payment_inv_create_uid_fkey N

Created by
write_uid int4 10 √ null
res_users.id sale_advance_payment_inv_write_uid_fkey N

Last Updated by
advance_payment_method varchar 2147483647 null

Create Invoice
fixed_amount numeric 0 √ null

Down Payment Amount (Fixed)
deduct_down_payments bool 1 √ null

Deduct down payments
consolidated_billing bool 1 √ null

Consolidated Billing
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
amount float8 17,17 √ null

Down Payment Amount

Indexes

Constraint Name Type Sort Column(s)
sale_advance_payment_inv_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation