SCRIPT BEGIN /* ====================================== */ /* NAME : ReBuildSAPVendormaster.sql */ /* PROJECT : HASP */ /* AUTHOR : Allan Brocklehurst */ /* LAST MOD : 2008-11-14 12:00AM */ /* ====================================== */ /* Last Run : 2008-11-14 1:45:47 PM */ BEGIN EXECUTE IMMEDIATE 'DROP TABLE "SAPVendorMaster_20080919" ' ; EXCEPTION END ; EXECUTE IMMEDIATE 'CREATE TABLE "SAPVendorMaster_20080919" ( "SAPLegacyXref" VARCHAR(20) COLLATE "ANSI", "LegacyVendorCode" VARCHAR(16) COLLATE "ANSI", "Company code" VARCHAR(50) COLLATE "ANSI", "Purchasing Group" VARCHAR(4) COLLATE "ANSI", "Account Group" VARCHAR(4) COLLATE "ANSI", "Name1" VARCHAR(40) COLLATE "ANSI", "Name2" VARCHAR(40) COLLATE "ANSI", "Name3" VARCHAR(40) COLLATE "ANSI", "Name4" VARCHAR(40) COLLATE "ANSI", "Search Term" VARCHAR(20) COLLATE "ANSI", "House Number" VARCHAR(10) COLLATE "ANSI", "Street" VARCHAR(60) COLLATE "ANSI", "Street suppl" VARCHAR(20) COLLATE "ANSI", "Street4" VARCHAR(40) COLLATE "ANSI", "City" VARCHAR(40) COLLATE "ANSI", "Region" VARCHAR(3) COLLATE "ANSI", "PostalCode" VARCHAR(20) COLLATE "ANSI", "Country" VARCHAR(2) COLLATE "ANSI", "PO BOX" VARCHAR(20) COLLATE "ANSI", "ZIP Code" VARCHAR(20) COLLATE "ANSI", "SalesTelephone" VARCHAR(30) COLLATE "ANSI", "Extension" VARCHAR(10) COLLATE "ANSI", "Fax" VARCHAR(30) COLLATE "ANSI", "E-Mail" VARCHAR(241) COLLATE "ANSI", "Standard Communication Method" VARCHAR(3) COLLATE "ANSI", "Corporate Group" VARCHAR(10) COLLATE "ANSI", "Industry" VARCHAR(4) COLLATE "ANSI", "Country of Bank" VARCHAR(3) COLLATE "ANSI", "Bank Key" VARCHAR(15) COLLATE "ANSI", "Bank Account Number" VARCHAR(18) COLLATE "ANSI", "Account Holder Name" VARCHAR(60) COLLATE "ANSI", "Alternate Payee" VARCHAR(50) COLLATE "ANSI", "First Name" VARCHAR(35) COLLATE "ANSI", "Name" VARCHAR(35) COLLATE "ANSI", "Department" VARCHAR(4) COLLATE "ANSI", "Function" VARCHAR(2) COLLATE "ANSI", "Reconciliation Account" VARCHAR(10) COLLATE "ANSI", "Sort Key" VARCHAR(3) COLLATE "ANSI", "Prev_Acct_No" VARCHAR(20) COLLATE "ANSI", "Payment terms" VARCHAR(4) COLLATE "ANSI", "Check Double Invoice" VARCHAR(1) COLLATE "ANSI", "Probable time until check is p" VARCHAR(3) COLLATE "ANSI", "Payment Methods" VARCHAR(20 COLLATE "ANSI"), "Alternate Payee2" VARCHAR(50) COLLATE "ANSI", "Payment block" VARCHAR(1) COLLATE "ANSI", "Acct w vendor" VARCHAR(12) COLLATE "ANSI", "Plant" VARCHAR(50) COLLATE "ANSI", "Order currency" VARCHAR(5) COLLATE "ANSI", "Terms of Payment" VARCHAR(4) COLLATE "ANSI", "INCO Terms Part1" VARCHAR(3) COLLATE "ANSI", "INCO Terms Part2" VARCHAR(28 COLLATE "ANSI"), "Minimum order Value" VARCHAR(13) COLLATE "ANSI", "Sales person" VARCHAR(30) COLLATE "ANSI", "Telephone" VARCHAR(16) COLLATE "ANSI", "Account with Vendor" VARCHAR(12) COLLATE "ANSI", "Automatic Purchase Order" VARCHAR(1) COLLATE "ANSI", "GR-Based Inv_Verification" VARCHAR(1) COLLATE "ANSI", "Service Based Invoice Verifica" VARCHAR(1) COLLATE "ANSI", "Partner Function" VARCHAR(2) COLLATE "ANSI", "Number" VARCHAR(20) COLLATE "ANSI", "DP Flag" VARCHAR(1) COLLATE "ANSI", "Partner Functionx" VARCHAR(1) COLLATE "ANSI", "VendorCode" VARCHAR(50) COLLATE "ANSI", "Accounting Memo" VARCHAR(255) COLLATE "ANSI", "Purchasing texts" VARCHAR(255) COLLATE "ANSI", "PurchasingOrg" VARCHAR(4) COLLATE "ANSI", "SIN" VARCHAR(16) COLLATE "ANSI", "MOID" GUID DEFAULT CURRENT_GUID, "Vend_OID" VARCHAR(38) COLLATE "ANSI", "LastMod" TIMESTAMP DEFAULT CURRENT_TIMESTAMP, "recno" INTEGER, CONSTRAINT "PrimaryKey" PRIMARY KEY ("MOID") ) VERSION 1 UNENCRYPTED INDEX PAGE SIZE 4096 BLOB BLOCK SIZE 512 MAX ROW BUFFER SIZE 32768 MAX INDEX BUFFER SIZE 65536 MAX BLOB BUFFER SIZE 32768'; EXECUTE IMMEDIATE ' CREATE INDEX "LastMod" on "SAPVendorMaster_20080919" "("LastMod") '; EXECUTE IMMEDIATE ' CREATE INDEX "LegacyVendorCode" on "SAPVendorMaster_20080919" "("LegacyVendorCode") '; EXECUTE IMMEDIATE ' CREATE INDEX "Name1" on "SAPVendorMaster_20080919" "("Name1") '; EXECUTE IMMEDIATE ' CREATE INDEX "Account Group" on "SAPVendorMaster_20080919" "("Account Group") '; EXECUTE IMMEDIATE ' CREATE INDEX "VendorPhone" on "SAPVendorMaster_20080919" "("Telephone") '; EXECUTE IMMEDIATE ' CREATE INDEX "Company code" on "SAPVendorMaster_20080919" "("Company code") '; EXECUTE IMMEDIATE ' CREATE INDEX "Mkey" on "SAPVendorMaster_20080919" "("Company code", "LegacyVendorCode") '; EXECUTE IMMEDIATE ' CREATE INDEX "SAPLegacyXref" on "SAPVendorMaster_20080919" "("SAPLegacyXref") '; EXECUTE IMMEDIATE ' CREATE INDEX "SIN" on "SAPVendorMaster_20080919" "("SIN") '; EXECUTE IMMEDIATE ' CREATE INDEX "Plant" on "SAPVendorMaster_20080919" "("Plant") '; EXECUTE IMMEDIATE ' CREATE INDEX "Vend_OID" on " SAPVendorMaster_20080919" "("Vend_OID") '; EXECUTE IMMEDIATE ' CREATE INDEX "recno" on " SAPVendorMaster_20080919" "("recno") '; END