27 lines
13 KiB
SQL
27 lines
13 KiB
SQL
INSERT INTO fad_oa.sys_oa_finance (finance_id, project_id, finance_title, receive_account_id, finance_parties, pay_type, finance_type, finance_time, accessory, make_time, make_ratio, make_price, make_explain, remark, create_by, create_time, update_by, update_time) VALUES (1755860775004790786, 1754790783681171457, '项目结算', -1, '某中心小学', '1', '1', '2024-10-01 09:35:19', null, null, null, null, null, '支付30%', 'zss', '2024-10-01 09:35:19', 'zss', '2024-10-01 09:35:19');
|
||
INSERT INTO fad_oa.sys_oa_finance (finance_id, project_id, finance_title, receive_account_id, finance_parties, pay_type, finance_type, finance_time, accessory, make_time, make_ratio, make_price, make_explain, remark, create_by, create_time, update_by, update_time) VALUES (1756241538145456130, 1755602361246720001, '测试6阿是的发生', -1, '实施', '2', '1', '2024-10-01 09:35:19', null, null, null, null, null, '但是', 'zss', '2024-10-01 09:35:19', 'admin', '2024-10-01 09:35:19');
|
||
INSERT INTO fad_oa.sys_oa_finance (finance_id, project_id, finance_title, receive_account_id, finance_parties, pay_type, finance_type, finance_time, accessory, make_time, make_ratio, make_price, make_explain, remark, create_by, create_time, update_by, update_time) VALUES (1756263906641313793, 1754790783681171457, '入账测试', -1, '实施', '1', '1', '2024-10-01 09:35:19', null, null, null, null, null, '实施', 'zss', '2024-10-01 09:35:19', 'zxj', '2024-10-01 09:35:19');
|
||
INSERT INTO fad_oa.sys_oa_finance (finance_id, project_id, finance_title, receive_account_id, finance_parties, pay_type, finance_type, finance_time, accessory, make_time, make_ratio, make_price, make_explain, remark, create_by, create_time, update_by, update_time) VALUES (1756287086302986242, 1754790783681171457, '是的发生', -1, '实施', '1', '0', '2024-10-01 09:35:19', null, '2024-03-04 00:00:00', null, null, null, '是否', 'admin', '2024-10-01 09:35:19', 'zss', '2024-10-01 09:35:19');
|
||
INSERT INTO fad_oa.sys_oa_finance (finance_id, project_id, finance_title, receive_account_id, finance_parties, pay_type, finance_type, finance_time, accessory, make_time, make_ratio, make_price, make_explain, remark, create_by, create_time, update_by, update_time) VALUES (1756287640722866177, 1755602361246720001, '随时随地分身乏术的是的发生地方111', -1, '是事实', '2', '0', '2024-10-01 09:35:19', null, null, null, null, null, '沙发是的', 'admin', '2024-10-01 09:35:19', 'admin', '2024-10-01 09:35:19');
|
||
INSERT INTO fad_oa.sys_oa_finance (finance_id, project_id, finance_title, receive_account_id, finance_parties, pay_type, finance_type, finance_time, accessory, make_time, make_ratio, make_price, make_explain, remark, create_by, create_time, update_by, update_time) VALUES (1757618182420598786, 1754790783681171457, '采购设备', -1, '李老师', '1', '0', '2024-10-01 09:35:19', null, '2024-03-07 00:00:00', '80%', '5600', null, '设备的备注信息', 'zss', '2024-10-01 09:35:19', 'zss', '2024-10-01 09:35:19');
|
||
INSERT INTO fad_oa.sys_oa_finance (finance_id, project_id, finance_title, receive_account_id, finance_parties, pay_type, finance_type, finance_time, accessory, make_time, make_ratio, make_price, make_explain, remark, create_by, create_time, update_by, update_time) VALUES (1763950559354839042, 0, '入账测试', -1, '公司的公司', '2', '1', '2024-10-01 09:35:19', null, '2024年3月30日', '100%', '10.03', '电子发票', '33', 'admin', '2024-10-01 09:35:19', 'zss', '2024-10-01 09:35:19');
|
||
INSERT INTO fad_oa.sys_oa_finance (finance_id, project_id, finance_title, receive_account_id, finance_parties, pay_type, finance_type, finance_time, accessory, make_time, make_ratio, make_price, make_explain, remark, create_by, create_time, update_by, update_time) VALUES (1773192093121351681, 1772091887814356994, '收项目60%款', -1, '海东市平安区教育局', '1', '1', '2024-10-01 09:35:19', '1781203938838986753', '2023-06-19 00:00:00', '100%', '1937000.00', null, null, 'zxj', '2024-10-01 09:35:19', 'zxj', '2024-10-01 09:35:19');
|
||
INSERT INTO fad_oa.sys_oa_finance (finance_id, project_id, finance_title, receive_account_id, finance_parties, pay_type, finance_type, finance_time, accessory, make_time, make_ratio, make_price, make_explain, remark, create_by, create_time, update_by, update_time) VALUES (1773522664783581186, 1772143887566417921, '收项目款30%', -1, '西宁市沈那中学', '1', '1', '2024-10-01 09:35:19', '1781218113854259201', '2023-11-08 00:00:00', '30%', '347400.00', null, '30%款已收到并已全额开票', 'zxj', '2024-10-01 09:35:19', 'zxj', '2024-10-01 09:35:19');
|
||
INSERT INTO fad_oa.sys_oa_finance (finance_id, project_id, finance_title, receive_account_id, finance_parties, pay_type, finance_type, finance_time, accessory, make_time, make_ratio, make_price, make_explain, remark, create_by, create_time, update_by, update_time) VALUES (1773531463401574402, 1772143887566417921, '收项目款70%', -1, '西宁市沈那中学', '1', '1', '2024-10-01 09:35:19', '1781212072022261761', '2023-11-28 00:00:00', '70%', '810600', '票已全开', '70%款已收到并已开全额票', 'zxj', '2024-10-01 09:35:19', 'zxj', '2024-10-01 09:35:19');
|
||
INSERT INTO fad_oa.sys_oa_finance (finance_id, project_id, finance_title, receive_account_id, finance_parties, pay_type, finance_type, finance_time, accessory, make_time, make_ratio, make_price, make_explain, remark, create_by, create_time, update_by, update_time) VALUES (1780862956457050114, 1772143887566417921, '付履约保证金', -1, '方', '1', '0', '2024-10-01 09:35:19', null, null, null, null, null, null, 'zxj', '2024-10-01 09:35:19', 'zxj', '2024-10-01 09:35:19');
|
||
INSERT INTO fad_oa.sys_oa_finance (finance_id, project_id, finance_title, receive_account_id, finance_parties, pay_type, finance_type, finance_time, accessory, make_time, make_ratio, make_price, make_explain, remark, create_by, create_time, update_by, update_time) VALUES (1780865433248088066, 1772143081001758722, '付履约保证金', -1, '方', '1', '0', '2024-10-01 09:35:19', null, null, null, null, null, null, 'zxj', '2024-10-01 09:35:19', 'zxj', '2024-10-01 09:35:19');
|
||
INSERT INTO fad_oa.sys_oa_finance (finance_id, project_id, finance_title, receive_account_id, finance_parties, pay_type, finance_type, finance_time, accessory, make_time, make_ratio, make_price, make_explain, remark, create_by, create_time, update_by, update_time) VALUES (1780866408184692737, 1772116024616202242, '收项目款', -1, '民和回族土族自治县教育局', '1', '1', '2024-10-01 09:35:19', '1783419576672206850', '2023.8.28', '20%', '352000', null, '全票已开', 'zxj', '2024-10-01 09:35:19', 'zxj', '2024-10-01 09:35:19');
|
||
INSERT INTO fad_oa.sys_oa_finance (finance_id, project_id, finance_title, receive_account_id, finance_parties, pay_type, finance_type, finance_time, accessory, make_time, make_ratio, make_price, make_explain, remark, create_by, create_time, update_by, update_time) VALUES (1780867036420128769, 1772116024616202242, '收项目款', -1, '民和回族土族自治县教育局', '1', '1', '2024-10-01 09:35:19', '1781154129721573377', '2023.12.28', '80%', '1408000', null, '收款1056000开票1408000元', 'zxj', '2024-10-01 09:35:19', 'zxj', '2024-10-01 09:35:19');
|
||
INSERT INTO fad_oa.sys_oa_finance (finance_id, project_id, finance_title, receive_account_id, finance_parties, pay_type, finance_type, finance_time, accessory, make_time, make_ratio, make_price, make_explain, remark, create_by, create_time, update_by, update_time) VALUES (1780867879655587841, 1772116024616202242, '付中标服务费', -1, '青海卓泽工程管理咨询有限公司', '1', '0', '2024-10-01 09:35:19', null, null, null, null, null, null, 'zxj', '2024-10-01 09:35:19', 'zxj', '2024-10-01 09:35:19');
|
||
INSERT INTO fad_oa.sys_oa_finance (finance_id, project_id, finance_title, receive_account_id, finance_parties, pay_type, finance_type, finance_time, accessory, make_time, make_ratio, make_price, make_explain, remark, create_by, create_time, update_by, update_time) VALUES (1780875075378364417, 1772116024616202242, '付履约保证金', -1, '民和回族土族自治县教育局', '1', '0', '2024-10-01 09:35:19', null, null, null, null, null, null, 'zxj', '2024-10-01 09:35:19', 'zxj', '2024-10-01 09:35:19');
|
||
INSERT INTO fad_oa.sys_oa_finance (finance_id, project_id, finance_title, receive_account_id, finance_parties, pay_type, finance_type, finance_time, accessory, make_time, make_ratio, make_price, make_explain, remark, create_by, create_time, update_by, update_time) VALUES (1780876795642789889, 1772097437482528769, '收项目款', -1, '循化撒拉族自治县工业商务和信息化局', '1', '1', '2024-10-01 09:35:19', '1782257412167057409,1797520486285389825,1797520525544075266,1797520557609529345', '全票已开', '100', '967000.00', '全票已开', '全票已开（2023.4.26和2023.11.16共开票967000元）', 'zxj', '2024-10-01 09:35:19', 'zxj', '2024-10-01 09:35:19');
|
||
INSERT INTO fad_oa.sys_oa_finance (finance_id, project_id, finance_title, receive_account_id, finance_parties, pay_type, finance_type, finance_time, accessory, make_time, make_ratio, make_price, make_explain, remark, create_by, create_time, update_by, update_time) VALUES (1780878923136385026, 1772097437482528769, '付履约保证金', -1, '循化撒拉族自治县工业商务和信息化局', '1', '0', '2024-10-01 09:35:19', null, null, null, null, null, null, 'zxj', '2024-10-01 09:35:19', 'zxj', '2024-10-01 09:35:19');
|
||
INSERT INTO fad_oa.sys_oa_finance (finance_id, project_id, finance_title, receive_account_id, finance_parties, pay_type, finance_type, finance_time, accessory, make_time, make_ratio, make_price, make_explain, remark, create_by, create_time, update_by, update_time) VALUES (1780881641045377026, 1772097437482528769, '付中标服务费', -1, '青海拓鑫工程项目管理有限公司', '1', '0', '2024-10-01 09:35:19', null, null, null, null, null, null, 'zxj', '2024-10-01 09:35:19', 'zxj', '2024-10-01 09:35:19');
|
||
INSERT INTO fad_oa.sys_oa_finance (finance_id, project_id, finance_title, receive_account_id, finance_parties, pay_type, finance_type, finance_time, accessory, make_time, make_ratio, make_price, make_explain, remark, create_by, create_time, update_by, update_time) VALUES (1781126930805178369, 1772091887814356994, '付履约保证金', -1, '海东市平安教育局', '1', '0', '2024-10-01 09:35:19', null, null, null, null, null, null, 'zxj', '2024-10-01 09:35:19', 'zxj', '2024-10-01 09:35:19');
|
||
INSERT INTO fad_oa.sys_oa_finance (finance_id, project_id, finance_title, receive_account_id, finance_parties, pay_type, finance_type, finance_time, accessory, make_time, make_ratio, make_price, make_explain, remark, create_by, create_time, update_by, update_time) VALUES (1793231027082244098, 1793099248287543298, '是事实', -1, '是的发生', '2', '1', '2024-10-01 09:35:19', null, null, null, null, null, null, 'zss', '2024-10-01 09:35:19', 'zss', '2024-10-01 09:35:19');
|
||
INSERT INTO fad_oa.sys_oa_finance (finance_id, project_id, finance_title, receive_account_id, finance_parties, pay_type, finance_type, finance_time, accessory, make_time, make_ratio, make_price, make_explain, remark, create_by, create_time, update_by, update_time) VALUES (1793233068621967362, 1793099248287543298, '二批', -1, '史蒂夫', '2', '1', '2024-10-01 09:35:19', null, null, null, null, null, null, 'zss', '2024-10-01 09:35:19', 'zss', '2024-10-01 09:35:19');
|
||
INSERT INTO fad_oa.sys_oa_finance (finance_id, project_id, finance_title, receive_account_id, finance_parties, pay_type, finance_type, finance_time, accessory, make_time, make_ratio, make_price, make_explain, remark, create_by, create_time, update_by, update_time) VALUES (1848614911749337090, 0, '采购物资', -1, '春天', '1', '0', '2024-10-22 00:00:00', null, null, null, '100', null, null, 'boss', '2024-10-22 14:38:35', 'boss', '2024-10-22 14:38:35');
|
||
INSERT INTO fad_oa.sys_oa_finance (finance_id, project_id, finance_title, receive_account_id, finance_parties, pay_type, finance_type, finance_time, accessory, make_time, make_ratio, make_price, make_explain, remark, create_by, create_time, update_by, update_time) VALUES (1848620071049441282, 1848619184239357954, '轧机改造预付款', -1, '123456公司', '1', '1', '2024-10-22 00:00:00', null, null, null, null, null, null, 'boss', '2024-10-22 14:59:05', 'boss', '2024-10-22 14:59:05');
|
||
INSERT INTO fad_oa.sys_oa_finance (finance_id, project_id, finance_title, receive_account_id, finance_parties, pay_type, finance_type, finance_time, accessory, make_time, make_ratio, make_price, make_explain, remark, create_by, create_time, update_by, update_time) VALUES (1848620573875187713, 1848619184239357954, '采购货款', -1, '李四', '1', '0', '2024-10-22 00:00:00', null, null, null, null, null, null, 'boss', '2024-10-22 15:01:05', 'boss', '2024-10-22 15:01:05');
|
||
INSERT INTO fad_oa.sys_oa_finance (finance_id, project_id, finance_title, receive_account_id, finance_parties, pay_type, finance_type, finance_time, accessory, make_time, make_ratio, make_price, make_explain, remark, create_by, create_time, update_by, update_time) VALUES (1848631822893658113, 0, '货款', 730536521, '张三公司', '1', '1', '2024-10-22 00:00:00', null, '2024-10-22', '0.13', '100', null, '货款', 'boss', '2024-10-22 15:45:47', 'boss', '2024-10-22 15:46:39');
|