Ordcust
In ScopeTechnical: ORDCUST | ID: OR-PUR-ORDCUST-ORDCUST
Stores the customer order information associated to with a Customer Order fulfilled through a purchase order or a transfer or inventory reservation at a store.
See how this object fits into Purchasing
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
- ORDCUST
Field Definitions(57)
Rules & Considerations(69)
Sample Load Data(4)
| _scenario | STATUSR | TSF_NORPK | ORDER_NORPK | CREATE_IDR | ORDCUST_NORPK | FULFILL_LOC_IDR | LAST_UPDATE_IDR | CREATE_DATETIMER | FULFILL_LOC_TYPER | FULFILL_ORDER_NOR | CUSTOMER_ORDER_NOR | LAST_UPDATE_DATETIMER | PARTIAL_DELIVERY_INDR | COMMENTS | BILL_ADD1 | BILL_ADD2 | BILL_ADD3 | BILL_CITY | BILL_POST | BILL_PHONE | BILL_STATE | BILL_COUNTY | CUSTOMER_NO | CARRIER_CODE | DELIVER_ADD1 | DELIVER_ADD2 | DELIVER_ADD3 | DELIVER_CITY | DELIVER_POST | DELIVERY_TYPE | DELIVER_PHONE | DELIVER_STATE | SOURCE_LOC_ID | BILL_LAST_NAME | DELIVER_CHARGE | DELIVER_COUNTY | BILL_COUNTRY_ID | BILL_FIRST_NAME | SOURCE_LOC_TYPE | BILL_COMPANY_NAME | BILL_JURISDICTION | DELIVER_LAST_NAME | BILL_PHONETIC_LAST | DELIVER_COUNTRY_ID | DELIVER_FIRST_NAME | ORDER_PLACED_STORE | BILL_PHONETIC_FIRST | BILL_PREFERRED_NAME | DELIVER_CHARGE_CURR | CARRIER_SERVICE_CODE | DELIVER_COMPANY_NAME | DELIVER_JURISDICTION | DELIVER_PHONETIC_LAST | CONSUMER_DELIVERY_DATE | CONSUMER_DELIVERY_TIME | DELIVER_PHONETIC_FIRST | DELIVER_PREFERRED_NAME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | S | 1 | 1 | SAMPLE | 1 | 1 | SAMPLE | 2026-01-01 | S | SAMPLE | SAMPLE | 2026-01-01 | S | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAM | SAMPLE | SAMPLE | SAMP | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | S | SAMPLE | SAM | 1 | SAMPLE | 1.0000 | SAMPLE | SAM | SAMPLE | SA | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAM | SAMPLE | 1 | SAMPLE | SAMPLE | SAM | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 2026-01-01 | 2026-01-01 | SAMPLE | SAMPLE |
Example values from field definitions
- STATUSR
- S
- TSF_NORPK
- 1
- ORDER_NORPK
- 1
- CREATE_IDR
- SAMPLE
- ORDCUST_NORPK
- 1
- FULFILL_LOC_IDR
- 1
- LAST_UPDATE_IDR
- SAMPLE
- CREATE_DATETIMER
- 2026-01-01
- FULFILL_LOC_TYPER
- S
- FULFILL_ORDER_NOR
- SAMPLE
- CUSTOMER_ORDER_NOR
- SAMPLE
- LAST_UPDATE_DATETIMER
- 2026-01-01
- PARTIAL_DELIVERY_INDR
- S
- COMMENTS
- SAMPLE
- BILL_ADD1
- SAMPLE
- BILL_ADD2
- SAMPLE
- BILL_ADD3
- SAMPLE
- BILL_CITY
- SAMPLE
- BILL_POST
- SAMPLE
- BILL_PHONE
- SAMPLE
- BILL_STATE
- SAM
- BILL_COUNTY
- SAMPLE
- CUSTOMER_NO
- SAMPLE
- CARRIER_CODE
- SAMP
- DELIVER_ADD1
- SAMPLE
- DELIVER_ADD2
- SAMPLE
- DELIVER_ADD3
- SAMPLE
- DELIVER_CITY
- SAMPLE
- DELIVER_POST
- SAMPLE
- DELIVERY_TYPE
- S
- DELIVER_PHONE
- SAMPLE
- DELIVER_STATE
- SAM
- SOURCE_LOC_ID
- 1
- BILL_LAST_NAME
- SAMPLE
- DELIVER_CHARGE
- 1.0000
- DELIVER_COUNTY
- SAMPLE
- BILL_COUNTRY_ID
- SAM
- BILL_FIRST_NAME
- SAMPLE
- SOURCE_LOC_TYPE
- SA
- BILL_COMPANY_NAME
- SAMPLE
- BILL_JURISDICTION
- SAMPLE
- DELIVER_LAST_NAME
- SAMPLE
- BILL_PHONETIC_LAST
- SAMPLE
- DELIVER_COUNTRY_ID
- SAM
- DELIVER_FIRST_NAME
- SAMPLE
- ORDER_PLACED_STORE
- 1
- BILL_PHONETIC_FIRST
- SAMPLE
- BILL_PREFERRED_NAME
- SAMPLE
- DELIVER_CHARGE_CURR
- SAM
- CARRIER_SERVICE_CODE
- SAMPLE
- DELIVER_COMPANY_NAME
- SAMPLE
- DELIVER_JURISDICTION
- SAMPLE
- DELIVER_PHONETIC_LAST
- SAMPLE
- CONSUMER_DELIVERY_DATE
- 2026-01-01
- CONSUMER_DELIVERY_TIME
- 2026-01-01
- DELIVER_PHONETIC_FIRST
- SAMPLE
- DELIVER_PREFERRED_NAME
- SAMPLE
Rule Validation Summary
- Source Rule Count
- 89
- Governed Rule Count
- 69