AutoInvoice Interface not loading
TAX Lines
AutoInvoice will load tax line only if you have
successfully. linked the TAX line to it's Invoice line.
The TAX lines will be ignored if it cannot be linked
with Invoice Line's. To link Tax Line with Invoice Line you must use the
Line Transaction Flexfield.
The segment values of the line transaction flexfield uniquely
identify any given line in the
RA_INTERFACE_LINES table. Use the following example to
load TAX lines attached to Invoice Line:-
Attributes |
Line |
Tax Line |
INTERFACE_LINE_CONTEXT |
'STD. ORDER' |
'STD. ORDER' |
INTERFACE_LINE_ATTRIBUTE1 |
'1000000' |
'1000000' |
INTERFACE_LINE_ATTRIBUTE2 |
'01' |
'01' |
INTERFACE_LINE_ATTRIBUTE3 |
'LINE' |
'TAX' |
LINK_TO_LINE_CONTEXT |
null |
'STD. ORDER' |
LINK_TO_LINE_ATTRIBUTE1 |
null |
'1000000' |
LINK_TO_LINE_ATTRIBUTE2 |
null |
'01' |
LINK_TO_LINE_ATTRIBUTE3 |
null |
'LINE' |
The INTERFACE_LINE_ATTRIBUTE1 is an order number, INTERFACE_LINE_ATTRIBUTE2
is the Order line # and INTERFACE_LINE_ATTRIBUTE3 is
LINE_TYPE invoice lines and tax lines.
The combination of the three INTERFACE_LINE_ATTRIBUTE's
makes each row in the
RA_INTERFACE_LINES unique, and the LINK_TO_LINE_ATTRIBUTE's
are used to link this TAX line to INVOICE LINE.
Have a Oracle Question
Do
you have an Oracle Question?
Oracle Books
Oracle
Certification, Database Administration, SQL, Application, Programming Reference
Books
Oracle Application
Oracle
Application Hints and Tips
Oracle Home
Oracle
Database, SQL, Application, Programming Tips
All the site contents are Copyright © www.erpgreat.com
and the content authors. All rights reserved.
All product names are trademarks of their respective
companies.
The site www.erpgreat.com is not affiliated with or endorsed
by any company listed at this site.
Every effort is made to ensure the content integrity.
Information used on this site is at your own risk.
The content on this site may not be reproduced
or redistributed without the express written permission of
www.erpgreat.com or the content authors.
|