Meaning of status_code and phase_code in FND_CONCURRENT_REQUESTS table

STATUS_CODE Column:

A - Waiting
B - Resuming
C - Normal
D - Cancelled
E - Error
F - Scheduled
G - Warning
H - On Hold
I - Normal
M - No Manager
Q - Standby
R - Normal
S - Suspended
T - Terminating
U - Disabled
W - Paused
X - Terminated
Z - Waiting


PHASE_CODE column

C - Completed
I  - Inactive
P - Pending
R - Running

Bank Payment Acknowledgement API Processing in Oracle Payments/Payables through XML parsing

Payment Acknowledgement functionality is about to load and display in EBS the bank processing status for each of your supplier/employee payments after successful transmission of the payment file to your bank.

Starting with release 12.2 a standard API is available to load acknowledgement file but the load of files to EBS database and call of API is subject of additional development.

From a setup point of view only Bank Acknowledgement Code Setup is required as your bank status codes should be mapped to ISO statuses provided by Oracle Payments:

·                     Accepted technical, syntactical and profile; passed to back office          (BACKOFF)

·                     Accepted back office; passed to clearing          (CLEAR)

·                     Accepted with change   (ACCC)

·                     Pending further processing        (PEND)

·                   Rejection          (REJECT)

From EBS process point of view this functionality will just show to you the bank status of your payment but will NOT:

·                    Void/change EBS payment status in Oracle Payments/Payables 

·                    Impact bank reconciliation process in Cash Management


Sample Code:

procedure payments_ack   (p_xml                in  xmltype,
                          x_return_status      out varchar2,
                          x_msg_data           out varchar2)
is
p_return_status varchar2(1);
p_ret_msg varchar2(2000);
p_msg_cnt number;
v_count number;
l_pay_ref_num iby_payments_all.payment_reference_number%type;

l_payment_id iby_payments_all.payment_id%type;
l_payment_reference_number iby_payments_all.payment_reference_number%type;
l_payment_instruction_id iby_payments_all.payment_instruction_id%type;
l_paper_document_number iby_payments_all.paper_document_number%type;
l_bank_assigned_ref_code iby_payments_all.bank_assigned_ref_code%type;
l_bank_assigned_ref_code2 iby_payments_all.bank_assigned_ref_code%type;
l_payer_legal_entity_name iby_payments_all.payer_legal_entity_name%type;
l_int_bank_name iby_payments_all.int_bank_name%type;
l_int_bank_branch_name iby_payments_all.int_bank_branch_name%type;
l_int_eft_swift_code iby_payments_all.int_eft_swift_code%type;
l_int_bank_account_number iby_payments_all.int_bank_account_number%type;
l_int_bank_account_iban iby_payments_all.int_bank_account_iban%type;
l_beneficiary_name iby_payments_all.beneficiary_name%type;
l_ext_bank_name iby_payments_all.ext_bank_name%type;
l_ext_bank_branch_name iby_payments_all.ext_bank_branch_name%type;
l_ext_eft_swift_code iby_payments_all.ext_eft_swift_code%type;
l_ext_bank_account_num_elec iby_payments_all.ext_bank_account_num_elec%type;
l_ext_bank_account_iban_number iby_payments_all.ext_bank_account_iban_number%type;
l_payment_amount iby_payments_all.payment_amount%type;
l_bank_charges number;
l_payment_currency_code iby_payments_all.payment_currency_code%type;
l_org_id number(15);

rej_dtls_TAB  IBY_IMPORT_PMT_ACK_DATA_PUB.Reject_dtls_tbl_type ;
rej_dtl_rec IBY_IMPORT_PMT_ACK_DATA_PUB.REJECT_DTLS_REC;

begin

--fnd_global.APPS_INITIALIZE(944523,63117,200);

FOR r IN (
    SELECT 
     ExtractValue(Value(p),'/row/BANK_STATUS_CODE/text()') as BANK_STATUS_CODE
    ,ExtractValue(Value(p),'/row/CHECK_NUMBER/text()') as CHECK_NUMBER
    ,ExtractValue(Value(p),'/row/BANK_ERROR_CODE/text()') as BANK_ERROR_CODE
    ,ExtractValue(Value(p),'/row/BANK_ERROR_MESSAGE/text()') as BANK_ERROR_MESSAGE
    ,ExtractValue(Value(p),'/row/BANK_ERROR_LOCATION/text()') as BANK_ERROR_LOCATION
    FROM   TABLE(XMLSEQUENCE(EXTRACT(p_xml,'/PaymentsAck/row'))) p ) 

    loop
    
      begin
      
        if r.BANK_STATUS_CODE is null then
        x_return_status:='REJECTED';
        x_msg_data:='BANK_STATUS_CODE cannot be null!';
        dbms_output.put_line (x_return_status||'---'||x_msg_data);
        return;
        end if;
      
        begin
        select payment_reference_number
        into   l_pay_ref_num
        from iby_payments_all a , ap_checks_all c
        where a.payment_id = c.payment_id
        and check_number = r.check_number;
        exception when others then
        x_return_status:='REJECTED';
        x_msg_data:='Invalid Check Number, Record Not Found!';
        dbms_output.put_line (x_return_status||'---'||x_msg_data);         
        return;
        end;
        
        select count(*)
        into v_count
        from apps.iby_payments_all
        where payment_reference_number = l_pay_ref_num;
        
        if v_count = 1 then
        
            select ipa.payment_id,
                   ipa.payment_reference_number,
                   ipa.payment_instruction_id,
                   paper_document_number,
                   ipa.bank_assigned_ref_code p_bank_assigned_ref_code1,
                   null p_bank_assigned_ref_code2,
                   ipa.payer_legal_entity_name,
                   ipa.int_bank_name,
                   ipa.int_bank_branch_name,
                   ipa.int_eft_swift_code,
                   ipa.int_bank_account_number,
                   ipa.int_bank_account_iban,
                   ipa.beneficiary_name,
                   ipa.ext_bank_name,
                   ipa.ext_bank_branch_name,
                   ipa.ext_eft_swift_code,
                   ipa.ext_bank_account_num_elec,
                   ipa.ext_bank_account_iban_number,
                   ipa.payment_amount,
                   null bank_charges,
                   ipa.payment_currency_code,
                   ipa.org_id
                   into
                   l_payment_id,
                   l_payment_reference_number,
                   l_payment_instruction_id,
                   l_paper_document_number,
                   l_bank_assigned_ref_code,
                   l_bank_assigned_ref_code2,
                   l_payer_legal_entity_name,
                   l_int_bank_name,
                   l_int_bank_branch_name,
                   l_int_eft_swift_code,
                   l_int_bank_account_number,
                   l_int_bank_account_iban,
                   l_beneficiary_name,
                   l_ext_bank_name,
                   l_ext_bank_branch_name,
                   l_ext_eft_swift_code,
                   l_ext_bank_account_num_elec,
                   l_ext_bank_account_iban_number,
                   l_payment_amount,
                   l_bank_charges,
                   l_payment_currency_code,
                   l_org_id
              from apps.iby_payments_all ipa       
             where payment_reference_number = l_pay_ref_num;

            rej_dtl_rec.BANK_ERROR_CODE := r.BANK_ERROR_CODE;
            rej_dtl_rec.BANK_ERROR_MESSAGE := r.BANK_ERROR_MESSAGE;
            rej_dtl_rec.BANK_ERROR_LOCATION := r.BANK_ERROR_LOCATION;
        
            rej_dtls_TAB(1) := rej_dtl_rec;

            iby_import_pmt_ack_data_pub.Create_Acknowlegment
            (
            P_PAYMENT_REF_NUMBER            => l_payment_reference_number,
            P_PMT_INSTRUCTION_REF_NUMBER    => l_payment_instruction_id,
            P_BANK_STATUS_CODE              => r.BANK_STATUS_CODE,
            P_ACKNOWLEDGEMENT_DATE          => sysdate,
            P_BANK_ASSIGNED_REF_CODE1       => l_bank_assigned_ref_code,
            P_BANK_ASSIGNED_REF_CODE2       => l_bank_assigned_ref_code2,
            P_PAYER_NAME                    => l_payer_legal_entity_name,
            P_PAYER_BANK_NAME               => l_int_bank_name,
            P_PAYER_BANK_BRANCH_NAME        => l_int_bank_branch_name,
            P_PAYER_BANK_SWIFT_CODE         => l_int_eft_swift_code,
            P_PAYER_BANK_ACCOUNT_NUMBER     => l_int_bank_account_number,
            P_PAYER_BANK_IBAN_NUMBER        => l_int_bank_account_iban,
            P_PAYEE_NAME                    => l_beneficiary_name,
            P_PAYEE_BANK_NAME               => l_ext_bank_name,
            P_PAYEE_BANK_BRANCH_NAME        => l_ext_bank_branch_name,
            P_PAYEE_BANK_SWIFT_CODE         => l_ext_eft_swift_code,
            P_PAYEE_BANK_ACCOUNT_NUMBER     => l_ext_bank_account_num_elec,
            P_PAYEE_BANK_IBAN_NUMBER        => l_ext_bank_account_iban_number,
            P_PAYMENT_AMOUNT                => l_payment_amount,
            P_BANK_CHARGE_AMOUNT            =>  null,
            P_PAYMENT_CURRENCY_CODE         => l_payment_currency_code,
            P_EXCHANGE_RATE                 =>  1,
            P_VALUE_DATE                    => sysdate,
            P_REQUESTED_EXECUTION_DATE      => sysdate,
            P_P_REJECT_DTLS_TBL_TYPE        => rej_dtls_TAB,
            x_return_status                 => p_return_status,
            x_return_message                => p_ret_msg,
            x_msg_count                     => p_msg_cnt
            );
--            DBMS_OUTPUT.PUT_LINE('p_return_status: '||p_return_status);
--            DBMS_OUTPUT.PUT_LINE('p_ret_msg: '||p_ret_msg);
--            DBMS_OUTPUT.PUT_LINE('p_msg_cnt: '||p_msg_cnt);
            
            if p_return_status = 'S' and p_ret_msg = 'SUCCESS' then                
                x_return_status:='SUCCESS';
                x_msg_data:='Acknowledgement Posted Successfully';
                dbms_output.put_line (x_return_status||':---:'||x_msg_data);
                else
                x_return_status:='REJECTED';
                x_msg_data:='Error in posting Acknowledgement: '||sqlerrm;
                dbms_output.put_line (x_return_status||':---:'||x_msg_data);
                return;
            end if;
        
        else
        
        x_return_status:='REJECTED';
        x_msg_data:='Invalid Check Number!';
        dbms_output.put_line (x_return_status||':---:'||x_msg_data);
                
        return;
        
        end if;
        
        EXCEPTION
        WHEN OTHERS THEN
        DBMS_OUTPUT.PUT_LINE('In API Exception: '||SQLERRM);
        rollback;

        x_return_status:='REJECTED';
        x_msg_data:='In API Exception: '||SQLERRM;
        return;
      end;

    end loop;

EXCEPTION
WHEN OTHERS THEN
    DBMS_OUTPUT.PUT_LINE('SQLERRM: '||SQLERRM);
  rollback;
  
        x_return_status:='REJECTED';
        x_msg_data:='In Main Exception: '||SQLERRM;
        
  return;

end payments_ack;

AR Tables in Oracle Apps r12

AR Tables in Oracle Apps r12

AR is the Receivable module in the Oracle apps r12. We creates the Customer Invoices in Oracle Receivables and we receive Customer Receipts against the Customer Invoices also in the Oracle receivables Modules. In each Activity, we save these transactional data in the AR Tables in Oracle apps r12. I will describe all the AR Tables of Oracle apps r12 step by step.

Customer Transaction/Invoice Table 

ra_customer_trx_all

ra_customer_trx_lines_all

ra_cust_trx_line_gl_dist_all

ra_terms

Customer Receipts Tables

ar_cash_receipts_all

ar_receivable_applications_all 

RA_CUSTOMER_TRX_ALL 

This is the AR Invoice/Transactions Header Table. In this Table, We will get the Customer Information’s, site Information’s, Payment Terms, Transaction Source and Transaction Type kind of Information’s.

Each row in this table includes general invoice information such as customer, transaction type, and printing instructions.

RA_CUSTOMER_TRX_LINES_ALL

This is the AR Invoice/Transactions Lines tables. In this Table, We will get the AR Invoice Lines Information’s along with the Tax Lines Information’s.

Here in this Table, We will get the separate Lines for the Each Tax line. If any invoice has 1 Line and two taxes applied to this Line. Then we will get three lines for this Invoice. One for Line and Two for Taxes.

RA_CUST_TRX_LINE_GL_DIST_ALL

This table stores the AR Invoice accounting information’s for each line of the AR Invoice.

Here will get all the Accounting Information’s. Each row in this table includes the General Ledger account and the amount of the accounting entry.

RA_CUST_TRX_LINE_SALESREPS_ALL

This Table Stores the Sales Person name used in the RA_CUSTOMER_TRX_ALL table.

This Table stores sales credit assignments for invoice lines. If Receivables bases your invoice distributions on sales credits, a mapping exists between the sales credit assignments in this table with the RA_CUST_TRX_LINE_GL_DIST_ALL table. 

AR Receipts Table

AR_CASH_RECEIPTS_ALL

This Table Stores Cash Receipt Header data. The AR_CASH_RECEIPTS_ALL table stores one record for each receipt that you enter.

Receivables concurrently create records in the AR_CASH_RECEIPT_HISTORY_ALL, AR_PAYMENT_SCHEDULES_ALL, and AR_RECEIVABLE_APPLICATIONS_ALL tables for invoice-related receipts. For receipts that are not related to invoices, such as miscellaneous receipts, Receivables creates records in the AR_MISC_CASH_DISTRIBUTIONS_ALL table instead of the AR_RECEIVABLE_APPLICATIONS_ALL table.

AR_RECEIVABLE_APPLICATIONS_ALL

This Table Stores which AR Receipt applied to which AR Invoice in the Oracle application

  

AR_PAYMENT_SCHEDULES_ALL

This Table stores all transactions except adjustments and miscellaneous cash receipts. This table is updated when an activity occurs against an invoice, debit memo, chargeback, credit memo, on-account credit, bills receivable

AR_CASH_RECEIPT_HISTORY_ALL 

This table stores all of the activity that is contained for the life cycle of a receipt.

Understanding the AR_PAYMENTS_INTERFACE Table

Column Name		Null?	Type
TRANSMISSION_RECORD_ID			NUMBER(15)
SOURCE:	AR_PAYMENTS_INTERFACE_S.NEXTVAL
DESTINATION:	None
CREATION_DATE			DATE
SOURCE:	CURRENT SYSTEM DATE
DESTINATION:	None
CREATED_BY			NUMBER(15)
SOURCE:	FND_USER.USER_ID
DESTINATION:	AR_BATCHES.CREATED_BY
	AR_INTERIM_CASH_RECEIPTS.CREATED_BY
	AR_INTERIM_CASH_RECEIPT_LINES.CREATED_BY
LAST_UPDATE_LOGIN			NUMBER(15)
SOURCE:	UNKNOWN
DESTINATION:	None
LAST_UPDATED_BY			NUMBER(15)
SOURCE:	FND_USER.USER_ID
DESTINATION:	None
LAST_UPDATE_DATE			DATE
SOURCE:	CURRENT SYSTEM DATE
DESTINATION:	None
RECORD_TYPE		NOT NULL	VARCHAR2(2)
SOURCE:	AR_TRANS_RECORD_FORMATS.RECORD_IDENTIFIER
DESTINATION:	None
STATUS			VARCHAR2(30)
SOURCE:	FND_MESSAGES.MESSAGE_NAME
DESTINATION:	None
TRANSMISSION_REQUEST_ID			NUMBER(15)
SOURCE:	FND_CONCURRENT_REQUESTS.REQUEST_ID
DESTINATION:	None
TRANSMISSION_ID			NUMBER(15)
SOURCE:	AR_TRANSMISSIONS.TRANSMISSION_ID
DESTINATION:	None
DESTINATION_ACCOUNT			VARCHAR2(25)
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	AR_TRANSMISSIONS.DESTINATION
ORIGINATION			VARCHAR2(25)
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	AR_TRANSMISSIONS.ORIGIN
DEPOSIT_DATE			DATE
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	AR_BATCHES.DEPOSIT_DATE
GL_DATE			DATE
SOURCE:	DERIVED FROM DEPOSIT DATE, IMPORT DATE OR
	ENTERED DATE
DESTINATION:	AR_BATCHES.GL_DATE
	AR_INTERIM_CASH_RECEIPTS.GL_DATE
	AR_CASH_RECEIPT_HISTORY.GL_DATE
DEPOSIT_TIME			VARCHAR2(8)
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	None
TRANSMISSION_RECORD_ COUNT			NUMBER(15)
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	AR_TRANSMISSIONS.COUNT
TRANSMISSION_AMOUNT			NUMBER
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	AR_TRANSMISSIONS.AMOUNT
TRANSFERRED_RECEIPT_COUNT			NUMBER
SOURCE:	PROGRAM COUNTS NUMBER OF RECORDS TRANSFERRED
	SUCCESSFULLY
DESTINATION:	AR_TRANSMISSIONS.VALIDATED_COUNT
TRANSFERRED_RECEIPT_ AMOUNT			NUMBER
SOURCE:	PROGRAM COUNTS RECEIPT AMOUNTS OF RECORDS
	TRANSFERRED SUCCESSFULLY
DESTINATION:	AR_TRANSMISSIONS.VALIDATED_AMOUNT
LOCKBOX_NUMBER			VARCHAR2(30)
SOURCE:	PROVIDED BY BANK OR ENTERED BY USER AT RUNTIME
DESTINATION:	None
LOCKBOX_BATCH_COUNT			NUMBER
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	None
LOCKBOX_RECORD_COUNT			NUMBER
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	None
LOCKBOX_AMOUNT			NUMBER
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	None
BATCH_NAME			VARCHAR2(25)
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	AR_BATCHES.LOCKBOX_BATCH_NAME
BATCH_AMOUNT			NUMBER
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	AR_BATCHES.CONTROL_AMOUNT
BATCH_RECORD_COUNT			NUMBER(15)
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	AR_BATCHES.CONTROL_COUNT
ITEM_NUMBER			NUMBER
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	None
CURRENCY_CODE			VARCHAR2(15)
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	AR_BATCHES.CURRENCY_CODE
	AR_INTERIM_CASH_RECEIPTS.CURRENCY_CODE
EXCHANGE_RATE			NUMBER
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	AR_BATCHES.EXCHANGE_RATE
	AR_INTERIM_CASH_RECEIPTS.EXCHANGE_RATE
EXCHANGE_RATE_TYPE			VARCHAR2(30)
SOURCE:	DEFAULTS FROM LOCKBOX DEFINITIONS OR ENTERED BY
	USER VIA 'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION	AR_BATCHES.EXCHANGE_RATE_TYPE
	AR_INTERIM_CASH_RECEIPTS.EXCHANGE
	AR_RATE_TYPE
REMITTANCE_AMOUNT			NUMBER
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	AR_INTERIM_CASH_RECEIPTS.AMOUNT
TRANSIT_ROUTING_NUMBER			VARCHAR2(25)
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	AP_BANK_BRANCHES.BANK_NAME
	AP_BANK_BRANCHES.BANK_BRANCH_NAME
	AP_BANK_BRANCHES.BANK_NUM
ACCOUNT			VARCHAR2(30)
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	AP_BANK_ACCOUNTS.BANK_ACCOUNT_NUM
CUSTOMER_BANK_ACCOUNT_ID			NUMBER(15)
SOURCE:	AP_BANK_ACCOUNT_USES.EXTERNAL_BANK_
	ACCOUNT_ID
DESTINATION:	AR_INTERIM_CASH_RECEIPTS.CUSTOMER_BANK_
	ACCOUNT_ID
	AR_CASH_RECEIPTS.CUSTOMER_BANK_ACCOUNT_ID
CHECK_NUMBER			VARCHAR2(30)
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	AR_INTERIM_CASH_RECEIPTS.RECEIPT_NUMBER
	AR_CASH_RECEIPTS.RECEIPT_NUMBER
SPECIAL_TYPE			VARCHAR2(20)
SOURCE:	PROGRAM DETERMINES THE TYPE
DESTINATION:	AR_INTERIM_CASH_RECEIPTS.SPECIAL_TYPE
CUSTOMER_NUMBER			VARCHAR2(30)
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	NONE
CUSTOMER_ID			NUMBER(15)
SOURCE:	PROGRAM DETERMINES IT
DESTINATION:	AR_INTERIM_CASH_RECEIPTS.PAY_FROM_CUSTOMER
	AR_CASH_RECEIPTS.PAY_FROM_CUSTOMER
BILL_TO_LOCATION			VARCHAR2(40)
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	NONE
CUSTOMER_SITE_USE_ID			NUMBER(15)
SOURCE:	PROGRAM DETERMINES IT
DESTINATION:	AR_INTERIM_CASH_RECEIPTS.SITE_USE_ID
	AR_CASH_RECEIPTS.CUSTOMER_SITE_USE_ID
RECEIPT_DATE			DATE
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	AR_INTERIM_CASH_RECEIPTS.RECEIPT_DATE
	AR_INTERIM_CASH_RECEIPTS.EXCHANGE_DATE
	AR_CASH_RECEIPTS.RECEIPT_DATE
	AR_CASH_RECEIPTS.EXCHANGE_DATE
RECEIPT_METHOD			VARCHAR2(30)
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	NONE
RECEIPT_METHOD_ID			NUMBER(15)
SOURCE:	PROGRAM DETERMINES IT
DESTINATION:	AR_INTERIM_CASH_RECEIPTS.RECEIPT_METHOD_ID
	AR_CASH_RECEIPTS.RECEIPT_METHOD_ID
OVERFLOW_INDICATOR			VARCHAR2(1)
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	NONE
OVERFLOW_SEQUENCE			NUMBER
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	NONE
INVOICE1-8			VARCHAR2(50)
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	NONE
MATCHING_DATE1-8			DATE
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	NONE
RESOLVED_MATCHING_ NUMBER1-8			NUMBER
SOURCE:	PROGRAM DETERMINES IT
DESTINATION:	NONE
RESOLVED_MATCHING_DATE1-8			DATE
SOURCE:	PROGRAM DETERMINES IT
DESTINATION:	NONE
RESOLVED_MATCHING_ INSTALLMENT1-8			NUMBER
SOURCE:	PROGRAM DETERMINES IT
DESTINATION:	NONE
AMOUNT_APPLIED1-8			NUMBER
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	AR_INTERIM_CASH_RECEIPT_LINES.PAYMENT
	_AMOUNT
	AR_RECEIVABLE_APPLICATIONS.AMOUNT_APPLIED
INVOICE1_STATUS- INVOICE8_STATUS			VARCHAR2(30)
SOURCE:	PROGRAM DETERMINES IT
DESTINATION:	NONE
COMMENTS			VARCHAR2(240)
SOURCE:	ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	AR_BATCHES.COMMENTS
	AR_INTERIM_CASH_RECEIPTS.COMMENTS
ATTRIBUTE_CATEGORY			VARCHAR2(30)
ATTRIBUTE1-15			CHAR(40)
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	AR_INTERIM_CASH_RECEIPTS.ATTRIBUTE1...15
	AR_CASH_RECEIPTS.ATTRIBUTE1...15
INVOICE1_INSTALLMENT-
INVOICE8_INSTALLMENT			NUMBER
SOURCE:	LOCKBOX DATA FILE OR ENTERED BY USER VIA
	'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:	NONE
CUSTOMER_NAME_ALT			VARCHAR2(320)
SOURCE:	LOCKBOX DATA FILE
DESTINATION:	NONE
CUSTOMER_BANK_NAME			VARCHAR2(320)
SOURCE:	LOCKBOX DATA FILE
DESTINATION:	NONE
CUSTOMER_ BANK_BRANCH_NAME			VARCHAR2(320)
SOURCE:	LOCKBOX DATA FILE
DESTINATION:	NONE
REMITTANCE_ BANK_NAME			VARCHAR2(320)
SOURCE:	PROGRAM DETERMINES IT
DESTINATION:	NONE
REMITTANCE_ BANK_BRANCH_NAME			VARCHAR2(320)
SOURCE:	PROGRAM DETERMINES IT
DESTINATION:	NONE
Table 1 - 23. AR_PAYMENTS_INTERFACE Table (Page 8 of 8)