Friday, December 12, 2008

R12 AR Invoice creation Script

INSERT INTO RA_INTERFACE_LINES_ALL
(batch_source_name,
line_type,
description,
conversion_type,
currency_code,
inventory_item_id,
created_by,
creation_date,
last_updated_by,
last_update_date,
amount,
term_name,
term_id,
trx_date, primary_salesrep_id,
cust_trx_type_id,
orig_system_bill_customer_id,
orig_system_bill_address_id,
orig_system_sold_customer_id,
conversion_rate, uom_code,
line_number,
interface_line_attribute1,
interface_line_attribute2,
interface_line_context,
quantity,org_id
)
VALUES ('LEGACY', 'LINE', 'Maintenance', 'User',
'USD',
8451, 1012015,
SYSDATE,1012015,
SYSDATE,
10000, '30 NET', 4,
SYSDATE, 10068,
1,
1288,
1338,
1288,
1, 'Ea',
1,
'631152600',
'1',
'VISION BUILD',
2, 204
);

No comments: