Essential field extraction from fusion using API for po creation with Validation

Summary:

We have a requirement to create POs in bulk, user only provide us fields such as Procurement BU,Requisitioning BU,Doument Style Name,Supplier Number Supplier Site ID,Default Ship To Location,Item and Quantity.

Currently we are using Fusion tables (using BIP report) to get below details with certain validations, request your help to share if we can achieve the same through API call.

These are the fields that we need:

BuyerID
Currency Code
Currency Conversion rate
Rate type
TermsID
BillToLocation
RequiredAcknowledgment
BuyerManagedTransportFlag
PayOnReceiptFlag
ShippingMethod
LineType
UOM
Inventory organization ID
ItemBuyerID
ShipToLocation
ShipToOrganizationCode
ReceiptCloseTolerancePercent
InvoiceMatchOptionCode
MatchApprovalLevelCode
EarlyReceiptToleranceDays
InvoiceCloseTolerancePercent