============================================================
LINK AFRICA CONTRACTS TABLE - Available Columns
============================================================
Started: 2026-10-04 09:45:32

✓ Connected to Solid Link Africa

Columns in Link Africa contracts table:
------------------------------------------------------------
  - id
  - version
  - priceExcl
  - setupPriceExcl
  - sourceCurrencyId
  - foreignCurrencyPriceExcl
  - foreignCurrencySetupPriceExcl
  - foreignCurrencyId
  - createDate
  - lastUpdate
  - adjustment
  - adjustmentApprovalAdminId
  - adjustmentApprovalDate
  - contractTypeId
  - costCenterId
  - dealerCode
  - dealerId
  - endDate
  - escalation
  - escalationTypeId
  - masterAccountId
  - originalContractId
  - parentServiceAccountId
  - productId
  - promoCodeCode
  - promoCodeId
  - ricaStatusId
  - ricaDetailId
  - salesAgentId
  - captureAgentId
  - startDate
  - supplierInstallDate
  - customerInstallDate
  - adminId
  - adminTypeId
  - serviceAccountId
  - escalationPeriodId
  - nextEscalationDate
  - physicalContractPeriod
  - physicalContractEndDate
  - physicalContractStartDate
  - physicalContractId
  - physicalContractInitialProductPrice
  - physicalContractInitialAdjustedProductPrice
  - billedToDate
  - prevBilledToDate
  - activationLetterId
  - adjustmentTypeId
  - billingRunId
  - prevBillingRunId
  - contractStatusId
  - escalationStatusId
  - escalationBaseRate
  - adjustmentApprovalProcessId
  - promoCodeProductId
  - campaignId
  - campaignCode
  - transactionId
  - salesChannelId
  - billingTypeId
  - productBundleInstanceId
  - bundleTypeId
  - billingProcessId
  - prevBillingProcessId
  - importContractId
  - alternateDescription
  - quantity
  - showDateTypeId
  - extAttribute1
  - extAttribute2
  - extAttribute3
  - extAttribute4
  - extAttribute5
  - overrideBillingPeriodId
  - setupAdjustmentTypeId
  - setupAdjustment
  - overrideBilledToDate
  - prevOverrideBilledToDate
  - salesAgentTypeId
  - captureAgentTypeId
  - adjustmentReasonId
  - contractNumber
  - costPriceExcl
  - setupCostPriceExcl
  - onceOffCostPriceExcl
  - contractNo

Total columns: 86

============================================================
CONTRACT DATA FOR ETHVAJ0001 (using actual columns)
============================================================

Contract ID: 1
Service Tag: ETHVAJ0001
------------------------------------------------------------
id                                 : 1
version                            : 172
priceExcl                          : 840
setupPriceExcl                     : 0
sourceCurrencyId                   : 1
foreignCurrencyPriceExcl           : 0
foreignCurrencySetupPriceExcl      : 0
foreignCurrencyId                  : 0
createDate                         : 2021-04-15 17:46:34
lastUpdate                         : 2026-04-30 12:27:20
adjustment                         : -8300
adjustmentApprovalAdminId          : 1
adjustmentApprovalDate             : 2021-04-15 17:46:34
contractTypeId                     : 1
costCenterId                       : 1
dealerCode                         : 
dealerId                           : 0
endDate                            : 
escalation                         : 0
escalationTypeId                   : 0
masterAccountId                    : 1
originalContractId                 : 0
parentServiceAccountId             : 0
productId                          : 12178
promoCodeCode                      : LEGACY
promoCodeId                        : 12
ricaStatusId                       : 3
ricaDetailId                       : 0
salesAgentId                       : 0
captureAgentId                     : 1
startDate                          : 2019-06-01 00:00:00
supplierInstallDate                : 2019-06-01 00:00:00
customerInstallDate                : 2019-06-01 00:00:00
adminId                            : 2
adminTypeId                        : 1
serviceAccountId                   : 1
escalationPeriodId                 : 0
nextEscalationDate                 : 
physicalContractPeriod             : 0
physicalContractEndDate            : 
physicalContractStartDate          : 
physicalContractId                 : 0
physicalContractInitialProductPrice: 0
physicalContractInitialAdjustedProductPrice: 0
billedToDate                       : 2026-11-01 00:00:00
prevBilledToDate                   : 2026-10-01 00:00:00
activationLetterId                 : 0
adjustmentTypeId                   : 1
billingRunId                       : 274
prevBillingRunId                   : 270
contractStatusId                   : 100
escalationStatusId                 : 0
escalationBaseRate                 : 0
adjustmentApprovalProcessId        : 2
promoCodeProductId                 : 13879
campaignId                         : 0
campaignCode                       : 
transactionId                      : 1
salesChannelId                     : 0
billingTypeId                      : 1
productBundleInstanceId            : 0
bundleTypeId                       : 1
billingProcessId                   : 194067805
prevBillingProcessId               : 190143765
importContractId                   : 1
alternateDescription               : ETHVAJ0001 - TERACO DC
quantity                           : 1
showDateTypeId                     : 1
extAttribute1                      : FTTB
extAttribute2                      : 
extAttribute3                      : 
extAttribute4                      : 800.0
extAttribute5                      : -7900.0
overrideBillingPeriodId            : 2
setupAdjustmentTypeId              : 1
setupAdjustment                    : 0
overrideBilledToDate               : 
prevOverrideBilledToDate           : 
salesAgentTypeId                   : 1
captureAgentTypeId                 : 1
adjustmentReasonId                 : 0
contractNumber                     : S1
costPriceExcl                      : 0
setupCostPriceExcl                 : 0
onceOffCostPriceExcl               : 0
contractNo                         : 

============================================================
Completed: 2026-10-04 09:45:32
============================================================