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.
- 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
Try it
Only attributes Oracle marks as searchable are offered.
GET /fscmRestApi/resources/11.13.18.05/intrastatTransactions?fields=AdjustedStatisticalValue,AffiliationReferenceCode,AlternateQuantity,AlternateUOM,AlternateUOMCode&limit=25&onlyData=true
{
"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
| Attribute | Type | Use |
|---|---|---|
AdjustedStatisticalValue | number | Optional on createUpdatableSearchable |
AffiliationReferenceCode | text · max 30 | Optional on createUpdatableSearchable |
AlternateQuantity | number | Optional on createUpdatableSearchable |
AlternateUOM | text · max 255 | Read-onlySearchable |
AlternateUOMCode | text · max 3 | Optional on createUpdatableSearchable |
AutomaticCreation | text · max 1 | Optional on createSearchable |
CSACode | text · max 30 | Optional on createUpdatableSearchable |
CategoryId | number | Optional on createUpdatableSearchable |
CategorySetId | number | Optional on createSearchable |
Comments | text · max 240 | Optional on createUpdatableSearchable |
CommodityCode | text · max 240 | Optional on createUpdatableSearchable |
CommodityDescription | text · max 240 | Optional on createUpdatableSearchable |
ContainerTypeCode | text · max 30 | Optional on createUpdatableSearchable |
CreatedBy | text · max 64 | Read-onlySearchable |
CreationDate | date-time | Read-onlySearchable |
CurrencyCode | text · max 15 | Optional on createUpdatableSearchable |
CurrencyConversionDate | date | Optional on createSearchable |
CurrencyConversionRate | number | Optional on createSearchable |
CurrencyConversionType | text · max 30 | Optional on createSearchable |
DeliveryTermsCode | text · max 30 | Optional on createUpdatableSearchable |
DestinationPostalCode | text · max 60 | Read-onlySearchable |
DestinationRegionCode | text · max 30 | Optional on createUpdatableSearchable |
DestinationTerritory | text · max 255 | Read-onlySearchable |
DestinationTerritoryCode | text · max 2 | Optional on createUpdatableSearchable |
DispatchTerritory | text · max 255 | Read-onlySearchable |
DispatchTerritoryCode | text · max 2 | Optional on createUpdatableSearchable |
DocumentLineNumber | text · max 20 | Optional on createUpdatableSearchable |
DocumentNumber | text · max 30 | Optional on createUpdatableSearchable |
DocumentSourceType | text · max 30 | Optional on createSearchable |
DocumentSourceTypeMeaning | text · max 255 | Read-only |
DocumentUnitPrice | number | Optional on createUpdatableSearchable |
EstablishmentId | number | Required on createUpdatableSearchable |
ExceptionsCount | number | Optional on createUpdatableSearchable |
FiscalRegimeCode | text · max 10 | Optional on createUpdatableSearchable |
FlowIndicatorCode | text · max 30 | Optional on createUpdatableSearchable |
FreightCharges | number | Optional on createSearchable |
FreightFactor | number | Optional on createUpdatableSearchable |
FromOrganizationId | number | Optional on createUpdatableSearchable |
GeographyId | number | Required on createSearchable |
InventoryItemId | number | Optional on createUpdatableSearchable |
InvoiceBatchId | number | Optional on createUpdatableSearchable |
InvoiceBatchName | text · max 50 | Optional on createUpdatableSearchable |
InvoiceCurrencyCode | text · max 15 | Optional on createUpdatableSearchable |
InvoiceDateReference | date | Optional on createUpdatableSearchable |
InvoiceId | number | Optional on createUpdatableSearchable |
InvoiceLineId | number | Optional on createUpdatableSearchable |
InvoiceLineNumber | text · max 30 | Optional on createUpdatableSearchable |
InvoiceNeeded | text · max 1 | Optional on createSearchable |
InvoiceNumber | text · max 50 | Optional on createUpdatableSearchable |
InvoiceQuantity | number | Optional on createUpdatableSearchable |
InvoiceQuantityUOM | text · max 255 | Read-onlySearchable |
InvoiceQuantityUOMCode | text · max 3 | Optional on createUpdatableSearchable |
InvoiceUnitPrice | number | Optional on createUpdatableSearchable |
InvoiceValue | number | Optional on createUpdatableSearchable |
InvoiceValueInReportingCurrency | number | Optional on createUpdatableSearchable |
ItemCode | text · max 300 | Optional on createUpdatableSearchable |
ItemCost | number | Optional on createUpdatableSearchable |
ItemDescription | text · max 240 | Optional on createUpdatableSearchable |
ItemUnitWeight | number | Optional on createUpdatable |
ItemWeightUOMCode | text | Optional on createUpdatable |
LastUpdateDate | date-time | Read-onlySearchable |
LastUpdateLogin | text · max 32 | Read-onlySearchable |
LastUpdatedBy | text · max 64 | Read-onlySearchable |
LegalEntityId | number | Optional on createUpdatableSearchable |
LegalEntityName | text · max 255 | Optional on createUpdatableSearchable |
LruName | text · max 240 | Optional on createUpdatableSearchable |
MovementId | number | Required on createSearchable |
MovementStatus | text · max 1 · default O | Optional on createUpdatableSearchable |
MovementStatusMeaning | text · max 255 | Optional on createUpdatableSearchable |
MovementType | text · max 3 | Required on createUpdatableSearchable |
MovementTypeMeaning | text · max 255 | Optional on createUpdatable |
ObjectVersionNumber | number | Optional on createUpdatableSearchable |
OilReferenceCode | text · max 30 | Optional on createUpdatableSearchable |
OrganizationId | number | Optional on createSearchable |
OrganizationName | text | Optional on createUpdatable |
OriginPostalCode | text · max 60 | Read-onlySearchable |
OriginRegionCode | text · max 30 | Optional on createUpdatableSearchable |
OriginTerritory | text · max 255 | Read-onlySearchable |
OriginTerritoryCode | text · max 2 | Optional on createSearchable |
OriginalTransactionDate | date | Optional on createUpdatableSearchable |
OutsideProcessValue | number | Optional on createUpdatableSearchable |
ParentMovementId | number | Optional on createUpdatableSearchable |
PeriodName | text · max 15 | Optional on createSearchable |
Port | text · max 30 | Optional on createUpdatableSearchable |
PreferenceCode | text · max 30 | Optional on createUpdatableSearchable |
ReportDate | date | Optional on createUpdatableSearchable |
ReportReference | text · max 200 | Optional on createUpdatableSearchable |
ReportingCurrencyCode | text · max 15 | Optional on createSearchable |
SetOfBooksPeriod | text · max 15 | Optional on createUpdatableSearchable |
StatisticalCode | text · max 10 | Optional on createUpdatableSearchable |
StatisticalValue | number | Optional on createUpdatableSearchable |
Status | text | Read-only |
SuppUOMText | text | Optional on createUpdatable |
SupplyReferenceCode | text · max 30 | Optional on createUpdatableSearchable |
TaricCode | text · max 30 | Optional on createUpdatableSearchable |
TerritoryCode | text · max 2 | Optional on createSearchable |
TerritoryName | text · max 80 | Optional on createSearchable |
ToLocationId | number | Read-onlySearchable |
ToOrganizationId | number | Read-onlySearchable |
TotalWeight | number | Optional on createUpdatableSearchable |
TotalWeightUOM | text · max 255 | Read-onlySearchable |
TotalWeightUOMCode | text · max 3 | Optional on createSearchable |
TradingPartnerId | number | Optional on createUpdatableSearchable |
TradingPartnerName | text · max 360 | Optional on createUpdatableSearchable |
TradingPartnerNumber | text · max 20 | Optional on createUpdatableSearchable |
TradingPartnerPartyId | number | Optional on createUpdatableSearchable |
TradingPartnerSiteCountry | text | Optional on createUpdatable |
TradingPartnerSiteId | number | Optional on createUpdatableSearchable |
TradingPartnerSiteName | text · max 250 | Optional on createUpdatableSearchable |
TradingPartnerSitePartyId | text · max 20 | Read-onlySearchable |
TradingPartnerType | text · max 1 | Optional on createUpdatableSearchable |
TradingPartnerTypeMeaning | text · max 255 | Read-onlySearchable |
TradingPartnerVATNumber | text · max 150 | Optional on createUpdatableSearchable |
TransactionDate | date | Required on createUpdatableSearchable |
TransactionDateHigh | date | Read-onlySearchable |
TransactionDateLow | date | Read-onlySearchable |
TransactionNatureCode | text · max 10 | Optional on createUpdatableSearchable |
TransactionQuantity | number | Optional on createUpdatableSearchable |
TransactionQuantityUOM | text · max 255 | Read-onlySearchable |
TransactionQuantityUOMCode | text · max 3 | Optional on createSearchable |
TransactionUOMText | text | Read-only |
TransactionValue | number | Optional on createUpdatableSearchable |
TransportModeCode | text · max 30 | Optional on createUpdatableSearchable |
TransportModeDescription | text · max 240 | Read-onlySearchable |
TriangulationCountry | text · max 255 | Read-onlySearchable |
TriangulationCountryCode | text · max 2 | Optional on createSearchable |
UnitWeight | number | Optional on createUpdatableSearchable |
VATRegistrationNumber | text · max 150 | Optional on createSearchable |
WeightUOMText | text | Read-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.
JmfInExceptionsGET JMF Intrastat Exceptions · 2 fieldsErrorDescriptionMovementId
Actions 4
POST …/action/ignoreResetTransactions·itemNumberdocumentNumberpActionperiodNamedocumentSourceTypefromTransactionDatedispatchCountryorganizationIdselectedTransactionsmovementTypelegalEntityIdcommodityCodevatRegistrationinvoiceNumberselectedToggleexcludedTransactionsmovementStatuskeywordSearchinvoiceDatedestinationCountrytradingPartnertoTransactionDatetradingPartnerTypemovementIdestablishmentIdPOST …/action/massEditTransactions·itemNumbernewOilReferencedocumentNumberperiodNamenewFreightTermsdocumentSourceTypefromTransactionDatedispatchCountryorganizationIdnewSupplyReferenceselectedTransactionsnewPreferenceCodemovementTypelegalEntityIdnewTradingPartnerVATcommodityCodevatRegistrationinvoiceNumbernewFreightFactorselectedToggleexcludedTransactionsmovementStatuskeywordSearchnewFlowIndicatorinvoiceDatedestinationCountrynewCountryOfOriginnewCategoryIdnewTransportModeCodetradingPartnernewNOTCCdodenewTARICCodetoTransactionDatetradingPartnerTypenewRegionOfOriginnewTransportContainernewDestinationRegionmovementIdnewAffiliationReferenceestablishmentIdPOST …/action/massValidateTransactions·excludedTransactionsitemNumbermovementStatusdocumentNumberkeywordSearchperiodNameinvoiceDatedocumentSourceTypefromTransactionDatedispatchCountrydestinationCountryorganizationIdtradingPartnerselectedTransactionsmovementTypelegalEntityIdcommodityCodevatRegistrationinvoiceNumbertoTransactionDatetradingPartnerTypemovementIdselectedToggleestablishmentIdPOST …/action/recalculateValues·unitPricecurrencyConversionDateunitWeightquantityterritoryCodefreightFactorcurrencyConversionTypecurrencyCodereportingCurrencyCodefreightCharges
Actions use Content-Type: application/vnd.oracle.adf.action+json. A path with a {key} runs on one record.
Use in AI Agent Studio
- Point a Business Object or REST tool at
/fscmRestApi/resources/11.13.18.05/intrastatTransactionsand ask only for the fields the agent needs withfields=. Big responses cost tokens and slow the agent. - Narrow with
q=on searchable fields and a smalllimit; for a count usetotalResults=true&limit=1. - Call once and pass the result on to later steps rather than calling the same endpoint again.
- This resource can change data. Put a human approval step before any create, update, delete or action call.
More in For Builders.
Pitfalls
- Attribute names are case-sensitive in
q,fieldsand bodies:AdjustedStatisticalValue, notadjustedstatisticalvalue. - 26 fields are read-only: sending them in POST or PATCH fails or is ignored. The builder leaves them out.
- Send dates as
YYYY-MM-DD; date-time fields take ISO 8601 with a time zone. - A list returns 25 rows unless you set
limit; readhasMoreand moveoffsetto page through. - Text fields have maximum lengths (shown in the field table). Longer values are rejected.