bulolo commented on issue #6658:
URL: https://github.com/apache/seatunnel/issues/6658#issuecomment-2044512864
> Provide the table‘s ddl
-- ----------------------------
-- Table structure for ORDERDETAIL
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id =
OBJECT_ID(N'[wmwhse2].[ORDERDETAIL]') AND type IN ('U'))
DROP TABLE [wmwhse2].[ORDERDETAIL]
GO
CREATE TABLE [wmwhse2].[ORDERDETAIL] (
[SERIALKEY] int IDENTITY(1,1) NOT NULL,
[WHSEID] nvarchar(30) COLLATE Chinese_PRC_CI_AS DEFAULT user_name() NULL,
[ORDERKEY] nvarchar(10) COLLATE Chinese_PRC_CI_AS NOT NULL,
[ORDERLINENUMBER] nvarchar(5) COLLATE Chinese_PRC_CI_AS NOT NULL,
[ORDERDETAILSYSID] int NULL,
[EXTERNORDERKEY] nvarchar(32) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT
NULL,
[EXTERNLINENO] nvarchar(20) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
[SKU] nvarchar(50) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
[STORERKEY] nvarchar(15) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
[MANUFACTURERSKU] nvarchar(50) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT
NULL,
[RETAILSKU] nvarchar(50) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
[ALTSKU] nvarchar(50) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
[ORIGINALQTY] decimal(22,5) DEFAULT 0 NOT NULL,
[OPENQTY] decimal(22,5) DEFAULT 0 NOT NULL,
[SHIPPEDQTY] decimal(22,5) DEFAULT 0 NOT NULL,
[ADJUSTEDQTY] decimal(22,5) DEFAULT 0 NOT NULL,
[QTYPREALLOCATED] decimal(22,5) DEFAULT 0 NOT NULL,
[QTYALLOCATED] decimal(22,5) DEFAULT 0 NOT NULL,
[QTYPICKED] decimal(22,5) DEFAULT 0 NOT NULL,
[UOM] nvarchar(10) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
[PACKKEY] nvarchar(50) COLLATE Chinese_PRC_CI_AS DEFAULT 'STD' NOT NULL,
[PICKCODE] nvarchar(10) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
[CARTONGROUP] nvarchar(10) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
[LOT] nvarchar(10) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
[ID] nvarchar(50) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
[FACILITY] nvarchar(20) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
[STATUS] nvarchar(10) COLLATE Chinese_PRC_CI_AS DEFAULT '02' NOT NULL,
[UNITPRICE] float(53) DEFAULT 0 NOT NULL,
[TAX01] float(53) DEFAULT 0 NOT NULL,
[TAX02] float(53) DEFAULT 0 NOT NULL,
[EXTENDEDPRICE] float(53) DEFAULT 0 NOT NULL,
[UPDATESOURCE] nvarchar(10) COLLATE Chinese_PRC_CI_AS DEFAULT '0' NOT NULL,
[LOTTABLE01] nvarchar(50) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
[LOTTABLE02] nvarchar(50) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
[LOTTABLE03] nvarchar(50) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
[LOTTABLE04] datetime NULL,
[LOTTABLE05] datetime NULL,
[LOTTABLE06] nvarchar(50) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
[LOTTABLE07] nvarchar(50) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
[LOTTABLE08] nvarchar(50) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
[LOTTABLE09] nvarchar(50) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
[LOTTABLE10] nvarchar(50) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
[EFFECTIVEDATE] datetime NULL,
[FORTE_FLAG] nvarchar(6) COLLATE Chinese_PRC_CI_AS DEFAULT 'I' NOT NULL,
[TARIFFKEY] nvarchar(10) COLLATE Chinese_PRC_CI_AS NULL,
[SUSR1] nvarchar(30) COLLATE Chinese_PRC_CI_AS NULL,
[SUSR2] nvarchar(30) COLLATE Chinese_PRC_CI_AS NULL,
[SUSR3] nvarchar(30) COLLATE Chinese_PRC_CI_AS NULL,
[SUSR4] nvarchar(30) COLLATE Chinese_PRC_CI_AS NULL,
[SUSR5] nvarchar(30) COLLATE Chinese_PRC_CI_AS NULL,
[NOTES] nvarchar(2000) COLLATE Chinese_PRC_CI_AS NULL,
[WORKORDERKEY] nvarchar(10) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
[ALLOCATESTRATEGYKEY] nvarchar(10) COLLATE Chinese_PRC_CI_AS NULL,
[PREALLOCATESTRATEGYKEY] nvarchar(10) COLLATE Chinese_PRC_CI_AS NULL,
[ALLOCATESTRATEGYTYPE] nvarchar(10) COLLATE Chinese_PRC_CI_AS NULL,
[SKUROTATION] nvarchar(10) COLLATE Chinese_PRC_CI_AS DEFAULT 'Lot' NULL,
[SHELFLIFE] int DEFAULT 0 NULL,
[ROTATION] nvarchar(10) COLLATE Chinese_PRC_CI_AS NULL,
[PALLET_ID] nvarchar(50) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
[SUB_FLAG] nvarchar(1) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
[PRODUCT_WEIGHT] float(53) DEFAULT 0 NOT NULL,
[PRODUCT_CUBE] float(53) DEFAULT 0 NOT NULL,
[ORIGCASEQTY] decimal(22,5) DEFAULT 0 NOT NULL,
[ORIGPALLETQTY] decimal(22,5) DEFAULT 0 NOT NULL,
[OKTOSUBSTITUTE] int DEFAULT 0 NOT NULL,
[ISSUBSTITUTE] int DEFAULT 0 NOT NULL,
[ORIGINALSKU] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
[ORIGINALLINENUMBER] nvarchar(5) COLLATE Chinese_PRC_CI_AS NULL,
[SHIPGROUP01] nvarchar(1) COLLATE Chinese_PRC_CI_AS DEFAULT 'N' NOT NULL,
[SHIPGROUP02] nvarchar(1) COLLATE Chinese_PRC_CI_AS DEFAULT 'N' NOT NULL,
[SHIPGROUP03] nvarchar(1) COLLATE Chinese_PRC_CI_AS DEFAULT 'N' NOT NULL,
[ACTUALSHIPDATE] datetime NULL,
[INTERMODALVEHICLE] nvarchar(10) COLLATE Chinese_PRC_CI_AS NULL,
[PICKINGINSTRUCTIONS] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
[CARTONBREAK] nvarchar(10) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
[CARTONQTYBREAK] int NULL,
[QTYINTRANSIT] decimal(22,5) DEFAULT 0 NOT NULL,
[OPPREQUEST] nvarchar(1) COLLATE Chinese_PRC_CI_AS DEFAULT 0 NULL,
[WPRELEASED] nvarchar(1) COLLATE Chinese_PRC_CI_AS DEFAULT '0' NOT NULL,
[EXTERNALLOT] nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL,
[BUYERPO] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
[GenerateContainerDetail] nvarchar(1) COLLATE Chinese_PRC_CI_AS DEFAULT
'0' NOT NULL,
[LABELNAME] nvarchar(20) COLLATE Chinese_PRC_CI_AS NULL,
[STDSSCCLABELNAME] nvarchar(20) COLLATE Chinese_PRC_CI_AS NULL,
[STDGTINLABELNAME] nvarchar(20) COLLATE Chinese_PRC_CI_AS NULL,
[RFIDSSCCLABELNAME] nvarchar(20) COLLATE Chinese_PRC_CI_AS NULL,
[RFIDGTINLABELNAME] nvarchar(20) COLLATE Chinese_PRC_CI_AS NULL,
[EXTERNALLOCSEQUENCE] nvarchar(20) COLLATE Chinese_PRC_CI_AS NULL,
[MINSHIPPERCENT] int DEFAULT '0' NOT NULL,
[LINETYPE] nvarchar(1) COLLATE Chinese_PRC_CI_AS NULL,
[COMPONENTQTY] decimal(22,5) NULL,
[COMPONENTREFERENCE] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
[OQCREQUIRED] nvarchar(1) COLLATE Chinese_PRC_CI_AS DEFAULT '0' NOT NULL,
[OQCAUTOADJUST] nvarchar(1) COLLATE Chinese_PRC_CI_AS DEFAULT '0' NOT NULL,
[ORDERDETAILID] nvarchar(32) COLLATE Chinese_PRC_CI_AS NULL,
[LOTTABLE11] datetime NULL,
[LOTTABLE12] datetime NULL,
[SOURCEVERSION] nvarchar(22) COLLATE Chinese_PRC_CI_AS NULL,
[REFERENCETYPE] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL,
[REFERENCEDOCUMENT] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL,
[REFERENCELOCATION] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL,
[REFERENCEVERSION] nvarchar(20) COLLATE Chinese_PRC_CI_AS NULL,
[REFERENCELINE] nvarchar(20) COLLATE Chinese_PRC_CI_AS NULL,
[CUBICMETER] decimal(22,5) DEFAULT 0 NULL,
[HUNDREDWEIGHT] decimal(22,5) DEFAULT 0 NULL,
[StageLoc] nvarchar(20) COLLATE Chinese_PRC_CI_AS NULL,
[FULFILLQTY] decimal(22,5) DEFAULT 0 NOT NULL,
[DAPICKSORT] nvarchar(1) COLLATE Chinese_PRC_CI_AS DEFAULT '1' NULL,
[SHORTSHIPREASON] nvarchar(10) COLLATE Chinese_PRC_CI_AS NULL,
[ORIGLAYERQTY] decimal(22,5) DEFAULT 0 NOT NULL,
[ReferenceAccountingEntity] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL,
[ReferenceScheduleLine] nvarchar(20) COLLATE Chinese_PRC_CI_AS NULL,
[BASEORDERKEY] nvarchar(10) COLLATE Chinese_PRC_CI_AS NULL,
[CONVERTEDQTY] decimal(22,5) NULL,
[PROCESSEDQTY] decimal(22,5) NULL,
[QTYTOPROCESS] decimal(22,5) NULL,
[SEQUENCE] decimal(18) NULL,
[REQUISITIONDOCUMENT] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL,
[REQUISITIONACCOUNTINGENTITY] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL,
[REQUISITIONLOCATION] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL,
[REQUISITIONVERSION] nvarchar(20) COLLATE Chinese_PRC_CI_AS NULL,
[REQUISITIONLINE] nvarchar(20) COLLATE Chinese_PRC_CI_AS NULL,
[REQUISITIONSCHEDULELINE] nvarchar(20) COLLATE Chinese_PRC_CI_AS NULL,
[PURCHASEORDERDOCUMENT] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL,
[PURCHASEORDERACCOUNTINGENTITY] nvarchar(64) COLLATE Chinese_PRC_CI_AS
NULL,
[PURCHASEORDERLOCATION] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL,
[PURCHASEORDERVERSION] nvarchar(20) COLLATE Chinese_PRC_CI_AS NULL,
[PURCHASEORDERLINE] nvarchar(20) COLLATE Chinese_PRC_CI_AS NULL,
[PURCHASEORDERSCHEDULELINE] nvarchar(20) COLLATE Chinese_PRC_CI_AS NULL,
[SALESORDERDOCUMENT] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL,
[SALESORDERACCOUNTINGENTITY] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL,
[SALESORDERLOCATION] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL,
[SALESORDERVERSION] nvarchar(20) COLLATE Chinese_PRC_CI_AS NULL,
[SALESORDERLINE] nvarchar(20) COLLATE Chinese_PRC_CI_AS NULL,
[SALESORDERSCHEDULELINE] nvarchar(20) COLLATE Chinese_PRC_CI_AS NULL,
[IDREQUIRED] nvarchar(18) COLLATE Chinese_PRC_CI_AS NULL,
[KITORDERASN] nvarchar(10) COLLATE Chinese_PRC_CI_AS NULL,
[PALLETESTIMATE] decimal(22,5) NULL,
[BACKFLUSHINDICATOR] nvarchar(1) COLLATE Chinese_PRC_CI_AS DEFAULT '0'
NULL,
[ALLOCLOTLIMIT] nvarchar(1) COLLATE Chinese_PRC_CI_AS NULL,
[LASTSHIPPEDDATE] datetime NULL,
[LABELSPRINTED] nvarchar(1) COLLATE Chinese_PRC_CI_AS DEFAULT '0' NOT NULL,
[NEWALLOCATIONSTRATEGY] nvarchar(10) COLLATE Chinese_PRC_CI_AS NULL,
[ITEMCLASS] nvarchar(10) COLLATE Chinese_PRC_CI_AS NULL,
[RUNINQTY] decimal(22,5) DEFAULT 0 NULL,
[RUNOUTQTY] decimal(22,5) DEFAULT 0 NULL,
[FGQTYRECEIVED] decimal(22,5) DEFAULT 0 NULL,
[RUNINUOM] nvarchar(10) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
[RUNOUTUOM] nvarchar(10) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
[EXTERNALSHIPREQUESTQTY] decimal(22,5) NULL,
[BATCHORDERNUMBER] nvarchar(10) COLLATE Chinese_PRC_CI_AS NULL,
[BATCHORDERLINE] nvarchar(5) COLLATE Chinese_PRC_CI_AS NULL,
[ORIGORDERNUMBER] nvarchar(10) COLLATE Chinese_PRC_CI_AS NULL,
[ORIGORDERLINE] nvarchar(5) COLLATE Chinese_PRC_CI_AS NULL,
[ADDDATE] datetime DEFAULT getutcdate() NOT NULL,
[ADDWHO] nvarchar(256) COLLATE Chinese_PRC_CI_AS DEFAULT user_name() NOT
NULL,
[EDITDATE] datetime DEFAULT getutcdate() NOT NULL,
[EDITWHO] nvarchar(256) COLLATE Chinese_PRC_CI_AS DEFAULT user_name() NOT
NULL,
[rtxcrmlinenumber] varchar(15) COLLATE Chinese_PRC_CI_AS NULL,
[rtxdocument] nvarchar(10) COLLATE Chinese_PRC_CI_AS NULL,
[rtxsapso] nvarchar(20) COLLATE Chinese_PRC_CI_AS NULL,
[rtxsapsoline] nvarchar(10) COLLATE Chinese_PRC_CI_AS NULL,
[rtxuom] nvarchar(30) COLLATE Chinese_PRC_CI_AS NULL,
[rtxumwrk] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
[rtxumlog] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
[RTXCRMORDERKEY] nvarchar(30) COLLATE Chinese_PRC_CI_AS NULL,
[RTXROTATION1] nvarchar(10) COLLATE Chinese_PRC_CI_AS DEFAULT '1' NOT NULL,
[RTXSKUROTATION1] nvarchar(10) COLLATE Chinese_PRC_CI_AS DEFAULT
'Lottable04' NOT NULL,
[RTXROTATION2] nvarchar(10) COLLATE Chinese_PRC_CI_AS DEFAULT '1' NOT NULL,
[RTXSKUROTATION2] nvarchar(10) COLLATE Chinese_PRC_CI_AS DEFAULT
'Lottable03' NOT NULL,
[RTX_EDITFLAG_SAP] nvarchar(5) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT
NULL,
[RTX_QUEUE_SAP] int DEFAULT 0 NOT NULL,
[RTX_DATE_SAP] date NULL,
[RTXCOSTCENTER] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
[rtxzshrq] numeric(22,5) NULL,
[rtxcurrency] nvarchar(20) COLLATE Chinese_PRC_CI_AS NULL,
[rtxtariff] nvarchar(20) COLLATE Chinese_PRC_CI_AS NULL,
[rtxfreight] numeric(22,5) NULL,
[RTXSAPPOLINE] nvarchar(20) COLLATE Chinese_PRC_CI_AS NULL,
[RTXINVOICENUMBER] nvarchar(20) COLLATE Chinese_PRC_CI_AS NULL,
[C_POSITION] varchar(20) COLLATE Chinese_PRC_CI_AS DEFAULT ' ' NULL,
[rtxbusinessoperator] varchar(30) COLLATE Chinese_PRC_CI_AS NULL,
[rtxboffice] varchar(50) COLLATE Chinese_PRC_CI_AS NULL,
[rtxcrmline] varchar(30) COLLATE Chinese_PRC_CI_AS NULL
)
GO
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscr...@seatunnel.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
