I_FTR_POSITION_VALUES

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.

-- Treasury Ledger Position Values
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_FTR_POSITION_VALUES (
    COMPANYCODE,
    FINANCIALTRANSACTION,
    SECURITYACCOUNT,
    SECURITYCLASS,
    _CENTRALCLEARINGACCOUNT,
    _COMPANYCODE,
    _DIFFERENTIATIONPORTFOLIOTEXT,
    _FINANCIALINSTRPRODTYPE,
    _FINANCIALINSTRPRODTYPETEXT,
    _FINANCIALINSTRVALCLASSTEXT,
    _LOANCONTRACT,
    _SECURITYACCOUNT,
    _SECURITYACCOUNTGROUP,
    _SECURITYCLASS,
    _TREASURYPOSITIONACCOUNT,
    _TREASURYSUBPOSITION,
    _TREASURYVALUATIONAREA,
    _TREASURYVALUATIONCLASSTEXT,
    _TRSYLDGRGLACCTASSGMTREF,
    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,
    CONTRACTCHANGEAMTINPOSCRCY,
    CONTRACTCHANGEAMTINVALNCRCY,
    CONTROLLINGAREA,
    COSTCENTER,
    COSTEXCLDBOOKVALAMTINVALNCRCY,
    COSTEXCLDBOOKVALUEAMTINPOSCRCY,
    COSTINPOSITIONCURRENCY,
    COSTINVALUATIONCURRENCY,
    CUMLTVREPAYMENTAMOUNTINPOSCRCY,
    CUMLTVREPAYMENTAMTINVALNCRCY,
    DESIGNATEDAMOUNTINNOMINALCRCY,
    DESIGNATEDORIGAMTINNOMINALCRCY,
    DESIGNATEDQUANTITYINPIECES,
    DIFFERENTIATIONPORTFOLIO,
    EFFCTVAMTINPOSCRCY,
    EFFCTVAMTINVALNCRCY,
    EFFCTVCOSTHDGGRSRVINPOSCRCY,
    EFFCTVCOSTHDGGRSRVINVALNCRCY,
    EFFCTVCOSTHDGRSRVPNLINPOSCRCY,
    EFFCTVCOSTHDGRSRVPNLINVALNCRCY,
    EFFCTVHDGGRSRVPNLINPOSCRCY,
    EFFCTVHDGGRSRVPNLINVALNCRCY,
    FINANCIALEXPOSUREITEM,
    FINANCIALEXPOSURESUBITEM,
    FINANCIALINSTRUMENTPRODUCTTYPE,
    FINANCIALINSTRVALUATIONCLASS,
    FINANCIALMANAGEMENTAREA,
    FOREIGNCRCYVALNAMTINVALNCRCY,
    FOREIGNEXCHIMPRMTAMTINVALNCRCY,
    FRGNEXCHCONTRCHGAMTINVALNCRCY,
    FRGNEXCHCOSTVALNAMTINVALNCRCY,
    FRGNEXCHCOSTWRTUPAMTINVALNCRCY,
    FRGNEXCHVALNDIFFAMTINVALNCRCY,
    FRGNEXCHWRITEDOWNAMTINVALNCRCY,
    FRGNEXCHWRITEUPAMTINVALNCRCY,
    FUNCTIONALAREA,
    FUND,
    FXAMTZNADJLOSSALLWNCINVALNCRCY,
    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,
    LOSSALLOWANCEAMOUNTINVALNCRCY,
    LOSSVALUEADJMTAMOUNTINPOSCRCY,
    LOSSVALUEADJMTAMOUNTINVALNCRCY,
    NEGTTNSPREADAMTZNAMTINPOSCRCY,
    NEGTTNSPREADAMTZNAMTINVALNCRCY,
    NOMINALAMOUNTINNOMINALCURRENCY,
    NOMINALCURRENCY,
    OCICOSTFXVALNAMOUNTINVALNCRCY,
    OCIFRGNEXCHVALNAMTINVALNCRCY,
    OCIINDEXVALNAMOUNTINPOSCRCY,
    OCIINDEXVALNAMOUNTINVALNCRCY,
    OCIOFFSTLOSSALLWNCAMTINPOSCRCY,
    OCIOFFSTLOSSALLWNCINVALNCRCY,
    OCISCRTYCOSTVALNAMTINPOSCRCY,
    OCISCRTYCOSTVALNAMTINVALNCRCY,
    OCISCRTYVALNAMOUNTINVALNCRCY,
    OCISECURITYVALNAMOUNTINPOSCRCY,
    OFFSETLOSSALLWNCAMTINVALNCRCY,
    OFFSTLOSSALLOWANCEAMTINPOSCRCY,
    ORIGINALVALADJMTAMTINVALNCRCY,
    ORIGINALVALUEADJMTAMTINPOSCRCY,
    ORIGLNOMINALAMTINNOMINALCRCY,
    PNLDESIGNATEDAMTINPOSCRCY,
    PNLDESIGNATEDAMTINVC,
    PNLNONDESIGNATEDAMTINPOSCRCY,
    PNLNONDESIGNATEDAMTINVC,
    POSITIONCURRENCY,
    POSTINGDATE,
    PROFITCENTER,
    PURCHASEVALUEINPOSITIONCRCY,
    PURCHASEVALUEINVALUATIONCRCY,
    PURCRCYSPOTVALNAMTINVALNCRCY,
    PURVALDEFERRALITMAMTINPOSCRCY,
    PURVALDEFERRALITMAMTINVALNCRCY,
    QUANTITYINPIECES,
    SALECRCYSPOTVALNAMTINVALNCRCY,
    SCRTYCOSTWRITEDOWNAMTINPOSCRCY,
    SCRTYCOSTWRITEUPAMTINPOSCRCY,
    SCRTYCOSTWRITEUPAMTINVALNCRCY,
    SCRTYCOSTWRTDOWNAMTINVALNCRCY,
    SCRTYWRITEDOWNAMTINVALNCRCY,
    SECURITYACCOUNTGROUP,
    SECURITYCOSTVALNAMTINPOSCRCY,
    SECURITYCOSTVALNAMTINVALNCRCY,
    SECURITYVALUATIONAMTINPOSCRCY,
    SECURITYVALUATIONAMTINVALNCRCY,
    SECURITYWRITEDOWNAMTINPOSCRCY,
    SECURITYWRITEUPAMOUNTINPOSCRCY,
    SECURITYWRITEUPAMTINVALNCRCY,
    SWAPACCRUALAMOUNTINPOSCURRENCY,
    SWAPACCRUALAMOUNTINVALNCRCY,
    SWAPVALUATIONAMOUNTINVALNCRCY,
    TRADER,
    TREASURYACCOUNTINGCODE,
    TREASURYBUSINESSTRANSCATEGORY,
    TREASURYBUSINESSTRANSSTATUS,
    TREASURYPOSASSETLIABILITYCODE,
    TREASURYPOSITION,
    TREASURYPOSITIONACCOUNT,
    TREASURYPOSITIONLEDGERDATE,
    TREASURYPOSITIONLONGSHORTCODE,
    TREASURYPOSITIONLOT,
    TREASURYPOSITIONZERODATE,
    TREASURYUPDATETYPE,
    TREASURYVALUATIONAREA,
    TREASURYVALUATIONCLASS,
    TRSYCLSFCTNAMTINPOSCRCY,
    TRSYCLSFCTNAMTINVALNCRCY,
    TRSYDERIVEDBUSINESSTRANSSTATUS,
    TRSYPOSAMOUNTCHANGECATEGORY,
    TRSYPOSCUSTOMDIFFNTNTERM1,
    TRSYPOSCUSTOMDIFFNTNTERM2,
    TRSYPOSCUSTOMDIFFNTNTERM3,
    TRSYPOSCUSTOMDIFFNTNTERM4,
    TRSYPOSCUSTOMDIFFNTNTERM5,
    TRSYPOSMANAGEMENTPROCEDURE,
    TRSYPOSQUANTITYCHANGECATEGORY,
    TRSYPOSVALUATIONSTEPPROCEDURE,
    TRSYSUBPOSITION,
    VALUATIONCURRENCY,
    VARIATIONMARGINAMOUNTINPOSCRCY,
    VARIATIONMARGINAMTINVALNCRCY,
    WBSELEMENTEXTERNALID,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (COMPANYCODE, FINANCIALTRANSACTION, SECURITYACCOUNT, SECURITYCLASS)
);