Supplier Import Attr
In ScopeTechnical: SUP_IMPORT_ATTR | ID: OR-SUP-SUP_IMPORT_ATTR-SUPPLIER_IMPORT_ATTR
This table is used to import specific attributes associated with a supplier. This table will only be populated if Import2000 is being used.
See how this object fits into Supplier 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
- SUP_IMPORT_ATTR
Field Definitions(5)
Rules & Considerations(35)
constraint
validation
Sample Load Data(4)
| _scenario | SUPPLIERRPK | AGENT | MFG_ID | FACTORY | DRAFTS_AT | PARTNER_1 | PARTNER_2 | PARTNER_3 | LADING_PORT | LC_NEG_DAYS | RELATED_IND | ISSUING_BANK | VARIANCE_PCT | ADVISING_BANK | REVOCABLE_IND | DISCHARGE_PORT | PARTNER_TYPE_1 | PARTNER_TYPE_2 | PARTNER_TYPE_3 | BENEFICIARY_IND | PLACE_OF_EXPIRY | WITH_RECOURSE_IND | PRESENTATION_TERMS |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPL | 1 | S | SAMPLE | 1.0000 | SAMPLE | S | SAMPL | SAMPLE | SAMPLE | SAMPLE | S | SAMPLE | S | SAMPLE |
| Historical closed record for a supplier with non-active status | 2 | AGENT2 | MFGID987654321 | FACTORY2 | 02 | PARTNER4 | PARTNER5 | PARTNER6 | LPORT | 45 | N | BANKD | 0.0000 | BANKC | Y | DPORT | TYPE4 | TYPE5 | TYPE6 | N | 02 | N | A |
| Current record for a minimal-data supplier in compliance | 3 | — | MFGID123456782 | — | — | — | — | — | — | — | Y | — | — | — | N | — | TYPE1 | TYPE2 | TYPE2 | Y | — | Y | — |
Example values from field definitions
- SUPPLIERRPK
- 1
- AGENT
- SAMPLE
- MFG_ID
- SAMPLE
- FACTORY
- SAMPLE
- DRAFTS_AT
- SAMPLE
- PARTNER_1
- SAMPLE
- PARTNER_2
- SAMPLE
- PARTNER_3
- SAMPLE
- LADING_PORT
- SAMPL
- LC_NEG_DAYS
- 1
- RELATED_IND
- S
- ISSUING_BANK
- SAMPLE
- VARIANCE_PCT
- 1.0000
- ADVISING_BANK
- SAMPLE
- REVOCABLE_IND
- S
- DISCHARGE_PORT
- SAMPL
- PARTNER_TYPE_1
- SAMPLE
- PARTNER_TYPE_2
- SAMPLE
- PARTNER_TYPE_3
- SAMPLE
- BENEFICIARY_IND
- S
- PLACE_OF_EXPIRY
- SAMPLE
- WITH_RECOURSE_IND
- S
- PRESENTATION_TERMS
- SAMPLE
Historical closed record for a supplier with non-active status
- SUPPLIERRPK
- 2
- AGENT
- AGENT2
- MFG_ID
- MFGID987654321
- FACTORY
- FACTORY2
- DRAFTS_AT
- 02
- PARTNER_1
- PARTNER4
- PARTNER_2
- PARTNER5
- PARTNER_3
- PARTNER6
- LADING_PORT
- LPORT
- LC_NEG_DAYS
- 45
- RELATED_IND
- N
- ISSUING_BANK
- BANKD
- VARIANCE_PCT
- 0.0000
- ADVISING_BANK
- BANKC
- REVOCABLE_IND
- Y
- DISCHARGE_PORT
- DPORT
- PARTNER_TYPE_1
- TYPE4
- PARTNER_TYPE_2
- TYPE5
- PARTNER_TYPE_3
- TYPE6
- BENEFICIARY_IND
- N
- PLACE_OF_EXPIRY
- 02
- WITH_RECOURSE_IND
- N
- PRESENTATION_TERMS
- A
Current record for a minimal-data supplier in compliance
- SUPPLIERRPK
- 3
- AGENT
- —
- MFG_ID
- MFGID123456782
- FACTORY
- —
- DRAFTS_AT
- —
- PARTNER_1
- —
- PARTNER_2
- —
- PARTNER_3
- —
- LADING_PORT
- —
- LC_NEG_DAYS
- —
- RELATED_IND
- Y
- ISSUING_BANK
- —
- VARIANCE_PCT
- —
- ADVISING_BANK
- —
- REVOCABLE_IND
- N
- DISCHARGE_PORT
- —
- PARTNER_TYPE_1
- TYPE1
- PARTNER_TYPE_2
- TYPE2
- PARTNER_TYPE_3
- TYPE2
- BENEFICIARY_IND
- Y
- PLACE_OF_EXPIRY
- —
- WITH_RECOURSE_IND
- Y
- PRESENTATION_TERMS
- —
Rule Validation Summary
- Source Rule Count
- 51
- Governed Rule Count
- 35