AP Invoice Interface

AP Invoice Interface:

select lookup_code

from ap_lookup_codes

where lookup_type='SOURCE'

INSERT

INTO ap_invoices_interface

(

invoice_id,

INVOICE_NUM,

DESCRIPTION,

invoice_type_lookup_code,

invoice_date,

vendor_id,

vendor_site_id,

invoice_amount,

INVOICE_CURRENCY_CODE,

source,

payment_method_code,

taxation_country

org_id

)

VALUES

(

AP_INVOICES_INTERFACE_S.NEXTVAL

, 'TESTINV01'

,'this is test invoice'

,'STANDARD'

,SYSDATE -40 --<invoice date>

,35028--<vendor_id validated against po_vendors.vendor_id>,

,2277--<vendor_site_id validated against po_vendor_sites.vendor_site_id>,

,100--<invoice_amount>

,'AED'

,'MANUAL INVOICE ENTRY'

,'CHECK'

, 'AE'

,81

);

INSERT

INTO ap_invoice_lines_interface

(

invoice_id,

invoice_line_id,

line_number,

line_type_lookup_code,

amount,

accounting_date,

dist_code_combination_id

)

VALUES

(

AP_INVOICES_INTERFACE_S.CURRVAL

,AP_INVOICE_LINES_INTERFACE_S.NEXTVAL

,1--<some unique_number>,

,'ITEM'--<ITEM>/<FREIGHT>/<TAX>

,100--<line_amount> sum of line_amount should always be equal to invoice_amount,

,SYSDATE -40

,4565 --'<account code>'—CC_ID

);

COMMIT;

After inserting, run the “PAYABLES OPEN INTERFACE IMPORT” program to load invoice

Purchase Requisition(PR) Creation Interface

Sample Script to create PR:

INSERT INTO po_requisitions_interface_all

                        (interface_source_code

                       , source_type_code

                      , destination_type_code, authorization_status

                      , preparer_id, category_id

                      , item_description, quantity

                      , unit_price, charge_account_id

                      , unit_of_measure

                      , suggested_vendor_id

                      , destination_organization_id

                      , deliver_to_location_id

                       , deliver_to_requestor_id

                      , org_id

                      , group_code,

                      )

                 VALUES (

                      'FSI'

                  , ‘VENDOR’

                  , ‘EXPENSE’

                  , 'INCOMPLETE'

                  , 200 --Person ID

                  , 1233  --Category ID

                  , ‘This is test item’  --Item Description

                   , 10 --Quantity

                   ,   100 --Unit Price

                   , 123  --CC_Id

                   , ’Each’

                   , 231 --suggested_vendor_id

                   , 101   --Destination Org ID

                    , 142 --Deliver to location ID

                     , 200 --Person ID

                     , 81 --Org ID

                     , 103 --Group Code --This is to group the requisition lines

                       );

Then run Requisition Import program: