.
| Payment_id | Primary Key |
| payment_service_request_id | foreign key to iby_pay_service_requests |
| Porcess_type | Lookup IBY_PROCESS_TYPES |
| Payment_status | Lookup IBY_PAYMENT_STATUSES |
| Exclusive_payment_flag | if it is Y then normally one invoice is paid using this payment |
| Internal_bank_account_id | Foreign key to ce_bank_accounts |
| Ext_payee_id | Foreign key to iby_external_payees_all |
| Payee_party_id | Foreign key to HZ_Parties, party associated with Supplier |
| Supplier_site_id | Foreign key to ap_supplier_sites_all |
| Paper_document_number | check Number. |
| ext_bank_account_id | Foreign key to iby_ext_bank_accounts |
| Payment_amount | check/EFT amount |
how to create record to this table while creating ap_checks ?
ReplyDelete