AR Israeli Receipt Print

Description
Categories: BI Publisher, Financials
Application: Receivables
Source: Israeli Receipt Print
Short Name: ARCRPRRPT
DB package: AR_CASH_RECEIPT_PRINT_PKG
     SELECT 
	      aicrg.cash_receipt_id    CASH_RECEIPT_ID
         ,aicrg.receipt_number     RECEIPT_NUMBER
		 ,aicrg.receipt_date       RECEIPT_DATE
		 ,aicrg.receipt_status     RECEIPT_STATUS
		 ,aicrg.document_number    DOCUMENT_NUMBER
		 ,aicrg.receipt_amount     RECEIPT_AMOUNT
		 ,aicrg.currency           CURRENCY
		 ,aicrg.credit_card_no     CREDIT_CARD_NO
		 ,aicrg.credit_card_type   CREDIT_CARD_TYPE
		 ,aicrg.maturity_date      MATURITY_DATE
		 ,aicrg.method_name        METHOD_NAME
		 ,aicrg.bank_account       BANK_ACCOUNT
		 ,aicrg.bank_name          BANK_NAME
		 ,aicrg.bank_branch_name   BANK_BRANCH_NAME
		 ,aicrg.customer_name      CUSTOMER_NAME
		 ,aicrg.customer_number    CUSTOMER_NUMBER
		 ,aicrg.tax_registration_number TAX_REGISTRATION_NUMBER
		 ,aicrg.name               NAME
	     ,aicrg.cust_account_id    CUST_ACCOUNT_ID
		 ,aicrg.cust_acct_site_id  CUST_ACCT_SITE_ID
		 ,aicrg.address_line1      ADDRESS_LINE1
		 ,aicrg.address_line2      ADDRESS_LINE2
		 ,aicrg.city               CITY
		 ,aicrg.postal_code        POSTAL_CODE
		 ,aicrg.copy_or_original   COPY_OR_ORIGINAL
		 ,aicrg.user_name          USER_NAME
		 ,aicrg.cust_tax_registration_num CUST_TAX_REGISTRATION_NUMBER
	FROM AR_IL_CASH_RECEIPTS2_GT aicrg
Ask a question
Parameter Name SQL text Validation
Customer
 
LOV Oracle
Document Number To
 
LOV Oracle
Document Number From
 
LOV Oracle
Receipt Number To
 
LOV Oracle
Receipt Number From
 
LOV Oracle
To Date
 
Date
From Date
 
Date
Print Copy or Original
 
LOV Oracle