我使用的是用友畅捷通T+财务管理软件,在操作T+总账模块的时候碰到了个问题:
bpm软件需要抓取T+数据库中科目(1151,2131)余额,
请教用友财务软件工程师如何解决?具体的情况如下:
跟踪了半天都是一些临时创建的表,跟索引, 能不能提供一下怎么从哪里抓取的数据啊 , 下面这段代码是从哪个表或者文件中提取的数据,能不能告诉一下 insert bulk TEMP_0_EAP_Rpt_GL_BalanceSumRpt_8d1d3d65_e875_9765_cc87_49009473cab2657 ([eap_reportrowtype] Int, [accountTypeID] Int, [accountTypeCode] NVarChar(2000) COLLATE Chinese_PRC_CI_AS,
[accountTypeName] NVarChar(2000) COLLATE Chinese_PRC_CI_AS, [accountID] Int, [accountCode] NVarChar(2000) COLLATE Chinese_PRC_CI_AS, [accountName] NVarChar(2000) COLLATE Chinese_PRC_CI_AS,
[accountDcdirection] Int, [accountUnit] NVarChar(2000) COLLATE Chinese_PRC_CI_AS, [currencyID] Int, [currencyCode] NVarChar(2000) COLLATE Chinese_PRC_CI_AS,
[currencyName] NVarChar(2000) COLLATE Chinese_PRC_CI_AS,
[calDirection] Int, [quantityBalance] Decimal(28,14), [origAmountBalance] Decimal(28,14), [amountBalance] Decimal(28,14), [periodBeginBalanceQuantityDr] Decimal(28,14),
[periodBeginBalanceOrigAmountDr] Decimal(28,14), [periodBeginBalanceAmountDr] Decimal(28,14), [periodBeginBalanceQuantityCr] Decimal(28,14), [periodBeginBalanceOrigAmountCr] Decimal(28,14),
[periodBeginBalanceAmountCr] Decimal(28,14), [quantityDr] Decimal(28,14), [origAmountDr] Decimal(28,14), [amountDr] Decimal(28,14), [quantityCr] Decimal(28,14), [origAmountCr] Decimal(28,14),
[amountCr] Decimal(28,14), [cumQuantityDr] Decimal(28,14), [cumOrigAmountDr] Decimal(28,14), [cumAmountDr] Decimal(28,14), [cumQuantityCr] Decimal(28,14), [cumOrigAmountCr] Decimal(28,14),
[cumAmountCr] Decimal(28,14), [periodEndBalanceQuantityDr] Decimal(28,14), [periodEndBalanceOrigAmountDr] Decimal(28,14), [periodEndBalanceAmountDr] Decimal(28,14),
[periodEndBalanceQuantityCr] Decimal(28,14), [periodEndBalanceOrigAmountCr] Decimal(28,14), [periodEndBalanceAmountCr] Decimal(28,14), [auxAccAuxSelfDef] NVarChar(2000) COLLATE Chinese_PRC_CI_AS)
您好,该问题请联系服务商提交问题到支持网处理呢