Domovská stránka Prehľadávať Pomoc
Prihlásiť sa
Neil
/
Q5
1
0
Fork 0
Súbory Issues 0 Pull requesty 0 Wiki
Strom: 5909de25d0
Branche Tagy
Q5
/
ws_objects
/
Ew_mainface.pbl.src
/
pl_test_1.srp

pl_test_1.srp 4.0 KB
História Raw

12345678910111213141516171819202122232425262728293031323334353637383940414243 
  1. $PBExportHeader$pl_test_1.srp
    2. 

  2. PIPELINE(source_connect=EWisERP_v50,destination_connect=EWisERP_v50_me,type=create,commit=100,errors=100,keyname="u_Bmstpaymx_x")
    3. 

  3. SOURCE(name="u_Bmstpaymx",COLUMN(type=long,name="scid",dbtype="int",key=yes,nulls_allowed=no)
    4. 

  4.  COLUMN(type=long,name="payid",dbtype="int",key=yes,nulls_allowed=no)
    5. 

  5.  COLUMN(type=long,name="listno",dbtype="int",key=yes,nulls_allowed=no)
    6. 

  6.  COLUMN(type=char,name="Billcode",dbtype="char(30)",nulls_allowed=no)
    7. 

  7.  COLUMN(type=datetime,name="paydate",dbtype="datetime",nulls_allowed=yes)
    8. 

  8.  COLUMN(type=long,name="banktypeid",dbtype="int",nulls_allowed=no)
    9. 

  9.  COLUMN(type=decimal,name="Mstpayamt",dbtype="decimal(18,2)",nulls_allowed=no)
    10. 

  10.  COLUMN(type=decimal,name="Payamt",dbtype="decimal(18,2)",nulls_allowed=no)
    11. 

  11.  COLUMN(type=char,name="opemp",dbtype="char(10)",nulls_allowed=no)
    12. 

  12.  COLUMN(type=datetime,name="opdate",dbtype="datetime",nulls_allowed=yes)
    13. 

  13.  COLUMN(type=varchar,name="dscrp",dbtype="nvarchar(255)",nulls_allowed=no)
    14. 

  14.  COLUMN(type=char,name="inrep",dbtype="char(20)",nulls_allowed=no)
    15. 

  15.  COLUMN(type=int,name="buildtype",dbtype="tinyint",nulls_allowed=no)
    16. 

  16.  COLUMN(type=long,name="buybillid",dbtype="int",nulls_allowed=no)
    17. 

  17.  COLUMN(type=long,name="ctmint",dbtype="int",nulls_allowed=no)
    18. 

  18.  COLUMN(type=long,name="sptid",dbtype="int",nulls_allowed=no)
    19. 

  19.  COLUMN(type=long,name="itemid",dbtype="int",nulls_allowed=no)
    20. 

  20.  COLUMN(type=int,name="delflag",dbtype="tinyint",nulls_allowed=no)
    21. 

  21.  COLUMN(type=long,name="moneyid",dbtype="int",nulls_allowed=no)
    22. 

  22.  COLUMN(type=char,name="relcode",dbtype="char(50)",nulls_allowed=no))
    23. 

  23. 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~")) ")
    24. 

  24. DESTINATION(name="u_Bmstpaymx",COLUMN(type=long,name="scid",dbtype="int",key=yes,nulls_allowed=no,initial_value="0")
    25. 

  25.  COLUMN(type=long,name="payid",dbtype="int",key=yes,nulls_allowed=no,initial_value="0")
    26. 

  26.  COLUMN(type=long,name="listno",dbtype="int",key=yes,nulls_allowed=no,initial_value="0")
    27. 

  27.  COLUMN(type=char,name="Billcode",dbtype="char(30)",nulls_allowed=no,initial_value="spaces")
    28. 

  28.  COLUMN(type=datetime,name="paydate",dbtype="datetime",nulls_allowed=yes)
    29. 

  29.  COLUMN(type=long,name="banktypeid",dbtype="int",nulls_allowed=no,initial_value="0")
    30. 

  30.  COLUMN(type=decimal,name="Mstpayamt",dbtype="decimal(18,2)",nulls_allowed=no,initial_value="0")
    31. 

  31.  COLUMN(type=decimal,name="Payamt",dbtype="decimal(18,2)",nulls_allowed=no,initial_value="0")
    32. 

  32.  COLUMN(type=char,name="opemp",dbtype="char(10)",nulls_allowed=no,initial_value="spaces")
    33. 

  33.  COLUMN(type=datetime,name="opdate",dbtype="datetime",nulls_allowed=yes)
    34. 

  34.  COLUMN(type=varchar,name="dscrp",dbtype="nvarchar(255)",nulls_allowed=no,initial_value="spaces")
    35. 

  35.  COLUMN(type=char,name="inrep",dbtype="char(20)",nulls_allowed=no,initial_value="spaces")
    36. 

  36.  COLUMN(type=int,name="buildtype",dbtype="tinyint",nulls_allowed=no,initial_value="0")
    37. 

  37.  COLUMN(type=long,name="buybillid",dbtype="int",nulls_allowed=no,initial_value="0")
    38. 

  38.  COLUMN(type=long,name="ctmint",dbtype="int",nulls_allowed=no,initial_value="0")
    39. 

  39.  COLUMN(type=long,name="sptid",dbtype="int",nulls_allowed=no,initial_value="0")
    40. 

  40.  COLUMN(type=long,name="itemid",dbtype="int",nulls_allowed=no,initial_value="0")
    41. 

  41.  COLUMN(type=int,name="delflag",dbtype="tinyint",nulls_allowed=no,initial_value="0")
    42. 

  42.  COLUMN(type=long,name="moneyid",dbtype="int",nulls_allowed=no,initial_value="0")
    43. 

  43.  COLUMN(type=char,name="relcode",dbtype="char(50)",nulls_allowed=no,initial_value="spaces"))
    44.