FIF Supplier Address Stg
In ScopeTechnical: FIF_SUPPLIER_ADDRESS_STG | ID: OR-FIN-FIF_SUPPLIER_ADDRESS_STG-FIF_SUPPLIER_ADDRESS_STG
This staging table will hold the supplier address information interfaced from CFIN. The address is a child array of master supplier.
See how this object fits into Finance
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
- FIF_SUPPLIER_ADDRESS_STG
Field Definitions(5)
Rules & Considerations(19)
Sample Load Data(4)
| _scenario | PROCESS_IDR | SUPPLIER_NUMBERR | CITY | STATE | PROVINCE | FAX_NUMBER | POSTAL_CODE | COUNTRY_CODE | PHONE_NUMBER | ADDRESS_LINE1 | ADDRESS_LINE2 | ADDRESS_LINE3 | ADDRESS_LINE4 | FAX_AREA_CODE | PHONE_AREA_CODE | SUPPLIER_ADDRESS_ID | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SA | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 |
| default | 1000000003 | FIF Supplier Address Stg-002-A | FIF Supplier Address Stg-002-ALT | FIF Supplier Address Stg-002-ALT | FIF Supplier Address Stg-002-ALT | FIF Supplier Address Stg-002-ALT | FIF Supplier Address Stg-002-ALT | ALT-FIF_SUPPLI-002 | AL | FIF Supplier Address Stg-002-ALT | FIF Supplier Address Stg-002-ALT | FIF Supplier Address Stg-002-ALT | FIF Supplier Address Stg-002-ALT | FIF Supplier Address Stg-002-ALT | ALT-FIF_SUPPLI-002 | ALT-FIF_SUPPLI-002 | 1000000003 |
| default | 1000000005 | FIF Supplier Address Stg-003-E | FIF Supplier Address Stg-003-EDGE | FIF Supplier Address Stg-003-EDGE | FIF Supplier Address Stg-003-EDGE | FIF Supplier Address Stg-003-EDGE | FIF Supplier Address Stg-003-EDGE | EDGE-FIF_SUPPLI-003 | ED | FIF Supplier Address Stg-003-EDGE | FIF Supplier Address Stg-003-EDGE | FIF Supplier Address Stg-003-EDGE | FIF Supplier Address Stg-003-EDGE | FIF Supplier Address Stg-003-EDGE | EDGE-FIF_SUPPLI-003 | EDGE-FIF_SUPPLI-003 | 1000000005 |
Example values from field definitions
- PROCESS_IDR
- 1
- SUPPLIER_NUMBERR
- SAMPLE
- CITY
- SAMPLE
- SAMPLE
- STATE
- SAMPLE
- PROVINCE
- SAMPLE
- FAX_NUMBER
- SAMPLE
- POSTAL_CODE
- SAMPLE
- COUNTRY_CODE
- SA
- PHONE_NUMBER
- SAMPLE
- ADDRESS_LINE1
- SAMPLE
- ADDRESS_LINE2
- SAMPLE
- ADDRESS_LINE3
- SAMPLE
- ADDRESS_LINE4
- SAMPLE
- FAX_AREA_CODE
- SAMPLE
- PHONE_AREA_CODE
- SAMPLE
- SUPPLIER_ADDRESS_ID
- 1
default
- PROCESS_IDR
- 1000000003
- SUPPLIER_NUMBERR
- FIF Supplier Address Stg-002-A
- CITY
- FIF Supplier Address Stg-002-ALT
- FIF Supplier Address Stg-002-ALT
- STATE
- FIF Supplier Address Stg-002-ALT
- PROVINCE
- FIF Supplier Address Stg-002-ALT
- FAX_NUMBER
- FIF Supplier Address Stg-002-ALT
- POSTAL_CODE
- ALT-FIF_SUPPLI-002
- COUNTRY_CODE
- AL
- PHONE_NUMBER
- FIF Supplier Address Stg-002-ALT
- ADDRESS_LINE1
- FIF Supplier Address Stg-002-ALT
- ADDRESS_LINE2
- FIF Supplier Address Stg-002-ALT
- ADDRESS_LINE3
- FIF Supplier Address Stg-002-ALT
- ADDRESS_LINE4
- FIF Supplier Address Stg-002-ALT
- FAX_AREA_CODE
- ALT-FIF_SUPPLI-002
- PHONE_AREA_CODE
- ALT-FIF_SUPPLI-002
- SUPPLIER_ADDRESS_ID
- 1000000003
default
- PROCESS_IDR
- 1000000005
- SUPPLIER_NUMBERR
- FIF Supplier Address Stg-003-E
- CITY
- FIF Supplier Address Stg-003-EDGE
- FIF Supplier Address Stg-003-EDGE
- STATE
- FIF Supplier Address Stg-003-EDGE
- PROVINCE
- FIF Supplier Address Stg-003-EDGE
- FAX_NUMBER
- FIF Supplier Address Stg-003-EDGE
- POSTAL_CODE
- EDGE-FIF_SUPPLI-003
- COUNTRY_CODE
- ED
- PHONE_NUMBER
- FIF Supplier Address Stg-003-EDGE
- ADDRESS_LINE1
- FIF Supplier Address Stg-003-EDGE
- ADDRESS_LINE2
- FIF Supplier Address Stg-003-EDGE
- ADDRESS_LINE3
- FIF Supplier Address Stg-003-EDGE
- ADDRESS_LINE4
- FIF Supplier Address Stg-003-EDGE
- FAX_AREA_CODE
- EDGE-FIF_SUPPLI-003
- PHONE_AREA_CODE
- EDGE-FIF_SUPPLI-003
- SUPPLIER_ADDRESS_ID
- 1000000005
Rule Validation Summary
- Source Rule Count
- 25
- Governed Rule Count
- 19