Posupld Cons Helper (Service Layer GTT)
Out of ScopeTechnical: SVC_POSUPLD_CONS_HELPER_GTT | ID: OR-FND-SVC_POSUPLD_CONS_HELPER_GTT-SVC_POSUPLD_CONS_HELPER_GTT
Consignment working table. Holds lookup data needed to process a consignment sale.
See how this object fits into Foundation Data
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 2
- Typical Sources
- ERPLegacy
Classification
- Object Type
- gtt
Target Structure
- Load Approach
- Table
- Target Objects
- SVC_POSUPLD_CONS_HELPER_GTT
Field Definitions(5)
Rules & Considerations(43)
validation
constraint
Sample Load Data(4)
| _scenario | SALES_THEAD_IDR | SALES_PROCESS_IDR | POSUPLD_LINE_ITEM_IDR | POSUPLD_CONSIGNMENT_HELPER_IDR | IM_DEPT | IM_ITEM | INVC_ID | CHUNK_ID | EOM_DATE | EOW_DATE | IM_CLASS | ORDER_NO | LOC_VALUE | TRAN_TYPE | SALES_SIGN | SUPS_TERMS | IM_PACK_IND | IM_SUBCLASS | IS_SUPPLIER | VI_VAT_CODE | VI_VAT_RATE | PO_INVC_DATE | RTV_ORDER_NO | TERMS_DUEDAYS | TERMS_PERCENT | CONSIGNMENT_RATE | EXISTING_RTV_IND | SUPS_RET_COURIER | EXISTING_INVC_IND | SUPS_HANDLING_PCT | TOTAL_AV_COST_LOC | TOTAL_WASTAGE_QTY | EXISTING_ORDER_IND | SUPS_CURRENCY_CODE | SUPS_RET_ALLOW_IND | IS_CONSIGNMENT_RATE | TOTAL_UNIT_COST_LOC | CONSIGNMENT_UNIT_COST | SALES_VALUE_WITHOUT_VAT | SUPS_AUTO_APPR_INVC_IND | SUPS_EDI_SALES_RPT_FREQ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | 1 | 1 | SAMPLE | 1 | 1 | 2026-01-01 | 2026-01-01 | 1 | 1 | 1 | S | 1 | SAMPLE | S | 1 | 1 | SAMPLE | 1.0000000000 | 2026-01-01 | 1 | 1 | 1.0000 | 1.0000 | S | SAMPLE | S | 1.0000 | 1.000000 | 1.0000 | S | SAM | S | 1.0000 | 1.000000 | 1.0000 | 1.0000 | S | S |
| default | 1000000003 | 1000000003 | 1000000003 | 1000000003 | 1003 | Svc Posupld Cons Helper G | 1000000003 | 1000000003 | 2026-01-03 | 2026-01-03 | 1103 | 4 | 3 | S | 3 | Svc Posupld Con | S | 1113 | 3 | ALT-SV | 12.5000000000 | 2026-01-03 | 4 | 3 | 12.5000 | 12.5000 | S | Svc Posupld Cons Helper Gtt-002-ALT | S | 12.5000 | 12.500000 | 12.5000 | S | ALT | S | 12.5000 | 12.500000 | 12.5000 | 12.5000 | S | D |
| default | 1000000005 | 1000000005 | 1000000005 | 1000000005 | 1005 | Svc Posupld Cons Helper G | 1000000005 | 1000000005 | 2026-01-05 | 2026-01-05 | 1105 | 6 | 5 | S | 5 | Svc Posupld Con | S | 1115 | 5 | EDGE-S | 14.0000000000 | 2026-01-05 | 6 | 5 | 14.0000 | 14.0000 | S | Svc Posupld Cons Helper Gtt-003-EDGE | S | 14.0000 | 14.000000 | 14.0000 | S | EDG | S | 14.0000 | 14.000000 | 14.0000 | 14.0000 | S | D |
Example values from field definitions
- SALES_THEAD_IDR
- 1
- SALES_PROCESS_IDR
- 1
- POSUPLD_LINE_ITEM_IDR
- 1
- POSUPLD_CONSIGNMENT_HELPER_IDR
- 1
- IM_DEPT
- 1
- IM_ITEM
- SAMPLE
- INVC_ID
- 1
- CHUNK_ID
- 1
- EOM_DATE
- 2026-01-01
- EOW_DATE
- 2026-01-01
- IM_CLASS
- 1
- ORDER_NO
- 1
- LOC_VALUE
- 1
- TRAN_TYPE
- S
- SALES_SIGN
- 1
- SUPS_TERMS
- SAMPLE
- IM_PACK_IND
- S
- IM_SUBCLASS
- 1
- IS_SUPPLIER
- 1
- VI_VAT_CODE
- SAMPLE
- VI_VAT_RATE
- 1.0000000000
- PO_INVC_DATE
- 2026-01-01
- RTV_ORDER_NO
- 1
- TERMS_DUEDAYS
- 1
- TERMS_PERCENT
- 1.0000
- CONSIGNMENT_RATE
- 1.0000
- EXISTING_RTV_IND
- S
- SUPS_RET_COURIER
- SAMPLE
- EXISTING_INVC_IND
- S
- SUPS_HANDLING_PCT
- 1.0000
- TOTAL_AV_COST_LOC
- 1.000000
- TOTAL_WASTAGE_QTY
- 1.0000
- EXISTING_ORDER_IND
- S
- SUPS_CURRENCY_CODE
- SAM
- SUPS_RET_ALLOW_IND
- S
- IS_CONSIGNMENT_RATE
- 1.0000
- TOTAL_UNIT_COST_LOC
- 1.000000
- CONSIGNMENT_UNIT_COST
- 1.0000
- SALES_VALUE_WITHOUT_VAT
- 1.0000
- SUPS_AUTO_APPR_INVC_IND
- S
- SUPS_EDI_SALES_RPT_FREQ
- S
default
- SALES_THEAD_IDR
- 1000000003
- SALES_PROCESS_IDR
- 1000000003
- POSUPLD_LINE_ITEM_IDR
- 1000000003
- POSUPLD_CONSIGNMENT_HELPER_IDR
- 1000000003
- IM_DEPT
- 1003
- IM_ITEM
- Svc Posupld Cons Helper G
- INVC_ID
- 1000000003
- CHUNK_ID
- 1000000003
- EOM_DATE
- 2026-01-03
- EOW_DATE
- 2026-01-03
- IM_CLASS
- 1103
- ORDER_NO
- 4
- LOC_VALUE
- 3
- TRAN_TYPE
- S
- SALES_SIGN
- 3
- SUPS_TERMS
- Svc Posupld Con
- IM_PACK_IND
- S
- IM_SUBCLASS
- 1113
- IS_SUPPLIER
- 3
- VI_VAT_CODE
- ALT-SV
- VI_VAT_RATE
- 12.5000000000
- PO_INVC_DATE
- 2026-01-03
- RTV_ORDER_NO
- 4
- TERMS_DUEDAYS
- 3
- TERMS_PERCENT
- 12.5000
- CONSIGNMENT_RATE
- 12.5000
- EXISTING_RTV_IND
- S
- SUPS_RET_COURIER
- Svc Posupld Cons Helper Gtt-002-ALT
- EXISTING_INVC_IND
- S
- SUPS_HANDLING_PCT
- 12.5000
- TOTAL_AV_COST_LOC
- 12.500000
- TOTAL_WASTAGE_QTY
- 12.5000
- EXISTING_ORDER_IND
- S
- SUPS_CURRENCY_CODE
- ALT
- SUPS_RET_ALLOW_IND
- S
- IS_CONSIGNMENT_RATE
- 12.5000
- TOTAL_UNIT_COST_LOC
- 12.500000
- CONSIGNMENT_UNIT_COST
- 12.5000
- SALES_VALUE_WITHOUT_VAT
- 12.5000
- SUPS_AUTO_APPR_INVC_IND
- S
- SUPS_EDI_SALES_RPT_FREQ
- D
default
- SALES_THEAD_IDR
- 1000000005
- SALES_PROCESS_IDR
- 1000000005
- POSUPLD_LINE_ITEM_IDR
- 1000000005
- POSUPLD_CONSIGNMENT_HELPER_IDR
- 1000000005
- IM_DEPT
- 1005
- IM_ITEM
- Svc Posupld Cons Helper G
- INVC_ID
- 1000000005
- CHUNK_ID
- 1000000005
- EOM_DATE
- 2026-01-05
- EOW_DATE
- 2026-01-05
- IM_CLASS
- 1105
- ORDER_NO
- 6
- LOC_VALUE
- 5
- TRAN_TYPE
- S
- SALES_SIGN
- 5
- SUPS_TERMS
- Svc Posupld Con
- IM_PACK_IND
- S
- IM_SUBCLASS
- 1115
- IS_SUPPLIER
- 5
- VI_VAT_CODE
- EDGE-S
- VI_VAT_RATE
- 14.0000000000
- PO_INVC_DATE
- 2026-01-05
- RTV_ORDER_NO
- 6
- TERMS_DUEDAYS
- 5
- TERMS_PERCENT
- 14.0000
- CONSIGNMENT_RATE
- 14.0000
- EXISTING_RTV_IND
- S
- SUPS_RET_COURIER
- Svc Posupld Cons Helper Gtt-003-EDGE
- EXISTING_INVC_IND
- S
- SUPS_HANDLING_PCT
- 14.0000
- TOTAL_AV_COST_LOC
- 14.000000
- TOTAL_WASTAGE_QTY
- 14.0000
- EXISTING_ORDER_IND
- S
- SUPS_CURRENCY_CODE
- EDG
- SUPS_RET_ALLOW_IND
- S
- IS_CONSIGNMENT_RATE
- 14.0000
- TOTAL_UNIT_COST_LOC
- 14.000000
- CONSIGNMENT_UNIT_COST
- 14.0000
- SALES_VALUE_WITHOUT_VAT
- 14.0000
- SUPS_AUTO_APPR_INVC_IND
- S
- SUPS_EDI_SALES_RPT_FREQ
- D
Rule Validation Summary
- Source Rule Count
- 47
- Governed Rule Count
- 43