Oracle Receivables Implementation Guide Release 12.1 Part Number E13510-04 | Contents | Previous | Next |
The Open Balances Revaluation extract shows the revalued balance sheet accounts that are denominated in a foreign currency and also shows revaluation details such as unrealized gain or loss by customer.
Parameter Name | Description | Displayed | Required | Default Value | LOV |
---|---|---|---|---|---|
Exchange rate type | Examples of exchange rate types are: User rate type or corporate rate type (these are user definable values) | Yes | Yes | None | Yes (User Definable Values) |
Currency | Currency | Yes | Yes | None | Yes (LOV containing all currencies from FND_CURRENCIES) |
Exchange rate | Needed if User rate type has been used | Yes | Yes (depending on exchange rate type) | None | No user entry |
Include Domestic Invoices | Whether domestic invoices to be included in the report | Yes | Yes | None | Yes (Yes/No) |
The Open Balance Revaluation report extract generates the following groups.
G_TRANSACTION
G_DUE_ER
< G_TRANSACTION >
The following table describes data obtained by < Q_INV_SELECT >
XML Tag | Description |
---|---|
< OU_NAME >Vision Operations< /OU_NAME > | Operating Unit |
< ACCOUNT >01-000-1210-0000-000< /ACCOUNT > | Accounting Flexfield |
< TRANSACTION_CURRENCY >EUR< /TRANSACTION_CURRENCY > | Currency of invoice to be revaluated |
< SUPPLIER_NAME >Imaging Innovations, Inc.< /SUPPLIER_NAME > | Customer name |
< CUST_TRANS_ID>442257< /CUST_TRANS_ID > | Customer transaction ID |
< TEST >10500< /TEST > | Total Transaction/Receipt Amount |
< INVOICE_NUMBER >510547< /INVOICE_NUMBER > | Invoice Number |
< INTERNAL_INV_NUMBER/ > | Document sequence Value / Voucher number |
< TRANSACTION_TYPE >INV< /TRANSACTION_TYPE > | Transaction Type |
< INVOICE_DATE >2006-01-05T00:00:00.000-08:00< /INVOICE_DATE > | Invoice Date |
< INVOICE_AMT_ENTERED >10500< /INVOICE_AMT_ENTERED > | Entered Amount |
< INVOICE_AMT_ACCOUNTED >13458.09< /INVOICE_AMT_ACCOUNTED > | Accounted Amount |
< EXCHANGE_RATE >1.2< /EXCHANGE_RATE > | Exchange Rate |
< INV_AMT_DUE >10500< /INV_AMT_DUE > | Unsettled invoice amount in foreign currency |
< INV_AMT_DUE_ER >13458.09< /INV_AMT_DUE_ER > | Unsettled invoice amount revaluated to SKK using historical invoice exchange rate |
< INV_AMT_DUE_REVAL >12600< /INV_AMT_DUE_REVAL > | Unsettled invoice amount revaluated to SKK using revaluation exchange rate |
< G_DUE_ER >
XML Tag | Description |
---|---|
< INV_AMT_DUE1 >10500 < /INV_AMT_DUE1 > | Unsettled invoice amount in foreign currency |
< INV_AMT_DUE_ER1 >13458.09 < /INV_AMT_DUE_ER1 > | Unsettled invoice amount revaluated to SKK using historical invoice exchange rate |
< INV_AMT_DUE_REVAL1 > 12600< /INV_AMT_DUE_REVAL1 > | Unsettled invoice amount revaluated to SKK using revaluation exchange rate |
The Deposit Balance Detail Extract confirms deposit activities and balances for a given period range. It prints:
Opening deposit balance if there is unapplied balance carried over from the period before the specified Period Start parameter.
Deposit activities (newly created and applied to invoices) during the specified Period range.
Deposit balance by each deposit, deposit account and customer.
Parameter Name | Description | Displayed | Required | Default Value | LOV |
---|---|---|---|---|---|
P_ORG_ID | Operating Unit | Y | N | N | Y |
P_PERIOD_FROM | GL Period Date From | Y | Y | Y | Y |
P_PERIOD_TO | GL Period Date To | Y | Y | Y | Y |
P_CUSTOMER_NAME | Customer to be Reported | Y | N | N | Y |
P_CURRENCY | Currency Code | Y | N | N | Y |
The Deposit Balance Report extract generates the following groups.
G_DATE
G_DATA
G_SUB_DATA
G_DATE
XML Tag | Description |
---|---|
<OPERATING_UNIT_NAME>Vision Corporation Japan</OPERATING_UNIT_NAME> | Name of the Operating Unit |
G_DATA
XML Tag | Description |
---|---|
<CUSTOMER_CODE>1005</CUSTOMER_CODE> | Code of the Customer Deposit |
<INVOICE_TYPE>Deposit</INVOICE_TYPE> | Invoice Type name |
<INVOICE_NUMBER>27</INVOICE_NUMBER> | Transaction Number of the Deposit |
<TRANSACTION_DATE>2007-10-11T00:00:00.000-07:00</TRANSACTION_DATE> | Transaction Date. |
<MAIN_CUSTOMER_TRX_ID>524832</MAIN_CUSTOMER_TRX_ID> | Customer Transaction ID. |
<CUSTOMER_NAME>AT&T Universal Card</CUSTOMER_NAME> | Customer Name |
<GL_DATE>2004-01-01T00:00:00.000-08:00</GL_DATE> | GL Date |
<CURRENCY>JPY</CURRENCY> | Currency |
<AMOUNT>15000</AMOUNT> | Deposit Balance Amount |
<ISSUING_DEPT_NAME /> | Issuing Department Name |
<SOURCE_INVOICE_NUMBER /> | Source Invoice Number |
<COMPANY>103</COMPANY> | Balancing Segment of the Accounting Flexfield |
<DEPARTMENT>0000</DEPARTMENT> | Cost Centre Segment of the Accounting Flexfield |
<ACCOUNT>113100</ACCOUNT> | Account Segment of the Accounting Flexfield |
<SEGMENT1>103</SEGMENT1> | Segment 1 |
<SEGMENT2>0000</SEGMENT2> | Segment 2 |
<SEGMENT3>113100</SEGMENT3> | Segment 3 |
<SEGMENT4>0000</SEGMENT4> | Segment 4 |
<SEGMENT5>0000</SEGMENT5> | Segment 5 |
<SEGMENT6>0000</SEGMENT6> | Segment 6 |
<SEGMENT7>0000</SEGMENT7> | Segment 7 |
<SEGMENT8>0000</SEGMENT8> | Segment 8 |
<SEGMENT9/> | Segment 9 |
<SEGMENT10/> | Segment 10 |
<SEGMENT11/> | Segment 11 |
<SEGMENT12/> | Segment 12 |
<SEGMENT13/> | Segment 13 |
<SEGMENT14/> | Segment 14 |
<SEGMENT15/> | Segment 15 |
<SEGMENT16/> | Segment 16 |
<SEGMENT17/> | Segment 17 |
<SEGMENT18/> | Segment 18 |
<SEGMENT19/> | Segment 19 |
<SEGMENT20/> | Segment 20 |
<SEGMENT21/> | Segment 21 |
<SEGMENT22/> | Segment 22 |
<SEGMENT23/> | Segment 23 |
<SEGMENT24/> | Segment 24 |
<SEGMENT25/> | Segment 25 |
<SEGMENT26/> | Segment 26 |
<SEGMENT27/> | Segment 27 |
<SEGMENT28/> | Segment 28 |
<SEGMENT29/> | Segment 29 |
<SEGMENT30/> | Segment 30 |
<ATTRIBUTE1/> | Attribute 1 |
<ATTRIBUTE2/> | Attribute 2 |
<ATTRIBUTE3/> | Attribute 3 |
<ATTRIBUTE4/> | Attribute 4 |
<ATTRIBUTE5/> | Attribute 5 |
<ATTRIBUTE6/> | Attribute 6 |
<ATTRIBUTE7/> | Attribute 7 |
<ATTRIBUTE8/> | Attribute 8 |
<ATTRIBUTE9/> | Attribute 9 |
<ATTRIBUTE10/> | Attribute 10 |
<ATTRIBUTE11/> | Attribute 11 |
<ATTRIBUTE12/> | Attribute 12 |
<ATTRIBUTE13/> | Attribute 13 |
<ATTRIBUTE14/> | Attribute 14 |
<ATTRIBUTE15/> | Attribute 15 |
<COMPANY_DESC>Vision Corporation Japan</COMPANY_DESC> | Description of the Balancing Segment |
<ACCOUNT_DESC>Account Receivable</ACCOUNT_DESC> | Description of the Account Segment |
G_SUB_DATA
XML Tag | Description |
---|---|
<SUB_CUSTOMER_CODE>1005</SUB_CUSTOMER_CODE> | Code of the Customer Deposit |
<SUB_INVOICE_TYPE>Deposit</SUB_INVOICE_TYPE> | Invoice Type name |
<SUB_INVOICE_NUMBER>26</SUB_INVOICE_NUMBER> | Transaction Number of the Deposit |
<SUB_TRANSACTION_DATE>2007-10-11T00:00:00.000-07:00</SUB_TRANSACTION_DATE> | Transaction Date. |
<SUB_MAIN_CUSTOMER_TRX_ID>524832</SUB_MAIN_CUSTOMER_TRX_ID> | Customer Transaction ID. |
<SUB_CUSTOMER_NAME>AT&T Universal Card</SUB_CUSTOMER_NAME> | Customer Name |
<SUB_GL_DATE>2004-01-01T00:00:00.000-08:00</SUB_GL_DATE> | GL Date |
<SUB_CURRENCY>JPY</SUB_CURRENCY> | Currency |
<SUB_AMOUNT>-1100</SUB_AMOUNT> | Deposit Balance Amount |
<SUB_ISSUING_DEPT_NAME /> | Issuing Department Name |
<SUBSOURCE_INVOICE_NUMBER /> | Source Invoice Number |
<SUB_COMPANY>103</SUB_COMPANY> | Balancing Segment of the Accounting Flexfield |
<SUB_DEPARTMENT>0000</SUB_DEPARTMENT> | Cost Centre Segment of the Accounting Flexfield |
<SUB_ACCOUNT>113100</SUB_ACCOUNT> | Account Segment of the Accounting Flexfield |
<SUB_SEGMENT1>103</SUB_SEGMENT1> | Segment 1 |
<SUB_SEGMENT2>0000</SUB_SEGMENT2> | Segment 2 |
<SUB_SEGMENT3>113100</SUB_SEGMENT3> | Segment 3 |
<SUB_SEGMENT4>0000</SUB_SEGMENT4> | Segment 4 |
<SUB_SEGMENT5>00000</SUB_SEGMENT5> | Segment 5 |
<SUB_SEGMENT6>00000</SUB_SEGMENT6> | Segment 6 |
<SUB_SEGMENT7>00000</SUB_SEGMENT7> | Segment 7 |
<SUB_SEGMENT8>00000</SUB_SEGMENT8> | Segment 8 |
<SUB_SEGMENT9/> | Segment 9 |
<SUB_SEGMENT10/> | Segment 10 |
<SUB_SEGMENT11/> | Segment 11 |
<SUB_SEGMENT12/> | Segment 12 |
<SUB_SEGMENT13/> | Segment 13 |
<SUB_SEGMENT14/> | Segment 14 |
<SUB_SEGMENT15/> | Segment 15 |
<SUB_SEGMENT16/> | Segment 16 |
<SUB_SEGMENT17/> | Segment 17 |
<SUB_SEGMENT18/> | Segment 18 |
<SUB_SEGMENT19/> | Segment 19 |
<SUB_SEGMENT20/> | Segment 20 |
<SUB_SEGMENT21/> | Segment 21 |
<SUB_SEGMENT22/> | Segment 22 |
<SUB_SEGMENT23/> | Segment 23 |
<SUB_SEGMENT24/> | Segment 24 |
<SUB_SEGMENT25/> | Segment 25 |
<SUB_SEGMENT26/> | Segment 26 |
<SUB_SEGMENT27/> | Segment 27 |
<SUB_SEGMENT28/> | Segment 28 |
<SUB_SEGMENT29/> | Segment 29 |
<SUB_SEGMENT30/> | Segment 30 |
<SUB_ATTRIBUTE1/> | Attribute 1 |
<SUB_ATTRIBUTE2/> | Attribute 2 |
<SUB_ATTRIBUTE3/> | Attribute 3 |
<SUB_ATTRIBUTE4/> | Attribute 4 |
<SUB_ATTRIBUTE5/> | Attribute 5 |
<SUB_ATTRIBUTE6/> | Attribute 6 |
<SUB_ATTRIBUTE7/> | Attribute 7 |
<SUB_ATTRIBUTE8/> | Attribute 8 |
<SUB_ATTRIBUTE9/> | Attribute 9 |
<SUB_ATTRIBUTE10/> | Attribute 10 |
<SUB_ATTRIBUTE11/> | Attribute 11 |
<SUB_ATTRIBUTE12/> | Attribute 12 |
<SUB_ATTRIBUTE13/> | Attribute 13 |
<SUB_ATTRIBUTE14/> | Attribute 14 |
<SUB_ATTRIBUTE15/> | Attribute 15 |
<SUB_COMPANY_DESC>Vision Corporation Japan</SUB_COMPANY_DESC> | Description of the Balancing Segment |
<SUB_ACCOUNT_DESC>Account Receivable</SUB_ACCOUNT_DESC> | Description of the Account Segment |
<SUB_SEGMENT4_DESC>Unspecified</SUB_SEGMENT4_DESC> | Description of the fourth Segment |
This report lists Receivables receipt information. The report includes from/to date ranges, receipt number from/to, document number from/to, and customer name.
Parameter Name | Description | Displayed | Required | Default Value | LOV |
---|---|---|---|---|---|
Print copy or original | In regards with the user selection original or copy receipt will be produces (original may be produces only once) | Yes | Yes | None | Yes |
Date from | Earliest receipt date for which you would like to print the receipt | Yes | No | None | No |
Date to | Latest receipt date for which you would like to print the receipt | Yes | No | None | No |
Receipt number from | The lowest receipt number for which you would like to print a receipt. If you want to print more than one receipt, select here the lowest receipt number you would like to print receipts for. | Yes | No | None | Yes |
Receipt number to | The highest receipt number for which you would like to print a receipt. If you want to print more than one receipt, select here the highest receipt number you would like to print receipts for. | Yes | No | None | Yes |
Document number from | The lowest receipt document number for which you would like to print a receipt. If you want to print more than one receipt, select here the lowest receipt document number you would like to print receipts for. | Yes | No | None | Yes |
Document number to | The highest receipt document number for which you would like to print a receipt. If you want to print more than one receipt, select here the highest receipt document number you would like to print receipts for. | Yes | No | None | Yes |
Customer name | The customer name for which you would like to print the receipt(s) for. | Yes | Yes |
The Receipt Print Report extract generates the following groups.
Receipts
Phones
Invoices
Receipts
XML Tag | Description |
---|---|
<CASH_RECEIPT_ID>77820</CASH_RECEIPT_ID> | Receipt ID |
<RECEIPT_NUMBER>IEX_10382</RECEIPT_NUMBER> | Receipt Number |
<RECEIPT_DATE>2006-05-22T00:00:00.000-07:00</RECEIPT_DATE> | Receipt Date |
<RECEIPT_STATUS>APP</RECEIPT_STATUS> | Status of the receipt |
<DOCUMENT_NUMBER>10059</DOCUMENT_NUMBER> | Doc sequence value of the receipt |
<RECEIPT_AMOUNT>15000</RECEIPT_AMOUNT> | receipt amount |
<CURRENCY>USD</CURRENCY> | receipt entered currency |
<CREDIT_CARD_TYPE/> | Type of Credit Card used for this receipt and this is made use of the DFF (attribute14) of the AR_CASH_RECEIPTS |
<MATURITY_DATE>2006-05-22T00:00:00.000-07:00</MATURITY_DATE> | maturity date of the receipt |
<BANK_ACCOUNT/> | bank account number of the customer |
<BANK_NAME /> | bank name of the customer |
<BANK_BRANCH_NAME /> | bank branch name of the customer |
<CUSTOMER_NAME>Computer Service and Rentals</CUSTOMER_NAME> | customer name |
<CUSTOMER_NUMBER>1006</CUSTOMER_NUMBER> | customer number |
<TAX_REGISTRATION_NUMBER>SYS12125</TAX_REGISTRATION_NUMBER> | Tax Registration Number of the Customer |
<ADDRESS_LINE1>301 Summit Hill Drive</ADDRESS_LINE1> | customer address line 1 |
<ADDRESS_LINE2/> | customer address line 2 |
<CITY>CHATTANOOGA</CITY> | customer city |
<POSTAL_CODE>37401</POSTAL_CODE> | customer postal code |
<ORIG_COPY>Copy</ORIG_COPY> | Used to identify whether the receipt that is printed is the Original Print or a Duplicate (Copy) |
<USER_NAME>OPERATIONS</USER_NAME> | User who runs the programs for printing of receipts |
Phones
XML Tag | Description |
---|---|
<PHONE_NUMBER>1-800-5558355</PHONE_NUMBER> | Customer Site phone number for the receipt that is assigned to |
Invoices
XML Tag | Description |
---|---|
<TRX_NUMBER>510840</TRX_NUMBER> | Transaction Numbers that got applied to the Receipt |
Copyright © 1988, 2010, Oracle and/or its affiliates. All rights reserved.