Hi All ,
I m trying to create a Billing Invoice for Project(entity)
using console Application i tried with SQL queries but cant see that entry in billings tab below are the tables i tried to insert data in
INSERT INTO PA13100 (PABILLTRXT,PADocnumber20,BACHNUMB, BCHSOURC,PAuserid,CUSTNMBR,PRBTADCD, PACOMM,CURNCYID,MISCTXBL,FRGTTXBL,CURRNIDX,PAPostoDynRM)
VALUES (1,'BILL0000000000006','B1','PA_BL','sa',1,'123456','test profiler','Z-US$',3,3,1007,1);
INSERT INTO PA01901 (PATranType,CUSTNMBR,PADOCDT,PACOSTOWNER,RMDTYPAL,PABILLTRXT,PADocnumber20,DCSTATUS)
VALUES (7,1,'2017-04-12 00:00:00.000',1,1,1,'BILL0000000000006',1);
INSERT INTO RM00401 (DOCNUMBR,BCHSOURC,CUSTNMBR,CHEKNMBR,DCSTATUS,RMDTYPAL,DOCDATE)
VALUES ('BILL0000000000006','PA_BL',1,'BILL0000000000006',0,1,'2017-04-12 00:00:00.000');
Also which tables which field data will insert the invoice for that particular project
As shown in image 
Any econnect claass or code that could do that will be very helpful
