custumer property exempt_vat
| | |
| | | -- |
| | | -- Table: business_partner |
| | | -- |
| | | INSERT INTO business_partner (member_id, member_code, member_since, shares_signed, free, indicator_vat) |
| | | VALUES (10000, 'hsh00-hsh', current_date, 0, TRUE, 'NET'); |
| | | INSERT INTO business_partner (member_id, member_code, member_since, shares_signed, free, indicator_vat, exempt_vat) |
| | | VALUES (10000, 'hsh00-hsh', current_date, 0, TRUE, 'NET', FALSE); |
| | | |
| | | -- |
| | | -- table: contact |
| | |
| | | uid_vat character varying(20), |
| | | free boolean NOT NULL, |
| | | indicator_vat character varying(20) NOT NULL, |
| | | exempt_vat boolean NOT NULL, |
| | | CONSTRAINT ckc_member_id_business CHECK (((member_id >= 10000) AND (member_id <= 99999))), |
| | | CONSTRAINT ckc_shares_signed_business CHECK ((shares_signed >= 0)), |
| | | CONSTRAINT ckt_business_partner CHECK ( ( ((member_since IS NULL) AND (member_until IS NULL)) OR ((member_since IS NOT NULL) AND (member_until IS NULL)) OR ((member_since IS NOT NULL) AND (member_until IS NOT NULL) AND (member_since < member_until)) ) AND ((member_code)::text ~~ 'hsh00-%'::text)), |
| | |
| | | @Column(name = "free", nullable = false) |
| | | private boolean free = false; |
| | | |
| | | @Column(name = "exempt_vat", nullable = false) |
| | | private boolean exemptVAT = false; |
| | | |
| | | @Column(name = "indicator_vat", nullable = false) |
| | | @Basic |
| | | @Enumerated(EnumType.STRING) |
| | |
| | | public void setIndicatorVAT(IndicatorVAT indicatorVAT) { |
| | | this.indicatorVAT = indicatorVAT; |
| | | } |
| | | |
| | | public boolean isExemptVAT() { |
| | | return exemptVAT; |
| | | } |
| | | |
| | | public void setExemptVAT(boolean exemptVAT) { |
| | | this.exemptVAT = exemptVAT; |
| | | } |
| | | } |