Brfulfilord (Service Layer)

In Scope

Technical: SVC_BRFULFILORD | ID: OR-INV-SVC_BRFULFILORD-BRFULFILORD_SERVICE_LAYER

This table is a parameter table used in integration services (e.g. web service, bulk interfaces) that will hold customer records for the customer order transfer Brazil attributes.

See how this object fits into Inventory Management

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity: Medium
Sequencing: Stage 2
Typical Sources: ERPLegacy

Classification

Object Type: dictionary

Target Structure

Load Approach: Table
Target Objects: SVC_BRFULFILORD

Field Definitions(5)

Rules & Considerations(38)

validation

constraint

Sample Load Data(4)

_scenario	PROCESS_IDR	ACTION_TYPER	FULFILORD_IDR	BRFULFILORD_IDR	PROCESS_STATUSR	CUST_CPF	CREATE_ID	ERROR_MSG	IE_EXEMPT	PRESENCE_IND	CUSTOMER_CNAE	TAXPAYER_TYPE	LAST_UPDATE_ID	CREATE_DATETIME	IPI_CONTRIBUTOR	ISS_CONTRIBUTOR	PIS_CONTRIBUTOR	CONTRIBUTOR_TYPE	ICMS_CONTRIBUTOR	CUST_NEIGHBORHOOD	COFINS_CONTRIBUTOR	TAX_EXCEPTION_TYPE	CITY_INSCRIPTION_ID	LAST_UPDATE_DATETIME	STATE_INSCRIPTION_ID	CORPORATE_TAXPAYER_ID	INCOME_RANGE_ELIGIBLE	INDIVIDUAL_TAXPAYER_ID	DISTRIBUTOR_MANUFACTURER	FISCAL_ADDRESS_INFORMATION	FREE_ZONE_MANAUS_INSCRPTN_ID
Example values from field definitions	1	SAMPLE	1	1	S	SAMPLE	SAMPLE	SAMPLE	S	1	SAMPLE	S	SAMPLE	2026-01-01	S	S	S	SA	S	SAMPLE	S	SA	SAMPLE	2026-01-01	SAMPLE	SAMPLE	S	SAMPLE	S	SAMPLE	SAMPLE
default	1000000003	Svc Brfulfilord-002-ALT	1000000003	1000000003	P	Svc Brfulfilord-002-ALT	MDM_USER	Svc Brfulfilord-002-ALT	S	3	Svc Brfulfilord-002-	S	MDM_USER	2026-01-03	S	S	S	Sv	S	Svc Brfulfilord-002-ALT	S	Sv	ALT-SVC_BRFULF-002	2026-01-03	ALT-SVC_BRFULF-002	ALT-SVC_BRFULF-002	S	ALT-SVC_BRFULF-002	S	Svc Brfulfilord-002-	ALT-SVC_BRFULF-002
default	1000000005	Svc Brfulfilord-003-EDGE	1000000005	1000000005	A	Svc Brfulfilord-003-EDGE	BATCH_USER	Svc Brfulfilord-003-EDGE	S	5	Svc Brfulfilord-003-	S	BATCH_USER	2026-01-05	S	S	S	Sv	S	Svc Brfulfilord-003-EDGE	S	Sv	EDGE-SVC_BRFULF-003	2026-01-05	EDGE-SVC_BRFULF-003	EDGE-SVC_BRFULF-003	S	EDGE-SVC_BRFULF-003	S	Svc Brfulfilord-003-	EDGE-SVC_BRFULF-003

Example values from field definitions

PROCESS_IDR: 1
ACTION_TYPER: SAMPLE
FULFILORD_IDR: 1
BRFULFILORD_IDR: 1
PROCESS_STATUSR: S
CUST_CPF: SAMPLE
CREATE_ID: SAMPLE
ERROR_MSG: SAMPLE
IE_EXEMPT: S
PRESENCE_IND: 1
CUSTOMER_CNAE: SAMPLE
TAXPAYER_TYPE: S
LAST_UPDATE_ID: SAMPLE
CREATE_DATETIME: 2026-01-01
IPI_CONTRIBUTOR: S
ISS_CONTRIBUTOR: S
PIS_CONTRIBUTOR: S
CONTRIBUTOR_TYPE: SA
ICMS_CONTRIBUTOR: S
CUST_NEIGHBORHOOD: SAMPLE
COFINS_CONTRIBUTOR: S
TAX_EXCEPTION_TYPE: SA
CITY_INSCRIPTION_ID: SAMPLE
LAST_UPDATE_DATETIME: 2026-01-01
STATE_INSCRIPTION_ID: SAMPLE
CORPORATE_TAXPAYER_ID: SAMPLE
INCOME_RANGE_ELIGIBLE: S
INDIVIDUAL_TAXPAYER_ID: SAMPLE
DISTRIBUTOR_MANUFACTURER: S
FISCAL_ADDRESS_INFORMATION: SAMPLE
FREE_ZONE_MANAUS_INSCRPTN_ID: SAMPLE

default

PROCESS_IDR: 1000000003
ACTION_TYPER: Svc Brfulfilord-002-ALT
FULFILORD_IDR: 1000000003
BRFULFILORD_IDR: 1000000003
PROCESS_STATUSR: P
CUST_CPF: Svc Brfulfilord-002-ALT
CREATE_ID: MDM_USER
ERROR_MSG: Svc Brfulfilord-002-ALT
IE_EXEMPT: S
PRESENCE_IND: 3
CUSTOMER_CNAE: Svc Brfulfilord-002-
TAXPAYER_TYPE: S
LAST_UPDATE_ID: MDM_USER
CREATE_DATETIME: 2026-01-03
IPI_CONTRIBUTOR: S
ISS_CONTRIBUTOR: S
PIS_CONTRIBUTOR: S
CONTRIBUTOR_TYPE: Sv
ICMS_CONTRIBUTOR: S
CUST_NEIGHBORHOOD: Svc Brfulfilord-002-ALT
COFINS_CONTRIBUTOR: S
TAX_EXCEPTION_TYPE: Sv
CITY_INSCRIPTION_ID: ALT-SVC_BRFULF-002
LAST_UPDATE_DATETIME: 2026-01-03
STATE_INSCRIPTION_ID: ALT-SVC_BRFULF-002
CORPORATE_TAXPAYER_ID: ALT-SVC_BRFULF-002
INCOME_RANGE_ELIGIBLE: S
INDIVIDUAL_TAXPAYER_ID: ALT-SVC_BRFULF-002
DISTRIBUTOR_MANUFACTURER: S
FISCAL_ADDRESS_INFORMATION: Svc Brfulfilord-002-
FREE_ZONE_MANAUS_INSCRPTN_ID: ALT-SVC_BRFULF-002