$PBExportHeader$pl_test_1.srp
PIPELINE(source_connect=EWisERP_v50,destination_connect=EWisERP_v50_me,type=create,commit=100,errors=100,keyname="u_Bmstpaymx_x")
SOURCE(name="u_Bmstpaymx",COLUMN(type=long,name="scid",dbtype="int",key=yes,nulls_allowed=no)
 COLUMN(type=long,name="payid",dbtype="int",key=yes,nulls_allowed=no)
 COLUMN(type=long,name="listno",dbtype="int",key=yes,nulls_allowed=no)
 COLUMN(type=char,name="Billcode",dbtype="char(30)",nulls_allowed=no)
 COLUMN(type=datetime,name="paydate",dbtype="datetime",nulls_allowed=yes)
 COLUMN(type=long,name="banktypeid",dbtype="int",nulls_allowed=no)
 COLUMN(type=decimal,name="Mstpayamt",dbtype="decimal(18,2)",nulls_allowed=no)
 COLUMN(type=decimal,name="Payamt",dbtype="decimal(18,2)",nulls_allowed=no)
 COLUMN(type=char,name="opemp",dbtype="char(10)",nulls_allowed=no)
 COLUMN(type=datetime,name="opdate",dbtype="datetime",nulls_allowed=yes)
 COLUMN(type=varchar,name="dscrp",dbtype="nvarchar(255)",nulls_allowed=no)
 COLUMN(type=char,name="inrep",dbtype="char(20)",nulls_allowed=no)
 COLUMN(type=int,name="buildtype",dbtype="tinyint",nulls_allowed=no)
 COLUMN(type=long,name="buybillid",dbtype="int",nulls_allowed=no)
 COLUMN(type=long,name="ctmint",dbtype="int",nulls_allowed=no)
 COLUMN(type=long,name="sptid",dbtype="int",nulls_allowed=no)
 COLUMN(type=long,name="itemid",dbtype="int",nulls_allowed=no)
 COLUMN(type=int,name="delflag",dbtype="tinyint",nulls_allowed=no)
 COLUMN(type=long,name="moneyid",dbtype="int",nulls_allowed=no)
 COLUMN(type=char,name="relcode",dbtype="char(50)",nulls_allowed=no))
RETRIEVE(statement="PBSELECT( VERSION(400) TABLE(NAME=~"u_Bmstpaymx~" ) COLUMN(NAME=~"u_Bmstpaymx.scid~") COLUMN(NAME=~"u_Bmstpaymx.payid~") COLUMN(NAME=~"u_Bmstpaymx.listno~") COLUMN(NAME=~"u_Bmstpaymx.Billcode~") COLUMN(NAME=~"u_Bmstpaymx.paydate~") COLUMN(NAME=~"u_Bmstpaymx.banktypeid~") COLUMN(NAME=~"u_Bmstpaymx.Mstpayamt~") COLUMN(NAME=~"u_Bmstpaymx.Payamt~") COLUMN(NAME=~"u_Bmstpaymx.opemp~") COLUMN(NAME=~"u_Bmstpaymx.opdate~") COLUMN(NAME=~"u_Bmstpaymx.dscrp~") COLUMN(NAME=~"u_Bmstpaymx.inrep~") COLUMN(NAME=~"u_Bmstpaymx.buildtype~") COLUMN(NAME=~"u_Bmstpaymx.buybillid~") COLUMN(NAME=~"u_Bmstpaymx.ctmint~") COLUMN(NAME=~"u_Bmstpaymx.sptid~") COLUMN(NAME=~"u_Bmstpaymx.itemid~") COLUMN(NAME=~"u_Bmstpaymx.delflag~") COLUMN(NAME=~"u_Bmstpaymx.moneyid~") COLUMN(NAME=~"u_Bmstpaymx.relcode~")) ")
DESTINATION(name="u_Bmstpaymx",COLUMN(type=long,name="scid",dbtype="int",key=yes,nulls_allowed=no,initial_value="0")
 COLUMN(type=long,name="payid",dbtype="int",key=yes,nulls_allowed=no,initial_value="0")
 COLUMN(type=long,name="listno",dbtype="int",key=yes,nulls_allowed=no,initial_value="0")
 COLUMN(type=char,name="Billcode",dbtype="char(30)",nulls_allowed=no,initial_value="spaces")
 COLUMN(type=datetime,name="paydate",dbtype="datetime",nulls_allowed=yes)
 COLUMN(type=long,name="banktypeid",dbtype="int",nulls_allowed=no,initial_value="0")
 COLUMN(type=decimal,name="Mstpayamt",dbtype="decimal(18,2)",nulls_allowed=no,initial_value="0")
 COLUMN(type=decimal,name="Payamt",dbtype="decimal(18,2)",nulls_allowed=no,initial_value="0")
 COLUMN(type=char,name="opemp",dbtype="char(10)",nulls_allowed=no,initial_value="spaces")
 COLUMN(type=datetime,name="opdate",dbtype="datetime",nulls_allowed=yes)
 COLUMN(type=varchar,name="dscrp",dbtype="nvarchar(255)",nulls_allowed=no,initial_value="spaces")
 COLUMN(type=char,name="inrep",dbtype="char(20)",nulls_allowed=no,initial_value="spaces")
 COLUMN(type=int,name="buildtype",dbtype="tinyint",nulls_allowed=no,initial_value="0")
 COLUMN(type=long,name="buybillid",dbtype="int",nulls_allowed=no,initial_value="0")
 COLUMN(type=long,name="ctmint",dbtype="int",nulls_allowed=no,initial_value="0")
 COLUMN(type=long,name="sptid",dbtype="int",nulls_allowed=no,initial_value="0")
 COLUMN(type=long,name="itemid",dbtype="int",nulls_allowed=no,initial_value="0")
 COLUMN(type=int,name="delflag",dbtype="tinyint",nulls_allowed=no,initial_value="0")
 COLUMN(type=long,name="moneyid",dbtype="int",nulls_allowed=no,initial_value="0")
 COLUMN(type=char,name="relcode",dbtype="char(50)",nulls_allowed=no,initial_value="spaces"))