Table Information for the Update Billing Currency Amounts Screen

The Update Billing Currency Amounts screen converts BILLING_SUM, BILLING_DETL_HIST, and BILL_INVC_HDR_HS to the new transaction currency.

The changes to the columns are based on the functional currency in the related column. For example, the BILLING_SUM table stores the functional currency amount in the BILLED_AMT column. The toolkit uses the amount in this column to restate the MU_BILLED_AMT in the BILLING_SUM table. The columns to be changed are shown by table.

BILLING_SUM

The following columns are updated in this table when this toolkit is executed:

• MU_BILLED_AMT
• MU_RTNGE_AMT
• MU_OVRCST_CL_AMT
• MU_OVRFEE_CL _AMT
• MU_OVRTOT_CL _AMT
• MU_SALES_TAX_AMT

BILLING_DETL_HIST

The following columns are updated in this table when this toolkit is executed:

• MU_BILL_AMT
• MU_PREV_BILLED_AMT
• MU_BILL_RT_AMT_
• MU_OVRCST_CL_AMT
• MU_OVRFEE_CL _AMT
• MU_OVRTOT_CL_AMT
• MU_RTNGE_AMT
• MU_SALES_TAX_AMT
• MU_UNIT_PRICE_AMT

BILL_INVC_HDR_HS

The following columns are updated in this table when this toolkit is executed:

• MU_FND_VAL_AMT
• MU_FND_VAL_FEE_AMT
• MU_FND_VAL_CST_AMT
• MU_CTR_VAL_AMT
• MU_CTR_VAL_FEE_AMT
• MU_CTR_VAL_CST_AMT
• MUITD_BILLED_AMT
• MUITD_OVRFEECL_AMT
• MUITD_OVRCSTCL_AMT
• MUITD_OVRTOTCL _AMT
• MUITD_RTNGE_AMT
• S_CRNCY_CD
• MU_INVC_AMT
• MU_RTNGE_AMT
• MU_SALES_TAX_AMT
• MU_OTH_CHG_AMT1
• MU_OTH_CHG_AMT2
• MU_OTH_CHG_AMT3
• MU_OVRFEE_CL_AMT
• MU_OVRCST_CL_AMT
• MU_OVRTOT_CL _AMT
• MU_DISC_AMT
• MUPROJ_LVL_INV_AMT
• MUITD_SALES_TX_AMT