Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO OUT_569_SALESORDER_HEADER(
- FLOW_RUN_ID,
- BUSINESS_UNIT_NAME,
- TRANSACTION_ON,
- TRANSACTION_TYPE_CODE,
- SOURCE_TRANSACTION_ID,
- BUYING_PARTY_ID,
- BUYING_PARTY_CONTACT_ID,
- TRANSACTIONAL_CURRENCY_CODE,
- REQUESTING_BUSINESS_UNIT_NAME,
- REQUESTED_FULFILLMENT_ORGANIZATION_ID,
- SOURCE_TRANSACTION_NUMBER,
- SOURCE_TRANSACTION_SYSTEM,
- BILLTOCUSTOMER_ACCOUNT_NUMBER,
- BILLTOCUSTOMER_SITE_USE_ID,
- SHIPTOCUSTOMER_CONTACT_ID,
- SHIPTOCUSTOMER_PARTY_ID,
- SHIPTOCUSTOMER_PARTY_NAME,
- SHIPTOCUSTOMER_PARTY_NUMBER,
- SHIPTOCUSTOMER_PERSON_FIRST_NAME,
- SHIPTOCUSTOMER_SITE_ID,
- SHIPTOCUSTOMER_ADDRESS1,
- SHIPTOCUSTOMER_CITY,
- SHIPTOCUSTOMER_POSTAL_CODE,
- SHIPTOCUSTOMER_COUNTRY,
- SHIPTOCUSTOMER_SOURCE_ADDRESS_ID,
- ADDITIONALINFORMATION_CATEGORY,
- ADDITIONALINFORMATION_CONTEXT_CODE,
- ADDITIONALINFORMATION_SHOP,
- ADDITIONALINFORMATION_CHANNEL,
- ADDITIONALINFORMATION_SOURCE_ORDER_NUMBER,
- ADDITIONALINFORMATION_CREDIT_NOTE_FOR_EXCHANGE,
- ADDITIONALINFORMATION_IFRS15,
- ADDITIONALINFORMATION_ACCOUNTING_COST_CENTER
- )
- VALUES(
- IN_FLOW_RUN_ID,
- ROW_OUT.BUSINESS_UNIT_NAME,
- ROW_OUT.TRANSACTION_ON,
- TRANSACTION_TYPE_CODE,
- SOURCE_ORDER_NUMBER,
- ROW_OUT.BUYING_PARTY_ID,
- NULL,
- ROW_OUT.CURRENCY,
- ROW_OUT.BUSINESS_UNIT_NAME,
- REQUESTED_FULFILLMENT_ORGANIZATION_ID,
- SOURCE_ORDER_NUMBER,
- SOURCE_TRANSACTION_SYSTEM,
- ROW_OUT.ACCOUNT_NUMBER,
- ROW_OUT.SITE_USE_ID,
- NULL,
- ROW_OUT.PARTY_ID,
- ROW_OUT.PARTY_NAME,
- ROW_OUT.PARTY_NUMBER,
- NULL,
- ROW_OUT.SITE_ID,
- ROW_OUT.ADDRESS1,
- ROW_OUT.CITY,
- ROW_OUT.POSTAL_CODE,
- ROW_OUT.COUNTRY,
- SOURCE_ADDRESS_ID_VALUE,
- ADDITIONALINFORMATION_CATEGORY,
- CONTEXT_CODE,
- ROW_OUT.SHOP_CODE,
- CHANNEL,
- SOURCE_ORDER_NUMBER,
- null,
- null,
- ROW_OUT.ACCOUNTING_COST_CENTER
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement