DROP PROCEDURE
IF
EXISTS proc_initData;
DELIMITER $
CREATE PROCEDURE proc_initData () BEGIN
DECLARE
i INT DEFAULT 1;
WHILE
i <= 100000 DO
INSERT INTO `payment_lines` (
`PAYMENT_HEADER_ID`,
`SEQ_NUM`,
`LINE_TYPE`,
`SUMMARY_FLAG`,
`PAYMENT_CATEGORY`,
`SETTLE_ORDER_ID`,
`REC_HEADER_ID`,
`DOCUMENT_DIRECT`,
`DOCUMENT_CURRENCY_CODE`,
`SOURCE_MATCH_NUM`,
`SOURCE_NUMBER`,
`ALLOCATED_PAYMENT_AMOUNT`,
`ALLOCATED_PAYMENT_BASEAMOUNT`,
`PAYMENT_AMOUNT`,
`WO_STATUS`,
`LINE_WAPPLY_AMOUNT`,
`LINE_WAPPLY_BASEAMOUNT`,
`PAYMENT_REQ_LINE_ID`,
`CROSS_EXCHANGE_RATE`,
`CUST_REC_NUMBER`,
`SETTLE_ORDER_NUM`,
`TENANT_ID`,
`PARTION_VALUE`,
`OBJECT_VERSION_NUMBER`,
`CREATION_DATE`,
`CREATED_BY`,
`LAST_UPDATE_DATE`,
`LAST_UPDATED_BY`,
`ATTRIBUTE_CATEGORY`,
`ATTRIBUTE1`,
`ATTRIBUTE2`,
`ATTRIBUTE3`,
`ATTRIBUTE4`,
`ATTRIBUTE5`,
`ATTRIBUTE6`,
`ATTRIBUTE7`,
`ATTRIBUTE8`,
`ATTRIBUTE9`,
`ATTRIBUTE10`,
`ATTRIBUTE11`,
`ATTRIBUTE12`,
`ATTRIBUTE13`,
`ATTRIBUTE14`,
`ATTRIBUTE15`
)
VALUES
(
3,
1,
'SYSTEM',
NULL,
'PREPAYMENT',
NULL,
NULL,
NULL,
'CNY',
NULL,
NULL,
200.00,
200.00,
200.00,
'U',
200.00,
200.00,
NULL,
NULL,
NULL,
NULL,
0,
NULL,
3,
'2020-08-11 14:40:12',
2,
'2020-08-11 14:40:48',
2,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL
);
SET i = i + 1;
END WHILE;
END $ CALL proc_initData ();