CREATE COLUMN TABLE "IMCYC"."PHA8" ("AbsEntry" INTEGER CS_INT NOT NULL , "LineID" INTEGER CS_INT NOT NULL , "PhBudget" DECIMAL(21,6) CS_FIXED, "OpenAmtAP" DECIMAL(21,6) CS_FIXED, "InvoicedAP" DECIMAL(21,6) CS_FIXED, "TotalAP" DECIMAL(21,6) CS_FIXED, "TotVarAP" DECIMAL(21,6) CS_FIXED, "VarPercAP" DECIMAL(21,6) CS_FIXED, "AccPhBudg" DECIMAL(21,6) CS_FIXED, "AccOpAmAP" DECIMAL(21,6) CS_FIXED, "AccInvAP" DECIMAL(21,6) CS_FIXED, "AccTotAP" DECIMAL(21,6) CS_FIXED, "AccTVarAP" DECIMAL(21,6) CS_FIXED, "AccVPercAP" DECIMAL(21,6) CS_FIXED, "PoPhAmt" DECIMAL(21,6) CS_FIXED, "OpenAmtAR" DECIMAL(21,6) CS_FIXED, "InvoicedAR" DECIMAL(21,6) CS_FIXED, "TotalAR" DECIMAL(21,6) CS_FIXED, "TotVarAR" DECIMAL(21,6) CS_FIXED, "VarPercAR" DECIMAL(21,6) CS_FIXED, "AccPoPhAmt" DECIMAL(21,6) CS_FIXED, "AccOpAmAR" DECIMAL(21,6) CS_FIXED, "AccInvAR" DECIMAL(21,6) CS_FIXED, "AccTotAR" DECIMAL(21,6) CS_FIXED, "AccTVarAR" DECIMAL(21,6) CS_FIXED, "AccVPercAR" DECIMAL(21,6) CS_FIXED, "ActICCost" DECIMAL(21,6) CS_FIXED, "ActRCCost" DECIMAL(21,6) CS_FIXED, "ActAddCost" DECIMAL(21,6) CS_FIXED, "ActPrCost" DECIMAL(21,6) CS_FIXED, "ActBPrCost" DECIMAL(21,6) CS_FIXED, "TotalVar" DECIMAL(21,6) CS_FIXED, "DueDate" LONGDATE CS_LONGDATE, "CloseDate" LONGDATE CS_LONGDATE, "Overdue" INTEGER CS_INT DEFAULT 0, "Valid" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "LogInstanc" INTEGER CS_INT DEFAULT 0, PRIMARY KEY INVERTED VALUE ("AbsEntry", "LineID")) UNLOAD PRIORITY 5  AUTO MERGE 