Projects:APR Migration Tool/Technical Documentation/Order
Contents |
Order Migration
Scenario 1
Affected Orders
The Orders (C_Order) that satisfy ALL the following conditions:
- Not invoiced.
- No payments (C_Debt_Payment)
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.
- Sales Management || Transactions || Sales Order || Header >> Payment Plan
- Procurement Management || Transactions || Purchase Order || Header >> Payment Plan
Scenario 2
Affected Payments
All the Orders (C_Order) that satisfy ALL the following conditions:
- Invoiced.
- No payments (C_Debt_Payment)
Migration Process
They are not migrated.
Scenario 3
Affected Payments
All the Orders (C_Order) that satisfy ALL the following conditions:
- Invoiced.
- With payments (C_Debt_Payment)
Migration Process
They are not migrated.
Scenario 4
Affected Payments
All the Orders (C_Order) that satisfy ALL the following conditions:
- Not Invoiced.
- With payments (C_Debt_Payment)
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.