View source | View content page | Page history | Printable version   

Projects:APR Migration Tool/Technical Documentation/Order

Contents

Order Migration

Scenario 1

Affected Orders

The Orders (C_Order) that satisfy ALL the following conditions:

Migration process

For each payment of the Order the process will create a new Payment Plan:

FIN_Payment_Schedule
Column Value
ad_client_id Client of the Payment.
ad_org_id Organization of the Payment.
c_order_id Affected Order.
c_invoice_id null
c_order_id null
duedate Due date of the Payment. Duedate column of C_Debt_Payment table.
fin_paymentmethod_id The payment method that matches with the form of payment defined in the order. It has been created in the Payment Method migration process.
c_currency_id Currency of the Payment. C_Currency_Id column of C_Debt_Payment table.
amount Amount of the Payment. Amount column of C_Debt_Payment table.
paidamt 0.0 Nothing has been paid.
outstandingamt Amount of the Payment. Amount column of C_Debt_Payment table.


FIN_Payment_ScheduleDetail
Column Value
ad_client_id Client of the Payment.
ad_org_id Organization of the Payment.
fin_payment_detail_id null
fin_payment_schedule_order The reference to the Fin_Payment_Schedule
fin_payment_schedule_invoice null
amount The amount of the Payment. Amount column of C_Debt_Payment table.
writeoffamt Writeoff amount of the Payment. Writeoffamt column of C_Debt_Payment table.

The recently created records will be shown in Payment Plan tab of the Orders window.

Scenario 2

Affected Payments

All the Orders (C_Order) that satisfy ALL the following conditions:

Migration Process

They are not migrated.

Scenario 3

Affected Payments

All the Orders (C_Order) that satisfy ALL the following conditions:

Migration Process

They are not migrated.

Scenario 4

Affected Payments

All the Orders (C_Order) that satisfy ALL the following conditions:

Migration Process

They are not migrated.

How to identify a migrated Order

All the migrated Invoices will be flagged to easily identify then. In C_Order table the Em_Aprmt_IsMigrated column set to true. This value is only visible from the database.

Retrieved from "http://wiki.openbravo.com/wiki/Projects:APR_Migration_Tool/Technical_Documentation/Order"

This page has been accessed 2,143 times. This page was last modified on 8 June 2012, at 05:26. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.