--UPDATE FROM 8.8.4.0 TO 8.8.4.1


DROP TABLE VERSION_8_8_4_0;



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


ALTER TABLE YEBS ADD YEBS_MERGEDFLAG NUMBER(3) DEFAULT 0;

COMMENT ON COLUMN YEBS.YEBS_MERGEDFLAG IS '0-booked by package; 1-created by merge functionality';

ALTER TABLE SRPD ADD SRPD_TYPE NUMBER(30) DEFAULT 0;

COMMENT ON COLUMN SRPD.SRPD_TYPE IS '0 Standard (all revenue), 1 Hotel, 2 Deposit, 3 Voucher';

ALTER TABLE SRDS ADD SRDS_TYPE NUMBER(30) DEFAULT 0;

COMMENT ON COLUMN SRDS.SRDS_TYPE IS '0 Standard (all revenue), 1 Hotel, 2 Deposit, 3 Voucher';

ALTER TABLE SMAN ADD
(
  SMAN_D_TOTALGROSSREV_D          NUMBER(30,4)        NULL,
  SMAN_D_TOTALGROSSREV_M          NUMBER(30,4)        NULL,
  SMAN_D_TOTALGROSSREV_Y          NUMBER(30,4)        NULL,
  SMAN_D_TOTALNETREV_D            NUMBER(30,4)        NULL,
  SMAN_D_TOTALNETREV_M            NUMBER(30,4)        NULL,
  SMAN_D_TOTALNETREV_Y            NUMBER(30,4)        NULL,
  SMAN_D_PAYMENTS_D               NUMBER(30,4)        NULL,
  SMAN_D_PAYMENTS_M               NUMBER(30,4)        NULL,
  SMAN_D_PAYMENTS_Y               NUMBER(30,4)        NULL,
  SMAN_D_ROOMREVGROSS_D           NUMBER(30,4)        NULL,
  SMAN_D_ROOMREVGROSS_M           NUMBER(30,4)        NULL,
  SMAN_D_ROOMREVGROSS_Y           NUMBER(30,4)        NULL,
  SMAN_D_ROOMREVNET_D             NUMBER(30,4)        NULL,
  SMAN_D_ROOMREVNET_M             NUMBER(30,4)        NULL,
  SMAN_D_ROOMREVNET_Y             NUMBER(30,4)        NULL,
  SMAN_D_TOTALGROSSNHTLREV_D      NUMBER(30,4)        NULL,
  SMAN_D_TOTALGROSSNHTLREV_M      NUMBER(30,4)        NULL,
  SMAN_D_TOTALGROSSNHTLREV_Y      NUMBER(30,4)        NULL,
  SMAN_D_TOTALNETNHTLREV_D        NUMBER(30,4)        NULL,
  SMAN_D_TOTALNETNHTLREV_M        NUMBER(30,4)        NULL,
  SMAN_D_TOTALNETNHTLREV_Y        NUMBER(30,4)        NULL,
  SMAN_D_ROOMNHTLREVGROSS_D       NUMBER(30,4)        NULL,
  SMAN_D_ROOMNHTLREVGROSS_M       NUMBER(30,4)        NULL,
  SMAN_D_ROOMNHTLREVGROSS_Y       NUMBER(30,4)        NULL,
  SMAN_D_ROOMNHTLREVNET_D         NUMBER(30,4)        NULL,
  SMAN_D_ROOMNHTLREVNET_M         NUMBER(30,4)        NULL,
  SMAN_D_ROOMNHTLREVNET_Y         NUMBER(30,4)        NULL,  
  SMAN_D_FBREVGROSS_D             NUMBER(30,4)        NULL,
  SMAN_D_FBNHTLREVGROSS_D         NUMBER(30,4)        NULL,
  SMAN_D_FBREVNET_D               NUMBER(30,4)        NULL,
  SMAN_D_FBNHTLREVNET_D           NUMBER(30,4)        NULL,
  SMAN_D_FBREVGROSS_M             NUMBER(30,4)        NULL,
  SMAN_D_FBNHTLREVGROSS_M         NUMBER(30,4)        NULL,
  SMAN_D_FBREVNET_M               NUMBER(30,4)        NULL,
  SMAN_D_FBNHTLREVNET_M           NUMBER(30,4)        NULL,
  SMAN_D_FBREVGROSS_Y             NUMBER(30,4)        NULL,
  SMAN_D_FBNHTLREVGROSS_Y         NUMBER(30,4)        NULL,
  SMAN_D_FBREVNET_Y               NUMBER(30,4)        NULL,
  SMAN_D_FBNHTLREVNET_Y           NUMBER(30,4)        NULL,
  SMAN_D_MINIREVGROSS_D           NUMBER(30,4)        NULL,
  SMAN_D_MININHTLREVGROSS_D       NUMBER(30,4)        NULL,
  SMAN_D_TELEREVGROSS_D           NUMBER(30,4)        NULL,
  SMAN_D_TELENHTLREVGROSS_D       NUMBER(30,4)        NULL,
  SMAN_D_MISCREVGROSS_D           NUMBER(30,4)        NULL,
  SMAN_D_MISCNHTLREVGROSS_D       NUMBER(30,4)        NULL,
  SMAN_D_NOSTATREVGROSS_D         NUMBER(30,4)        NULL,
  SMAN_D_NOSTATNHTLREVGROSS_D     NUMBER(30,4)        NULL,
  SMAN_D_MINIREVGROSS_M           NUMBER(30,4)        NULL,
  SMAN_D_MININHTLREVGROSS_M       NUMBER(30,4)        NULL,
  SMAN_D_TELEREVGROSS_M           NUMBER(30,4)        NULL,
  SMAN_D_TELENHTLREVGROSS_M       NUMBER(30,4)        NULL,
  SMAN_D_MISCREVGROSS_M           NUMBER(30,4)        NULL,
  SMAN_D_MISCNHTLREVGROSS_M       NUMBER(30,4)        NULL,
  SMAN_D_NOSTATREVGROSS_M         NUMBER(30,4)        NULL,
  SMAN_D_NOSTATNHTLREVGROSS_M     NUMBER(30,4)        NULL,
  SMAN_D_MINIREVGROSS_Y           NUMBER(30,4)        NULL,
  SMAN_D_MININHTLREVGROSS_Y       NUMBER(30,4)        NULL,
  SMAN_D_TELEREVGROSS_Y           NUMBER(30,4)        NULL,
  SMAN_D_TELENHTLREVGROSS_Y       NUMBER(30,4)        NULL,
  SMAN_D_MISCREVGROSS_Y           NUMBER(30,4)        NULL,
  SMAN_D_MISCNHTLREVGROSS_Y       NUMBER(30,4)        NULL,
  SMAN_D_NOSTATREVGROSS_Y         NUMBER(30,4)        NULL,
  SMAN_D_NOSTATNHTLREVGROSS_Y     NUMBER(30,4)        NULL,
  SMAN_D_MINIREVNET_D             NUMBER(30,4)        NULL,
  SMAN_D_MININHTLREVNET_D         NUMBER(30,4)        NULL,
  SMAN_D_TELEREVNET_D             NUMBER(30,4)        NULL,
  SMAN_D_TELENHTLREVNET_D         NUMBER(30,4)        NULL,
  SMAN_D_MISCREVNET_D             NUMBER(30,4)        NULL,
  SMAN_D_MISCNHTLREVNET_D         NUMBER(30,4)        NULL,
  SMAN_D_NOSTATREVNET_D           NUMBER(30,4)        NULL,
  SMAN_D_NOSTATNHTLREVNET_D       NUMBER(30,4)        NULL,
  SMAN_D_MINIREVNET_M             NUMBER(30,4)        NULL,
  SMAN_D_MININHTLREVNET_M         NUMBER(30,4)        NULL,
  SMAN_D_TELEREVNET_M             NUMBER(30,4)        NULL,
  SMAN_D_TELENHTLREVNET_M         NUMBER(30,4)        NULL,
  SMAN_D_MISCREVNET_M             NUMBER(30,4)        NULL,
  SMAN_D_MISCNHTLREVNET_M         NUMBER(30,4)        NULL,
  SMAN_D_NOSTATREVNET_M           NUMBER(30,4)        NULL,
  SMAN_D_NOSTATNHTLREVNET_M       NUMBER(30,4)        NULL,
  SMAN_D_MINIREVNET_Y             NUMBER(30,4)        NULL,
  SMAN_D_MININHTLREVNET_Y         NUMBER(30,4)        NULL,
  SMAN_D_TELEREVNET_Y             NUMBER(30,4)        NULL,
  SMAN_D_TELENHTLREVNET_Y         NUMBER(30,4)        NULL,
  SMAN_D_MISCREVNET_Y             NUMBER(30,4)        NULL,
  SMAN_D_MISCNHTLREVNET_Y         NUMBER(30,4)        NULL,
  SMAN_D_NOSTATREVNET_Y           NUMBER(30,4)        NULL,
  SMAN_D_NOSTATNHTLREVNET_Y       NUMBER(30,4)        NULL
);

ALTER TABLE SMAN ADD
(
  SMAN_V_TOTALGROSSREV_D          NUMBER(30,4)        NULL,
  SMAN_V_TOTALGROSSREV_M          NUMBER(30,4)        NULL,
  SMAN_V_TOTALGROSSREV_Y          NUMBER(30,4)        NULL,
  SMAN_V_TOTALNETREV_D            NUMBER(30,4)        NULL,
  SMAN_V_TOTALNETREV_M            NUMBER(30,4)        NULL,
  SMAN_V_TOTALNETREV_Y            NUMBER(30,4)        NULL,
  SMAN_V_PAYMENTS_D               NUMBER(30,4)        NULL,
  SMAN_V_PAYMENTS_M               NUMBER(30,4)        NULL,
  SMAN_V_PAYMENTS_Y               NUMBER(30,4)        NULL,
  SMAN_V_ROOMREVGROSS_D           NUMBER(30,4)        NULL,
  SMAN_V_ROOMREVGROSS_M           NUMBER(30,4)        NULL,
  SMAN_V_ROOMREVGROSS_Y           NUMBER(30,4)        NULL,
  SMAN_V_ROOMREVNET_D             NUMBER(30,4)        NULL,
  SMAN_V_ROOMREVNET_M             NUMBER(30,4)        NULL,
  SMAN_V_ROOMREVNET_Y             NUMBER(30,4)        NULL,
  SMAN_V_TOTALGROSSNHTLREV_D      NUMBER(30,4)        NULL,
  SMAN_V_TOTALGROSSNHTLREV_M      NUMBER(30,4)        NULL,
  SMAN_V_TOTALGROSSNHTLREV_Y      NUMBER(30,4)        NULL,
  SMAN_V_TOTALNETNHTLREV_D        NUMBER(30,4)        NULL,
  SMAN_V_TOTALNETNHTLREV_M        NUMBER(30,4)        NULL,
  SMAN_V_TOTALNETNHTLREV_Y        NUMBER(30,4)        NULL,
  SMAN_V_ROOMNHTLREVGROSS_D       NUMBER(30,4)        NULL,
  SMAN_V_ROOMNHTLREVGROSS_M       NUMBER(30,4)        NULL,
  SMAN_V_ROOMNHTLREVGROSS_Y       NUMBER(30,4)        NULL,
  SMAN_V_ROOMNHTLREVNET_D         NUMBER(30,4)        NULL,
  SMAN_V_ROOMNHTLREVNET_M         NUMBER(30,4)        NULL,
  SMAN_V_ROOMNHTLREVNET_Y         NUMBER(30,4)        NULL,  
  SMAN_V_FBREVGROSS_D             NUMBER(30,4)        NULL,
  SMAN_V_FBNHTLREVGROSS_D         NUMBER(30,4)        NULL,
  SMAN_V_FBREVNET_D               NUMBER(30,4)        NULL,
  SMAN_V_FBNHTLREVNET_D           NUMBER(30,4)        NULL,
  SMAN_V_FBREVGROSS_M             NUMBER(30,4)        NULL,
  SMAN_V_FBNHTLREVGROSS_M         NUMBER(30,4)        NULL,
  SMAN_V_FBREVNET_M               NUMBER(30,4)        NULL,
  SMAN_V_FBNHTLREVNET_M           NUMBER(30,4)        NULL,
  SMAN_V_FBREVGROSS_Y             NUMBER(30,4)        NULL,
  SMAN_V_FBNHTLREVGROSS_Y         NUMBER(30,4)        NULL,
  SMAN_V_FBREVNET_Y               NUMBER(30,4)        NULL,
  SMAN_V_FBNHTLREVNET_Y           NUMBER(30,4)        NULL,
  SMAN_V_MINIREVGROSS_D           NUMBER(30,4)        NULL,
  SMAN_V_MININHTLREVGROSS_D       NUMBER(30,4)        NULL,
  SMAN_V_TELEREVGROSS_D           NUMBER(30,4)        NULL,
  SMAN_V_TELENHTLREVGROSS_D       NUMBER(30,4)        NULL,
  SMAN_V_MISCREVGROSS_D           NUMBER(30,4)        NULL,
  SMAN_V_MISCNHTLREVGROSS_D       NUMBER(30,4)        NULL,
  SMAN_V_NOSTATREVGROSS_D         NUMBER(30,4)        NULL,
  SMAN_V_NOSTATNHTLREVGROSS_D     NUMBER(30,4)        NULL,
  SMAN_V_MINIREVGROSS_M           NUMBER(30,4)        NULL,
  SMAN_V_MININHTLREVGROSS_M       NUMBER(30,4)        NULL,
  SMAN_V_TELEREVGROSS_M           NUMBER(30,4)        NULL,
  SMAN_V_TELENHTLREVGROSS_M       NUMBER(30,4)        NULL,
  SMAN_V_MISCREVGROSS_M           NUMBER(30,4)        NULL,
  SMAN_V_MISCNHTLREVGROSS_M       NUMBER(30,4)        NULL,
  SMAN_V_NOSTATREVGROSS_M         NUMBER(30,4)        NULL,
  SMAN_V_NOSTATNHTLREVGROSS_M     NUMBER(30,4)        NULL,
  SMAN_V_MINIREVGROSS_Y           NUMBER(30,4)        NULL,
  SMAN_V_MININHTLREVGROSS_Y       NUMBER(30,4)        NULL,
  SMAN_V_TELEREVGROSS_Y           NUMBER(30,4)        NULL,
  SMAN_V_TELENHTLREVGROSS_Y       NUMBER(30,4)        NULL,
  SMAN_V_MISCREVGROSS_Y           NUMBER(30,4)        NULL,
  SMAN_V_MISCNHTLREVGROSS_Y       NUMBER(30,4)        NULL,
  SMAN_V_NOSTATREVGROSS_Y         NUMBER(30,4)        NULL,
  SMAN_V_NOSTATNHTLREVGROSS_Y     NUMBER(30,4)        NULL,
  SMAN_V_MINIREVNET_D             NUMBER(30,4)        NULL,
  SMAN_V_MININHTLREVNET_D         NUMBER(30,4)        NULL,
  SMAN_V_TELEREVNET_D             NUMBER(30,4)        NULL,
  SMAN_V_TELENHTLREVNET_D         NUMBER(30,4)        NULL,
  SMAN_V_MISCREVNET_D             NUMBER(30,4)        NULL,
  SMAN_V_MISCNHTLREVNET_D         NUMBER(30,4)        NULL,
  SMAN_V_NOSTATREVNET_D           NUMBER(30,4)        NULL,
  SMAN_V_NOSTATNHTLREVNET_D       NUMBER(30,4)        NULL,
  SMAN_V_MINIREVNET_M             NUMBER(30,4)        NULL,
  SMAN_V_MININHTLREVNET_M         NUMBER(30,4)        NULL,
  SMAN_V_TELEREVNET_M             NUMBER(30,4)        NULL,
  SMAN_V_TELENHTLREVNET_M         NUMBER(30,4)        NULL,
  SMAN_V_MISCREVNET_M             NUMBER(30,4)        NULL,
  SMAN_V_MISCNHTLREVNET_M         NUMBER(30,4)        NULL,
  SMAN_V_NOSTATREVNET_M           NUMBER(30,4)        NULL,
  SMAN_V_NOSTATNHTLREVNET_M       NUMBER(30,4)        NULL,
  SMAN_V_MINIREVNET_Y             NUMBER(30,4)        NULL,
  SMAN_V_MININHTLREVNET_Y         NUMBER(30,4)        NULL,
  SMAN_V_TELEREVNET_Y             NUMBER(30,4)        NULL,
  SMAN_V_TELENHTLREVNET_Y         NUMBER(30,4)        NULL,
  SMAN_V_MISCREVNET_Y             NUMBER(30,4)        NULL,
  SMAN_V_MISCNHTLREVNET_Y         NUMBER(30,4)        NULL,
  SMAN_V_NOSTATREVNET_Y           NUMBER(30,4)        NULL,
  SMAN_V_NOSTATNHTLREVNET_Y       NUMBER(30,4)        NULL
);

ALTER TABLE SMAN ADD
(
  SMAN_D_COMPANY_REV_GROSS_D      NUMBER(30,4)        NULL,
  SMAN_D_COMPANY_REV_GROSS_M      NUMBER(30,4)        NULL,
  SMAN_D_COMPANY_REV_GROSS_Y      NUMBER(30,4)        NULL,
  SMAN_D_AGENT_REV_GROSS_D        NUMBER(30,4)        NULL,
  SMAN_D_AGENT_REV_GROSS_M        NUMBER(30,4)        NULL,
  SMAN_D_AGENT_REV_GROSS_Y        NUMBER(30,4)        NULL,
  SMAN_D_IND_REV_GROSS_D          NUMBER(30,4)        NULL,
  SMAN_D_IND_REV_GROSS_M          NUMBER(30,4)        NULL,
  SMAN_D_IND_REV_GROSS_Y          NUMBER(30,4)        NULL,  
  SMAN_D_COMPANY_NHTLREV_GROSS_D  NUMBER(30,4)        NULL,
  SMAN_D_COMPANY_NHTLREV_GROSS_M  NUMBER(30,4)        NULL,
  SMAN_D_COMPANY_NHTLREV_GROSS_Y  NUMBER(30,4)        NULL,
  SMAN_D_AGENT_NHTLREV_GROSS_D    NUMBER(30,4)        NULL,
  SMAN_D_AGENT_NHTLREV_GROSS_M    NUMBER(30,4)        NULL,
  SMAN_D_AGENT_NHTLREV_GROSS_Y    NUMBER(30,4)        NULL,
  SMAN_D_IND_NHTLREV_GROSS_D      NUMBER(30,4)        NULL,
  SMAN_D_IND_NHTLREV_GROSS_M      NUMBER(30,4)        NULL,
  SMAN_D_IND_NHTLREV_GROSS_Y      NUMBER(30,4)        NULL, 
  SMAN_D_SOURCE_REV_GROSS_D       NUMBER(30,4)        NULL,
  SMAN_D_SOURCE_REV_GROSS_M       NUMBER(30,4)        NULL,
  SMAN_D_SOURCE_REV_GROSS_Y       NUMBER(30,4)        NULL,
  SMAN_D_BOOKER_REV_GROSS_D       NUMBER(30,4)        NULL,
  SMAN_D_BOOKER_REV_GROSS_M       NUMBER(30,4)        NULL,
  SMAN_D_BOOKER_REV_GROSS_Y       NUMBER(30,4)        NULL,
  SMAN_D_VENDOR_REV_GROSS_D       NUMBER(30,4)        NULL,
  SMAN_D_VENDOR_REV_GROSS_M       NUMBER(30,4)        NULL,
  SMAN_D_VENDOR_REV_GROSS_Y       NUMBER(30,4)        NULL,
  SMAN_D_MPLANER_REV_GROSS_D      NUMBER(30,4)        NULL,
  SMAN_D_MPLANER_REV_GROSS_M      NUMBER(30,4)        NULL,
  SMAN_D_MPLANER_REV_GROSS_Y      NUMBER(30,4)        NULL,
  SMAN_D_SOURCE_NHTLREV_GROSS_D   NUMBER(30,4)        NULL,
  SMAN_D_SOURCE_NHTLREV_GROSS_M   NUMBER(30,4)        NULL,
  SMAN_D_SOURCE_NHTLREV_GROSS_Y   NUMBER(30,4)        NULL,
  SMAN_D_BOOKER_NHTLREV_GROSS_D   NUMBER(30,4)        NULL,
  SMAN_D_BOOKER_NHTLREV_GROSS_M   NUMBER(30,4)        NULL,
  SMAN_D_BOOKER_NHTLREV_GROSS_Y   NUMBER(30,4)        NULL,
  SMAN_D_VENDOR_NHTLREV_GROSS_D   NUMBER(30,4)        NULL,
  SMAN_D_VENDOR_NHTLREV_GROSS_M   NUMBER(30,4)        NULL,
  SMAN_D_VENDOR_NHTLREV_GROSS_Y   NUMBER(30,4)        NULL,
  SMAN_D_MPLANER_NHTLREV_GROSS_D  NUMBER(30,4)        NULL,
  SMAN_D_MPLANER_NHTLREV_GROSS_M  NUMBER(30,4)        NULL,
  SMAN_D_MPLANER_NHTLREV_GROSS_Y  NUMBER(30,4)        NULL
);

ALTER TABLE SMAN ADD
(
  SMAN_V_COMPANY_REV_GROSS_D      NUMBER(30,4)        NULL,
  SMAN_V_COMPANY_REV_GROSS_M      NUMBER(30,4)        NULL,
  SMAN_V_COMPANY_REV_GROSS_Y      NUMBER(30,4)        NULL,
  SMAN_V_AGENT_REV_GROSS_D        NUMBER(30,4)        NULL,
  SMAN_V_AGENT_REV_GROSS_M        NUMBER(30,4)        NULL,
  SMAN_V_AGENT_REV_GROSS_Y        NUMBER(30,4)        NULL,
  SMAN_V_IND_REV_GROSS_D          NUMBER(30,4)        NULL,
  SMAN_V_IND_REV_GROSS_M          NUMBER(30,4)        NULL,
  SMAN_V_IND_REV_GROSS_Y          NUMBER(30,4)        NULL,  
  SMAN_V_COMPANY_NHTLREV_GROSS_D  NUMBER(30,4)        NULL,
  SMAN_V_COMPANY_NHTLREV_GROSS_M  NUMBER(30,4)        NULL,
  SMAN_V_COMPANY_NHTLREV_GROSS_Y  NUMBER(30,4)        NULL,
  SMAN_V_AGENT_NHTLREV_GROSS_D    NUMBER(30,4)        NULL,
  SMAN_V_AGENT_NHTLREV_GROSS_M    NUMBER(30,4)        NULL,
  SMAN_V_AGENT_NHTLREV_GROSS_Y    NUMBER(30,4)        NULL,
  SMAN_V_IND_NHTLREV_GROSS_D      NUMBER(30,4)        NULL,
  SMAN_V_IND_NHTLREV_GROSS_M      NUMBER(30,4)        NULL,
  SMAN_V_IND_NHTLREV_GROSS_Y      NUMBER(30,4)        NULL, 
  SMAN_V_SOURCE_REV_GROSS_D       NUMBER(30,4)        NULL,
  SMAN_V_SOURCE_REV_GROSS_M       NUMBER(30,4)        NULL,
  SMAN_V_SOURCE_REV_GROSS_Y       NUMBER(30,4)        NULL,
  SMAN_V_BOOKER_REV_GROSS_D       NUMBER(30,4)        NULL,
  SMAN_V_BOOKER_REV_GROSS_M       NUMBER(30,4)        NULL,
  SMAN_V_BOOKER_REV_GROSS_Y       NUMBER(30,4)        NULL,
  SMAN_V_VENDOR_REV_GROSS_D       NUMBER(30,4)        NULL,
  SMAN_V_VENDOR_REV_GROSS_M       NUMBER(30,4)        NULL,
  SMAN_V_VENDOR_REV_GROSS_Y       NUMBER(30,4)        NULL,
  SMAN_V_MPLANER_REV_GROSS_D      NUMBER(30,4)        NULL,
  SMAN_V_MPLANER_REV_GROSS_M      NUMBER(30,4)        NULL,
  SMAN_V_MPLANER_REV_GROSS_Y      NUMBER(30,4)        NULL,
  SMAN_V_SOURCE_NHTLREV_GROSS_D   NUMBER(30,4)        NULL,
  SMAN_V_SOURCE_NHTLREV_GROSS_M   NUMBER(30,4)        NULL,
  SMAN_V_SOURCE_NHTLREV_GROSS_Y   NUMBER(30,4)        NULL,
  SMAN_V_BOOKER_NHTLREV_GROSS_D   NUMBER(30,4)        NULL,
  SMAN_V_BOOKER_NHTLREV_GROSS_M   NUMBER(30,4)        NULL,
  SMAN_V_BOOKER_NHTLREV_GROSS_Y   NUMBER(30,4)        NULL,
  SMAN_V_VENDOR_NHTLREV_GROSS_D   NUMBER(30,4)        NULL,
  SMAN_V_VENDOR_NHTLREV_GROSS_M   NUMBER(30,4)        NULL,
  SMAN_V_VENDOR_NHTLREV_GROSS_Y   NUMBER(30,4)        NULL,
  SMAN_V_MPLANER_NHTLREV_GROSS_D  NUMBER(30,4)        NULL,
  SMAN_V_MPLANER_NHTLREV_GROSS_M  NUMBER(30,4)        NULL,
  SMAN_V_MPLANER_NHTLREV_GROSS_Y  NUMBER(30,4)        NULL
);  

ALTER TABLE SMAD ADD
(
  SMAD_D_TOTALGROSSREV_D          NUMBER(30,4)        NULL,
  SMAD_D_TOTALGROSSREV_M          NUMBER(30,4)        NULL,
  SMAD_D_TOTALGROSSREV_Y          NUMBER(30,4)        NULL,
  SMAD_D_TOTALNETREV_D            NUMBER(30,4)        NULL,
  SMAD_D_TOTALNETREV_M            NUMBER(30,4)        NULL,
  SMAD_D_TOTALNETREV_Y            NUMBER(30,4)        NULL,
  SMAD_D_PAYMENTS_D               NUMBER(30,4)        NULL,
  SMAD_D_PAYMENTS_M               NUMBER(30,4)        NULL,
  SMAD_D_PAYMENTS_Y               NUMBER(30,4)        NULL,
  SMAD_D_ROOMREVGROSS_D           NUMBER(30,4)        NULL,
  SMAD_D_ROOMREVGROSS_M           NUMBER(30,4)        NULL,
  SMAD_D_ROOMREVGROSS_Y           NUMBER(30,4)        NULL,
  SMAD_D_ROOMREVNET_D             NUMBER(30,4)        NULL,
  SMAD_D_ROOMREVNET_M             NUMBER(30,4)        NULL,
  SMAD_D_ROOMREVNET_Y             NUMBER(30,4)        NULL,
  SMAD_D_TOTALGROSSNHTLREV_D      NUMBER(30,4)        NULL,
  SMAD_D_TOTALGROSSNHTLREV_M      NUMBER(30,4)        NULL,
  SMAD_D_TOTALGROSSNHTLREV_Y      NUMBER(30,4)        NULL,
  SMAD_D_TOTALNETNHTLREV_D        NUMBER(30,4)        NULL,
  SMAD_D_TOTALNETNHTLREV_M        NUMBER(30,4)        NULL,
  SMAD_D_TOTALNETNHTLREV_Y        NUMBER(30,4)        NULL,
  SMAD_D_ROOMNHTLREVGROSS_D       NUMBER(30,4)        NULL,
  SMAD_D_ROOMNHTLREVGROSS_M       NUMBER(30,4)        NULL,
  SMAD_D_ROOMNHTLREVGROSS_Y       NUMBER(30,4)        NULL,
  SMAD_D_ROOMNHTLREVNET_D         NUMBER(30,4)        NULL,
  SMAD_D_ROOMNHTLREVNET_M         NUMBER(30,4)        NULL,
  SMAD_D_ROOMNHTLREVNET_Y         NUMBER(30,4)        NULL,  
  SMAD_D_FBREVGROSS_D             NUMBER(30,4)        NULL,
  SMAD_D_FBNHTLREVGROSS_D         NUMBER(30,4)        NULL,
  SMAD_D_FBREVNET_D               NUMBER(30,4)        NULL,
  SMAD_D_FBNHTLREVNET_D           NUMBER(30,4)        NULL,
  SMAD_D_FBREVGROSS_M             NUMBER(30,4)        NULL,
  SMAD_D_FBNHTLREVGROSS_M         NUMBER(30,4)        NULL,
  SMAD_D_FBREVNET_M               NUMBER(30,4)        NULL,
  SMAD_D_FBNHTLREVNET_M           NUMBER(30,4)        NULL,
  SMAD_D_FBREVGROSS_Y             NUMBER(30,4)        NULL,
  SMAD_D_FBNHTLREVGROSS_Y         NUMBER(30,4)        NULL,
  SMAD_D_FBREVNET_Y               NUMBER(30,4)        NULL,
  SMAD_D_FBNHTLREVNET_Y           NUMBER(30,4)        NULL,
  SMAD_D_MINIREVGROSS_D           NUMBER(30,4)        NULL,
  SMAD_D_MININHTLREVGROSS_D       NUMBER(30,4)        NULL,
  SMAD_D_TELEREVGROSS_D           NUMBER(30,4)        NULL,
  SMAD_D_TELENHTLREVGROSS_D       NUMBER(30,4)        NULL,
  SMAD_D_MISCREVGROSS_D           NUMBER(30,4)        NULL,
  SMAD_D_MISCNHTLREVGROSS_D       NUMBER(30,4)        NULL,
  SMAD_D_NOSTATREVGROSS_D         NUMBER(30,4)        NULL,
  SMAD_D_NOSTATNHTLREVGROSS_D     NUMBER(30,4)        NULL,
  SMAD_D_MINIREVGROSS_M           NUMBER(30,4)        NULL,
  SMAD_D_MININHTLREVGROSS_M       NUMBER(30,4)        NULL,
  SMAD_D_TELEREVGROSS_M           NUMBER(30,4)        NULL,
  SMAD_D_TELENHTLREVGROSS_M       NUMBER(30,4)        NULL,
  SMAD_D_MISCREVGROSS_M           NUMBER(30,4)        NULL,
  SMAD_D_MISCNHTLREVGROSS_M       NUMBER(30,4)        NULL,
  SMAD_D_NOSTATREVGROSS_M         NUMBER(30,4)        NULL,
  SMAD_D_NOSTATNHTLREVGROSS_M     NUMBER(30,4)        NULL,
  SMAD_D_MINIREVGROSS_Y           NUMBER(30,4)        NULL,
  SMAD_D_MININHTLREVGROSS_Y       NUMBER(30,4)        NULL,
  SMAD_D_TELEREVGROSS_Y           NUMBER(30,4)        NULL,
  SMAD_D_TELENHTLREVGROSS_Y       NUMBER(30,4)        NULL,
  SMAD_D_MISCREVGROSS_Y           NUMBER(30,4)        NULL,
  SMAD_D_MISCNHTLREVGROSS_Y       NUMBER(30,4)        NULL,
  SMAD_D_NOSTATREVGROSS_Y         NUMBER(30,4)        NULL,
  SMAD_D_NOSTATNHTLREVGROSS_Y     NUMBER(30,4)        NULL,
  SMAD_D_MINIREVNET_D             NUMBER(30,4)        NULL,
  SMAD_D_MININHTLREVNET_D         NUMBER(30,4)        NULL,
  SMAD_D_TELEREVNET_D             NUMBER(30,4)        NULL,
  SMAD_D_TELENHTLREVNET_D         NUMBER(30,4)        NULL,
  SMAD_D_MISCREVNET_D             NUMBER(30,4)        NULL,
  SMAD_D_MISCNHTLREVNET_D         NUMBER(30,4)        NULL,
  SMAD_D_NOSTATREVNET_D           NUMBER(30,4)        NULL,
  SMAD_D_NOSTATNHTLREVNET_D       NUMBER(30,4)        NULL,
  SMAD_D_MINIREVNET_M             NUMBER(30,4)        NULL,
  SMAD_D_MININHTLREVNET_M         NUMBER(30,4)        NULL,
  SMAD_D_TELEREVNET_M             NUMBER(30,4)        NULL,
  SMAD_D_TELENHTLREVNET_M         NUMBER(30,4)        NULL,
  SMAD_D_MISCREVNET_M             NUMBER(30,4)        NULL,
  SMAD_D_MISCNHTLREVNET_M         NUMBER(30,4)        NULL,
  SMAD_D_NOSTATREVNET_M           NUMBER(30,4)        NULL,
  SMAD_D_NOSTATNHTLREVNET_M       NUMBER(30,4)        NULL,
  SMAD_D_MINIREVNET_Y             NUMBER(30,4)        NULL,
  SMAD_D_MININHTLREVNET_Y         NUMBER(30,4)        NULL,
  SMAD_D_TELEREVNET_Y             NUMBER(30,4)        NULL,
  SMAD_D_TELENHTLREVNET_Y         NUMBER(30,4)        NULL,
  SMAD_D_MISCREVNET_Y             NUMBER(30,4)        NULL,
  SMAD_D_MISCNHTLREVNET_Y         NUMBER(30,4)        NULL,
  SMAD_D_NOSTATREVNET_Y           NUMBER(30,4)        NULL,
  SMAD_D_NOSTATNHTLREVNET_Y       NUMBER(30,4)        NULL
);

ALTER TABLE SMAD ADD
(
  SMAD_V_TOTALGROSSREV_D          NUMBER(30,4)        NULL,
  SMAD_V_TOTALGROSSREV_M          NUMBER(30,4)        NULL,
  SMAD_V_TOTALGROSSREV_Y          NUMBER(30,4)        NULL,
  SMAD_V_TOTALNETREV_D            NUMBER(30,4)        NULL,
  SMAD_V_TOTALNETREV_M            NUMBER(30,4)        NULL,
  SMAD_V_TOTALNETREV_Y            NUMBER(30,4)        NULL,
  SMAD_V_PAYMENTS_D               NUMBER(30,4)        NULL,
  SMAD_V_PAYMENTS_M               NUMBER(30,4)        NULL,
  SMAD_V_PAYMENTS_Y               NUMBER(30,4)        NULL,
  SMAD_V_ROOMREVGROSS_D           NUMBER(30,4)        NULL,
  SMAD_V_ROOMREVGROSS_M           NUMBER(30,4)        NULL,
  SMAD_V_ROOMREVGROSS_Y           NUMBER(30,4)        NULL,
  SMAD_V_ROOMREVNET_D             NUMBER(30,4)        NULL,
  SMAD_V_ROOMREVNET_M             NUMBER(30,4)        NULL,
  SMAD_V_ROOMREVNET_Y             NUMBER(30,4)        NULL,
  SMAD_V_TOTALGROSSNHTLREV_D      NUMBER(30,4)        NULL,
  SMAD_V_TOTALGROSSNHTLREV_M      NUMBER(30,4)        NULL,
  SMAD_V_TOTALGROSSNHTLREV_Y      NUMBER(30,4)        NULL,
  SMAD_V_TOTALNETNHTLREV_D        NUMBER(30,4)        NULL,
  SMAD_V_TOTALNETNHTLREV_M        NUMBER(30,4)        NULL,
  SMAD_V_TOTALNETNHTLREV_Y        NUMBER(30,4)        NULL,
  SMAD_V_ROOMNHTLREVGROSS_D       NUMBER(30,4)        NULL,
  SMAD_V_ROOMNHTLREVGROSS_M       NUMBER(30,4)        NULL,
  SMAD_V_ROOMNHTLREVGROSS_Y       NUMBER(30,4)        NULL,
  SMAD_V_ROOMNHTLREVNET_D         NUMBER(30,4)        NULL,
  SMAD_V_ROOMNHTLREVNET_M         NUMBER(30,4)        NULL,
  SMAD_V_ROOMNHTLREVNET_Y         NUMBER(30,4)        NULL,  
  SMAD_V_FBREVGROSS_D             NUMBER(30,4)        NULL,
  SMAD_V_FBNHTLREVGROSS_D         NUMBER(30,4)        NULL,
  SMAD_V_FBREVNET_D               NUMBER(30,4)        NULL,
  SMAD_V_FBNHTLREVNET_D           NUMBER(30,4)        NULL,
  SMAD_V_FBREVGROSS_M             NUMBER(30,4)        NULL,
  SMAD_V_FBNHTLREVGROSS_M         NUMBER(30,4)        NULL,
  SMAD_V_FBREVNET_M               NUMBER(30,4)        NULL,
  SMAD_V_FBNHTLREVNET_M           NUMBER(30,4)        NULL,
  SMAD_V_FBREVGROSS_Y             NUMBER(30,4)        NULL,
  SMAD_V_FBNHTLREVGROSS_Y         NUMBER(30,4)        NULL,
  SMAD_V_FBREVNET_Y               NUMBER(30,4)        NULL,
  SMAD_V_FBNHTLREVNET_Y           NUMBER(30,4)        NULL,
  SMAD_V_MINIREVGROSS_D           NUMBER(30,4)        NULL,
  SMAD_V_MININHTLREVGROSS_D       NUMBER(30,4)        NULL,
  SMAD_V_TELEREVGROSS_D           NUMBER(30,4)        NULL,
  SMAD_V_TELENHTLREVGROSS_D       NUMBER(30,4)        NULL,
  SMAD_V_MISCREVGROSS_D           NUMBER(30,4)        NULL,
  SMAD_V_MISCNHTLREVGROSS_D       NUMBER(30,4)        NULL,
  SMAD_V_NOSTATREVGROSS_D         NUMBER(30,4)        NULL,
  SMAD_V_NOSTATNHTLREVGROSS_D     NUMBER(30,4)        NULL,
  SMAD_V_MINIREVGROSS_M           NUMBER(30,4)        NULL,
  SMAD_V_MININHTLREVGROSS_M       NUMBER(30,4)        NULL,
  SMAD_V_TELEREVGROSS_M           NUMBER(30,4)        NULL,
  SMAD_V_TELENHTLREVGROSS_M       NUMBER(30,4)        NULL,
  SMAD_V_MISCREVGROSS_M           NUMBER(30,4)        NULL,
  SMAD_V_MISCNHTLREVGROSS_M       NUMBER(30,4)        NULL,
  SMAD_V_NOSTATREVGROSS_M         NUMBER(30,4)        NULL,
  SMAD_V_NOSTATNHTLREVGROSS_M     NUMBER(30,4)        NULL,
  SMAD_V_MINIREVGROSS_Y           NUMBER(30,4)        NULL,
  SMAD_V_MININHTLREVGROSS_Y       NUMBER(30,4)        NULL,
  SMAD_V_TELEREVGROSS_Y           NUMBER(30,4)        NULL,
  SMAD_V_TELENHTLREVGROSS_Y       NUMBER(30,4)        NULL,
  SMAD_V_MISCREVGROSS_Y           NUMBER(30,4)        NULL,
  SMAD_V_MISCNHTLREVGROSS_Y       NUMBER(30,4)        NULL,
  SMAD_V_NOSTATREVGROSS_Y         NUMBER(30,4)        NULL,
  SMAD_V_NOSTATNHTLREVGROSS_Y     NUMBER(30,4)        NULL,
  SMAD_V_MINIREVNET_D             NUMBER(30,4)        NULL,
  SMAD_V_MININHTLREVNET_D         NUMBER(30,4)        NULL,
  SMAD_V_TELEREVNET_D             NUMBER(30,4)        NULL,
  SMAD_V_TELENHTLREVNET_D         NUMBER(30,4)        NULL,
  SMAD_V_MISCREVNET_D             NUMBER(30,4)        NULL,
  SMAD_V_MISCNHTLREVNET_D         NUMBER(30,4)        NULL,
  SMAD_V_NOSTATREVNET_D           NUMBER(30,4)        NULL,
  SMAD_V_NOSTATNHTLREVNET_D       NUMBER(30,4)        NULL,
  SMAD_V_MINIREVNET_M             NUMBER(30,4)        NULL,
  SMAD_V_MININHTLREVNET_M         NUMBER(30,4)        NULL,
  SMAD_V_TELEREVNET_M             NUMBER(30,4)        NULL,
  SMAD_V_TELENHTLREVNET_M         NUMBER(30,4)        NULL,
  SMAD_V_MISCREVNET_M             NUMBER(30,4)        NULL,
  SMAD_V_MISCNHTLREVNET_M         NUMBER(30,4)        NULL,
  SMAD_V_NOSTATREVNET_M           NUMBER(30,4)        NULL,
  SMAD_V_NOSTATNHTLREVNET_M       NUMBER(30,4)        NULL,
  SMAD_V_MINIREVNET_Y             NUMBER(30,4)        NULL,
  SMAD_V_MININHTLREVNET_Y         NUMBER(30,4)        NULL,
  SMAD_V_TELEREVNET_Y             NUMBER(30,4)        NULL,
  SMAD_V_TELENHTLREVNET_Y         NUMBER(30,4)        NULL,
  SMAD_V_MISCREVNET_Y             NUMBER(30,4)        NULL,
  SMAD_V_MISCNHTLREVNET_Y         NUMBER(30,4)        NULL,
  SMAD_V_NOSTATREVNET_Y           NUMBER(30,4)        NULL,
  SMAD_V_NOSTATNHTLREVNET_Y       NUMBER(30,4)        NULL
);

ALTER TABLE SMAD ADD
(
  SMAD_D_COMPANY_REV_GROSS_D      NUMBER(30,4)        NULL,
  SMAD_D_COMPANY_REV_GROSS_M      NUMBER(30,4)        NULL,
  SMAD_D_COMPANY_REV_GROSS_Y      NUMBER(30,4)        NULL,
  SMAD_D_AGENT_REV_GROSS_D        NUMBER(30,4)        NULL,
  SMAD_D_AGENT_REV_GROSS_M        NUMBER(30,4)        NULL,
  SMAD_D_AGENT_REV_GROSS_Y        NUMBER(30,4)        NULL,
  SMAD_D_IND_REV_GROSS_D          NUMBER(30,4)        NULL,
  SMAD_D_IND_REV_GROSS_M          NUMBER(30,4)        NULL,
  SMAD_D_IND_REV_GROSS_Y          NUMBER(30,4)        NULL,  
  SMAD_D_COMPANY_NHTLREV_GROSS_D  NUMBER(30,4)        NULL,
  SMAD_D_COMPANY_NHTLREV_GROSS_M  NUMBER(30,4)        NULL,
  SMAD_D_COMPANY_NHTLREV_GROSS_Y  NUMBER(30,4)        NULL,
  SMAD_D_AGENT_NHTLREV_GROSS_D    NUMBER(30,4)        NULL,
  SMAD_D_AGENT_NHTLREV_GROSS_M    NUMBER(30,4)        NULL,
  SMAD_D_AGENT_NHTLREV_GROSS_Y    NUMBER(30,4)        NULL,
  SMAD_D_IND_NHTLREV_GROSS_D      NUMBER(30,4)        NULL,
  SMAD_D_IND_NHTLREV_GROSS_M      NUMBER(30,4)        NULL,
  SMAD_D_IND_NHTLREV_GROSS_Y      NUMBER(30,4)        NULL, 
  SMAD_D_SOURCE_REV_GROSS_D       NUMBER(30,4)        NULL,
  SMAD_D_SOURCE_REV_GROSS_M       NUMBER(30,4)        NULL,
  SMAD_D_SOURCE_REV_GROSS_Y       NUMBER(30,4)        NULL,
  SMAD_D_BOOKER_REV_GROSS_D       NUMBER(30,4)        NULL,
  SMAD_D_BOOKER_REV_GROSS_M       NUMBER(30,4)        NULL,
  SMAD_D_BOOKER_REV_GROSS_Y       NUMBER(30,4)        NULL,
  SMAD_D_VENDOR_REV_GROSS_D       NUMBER(30,4)        NULL,
  SMAD_D_VENDOR_REV_GROSS_M       NUMBER(30,4)        NULL,
  SMAD_D_VENDOR_REV_GROSS_Y       NUMBER(30,4)        NULL,
  SMAD_D_MPLANER_REV_GROSS_D      NUMBER(30,4)        NULL,
  SMAD_D_MPLANER_REV_GROSS_M      NUMBER(30,4)        NULL,
  SMAD_D_MPLANER_REV_GROSS_Y      NUMBER(30,4)        NULL,
  SMAD_D_SOURCE_NHTLREV_GROSS_D   NUMBER(30,4)        NULL,
  SMAD_D_SOURCE_NHTLREV_GROSS_M   NUMBER(30,4)        NULL,
  SMAD_D_SOURCE_NHTLREV_GROSS_Y   NUMBER(30,4)        NULL,
  SMAD_D_BOOKER_NHTLREV_GROSS_D   NUMBER(30,4)        NULL,
  SMAD_D_BOOKER_NHTLREV_GROSS_M   NUMBER(30,4)        NULL,
  SMAD_D_BOOKER_NHTLREV_GROSS_Y   NUMBER(30,4)        NULL,
  SMAD_D_VENDOR_NHTLREV_GROSS_D   NUMBER(30,4)        NULL,
  SMAD_D_VENDOR_NHTLREV_GROSS_M   NUMBER(30,4)        NULL,
  SMAD_D_VENDOR_NHTLREV_GROSS_Y   NUMBER(30,4)        NULL,
  SMAD_D_MPLANER_NHTLREV_GROSS_D  NUMBER(30,4)        NULL,
  SMAD_D_MPLANER_NHTLREV_GROSS_M  NUMBER(30,4)        NULL,
  SMAD_D_MPLANER_NHTLREV_GROSS_Y  NUMBER(30,4)        NULL
);

ALTER TABLE SMAD ADD
(
  SMAD_V_COMPANY_REV_GROSS_D      NUMBER(30,4)        NULL,
  SMAD_V_COMPANY_REV_GROSS_M      NUMBER(30,4)        NULL,
  SMAD_V_COMPANY_REV_GROSS_Y      NUMBER(30,4)        NULL,
  SMAD_V_AGENT_REV_GROSS_D        NUMBER(30,4)        NULL,
  SMAD_V_AGENT_REV_GROSS_M        NUMBER(30,4)        NULL,
  SMAD_V_AGENT_REV_GROSS_Y        NUMBER(30,4)        NULL,
  SMAD_V_IND_REV_GROSS_D          NUMBER(30,4)        NULL,
  SMAD_V_IND_REV_GROSS_M          NUMBER(30,4)        NULL,
  SMAD_V_IND_REV_GROSS_Y          NUMBER(30,4)        NULL,  
  SMAD_V_COMPANY_NHTLREV_GROSS_D  NUMBER(30,4)        NULL,
  SMAD_V_COMPANY_NHTLREV_GROSS_M  NUMBER(30,4)        NULL,
  SMAD_V_COMPANY_NHTLREV_GROSS_Y  NUMBER(30,4)        NULL,
  SMAD_V_AGENT_NHTLREV_GROSS_D    NUMBER(30,4)        NULL,
  SMAD_V_AGENT_NHTLREV_GROSS_M    NUMBER(30,4)        NULL,
  SMAD_V_AGENT_NHTLREV_GROSS_Y    NUMBER(30,4)        NULL,
  SMAD_V_IND_NHTLREV_GROSS_D      NUMBER(30,4)        NULL,
  SMAD_V_IND_NHTLREV_GROSS_M      NUMBER(30,4)        NULL,
  SMAD_V_IND_NHTLREV_GROSS_Y      NUMBER(30,4)        NULL, 
  SMAD_V_SOURCE_REV_GROSS_D       NUMBER(30,4)        NULL,
  SMAD_V_SOURCE_REV_GROSS_M       NUMBER(30,4)        NULL,
  SMAD_V_SOURCE_REV_GROSS_Y       NUMBER(30,4)        NULL,
  SMAD_V_BOOKER_REV_GROSS_D       NUMBER(30,4)        NULL,
  SMAD_V_BOOKER_REV_GROSS_M       NUMBER(30,4)        NULL,
  SMAD_V_BOOKER_REV_GROSS_Y       NUMBER(30,4)        NULL,
  SMAD_V_VENDOR_REV_GROSS_D       NUMBER(30,4)        NULL,
  SMAD_V_VENDOR_REV_GROSS_M       NUMBER(30,4)        NULL,
  SMAD_V_VENDOR_REV_GROSS_Y       NUMBER(30,4)        NULL,
  SMAD_V_MPLANER_REV_GROSS_D      NUMBER(30,4)        NULL,
  SMAD_V_MPLANER_REV_GROSS_M      NUMBER(30,4)        NULL,
  SMAD_V_MPLANER_REV_GROSS_Y      NUMBER(30,4)        NULL,
  SMAD_V_SOURCE_NHTLREV_GROSS_D   NUMBER(30,4)        NULL,
  SMAD_V_SOURCE_NHTLREV_GROSS_M   NUMBER(30,4)        NULL,
  SMAD_V_SOURCE_NHTLREV_GROSS_Y   NUMBER(30,4)        NULL,
  SMAD_V_BOOKER_NHTLREV_GROSS_D   NUMBER(30,4)        NULL,
  SMAD_V_BOOKER_NHTLREV_GROSS_M   NUMBER(30,4)        NULL,
  SMAD_V_BOOKER_NHTLREV_GROSS_Y   NUMBER(30,4)        NULL,
  SMAD_V_VENDOR_NHTLREV_GROSS_D   NUMBER(30,4)        NULL,
  SMAD_V_VENDOR_NHTLREV_GROSS_M   NUMBER(30,4)        NULL,
  SMAD_V_VENDOR_NHTLREV_GROSS_Y   NUMBER(30,4)        NULL,
  SMAD_V_MPLANER_NHTLREV_GROSS_D  NUMBER(30,4)        NULL,
  SMAD_V_MPLANER_NHTLREV_GROSS_M  NUMBER(30,4)        NULL,
  SMAD_V_MPLANER_NHTLREV_GROSS_Y  NUMBER(30,4)        NULL
);  

ALTER TABLE COUP ADD COUP_VOID_ZFAC_ID NUMBER(30,0);

COMMENT ON COLUMN COUP.COUP_VOID_ZFAC_ID IS 'Link to FA of the voided voucher';

ALTER TABLE CART ADD CART_TAXWHENUSED NUMBER(1);

COMMENT ON COLUMN CART.CART_TAXWHENUSED IS 'when 1, Tax will be calculated when the voucher is used, not when the voucher is created';

ALTER TABLE COUP ADD COUP_FULLYPAID NUMBER(1);

COMMENT ON COLUMN COUP.COUP_FULLYPAID IS 'when 1, means that voucher has been fully paid (V* voucher management only)';
