CREATE TABLE CustomPurchaseOrders
(
CustomPurchaseOrders_ID INTEGER NOT NULL CONSTRAINT CustomPurchaseOrders_ID PRIMARY KEY,
/*marked as   identifier and key column*/
AD_CLIENT_ID integer NOT NULL,
AD_ORG_ID integer NOT NULL,
ISACTIVE BOOL NOT NULL,
CREATED DATE NOT NULL,
CREATEDBY integer NOT NULL,
UPDATED DATE NOT NULL,
UPDATEDBY integer NOT NULL,
REQUESTOR_NAME VARCHAR(60) NOT NULL,
PURPOSE_OF_PURCHASE VARCHAR(100),
VENDOR_NAME VARCHAR(30) NOT NULL,
CASH_ADVANCE INTEGER NOT NULL,
ACCOUNT_NAME VARCHAR,
ACCOUNT_NUMBER INTEGER,
REIMBURSABLE BOOL,
APPROVED_BY VARCHAR(60),
CUSTOMER VARCHAR(30),
APPROVED_BY_CUSTOMER VARCHAR(60)
);

CREATE TABLE CustomPurchaseOrdersItems
(
CustomPurchaseOrdersItems_ID integer NOT NULL CONSTRAINT CustomPurchaseOrdersItems_ID PRIMARY KEY, /*marked as key column*/
CustomPurchaseOrders_ID integer NOT NULL REFERENCES CustomPurchaseOrders(CustomPurchaseOrders_ID),
/*marked as is secondary key*/
ISACTIVE BOOL NOT NULL,
CREATED DATE NOT NULL,
CREATEDBY integer NOT NULL,
UPDATED DATE NOT NULL,
UPDATEDBY integer NOT NULL,
QTY INTEGER NOT NULL,
UNIT VARCHAR NOT NULL,
DESCRIPTION VARCHAR(60),
ESTIMATED_TOTAL INTEGER NOT NULL,
ACTUAL_TOTAL INTEGER NOT NULL,
CLASS_OF_TRANSACTION VARCHAR(10) NOT NULL,
APPROVAL_NO INTEGER NOT NULL,
CASH_TRANSACTION_NO INTEGER NOT NULL,
CASH_ADVANCE INTEGER  NOT NULL,
TOTAL_EXPENDITURE INTEGER  NOT NULL,
CASH_RETURNED_GIVEN INTEGER,
ENTERED_BY_ACCOUNTING BOOL NOT NULL,
CASHBOOK_DATE DATE NOT NULL,
CASH_ADVANCED_RECEIVED_BY VARCHAR(60),
CLOSING_DATE DATE,
CASH_RETURNED_RECEIVED_BY VARCHAR(60)
);