Pages

OracleEBSpro is purely for knowledge sharing and learning purpose, with the main focus on Oracle E-Business Suite Product and other related Oracle Technologies.

I'm NOT responsible for any damages in whatever form caused by the usage of the content of this blog.

I share my Oracle knowledge through this blog. All my posts in this blog are based on my experience, reading oracle websites, books, forums and other blogs. I invite people to read and suggest ways to improve this blog.


Tuesday, April 9, 2013

AR Transaction Flexfields



Transaction flexfields are descriptive flexfields that AutoInvoice uses to identify transactions and transaction lines. Receivables lets you determine how you want to build your transaction flexfield structure and what information you want to capture.
There are four types of transaction flexfields:
  1. Line Transaction Flexfield
  2. Reference Transaction Flexfield
  3. Link–To Transaction Flexfield
  4. Invoice Transaction Flexfield
You must define the Line Transaction Flexfield if you use AutoInvoice. You can use the Line Transaction Flexfield to reference and link to other lines because the Line Transaction Flexfield is unique for each transaction line. AutoInvoice always uses the Line Transaction Flexfield structure for both the Link–to and Reference information when importing invoices. 
You must explicitly define the Link–to, Reference, and Invoice Transaction Flexfield structures only if this information is to be displayed on a custom window. Receivables gives you the option of displaying Invoice Transaction Flexfield information in the reference column of invoice lists of values. Use the System Profile Option AR: Transaction Flexfield QuickPick Attribute to select the Invoice Transaction Flexfield segment that you want to display. For example, if you want to be able to  reference the order number for imported invoices when using an invoice list of values, you must assign the transaction flexfield segment that holds the order number to the AR: Transaction Flexfield QuickPick Attribute profile option. The order number will now display in the reference column of invoice lists of values.
Line Transaction Flexfield
Use columns INTERFACE_LINE_ATTRIBUTE1–15 and INTERFACE_LINE_CONTEXT to define the Line Transaction Flexfield.
Line Transaction Flexfields are unique for each record in the interface table and therefore can be used as record identifiers.
Reference Transaction Flexfield
Reference Transaction Flexfields have the same structure as the Line Transaction Flexfields.
Reference Transaction Flexfields are used to apply a credit memo to an invoice or associate an invoice to a specific commitment. For example, to refer a credit memo to a specific invoice, use the REFERENCE_LINE_ATTRIBUTE1–15 and
REFERENCE_LINE_CONTEXT columns of the credit memo to enter the Line Transaction Flexfield of the invoice. To refer an invoice to a specific commitment, use the REFERENCE_LINE_ATTRIBUTE1–15 and REFERENCE_LINE_CONTEXT columns of the invoice to enter the Line Transaction Flexfield of the commitment.
Link–To Transaction Flexfield
Link–To Transaction Flexfields also have the same structure as the Line Transaction Flexfield.
Use Link–To Transaction Flexfields to link transaction lines together in the interface table. For example, you might want to import tax and freight charges that are associated with specific transaction lines. If you want to associate a specific tax line with a specific transaction line, use the LINK_TO_LINE_ATTRIBUTE1–15 and LINK_TO_LINE_CONTEXT columns of the tax line to enter the Line Transaction Flexfield of the invoice.
Invoice Transaction Flexfields
Create a new flexfield with a similar structure as the Line Transaction Flexfield, but only include header level segments. For example, if the Line Transaction Flexfield structure has four segments and the last two segments contain line level information, define your Invoice Transaction Flexfield using the first two segments only. Segments included in the Invoice Transaction Flexfield should be included in the AutoInvoice grouping rules.
Transaction Flexfields: An example
This example illustrates how records described in the Line Transaction Flexfield are linked in the interface table using the Link–To or the Reference Transaction Flexfield columns.
Consider an invoice against a commitment with four records: two Line records, one header Freight record, and one Tax record. The transaction type for records of an invoice is INV.
The table below shows how the four invoice records are represented in the interface table. There are two segments enabled for the Line Transaction Flexfield OM (Order Management) context. The 

No comments:

Post a Comment