Oracle EBS AR运费记录

Oracle EBS AR运费记录

根据订单(Order Entry)生成AR时，运费处理有2种

第一种 常见的是AR接口表中 多个运费行 ， 在生成AR时会汇总记录成 一个运费行，读者可以理解为标准自动开票程序跑出的结果，无需客户化。

第二种 是 希望AR接口表中 多个运费行 ， 在生成AR时会汇总记录成 多个运费行

针对第二种需要进行客户化处理

主要是处理LINE_TYPE = 'FRIEGHT'字段 ， 

使用 LINE_TYPE = 'FRIEGHT' 对应的LINE_TYPE = 'LINE' 信息 对以下字段进行赋值即可

link_to_line_context       

link_to_line_attribute1  

link_to_line_attribute2  

link_to_line_attribute3 

link_to_line_attribute4 

link_to_line_attribute5 

link_to_line_attribute6 

link_to_line_attribute7 

link_to_line_attribute8  

link_to_line_attribute9 

link_to_line_attribute10 

link_to_line_attribute11 

link_to_line_attribute12 

link_to_line_attribute13 

link_to_line_attribute14 

link_to_line_attribute15

如果想知道为什么，请仔细阅读下面的内容。

LINK_TO_LINE_ATTRIBUTE1-15

Enter the link to your Transaction Flexfield attribute values.

If LINE_TYPE = LINE, CHARGES, or you are passing header freight, do not enter values in these columns.

If LINE_TYPE = TAX or you are passing freight for a specific line, you must enter a value. Use link-to-line attributes to associate this tax or freight line to another transaction line in RA_INTERFACE_LINES_ALL. All tax lines and freight for specific lines must be associated with a line that has a LINE_TYPE of LINE. Enter the same combination of attribute values as the transaction that you are associating this transaction with.

For credit memos applied to tax lines, you must use these columns to link your credit memo tax lines to your credit memo transaction. Similarly, for credit memos applied to freight lines, you must also use these columns to link your credit memo freight line to your credit memo transaction.

If you are applying a credit memo against a tax line which is linked to a transaction, you must enter a dummy credit memo transaction with a zero revenue amount and use these columns to link to your credit memo tax line. Similarly, if you are applying a credit memo against a freight line which is linked to a transaction, you must also enter a dummy credit memo transaction with a zero revenue amount and use these columns to link to your credit memo freight line.

Validation

The transaction that you link to must have a LINE_TYPE = LINE. You can only link at most one freight line to another transaction. You cannot link a transaction that has a LINE_TYPE = LINE or CHARGES to another transaction.

Destination

None.

LINK_TO_LINE_CONTEXT

Enter the context name of the Transaction Flexfield data that you entered in RA_INTERFACE_LINES_ALL.LINK_TO_LINE_ATTRIBUTE1-15.

Validation

None.

Destination

None

--- 刘轶鹤