-- ABS-37729
----------   CUSTOMERBILLINGINFO   --------------
ALTER TABLE CUSTOMERBILLINGINFO ADD (FULLPAYMENTONDELIVERY VARCHAR2(1) DEFAULT 'N' NOT NULL
				     CONSTRAINT YN_VALIDATIONFIELD363 CHECK (FULLPAYMENTONDELIVERY IN ('Y','N')));

COMMENT ON COLUMN CUSTOMERBILLINGINFO.FULLPAYMENTONDELIVERY IS 'When set to Yes, collected amount must be equal or more than invoice amount to be able to capture the signature and settle the invoice.';