Wednesday, March 30, 2016

Insert Script for Open AR Transaction (Invoice) for R12



INSERT
INTO Apps.ra_interface_lines_all
  (
    trx_number,
    batch_source_name,
    line_type,
    Inventory_item_id,
description,
uom_code,
quantity_ordered,
    currency_code,
    amount,
    org_id ,
    conversion_type,
    conversion_rate ,
    orig_system_bill_address_id,
    orig_system_ship_address_id,
    orig_system_bill_customer_id,
    orig_system_ship_customer_id ,
    primary_salesrep_id,
    memo_line_id,
    memo_line_name, -- (standard lines)
    creation_date,
    created_by ,
    tax_code,
    gl_date ,
    term_id,
    term_name,
    cust_trx_type_id,
    cust_trx_type_name ,
    interface_line_context,
    interface_line_attribute1,
    interface_line_attribute2,
    interface_line_attribute3,
    interface_line_attribute4
  )
  VALUES
  (
    '9997',
    'CONVERSION_GP', -- Name in ra_batch_sources_all
    'LINE',
    2256906, -- Inventory_item_id in mtl_system_items_b
'NOVASURE STERILIZED DEVICE 3 PK', -- Description in mtl_system_items_b
'EA',
2,
    'USD', -- Currency_code in fnd_currencies
    150,
85 ,  -- Organization_id in hr_operating_units
    'User',
    1 ,
    377980, -- cust_acct_site_id in hz_cust_acct_sites_all
NULL, -- cust_acct_site_id in hz_cust_acct_sites_all
2955128, -- cust_account_id in hz_cust_accounts
NULL , -- cust_account_id in hz_cust_accounts
    -3, -- salesrep_id in jtf_rs_salesreps
    NULL, -- memo_line_id in ar_memo_lines_all_tl
    NULL, -- Name in ar_memo_lines_all_tl
    SYSDATE,
    1238 , -- User_Id in fnd_user
    NULL,
    SYSDATE ,
    1010, -- term_id in ra_terms_tl
    '90 NET', -- Name in ra_terms_tl
    5396, -- cust_trx_type_id in ra_cust_trx_types_all
    'GPI CORP CONV INV' , -- Name in ra_cust_trx_types_all
    'CONVERSION',
    '9997',
    'GENPROBE_TEST',
    'Testing',
    'Test'
  );

-- Submit the "Autoinvoice Master Program" Program from the respective OU

No comments:

Post a Comment

How to improve blog performance

Improving the performance of a blog can involve a variety of strategies, including optimizing the website's technical infrastructure, im...