// fusionrest agent · supply chain and manufacturing · inventory management

Intrastat Transactions

intrastatTransactions Based on 26C

Create, change and look up Intrastat Transactions, with jmf in exceptions. Actions include ignore reset transactions and mass edit transactions.

/fscmRestApi/resources/11.13.18.05/intrastatTransactions
Operations
GET (list)GET (one)POST (create)PATCH (update)4 actions
Record key
MovementId
Required on create
EstablishmentIdGeographyIdMovementIdMovementTypeTransactionDate
At a glance
129 fields0 finders1 children
I want to…List the latest 25Count recordsGet one recordCreate oneUpdate one

Try it

Response fields ·
Filters (q)

Only attributes Oracle marks as searchable are offered.

Include children (expand)
Paging and options
limit
Endpoint and headers
GET /fscmRestApi/resources/11.13.18.05/intrastatTransactions?fields=AdjustedStatisticalValue,AffiliationReferenceCode,AlternateQuantity,AlternateUOM,AlternateUOMCode&limit=25&onlyData=true
Response shape (placeholders)
{
  "items": [
    {
      "AdjustedStatisticalValue": 0,
      "AffiliationReferenceCode": "<string, max 30>",
      "AlternateQuantity": 0,
      "AlternateUOM": "<string, max 255>",
      "AlternateUOMCode": "<string, max 3>"
    }
  ],
  "count": 25,
  "hasMore": true,
  "limit": 25,
  "offset": 0
}

Shapes and placeholders, not real data. Replace https://<your-pod> and the login with your own: this site never sees them. Based on Oracle's 26C REST specification.

Fields 129

AttributeTypeUse
AdjustedStatisticalValuenumberOptional on createUpdatableSearchable
AffiliationReferenceCodetext · max 30Optional on createUpdatableSearchable
AlternateQuantitynumberOptional on createUpdatableSearchable
AlternateUOMtext · max 255Read-onlySearchable
AlternateUOMCodetext · max 3Optional on createUpdatableSearchable
AutomaticCreationtext · max 1Optional on createSearchable
CSACodetext · max 30Optional on createUpdatableSearchable
CategoryIdnumberOptional on createUpdatableSearchable
CategorySetIdnumberOptional on createSearchable
Commentstext · max 240Optional on createUpdatableSearchable
CommodityCodetext · max 240Optional on createUpdatableSearchable
CommodityDescriptiontext · max 240Optional on createUpdatableSearchable
ContainerTypeCodetext · max 30Optional on createUpdatableSearchable
CreatedBytext · max 64Read-onlySearchable
CreationDatedate-timeRead-onlySearchable
CurrencyCodetext · max 15Optional on createUpdatableSearchable
CurrencyConversionDatedateOptional on createSearchable
CurrencyConversionRatenumberOptional on createSearchable
CurrencyConversionTypetext · max 30Optional on createSearchable
DeliveryTermsCodetext · max 30Optional on createUpdatableSearchable
DestinationPostalCodetext · max 60Read-onlySearchable
DestinationRegionCodetext · max 30Optional on createUpdatableSearchable
DestinationTerritorytext · max 255Read-onlySearchable
DestinationTerritoryCodetext · max 2Optional on createUpdatableSearchable
DispatchTerritorytext · max 255Read-onlySearchable
DispatchTerritoryCodetext · max 2Optional on createUpdatableSearchable
DocumentLineNumbertext · max 20Optional on createUpdatableSearchable
DocumentNumbertext · max 30Optional on createUpdatableSearchable
DocumentSourceTypetext · max 30Optional on createSearchable
DocumentSourceTypeMeaningtext · max 255Read-only
DocumentUnitPricenumberOptional on createUpdatableSearchable
EstablishmentIdnumberRequired on createUpdatableSearchable
ExceptionsCountnumberOptional on createUpdatableSearchable
FiscalRegimeCodetext · max 10Optional on createUpdatableSearchable
FlowIndicatorCodetext · max 30Optional on createUpdatableSearchable
FreightChargesnumberOptional on createSearchable
FreightFactornumberOptional on createUpdatableSearchable
FromOrganizationIdnumberOptional on createUpdatableSearchable
GeographyIdnumberRequired on createSearchable
InventoryItemIdnumberOptional on createUpdatableSearchable
InvoiceBatchIdnumberOptional on createUpdatableSearchable
InvoiceBatchNametext · max 50Optional on createUpdatableSearchable
InvoiceCurrencyCodetext · max 15Optional on createUpdatableSearchable
InvoiceDateReferencedateOptional on createUpdatableSearchable
InvoiceIdnumberOptional on createUpdatableSearchable
InvoiceLineIdnumberOptional on createUpdatableSearchable
InvoiceLineNumbertext · max 30Optional on createUpdatableSearchable
InvoiceNeededtext · max 1Optional on createSearchable
InvoiceNumbertext · max 50Optional on createUpdatableSearchable
InvoiceQuantitynumberOptional on createUpdatableSearchable
InvoiceQuantityUOMtext · max 255Read-onlySearchable
InvoiceQuantityUOMCodetext · max 3Optional on createUpdatableSearchable
InvoiceUnitPricenumberOptional on createUpdatableSearchable
InvoiceValuenumberOptional on createUpdatableSearchable
InvoiceValueInReportingCurrencynumberOptional on createUpdatableSearchable
ItemCodetext · max 300Optional on createUpdatableSearchable
ItemCostnumberOptional on createUpdatableSearchable
ItemDescriptiontext · max 240Optional on createUpdatableSearchable
ItemUnitWeightnumberOptional on createUpdatable
ItemWeightUOMCodetextOptional on createUpdatable
LastUpdateDatedate-timeRead-onlySearchable
LastUpdateLogintext · max 32Read-onlySearchable
LastUpdatedBytext · max 64Read-onlySearchable
LegalEntityIdnumberOptional on createUpdatableSearchable
LegalEntityNametext · max 255Optional on createUpdatableSearchable
LruNametext · max 240Optional on createUpdatableSearchable
MovementIdnumberRequired on createSearchable
MovementStatustext · max 1 · default OOptional on createUpdatableSearchable
MovementStatusMeaningtext · max 255Optional on createUpdatableSearchable
MovementTypetext · max 3Required on createUpdatableSearchable
MovementTypeMeaningtext · max 255Optional on createUpdatable
ObjectVersionNumbernumberOptional on createUpdatableSearchable
OilReferenceCodetext · max 30Optional on createUpdatableSearchable
OrganizationIdnumberOptional on createSearchable
OrganizationNametextOptional on createUpdatable
OriginPostalCodetext · max 60Read-onlySearchable
OriginRegionCodetext · max 30Optional on createUpdatableSearchable
OriginTerritorytext · max 255Read-onlySearchable
OriginTerritoryCodetext · max 2Optional on createSearchable
OriginalTransactionDatedateOptional on createUpdatableSearchable
OutsideProcessValuenumberOptional on createUpdatableSearchable
ParentMovementIdnumberOptional on createUpdatableSearchable
PeriodNametext · max 15Optional on createSearchable
Porttext · max 30Optional on createUpdatableSearchable
PreferenceCodetext · max 30Optional on createUpdatableSearchable
ReportDatedateOptional on createUpdatableSearchable
ReportReferencetext · max 200Optional on createUpdatableSearchable
ReportingCurrencyCodetext · max 15Optional on createSearchable
SetOfBooksPeriodtext · max 15Optional on createUpdatableSearchable
StatisticalCodetext · max 10Optional on createUpdatableSearchable
StatisticalValuenumberOptional on createUpdatableSearchable
StatustextRead-only
SuppUOMTexttextOptional on createUpdatable
SupplyReferenceCodetext · max 30Optional on createUpdatableSearchable
TaricCodetext · max 30Optional on createUpdatableSearchable
TerritoryCodetext · max 2Optional on createSearchable
TerritoryNametext · max 80Optional on createSearchable
ToLocationIdnumberRead-onlySearchable
ToOrganizationIdnumberRead-onlySearchable
TotalWeightnumberOptional on createUpdatableSearchable
TotalWeightUOMtext · max 255Read-onlySearchable
TotalWeightUOMCodetext · max 3Optional on createSearchable
TradingPartnerIdnumberOptional on createUpdatableSearchable
TradingPartnerNametext · max 360Optional on createUpdatableSearchable
TradingPartnerNumbertext · max 20Optional on createUpdatableSearchable
TradingPartnerPartyIdnumberOptional on createUpdatableSearchable
TradingPartnerSiteCountrytextOptional on createUpdatable
TradingPartnerSiteIdnumberOptional on createUpdatableSearchable
TradingPartnerSiteNametext · max 250Optional on createUpdatableSearchable
TradingPartnerSitePartyIdtext · max 20Read-onlySearchable
TradingPartnerTypetext · max 1Optional on createUpdatableSearchable
TradingPartnerTypeMeaningtext · max 255Read-onlySearchable
TradingPartnerVATNumbertext · max 150Optional on createUpdatableSearchable
TransactionDatedateRequired on createUpdatableSearchable
TransactionDateHighdateRead-onlySearchable
TransactionDateLowdateRead-onlySearchable
TransactionNatureCodetext · max 10Optional on createUpdatableSearchable
TransactionQuantitynumberOptional on createUpdatableSearchable
TransactionQuantityUOMtext · max 255Read-onlySearchable
TransactionQuantityUOMCodetext · max 3Optional on createSearchable
TransactionUOMTexttextRead-only
TransactionValuenumberOptional on createUpdatableSearchable
TransportModeCodetext · max 30Optional on createUpdatableSearchable
TransportModeDescriptiontext · max 240Read-onlySearchable
TriangulationCountrytext · max 255Read-onlySearchable
TriangulationCountryCodetext · max 2Optional on createSearchable
UnitWeightnumberOptional on createUpdatableSearchable
VATRegistrationNumbertext · max 150Optional on createSearchable
WeightUOMTexttextRead-only

Names, types, labels and flags from Oracle's REST specification (26C). Flexfield and custom attributes vary by pod: check /describe for yours.

Check a payload

Checked in your browser only; nothing you paste is sent anywhere. Checks names and flags, not values.

Children 1

Child resources sit under one record: /fscmRestApi/resources/11.13.18.05/intrastatTransactions/{MovementId}/child/<name>. Add them to a GET with expand.

Actions 4

Actions use Content-Type: application/vnd.oracle.adf.action+json. A path with a {key} runs on one record.

Use in AI Agent Studio

More in For Builders.

Pitfalls