INSERT INTO sms_invoice_test1
( org_id
,
is_delete
,
is_active
,
created
,
createdby
,
updated
,
updatedby
,
invoice_no
,
doc_type
,
status
,
is_posted
,
version
,
date_acct
,
bpartner_code
,
bill_bpartner_code
,
grand_total
,
currency_code
,
remark
,
multiply_rate
,
conversion_type_code
,
recharge_no
,
bpartner_name
,
MOD_VALUE
)
VALUES
(1000000,‘N’,‘Y’,‘2021-05-01 00:00:00’,‘system’,‘2021-05-01 00:00:00’,‘system’,‘ARI1521646612’,‘ARI’,‘CO’,‘Y’,NULL,‘2021-05-01 00:00:00’,‘1000069’,NULL,-0.32,‘EUR’,‘自动生成’,1.2134,‘114’,NULL,‘ss’,2),
(1000000,‘N’,‘Y’,‘2021-04-30 23:59:59’,‘system’,‘2021-04-30 23:59:59’,‘system’,‘ARI1521646613’,‘ARI’,‘CO’,‘Y’,NULL,‘2021-04-30 00:00:00’,‘10005909’,NULL,0.10,‘GBP’,‘自动生成’,1.3953,‘114’,NULL,‘ww’,3),
(1000000,‘N’,‘Y’,‘2021-04-30 23:59:59’,‘system’,‘2021-04-30 23:59:59’,‘system’,‘ARI1521646614’,‘ARI’,‘CO’,‘Y’,NULL,‘2021-04-30 00:00:00’,‘1000069’,NULL,-0.20,‘EUR’,‘自动生成’,1.2134,‘114’,NULL,‘ss’,4),
(1000000,‘N’,‘Y’,‘2021-04-30 23:59:59’,‘system’,‘2021-04-30 23:59:59’,‘system’,‘ARI1521646615’,‘ARI’,‘CO’,‘Y’,NULL,‘2021-04-30 00:00:00’,‘1000239’,NULL,0.10,‘GBP’,‘自动生成’,1.3953,‘114’,NULL,‘ss’,5),
(1000000,‘N’,‘Y’,‘2021-04-30 23:59:59’,‘system’,‘2021-04-30 23:59:59’,‘system’,‘ARI1521646616’,‘ARI’,‘CO’,‘Y’,NULL,‘2021-04-30 00:00:00’,‘1000239’,NULL,1.97,‘GBP’,‘自动生成’,1.3953,‘114’,NULL,‘ss’,6),
(1000000,‘N’,‘Y’,‘2021-04-30 23:59:59’,‘system’,‘2021-04-30 23:59:59’,‘system’,‘ARI1521646617’,‘ARI’,‘CO’,‘Y’,NULL,‘2021-04-30 00:00:00’,‘1000069’,NULL,-0.20,‘EUR’,‘自动生成’,1.2134,‘114’,NULL,‘ss’,7),
(1000000,‘N’,‘Y’,‘2021-04-30 23:59:59’,‘system’,‘2021-04-30 23:59:59’,‘system’,‘ARI1521646618’,‘ARI’,‘CO’,‘Y’,NULL,‘2021-04-30 00:00:00’,‘1000239’,NULL,-0.07,‘GBP’,‘自动生成’,1.3953,‘114’,NULL,‘ss’,8),
(1000000,‘N’,‘Y’,‘2021-04-30 23:59:59’,‘system’,‘2021-04-30 23:59:59’,‘system’,‘ARI1521646619’,‘ARI’,‘CO’,‘Y’,NULL,‘2021-04-30 00:00:00’,‘1000069’,NULL,-0.93,‘EUR’,‘自动生成’,1.2134,‘114’,NULL,‘ss’,9),
(1000000,‘N’,‘Y’,‘2021-04-30 23:59:59’,‘system’,‘2021-04-30 23:59:59’,‘system’,‘ARI1521646620’,‘ARI’,‘CO’,‘Y’,NULL,‘2021-04-30 00:00:00’,‘1000069’,NULL,-0.26,‘EUR’,‘自动生成’,1.2134,‘114’,NULL,‘ww’,0),
(1000000,‘N’,‘Y’,‘2021-04-30 23:59:59’,‘system’,‘2021-04-30 23:59:59’,‘system’,‘ARI1521646621’,‘ARI’,‘CO’,‘Y’,NULL,‘2021-04-30 00:00:00’,‘1000069’,NULL,-0.05,‘EUR’,‘自动生成’,1.2134,‘114’,NULL,‘ww’,1),
(1000000,‘N’,‘Y’,‘2021-04-30 23:59:59’,‘system’,‘2021-04-30 23:59:59’,‘system’,‘ARI1521646622’,‘ARI’,‘CO’,‘Y’,NULL,‘2021-04-30 00:00:00’,‘1000069’,NULL,-0.64,‘EUR’,‘自动生成’,1.2134,‘114’,NULL,‘ww’,2),
(1000000,‘N’,‘Y’,‘2021-04-30 23:59:59’,‘system’,‘2021-04-30 23:59:59’,‘system’,‘ARI1521646623’,‘ARI’,‘CO’,‘Y’,NULL,‘2021-04-30 00:00:00’,‘1000239’,NULL,-0.07,‘GBP’,‘自动生成’,1.3953,‘114’,NULL,‘aa’,3),
(1000000,‘N’,‘Y’,‘2021-04-30 23:59:59’,‘system’,‘2021-04-30 23:59:59’,‘system’,‘ARI1521646624’,‘ARI’,‘CO’,‘Y’,NULL,‘2021-04-30 00:00:00’,‘1000239’,NULL,0.10,‘GBP’,‘自动生成’,1.3953,‘114’,NULL,‘aa’,4),
(1000000,‘N’,‘Y’,‘2021-04-30 23:59:59’,‘system’,‘2021-04-30 23:59:59’,‘system’,‘ARI1521646625’,‘ARI’,‘CO’,‘Y’,NULL,‘2021-04-30 00:00:00’,‘1000069’,NULL,-0.10,‘EUR’,‘自动生成’,1.2134,‘114’,NULL,‘ww’,5),
(1000000,‘N’,‘Y’,‘2021-04-30 23:59:59’,‘system’,‘2021-04-30 23:59:59’,‘system’,‘ARI1521646617’,‘ARI’,‘CO’,‘Y’,NULL,‘2021-04-30 00:00:00’,‘1000069’,NULL,-0.20,‘EUR’,‘自动生成’,1.2134,‘114’,NULL,‘ss’,7),
(1000000,‘N’,‘Y’,‘2021-04-30 23:59:59’,‘system’,‘2021-04-30 23:59:59’,‘system’,‘ARI1521646618’,‘ARI’,‘CO’,‘Y’,NULL,‘2021-04-30 00:00:00’,‘1000239’,NULL,-0.07,‘GBP’,‘自动生成’,1.3953,‘114’,NULL,‘ss’,8),
(1000000,‘N’,‘Y’,‘2021-04-30 23:59:59’,‘system’,‘2021-04-30 23:59:59’,‘system’,‘ARI1521646619’,‘ARI’,‘CO’,‘Y’,NULL,‘2021-04-30 00:00:00’,‘1000069’,NULL,-0.93,‘EUR’,‘自动生成’,1.2134,‘114’,NULL,‘ss’,9),
(1000000,‘N’,‘Y’,‘2021-04-30 23:59:59’,‘system’,‘2021-04-30 23:59:59’,‘system’,‘ARI1521646620’,‘ARI’,‘CO’,‘Y’,NULL,‘2021-04-30 00:00:00’,‘1000069’,NULL,-0.26,‘EUR’,‘自动生成’,1.2134,‘114’,NULL,‘ww’,0),
(1000000,‘N’,‘Y’,‘2021-04-30 23:59:59’,‘system’,‘2021-04-30 23:59:59’,‘system’,‘ARI1521646621’,‘ARI’,‘CO’,‘Y’,NULL,‘2021-04-30 00:00:00’,‘1000069’,NULL,-0.05,‘EUR’,‘自动生成’,1.2134,‘114’,NULL,‘ww’,1),
(1000000,‘N’,‘Y’,‘2021-04-30 23:59:59’,‘system’,‘2021-04-30 23:59:59’,‘system’,‘ARI1521646622’,‘ARI’,‘CO’,‘Y’,NULL,‘2021-04-30 00:00:00’,‘1000069’,NULL,-0.64,‘EUR’,‘自动生成’,1.2134,‘114’,NULL,‘ww’,2),
(1000000,‘N’,‘Y’,‘2021-04-30 23:59:59’,‘system’,‘2021-04-30 23:59:59’,‘system’,‘ARI1521646623’,‘ARI’,‘CO’,‘Y’,NULL,‘2021-04-30 00:00:00’,‘1000239’,NULL,-0.07,‘GBP’,‘自动生成’,1.3953,‘114’,NULL,‘aa’,3),
(1000000,‘N’,‘Y’,‘2021-04-30 23:59:59’,‘system’,‘2021-04-30 23:59:59’,‘system’,‘ARI1521646624’,‘ARI’,‘CO’,‘Y’,NULL,‘2021-04-30 00:00:00’,‘1000239’,NULL,0.10,‘GBP’,‘自动生成’,1.3953,‘114’,NULL,‘aa’,4),
(1000000,‘N’,‘Y’,‘2021-04-30 23:59:59’,‘system’,‘2021-04-30 23:59:59’,‘system’,‘ARI1521646625’,‘ARI’,‘CO’,‘Y’,NULL,‘2021-04-30 00:00:00’,‘1000069’,NULL,-0.10,‘EUR’,‘自动生成’,1.2134,‘114’,NULL,‘ww’,5),
(1000000,‘N’,‘Y’,‘2021-04-30 23:59:59’,‘system’,‘2021-04-30 23:59:59’,‘system’,‘ARI1521646626’,‘ARI’,‘CO’,‘Y’,NULL,‘2021-04-30 00:00:00’,‘10005909’,NULL,0.06,‘GBP’,‘自动生成’,1.3953,‘114’,NULL,‘zz’,6);