gistfile1.txt

--------------------------------------------------------
--  File created - Tuesday-April-20-2021   
--------------------------------------------------------
--------------------------------------------------------
--  DDL for Table GENERAL_LEDGER_ACCOUNTS
--------------------------------------------------------

  CREATE TABLE "AP"."GENERAL_LEDGER_ACCOUNTS" 
   (    "ACCOUNT_NUMBER" NUMBER, 
    "ACCOUNT_DESCRIPTION" VARCHAR2(50 BYTE) COLLATE "USING_NLS_COMP"
   )  DEFAULT COLLATION "USING_NLS_COMP" SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS" ;
REM INSERTING into AP.GENERAL_LEDGER_ACCOUNTS
SET DEFINE OFF;
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (221,'401K Employee Contributions');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (591,'Accounting');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (200,'Accounts Payable');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (110,'Accounts Receivable');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (569,'Auto Expense');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (568,'Auto License Fee');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (565,'Bank Fees');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (394,'Book Club Royalties');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (181,'Book Development');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (120,'Book Inventory');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (400,'Book Printing Costs');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (403,'Book Production Costs');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (572,'Books, Dues, and Subscriptions');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (520,'Building Lease');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (523,'Building Maintenance');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (551,'Business Forms');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (590,'Business Insurance');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (574,'Business Licenses and Taxes');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (280,'Capital Stock');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (162,'Capitalized Lease');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (536,'Card Deck Advertising');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (100,'Cash');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (610,'Charitable Contributions');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (555,'Collection Agency Fees');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (301,'College Sales');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (310,'Compositing Revenue');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (160,'Computer Equipment');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (527,'Computer Equipment Maintenance');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (306,'Consignment Sales');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (556,'Credit Card Handling');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (540,'Direct Mail Advertising');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (238,'Employee FICA Taxes Payable');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (242,'Employee SDI Taxes Payable');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (239,'Employer FICA Taxes Payable');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (241,'Employer FUTA Taxes Payable');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (243,'Employer UCI Taxes Payable');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (532,'Equipment Rental');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (546,'Exhibits and Shows');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (505,'FICA');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (506,'FUTA');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (630,'Federal Corporation Income Taxes');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (553,'Freight');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (150,'Furniture');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (510,'Group Insurance');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (251,'IBM Credit Corporation Payable');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (528,'IBM Lease');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (235,'Income Taxes Payable');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (620,'Interest Paid to Banks');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (580,'Meals');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (508,'Medicare');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (234,'Medicare Taxes Payable');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (570,'Office Supplies');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (170,'Other Equipment');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (621,'Other Interest');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (589,'Outside Services');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (576,'PC Software');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (550,'Packaging Materials');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (552,'Postage');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (611,'Profit Sharing Contributions');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (300,'Retail Sales');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (290,'Retained Earnings');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (205,'Royalties Payable');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (500,'Salaries and Wages');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (632,'Sales Tax');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (230,'Sales Taxes Payable');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (167,'Software');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (541,'Space Advertising');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (631,'State Corporation Income Taxes');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (237,'State Payroll Taxes Payable');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (522,'Telephone');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (302,'Trade Sales');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (582,'Travel and Accomodations');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (507,'UCI');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (521,'Utilities');
Insert into AP.GENERAL_LEDGER_ACCOUNTS (ACCOUNT_NUMBER,ACCOUNT_DESCRIPTION) values (548,'Web Site Production and Fees');
--------------------------------------------------------
--  DDL for Index GL_ACCOUNTS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "AP"."GL_ACCOUNTS_PK" ON "AP"."GENERAL_LEDGER_ACCOUNTS" ("ACCOUNT_NUMBER") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS" ;
--------------------------------------------------------
--  DDL for Index GL_ACCOUNT_DESCRIPTION_UQ
--------------------------------------------------------

  CREATE UNIQUE INDEX "AP"."GL_ACCOUNT_DESCRIPTION_UQ" ON "AP"."GENERAL_LEDGER_ACCOUNTS" ("ACCOUNT_DESCRIPTION") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS" ;
--------------------------------------------------------
--  Constraints for Table GENERAL_LEDGER_ACCOUNTS
--------------------------------------------------------

  ALTER TABLE "AP"."GENERAL_LEDGER_ACCOUNTS" MODIFY ("ACCOUNT_NUMBER" NOT NULL ENABLE);
  ALTER TABLE "AP"."GENERAL_LEDGER_ACCOUNTS" MODIFY ("ACCOUNT_DESCRIPTION" NOT NULL ENABLE);
  ALTER TABLE "AP"."GENERAL_LEDGER_ACCOUNTS" ADD CONSTRAINT "GL_ACCOUNTS_PK" PRIMARY KEY ("ACCOUNT_NUMBER")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"  ENABLE;
  ALTER TABLE "AP"."GENERAL_LEDGER_ACCOUNTS" ADD CONSTRAINT "GL_ACCOUNT_DESCRIPTION_UQ" UNIQUE ("ACCOUNT_DESCRIPTION")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"  ENABLE;