SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
1ERP EHP76.0TLRT_TARO_CNT1141Trade Repository: Content
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, TARO_GUID, KONTRH, EXTERNAL_ACCOUNT, ASSET_CLASS, NOTICE_DATE, ACTION_TYPE_DTL, DELEGATION, COUNTERP_SIDE, BROKER, CLEARING_MEMBER, LINKED_TO_COMACT, MTM_VALUE, MTM_CURR, VALUATION_DATE, VALUATION_TIME, VALUATION_TYPE, COLLATERILISAT, COLLAT_PORTF, COLLAT_PORTF_C, COLLAT_VALUE, COLLAT_CURR, TAXONOMY, PRODUCT_ID1, PRODUCT_ID2, UNDERLYING_TYPE, UNDERLYING, DELIVERABLE_CURR, NOTIONAL_CURR1, NOTIONAL_CURR2, TRANS_REFNBR, VENUE_OF_EXEC, COMPRESSION, PRICE, PRICE_NOTATION, NOTIONAL_AMT, NOTIONAL_AMT_ACTUAL, NOTIONAL_CURR, PRICE_MULTIPLIER, QUANTITY, UPFRPAY_AMT, UPFRPAY_CURR, DELIVERY_TYPE, EXECUTION_DATE, EXECUTION_TIME, EFFECTIVE_DATE, MATURITY_DATE, TERMINATION_DATE, SETTLEMENT_DATE, MASTERAGREE_TYPE, MASTERAGREE_VERS, CONFIRM_DATE, CONFIRM_TIME, CONFIRM_MEANS, CLEARING_OBLIG, CLEARED, CLEARING_DATE, CLEARING_TIME, CCP, INTRAGROUP, FIXED_RATE_LEG1, FIXED_RATE_LEG2, FIXED_RATE_DAY_C, FIXED_LEG_PAYM_F, FLOAT_RATE_PAY_F, FLOAT_RATE_RES_F, FLOAT_RATE_LEG1, FLOAT_RATE_LEG2, CURRENCY2, EXCHANGE_RATE1, FORWARD_RATE, EXCHANGE_RATE_BA, COMMODITY_BASE, COMMODITY_DTL, DELIVERY_POINT, INTERCON_POINT, LOAD_TYPE, DELIV_START_DATE, DELIV_START_TIME, DELIV_END_DATE, DELIV_END_TIME, CONTRACT_CAPAC, QUANTITY_UNIT, PRICE_TIME_QUANT, OPTION_TYPE, OPTION_STYLE, STRIKE_PRICE, STRIKE_CURR, STRIKE, COUNTERPARTY_ID, COUNTERPARTY_ID_TYPE, COUNTERPARTY_NAME, COUNTERPARTY_DOMICILE, COUNTERPARTY_COUNTRY, COUNTERPARTY_CORP_SECTOR, COUNTERPARTY_FIN_SECTOR, OTHER_COUNTERPARTY_ID, OTHER_COUNTERPARTY_ID_TYPE, OTHER_COUNTERPARTY_COUNTRY, OTHER_COUNTERPARTY_FIN_SECTOR, BROKER_ID, BROKER_ID_TYPE, REPORTING_ENTITY_ID, REPORTING_ENTITY_ID_TYPE, CLEARING_MEMBER_ID, CLEARING_MEMBER_ID_TYPE, BENEFICIARY_ID, BENEFICIARY_ID_TYPE, NON_LEGAL_BASIS_COUNTERP, NON_EUROPEAN_COUNTERP, CLEARING_THRESHOLD, TRADING_CAPACITY, CCP_ID, CCP_ID_TYPE FROM TLRT_TARO_CNT
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2TARO_GUIDGlobally Unique Identifiervarbinary160RAWNoOS_GUID
3KONTRHGeneral Data: Counterpartynvarchar100CHAR(N' ')Yes*FTR_TARO_KONTRH Allow NULL? 
4EXTERNAL_ACCOUNTExternal Accountnvarchar100CHAR(N' ')YesTPM_EXT_ACCOUNT Allow NULL? 
5ASSET_CLASSTransaction Data: Asset Classnvarchar20CHAR(N' ')YesFTR_TARO_ASSET_CLASS Allow NULL? 
6NOTICE_DATEOTC Notice Datenvarchar80DATS(N'00000000')YesTB_NOTICE_DATE Allow NULL? 
7ACTION_TYPE_DTLAction Type Detailsnvarchar500CHAR(N' ')YesFTR_TARO_ACTION_TYPE_DTL Allow NULL? 
8DELEGATIONTransaction Data: Delegationchar10CHAR(N' ')YesFTR_TARO_DELEGATION Allow NULL? 
9COUNTERP_SIDEDerived Counterparty Data: Counterparty Sidechar10CHAR(N' ')YesFTR_TARO_COUNTERP_SIDE Allow NULL? 
10BROKERCounterparty Data: Brokernvarchar100CHAR(N' ')Yes*FTR_TARO_BROKER Allow NULL? 
11CLEARING_MEMBERCounterparty Data: Clearing Membernvarchar100CHAR(N' ')Yes*FTR_TARO_CLEARING_MEMBER Allow NULL? 
12LINKED_TO_COMACTDerived Counterparty Data: Linked to Commerc. Activitychar10CHAR(N' ')YesFTR_TARO_LINKED_TO_COMMERC_ACT Allow NULL? 
13MTM_VALUECounterparty Data: Mark-to-Market Value of Contractdecimal212CURR((0))YesFTR_TARO_MTM_VALUE
14MTM_CURRCounterparty Data: Mark-to-Market Value Currencynvarchar50CUKY(N' ')Yes*FTR_TARO_MTM_CURRENCY Allow NULL? 
15VALUATION_DATECounterparty Data: Date of Last Valuation (UTC)nvarchar80DATS(N'00000000')YesFTR_TARO_VALUATION_DATE Allow NULL? 
16VALUATION_TIMECounterparty Data: Time of Last Valuation (UTC)nvarchar60TIMS(N'000000')YesFTR_TARO_VALUATION_TIME Allow NULL? 
17VALUATION_TYPECounterparty Data: Type of Last Valuationchar10CHAR(N' ')YesFTR_TARO_VALUATION_TYPE Allow NULL? 
18COLLATERILISATCounterparty Data: Collateralizationnvarchar20CHAR(N' ')YesFTR_TARO_COLLATERILISATION Allow NULL? 
19COLLAT_PORTFCounterparty Data: Collateral Portfoliochar10CHAR(N' ')YesFTR_TARO_COLLATERAL_PORTF Allow NULL? 
20COLLAT_PORTF_CCounterparty Data: Collateral Portfolio Codedecimal100DEC((0))YesFTR_TARO_COLLATERAL_PORTF_CODE
21COLLAT_VALUECounterparty Data: Collateral Valuedecimal212CURR((0))YesFTR_TARO_COLLATERAL_VALUE
22COLLAT_CURRCounterparty Data: Collateral Currencynvarchar50CUKY(N' ')Yes*FTR_TARO_COLLATERAL_CURRENCY Allow NULL? 
23TAXONOMYContract Type Data: Taxonomy Usedchar10CHAR(N' ')YesFTR_TARO_TAXONOMY Allow NULL? 
24PRODUCT_ID1Contract Type Data: Product ID 1nvarchar120CHAR(N' ')YesFTR_TARO_PRODUCT_ID1 Allow NULL? 
25PRODUCT_ID2Contract Type Data: Product ID 2nvarchar60CHAR(N' ')YesFTR_TARO_PRODUCT_ID2 Allow NULL? 
26UNDERLYING_TYPEContract Type Data: Underlying Typenvarchar40CHAR(N' ')YesFTR_TARO_UNDERLYING_TYPE Allow NULL? 
27UNDERLYINGContract Type Data: Underlyingnvarchar200CHAR(N' ')YesFTR_TARO_UNDERLYING Allow NULL? 
28DELIVERABLE_CURRContract Type Data: Deliverable Currencynvarchar50CUKY(N' ')Yes*FTR_TARO_DELIVERABLE_CURR Allow NULL? 
29NOTIONAL_CURR1Contract Type Data: Notional Currency 1nvarchar50CUKY(N' ')Yes*FTR_TARO_NOTIONAL_CURRENCY1 Allow NULL? 
30NOTIONAL_CURR2Contract Type Data: Notional Currency 2nvarchar50CUKY(N' ')Yes*FTR_TARO_NOTIONAL_CURRENCY2 Allow NULL? 
31TRANS_REFNBRTransaction Data: TransactRefNumber (aka ReportTrackingNum.)nvarchar400CHAR(N' ')YesFTR_TARO_TRANSACTION_REFNBR Allow NULL? 
32VENUE_OF_EXECTransaction Data: Venue of Executionnvarchar40CHAR(N' ')YesFTR_TARO_VENUE_OF_EXECUTION Allow NULL? 
33COMPRESSIONTransaction Data: Compressionchar10CHAR(N' ')YesFTR_TARO_COMPRESSION Allow NULL? 
34PRICETransaction Data: Pricedecimal156DEC((0))YesFTR_TARO_PRICE
35PRICE_NOTATIONTransaction Data: Price Notationnvarchar30CHAR(N' ')YesFTR_TARO_PRICE_NOTATION Allow NULL? 
36NOTIONAL_AMTTransaction Data: Notional Amountdecimal212CURR((0))YesFTR_TARO_NOTIONAL_AMT
37NOTIONAL_AMT_ACTUALTransaction Data: Actual Notional Amountdecimal212CURR((0))YesFTR_TARO_NOTIONAL_AMT_ACTUAL
38NOTIONAL_CURRTransaction Data: Notional Currencynvarchar50CUKY(N' ')Yes*FTR_TARO_NOTIONAL_CURRENCY Allow NULL? 
39PRICE_MULTIPLIERTransaction Data: Price Multiplierdecimal100DEC((0))YesFTR_TARO_PRICE_MUTLIPLIER
40QUANTITYTransaction Data: Quantitydecimal100DEC((0))YesFTR_TARO_QUANTITY
41UPFRPAY_AMTTransaction Data: Up-Front Payment Amountdecimal212CURR((0))YesFTR_TARO_UPFRONT_PAYMENT_AMT
42UPFRPAY_CURRTransaction Data: Up-Front Payment Currencynvarchar50CUKY(N' ')Yes*FTR_TARO_UPFRONT_PAYMENT_CURR Allow NULL? 
43DELIVERY_TYPETransaction Data: Delivery Typechar10CHAR(N' ')YesFTR_TARO_DELIVERY_TYPE Allow NULL? 
44EXECUTION_DATETransaction Data: Execution Date (UTC)nvarchar80DATS(N'00000000')YesFTR_TARO_EXECUTION_DATE Allow NULL? 
45EXECUTION_TIMETransaction Data: Execution Time (UTC)nvarchar60TIMS(N'000000')YesFTR_TARO_EXECUTION_TIME Allow NULL? 
46EFFECTIVE_DATETransaction Data: Effective Datenvarchar80DATS(N'00000000')YesFTR_TARO_EFFECTIVE_DATE Allow NULL? 
47MATURITY_DATETransaction Data: Maturity Datenvarchar80DATS(N'00000000')YesFTR_TARO_MATURITY_DATE Allow NULL? 
48TERMINATION_DATETransaction Data: Termination Datenvarchar80DATS(N'00000000')YesFTR_TARO_TERMINATION_DATE Allow NULL? 
49SETTLEMENT_DATETransaction Data: Settlement Datenvarchar80DATS(N'00000000')YesFTR_TARO_SETTLEMENT_DATE Allow NULL? 
50MASTERAGREE_TYPETransaction Data: Master Agreement Typenvarchar500CHAR(N' ')YesFTR_TARO_MASTER_AGREEMENT_TYPE Allow NULL? 
51MASTERAGREE_VERSTransaction Data: Master Agreement Versiondecimal40DEC((0))YesFTR_TARO_MASTER_AGREEMENT_VERS
52CONFIRM_DATERisk Mitigation/Reporting Data: Confirmation Date (UTC)nvarchar80DATS(N'00000000')YesFTR_TARO_CONFIRMATION_DATE Allow NULL? 
53CONFIRM_TIMERisk Mitigation/Reporting Data: Confirmation Time (UTC)nvarchar60TIMS(N'000000')YesFTR_TARO_CONFIRMATION_TIME Allow NULL? 
54CONFIRM_MEANSRisk Mitigation/Reporting Data: Confirmation Meanschar10CHAR(N' ')YesFTR_TARO_CONFIRMATION_MEANS Allow NULL? 
55CLEARING_OBLIGClearing Data: Clearing Obligationchar10CHAR(N' ')YesFTR_TARO_CLEARING_OBLIGATION Allow NULL? 
56CLEAREDClearing Data: Clearedchar10CHAR(N' ')YesFTR_TARO_CLEARED Allow NULL? 
57CLEARING_DATEClearing Data: Clearing Date (UTC)nvarchar80DATS(N'00000000')YesFTR_TARO_CLEARING_DATE Allow NULL? 
58CLEARING_TIMEClearing Data: Clearing Time (UTC)nvarchar60TIMS(N'000000')YesFTR_TARO_CLEARING_TIME Allow NULL? 
59CCPCounterparty Data: Central Clearing Partnernvarchar100CHAR(N' ')Yes*FTR_TARO_CENTRAL_CLEAR_PARTNER Allow NULL? 
60INTRAGROUPClearing Data: Intragroupchar10CHAR(N' ')YesFTR_TARO_INTRAGROUP Allow NULL? 
61FIXED_RATE_LEG1Interest Rate Data: Fixed Rate of Leg 1decimal107DEC((0))YesFTR_TARO_FIXED_RATE_LEG1
62FIXED_RATE_LEG2Interest Rate Data: Fixed Rate of Leg 2decimal107DEC((0))YesFTR_TARO_FIXED_RATE_LEG2
63FIXED_RATE_DAY_CInterest Rate Data: Fixed-Rate Day Countnvarchar100CHAR(N' ')YesFTR_TARO_FIXED_RATE_DAY_COUNT Allow NULL? 
64FIXED_LEG_PAYM_FInterest Rate Data: Fixed-Leg Payment Frequencynvarchar40CHAR(N' ')YesFTR_TARO_FIXED_LEG_PAYM_FREQ Allow NULL? 
65FLOAT_RATE_PAY_FInterest Rate Data: Floating-Rate Payment Frequencynvarchar40CHAR(N' ')YesFTR_TARO_FLOAT_RATE_PAYM_FREQ Allow NULL? 
66FLOAT_RATE_RES_FInterest Rate Data: Floating-Rate Reset Frequencynvarchar40CHAR(N' ')YesFTR_TARO_FLOAT_RATE_RESET_FREQ Allow NULL? 
67FLOAT_RATE_LEG1Interest Rate Data: Floating Rate of Leg 1nvarchar400CHAR(N' ')YesFTR_TARO_FLOAT_RATE_OF_LEG1 Allow NULL? 
68FLOAT_RATE_LEG2Interest Rate Data: Floating Rate of Leg 2nvarchar400CHAR(N' ')YesFTR_TARO_FLOAT_RATE_OF_LEG2 Allow NULL? 
69CURRENCY2Foreign Exchange Data: Currency 2nvarchar50CUKY(N' ')Yes*FTR_TARO_CURRENCY2 Allow NULL? 
70EXCHANGE_RATE1Foreign Exchange Data: Exchange Rate 1decimal139DEC((0))YesFTR_TARO_EXCHANGE_RATE1
71FORWARD_RATEForeign Exchange Data: Forward Ratedecimal139DEC((0))YesFTR_TARO_FORWARD_RATE
72EXCHANGE_RATE_BAForeign Exchange Data: Exchange Rate Basisnvarchar70CHAR(N' ')YesFTR_TARO_EXCHANGE_RATE_BASIS Allow NULL? 
73COMMODITY_BASECommodity Data: Commodity Basenvarchar20CHAR(N' ')YesFTR_TARO_COMMODITY_BASE Allow NULL? 
74COMMODITY_DTLCommodity Data: Commodity Detailsnvarchar20CHAR(N' ')YesFTR_TARO_COMMODITY_DETAILS Allow NULL? 
75DELIVERY_POINTCommodity Data: Delivery Pointnvarchar160CHAR(N' ')YesFTR_TARO_DELIVERY_POINT Allow NULL? 
76INTERCON_POINTCommodity Data: Interconnection Pointnvarchar500CHAR(N' ')YesFTR_TARO_INTERCONNECTION_POINT Allow NULL? 
77LOAD_TYPECommodity Data: Load Typenvarchar20CHAR(N' ')YesFTR_TARO_LOAD_TYPE Allow NULL? 
78DELIV_START_DATECommodity Data: Delivery Start Datenvarchar80DATS(N'00000000')YesFTR_TARO_DELIVERY_START_DATE Allow NULL? 
79DELIV_START_TIMECommodity Data: Delivery Start Timenvarchar60TIMS(N'000000')YesFTR_TARO_DELIVERY_START_TIME Allow NULL? 
80DELIV_END_DATECommodity Data: Delivery End Datenvarchar80DATS(N'00000000')YesFTR_TARO_DELIVERY_END_DATE Allow NULL? 
81DELIV_END_TIMECommodity Data: Delivery End Date Timenvarchar60TIMS(N'000000')YesFTR_TARO_DELIVERY_END_TIME Allow NULL? 
82CONTRACT_CAPACCommodity Data: Contract Capacitynvarchar500CHAR(N' ')YesFTR_TARO_CONTRACT_CAPACITY Allow NULL? 
83QUANTITY_UNITCommodity Data: Quantity Unitdecimal105DEC((0))YesFTR_TARO_QUANTITY_UNIT
84PRICE_TIME_QUANTCommodity Data: Price Time Interval Quantitiesdecimal135DEC((0))YesFTR_TARO_PRICE_TIME_INT_QUANT
85OPTION_TYPEOption Data: Option Typechar10CHAR(N' ')YesFTR_TARO_OPTION_TYPE Allow NULL? 
86OPTION_STYLEOption Data: Option Stylechar10CHAR(N' ')YesFTR_TARO_OPTION_STYLE Allow NULL? 
87STRIKE_PRICEOption Data: Strike Pricedecimal132CURR((0))YesFTR_TARO_STRIKE_PRICE
88STRIKE_CURROption Data: Strike Currencynvarchar50CUKY(N' ')Yes*FTR_TARO_STRIKE_CURRENCY Allow NULL? 
89STRIKEOption Data: Strikedecimal117DEC((0))YesFTR_TARO_STRIKE
90COUNTERPARTY_IDDerived Counterparty Data: Counterparty IDnvarchar500CHAR(N' ')YesFTR_TARO_COUNTERP_ID Allow NULL? 
91COUNTERPARTY_ID_TYPEIdentifier Codenvarchar30CHAR(N' ')YesFTR_TARO_TARO_ID_TYPE Allow NULL? 
92COUNTERPARTY_NAMEDerived Counterparty Data: Counterparty Namenvarchar1000CHAR(N' ')YesFTR_TARO_COUNTERP_NAME Allow NULL? 
93COUNTERPARTY_DOMICILEDerived Counterparty Data: Counterparty Domicilenvarchar5000CHAR(N' ')YesFTR_TARO_COUNTERP_DOMICILE Allow NULL? 
94COUNTERPARTY_COUNTRYCounterparty Data: Countrynvarchar30CHAR(N' ')Yes*FTR_TARO_COUNTERP_COUNTRY Allow NULL? 
95COUNTERPARTY_CORP_SECTORDerived Counterparty Data: Counterparty Corporate Sectorchar10CHAR(N' ')YesFTR_TARO_COUNTERP_CORP_SECTOR Allow NULL? 
96COUNTERPARTY_FIN_SECTORDerived Counterparty Data: Counterparty Financial Sectorchar10CHAR(N' ')YesFTR_TARO_COUNTERP_FIN_SECTOR Allow NULL? 
97OTHER_COUNTERPARTY_IDDerived Counterparty Data: Other Counterparty IDnvarchar500CHAR(N' ')YesFTR_TARO_OTHER_COUNTERP_ID Allow NULL? 
98OTHER_COUNTERPARTY_ID_TYPEIdentifier Codenvarchar30CHAR(N' ')YesFTR_TARO_TARO_ID_TYPE Allow NULL? 
99OTHER_COUNTERPARTY_COUNTRYDerived Counterparty Data: Other Counterparty Countrynvarchar30CHAR(N' ')Yes*FTR_TARO_OTHERCOUNTERP_COUNTRY Allow NULL? 
100OTHER_COUNTERPARTY_FIN_SECTORDerivedCounterpartyData: Other Counterparty Financial Sectorchar10CHAR(N' ')YesFTR_TARO_OTHERCOUNTERP_FIN_SEC Allow NULL? 
101BROKER_IDDerived Counterparty Data: Broker IDnvarchar500CHAR(N' ')YesFTR_TARO_BROKER_ID Allow NULL? 
102BROKER_ID_TYPEIdentifier Codenvarchar30CHAR(N' ')YesFTR_TARO_TARO_ID_TYPE Allow NULL? 
103REPORTING_ENTITY_IDDerived Counterparty Data: Reporting Entity IDnvarchar500CHAR(N' ')YesFTR_TARO_REPORTING_ENTITY_ID Allow NULL? 
104REPORTING_ENTITY_ID_TYPEIdentifier Codenvarchar30CHAR(N' ')YesFTR_TARO_TARO_ID_TYPE Allow NULL? 
105CLEARING_MEMBER_IDDerived Counterparty Data: Clearing Member IDnvarchar500CHAR(N' ')YesFTR_TARO_CLEARING_MEMBER_ID Allow NULL? 
106CLEARING_MEMBER_ID_TYPEIdentifier Codenvarchar30CHAR(N' ')YesFTR_TARO_TARO_ID_TYPE Allow NULL? 
107BENEFICIARY_IDDerived Counterparty Data: Beneficiary IDnvarchar500CHAR(N' ')YesFTR_TARO_BENEFICIARY_ID Allow NULL? 
108BENEFICIARY_ID_TYPEIdentifier Codenvarchar30CHAR(N' ')YesFTR_TARO_TARO_ID_TYPE Allow NULL? 
109NON_LEGAL_BASIS_COUNTERPDrvdCtptyData: Domicile Not in Validity Area of Legal Basischar10CHAR(N' ')YesFTR_TARO_NON_LEGALB_COUNTERP Allow NULL? 
110NON_EUROPEAN_COUNTERPObsolete: Instead use field NON_LEGAL_BASIS_COUNTERPchar10CHAR(N' ')YesFTR_TARO_NON_EUROPEAN_COUNTERP Allow NULL? 
111CLEARING_THRESHOLDDerived Counterparty Data: Clearing Thresholdchar10CHAR(N' ')YesFTR_TARO_CLEARING_THRESHOLD Allow NULL? 
112TRADING_CAPACITYDerived Counterparty Data: Trading Capacitychar10CHAR(N' ')YesFTR_TARO_TRADING_CAPACITY Allow NULL? 
113CCP_IDClearing Data: CCP Identificationnvarchar500CHAR(N' ')YesFTR_TARO_CCP_ID Allow NULL? 
114CCP_ID_TYPEIdentifier Codenvarchar30CHAR(N' ')YesFTR_TARO_TARO_ID_TYPE Allow NULL? 
NamePrimaryUniqueTypeColumns
TLRT_TARO_CNT~0YesYesCLUSTEREDMANDT, TARO_GUID