Product Description
NOTE - This is a VIEW not a report and enables you to build dozens of reports.
What happens now?
Once you've decided on the report or view you'd like to buy, simply add it to your basket and proceed through the checkout. You will visit 2checkout.com who are our payment processor, and on successful payment you will return to our site and the code will be unlocked for you to use. There will be a direct link in the order confirmation screen, or you can view the code at any time in the future through your Account screen.
What am I buying?
There are a total of 259 lines of code in this product. Here is an example:
87. NVL(INV.APPROVED_AMOUNT,0) Invoice_Manual_Approval_Amount,
88. INV.APPROVAL_DESCRIPTION Invoice_Manual_Approval_Descr,
89. INV.APPROVAL_STATUS Invoice_Manual_Approval_Status,
90. (NVL(INV.APPROVED_AMOUNT,0))*NVL(INV.EXCHANGE_RATE,DECODE(
91. INV.INVOICE_CURRENCY_CODE,
92. SOB.CURRENCY_CODE,1,NULL)) Invoice_Manual_Apprvl_Amt_Base,
Report Fields
|
Accrual Posted Flag |
Batch Name |
Buyer Name |
|
Buyer Number |
All segments of the Chart of Accounts |
Invoice Date |
|
Invoice Distr Gl Date |
Invoice Number |
Item Description |
|
PO Document Number |
Posted Flag |
Promised Date |
|
Accrual Posted Flag |
Assets Addition Code |
Assets Tracking Flag |
|
Base Amount |
Base Currency Code |
Base Invoice Price Variance |
|
Base Quantity Variance |
Batch Name |
Buyer Name |
|
Buyer Number |
Cancel flag |
Closed Code |
|
Destination Organization |
Distribution Line Number |
Earliest Settlement Date |
|
Exchange Date |
Exchange Rate |
Exchange Rate Type |
|
Exchange Rate Variance |
Final Match Flag |
Goods Received Date |
|
Hazard Class |
Hold Match Status |
Income Tax Region |
|
Income Tax Type |
Invoice Creation Date |
Invoice Date |
|
Invoice Description |
Invoice Distr Amount |
Invoice Distr Amount Base |
|
Invoice Distr Description |
Invoice Distr Gl Date |
Invoice Distr Line Type Code |
|
Invoice Manual Approval Amount |
Invoice Manual Approval Descr |
Invoice Manual Approval Status |
|
Invoice Manual Apprvl Amt Base |
Invoice Number |
Invoice Posting Period Name |
|
Invoice Price Variance |
Invoice Price Variance Base |
Invoice Source |
|
Invoice Terms |
Invoice Type Lookup Code |
Item |
|
Item Description |
Item Revision |
Need By Date |
|
PO Currency Code |
PO Document Number |
PO Document Type Lookup Code |
|
PO Line Amount |
PO Line Amount Base |
PO Line Number |
|
PO Line Type |
PO Unit Price |
PO Unit Price Base |
|
Pay Alone Flag |
Posted Amount |
Posted Amount Base |
|
Posted Base Amount |
Posted Flag |
Prepay Amount Remaining |
|
Prepay Amount Remaining Base |
Project Name |
Project Number |
|
Promised Date |
Quantity |
Quantity Invoiced |
|
Quantity Received |
Quantity Variance |
Rate |
|
Rate Date |
Rate Type |
Reversal Flag |
|
Ship To Organization |
Shipment Amount |
Shipment Amount Base |
|
Shipment Number |
Shipment Quantity |
Shipment Quantity Billed |
|
Shipment Quantity Cancelled |
Stat Amount |
Task Name |
|
Task Number |
Vat Code |
Vendor Name |
|
Vendor Number |
Vendor Site Code |
