c_allocationline

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_allocationline_id numeric 10 null
c_paymentallocate.c_allocationline_id cpaymtallocate_callocationline N
c_taxdeclarationline.c_allocationline_id callocationline_ctaxdeclline R
rv_allocation.c_allocationline_id Implied Constraint R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
allocationno numeric 10 √ null
datetrx timestamp 29,6 √ null
ismanual bpchar 1 √ 'N'::bpchar
c_invoice_id numeric 10 √ null
c_invoice.c_invoice_id cinvoice_callocationline R
c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id cbpartner_callocationline R
c_order_id numeric 10 √ null
c_order.c_order_id corder_callocation R
c_payment_id numeric 10 √ null
c_payment.c_payment_id cpayment_callocationline R
c_cashline_id numeric 10 √ null
c_cashline.c_cashline_id ccashline_callocationline R
amount numeric 0 0
discountamt numeric 0 0
writeoffamt numeric 0 0
overunderamt numeric 0 √ 0
c_allocationhdr_id numeric 10 null
c_allocationhdr.c_allocationhdr_id callocation_callocationline R
c_allocationline_uu varchar 36 √ NULL::character varying
c_charge_id numeric 10 √ null
c_charge.c_charge_id ccharge_callocationline R
c_invoicepayschedule_id numeric 10 √ NULL::numeric
c_invoicepayschedule.c_invoicepayschedule_id Implied Constraint R
cof_elementvalue_id numeric 10 √ NULL::numeric
c_elementvalue.c_elementvalue_id cofelementvalue_callocationlin R
cof_writeoffreason varchar 22 √ NULL::character varying
cof_interestamt numeric 0 √ (0)::numeric
cof_penaltyamt numeric 0 √ (0)::numeric
c_banktransfer_id numeric 10 √ NULL::numeric
c_banktransfer.c_banktransfer_id cbanktransfer_callocationline R

Indexes

Constraint Name Type Sort Column(s)
c_allocationline_pkey Primary key Asc c_allocationline_id
c_allocationline_invoice Performance Asc c_invoice_id
c_allocationline_payment Performance Asc c_payment_id
c_allocationline_uu_idx Must be unique Asc c_allocationline_uu

Check Constraints

Constraint Name Constraint
c_allocationline_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_allocationline_ismanual_check ((ismanual = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation