1 files changed, 164 insertions, 0 deletions
diff --git a/python/csv_headers/bond_upload.py b/python/csv_headers/bond_upload.py
new file mode 100644
index 00000000..db1eb066
--- /dev/null
+++ b/python/csv_headers/bond_upload.py
@@ -0,0 +1,164 @@
+BBH_BONDS = [
+    "Function of Instruction",
+    "Client Reference Number",
+    "Previous Reference Number",
+    "Account Number",
+    "Transaction Type",
+    "Place of Settlement/Country",
+    "Place of Safekeeping",
+    "Trade Date",
+    "Settlement Date",
+    "Security ID",
+    "Security Description",
+    "Unit / Original Face Amount",
+    "Currency",
+    "Unit Price Amount",
+    "Net Amount",
+    "Trading Broker Type/ID",
+    "Trading Broker Description",
+    "Beneficiary of Securities Account",
+    "Clearing Broker ID / Type",
+    "Clearing Broker Description",
+    "Clearing Agent Account",
+    "Stamp Duty Code",
+    "Stamp Duty Amount",
+    "Special Settlement Type",
+    "Special Indicator #1",
+    "Special Indicator #2",
+    "Registration Details",
+    "Special Instruction",
+    "Originator of Message",
+    "Current Face/Amortize Value",
+    "Principal Amount",
+    "Interest Amount",
+    "Other Fees Amount",
+    "Commission Amount",
+    "SEC Fees Amount",
+    "Transaction Tax Amount",
+    "Withholding Tax Amount",
+    "Exchange Rate",
+    "Resulting Currency",
+    "Resulting Amount",
+    "FX Currency",
+    "Pool Reference Number",
+    "Total Group Number",
+    "Trade Number",
+    "Repo Term Date (REPO only)",
+    "Repo Amount (REPO only)",
+    "Repo Reference Number (REPO only)",
+    "Repo Rate (REPO Only)",
+    "Ticker (CPF and CRF Only)",
+    "Strike Price (CPF and CRF Only)",
+    "Expiration Date (CPF and CRF Only)",
+    "Broker Number (CPF and CRF Only)",
+    "Broker Account (CPF and CRF Only)",
+    "Contract Size (Option Contract and Future Contract Only)",
+    "Place of Trade Narrative",
+    "Common Reference",
+    "Partial Settlement Allowed",
+    "Partial Settlement Tolerance",
+    "No Automatic Market Claim",
+    "Corporate Action Coupon Option",
+    "Triparty Collateral Segregation",
+    "FX Cancel - For CANC instructions only",
+    "Fund Accounting Only Trade (RPTO)",
+    "Custody Only Trade (NACT)",
+    "Research Fee (RSCH)",
+]
+
+bbh_swap = [
+    "Deal Type",
+    "Deal Id",
+    "Action",
+    "Client",
+    "Fund",
+    "Portfolio",
+    "Folder",
+    "Custodian",
+    "Cash Account",
+    "Counterparty",
+    "Comments",
+    "State",
+    "Trade Date",
+    "Reserved",
+    "Reserved",
+    "Reserved",
+    "Notional",
+    "PremiumSettlementDate",
+    "ExpirationDate",
+    "PremiumCurrency",
+    "PercentageOfPremium",
+    "ExerciseType",
+    "Reserved",
+    "SettlementMode",
+    "SettlementRate",
+    "Transaction Indicator",
+    "InitialMargin",
+    "InitialMarginPercentage",
+    "InitialMarginCurrency",
+    "ReceiveLegRateType",
+    "ReceiveFloatRate",
+    "ReceiveFirstCouponDate",
+    "ReceiveFirstCouponRate",
+    "ReceiveFixedRate",
+    "ReceiveDaycount",
+    "ReceiveFrequency",
+    "ReceivePaymentRollConvention",
+    "ReceiveEffectiveDate",
+    "ReceiveMaturityDate",
+    "ReceiveNotional",
+    "ReceiveArrears",
+    "ReceiveAdjusted",
+    "ReceiveCompound",
+    "ReceiveCurrency",
+    "PayLegRateType",
+    "PayFloatRate",
+    "PayFirstCouponDate",
+    "PayFirstCouponRate",
+    "PayFixedRate",
+    "PayDaycount",
+    "PayFrequency",
+    "PayPaymentRollConvention",
+    "PayEffectiveDate",
+    "PayMaturityDate",
+    "PayNotional",
+    "PayArrears",
+    "PayAdjusted",
+    "PayCompound",
+    "PayCurrency",
+    "RegenerateCashFlow",
+    "GiveUpBroker",
+    "ClientReference",
+    "ReceiveDiscountCurve",
+    "ReceiveForwardCurve",
+    "PayDiscountCurve",
+    "PayForwardCurve",
+    "ReceiveFixingFrequency",
+    "ReceiveInterestCalcMethod",
+    "ReceiveCompoundAverageFrequency",
+    "PayFixingFrequency",
+    "PayInterestCalcMethod",
+    "PayCompoundAverageFrequency",
+    "SwapType",
+    "AttachmentPoint",
+    "ExhaustionPoint",
+    "UnderlyingInstrument",
+    "AssociatedDealType",
+    "AssociatedDealId",
+    "CounterpartyReference",
+    "PremiumSettlementCurrency",
+    "PremiumSettlementAmount",
+    "ReceiveIMM Period",
+    "PayIMMPeriod",
+    "Reserved",
+    "ClearingFacility",
+    "Strike",
+    "CcpTradeRef",
+    "BreakClauseFrequency",
+    "BlockId",
+    "BlockAmount",
+    "Cross Currency Premium Payment",
+    "Premium Payment Amount",
+    "Netting Id",
+    "BreakClauseDate",
+]