Sample scripts to populate the table for various scenarios:
INSERT INTO ra_interface_lines_all
( interface_line_context
, interface_line_attribute1
, interface_line_attribute2
, amount
, batch_source_name
, conversion_rate
, conversion_type
, currency_code
, cust_trx_type_id
, description
, gl_date
, line_type
, orig_system_bill_address_id
, orig_system_bill_customer_id
, quantity
, unit_selling_price
, term_id
, taxable_flag
, amount_includes_tax_flag
, set_of_books_id
, org_id)
VALUES ( 'XAOA'
, 'All Oracle Apps 2'
, 'ALLORACLEAPPS.COM 2'
, 1000.00
, 'AOA Transaction Source'
, 1
, 'User'
, 'USD'
, 3436
, 'All Oracle Apps 2 - ITEM #1'
, '10-DEC-2013'
, 'LINE'
, 11842
, 126871
, 10
, 100.00
, 1228
, 'Y'
, 'N'
, 1
, 204);
COMMIT;
No comments:
Post a Comment