apop

-- Fully populated record
insert into MY_TABLE (
INTERNINSTID,
INTERVERSION,
INTERNTIMESTAMP,
INTERNRECTYPE,
LISTID,
SYNC,
LISTNAME,
PARENTLISTID,
ACCOUNTGROUP,
BASKETNUMBER,
CLIENTID,
CREDITID,
CUSTENTITY,
FIRMID,
FIXREPORTINGTYPE,
GROUPPERMISSION,
INDEXAKW,
INDEXDIVISOR,
INDEXMULTIPLIER,
INDEXPREVCLOSE,
INDEXVALIDATED,
INDEXWEIGHTTYPE,
LISTACCOUNT,
LISTCREATIONTIME,
LISTLOCKED,
LISTOWNER,
LISTSECONO,
LISTSOURCE,
LISTSTATE,
LISTSTATUS,
LISTSTATUSTEXT,
LISTSTATUSTYPE,
LISTTRADINGACCT,
LISTTYPE,
PARENTLISTOWNER,
PROGRPTREGS,
REGION,
ROUTEPODESTINATION,
SALESCREDIT,
SALESPERSONID,
TOTALNETVALUE,
TOTNAMES,
TOTNOORDERS,
TOTNORELLITEDSYM,
TOTREJECTEDORDERS,
TRADERID,
TRADINGORSTAGING,
USERGROUP,
USERPERMISSION,
WORLDPERMISSION
) values (
100,
1,
'2025-01-01 10:00:00',
1,
'LST001',
10,
'MyList',
'PARENT001',
'ACCGRP01',
123456789,
'CL001',
'CR001',
'CUSTENT001',
'FIRM01',
1,
'GROUP1',
'AKW1',
1.23,
2,
3.45,
'YES',
1,
'LISTACC001',
'2025-01-01 09:00:00',
'Y',
'OWNER1',
1,
2,
3,
'ACTIVE',
'Status text example',
'TYPE1',
'TRACCT01',
1,
'PARENTOWNER',
'PROGRPT1',
'REGION1',
'D',
1000.50,
'SP001',
5000.75,
10,
5,
2,
1,
'TR001',
'S',
'USERGRP1',
'PERM1',
'WORLD1'
);

-- Partially populated record (nullable columns left NULL)
insert into MY_TABLE (
INTERNINSTID,
INTERVERSION,
INTERNTIMESTAMP,
INTERNRECTYPE,
LISTID,
SYNC
) values (
101,
1,
'2025-01-02 11:30:00',
2,
'LST002',
20
);