Sales Invoice Line
In ScopeTechnical: sales_invoice_line | ID: D365BC-HIST-SALES_INVOICE_LINE
D365 BC migration object for Sales Invoice Line.
See how this object fits into Historical Data Analytics
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Historical Data
- Typical Sources
- ERPLegacy
Target Structure
- Load Approach
- Table
- Target Objects
- Sales Invoice Line
Field Definitions(5)
Rules & Considerations(17)
constraint
validation
Sample Load Data(4)
| _scenario | No. | Amount | Line No. | Quantity | CUTOVER_WAVE | Document No. | DEPENDENCY_LEVEL | LINE_REFERENCE_KEY | SALES_INVOICE_NAME | EFFECTIVE_FROM_DATE | LOAD_SEQUENCE_STAGE | SALES_REFERENCE_KEY | INVOICE_REFERENCE_KEY | SALES_INVOICE_SOURCE_ID | SALES_INVOICE_DESCRIPTION | SALES_INVOICE_STATUS_CODE | SALES_INVOICE_BUSINESS_KEY | SALES INVOICE LINE_REFERENCE_KEY |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | No. | 100.00 | 1 | 100.00 | Sales Invoice Line-006 | Document No. | Sales Invoice Line-007 | STD-SALES_INVO-001 | Sales Invoice Line Primary | 2026-01-13 | Historical Data | STD-SALES_INVO-001 | STD-SALES_INVO-001 | SRC-SALES_INVO-001 | Sales Invoice Line: Baseline migration row | ACTIVE | BK-SALES_INVOIC-001 | STD-SALES_INVO-001 |
| default | — | — | — | — | Sales Invoice Line-006 | — | MEDIUM-ALT | ALT-SALES_INVO-002 | Sales Invoice Line Secondary | 2026-01-14 | Historical Data | ALT-SALES_INVO-002 | ALT-SALES_INVO-002 | LEG-SALES_INVO-002 | Sales Invoice Line: Alternate source profile | PENDING | ALT-SALES_INVOIC-002 | ALT-SALES_INVO-002 |
| default | — | — | — | — | Sales Invoice Line-006 | — | Sales Invoice Line-007 | — | Sales Invoice Line Legacy | 2026-01-15 | Historical Data | — | — | EXT-SALES_INVO-003 | — | HOLD | EDGE-SALES_INVOIC-003 | — |
Example values from field definitions
- No.
- No.
- Amount
- 100.00
- Line No.
- 1
- Quantity
- 100.00
- CUTOVER_WAVE
- Sales Invoice Line-006
- Document No.
- Document No.
- DEPENDENCY_LEVEL
- Sales Invoice Line-007
- LINE_REFERENCE_KEY
- STD-SALES_INVO-001
- SALES_INVOICE_NAME
- Sales Invoice Line Primary
- EFFECTIVE_FROM_DATE
- 2026-01-13
- LOAD_SEQUENCE_STAGE
- Historical Data
- SALES_REFERENCE_KEY
- STD-SALES_INVO-001
- INVOICE_REFERENCE_KEY
- STD-SALES_INVO-001
- SALES_INVOICE_SOURCE_ID
- SRC-SALES_INVO-001
- SALES_INVOICE_DESCRIPTION
- Sales Invoice Line: Baseline migration row
- SALES_INVOICE_STATUS_CODE
- ACTIVE
- SALES_INVOICE_BUSINESS_KEY
- BK-SALES_INVOIC-001
- SALES INVOICE LINE_REFERENCE_KEY
- STD-SALES_INVO-001
default
- No.
- —
- Amount
- —
- Line No.
- —
- Quantity
- —
- CUTOVER_WAVE
- Sales Invoice Line-006
- Document No.
- —
- DEPENDENCY_LEVEL
- MEDIUM-ALT
- LINE_REFERENCE_KEY
- ALT-SALES_INVO-002
- SALES_INVOICE_NAME
- Sales Invoice Line Secondary
- EFFECTIVE_FROM_DATE
- 2026-01-14
- LOAD_SEQUENCE_STAGE
- Historical Data
- SALES_REFERENCE_KEY
- ALT-SALES_INVO-002
- INVOICE_REFERENCE_KEY
- ALT-SALES_INVO-002
- SALES_INVOICE_SOURCE_ID
- LEG-SALES_INVO-002
- SALES_INVOICE_DESCRIPTION
- Sales Invoice Line: Alternate source profile
- SALES_INVOICE_STATUS_CODE
- PENDING
- SALES_INVOICE_BUSINESS_KEY
- ALT-SALES_INVOIC-002
- SALES INVOICE LINE_REFERENCE_KEY
- ALT-SALES_INVO-002
default
- No.
- —
- Amount
- —
- Line No.
- —
- Quantity
- —
- CUTOVER_WAVE
- Sales Invoice Line-006
- Document No.
- —
- DEPENDENCY_LEVEL
- Sales Invoice Line-007
- LINE_REFERENCE_KEY
- —
- SALES_INVOICE_NAME
- Sales Invoice Line Legacy
- EFFECTIVE_FROM_DATE
- 2026-01-15
- LOAD_SEQUENCE_STAGE
- Historical Data
- SALES_REFERENCE_KEY
- —
- INVOICE_REFERENCE_KEY
- —
- SALES_INVOICE_SOURCE_ID
- EXT-SALES_INVO-003
- SALES_INVOICE_DESCRIPTION
- —
- SALES_INVOICE_STATUS_CODE
- HOLD
- SALES_INVOICE_BUSINESS_KEY
- EDGE-SALES_INVOIC-003
- SALES INVOICE LINE_REFERENCE_KEY
- —
Rule Validation Summary
- Source Rule Count
- 17
- Governed Rule Count
- 2