bos平台

签入 相当于修改到系统文件。通过签入签出加锁,保存实时生效

update 数据库客户端需要清理缓存

修改该单据

查找单据

单据字段和信息配置文件

D:\WorkSpace\XJPT\ttt\DataModel_20\XSYFX_35466510\cf2e0498-125f-4346-bbf8-0d68ce30c8a3.dym

论坛参考

bos整体精度和小数精度的用法

单据里的合计怎么加，不是列表的

销售出库例子

修改单据

表id大多数来自同一个seq

修改单据同时也会自动修改数据库表

出库单明细表-->销售出库单明细

CREATE TABLE [dbo].[T_SAL_OUTSTOCKENTRY](
	[FENTRYID] [int] NOT NULL,
	[FID] [int] NOT NULL,
	[FCUSTMATNAME] [nvarchar](80) NOT NULL,
	[FCUSTMATID] [nvarchar](30) NOT NULL,
	[FSEQ] [int] NOT NULL,
	...
	[FRECEIVEBILLNO] [nvarchar](255) NOT NULL,
	[FRECEIVEENTRYID] [int] NOT NULL,
	[F_VMKV_TEXT] [nvarchar](50) NOT NULL,
	[F_VMKV_DATE] [datetime] NULL,
 CONSTRAINT [PK_SAL_OUTSTOCKENTRY] PRIMARY KEY CLUSTERED 
(
	[FENTRYID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

其中 [F_VMKV_TEXT/F_VMKV_DATE] 是后添加的表单明细字段同时在数据中会建立

T_SAL_OUTSTOCK（销售出库单表）

数据结构

依据 XSDD000041

INSERT [dbo].[T_SAL_OUTSTOCKENTRY] 
([FENTRYID], [FID], [FCUSTMATNAME], [FCUSTMATID], [FSEQ], [FMATERIALID], [FUNITID], [FAUXPROPID], [FMUSTQTY], [FREALQTY], [FSTOCKID], [FSTOCKLOCID], [FSTOCKSTATUSID], [FLOT], [FLOT_TEXT], [FGROSSWEIGHT], [FNETWEIGHT], [FBASEUNITID], [FBASEUNITQTY], [FAUXUNITID], [FAUXUNITQTY], [FBOMID], [FNOTE], [FSTOCKFLAG], [FOWNERTYPEID], [FOWNERID], [FKEEPERTYPEID], [FKEEPERID], [FPRODUCEDATE], [FEXPIRYDATE], [FBASEMUSTQTY], [FARRIVALSTATUS], [FARRIVALDATE], [FARRIVALCONFIRMOR], [FVALIDATESTATUS], [FVALIDATEDATE], [FVALIDATECONFIRMOR], [FBFLOWID], [FMTONO], [FPROJECTNO], [FREPAIRQTY], [FREFUSEQTY], [FWANTRETQTY], [FACTQTY], [FISREPAIR], [FRECNOTE], [FRETURNNOTE], [FSNUNITID], [FSNQTY], [FOUTCONTROL], [FEXTAUXUNITID], [FEXTAUXUNITQTY], [FSRCENTRYID], [FBarcode], [FRetailSaleProm], [FALLAMOUNTEXCEPTDISCOUNT], [FGYENTERTIME], [FMATERIALID_SAL], [FINSTOCKBILLNO], [FINSTOCKENTRYID], [FVMIBUSINESSSTATUS], [FRECEIVEBILLNO], [FRECEIVEENTRYID], [F_VMKV_TEXT], [F_VMKV_DATE]) 
VALUES (100046, 100047, N' ', N' ', 1, 119464, 10101, 0, CAST(60.0000000000 AS Decimal(23, 10)), CAST(60.0000000000 AS Decimal(23, 10)), 119749, 0, 10000, 0, N' ', CAST(0.0000000000 AS Decimal(23, 10)), CAST(0.0000000000 AS Decimal(23, 10)), 10101, CAST(60.0000000000 AS Decimal(23, 10)), 0, CAST(0.0000000000 AS Decimal(23, 10)), 0, N' ', N'1', N'BD_OwnerOrg', 1, N'BD_KeeperOrg', 1, NULL, NULL, CAST(60.0000000000 AS Decimal(23, 10)), N' ', NULL, 0, N' ', NULL, 0, N' ', N' ', N' ', CAST(0.0000000000 AS Decimal(23, 10)), CAST(0.0000000000 AS Decimal(23, 10)), CAST(0.0000000000 AS Decimal(23, 10)), CAST(0.0000000000 AS Decimal(23, 10)), N'0', N' ', N' ', 0, 0, N'0', 0, CAST(0.0000000000 AS Decimal(23, 10)), N' ', N' ', N'0', CAST(23700.0000000000 AS Decimal(23, 10)), NULL, 0, N' ', 0, N'0', N' ', 0, N'XSDD000041', CAST(N'2023-07-14T00:00:00.000' AS DateTime))

发货通知单

对应表 T_SAL_DELIVERYNOTICEENTRY

INSERT [dbo].[T_SAL_DELIVERYNOTICEENTRY] ([FENTRYID], [FID], [FSEQ], [FCUSTMATID], [FMATERIALID], [FAUXPROPID], [FUNITID], [FQTY], [FSHIPMENTSTOCKID], [FSHIPMENTSTOCKLOCID], [FDELIVERYLOC], [FDELIVERYADDRESS], [FDELIVERYDATE], [FDELIVERYTYPE], [FPLANDELIVERYDATE], [FCARRYLEADTIME], [FBOMID], [FLOT], [FLOT_TEXT], [FBASEUNITID], [FBASEUNITQTY], [FGROSSWEIGHT], [FNETWEIGHT], [FOUTCONTROL], [FOUTMAXQTY], [FOUTMINQTY], [FSRCTYPE], [FSRCBILLNO], [FSRCROWID], [FNOTE], [FJOINOUTQTY], [FBASEJOINOUTQTY], [FSUMOUTQTY], [FBASESUMRETNOTICEQTY], [FORDERNO], [FORDERSEQ], [FBACKUPSTOCKID], [FBACKUPSTOCKLOCID], [FTRANSFERQTY], [FBASETRANSFERQTY], [FBASEACTUALQTY], [FBASESUMOUTQTY], [FPRODUCEDATE], [FEXPUNIT], [FEXPPERIOD], [FEXPIRYDATE], [FREMAINOUTQTY], [FCLOSESTATUS], [FSTOCKSTATUSID], [FBASEOUTMAXQTY], [FBASEOUTMINQTY], [FBFLOWID], [FMTONO], [FALLAMOUNTEXCEPTDISCOUNT], [F_UN_JOINPREPICKBASEQTY], [FLOCKSTOCKFLAG], [FLOCKSTOCKBASEQTY], [FLOCKSTOCKLEFTBASEQTY], [FSNUNITID], [FSNQTY], [F_QINL_YSJE], [F_VMKV_DATE1], [F_VMKV_TEXT1])
VALUES (100033, 100034, 1, N' ', 119464, 0, 10101, CAST(60.0000000000 AS Decimal(23, 10)), 119749, 0, 0, N' ', CAST(N'2023-07-14T15:17:59.637' AS DateTime), N' ', CAST(N'2023-07-14T15:17:59.637' AS DateTime), 0, 0, 0, N' ', 10101, CAST(60.0000000000 AS Decimal(23, 10)), CAST(0.0000000000 AS Decimal(23, 10)), CAST(0.0000000000 AS Decimal(23, 10)), N'0', CAST(60.0000000000 AS Decimal(23, 10)), CAST(60.0000000000 AS Decimal(23, 10)), N'SAL_SaleOrder', N'XSDD000041', 0, N' ', CAST(60.0000000000 AS Decimal(23, 10)), CAST(60.0000000000 AS Decimal(23, 10)), CAST(60.0000000000 AS Decimal(23, 10)), CAST(0.0000000000 AS Decimal(23, 10)), N'XSDD000041', N'1', 0, 0, CAST(0.0000000000 AS Decimal(23, 10)), CAST(0.0000000000 AS Decimal(23, 10)), CAST(0.0000000000 AS Decimal(23, 10)), CAST(60.0000000000 AS Decimal(23, 10)), NULL, N' ', CAST(0.000000 AS Decimal(19, 6)), NULL, CAST(0.0000000000 AS Decimal(23, 10)), N'B', 10000, CAST(60.0000000000 AS Decimal(23, 10)), CAST(60.0000000000 AS Decimal(23, 10)), N' ', N' ', CAST(23700.0000000000 AS Decimal(23, 10)), CAST(0.0000000000 AS Decimal(23, 10)), N'0', CAST(0.0000000000 AS Decimal(23, 10)), CAST(0.0000000000 AS Decimal(23, 10)), 0, 0, CAST(0.0000000000 AS Decimal(23, 10)), CAST(N'2023-07-14T00:00:00.000' AS DateTime), N'XSDD000041')

INSERT [dbo].[T_SAL_OUTSTOCKENTRY_R] ([FENTRYID], [FID], [FSRCTYPE], [FSRCBILLNO], [FJOINEDQTY], [FUNJOINQTY], [FJOINEDAMOUNT], [FUNJOINAMOUNT], [FFULLYJOINED], [FJOINSTATUS], [FRETURNQTY], [FBASERETURNQTY], [FSUMRETNOTICEQTY], [FSUMRETSTOCKQTY], [FINVOICEDQTY], [FBASEINVOICEDQTY], [FSUMINVOICEDQTY], [FSUMINVOICEDAMT], [FSUMRECIEVEDAMT], [FSOORDERNO], [FBASESUMRETNOTICEQTY], [FBASESUMRETSTOCKQTY], [FBASESUMINVOICEDQTY], [FBASEARJOINQTY], [FBASEARQTY], [FARJOINAMOUNT], [FARAMOUNT], [FBASEJOININSTOCKQTY], [FJOININSTOCKQTY], [FSECJOININSTOCKQTY], [FSECRETURNQTY], [FARJOINQTY], [FEOWNERSUPPLIERID], [FESETTLECUSTOMERID], [FSTOCKBASERETURNQTY], [FSTOCKBASESUMRETSTOCKQTY], [FSTOCKBASEARJOINQTY], [FSALBASEARJOINQTY], [FPURBASEJOININSTOCKQTY], [FARNOTJOINQTY], [FQMENTRYID], [FCONVERTENTRYID], [FB2CORDERDETAILID], [FSOENTRYID], [FRESERVEENTRYID], [FSIGNQTY], [FTHIRDENTRYID], [FCHECKDELIVERY], [FTHIRDBILLID], [FTHIRDBILLNO], [FGYFINSTATUS], [FGYFINDATE], [FWRITEOFFPRICEBASEQTY], [FWRITEOFFSALEBASEQTY], [FWRITEOFFSTOCKBASEQTY], [FWRITEOFFAMOUNT], [FBOMENTRYID]) 
VALUES (100046, 100047, N'SAL_DELIVERYNOTICE', N'FHTZD000012', CAST(0.0000000000 AS Decimal(23, 10)), CAST(0.0000000000 AS Decimal(23, 10)), CAST(0.0000000000 AS Decimal(23, 10)), CAST(0.0000000000 AS Decimal(23, 10)), N'0', N' ', CAST(5.0000000000 AS Decimal(23, 10)), CAST(5.0000000000 AS Decimal(23, 10)), CAST(0.0000000000 AS Decimal(23, 10)), CAST(5.0000000000 AS Decimal(23, 10)), CAST(0.0000000000 AS Decimal(23, 10)), CAST(0.0000000000 AS Decimal(23, 10)), CAST(60.0000000000 AS Decimal(23, 10)), CAST(0.0000000000 AS Decimal(23, 10)), CAST(0.0000000000 AS Decimal(23, 10)), N'XSDD000041', CAST(0.0000000000 AS Decimal(23, 10)), CAST(5.0000000000 AS Decimal(23, 10)), CAST(0.0000000000 AS Decimal(23, 10)), CAST(60.0000000000 AS Decimal(23, 10)), CAST(60.0000000000 AS Decimal(23, 10)), CAST(23700.0000000000 AS Decimal(23, 10)), CAST(20973.4500000000 AS Decimal(23, 10)), CAST(0.0000000000 AS Decimal(23, 10)), CAST(0.0000000000 AS Decimal(23, 10)), CAST(0.0000000000 AS Decimal(23, 10)), CAST(0.0000000000 AS Decimal(23, 10)), CAST(60.0000000000 AS Decimal(23, 10)), 0, 0, CAST(5.0000000000 AS Decimal(23, 10)), CAST(5.0000000000 AS Decimal(23, 10)), CAST(60.0000000000 AS Decimal(23, 10)), CAST(60.0000000000 AS Decimal(23, 10)), CAST(0.0000000000 AS Decimal(23, 10)), CAST(0.0000000000 AS Decimal(23, 10)), 0, 0, 0, 100106, 0, CAST(0.0000000000 AS Decimal(23, 10)), N' ', N'0', N' ', N' ', N'0', NULL, CAST(0.0000000000 AS Decimal(23, 10)), CAST(0.0000000000 AS Decimal(23, 10)), CAST(0.0000000000 AS Decimal(23, 10)), CAST(0.0000000000 AS Decimal(23, 10)), 0)

现工作文档