Custcreditchk (Service Layer)
In ScopeTechnical: SVC_CUSTCREDITCHK | ID: OR-CST-SVC_CUSTCREDITCHK-CUSTCREDITCHK_SERVICE_LAYER
This is an interface staging table that holds information related to franchise customer update request from the financials to RMS.
See how this object fits into Cost
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
- SVC_CUSTCREDITCHK
Field Definitions(5)
Rules & Considerations(24)
validation
constraint
Sample Load Data(4)
| _scenario | CHUNK_IDR | PROCESS_IDR | ACTION_TYPER | PROCESS_STATUSR | CUSTCREDITCHK_IDRPK | CREATE_ID | ERROR_MSG | CREDIT_IND | LAST_UPDATE_ID | WF_CUSTOMER_ID | CREATE_DATETIME | LAST_UPDATE_DATETIME | WF_CUSTOMER_GROUP_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | SAMPLE | S | 1 | SAMPLE | SAMPLE | S | SAMPLE | 1 | 2026-01-01 | 2026-01-01 | 1 |
| default | 1000000003 | 1000000003 | Svc Custcr | v | 1000000003 | MDM_USER | Svc Custcreditchk-002-ALT | N | MDM_USER | 1000000003 | 2026-01-03 | 2026-01-03 | 1000000003 |
| default | 1000000005 | 1000000005 | Svc Custcr | e | 1000000005 | BATCH_USER | Svc Custcreditchk-003-EDGE | Y | BATCH_USER | 1000000005 | 2026-01-05 | 2026-01-05 | 1000000005 |
Example values from field definitions
- CHUNK_IDR
- 1
- PROCESS_IDR
- 1
- ACTION_TYPER
- SAMPLE
- PROCESS_STATUSR
- S
- CUSTCREDITCHK_IDRPK
- 1
- CREATE_ID
- SAMPLE
- ERROR_MSG
- SAMPLE
- CREDIT_IND
- S
- LAST_UPDATE_ID
- SAMPLE
- WF_CUSTOMER_ID
- 1
- CREATE_DATETIME
- 2026-01-01
- LAST_UPDATE_DATETIME
- 2026-01-01
- WF_CUSTOMER_GROUP_ID
- 1
default
- CHUNK_IDR
- 1000000003
- PROCESS_IDR
- 1000000003
- ACTION_TYPER
- Svc Custcr
- PROCESS_STATUSR
- v
- CUSTCREDITCHK_IDRPK
- 1000000003
- CREATE_ID
- MDM_USER
- ERROR_MSG
- Svc Custcreditchk-002-ALT
- CREDIT_IND
- N
- LAST_UPDATE_ID
- MDM_USER
- WF_CUSTOMER_ID
- 1000000003
- CREATE_DATETIME
- 2026-01-03
- LAST_UPDATE_DATETIME
- 2026-01-03
- WF_CUSTOMER_GROUP_ID
- 1000000003
default
- CHUNK_IDR
- 1000000005
- PROCESS_IDR
- 1000000005
- ACTION_TYPER
- Svc Custcr
- PROCESS_STATUSR
- e
- CUSTCREDITCHK_IDRPK
- 1000000005
- CREATE_ID
- BATCH_USER
- ERROR_MSG
- Svc Custcreditchk-003-EDGE
- CREDIT_IND
- Y
- LAST_UPDATE_ID
- BATCH_USER
- WF_CUSTOMER_ID
- 1000000005
- CREATE_DATETIME
- 2026-01-05
- LAST_UPDATE_DATETIME
- 2026-01-05
- WF_CUSTOMER_GROUP_ID
- 1000000005
Rule Validation Summary
- Source Rule Count
- 34
- Governed Rule Count
- 24