# Business Logic - JBSbatKKEoTVChgeFix.insertKktkSvcKeiKojiCl() [688 LOC]

| Field | Value |
|-------|-------|
| Fully Qualified Name | `eo.business.service.JBSbatKKEoTVChgeFix` |
| Layer | Service (Batch) |
| Module | `service` (Package: `eo.business.service`) |

## 1. Role

### JBSbatKKEoTVChgeFix.insertKktkSvcKeiKojiCl()

This method performs the **equipment-provided service contract registration process triggered by a construction cancellation workflow** (機器提供サービス契約登録処理（工事取消ワーク起因）). It is invoked as part of a batch process that handles service contract data changes arising from customer construction cancellation scenarios - specifically, situations where service installation work is canceled, modified, or has equipment replaced. The method implements a **conditional routing/dispatch pattern** based on the `flg` parameter, which determines whether the scenario involves post-replacement processing or STB (Set-Top Box) addition. For both branches, it reads existing service contract data from the current database snapshot, transforms it according to the specific business rules of the scenario, and then registers the transformed record into the `T_KKTK_SVC_KEI` table via the `executeKK_T_KKTK_SVC_KEI_PKINSERT` method. Its role in the larger system is as a **data transformation and persistence entry point** - it is not called by screens directly but only from internal batch processing methods within `JBSbatKKEoTVChgeFix` (specifically `createKktkSvcKeiAddInfoKjCl`), which orchestrate the broader construction cancellation workflow.

The method supports three scenario types (though only two branches are currently implemented in the code):

- **flg = "0" (KOUKAN_AF)**: Post-replacement processing - handles cases where equipment has been replaced and the contract needs re-registration with modified dates (reservation cancellation set to operational date, reservation application code set to "3:Reservation Cancellation").
- **flg = "2" (STB_ADD_KKTK)**: STB addition - handles cases where a Set-Top Box is being added, setting contract status to "910:Cancelled", service cancellation reason to "03:Construction-Initiated Cancellation", and clearing the recovery date.
- **flg = "3" (STB_PARTIAL_REMOVE)**: Partial STB removal - documented in Javadoc but no explicit code branch is implemented in this method for flg=3; this scenario would need to be added to the if/else chain.

## 2. Processing Pattern (Detailed Business Logic)

```mermaid
flowchart TD
    START(["insertKktkSvcKeiKojiCl"])
    STEP_SYS["取得システム日時 sysDate"]
    STEP_VARS["処理用変数宣言"]
    STEP_KAIHK["復旧年月日 kaihkYmd 取得"]
    COND_FLG{flg == "0"}
    BRANCH_KOUKAN["機器提供サービス契約登録処理 (交換後)"]
    STEP_RSV["予約適用関連データ取得"]
    STEP_OPE["予約取消年月日 設置日"]
    STEP_APLY["予約適用コード 3:予約取消"]
    STEP_PLAN["プラン関連データ取得"]
    STEP_SVC["サービス関連データ取得"]
    STEP_IDO["異動区分/申込明細番号取得"]
    COND_STB{flg == "2"}
    BRANCH_STB["機器提供サービス契約登録処理 (STB追加)"]
    STEP_STAT["契約ステータス 910:解除済"]
    STEP_RSV2["予約取消適用データ取得"]
    STEP_SVCDSL["サービス解約日 設置日"]
    STEP_DLRE["サービス解約理由コード 03:工事起因"]
    STEP_CLEAR["kaihkYmd 空文字でクリア"]
    STEP_ARRAY["Object[] setParam 168要素"]
    STEP_F0["setParam[0] KKTK_SVC_KEI_NO"]
    STEP_F1["setParam[1] sysDate"]
    STEP_F2["setParam[2] kktkSvcKeiStat"]
    STEP_F3_F144["setParam[3-144] DB項目取得"]
    STEP_F98_F100["setParam[98-100] rsvAplyYmd, rsvClYmd, rsvAplyCd"]
    STEP_AUDIT["監査フィールド設定"]
    STEP_INVALID["無効フラグ 0:有効"]
    STEP_CLEAROPS["削除フィールド空文字"]
    STEP_CLEAROPS2["运算フィールド空文字"]
    END_EXEC["executeKK_T_KKTK_SVC_KEI_PKINSERT"]
    END_NODE(["Return"])

    START --> STEP_SYS
    STEP_SYS --> STEP_VARS
    STEP_VARS --> STEP_KAIHK
    STEP_KAIHK --> COND_FLG
    COND_FLG -->|flg 0 (交換後)| BRANCH_KOUKAN
    COND_FLG -->|flg 2 (STB追加)| BRANCH_STB
    BRANCH_KOUKAN --> STEP_RSV
    STEP_RSV --> STEP_OPE
    STEP_OPE --> STEP_APLY
    STEP_APLY --> STEP_PLAN
    STEP_PLAN --> STEP_SVC
    STEP_SVC --> STEP_IDO
    STEP_IDO --> COND_STB
    COND_STB -->|flg 2| BRANCH_STB
    COND_STB -->|default (他)| BRANCH_STB
    BRANCH_STB --> STEP_STAT
    STEP_STAT --> STEP_RSV2
    STEP_RSV2 --> STEP_SVCDSL
    STEP_SVCDSL --> STEP_DLRE
    STEP_DLRE --> STEP_CLEAR
    STEP_CLEAR --> STEP_ARRAY
    BRANCH_KOUKAN --> STEP_ARRAY
    STEP_ARRAY --> STEP_F0
    STEP_F0 --> STEP_F1
    STEP_F1 --> STEP_F2
    STEP_F2 --> STEP_F3_F144
    STEP_F3_F144 --> STEP_F98_F100
    STEP_F98_F100 --> STEP_AUDIT
    STEP_AUDIT --> STEP_INVALID
    STEP_INVALID --> STEP_CLEAROPS
    STEP_CLEAROPS --> STEP_CLEAROPS2
    STEP_CLEAROPS2 --> END_EXEC
    END_EXEC --> END_NODE
```

**Branch Logic Summary:**

| Branch | Condition | Constant Value | Business Meaning | Key Transformations |
|--------|-----------|----------------|------------------|-------------------|
| 1 | `KOUKAN_AF.equals(flg)` | `KOUKAN_AF = "0"` | Post-replacement (交換後) | kktkSvcKeiStat kept from DB, rsvClYmd=opeDate, rsvAplyCd="3", all date fields from DB |
| 2 | `STB_ADD_KKTK.equals(flg)` | `STB_ADD_KKTK = "2"` | STB Addition (STB追加) | kktkSvcKeiStat="910", svcDslYmd=opeDate, svcDlreCd="03", kaihkYmd cleared |
| default | else | N/A | Partial STB removal (STB一部撤去) | No explicit branch - documented but not implemented |

## 3. Parameter Analysis

| No | Parameter Name | Type | Business Description |
|----|---------------|------|---------------------|
| 1 | `dbInfo` | `JBSbatCommonDBInterface` | Equipment-provided service contract current data snapshot. Contains all fields of T_KKTK_SVC_KEI needed for data extraction. |
| 2 | `kojiakJssiYmd` | `String` | Construction case execution date (工事案件実施年月日) - the operational date used to set reservation cancellation date and service cancellation date |
| 3 | `flg` | `String` | Flag indicating the type of service change. Values: "0"=Post-replacement (交換後), "2"=STB Addition (STB追加). "3" (Partial STB removal) is documented but not implemented. |
| 4 | `strIdoDiv` | `String` | Movement division code (異動区分) - extracted from DB and passed through to setParam[139] |
| 5 | `strMskmDtlNo` | `String` | Application detail number (申込明細番号) - extracted from DB and passed through to setParam[30] |

**Instance fields read:**

| Field | Type | Description |
|-------|------|-------------|
| `this.opeDate` | `String` | Operation date (運用日) - used as the operational date for setting rsvClYmd (reservation cancellation date) and svcDslYmd (service cancellation date) |
| `batchUserId` | `String` | Batch operation user ID - used as the registration/update operator account |

## 4. CRUD Operations / Called Services

The method reads ~150+ fields from the current database record (`T_KKTK_SVC_KEI`) and writes all 168 fields of the transformed record back to the same table. Below are the key CRUD operations:

| CRUD | SC / CBS | SC Code | Entity / DB | Operation Description |
|------|----------|---------|-------------|----------------------|
| R | `dbInfo.getString(KAIHK_YMD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads recovery date (復旧年月日) - cleared for STB addition |
| R | `dbInfo.getString(KKTK_SVC_KEI_STAT)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads current service contract status |
| R | `dbInfo.getString(RSV_APLY_YMD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads reservation application date |
| R | `dbInfo.getString(RSV_CL_YMD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads reservation cancellation date |
| R | `dbInfo.getString(RSV_APLY_CD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads reservation application code |
| R | `dbInfo.getString(PLAN_STAYMD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads plan start date |
| R | `dbInfo.getString(PLAN_ENDYMD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads plan end date |
| R | `dbInfo.getString(PLAN_CHRG_STAYMD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads plan charge start date |
| R | `dbInfo.getString(PLAN_CHRG_ENDYMD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads plan charge end date |
| R | `dbInfo.getString(SVC_STA_YMD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads service start date |
| R | `dbInfo.getString(SVC_CHRG_STAYMD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads service charge start date |
| R | `dbInfo.getString(SVC_ENDYMD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads service end date |
| R | `dbInfo.getString(SVC_DSL_YMD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads service cancellation date |
| R | `dbInfo.getString(IDO_DIV)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads movement division code |
| R | `dbInfo.getString(MSKM_DTL_NO)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads application detail number |
| R | `dbInfo.getString(SVC_DLRE_CD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads service cancellation reason code |
| R | `dbInfo.getString(KKTK_SVC_KEI_NO)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads service contract number |
| R | `dbInfo.getString(KKTK_SVC_CD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads service code |
| R | `dbInfo.getString(PCRS_CD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads price course code |
| R | `dbInfo.getString(PPLAN_CD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads price plan code |
| R | `dbInfo.getString(TK_HOSHIKI_KEI_NO)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads provider contract number |
| R | `dbInfo.getString(KKTK_SBT_CD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads equipment subtype code |
| R | `dbInfo.getString(HAMBAI_SBT_CD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads sales subtype code |
| R | `dbInfo.getString(SVC_USE_STA_KIBO_YMD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads service start desire date |
| R | `dbInfo.getString(RSV_TSTA_KIBO_YMD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads reservation start desire date |
| R | `dbInfo.getString(SVC_KEI_NO)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads service contract number |
| R | `dbInfo.getString(SVC_KEI_UCWK_NO)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads service contract detail number |
| R | `dbInfo.getString(SVC_KEI_KAISEN_UCWK_NO)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads service contract line detail number |
| R | `dbInfo.getString(OP_SVC_KEI_NO)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads option service contract number |
| R | `dbInfo.getString(SYSID)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads SYSID |
| R | `dbInfo.getString(LINK_STB_FLG)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads link STB flag |
| R | `dbInfo.getString(OYA_KEI_SKBT_CD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads parent contract identification code |
| R | `dbInfo.getString(KIKI_CHG_YMD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads equipment change date |
| R | `dbInfo.getString(PLAN_END_SBT_CD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads plan end subtype code |
| R | `dbInfo.getString(SVC_CANCEL_YMD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads service cancellation date |
| R | `dbInfo.getString(SVC_CANCEL_RSN_CD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads service cancellation reason code |
| R | `dbInfo.getString(SVC_STA_KISAN_YMD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads service start billing date |
| R | `dbInfo.getString(SVC_STP_YMD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads service suspension date |
| R | `dbInfo.getString(SVC_STP_RSN_CD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads service suspension reason code |
| R | `dbInfo.getString(SVC_STP_RLS_YMD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads service suspension release date |
| R | `dbInfo.getString(PAUSE_STP_CD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads pause suspension code |
| R | `dbInfo.getString(SVC_PAUSE_YMD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads service pause date |
| R | `dbInfo.getString(SVC_PAUSE_RSN_CD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads service pause reason code |
| R | `dbInfo.getString(SVC_PAUSE_RSN_MEMO)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads service pause reason memo |
| R | `dbInfo.getString(SVC_PAUSE_RLS_YMD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads service pause release date |
| R | `dbInfo.getString(SVC_PAUSE_RLS_RSN_CD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads service pause release reason code |
| R | `dbInfo.getString(SVC_PAUSE_RLS_RSN_MEMO)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads service pause release reason memo |
| R | `dbInfo.getString(SVC_DLRE_MEMO)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads service cancellation reason memo |
| R | `dbInfo.getString(ZANCHI_FLG)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads remaining balance flag |
| R | `dbInfo.getString(SVC_DSL_TTDKI_FIN_FLG)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads service cancellation procedure completion flag |
| R | `dbInfo.getString(SVC_CANCEL_CL_YMD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads service cancellation withdrawal date |
| R | `dbInfo.getString(SVC_DSL_CL_YMD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads service cancellation withdrawal date |
| R | `dbInfo.getString(SKEKKA_SEND_CD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads review result transmission code |
| R | `dbInfo.getString(SVC_PAUSE_CHRG_STA_YMD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads service pause charge start date |
| R | `dbInfo.getString(PNLTY_HASSEI_CD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads penalty occurrence code |
| R | `dbInfo.getString(KIKI_NINSHO_ID)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads equipment authentication ID |
| R | `dbInfo.getString(KIKI_NINSHO_ID_PWD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads equipment authentication ID password |
| R | `dbInfo.getString(EO_TV_KKST_SNN_STAT_CD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads eoTV equipment installation acceptance status |
| R | `dbInfo.getString(KKST_SNN_YMD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads equipment installation acceptance date |
| R | `dbInfo.getString(TAKNKIKI_IDO_CD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads in-home equipment movement code |
| R | `dbInfo.getString(CAS_CARD_USE_KYODAK_YMD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads CAS card usage authorization date |
| R | `dbInfo.getString(KIKI_HUKA_INFO_CD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads equipment additional info code |
| R | `dbInfo.getString(SHOSA_DSL_FIN_CD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads review cancellation completion code |
| R | `dbInfo.getString(ROUTER_DSL_RSV_TRN_STAT_CD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads router cancellation reservation processing status |
| R | `dbInfo.getString(ROUTER_DSL_RSV_TRN_RSLT_CD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads router cancellation reservation processing result |
| R | `dbInfo.getString(HAISO_WAY_CD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads delivery method code |
| R | `dbInfo.getString(KIKI_ITENS_MV_JSSIS_SKCD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads equipment transfer destination carrier ID |
| R | `dbInfo.getString(KAISHU_KIKI_UM)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads return equipment flag |
| R | `dbInfo.getString(HAISO_REQ_SHITEI_YMD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads delivery request designation date |
| R | `dbInfo.getString(SHKA_FIN_JI_SYRZM_FLG)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads shipment completion processing flag |
| R | `dbInfo.getString(SVC_STA_JI_HIS_JOKYO_SKCD)` | T_KKTK_SVC_KEI | T_KKTK_SVC_KEI | Reads service start status identification |
| C | `executeKK_T_KKTK_SVC_KEI_PKINSERT(setParam)` | KK domain | T_KKTK_SVC_KEI | Inserts/updates the full 168-field service contract record |
| - | `JBSbatStringUtil.Rtrim` | - | - | Trims whitespace from all DB string values |
| - | `JBSbatDateUtil.getSystemDateTimeStamp` | - | - | Gets system date/time for audit fields |

### setParam Array Field Summary (168 elements)

The method populates a 168-element `Object[]` array with fields for the `T_KKTK_SVC_KEI` table insert:

| Index Range | Field Category | Key Fields |
|-------------|---------------|------------|
| 0-2 | Contract identity | KKTK_SVC_KEI_NO, REGIST_DATETIMESTAMP, KKTK_SVC_KEI_STAT |
| 3-8 | Service codes | KKTK_SVC_CD, PCRSCD, PPLANCODE, TK_HOSHIKI_KEI_NO, KKTK_SBT_CD, HAMBAI_SBT_CD |
| 9-16 | Service/Reservation dates and equipment | SVC_USE_STA_KIBO_YMD, RSV_TSTA_KIBO_YMD, KIBO_MAKER_CD, KIKI_SHITEI_SBT_CD, TAKNKIKI_SBT_CD, TAKNKIKI_MODEL_CD, KIKI_SEIZO_NO, FUZOKUHIN_SBT_CD |
| 17-28 | Additional equipment and service contract info | FUZOKUHIN_MODEL_CD, TAKNKIKI_SETHIN_MODEL_CD, KIKI_CHG_NO, KIKI_CHG_RSN_CD, TSUSHIN_KIKI_SET_CD, HDD_CAPA_CD, KIKI_STC_SAKI_PLACE_NO, OYA_KEI_SKBT_CD, SVC_KEI_NO, SVC_KEI_UCWK_NO, SVC_KEI_KAISEN_UCWK_NO, OP_SVC_KEI_NO |
| 29-40 | SYSID, mskmDtlNo, linkSTB_FLG, warehouse codes, installation codes, occurrence date, shipping flag |
| 41-54 | Shipping destination info (name, kana, address code, postal, prefecture, city, town, district, block, building, room, manual input flag, phone) |
| 55-60 | Mansion property number, contract address mismatch flag, individual designation flag, supplementary codes 1/2, memo |
| 61-75 | Installation destination info (name, kana, address code, postal, prefecture, city, town, district, block, building, room, contract address mismatch, phone, area sorting flag, address undetermined flag) |
| 76-81 | Auto registration code, address undetermined release date, charge start date correction, installation supplementary codes 1/2, memo |
| 82-97 | Post-work request date, review date/cancellation, delivery division/deadline/arrival, trial dates, full entry dates, contract conclusion, JCCC document, guarantee code, remark, guarantee start/end |
| 98-100 | rsvAplyYmd, rsvClYmd, rsvAplyCd (branch-dependent values) |
| 101-129 | Equipment change date, plan dates/charge dates/end subtype, service cancellation dates/reason, service start billing/start/charge start/suspension/unusable subtype/suspension reason/suspension release dates/codes, pause suspension/start/reason dates/codes/memo/release dates/codes/memo, service end/charge end/cancellation dates/reason/memo, remaining balance flag, cancellation procedure completion flag |
| 130-144 | Recovery date (KAIHK_YMD, branch-dependent), service cancellation withdrawal dates, review transmission code, pause charge start date, penalty code, equipment auth ID/password, installation actual receipt date, eoTV acceptance status, installation acceptance date, in-home equipment movement code, CAS card authorization date, equipment additional info |
| 145-160 | Review cancellation completion, router cancellation status/result, delivery method, transfer destination carrier, return equipment flag, delivery request date, shipment completion flag, service start status, reg datetime, batch userId, upd datetime, upd userId, dele datetime (empty), dele userId (empty) |
| 161-167 | MK_FLG (invalid flag), regist/upd/dele operation dates and IDs (all empty) |

## 5. Dependency Trace

### Direct callers:

| # | Caller (Screen/Batch) | Call Chain (Full Path to this Method) | Terminal (SC / CRUD / Entity) |
|---|----------------------|--------------------------------------|-------------------------------|
| 1 | Batch: `JBSbatKKEoTVChgeFix.createKktkSvcKeiAddInfoKjCl()` | `createKktkSvcKeiAddInfoKjCl` -> `insertKktkSvcKeiKojiCl(dbInfo, kojiakJssiYmd, STB_ADD_KKTK, "", "")` | `executeKK_T_KKTK_SVC_KEI_PKINSERT [C] T_KKTK_SVC_KEI` |

### Method Call Chain:

```
createKktkSvcKeiAddInfoKjCl()  [Batch - constructs STB addition scenario]
    -> insertKktkSvcKeiKojiCl(dbInfo, kojiakJssiYmd, "2", "", "")  [flg="2" STB_ADD_KKTK]
        -> dbInfo.getString(...) x 150+  [R: T_KKTK_SVC_KEI]
        -> executeKK_T_KKTK_SVC_KEI_PKINSERT(setParam)  [C: T_KKTK_SVC_KEI]
```

### Terminal operations from this method:

| # | Terminal | CRUD | Entity/DB |
|---|----------|------|-----------|
| 1 | `executeKK_T_KKTK_SVC_KEI_PKINSERT` | C | T_KKTK_SVC_KEI |
| 2 | `dbInfo.getString(...)` (150+ fields) | R | T_KKTK_SVC_KEI |
| 3 | `JBSbatStringUtil.Rtrim(...)` | - | - |
| 4 | `JBSbatDateUtil.getSystemDateTimeStamp()` | R | - |
| 5 | `JBSbatKKConst.CD00056_KKTK_SVC_KEI_STAT_910` | - | - |
| 6 | `JBSbatKKConst.RSV_APLY_CD_CL` | - | - |
| 7 | `JBSbatKKConst.SVC_DLRE_CD_CANCEL` | - | - |
| 8 | `JBSbatKKConst.MK_FLG_YK` | - | - |

**No screen/batch entry points found within 8 hops.** This method is a leaf-level batch service method, not invoked by any screen (KKSVxxxx) entry point.

## 6. Per-Branch Detail Blocks

**Block 1** - INITIALIZATION `(L5716-L5765)`

Initial variable declarations and recovery date extraction.

| # | Type | Code |
|---|------|------|
| 1 | SET | `sysDate = JBSbatDateUtil.getSystemDateTimeStamp()` // Get system date/time |
| 2 | SET | `kktkSvcKeiStat = ""` // Initialize service contract status |
| 3 | SET | `rsvAplyYmd = ""` // Initialize reservation application date |
| 4 | SET | `rsvClYmd = ""` // Initialize reservation cancellation date |
| 5 | SET | `rsvAplyCd = ""` // Initialize reservation application code |
| 6 | SET | `planStaymd = ""` // Initialize plan start date |
| 7 | SET | `planEndymd = ""` // Initialize plan end date |
| 8 | SET | `planChrgStaymd = ""` // Initialize plan charge start date |
| 9 | SET | `planChrgEndymd = ""` // Initialize plan charge end date |
| 10 | SET | `svcStaYmd = ""` // Initialize service start date |
| 11 | SET | `svcChrgStaymd = ""` // Initialize service charge start date |
| 12 | SET | `svcEndymd = ""` // Initialize service end date |
| 13 | SET | `svcChrgEndymd = ""` // Initialize service charge end date |
| 14 | SET | `svcDslYmd = ""` // Initialize service cancellation date |
| 15 | SET | `idoDiv = ""` // Initialize movement division code |
| 16 | SET | `mskmDtlNo = ""` // Initialize application detail number |
| 17 | SET | `svcDlreCd = ""` // Initialize service cancellation reason code |
| 18 | SET | `kaihkYmd = Rtrim(dbInfo.getString(KAIHK_YMD))` // Get recovery date [OM-2014-0000400: will be cleared for STB addition] |

**Block 2** - IF BRANCH `[KOUKAN_AF="0"]` (交換後 - Post-replacement) `(L5767-L5817)`

Handles the post-replacement scenario: reads all fields from DB, sets reservation cancellation to operational date and reservation application code to "3:Reservation Cancellation".

| # | Type | Code |
|---|------|------|
| 1 | COND | `if(KOUKAN_AF.equals(flg))` [KOUKAN_AF = "0"] // Post-replacement (交換後) |
| 2 | SET | `kktkSvcKeiStat = Rtrim(dbInfo.getString(KKTK_SVC_KEI_STAT))` // Keep current status from DB |
| 3 | SET | `rsvAplyYmd = Rtrim(dbInfo.getString(RSV_APLY_YMD))` // Reservation application date from DB |
| 4 | SET | `rsvClYmd = this.opeDate` // Reservation cancellation date = operational date |
| 5 | SET | `rsvAplyCd = JBSbatKKConst.RSV_APLY_CD_CL` [RSV_APLY_CD_CL="3"] // Reservation code = "3:Reservation Cancellation" |
| 6 | SET | `planStaymd = Rtrim(dbInfo.getString(PLAN_STAYMD))` // Plan start date from DB |
| 7 | SET | `planEndymd = Rtrim(dbInfo.getString(PLAN_ENDYMD))` // Plan end date from DB |
| 8 | SET | `planChrgStaymd = Rtrim(dbInfo.getString(PLAN_CHRG_STAYMD))` // Plan charge start from DB |
| 9 | SET | `planChrgEndymd = Rtrim(dbInfo.getString(PLAN_CHRG_ENDYMD))` // Plan charge end from DB |
| 10 | SET | `svcStaYmd = Rtrim(dbInfo.getString(SVC_STA_YMD))` // Service start date from DB |
| 11 | SET | `svcChrgStaymd = Rtrim(dbInfo.getString(SVC_CHRG_STAYMD))` // Service charge start from DB |
| 12 | SET | `svcEndymd = Rtrim(dbInfo.getString(SVC_ENDYMD))` // Service end date from DB |
| 13 | SET | `svcChrgEndymd = Rtrim(dbInfo.getString(SVC_CHRG_ENDYMD))` // Service charge end from DB |
| 14 | SET | `svcDslYmd = Rtrim(dbInfo.getString(SVC_DSL_YMD))` // Service cancellation date from DB |
| 15 | SET | `idoDiv = Rtrim(dbInfo.getString(IDO_DIV))` // Movement division from DB |
| 16 | SET | `mskmDtlNo = Rtrim(dbInfo.getString(MSKM_DTL_NO))` // Application detail number from DB |
| 17 | SET | `svcDlreCd = Rtrim(dbInfo.getString(SVC_DLRE_CD))` // Service cancellation reason from DB |

**Block 3** - ELSE-IF BRANCH `[STB_ADD_KKTK="2"]` (STB追加 - STB Addition) `(L5819-L5867)`

Handles STB addition: sets contract status to "910:Cancelled", service cancellation to operational date with reason "03:Construction-Initiated", and clears recovery date.

| # | Type | Code |
|---|------|------|
| 1 | COND | `else if(STB_ADD_KKTK.equals(flg))` [STB_ADD_KKTK = "2"] // STB Addition (STB追加) |
| 2 | SET | `kktkSvcKeiStat = JBSbatKKConst.CD00056_KKTK_SVC_KEI_STAT_910` [CD00056_KKTK_SVC_KEI_STAT_910="910"] // Status = "910:Cancelled" |
| 3 | SET | `rsvAplyYmd = Rtrim(dbInfo.getString(RSV_APLY_YMD))` // Reservation application date from DB |
| 4 | SET | `rsvClYmd = Rtrim(dbInfo.getString(RSV_CL_YMD))` // Reservation cancellation date from DB |
| 5 | SET | `rsvAplyCd = Rtrim(dbInfo.getString(RSV_APLY_CD))` // Reservation application code from DB |
| 6 | SET | `planStaymd = Rtrim(dbInfo.getString(PLAN_STAYMD))` // Plan start date from DB |
| 7 | SET | `planEndymd = Rtrim(dbInfo.getString(PLAN_ENDYMD))` // Plan end date from DB |
| 8 | SET | `planChrgStaymd = Rtrim(dbInfo.getString(PLAN_CHRG_STAYMD))` // Plan charge start from DB |
| 9 | SET | `planChrgEndymd = Rtrim(dbInfo.getString(PLAN_CHRG_ENDYMD))` // Plan charge end from DB |
| 10 | SET | `svcStaYmd = Rtrim(dbInfo.getString(SVC_STA_YMD))` // Service start date from DB |
| 11 | SET | `svcChrgStaymd = Rtrim(dbInfo.getString(SVC_CHRG_STAYMD))` // Service charge start from DB |
| 12 | SET | `svcEndymd = Rtrim(dbInfo.getString(SVC_ENDYMD))` // Service end date from DB |
| 13 | SET | `svcChrgEndymd = Rtrim(dbInfo.getString(SVC_CHRG_ENDYMD))` // Service charge end from DB |
| 14 | SET | `svcDslYmd = this.opeDate` // Service cancellation date = operational date |
| 15 | SET | `idoDiv = Rtrim(dbInfo.getString(IDO_DIV))` // Movement division from DB |
| 16 | SET | `mskmDtlNo = Rtrim(dbInfo.getString(MSKM_DTL_NO))` // Application detail from DB |
| 17 | SET | `svcDlreCd = JBSbatKKConst.SVC_DLRE_CD_CANCEL` [SVC_DLRE_CD_CANCEL="03"] // Reason = "03:Construction-Initiated Cancellation" |
| 18 | SET | `kaihkYmd = ""` // Clear recovery date (復旧年月日クリア) - OM-2014-0000400対応 |

**Block 4** - DATA PREPARATION `(L5869-L6390)`

Populates the 168-element `setParam` array with field values from DB info and branch-dependent values.

| # | Type | Code |
|---|------|------|
| 1 | SET | `Object[] setParam = new Object[168]` // 168-element array for insert |
| 2 | SET | `setParam[0] = Rtrim(dbInfo.getString(KKTK_SVC_KEI_NO))` // Contract number |
| 3 | SET | `setParam[1] = sysDate` // Registration timestamp |
| 4 | SET | `setParam[2] = kktkSvcKeiStat` // Service contract status (branch-dependent) |
| 5 | SET | `setParam[3] = Rtrim(dbInfo.getString(KKTK_SVC_CD))` // Service code |
| 6 | SET | `setParam[4] = Rtrim(dbInfo.getString(PCRS_CD))` // Price course code |
| 7 | SET | `setParam[5] = Rtrim(dbInfo.getString(PPLAN_CD))` // Price plan code |
| 8 | SET | `setParam[6] = Rtrim(dbInfo.getString(TK_HOSHIKI_KEI_NO))` // Provider contract number |
| 9 | SET | `setParam[7] = Rtrim(dbInfo.getString(KKTK_SBT_CD))` // Equipment subtype |
| 10 | SET | `setParam[8] = Rtrim(dbInfo.getString(HAMBAI_SBT_CD))` // Sales subtype |
| 11 | SET | `setParam[9] = Rtrim(dbInfo.getString(SVC_USE_STA_KIBO_YMD))` // Service start desire |
| 12 | SET | `setParam[10] = Rtrim(dbInfo.getString(RSV_TSTA_KIBO_YMD))` // Reservation start desire |
| 13-167 | SET | Remaining fields [11-144]: All DB string fields from T_KKTK_SVC_KEI with Rtrim applied |
| 168 | SET | `setParam[98] = rsvAplyYmd` // Reservation application date (branch-dependent) |
| 169 | SET | `setParam[99] = rsvClYmd` // Reservation cancellation date (branch-dependent) |
| 170 | SET | `setParam[100] = rsvAplyCd` // Reservation application code (branch-dependent) |
| 171 | SET | `setParam[109] = Rtrim(dbInfo.getString(SVC_STA_KISAN_YMD))` // Service start billing date |
| 172 | SET | `setParam[110] = svcStaYmd` // Service start date (branch-dependent) |
| 173 | SET | `setParam[111] = svcChrgStaymd` // Service charge start date |
| 174 | SET | `setParam[124] = svcEndymd` // Service end date |
| 175 | SET | `setParam[125] = svcChrgEndymd` // Service charge end date |
| 176 | SET | `setParam[126] = svcDslYmd` // Service cancellation date (branch-dependent) |
| 177 | SET | `setParam[127] = svcDlreCd` // Service cancellation reason (branch-dependent) |
| 178 | SET | `setParam[131] = kaihkYmd` // Recovery date (branch-dependent) |
| 179 | SET | `setParam[139] = idoDiv` // Movement division code |
| 180 | SET | `setParam[155] = sysDate` // Registration datetime |
| 181 | SET | `setParam[156] = batchUserId` // Registration operator |
| 182 | SET | `setParam[157] = sysDate` // Update datetime |
| 183 | SET | `setParam[158] = batchUserId` // Update operator |
| 184 | SET | `setParam[159] = ""` // Delete datetime (cleared) |
| 185 | SET | `setParam[160] = ""` // Delete operator (cleared) |
| 186 | SET | `setParam[161] = JBSbatKKConst.MK_FLG_YK` [MK_FLG_YK="0"] // Invalid flag = "0" (valid) |
| 187 | SET | `setParam[162-167] = ""` // All operation dates/IDs cleared |

**Block 5** - INSERT EXECUTION `(L6392-L6402)`

Performs the database insert/update using the populated parameter array.

| # | Type | Code |
|---|------|------|
| 1 | CALL | `executeKK_T_KKTK_SVC_KEI_PKINSERT(setParam)` // Insert/update T_KKTK_SVC_KEI with 168 fields |

## 7. Glossary

| Term | Type | Business Meaning |
|------|------|------------------|
| `kktkSvcKei` | Field | Equipment-provided service (機器提供サービス) - telecom services (TV, broadband, etc.) provided by the carrier to customers as part of their contract |
| `svc_kei` | Field | Service contract (サービス契約) - the core service agreement between customer and carrier |
| `svc_kei_ucwk_no` | Field | Service contract detail number (サービス契約内訳番号) - internal tracking ID for service contract line items |
| `odr_naiyo_cd` | Field | Order content code (注文内容コード) - classifies the type of service order |
| `KKTK_SVC_KEI_STAT` | Field | Service contract status (機器提供サービス契約ステータス) - current state of the service contract (active, cancelled, etc.) |
| `KKTK_SVC_KEI_STAT_910` | Field | Status code "910:Cancelled" (解除済) - indicates the service contract has been cancelled |
| `RSV_APLY_YMD` | Field | Reservation application date (予約適用年月日) - date when the reservation becomes applicable |
| `RSV_CL_YMD` | Field | Reservation cancellation date (予約取消年月日) - date when the reservation was cancelled |
| `RSV_APLY_CD` | Field | Reservation application code (予約適用コード) - code indicating reservation state |
| `RSV_APLY_CD_CL` | Constant | "3:Reservation Cancellation" (予約取消) - code for cancelled reservation state |
| `PLAN_STAYMD` | Field | Plan start date (プラン開始年月日) - when the billing plan begins |
| `PLAN_ENDYMD` | Field | Plan end date (プラン終了年月日) - when the billing plan ends |
| `PLAN_CHRG_STAYMD` | Field | Plan charge start date (プラン課金開始年月日) - when billing starts |
| `PLAN_CHRG_ENDYMD` | Field | Plan charge end date (プラン課金終了年月日) - when billing ends |
| `SVC_STA_YMD` | Field | Service start date (サービス開始年月日) - when service becomes active |
| `SVC_CHRG_STAYMD` | Field | Service charge start date (サービス課金開始年月日) - when service billing starts |
| `SVC_ENDYMD` | Field | Service end date (サービス終了年月日) - when service ends |
| `SVC_DSL_YMD` | Field | Service cancellation date (サービス解約年月日) - when service is cancelled |
| `SVC_DLRE_CD` | Field | Service cancellation reason code (サービス解約理由コード) - reason for service cancellation |
| `SVC_DLRE_CD_CANCEL` | Constant | "03:Construction-Initiated Cancellation" (工事起因によるキャンセル) - cancellation due to construction issues |
| `IDO_DIV` | Field | Movement division code (異動区分) - classification of service contract movement/change type |
| `MSKM_DTL_NO` | Field | Application detail number (申込明細番号) - unique identifier for the application line item |
| `KAIHK_YMD` | Field | Recovery date (復旧年月日) - date when service was recovered after an outage; cleared when STB is added |
| `KOUKAN_AF` | Constant | "0:Post-replacement" (交換後) - indicates equipment has been replaced |
| `STB_ADD_KKTK` | Constant | "2:STB Addition" (STB追加) - indicates a Set-Top Box is being added |
| `STB_PARTIAL_REMOVE` | Constant | "3:Partial STB Removal" (STB一部撤去) - indicates partial STB removal (documented but not implemented) |
| `MK_FLG_YK` | Constant | "0:Valid" (無効フラグ：有効) - invalid flag; "0" means the record is valid/active |
| `opeDate` | Field | Operation date (運用日) - the system's operational date used for setting effective dates |
| `batchUserId` | Field | Batch operator user ID (バッチ処理者アカウント) - identifies the batch process user performing the operation |
| T_KKTK_SVC_KEI | Table | Equipment-provided service contract table (機器提供サービス契約テーブル) - the main table storing service contract records for carrier-provided equipment services |
| STB | Acronym | Set-Top Box (セットトップボックス) - decoding device for cable/satellite/broadband TV service |
| FTTH | Business term | Fiber To The Home - fiber-optic broadband internet service |
| 機器提供 | Business term | Equipment-provided - telecom services where the carrier provides equipment (STB, router, etc.) as part of the service contract |
| 工事取消 | Business term | Construction cancellation - cancellation of a planned service installation/construction work |
| 交換後 | Business term | Post-replacement - the state after equipment has been replaced |
| STB追加 | Business term | STB Addition - adding a new Set-Top Box to an existing service |
| STB一部撤去 | Business term | Partial STB Removal - removing one STB from a multi-STB setup |
| 異動区分 | Business term | Movement division - classification code for the type of service contract change/movement |
| 申込明細番号 | Business term | Application detail number - unique identifier for the application line item |
| 予約適用コード | Business term | Reservation application code - code indicating the reservation state (applied, cancelled, etc.) |
| プラン | Business term | Plan - the billing/service plan the customer is subscribed to |
| 課金 | Business term | Billing/Charge - the process of charging the customer for services |
| 解約 | Business term | Cancellation/Termination - ending a service contract |
| 復旧 | Business term | Recovery - restoration of service after an outage or issue |
| 工事起因 | Business term | Construction-initiated - a cancellation reason code indicating the cancellation was due to construction/installation issues |
| 無効フラグ | Business term | Invalid flag (無効フラグ) - flag indicating whether a record is invalid ("0"=valid, "1"=invalid) |
| 運用日 | Business term | Operation date (運用日) - the effective date used for processing in the batch system |
| KK domain | Domain | Equipment-provided service contract domain (機器提供サービス契約ドメイン) - the service contract area dealing with carrier-provided equipment services |
| KKTK_SVC_KEI_NO | Field | Equipment-provided service contract number (機器提供サービス契約番号) - unique identifier for the service contract |
| KKTK_SVC_CD | Field | Equipment-provided service code (機器提供サービスコード) - classification code for the type of equipment-provided service |
| PCRSCD | Field | Price course code (料金コースコード) - the pricing course/code for the service |
| PPLAN_CD | Field | Price plan code (料金プランコード) - the pricing plan for the service |
| TK_HOSHIKI_KEI_NO | Field | Provider contract number (提供方契約番号) - fixed value "999999999999" for provider contract identification |
| KKTK_SBT_CD | Field | Equipment-provided subtype code (機器提供種別コード) - subtype classification of the equipment-provided service |
| HAMBAI_SBT_CD | Field | Sales subtype code (販売種別コード) - sales subtype classification |
| SVC_USE_STA_KIBO_YMD | Field | Service start desire date (サービス利用開始希望年月日) - when the customer desires service to start |
| RSV_TSTA_KIBO_YMD | Field | Reservation start desire date (予約適用開始希望年月日) - when the customer desires the reservation to start |
| KIBO_MAKER_CD | Field | Desired maker code (希望メーカーコード) - the customer's preferred equipment manufacturer |
| KIKI_SHITEI_SBT_CD | Field | Equipment designated subtype code (機器指定種別コード) - subtype of designated equipment |
| TAKNKIKI_SBT_CD | Field | In-home equipment subtype code (宅内機器種別コード) - subtype of in-home equipment |
| TAKNKIKI_MODEL_CD | Field | In-home equipment model code (宅内機器型式コード) - model code for in-home equipment |
| KIKI_SEIZO_NO | Field | Equipment serial number (機器製造番号) - unique serial number of the equipment |
| FUZOKUHIN_SBT_CD | Field | Accessory subtype code (附属品種別コード) - subtype of accessories |
| FUZOKUHIN_MODEL_CD | Field | Accessory model code (附属品型式コード) - model code for accessories |
| KIKI_CHG_NO | Field | Equipment change number (機器変更番号) - identifier for equipment changes |
| KIKI_CHG_RSN_CD | Field | Equipment change reason code (機器変更理由コード) - reason for equipment change |
| TSUSHIN_KIKI_SET_CD | Field | Communication equipment set code (通信機器セットコード) - communication equipment set classification |
| HDD_CAPA_CD | Field | HDD capacity code (HDD容量コード) - HDD capacity classification |
| OYA_KEI_SKBT_CD | Field | Parent contract identification code (親契約識別コード) - identifies the parent contract relationship |
| SVC_KEI_NO | Field | Service contract number (サービス契約番号) - unique identifier for the service contract |
| SVC_KEI_UCWK_NO | Field | Service contract detail number (サービス契約内訳番号) - detail number for the service contract |
| SVC_KEI_KAISEN_UCWK_NO | Field | Service contract line detail number (サービス契約回線内訳番号) - line detail number for the service contract |
| OP_SVC_KEI_NO | Field | Option service contract number (オプションサービス契約番号) - number for option service contracts |
| SYSID | Field | System ID (SYSID) - system identifier |
| LINK_STB_FLG | Field | Link STB flag (リンクSTBフラグ) - flag for linked STB |
| KIKI_HKAT_SHITEI_SOKO_CD | Field | Equipment assignment designated warehouse code (機器引当指定倉庫コード) - warehouse code for equipment assignment |
| KIKI_HKAT_SHITEI_SKDN_CD | Field | Equipment assignment designated shelf code (機器引当指定庫番コード) - shelf code for equipment assignment |
| KIKI_STI_JI_KRIPLACE_SKCD | Field | Equipment designated-time installation site identification code (機器指定時工事事務所識別コード) - identification for construction site office |
| KIKI_STI_JI_KOCOMP_CD | Field | Equipment designated-time construction company code (機器指定時工事会社コード) - construction company code |
| KIKI_STI_JI_KOCOMP_SLF_CD | Field | Equipment designated-time construction company shelf code (機器指定時工事会社庫番コード) - shelf code for construction company |
| KIKI_STI_JI_YTKSKOF_CD | Field | Equipment designated-time pre-delivery office code (機器指定時予賭先オフィスコード) - pre-delivery office code |
| KIKI_STI_JI_YTKSKOF_SLF_CD | Field | Equipment designated-time pre-delivery office shelf code (機器指定時予賭先オフィス庫番コード) - shelf code for pre-delivery office |
| KKTK_SVC_KEI_HKHASYMD | Field | Equipment-provided service contract occurrence date (機器提供サービス契約発生年月日) - date the contract was created |
| KIKI_SORYO_UM | Field | Equipment shipping charge flag (機器送料有無) - whether shipping is charged |
| KIKI_SORYO_SAKSEI_YMD | Field | Equipment shipping creation date (機器送料作成年月日) - date shipping info was created |
| KIKI_SOHUS_NM | Field | Equipment shipping destination name (機器送付先名) - name of the shipping destination |
| KIKI_SOHUS_KANA | Field | Equipment shipping destination kana (機器送付先カナ) - kana reading of the shipping destination name |
| KIKI_SOHUS_AD_CD | Field | Equipment shipping destination address code (機器送付先住所コード) - address code for shipping destination |
| KIKI_SOHUS_PCD | Field | Equipment shipping destination postal code (機器送付先郵便番号) - postal code for shipping destination |
| KIKI_SOHUS_STATE_NM | Field | Equipment shipping destination prefecture name (機器送付先都道府県名) - prefecture name for shipping destination |
| KIKI_SOHUS_CITY_NM | Field | Equipment shipping destination city name (機器送付先市区町村名) - city/town name for shipping destination |
| KIKI_SOHUS_OAZTSU_NM | Field | Equipment shipping destination town name (機器送付先大字通名称) - town/block name for shipping destination |
| KIKI_SOHUS_AZCHO_NM | Field | Equipment shipping destination district name (機器送付先字丁目名) - district name for shipping destination |
| KIKI_SOHUS_BNCHIGO | Field | Equipment shipping destination block/number (機器送付先番地番号) - block/lot number for shipping destination |
| KIKI_SOHUS_ADRTTM | Field | Equipment shipping destination address remark/building name (機器送付先住所補建名) - building name/remark for shipping destination |
| KIKI_SOHUS_ADRRM | Field | Equipment shipping destination room number (機器送付先部屋番号) - room number for shipping destination |
| KIKI_SHS_AD_MAN_INPUT_FLG | Field | Equipment shipping destination manual input flag (機器送付先住所手動入力フラグ) - manual input flag for address |
| KIKI_SOHUS_TELNO | Field | Equipment shipping destination phone number (機器送付先電話番号) - phone number for shipping destination |
| MANSION_BUKKEN_NO | Field | Mansion property number (マンション物件番号) - property number for mansion addresses |
| KIKI_SOHUS_KSH_AD_SAI_FLG | Field | Equipment shipping destination contract address mismatch flag (機器送付先_契約者住所差異フラグ) - flag for address mismatch |
| KIKI_SHS_KBT_SHITEI_FLG | Field | Equipment shipping destination individual designation flag (機器送付先個別指定フラグ) - flag for individual designation |
| KIKI_SHS_HSK_CD_1 | Field | Equipment shipping destination supplementary code 1 (機器送付先補足コード1) |
| KIKI_SHS_HSK_CD_2 | Field | Equipment shipping destination supplementary code 2 (機器送付先補足コード2) |
| KIKI_SHS_HSK_MEMO | Field | Equipment shipping destination supplementary memo (機器送付先補足メモ) |
| KIKI_STC_SAKI_NM | Field | Equipment installation destination name (機器設置先名) - name of the installation destination |
| KIKI_STC_SAKI_KANA | Field | Equipment installation destination kana (機器設置先カナ) - kana reading of installation destination |
| KIKI_STC_SAKI_AD_CD | Field | Equipment installation destination address code (機器設置先住所コード) |
| KIKI_STC_SAKI_PCD | Field | Equipment installation destination postal code (機器設置先郵便番号) |
| KIKI_STC_SAKI_STATE_NM | Field | Equipment installation destination prefecture name (機器設置先都道府県名) |
| KIKI_STC_SAKI_CITY_NM | Field | Equipment installation destination city name (機器設置先市区町村名) |
| KIKI_STC_SAKI_OAZTSU_NM | Field | Equipment installation destination town name (機器設置先大字通名称) |
| KIKI_STC_SAKI_AZCHO_NM | Field | Equipment installation destination district name (機器設置先字丁目名) |
| KIKI_STC_SAKI_BNCHIGO | Field | Equipment installation destination block/number (機器設置先番地番号) |
| KIKI_STC_SAKI_ADRTTM | Field | Equipment installation destination address remark/building name (機器設置先住所補建名) |
| KIKI_STC_SAKI_ADRRM | Field | Equipment installation destination room number (機器設置先部屋番号) |
| KIKI_STC_SK_KSH_AD_SAI_FLG | Field | Equipment installation destination contract address mismatch flag (機器設置先_契約者住所差異フラグ) |
| KIKI_STC_SK_TELNO | Field | Equipment installation destination phone number (機器設置先電話番号) |
| KIKI_STS_KKK_SEIRI_CHU_FLG | Field | Equipment installation area sorting mid flag (機器設置先区画整理中フラグ) - flag for area sorting mid process |
| AD_MI_FIX_FLG | Field | Address undetermined flag (住所未確定フラグ) - flag for undetermined address status |
| AUTO_ADD_CD | Field | Auto-registration code (自動登録コード) - code for automatic registration |
| AD_MI_FIX_RLS_YMD | Field | Address undetermined release date (住所未確定解除年月日) - date when address undetermined status is released |
| CHRG_STA_YMD_HOSEI_UM | Field | Charge start date correction flag (課金開始年月日補正有無) - flag for charge start date correction |
| KIKI_STS_HSK_CD_1 | Field | Equipment installation supplementary code 1 (機器設置先補足コード1) |
| KIKI_STS_HSK_CD_2 | Field | Equipment installation supplementary code 2 (機器設置先補足コード2) |
| KIKI_STS_HSK_MEMO | Field | Equipment installation supplementary memo (機器設置先補足メモ) |
| KKTK_SVC_KEI_KZKWRK_REQYMD | Field | Equipment-provided service post-work request date (機器提供サービス後続業務依頼年月日) |
| SHOSA_YMD | Field | Review date (照会年月日) - date of inquiry/review |
| SHOSA_CL_YMD | Field | Review cancellation date (照会取消年月日) |
| HAISO_DIV | Field | Delivery division (配送区分) - classification of delivery type |
| HAISO_KIGEN_YMD | Field | Delivery deadline date (配送期限年月日) |
| HAISO_ARIV_SHITEI_YMD | Field | Delivery arrival designation date (配送到着指定年月日) |
| FTRIAL_KANYU_YMD | Field | Free trial entry date (無料試用加入年月日) |
| FTRIAL_PRD_ENDYMD | Field | Free trial period end date (無料試用期間終了年月日) |
| HONKANYU_YMD | Field | Full entry date (本加入年月日) - date of full service activation |
| HONKANYU_IKO_KIGEN_YMD | Field | Full entry migration deadline date (本加入移行期限年月日) |
| KEI_CNC_YMD | Field | Contract conclusion date (契約締結年月日) |
| JCCC_KANYU_BUNSHO_YMD | Field | JCCC entry document date (JCCC加入書類年月日) |
| HOSHO_CD | Field | Guarantee code (保証コード) |
| KKTK_SVKEI_HOKI | Field | Equipment-provided service contract remark (機器提供サービス契約補記) |
| HOSHO_STAYMD | Field | Guarantee start date (保証開始年月日) |
| HOSHO_END_YMD | Field | Guarantee end date (保証終了年月日) |
| KIKI_CHG_YMD | Field | Equipment change date (機器変更年月日) |
| PLAN_END_SBT_CD | Field | Plan end subtype code (プラン終了種別コード) |
| SVC_CANCEL_YMD | Field | Service cancellation date (サービスキャンセル年月日) |
| SVC_CANCEL_RSN_CD | Field | Service cancellation reason code (サービスキャンセル理由コード) |
| SVC_STA_KISAN_YMD | Field | Service start billing date (サービス開始起算年月日) - billing start date from service start |
| SVC_STP_YMD | Field | Service suspension date (サービス停止年月日) |
| SVCTK_CHU_USE_FAIL_SBT_CD | Field | Service suspension unusable subtype code (サービス提供中使用不可種別コード) |
| SVC_STP_RSN_CD | Field | Service suspension reason code (サービス停止理由コード) |
| SVC_STP_RLS_YMD | Field | Service suspension release date (サービス停止解除年月日) |
| SVC_STP_RLS_RSN_CD | Field | Service suspension release reason code (サービス停止解除理由コード) |
| PAUSE_STP_CD | Field | Pause suspension code (休止中止コード) |
| SVC_PAUSE_YMD | Field | Service pause date (サービス休止年月日) |
| SVC_PAUSE_RSN_CD | Field | Service pause reason code (サービス休止理由コード) |
| SVC_PAUSE_RSN_MEMO | Field | Service pause reason memo (サービス休止理由メモ) |
| SVC_PAUSE_RLS_YMD | Field | Service pause release date (サービス休止解除年月日) |
| SVC_PAUSE_RLS_RSN_CD | Field | Service pause release reason code (サービス休止解除理由コード) |
| SVC_PAUSE_RLS_RSN_MEMO | Field | Service pause release reason memo (サービス休止解除理由メモ) |
| SVC_DLRE_MEMO | Field | Service cancellation reason memo (サービス解約理由メモ) |
| ZANCHI_FLG | Field | Remaining balance flag (残高フラグ) - flag for remaining balance status |
| SVC_DSL_TTDKI_FIN_FLG | Field | Service cancellation procedure completion flag (サービス解約手続き完了フラグ) |
| SVC_CANCEL_CL_YMD | Field | Service cancellation withdrawal date (サービスキャンセル取消年月日) |
| SVC_DSL_CL_YMD | Field | Service cancellation withdrawal date (サービス解約取消年月日) |
| SKEKKA_SEND_CD | Field | Review result transmission code (審査結果送信コード) |
| SVC_PAUSE_CHRG_STA_YMD | Field | Service pause charge start date (サービス休止課金開始年月日) |
| PNLTY_HASSEI_CD | Field | Penalty occurrence code (違約金発生コード) |
| KIKI_NINSHO_ID | Field | Equipment authentication ID (機器認証ID) |
| KIKI_NINSHO_ID_PWD | Field | Equipment authentication ID password (機器認証IDパスワード) |
| KKST_JSEKI_UK_YMD | Field | Equipment installation actual receipt date (機器設置実績受領年月日) |
| EO_TV_KKST_SNN_STAT_CD | Field | eoTV equipment installation acceptance status code (eoTV機器設置受領状態コード) |
| KKST_SNN_YMD | Field | Equipment installation acceptance date (機器設置受領年月日) |
| TAKNKIKI_IDO_CD | Field | In-home equipment movement code (宅内機器異動コード) |
| CAS_CARD_USE_KYODAK_YMD | Field | CAS card usage authorization date (CASカード使用許可年月日) |
| KIKI_HUKA_INFO_CD | Field | Equipment additional info code (機器付加情報コード) |
| SHOSA_DSL_FIN_CD | Field | Review cancellation completion code (照会解約完了コード) |
| ROUTER_DSL_RSV_TRN_STAT_CD | Field | Router cancellation reservation processing status code (ルーター解約予約処理状態コード) |
| ROUTER_DSL_RSV_TRN_RSLT_CD | Field | Router cancellation reservation processing result code (ルーター解約予約処理結果コード) |
| HAISO_WAY_CD | Field | Delivery method code (配送方法コード) |
| KIKI_ITENS_MV_JSSIS_SKCD | Field | Equipment transfer destination carrier identification code (機器転送先キャリア識別コード) |
| KAISHU_KIKI_UM | Field | Return equipment flag (回収機器有無) |
| HAISO_REQ_SHITEI_YMD | Field | Delivery request designation date (配送依頼指定年月日) |
| SHKA_FIN_JI_SYRZM_FLG | Field | Shipment completion processing completed flag (出荷完了時処理済みフラグ) |
| SVC_STA_JI_HIS_JOKYO_SKCD | Field | Service start status identification code (サービス開始時状況識別コード) |
| MK_FLG | Field | Invalid flag (無効フラグ) - "0" = valid, "1" = invalid |
| REGIST_DATETIMESTAMP | Field | Registration date/time stamp (登録年月日时分秒) |
| REGIST_OPERATOR | Field | Registration operator account (登録オペレーターアカウント) |
| UPD_DATETIMESTAMP | Field | Update date/time stamp (更新年月日时分秒) |
| UPD_OPERATOR | Field | Update operator account (更新オペレーターアカウント) |
| DELE_DATETIMESTAMP | Field | Delete date/time stamp (削除年月日时分秒) |
| DELE_OPERATOR | Field | Delete operator account (削除オペレーターアカウント) |
| REGIST_OPERATION_DATE | Field | Registration operation date (登録運用年月日) |
| REGIST_OPERATION_ID | Field | Registration operation ID (登録処理ID) |
| UPD_OPERATION_DATE | Field | Update operation date (更新運用年月日) |
| UPD_OPERATION_ID | Field | Update operation ID (更新処理ID) |
| DELE_OPERATION_DATE | Field | Delete operation date (削除運用年月日) |
| DELE_OPERATION_ID | Field | Delete operation ID (削除処理ID) |