--UPDATE FROM 8.10.1.10 TO 8.10.1.11


DROP TABLE VERSION_8_10_1_10;


/*  VERSION_8_10_1_11  */
CREATE TABLE VERSION_8_10_1_11 (
	 DUMMY	NUMBER	    NULL
)
;



ALTER TABLE ZFCF ADD ZFCF_TRANSACTION_TYPE VARCHAR2(1);
 
COMMENT ON COLUMN ZFCF.ZFCF_TRANSACTION_TYPE IS 'indicates the type of transaction I = Initial, N = Invoice, Z = Zero';

ALTER TABLE ZFCF ADD ZFCF_DEP_TIMESTAMP date;
 
COMMENT ON COLUMN ZFCF.ZFCF_DEP_TIMESTAMP IS 'the timestamp sent in the response';

ALTER TABLE ZFCF ADD ZFCF_SIGNATURE VARCHAR2(400 CHAR);
  
ALTER TABLE ZFCF ADD ZFCF_RUNNING_TOTAL NUMBER(30,4);
  
ALTER TABLE ZFCF ADD ZFCF_WPCA_ID NUMBER (30,0);
 
COMMENT ON COLUMN ZFCF.ZFCF_SIGNATURE IS 'Fiscal NUMBER / Signature from FiscalPrinter';

COMMENT ON COLUMN ZFCF.ZFCF_RUNNING_TOTAL IS 'Running total provided by FiscalPrinter';

COMMENT ON COLUMN ZFCF.ZFCF_WPCA_ID IS 'link to wpca (workstation id)';
 
ALTER TABLE ZFCF ADD ZFCF_RECEIPT_NUMBER VARCHAR2(30 CHAR);

ALTER TABLE WPCA ADD WPCA_FISCAL_PRINTER_URL VARCHAR2(60 CHAR);

COMMENT ON COLUMN ZFCF.ZFCF_RECEIPT_NUMBER IS 'Receipt NUMBER received from FiscalPrinter';

COMMENT ON COLUMN WPCA.WPCA_FISCAL_PRINTER_URL IS 'URL of fiscal layer';

ALTER TABLE ZFCF ADD ZFCF_dep clob;

COMMENT ON COLUMN ZFCF.ZFCF_DEP IS 'Contains the DEP received from FiscalPrinter in json format';

ALTER TABLE ZFCF ADD ZFCF_cash_register_id VARCHAR2(16 CHAR);

COMMENT ON COLUMN ZFCF.ZFCF_CASH_REGISTER_ID IS 'Contains the cash register id of the terminal send the invoice';





