How to fetch SOURCE_MANUAL_PRICE_ADJ_ID based on the adjustment type?
While creating sales order using REST API with manual price adjustments, there is a field called 'SourceManualPriceAdjustmentId' that needs to be mandatorily passed. From which table can I get this id based on the adjustment type?
REST API URL: /fscmRestApi/resources/11.13.18.05/salesOrdersForOrderHub
Request Payload:
{
"SourceTransactionSystem":"OPS",
"SourceTransactionId" : "400002368884687",
"SourceTransactionNumber" : "TEST_5074",
"BusinessUnitName":"US BU USD",
"BuyingPartyName":"RUST-OLEUM CORP",
"TransactionTypeCode" : "Bill Only Order",
"RequestingBusinessUnitId": 300002422266978,
"PaymentTerms":"N30",
"TransactionalCurrencyName":"US Dollar",
"FreezeShippingChargeFlag":false,
"FreezeTaxFlag":false,
"SubmittedFlag":false,
"FreezePriceFlag": false,
"billToCustomer":[
{
"PartyName":"RUST-OLEUM CORP",
"AccountNumber":"1000064"
}
],
"lines": [{
"SourceTransactionLineId": "1",
"SourceTransactionLineNumber": "1",
"SourceScheduleNumber": "1",
"SourceTransactionScheduleId": "1",
"RequestedShipDate": "2024-03-28T10:12:01+00:00",
"OrderedUOMCode": "LB",
"OrderedQuantity": 100,
"ProductNumber": "2708.25",
"FreightTerms": "Freight Collect",
"TransactionLineType" : "Buy",
"TransactionLineTypeCode": "ORA_BUY",