Open Purchase Orders
In ScopeTechnical: PurchTable | ID: D365FO-PRC-PURCHTABLE-OPEN_PURCHASE_ORDERS
See how this object fits into Vendors Procurement
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- High
- Sequencing
- Stage 3 - Open Transactions
- Typical Sources
- ERPLegacy
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- PurchTable
This object has high complexity or dependency level
Review sequencing requirements before loading
Field Definitions(5)
Rules & Considerations(51)
Sample Load Data(3)
| _scenario | PurchIdRPK | CurrencyCodeR | DocumentDateR | OrderAccountR | OrderDate | ProjectId | DataAreaId | LanguageId | IsConfirmed | PurchStatus | DeliveryDate | PurchaseType | AccountingDate | ReceivingSiteId | VendorReference | DeliveryModeCode | PaymentTermsName | PurchAgreementId | DeliveryTermsCode | FixedExchangeRate | PaymentMethodName | PurchaseOrderName | PurchaseOrderType | SalesTaxGroupCode | DeliveryAddressCity | DeliveryAddressName | PurchaseOrderNumber | PurchaseOrderPoolId | DeliveryAddressState | HeaderDiscountAmount | ReceivingWarehouseId | ConfirmedDeliveryDate | DeliveryAddressStreet | RequestedDeliveryDate | DeliveryAddressZipCode | PrimaryContactPersonId | PurchaseOrderStatusCode | HeaderDiscountPercentage | DeliveryAddressLocationId | InvoiceVendorAccountNumber | OrderingVendorAccountNumber | DefaultDimensionDisplayValue | DeliveryAddressCountryRegionId | PurchasingAgentPersonnelNumber | WorkerRequesterPersonnelNumber | IntercompanyPurchaseOrderNumber |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | PO-0000001 | USD | 2023-10-26 | VEND-00123 | 2023-10-26 | PROJ-BUILD001 | USRT | en-gb | Yes | Open order | 2023-11-15 | Purchase order | 2023-10-31 | USMF | VEND-REF-98765 | TRUCK | NET30 | PA-2023-005 | FOB | 1.15 | CHECK | Software License Renewal 2023 | Purchase order | TX_DOM | Seattle | Main Warehouse | PO-2023-000100 | POOL1 | WA | 100.00 | WARE1 | 2023-11-10 | 123 Main St | 2023-11-15 | 98101 | V_CONTACT_001 | Open order | 5.00 | WH-EAST-DOC-BAY | VEND-BILL-001 | US-001 | CostCenter-001|Department-SALES|Project-P123 | USA | 00000001 | 00000005 | IC-PO-001 |
| Variation 1 - type-safe variation anchored to example values | PO000000102 | VSD | 20231202 | VEND0012302 | 20231202 | PROJBUILD00102 | VSRT | ENGB02 | ZES | OPENORDE02 | 20231222 | PURCHASEORDE02 | 20231207 | VSMF | VENDREF9876502 | URUCK | NET31 | PA202300502 | GOB | 1102 | DHECK | SOFTWARELICENSERENEWAL202302 | PURCHASEORDE02 | TXDOM02 | TEATTLE | MAINWAREHOUSE02 | PO202300010002 | POOL1 | XA | 100002 | WARE1 | 20231217 | 123MAINST02 | 20231222 | 98101 | VCONTACT00102 | OPENORDE02 | 5002 | WHEASTDOCBAY02 | VENDBILL00102 | US00102 | COSTCENTER001DEPARTMENTSALESPROJECTP12302 | VSA | 00000001 | 00000001 | ICPO00102 |
| Variation 2 - additional in-range variation with row-level constraint alignment | PO000000103 | UUD | 20240108 | VEND0012303 | 20240108 | PROJBUILD00103 | UURT | ENGB03 | YGS | OPENORDE03 | 20240128 | PURCHASEORDE03 | 20240113 | UUMF | VENDREF9876503 | TTUCK | NET32 | PA202300503 | FQB | 1103 | CJECK | SOFTWARELICENSERENEWAL202303 | PURCHASEORDE03 | TXDOM03 | SGATTLE | MAINWAREHOUSE03 | PO202300010003 | POOL2 | WC | 100003 | WARE2 | 20240123 | 123MAINST03 | 20240128 | 98102 | VCONTACT00103 | OPENORDE03 | 5003 | WHEASTDOCBAY03 | VENDBILL00103 | US00103 | COSTCENTER001DEPARTMENTSALESPROJECTP12303 | UUA | 00000002 | 00000002 | ICPO00103 |
Example values from field definitions
- PurchIdRPK
- PO-0000001
- CurrencyCodeR
- USD
- DocumentDateR
- 2023-10-26
- OrderAccountR
- VEND-00123
- OrderDate
- 2023-10-26
- ProjectId
- PROJ-BUILD001
- DataAreaId
- USRT
- LanguageId
- en-gb
- IsConfirmed
- Yes
- PurchStatus
- Open order
- DeliveryDate
- 2023-11-15
- PurchaseType
- Purchase order
- AccountingDate
- 2023-10-31
- ReceivingSiteId
- USMF
- VendorReference
- VEND-REF-98765
- DeliveryModeCode
- TRUCK
- PaymentTermsName
- NET30
- PurchAgreementId
- PA-2023-005
- DeliveryTermsCode
- FOB
- FixedExchangeRate
- 1.15
- PaymentMethodName
- CHECK
- PurchaseOrderName
- Software License Renewal 2023
- PurchaseOrderType
- Purchase order
- SalesTaxGroupCode
- TX_DOM
- DeliveryAddressCity
- Seattle
- DeliveryAddressName
- Main Warehouse
- PurchaseOrderNumber
- PO-2023-000100
- PurchaseOrderPoolId
- POOL1
- DeliveryAddressState
- WA
- HeaderDiscountAmount
- 100.00
- ReceivingWarehouseId
- WARE1
- ConfirmedDeliveryDate
- 2023-11-10
- DeliveryAddressStreet
- 123 Main St
- RequestedDeliveryDate
- 2023-11-15
- DeliveryAddressZipCode
- 98101
- PrimaryContactPersonId
- V_CONTACT_001
- PurchaseOrderStatusCode
- Open order
- HeaderDiscountPercentage
- 5.00
- DeliveryAddressLocationId
- WH-EAST-DOC-BAY
- InvoiceVendorAccountNumber
- VEND-BILL-001
- OrderingVendorAccountNumber
- US-001
- DefaultDimensionDisplayValue
- CostCenter-001|Department-SALES|Project-P123
- DeliveryAddressCountryRegionId
- USA
- PurchasingAgentPersonnelNumber
- 00000001
- WorkerRequesterPersonnelNumber
- 00000005
- IntercompanyPurchaseOrderNumber
- IC-PO-001
Variation 1 - type-safe variation anchored to example values
- PurchIdRPK
- PO000000102
- CurrencyCodeR
- VSD
- DocumentDateR
- 20231202
- OrderAccountR
- VEND0012302
- OrderDate
- 20231202
- ProjectId
- PROJBUILD00102
- DataAreaId
- VSRT
- LanguageId
- ENGB02
- IsConfirmed
- ZES
- PurchStatus
- OPENORDE02
- DeliveryDate
- 20231222
- PurchaseType
- PURCHASEORDE02
- AccountingDate
- 20231207
- ReceivingSiteId
- VSMF
- VendorReference
- VENDREF9876502
- DeliveryModeCode
- URUCK
- PaymentTermsName
- NET31
- PurchAgreementId
- PA202300502
- DeliveryTermsCode
- GOB
- FixedExchangeRate
- 1102
- PaymentMethodName
- DHECK
- PurchaseOrderName
- SOFTWARELICENSERENEWAL202302
- PurchaseOrderType
- PURCHASEORDE02
- SalesTaxGroupCode
- TXDOM02
- DeliveryAddressCity
- TEATTLE
- DeliveryAddressName
- MAINWAREHOUSE02
- PurchaseOrderNumber
- PO202300010002
- PurchaseOrderPoolId
- POOL1
- DeliveryAddressState
- XA
- HeaderDiscountAmount
- 100002
- ReceivingWarehouseId
- WARE1
- ConfirmedDeliveryDate
- 20231217
- DeliveryAddressStreet
- 123MAINST02
- RequestedDeliveryDate
- 20231222
- DeliveryAddressZipCode
- 98101
- PrimaryContactPersonId
- VCONTACT00102
- PurchaseOrderStatusCode
- OPENORDE02
- HeaderDiscountPercentage
- 5002
- DeliveryAddressLocationId
- WHEASTDOCBAY02
- InvoiceVendorAccountNumber
- VENDBILL00102
- OrderingVendorAccountNumber
- US00102
- DefaultDimensionDisplayValue
- COSTCENTER001DEPARTMENTSALESPROJECTP12302
- DeliveryAddressCountryRegionId
- VSA
- PurchasingAgentPersonnelNumber
- 00000001
- WorkerRequesterPersonnelNumber
- 00000001
- IntercompanyPurchaseOrderNumber
- ICPO00102
Variation 2 - additional in-range variation with row-level constraint alignment
- PurchIdRPK
- PO000000103
- CurrencyCodeR
- UUD
- DocumentDateR
- 20240108
- OrderAccountR
- VEND0012303
- OrderDate
- 20240108
- ProjectId
- PROJBUILD00103
- DataAreaId
- UURT
- LanguageId
- ENGB03
- IsConfirmed
- YGS
- PurchStatus
- OPENORDE03
- DeliveryDate
- 20240128
- PurchaseType
- PURCHASEORDE03
- AccountingDate
- 20240113
- ReceivingSiteId
- UUMF
- VendorReference
- VENDREF9876503
- DeliveryModeCode
- TTUCK
- PaymentTermsName
- NET32
- PurchAgreementId
- PA202300503
- DeliveryTermsCode
- FQB
- FixedExchangeRate
- 1103
- PaymentMethodName
- CJECK
- PurchaseOrderName
- SOFTWARELICENSERENEWAL202303
- PurchaseOrderType
- PURCHASEORDE03
- SalesTaxGroupCode
- TXDOM03
- DeliveryAddressCity
- SGATTLE
- DeliveryAddressName
- MAINWAREHOUSE03
- PurchaseOrderNumber
- PO202300010003
- PurchaseOrderPoolId
- POOL2
- DeliveryAddressState
- WC
- HeaderDiscountAmount
- 100003
- ReceivingWarehouseId
- WARE2
- ConfirmedDeliveryDate
- 20240123
- DeliveryAddressStreet
- 123MAINST03
- RequestedDeliveryDate
- 20240128
- DeliveryAddressZipCode
- 98102
- PrimaryContactPersonId
- VCONTACT00103
- PurchaseOrderStatusCode
- OPENORDE03
- HeaderDiscountPercentage
- 5003
- DeliveryAddressLocationId
- WHEASTDOCBAY03
- InvoiceVendorAccountNumber
- VENDBILL00103
- OrderingVendorAccountNumber
- US00103
- DefaultDimensionDisplayValue
- COSTCENTER001DEPARTMENTSALESPROJECTP12303
- DeliveryAddressCountryRegionId
- UUA
- PurchasingAgentPersonnelNumber
- 00000002
- WorkerRequesterPersonnelNumber
- 00000002
- IntercompanyPurchaseOrderNumber
- ICPO00103
Rule Validation Summary
- Source Rule Count
- 51
- Governed Rule Count
- 51