Advertisement
Guest User

Untitled

a guest
Nov 16th, 2019
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.80 KB | None | 0 0
  1. INSERT INTO OUT_569_SALESORDER_HEADER(
  2. FLOW_RUN_ID,
  3. BUSINESS_UNIT_NAME,
  4. TRANSACTION_ON,
  5. TRANSACTION_TYPE_CODE,
  6. SOURCE_TRANSACTION_ID,
  7. BUYING_PARTY_ID,
  8. BUYING_PARTY_CONTACT_ID,
  9. TRANSACTIONAL_CURRENCY_CODE,
  10. REQUESTING_BUSINESS_UNIT_NAME,
  11. REQUESTED_FULFILLMENT_ORGANIZATION_ID,
  12. SOURCE_TRANSACTION_NUMBER,
  13. SOURCE_TRANSACTION_SYSTEM,
  14. BILLTOCUSTOMER_ACCOUNT_NUMBER,
  15. BILLTOCUSTOMER_SITE_USE_ID,
  16. SHIPTOCUSTOMER_CONTACT_ID,
  17. SHIPTOCUSTOMER_PARTY_ID,
  18. SHIPTOCUSTOMER_PARTY_NAME,
  19. SHIPTOCUSTOMER_PARTY_NUMBER,
  20. SHIPTOCUSTOMER_PERSON_FIRST_NAME,
  21. SHIPTOCUSTOMER_SITE_ID,
  22. SHIPTOCUSTOMER_ADDRESS1,
  23. SHIPTOCUSTOMER_CITY,
  24. SHIPTOCUSTOMER_POSTAL_CODE,
  25. SHIPTOCUSTOMER_COUNTRY,
  26. SHIPTOCUSTOMER_SOURCE_ADDRESS_ID,
  27. ADDITIONALINFORMATION_CATEGORY,
  28. ADDITIONALINFORMATION_CONTEXT_CODE,
  29. ADDITIONALINFORMATION_SHOP,
  30. ADDITIONALINFORMATION_CHANNEL,
  31. ADDITIONALINFORMATION_SOURCE_ORDER_NUMBER,
  32. ADDITIONALINFORMATION_CREDIT_NOTE_FOR_EXCHANGE,
  33. ADDITIONALINFORMATION_IFRS15,
  34. ADDITIONALINFORMATION_ACCOUNTING_COST_CENTER
  35. )
  36. VALUES(
  37. IN_FLOW_RUN_ID,
  38. ROW_OUT.BUSINESS_UNIT_NAME,
  39. ROW_OUT.TRANSACTION_ON,
  40. TRANSACTION_TYPE_CODE,
  41. SOURCE_ORDER_NUMBER,
  42. ROW_OUT.BUYING_PARTY_ID,
  43. NULL,
  44. ROW_OUT.CURRENCY,
  45. ROW_OUT.BUSINESS_UNIT_NAME,
  46. REQUESTED_FULFILLMENT_ORGANIZATION_ID,
  47. SOURCE_ORDER_NUMBER,
  48. SOURCE_TRANSACTION_SYSTEM,
  49. ROW_OUT.ACCOUNT_NUMBER,
  50. ROW_OUT.SITE_USE_ID,
  51. NULL,
  52. ROW_OUT.PARTY_ID,
  53. ROW_OUT.PARTY_NAME,
  54. ROW_OUT.PARTY_NUMBER,
  55. NULL,
  56. ROW_OUT.SITE_ID,
  57. ROW_OUT.ADDRESS1,
  58. ROW_OUT.CITY,
  59. ROW_OUT.POSTAL_CODE,
  60. ROW_OUT.COUNTRY,
  61. SOURCE_ADDRESS_ID_VALUE,
  62. ADDITIONALINFORMATION_CATEGORY,
  63. CONTEXT_CODE,
  64. ROW_OUT.SHOP_CODE,
  65. CHANNEL,
  66. SOURCE_ORDER_NUMBER,
  67. null,
  68. null,
  69. ROW_OUT.ACCOUNTING_COST_CENTER
  70. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement