I_TRSYPOSVALUESCOMPATIBLE

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Position Values (OLD VERSION DO NOT USE)
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_TRSYPOSVALUESCOMPATIBLE (
    ACCRUEDINTERESTINPOSITIONCRCY,
    ACCRUEDINTERESTINVALUATIONCRCY,
    ACQUISITIONAMOUNTINVALNCRCY,
    ACQUISITIONAMTINPOSITIONCRCY,
    AMORTIZATIONAMTINPOSITIONCRCY,
    AMORTIZATIONAMTINVALUATIONCRCY,
    AMORTIZEDACQNAMOUNTINPOSCRCY,
    AMORTIZEDACQNAMOUNTINVALNCRCY,
    AMORTIZEDCOSTINPOSITIONCRCY,
    AMORTIZEDCOSTINVALUATIONCRCY,
    AMTZNADJMTLOSSALLWNCINPOSCRCY,
    AMTZNADJMTLOSSALLWNCINVALNCRCY,
    AMTZNNONDESIGNATEDAMTINPOSCRCY,
    AMTZNNONDESIGNATEDAMTINVC,
    BOOKVALUEAMOUNTINVALNCURRENCY,
    BOOKVALUEAMTINPOSITIONCURRENCY,
    CAPITALIZATIONRSRVINPOSCRCY,
    CAPITALIZATIONRSRVINVALNCRCY,
    CENTRALCLEARINGACCOUNT,
    CENTRALCLEARINGACCOUNTCURRENCY,
    CLEARINGAMOUNTINPOSITIONCRCY,
    CLEARINGAMOUNTINVALUATIONCRCY,
    CLRDPREMDISCDEFRLAMTINVALNCRCY,
    CLRDPREMDISCDEFRLTXCOMPNAMOUNT,
    CNSLDTDFOREXGAINAMTINVALNCRCY,
    CNSLDTDFOREXLOSSAMTINVALNCRCY,
    CNSLDTDSCRTYGAINAMTINPOSCRCY,
    CNSLDTDSCRTYGAINAMTINVALNCRCY,
    CNSLDTDSCRTYLOSSAMTINPOSCRCY,
    CNSLDTDSCRTYLOSSAMTINVALNCRCY,
    COMMITMENTBUSINESSPARTNER,
    COMPANYCODE,
    CONTRACTCHANGEAMTINPOSCRCY,
    CONTRACTCHANGEAMTINVALNCRCY,
    COSTCENTER,
    COSTEXCLDBOOKVALAMTINVALNCRCY,
    COSTEXCLDBOOKVALUEAMTINPOSCRCY,
    COSTINPOSITIONCURRENCY,
    COSTINVALUATIONCURRENCY,
    CUMLTVREPAYMENTAMOUNTINPOSCRCY,
    CUMLTVREPAYMENTAMTINVALNCRCY,
    DESIGNATEDAMOUNTINNOMINALCRCY,
    DESIGNATEDORIGAMTINNOMINALCRCY,
    EFFCTVAMTINPOSCRCY,
    EFFCTVAMTINVALNCRCY,
    EFFCTVCOSTHDGGRSRVINPOSCRCY,
    EFFCTVCOSTHDGGRSRVINVALNCRCY,
    EFFCTVCOSTHDGRSRVPNLINPOSCRCY,
    EFFCTVCOSTHDGRSRVPNLINVALNCRCY,
    EFFCTVHDGGRSRVPNLINPOSCRCY,
    FINANCIALEXPOSUREITEM,
    FINANCIALEXPOSURESUBITEM,
    FINANCIALINSTRUMENTPRODUCTTYPE,
    FINANCIALINSTRVALUATIONCLASS,
    FINANCIALTRANSACTION,
    FOREIGNCRCYVALNAMTINVALNCRCY,
    FOREIGNEXCHIMPRMTAMTINVALNCRCY,
    FRGNEXCHCONTRCHGAMTINVALNCRCY,
    FRGNEXCHCOSTVALNAMTINVALNCRCY,
    FRGNEXCHCOSTWRTUPAMTINVALNCRCY,
    FRGNEXCHVALNDIFFAMTINVALNCRCY,
    FRGNEXCHWRITEDOWNAMTINVALNCRCY,
    FRGNEXCHWRITEUPAMTINVALNCRCY,
    FUNCTIONALAREA,
    FUND,
    FXCOSTWRITEDOWNAMTINVALNCRCY,
    FXLOSSALLOWANCEAMTINVALNCRCY,
    FXOFFSTLOSSALLWNCAMTINVALNCRCY,
    FXOFFSTOCILOSSALLWNCINVALNCRCY,
    FXVALNAMTZDACQNAMTINVALNCRCY,
    GAINVALUEADJMTAMOUNTINPOSCRCY,
    GAINVALUEADJMTAMOUNTINVALNCRCY,
    GRANTID,
    HEDGEAMORTIZATIONAMTINPOSCRCY,
    HEDGEAMORTIZATIONAMTINVALNCRCY,
    IDXCLEANAMTZDACQNAMTINPOSCRCY,
    IDXCLEANHEDGEAMTZNAMTINPOSCRCY,
    IDXCLEANSCRTYVALNAMTINPOSCRCY,
    IDXCLNCLRDPREMDISCDEFERRALAMT,
    IDXCLNCOSTEXCLDBOOKVALUEAMOUNT,
    IDXCLNOCISCRTYCOSTVALUATIONAMT,
    IDXCLNOCISCRTYVALNAMTINPOSCRCY,
    IDXCLNPURVALDEFRLAMTINPOSCRCY,
    IMPAIRMENTAMOUNTINPOSITIONCRCY,
    IMPAIRMENTAMTINVALUATIONCRCY,
    INDEXCLEANACQNAMOUNTINPOSCRCY,
    INDEXCLEANAMTZNAMOUNTINPOSCRCY,
    INDEXCLEANCLEARINGAMTINPOSCRCY,
    INDEXCLEANCOSTINPOSITIONCRCY,
    INDEXCLEANIMPRMTAMTINPOSCRCY,
    INDEXCLEANINTERESTINCINPOSCRCY,
    INDEXCLEANNEGTTNAMTZNINPOSCRCY,
    INDEXCLEANPURCHASEVALINPOSCRCY,
    INDEXCLEANRPAYTAMTINPOSCRCY,
    INDEXCLNBOOKVALUEAMTINPOSCRCY,
    INDEXCLNSCRTYCOSTVALUATIONAMT,
    INDEXVALUATIONAMOUNTINPOSCRCY,
    INDEXVALUATIONAMOUNTINVALNCRCY,
    INDEXWRITEDOWNAMOUNTINPOSCRCY,
    INDEXWRITEDOWNAMTINVALNCRCY,
    INDEXWRITEUPAMOUNTINPOSCRCY,
    INDEXWRITEUPAMOUNTINVALNCRCY,
    INEFFCTVAMTINPOSCRCY,
    INEFFCTVAMTINVALNCRCY,
    INEFFCTVCOSTHDGRSRVPNLPOSCRCY,
    INEFFCTVCOSTHDGRSRVPNLVALNCRCY,
    INEFFCTVHDGGRSRVPNLINPOSCRCY,
    INEFFCTVHDGGRSRVPNLINVALNCRCY,
    INTERESTINCOMEINPOSITIONCRCY,
    INTERESTINCOMEINVALUATIONCRCY,
    LOANCONTRACT,
    LOSSALLOWANCEAMOUNTINPOSCRCY,
    LOSSALLOWANCEAMOUNTINVALNCRCY,
    LOSSVALUEADJMTAMOUNTINPOSCRCY,
    LOSSVALUEADJMTAMOUNTINVALNCRCY,
    NEGTTNSPREADAMTZNAMTINPOSCRCY,
    NEGTTNSPREADAMTZNAMTINVALNCRCY,
    NOMINALAMOUNTINNOMINALCURRENCY,
    NOMINALCURRENCY,
    OCICOSTFXVALNAMOUNTINVALNCRCY,
    OCIFRGNEXCHVALNAMTINVALNCRCY,
    OCIINDEXVALNAMOUNTINPOSCRCY,
    OCIINDEXVALNAMOUNTINVALNCRCY,
    OCIOFFSTLOSSALLWNCAMTINPOSCRCY,
    OCISCRTYCOSTVALNAMTINPOSCRCY,
    OCISCRTYCOSTVALNAMTINVALNCRCY,
    OCISCRTYVALNAMOUNTINVALNCRCY,
    OCISECURITYVALNAMOUNTINPOSCRCY,
    OFFSETLOSSALLWNCAMTINVALNCRCY,
    OFFSTLOSSALLOWANCEAMTINPOSCRCY,
    ORIGINALVALADJMTAMTINVALNCRCY,
    ORIGINALVALUEADJMTAMTINPOSCRCY,
    ORIGLNOMINALAMTINNOMINALCRCY,
    PNLDESIGNATEDAMTINPOSCRCY,
    PNLDESIGNATEDAMTINVC,
    PNLNONDESIGNATEDAMTINPOSCRCY,
    PNLNONDESIGNATEDAMTINVC,
    PORTFOLIO,
    POSITIONCURRENCY,
    PROFITCENTER,
    PURCHASEVALUEINPOSITIONCRCY,
    PURCHASEVALUEINVALUATIONCRCY,
    PURCRCYSPOTVALNAMTINVALNCRCY,
    PURVALDEFERRALITMAMTINPOSCRCY,
    PURVALDEFERRALITMAMTINVALNCRCY,
    SALECRCYSPOTVALNAMTINVALNCRCY,
    SCRTYCOSTWRITEDOWNAMTINPOSCRCY,
    SCRTYCOSTWRITEUPAMTINPOSCRCY,
    SCRTYCOSTWRITEUPAMTINVALNCRCY,
    SCRTYCOSTWRTDOWNAMTINVALNCRCY,
    SCRTYWRITEDOWNAMTINVALNCRCY,
    SECURITYACCOUNT,
    SECURITYACCOUNTGROUP,
    SECURITYCLASS,
    SECURITYCOSTVALNAMTINPOSCRCY,
    SECURITYCOSTVALNAMTINVALNCRCY,
    SECURITYVALUATIONAMTINPOSCRCY,
    SECURITYVALUATIONAMTINVALNCRCY,
    SECURITYWRITEDOWNAMTINPOSCRCY,
    SECURITYWRITEUPAMOUNTINPOSCRCY,
    SECURITYWRITEUPAMTINVALNCRCY,
    SWAPACCRUALAMOUNTINPOSCURRENCY,
    SWAPACCRUALAMOUNTINVALNCRCY,
    SWAPVALUATIONAMOUNTINVALNCRCY,
    TREASURYACCOUNTINGCODE,
    TREASURYBUSINESSTRANSCATEGORY,
    TREASURYGLACCOUNTASSIGNMENTREF,
    TREASURYPOSASSETLIABILITYCODE,
    TREASURYPOSITION,
    TREASURYPOSITIONACCOUNT,
    TREASURYPOSITIONLEDGERDATE,
    TREASURYPOSITIONLONGSHORTCODE,
    TREASURYPOSITIONLOT,
    TREASURYUPDATETYPE,
    TREASURYVALUATIONAREA,
    TREASURYVALUATIONCLASS,
    TRSYPOSCUSTOMDIFFNTNTERM1,
    TRSYPOSCUSTOMDIFFNTNTERM2,
    TRSYPOSCUSTOMDIFFNTNTERM3,
    TRSYPOSCUSTOMDIFFNTNTERM4,
    TRSYPOSCUSTOMDIFFNTNTERM5,
    TRSYPOSMANAGEMENTPROCEDURE,
    VALUATIONCURRENCY,
    VARIATIONMARGINAMOUNTINPOSCRCY,
    VARIATIONMARGINAMTINVALNCRCY,
    WBSELEMENTINTERNALID
);