22,209
社区成员
发帖
与我相关
我的任务
分享
[SC#] [varchar](11) NOT NULL,
[CustID] [varchar](5) NULL,
[Comp#] [varchar](6) NULL,
[P/O#] [varchar](50) NULL,
[LOT#] [varchar](50) NULL,
[Description] [char](50) NULL,
[PO_Category] [varchar](3) NULL,
[PO_Qty] [decimal](10, 0) NULL,
[Part_code] [char](50) NULL,
[UnitPrice] [decimal](10, 3) NULL,
[AskToDelBalance] [decimal](10, 0) NULL,
[AskToProdBalance] [decimal](10, 0) NULL,
[NewOrder] [varchar](1) NULL,
[ParentSC#] [varchar](50) NULL,
[KeyInDate] [datetime] NULL,
[KeyInTime] [datetime] NULL,
[KeyInBy] [varchar](6) NULL,
[ForceComplete] [bit] NULL,
[SCStatus] [varchar](8) NULL,
[SpecialApproval#] [varchar](100) NULL,
[CommissionTheir] [real] NULL,
[CommissionOur] [real] NULL,
[SeparatePrintings] [real] NULL,
[ProfitMargin] [real] NULL,
[PriceLevel] [varchar](2) NULL,
[SessionID] [int] NULL,
[DeliveryPresent] [varchar](3) NULL,
[DeliveryPresentQty] [int] NULL,
[AddrNo] [char](10) NULL,
[DelAddress] [varchar](500) NULL,
[SampleOrder] [varchar](1) NULL,
[DelDate] [datetime] NULL,
[AdditionalAllowance] [real] NULL,
[NotToProduce] [char](1) NULL,
[NotToStore] [char](1) NULL,
[OnHoldSC#] [varchar](9) NULL,
[SampleForPrinting] [smallint] NULL,
[SampleForDieCut] [smallint] NULL,
[sampleBox] [smallint] NULL CONSTRAINT [DF_YSBMEORD_sampleBox] DEFAULT ((0)),
[Salesman] [varchar](6) NULL,
[TotalCost] [real] NULL,
[NoOfPalletForSS] [int] NULL,
[ratio] [int] NULL,
[belongto] [char](2) NULL,
[status] [varchar](10) NULL,
[model#] [varchar](100) NULL,
[NotTrim] [int] NULL,
[PorWorking] [varchar](1) NULL,
[Plantid] [char](2) NULL,
[txtbank] [smallint] NULL,
[DCMould] [smallint] NULL,
[musr] [char](5) NULL,
[mdtm] [datetime] NULL,
[DM] [char](3) NULL,
[Sellout] [smallint] NULL CONSTRAINT [DF_YSBMEORD_Sellout] DEFAULT (NULL),
CONSTRAINT [PK_ysbmeord] PRIMARY KEY CLUSTERED
(
[SC#] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100) ON [PRIMARY]
) ON [PRIMARY]