[go: up one dir, main page]
Scribd
Upload
63 views23 pages

GSW WebService Example

This document outlines the REST API for GSW, detailing the objectives, connection requirements, and endpoints for accessing Suppliers, Items, Purchase Orders, and AP Invoices. It provides specific URLs and methods for each resource, along with example responses. The document serves as a guide for executing web service calls to retrieve and manage data related to these entities.

Uploaded by

Luis Jalys
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
63 views23 pages

GSW WebService Example

This document outlines the REST API for GSW, detailing the objectives, connection requirements, and endpoints for accessing Suppliers, Items, Purchase Orders, and AP Invoices. It provides specific URLs and methods for each resource, along with example responses. The document serves as a guide for executing web service calls to retrieve and manage data related to these entities.

Uploaded by

Luis Jalys
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 23

Rest Api - GSW

Date: 26 Jun 2021

Table of Contents
Rest Api - GSW 1
Objective 2
Connection 2
Suppliers 3
Items 4
Purchase Orders 11
AP Invoices 15
Create AP Invoices 21
Objective
This document contains the web service execution examples to find the Suppliers, Items, PO and AP
Invoices.

Connection
To invoke the web service, it is necessary:

URL:

• Enviroment URL: https://edvo-dev3.fa.em2.oraclecloud.com


• Path: Web service consumption path
o Suppliers: /fscmRestApi/resources/11.13.18.05/suppliers
o Items: /fscmRestApi/resources/11.13.18.05/itemsV2
o PO: /fscmRestApi/resources/11.13.18.05/purchaseOrders
o PO lineas:
/fscmRestApi/resources/11.13.18.05/purchaseOrders/{purchaseOrdersUniqID}/child/lines
o Invoices: /fscmRestApi/resources/11.13.18.05/invoices
o Invoice Lines:
/fscmRestApi/resources/11.13.18.05/invoices/{invoicesUniqID}/child/invoiceLines
o Create AP Invoice: /fscmRestApi/resources/11.13.18.05/invoices
• OCS User

Note: The environment address will change according to the Project stage, for which it will only be
necessary to change the prefix dev1, for dev3, for test, and the link to production is without prefix. The
path is the same in all environments.
Suppliers
URL:
https://edvo-
dev3.fa.em2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/suppliers?q=SupplierNumber=21621&onlyData=Tr
ue

Method: GET

Content-Type: application/vnd.oracle.adf.resourcecollection+json

Response: 200 OK

{
"items": [
{
"SupplierId": 300000034325963,
"SupplierPartyId": 300000034325961,
"Supplier": "Supplier Test 1",
"SupplierNumber": "21621",
"AlternateName": null,
"TaxOrganizationTypeCode": "CORPORATION",
"TaxOrganizationType": "Corporation",
"SupplierTypeCode": "SUPPLIER",
"SupplierType": "Supplier",
"InactiveDate": "2021-06-18",
"Status": "INACTIVE",
"BusinessRelationshipCode": "SPEND_AUTHORIZED",
"BusinessRelationship": "Spend Authorized",
"ParentSupplierId": null,
"ParentSupplier": null,
"ParentSupplierNumber": null,
"CreationDate": "2021-06-07T13:35:09.044+00:00",
"CreationSourceCode": "MANUAL",
"CreationSource": "Manual",
"Alias": null,
"DUNSNumber": null,
"OneTimeSupplierFlag": null,
"RegistryId": "688088",
"CustomerNumber": null,
"StandardIndustryClass": null,
"NationalInsuranceNumber": null,
"NationalInsuranceNumberExistsFlag": false,
"CorporateWebsite": null,
"YearEstablished": null,
"MissionStatement": null,
"YearIncorporated": null,
"ChiefExecutiveTitle": null,
"ChiefExecutiveName": null,
"PrincipalTitle": null,
"PrincipalName": null,
"FiscalYearEndMonthCode": null,
"FiscalYearEndMonth": null,
"CurrentFiscalYearPotentialRevenue": null,
"PreferredFunctionalCurrencyCode": null,
"PreferredFunctionalCurrency": null,
"TaxRegistrationCountryCode": null,
"TaxRegistrationCountry": null,
"TaxRegistrationNumber": null,
"TaxpayerCountryCode": "BR",
"TaxpayerCountry": "Brazil",
"TaxpayerId": "47960950089785",
"TaxpayerIdExistsFlag": true,
"FederalReportableFlag": false,
"FederalIncomeTaxTypeCode": null,
"FederalIncomeTaxType": null,
"StateReportableFlag": null,
"TaxReportingName": null,
"NameControl": null,
"VerificationDate": null,
"UseWithholdingTaxFlag": null,
"WithholdingTaxGroupId": null,
"WithholdingTaxGroup": null,
"BusinessClassificationNotApplicableFlag": null,
"DataFoxId": null
}
]
}

Items
URL: https://edvo-
dev3.fa.em2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/itemsV2?q=ItemNumber=TEST D8

Method: GET

Content-Type: application/vnd.oracle.adf.resourcecollection+json

Response: 200 OK

{
"items": [
{
"ItemId": 100000060028297,
"OrganizationId": 300000002417828,
"OrganizationCode": "VOPAK_IMO",
"ItemClass": "Root Item Class",
"Template": null,
"ItemNumber": "TEST D8",
"ItemDescription": "TABLET IPAD Test 8",
"ApprovalStatusValue": "Approved",
"ItemStatusValue": "Active",
"LifecyclePhaseValue": "Production",
"StyleItemFlag": null,
"StyleItemNumberValue": "TEST D8",
"Keyword": null,
"IgnoreDuplicateItemFlag": null,
"UserItemTypeValue": null,
"PackTypeValue": null,
"LongDescription": "TABLET IPAD Test 8",
"FormattedDescription": null,
"PrimaryUOMValue": "EA",
"TransactionConversionValue": "Both",
"DefaultingControlValue": null,
"PositiveDeviationFactor": 0,
"NegativeDeviationFactor": 0,
"CopyItemAndApplyTemplatesFlag": null,
"CopyAssociationsFlag": null,
"CopyAttachmentsFlag": null,
"CopyCategoriesFlag": null,
"CopyFromItemValue": null,
"CopyFromRevisionValue": null,
"CopyFromVersionValue": null,
"CopyOrganizationAssignmentsFlag": null,
"LastSubmittedNewItemRequest": null,
"ChangeNotice": null,
"ChangeOrderLineSequenceNumber": null,
"StructureItemTypeValue": "Standard",
"CreateConfiguredItem": null,
"ConfigModelTypeValue": "Standard",
"EffectivityControlValue": "Date",
"BaseItemValue": null,
"AutoCreatedConfigurationFlag": false,
"PickComponentsFlag": false,
"AssembleToOrderFlag": false,
"CostingEnabledFlag": true,
"IncludeInRollUpFlag": null,
"StandardLotSize": null,
"InventoryAssetFlag": true,
"BuildInWIPFlag": false,
"WIPSupplyTypeValue": "Push",
"WIPSupplyLocatorValue": null,
"WIPSupplySubinventoryValue": null,
"OvercompletionToleranceTypeValue": null,
"OvercompletionToleranceValue": null,
"InventoryCarryPenalty": null,
"OperationSlackPenalty": null,
"RecipeEnabledFlag": true,
"ProcessQualityEnabledFlag": false,
"ProcessCostingEnabledFlag": false,
"ProcessExecutionEnabledFlag": false,
"ProcessSupplySubinventoryValue": null,
"ProcessSupplyLocatorValue": null,
"ProcessYieldSubinventoryValue": null,
"ProcessYieldLocatorValue": null,
"HazardousMaterialFlag": true,
"CASNumber": null,
"AssetTrackedFlag": false,
"AssetClassValue": "Equipment",
"ServiceRequestEnabledValue": null,
"DefectTrackingOnFlag": null,
"ServiceDurationTypeValue": "Open Ended",
"ServiceDuration": null,
"ServiceDurationPeriodValue": null,
"ServiceStartTypeValue": "Milestone",
"ServiceStartDelay": 0,
"AllowSuspendFlag": false,
"AllowTerminateFlag": false,
"RequiresItemAssociationFlag": false,
"CreateFixedAssetFlag": null,
"InstanceClassValue": null,
"BillingTypeValue": null,
"ServiceBillingEnabledFlag": false,
"RecoveredPartDispositionValue": null,
"InventoryItemFlag": false,
"StockEnabledFlag": false,
"MaterialTransactionEnabledFlag": false,
"ReservableFlag": true,
"CheckMaterialShortageFlag": false,
"RevisionQuantityControlFlag": false,
"BulkPickedFlag": false,
"LotControlValue": "No lot control",
"StartingLotPrefix": null,
"StartingLotNumber": null,
"MaturityDays": null,
"HoldDays": null,
"LotExpirationControlValue": "No shelf life control",
"ShelfLifeDays": 0,
"RetestInterval": null,
"ExpirationActionValue": null,
"ExpirationActionInterval": null,
"ChildLotEnabledFlag": false,
"ChildLotFormatValidationFlag": false,
"CopyLotAttributeFlag": false,
"ChildLotPrefix": null,
"ChildLotStartingNumber": null,
"ChildLotParent": null,
"LotTranslateEnabledFlag": false,
"LotSplitEnabledFlag": false,
"LotDivisibleFlag": false,
"LotSubstitutionEnabledFlag": null,
"LotMergeEnabledFlag": false,
"GradeControlFlag": false,
"DefaultGradeValue": null,
"SerialGenerationValue": "No serial number control",
"SerialStartingPrefix": null,
"SerialStartingNumber": null,
"NegativeMeasurementError": null,
"PositiveMeasurementError": null,
"CycleCountEnabledFlag": false,
"LotStatusEnabledFlag": false,
"SerialStatusEnabledFlag": false,
"DefaultLotStatusValue": null,
"DefaultSerialStatusValue": null,
"RestrictSubinventoriesFlag": false,
"RestrictLocatorsFlag": false,
"StockLocatorControlValue": "No control",
"DimensionUOMValue": null,
"UnitWidthQuantity": null,
"UnitLengthQuantity": null,
"UnitHeightQuantity": null,
"WeightUOMValue": null,
"UnitWeightQuantity": null,
"VolumeUOMValue": null,
"UnitVolumeQuantity": null,
"ContainerItemFlag": null,
"ContainerTypeValue": null,
"MaximumLoadWeight": null,
"VehicleItemFlag": null,
"InternalVolume": null,
"MinimumFillPercent": null,
"WarehouseEquipmentFlag": false,
"EventFlag": null,
"CollateralFlag": null,
"CustomerOrderFlag": true,
"CustomerOrderEnabledFlag": true,
"ATPComponentsValue": "None",
"PickingRuleValue": null,
"RMAInspectionRequiredFlag": false,
"EligibilityRuleFlag": null,
"ReturnableFlag": false,
"ATPValue": "None",
"FinancingAllowedFlag": null,
"SalesProductTypeValue": null,
"TransactionEnabledFlag": false,
"OrderManagementIndivisibleFlag": null,
"DefaultSalesOrderSourceTypeValue": "Internal",
"ElectronicFormatFlag": null,
"ShippableFlag": false,
"DefaultShippingOrganizationValue": null,
"ShipModelCompleteFlag": false,
"DownloadableFlag": null,
"OverShipmentTolerance": null,
"UnderShipmentTolerance": null,
"OverReturnTolerance": null,
"UnderReturnTolerance": null,
"InvoiceEnabledFlag": true,
"AccountingRuleValue": null,
"PaymentTermsValue": null,
"OutputTaxClassificationCodeValue": null,
"InvoicedFlag": true,
"InvoicingRuleValue": null,
"SalesAccountValue": null,
"WebStatusValue": "Unpublished",
"BackOrderableFlag": null,
"OrderableOnWebFlag": true,
"MinimumLicenseQuantity": null,
"InventoryPlanningMethodValue": "Not planned",
"PlanningMakeBuyValue": "Buy",
"Planner": null,
"SubcontractingComponentValue": null,
"MinimumMinmaxQuantity": null,
"MaximumMinmaxQuantity": null,
"MinimumOrderQuantity": null,
"MaximumOrderQuantity": null,
"OrderCost": null,
"SourceOrganizationValue": null,
"SourceSubinventoryOrganizationValue": null,
"SourceSubinventoryValue": null,
"FixedOrderQuantity": null,
"FixedDaysSupply": null,
"FixedLotSizeMultiplier": null,
"ReleaseAuthorizationRequiredValue": "Customer",
"AutomaticallyExpireASNFlag": false,
"ConsignedFlag": false,
"ReplenishmentMinimumOrder": null,
"ReplenishmentMaximumOrder": null,
"VMIFixedOrderQuantity": null,
"ForecastTypelValue": "Order Forecast",
"ForecastHorizon": null,
"PlanningMethodValue": "Not Planned",
"RoundingControlTypeFlag": null,
"CreateSupplyFlag": true,
"PlanningTimeFence": "User Defined Time Fence",
"DemandTimeFence": null,
"ReleaseTimeFence": null,
"ShrinkageRate": null,
"ForecastControlValue": null,
"AcceptableEarlyDays": null,
"PlanningTimeDays": 1,
"DemandTimeDays": null,
"ReleaseTimeDays": null,
"MRPCalculateATPFlag": null,
"PreprocessingDays": null,
"PostprocessingDays": 0,
"ProcessingDays": null,
"VariableLeadTime": null,
"CumulativeTotalLeadTime": null,
"FixedLeadTime": null,
"CumulativeManufacturingLeadTime": null,
"LeadTimeLotSize": 1,
"PurchasingFlag": true,
"UseApprovedSupplierFlag": false,
"NegotiationRequiredFlag": null,
"PurchasingInputTaxClassificationValue": null,
"InvoiceCloseTolerancePercentage": null,
"HazardClassValue": null,
"AssetCategoryValue": null,
"PurchasableFlag": true,
"TaxableFlag": true,
"BuyerOrganizationValue": null,
"DefaultBuyerValue": null,
"ReceiptCloseTolerancePercentage": null,
"UNNumberValue": null,
"ListPrice": null,
"PriceTolerancePercentage": null,
"MarketPrice": null,
"RoundingFactor": null,
"MatchApprovalLevelValue": null,
"MatchConfigurationOptionValue": null,
"ReceiptDateActionValue": null,
"DaysEarlyReceiptAllowed": null,
"DaysLateReceiptAllowed": null,
"AllowSubstituteReceiptsFlag": null,
"AllowUnorderedReceiptsFlag": null,
"QuantityReceivedToleranceAction": null,
"QuantityReceivedTolerancePercentage": null,
"ItemExtensibleFlexfieldCategoryCode": "ROOT_ICC",
"CreationDate": "2021-05-28T15:41:48.203+00:00",
"LastUpdateDate": "2021-05-28T15:41:51.385+00:00",
"BackToBackEnabledFlag": false,
"ContractManufacturingFlag": false,
"DaysOfCover": null,
"DemandPeriod": null,
"SafetyStockPlanningMethodValue": "Not Planned",
"OutsideProcessServiceFlag": false,
"AllowMaintenanceAssetFlag": false,
"EnableGenealogyTrackingFlag": false,
"EngineeredItemFlag": false,
"ProcurementBusinessUnitName": null,
"ForcePurchaseLeadTimeFlag": true,
"ReplacementTypeValue": null,
"BuyerEmailAddress": null,
"AssetTrackedValue": "Not Tracked",
"RequestId": 1766624,
"CreatedBy": "alberto.lopez.herrera",
"CreationDateTime": "2021-05-28T15:41:48.203+00:00",
"LastUpdateDateTime": "2021-05-28T15:41:51.385+00:00",
"LastUpdateLogin": "C366B4491F181631E0530965410A47C5",
"LastUpdatedBy": "alberto.lopez.herrera",
"InternallyTransferableFlag": false,
"TransferOrdersEnabledFlag": false,
"ReplenishmentMaximumDaysOfSupply": null,
"CustomerSelfServiceEnabledFlag": false,
"AllowPurchasingDocumentDescriptionUpdateFlag": true,
"EnableContractCoverage": true,
"CarryingCostPercentage": null,
"ReplenishmentMinimumDaysOfSupply": null,
"AllowExpressTransactionsFlag": null,
"ReceiptRoutingValue": null,
"InvoiceMatchOptionValue": "Receipt",
"CommsActivationRequiredFlag": null,
"RequiresFulfillmentLocationFlag": false,
"IssueUOMValue": null,
"EnforceShipToLocationValue": null,
"StandardCoverageValue": null,
"ReplenishmentSourceTypeValue": null,
"TrackingUOMValue": "Primary",
"SecondaryUOMValue": null,
"PricingUOMValue": "Primary",
"HardPeggingLevelValue": "None",
"CommonSupplyProjectDemandFlag": null,
"EnableIotFlag": false,
"ExpenditureTypeValue": null,
"PackagingStringValue": null
}
]
}

Purchase Orders
URL Header: https://edvo-
dev3.fa.em2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/purchaseOrders?onlyData=True&q=ProcurementB
U=Vopak Procurement BR;StatusCode=OPEN&limit=1000

Method: GET

Content-Type: application/json

Response: 200 OK

{
"items": [
{
"POHeaderId": 149426,

"OrderNumber": "421ON",
"SoldToLegalEntityId": 300000034033786,
"SoldToLegalEntity": "LE Vopak Brasil S.A SANTOS",
"CreationDate": "2021-06-28T21:17:47+00:00",
"StatusCode": "OPEN",
"Status": "Open",
"ProcurementBUId": 300000034075600,
"ProcurementBU": "Vopak Procurement BR",
"RequisitioningBUId": 300000034075587,
"RequisitioningBU": "6110 BR Santos",
"BillToBUId": 300000034075587,
"BillToBU": "6110 BR Santos",
"Revision": 0,
"BuyerId": 300000034520879,
"Buyer": "Anfrisio, Gilmar",
"SupplierId": 300000034636799,
"Supplier": "Abilio Pereira Simone",
"SupplierSiteId": 300000034650879,
"SupplierSite": "MAIN-PURCHASING",
"SupplierContactId": 300000034667320,
"SupplierContact": "Simone, abiliosi",
"BillToLocationId": 300000034075468,
"BillToLocation": "Vopak Brasil S.A SANTOS",
"ConversionRateType": null,
"Ordered": 190.75,
"CurrencyCode": "BRL",
"Currency": "Brazilian Real",
"TotalTax": 0,
"Total": 190.75,
"Description": "APOIO E INFRAESTRUTURA ADMIMINNCM 9999.99.99",
"MasterContractId": null,
"MasterContractNumber": null,
"MasterContractTypeId": null,
"MasterContractType": null,
"RequiredAcknowledgmentCode": "N",
"RequiredAcknowledgment": "None",
"SupplierOrder": "421 ON",
"ReferenceNumber": null,
"AcknowledgmentDueDate": null,
"PaymentTermsId": 10001,
"PaymentTerms": "Immediate",
"CarrierId": null,
"Carrier": null,
"ModeOfTransportCode": null,
"ModeOfTransport": null,
"ServiceLevelCode": null,
"ServiceLevel": null,
"ShippingMethod": "",
"FreightTermsCode": "NONE",
"FreightTerms": "None",
"FOBCode": "DDP",
"FOB": "DDP",
"RequiresSignatureFlag": false,
"AcknowledgeWithinDays": null,
"BuyerManagedTransportFlag": false,
"PayOnReceiptFlag": false,
"ConfirmingOrderFlag": false,
"NoteToSupplier": null,
"NoteToReceiver": null
}
]
}
URL Lines: https://edvo-
dev3.fa.em2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/purchaseOrders/300000028744275/child/lines?q=
StatusCode=OPEN&onlyData=True

Método: GET

Content-Type: application/json

Respuesta: 200 OK

{
"items": [
{
"POLineId": 273206,
"POHeaderId": 149426,
"LineNumber": 1,
"OrderNumber": "421ON",
"LineTypeId": 300000002527025,
"LineType": "Services Quantity Based",
"ItemId": 100000078885295,
"Item": "BR24268",
"ConsignmentLineFlag": false,
"ItemRevision": null,
"Description": "Apoio E Infraestrutura Admimin - 804674",
"SupplierItem": null,
"SupplierConfigurationId": null,
"CategoryId": 300000002526056,
"CategoryCode": "Other_Professional_Services",
"Category": "Other Professional Services",
"StatusCode": "OPEN",
"Status": "Open",
"UOMCode": "zzL",
"UOM": "PC",
"Quantity": 1,
"Price": 91.98,
"NegotiatedFlag": false,
"CurrencyCode": "BRL",
"Currency": "Brazilian Real",
"WorkOrderProduct": null,
"NoteToSupplier": null,
"UNNumberId": null,
"UNNumber": null,
"UNNumberDescription": null,
"HazardClassCode": null,
"HazardClassId": null,
"HazardClass": null,
"Ordered": 91.98,
"TotalTax": 0,
"Total": 91.98,
"SourceAgreementId": null,
"SourceAgreementNumber": null,
"SourceAgreementLineId": null,
"SourceAgreementLine": null,
"SourceAgreementTypeCode": null,
"SourceAgreementType": null,
"MaximumRetainageAmount": null,
"Manufacturer": null,
"ManufacturerPartNumber": null
},
{
"POLineId": 273207,
"POHeaderId": 149426,
"LineNumber": 2,
"OrderNumber": "421ON",
"LineTypeId": 300000002527025,
"LineType": "Services Quantity Based",
"ItemId": 100000078885295,
"Item": "BR24268",
"ConsignmentLineFlag": false,
"ItemRevision": null,
"Description": "Apoio E Infraestrutura Admimin - 804674",
"SupplierItem": null,
"SupplierConfigurationId": null,
"CategoryId": 300000002526056,
"CategoryCode": "Other_Professional_Services",
"Category": "Other Professional Services",
"StatusCode": "OPEN",
"Status": "Open",
"UOMCode": "zzL",
"UOM": "PC",
"Quantity": 1,
"Price": 98.77,
"NegotiatedFlag": false,
"CurrencyCode": "BRL",
"Currency": "Brazilian Real",
"WorkOrderProduct": null,
"NoteToSupplier": null,
"UNNumberId": null,
"UNNumber": null,
"UNNumberDescription": null,
"HazardClassCode": null,
"HazardClassId": null,
"HazardClass": null,
"Ordered": 98.77,
"TotalTax": 0,
"Total": 98.77,
"SourceAgreementId": null,
"SourceAgreementNumber": null,
"SourceAgreementLineId": null,
"SourceAgreementLine": null,
"SourceAgreementTypeCode": null,
"SourceAgreementType": null,
"MaximumRetainageAmount": null,
"Manufacturer": null,
"ManufacturerPartNumber": null
}
],
"count": 2,
"hasMore": false,
"limit": 25,
"offset": 0,
"links": [
{
"rel": "self",
"href": "https://edvo-
dev3.fa.em2.oraclecloud.com:443/fscmRestApi/resources/11.13.18.05/purchaseOrders/149426/child/
lines",
"name": "lines",
"kind": "collection"
}
]
}

AP Invoices
URL Header: https://edvo-
dev3.fa.em2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices?q=ValidationStatus=Not
validated;LegalEntity=LE Vopak Brasil S.A SANTOS&onlyData=True

Method: GET

Content-Type: application/vnd.oracle.adf.resourceitem+json

Response: 200 OK

{
"items": [
{
"InvoiceId": 1674131,
"InvoiceNumber": "6900007-01-20210624-22892409000100",
"InvoiceCurrency": "BRL",
"PaymentCurrency": "BRL",
"InvoiceAmount": 100,
"InvoiceDate": "2021-06-24",
"BusinessUnit": "6110 BR Santos",
"Supplier": "Abs Com Moveis Equip E Maq Escrit Ltda",
"SupplierNumber": "21637",
"ProcurementBU": null,
"SupplierSite": "MAIN-PURCHASING",
"RequesterId": null,
"Requester": null,
"InvoiceGroup": null,
"ConversionRateType": null,
"ConversionDate": null,
"ConversionRate": null,
"AccountingDate": "2021-06-24",
"Description": null,
"DeliveryChannelCode": null,
"DeliveryChannel": null,
"PayAloneFlag": false,
"InvoiceSource": "Fiscal Document Capture",
"InvoiceType": "Standard",
"PayGroup": "VPK Normal Supplier",
"InvoiceReceivedDate": "2021-06-24",
"PaymentReasonCode": null,
"PaymentReason": null,
"PaymentReasonComments": null,
"RemittanceMessageOne": null,
"RemittanceMessageTwo": null,
"RemittanceMessageThree": null,
"PaymentTerms": "Net 15",
"TermsDate": "2021-06-24",
"GoodsReceivedDate": "2021-06-24",
"PaymentMethodCode": "ACH_1",
"PaymentMethod": "ACH",
"SupplierTaxRegistrationNumber": null,
"FirstPartyTaxRegistrationId": null,
"FirstPartyTaxRegistrationNumber": null,
"LegalEntity": "LE Vopak Brasil S.A SANTOS",
"LegalEntityIdentifier": "LE_BR_VS",
"LiabilityDistribution": "6110.20500.000.000.000.0000.000000.000000.000",
"DocumentCategory": "STD INV - Standard Invoices",
"DocumentSequence": 3,
"VoucherNumber": null,
"ValidationStatus": "Not validated",
"ApprovalStatus": "Required",
"PaidStatus": "Unpaid",
"AccountingStatus": "Unaccounted",
"ApplyAfterDate": null,
"CanceledFlag": false,
"AmountPaid": 0,
"BaseAmount": null,
"PurchaseOrderNumber": null,
"Party": "Abs Com Moveis Equip E Maq Escrit Ltda",
"PartySite": "SALVADOR",
"ControlAmount": null,
"DocumentFiscalClassificationCodePath": null,
"TaxationCountry": "Brazil",
"RoutingAttribute1": null,
"RoutingAttribute2": null,
"RoutingAttribute3": null,
"RoutingAttribute4": null,
"RoutingAttribute5": null,
"AccountCodingStatus": "Not required",
"BudgetDate": "2021-06-24",
"FundsStatus": "Not attempted",
"CanceledDate": null,
"CanceledBy": null,
"UniqueRemittanceIdentifier": null,
"UniqueRemittanceIdentifierCheckDigit": null,
"CreationDate": "2021-06-24T12:16:23+00:00",
"CreatedBy": "Hsie.Hsuan",
"LastUpdatedBy": "Hsie.Hsuan",
"LastUpdateDate": "2021-06-24T12:16:23+00:00",
"LastUpdateLogin": "C565A4B7A34B0794E0530765410A4956",
"BankAccount": "8896578",
"SupplierIBAN": null,
"ExternalBankAccountId": 913113,
"BankChargeBearer": null,
"SettlementPriority": null
}
],
"count": 1,
"hasMore": true,
"limit": 1,
"offset": 0,
"links": [
{
"rel": "self",
"href": "https://edvo-
dev3.fa.em2.oraclecloud.com:443/fscmRestApi/resources/11.13.18.05/invoices",
"name": "invoices",
"kind": "collection"
},
{
"rel": "action",
"href": "https://edvo-
dev3.fa.em2.oraclecloud.com:443/fscmRestApi/resources/11.13.18.05/invoices/action/cancelInvoic
e",
"name": "cancelInvoice",
"kind": "other"
},
{
"rel": "action",
"href": "https://edvo-
dev3.fa.em2.oraclecloud.com:443/fscmRestApi/resources/11.13.18.05/invoices/action/cancelLine",
"name": "cancelLine",
"kind": "other"
},
{
"rel": "action",
"href": "https://edvo-
dev3.fa.em2.oraclecloud.com:443/fscmRestApi/resources/11.13.18.05/invoices/action/validateInvo
ice",
"name": "validateInvoice",
"kind": "other"
},
{
"rel": "action",
"href": "https://edvo-
dev3.fa.em2.oraclecloud.com:443/fscmRestApi/resources/11.13.18.05/invoices/action/calculateTax
",
"name": "calculateTax",
"kind": "other"
},
{
"rel": "action",
"href": "https://edvo-
dev3.fa.em2.oraclecloud.com:443/fscmRestApi/resources/11.13.18.05/invoices/action/generateDist
ributions",
"name": "generateDistributions",
"kind": "other"
},
{
"rel": "action",
"href": "https://edvo-
dev3.fa.em2.oraclecloud.com:443/fscmRestApi/resources/11.13.18.05/invoices/action/applyPrepaym
ents",
"name": "applyPrepayments",
"kind": "other"
},
{
"rel": "action",
"href": "https://edvo-
dev3.fa.em2.oraclecloud.com:443/fscmRestApi/resources/11.13.18.05/invoices/action/unapplyPrepa
yments",
"name": "unapplyPrepayments",
"kind": "other"
}
]
}

URL Lines:
https://edvo-
dev3.fa.em2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/1674131/child/invoiceLines?onlyData=Tru
e

Method: GET

Content-Type: application/vnd.oracle.adf.resourceitem+json

Response: 200 OK

{
"items": [
{
"LineNumber": 1,
"LineAmount": 100,
"AccountingDate": "2021-06-24",
"UOM": "EA",
"TaxRateName": null,
"LineType": "Item",
"AssetBook": null,
"TrackAsAssetFlag": false,
"BaseAmount": null,
"Description": "Test ítem Rec Rout",
"IncomeTaxRegion": null,
"Item": "BR10001",
"ItemDescription": "Test ítem Rec Rout",
"LineSource": "Interface imported invoice",
"Quantity": 1,
"DistributionCombination": "",
"AssetCategory": "",
"UnitPrice": 100,
"ProrateAcrossAllItemsFlag": false,
"LandedCostEnabled": "N",
"DiscardedFlag": false,
"CanceledFlag": false,
"IncomeTaxType": null,
"TaxRateCode": null,
"TaxRate": null,
"TaxClassification": null,
"GenerateDistributions": "D",
"BudgetDate": "2021-06-24",
"FundsStatus": "Not attempted",
"ApprovalStatus": "Not required",
"DistributionSet": null,
"Withholding": null,
"ShipToLocationCode": null,
"ShipToLocation": null,
"ShipToCustomerLocation": null,
"TaxControlAmount": null,
"AssessableValue": 100,
"ProductType": "Goods",
"ProductCategory": "Goods",
"ProductCategoryCodePath": "GOODS",
"UserDefinedFiscalClassification": null,
"UserDefinedFiscalClassificationCode": null,
"IntendedUse": "Consumption without IPI",
"IntendedUseCode": null,
"ProductFiscalClassification": null,
"ProductFiscalClassificationCode": null,
"ProductFiscalClassificationType": null,
"TransactionBusinessCategory": "Purchase for Manufacture, Sale, or Provision of Se
rvice",
"TransactionBusinessCategoryCodePath": "PURCHASE_TRANSACTION/OPERATION FISCAL CODE
/1100",
"Requester": "Lopez Herrera, Alberto",
"PurchasingCategory": "Actuators",
"MatchType": "ITEM_TO_RECEIPT",
"MatchOption": "Receipt",
"MatchBasis": "Quantity",
"PurchaseOrderNumber": "P6900007",
"PurchaseOrderLineNumber": 1,
"PurchaseOrderScheduleLineNumber": 1,
"ReceiptNumber": "900006",
"ReceiptLineNumber": 1,
"ConsumptionAdviceNumber": null,
"ConsumptionAdviceLineNumber": null,
"FinalMatchFlag": null,
"MultiperiodAccountingStartDate": null,
"MultiperiodAccountingEndDate": null,
"MultiperiodAccountingAccrualAccount": "",
"CreatedBy": "Hsie.Hsuan",
"CreationDate": "2021-06-24T12:16:46+00:00",
"LastUpdateDate": "2021-06-24T12:16:46+00:00",
"LastUpdatedBy": "Hsie.Hsuan",
"LastUpdateLogin": "C565A4B7A34B0794E0530765410A4956",
"RequesterId": 300000022242534,
"PrepaymentNumber": null,
"PrepaymentLineNumber": null,
"PrepaymentIncludedonInvoiceFlag": null
}
],
"count": 1,
"hasMore": false,
"limit": 25,
"offset": 0,
"links": [
{
"rel": "self",
"href": "https://edvo-
dev3.fa.em2.oraclecloud.com:443/fscmRestApi/resources/11.13.18.05/invoices/1674131/child/invoi
ceLines",
"name": "invoiceLines",
"kind": "collection"
}
]
}

Create AP Invoices

URL:
https://edvo-dev3.fa.em2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices

Method: POST

Content-Type: application/json
Body: JSON

{
"InvoiceNumber": "WS_02",
"InvoiceCurrency": "BRL",
"InvoiceAmount": 2212.75,
"InvoiceDate": "2021-06-29",
"BusinessUnit": "6110 BR Santos",
"Supplier": " Autoridade Portuaria De Santos S.A",

"SupplierSite": " MAIN-PURCHASING",


"Requester": "I Hsuan, Hsie",
"Description": "Invoice from WS",
"PaymentTerms": "Immediate",
"TermsDate": "2021-05-25",
"PaymentMethod": "Wire",

"invoiceLines": [{
"LineNumber": 1,
"LineType": "Item",
"Description": "Desc Line 1",
"LineAmount": 1000,

"invoiceDistributions": [{
"DistributionLineNumber": 1,
"DistributionLineType": "Item",
"DistributionAmount": 1000,
"DistributionCombination": "6110.52750.090.000.000.0000.000000.000000.000"

}]
},
{
"LineNumber": 2,
"LineType": "Item",
"Description": "Desc Line 2",
"LineAmount": 100,

"invoiceDistributions": [{
"DistributionLineNumber": 1,
"DistributionLineType": "Item",
"DistributionAmount": 100,
"DistributionCombination": "6110.23750.000.000.000.0000.BR0005.000000.000"

}]

}]

Response: 201 Created

You might also like