Powered by InfoCaptor


Previous Page   Next Page

Pricing Modifier Lines
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.QPFG_MODIFIER_LINESUnknown
NoneNone.QPFG_MODIFIER_LINESUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Accrual Conversion Rate Pricing Modifier Lines.Accrual Conversion RateACCRUAL_CONVERSION_RATEACCRUAL_CONVERSION_RATE114328
Accrual Flag Pricing Modifier Lines.Accrual FlagACCRUAL_FLAGACCRUAL_FLAG114331
Accum Attr Run Src Flag Pricing Modifier Lines.Accum Attr Run Src FlagACCUM_ATTR_RUN_SRC_FLAGACCUM_ATTR_RUN_SRC_FLAG114452
Accum Attribute Pricing Modifier Lines.Accum AttributeACCUM_ATTRIBUTEACCUM_ATTRIBUTE114451
Accum Context Pricing Modifier Lines.Accum ContextACCUM_CONTEXTACCUM_CONTEXT114453
Arithmetic Operator Pricing Modifier Lines.Arithmetic OperatorARITHMETIC_OPERATORARITHMETIC_OPERATOR116439
Arithmetic Operator 1 Pricing Modifier Lines.Arithmetic Operator 1ARITHMETIC_OPERATOR_1ARITHMETIC_OPERATOR_1272744
Benefit Qty Pricing Modifier Lines.Benefit QtyBENEFIT_QTYBENEFIT_QTY119515
Benefit UOM Code Pricing Modifier Lines.Benefit UOM CodeBENEFIT_UOM_CODEBENEFIT_UOM_CODE119517
Benefit UOM Name Pricing Modifier Lines.Benefit UOM NameBENEFIT_UOM_NAMEBENEFIT_UOM_NAME119519
Charge Subtype Code Pricing Modifier Lines.Charge Subtype CodeCHARGE_SUBTYPE_CODECHARGE_SUBTYPE_CODE121934
Charge Type Code Pricing Modifier Lines.Charge Type CodeCHARGE_TYPE_CODECHARGE_TYPE_CODE121938
Charge Type Code 1 Pricing Modifier Lines.Charge Type Code 1CHARGE_TYPE_CODE_1CHARGE_TYPE_CODE_1272746
Created By Pricing Modifier Lines.Created ByCREATED_BYCREATED_BY124659
Creation Date Pricing Modifier Lines.Creation DateCREATION_DATECREATION_DATE126085
End Date Active Pricing Modifier Lines.End Date ActiveEND_DATE_ACTIVEEND_DATE_ACTIVE132919
End Date Active - Day Pricing Modifier Lines.End Date Active END_DATE_ACTIVE_DAY178305
End Date Active - Month Pricing Modifier Lines.End Date Active END_DATE_ACTIVE_MONTH178347
End Date Active - Quarter Pricing Modifier Lines.End Date Active END_DATE_ACTIVE_QUARTER178381
End Date Active - Year Pricing Modifier Lines.End Date Active END_DATE_ACTIVE_YEAR178423
Estimated Accrual Rate Pricing Modifier Lines.Estimated Accrual RateESTIM_ACCRUAL_RATEESTIM_ACCRUAL_RATE133558
Expiration DateThe date on which the agreement expires.Pricing Modifier Lines.Expiration DateEXPIRATION_DATEEXPIRATION_DATE134090
Expiration Date - Day Pricing Modifier Lines.Expiration Date EXPIRATION_DATE_DAY179305
Expiration Date - Month Pricing Modifier Lines.Expiration Date EXPIRATION_DATE_MONTH179323
Expiration Date - Quarter Pricing Modifier Lines.Expiration Date EXPIRATION_DATE_QUARTER179341
Expiration Date - Year Pricing Modifier Lines.Expiration Date EXPIRATION_DATE_YEAR179359
Expiration Period Start Date Pricing Modifier Lines.Expiration Period Start DateEXPIRATION_PERIOD_START_DATEEXPIRATION_PERIOD_START_DATE134096
Expiration Period Start Date - Day Pricing Modifier Lines.Expiration Period Start Date EXPIRATION_PERIOD_START_DATE_DAY179365
Expiration Period Start Date - Month Pricing Modifier Lines.Expiration Period Start Date EXPIRATION_PERIOD_START_DATE_MONTH179369
Expiration Period Start Date - Quarter Pricing Modifier Lines.Expiration Period Start Date EXPIRATION_PERIOD_START_DATE_QUARTER179373
Expiration Period Start Date - Year Pricing Modifier Lines.Expiration Period Start Date EXPIRATION_PERIOD_START_DATE_YEAR179377
Expiration Period UOM Pricing Modifier Lines.Expiration Period UOMEXPIRATION_PERIOD_UOMEXPIRATION_PERIOD_UOM134098
Expiration Period UOM Name Pricing Modifier Lines.Expiration Period UOM NameEXP_PERIOD_UOM_NAMEEXP_PERIOD_UOM_NAME134124
Incompatibility Group Code Pricing Modifier Lines.Incompatibility Group CodeINCOMPATIBILITY_GRP_CODEINCOMPATIBILITY_GRP_CODE136244
Incompatibility Grp Code 1 Pricing Modifier Lines.Incompatibility Grp Code 1INCOMPATIBILITY_GRP_CODE_1INCOMPATIBILITY_GRP_CODE_1272747
Last Update Date Pricing Modifier Lines.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140621
Last Updated By Pricing Modifier Lines.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139284
List Header ID Pricing Modifier Lines.List Header IDLIST_HEADER_IDLIST_HEADER_ID144844
List Line ID Pricing Modifier Lines.List Line IDLIST_LINE_IDLIST_LINE_ID144860
List Line Number Pricing Modifier Lines.List Line NumberLIST_LINE_NOLIST_LINE_NO144866
List Line Type Code Pricing Modifier Lines.List Line Type CodeLIST_LINE_TYPE_CODELIST_LINE_TYPE_CODE144872
List Line Type Code 1 Pricing Modifier Lines.List Line Type Code 1LIST_LINE_TYPE_CODE_1LIST_LINE_TYPE_CODE_1272748
Modifier Level Code Pricing Modifier Lines.Modifier Level CodeMODIFIER_LEVEL_CODEMODIFIER_LEVEL_CODE147421
Modifier Level Code 1 Pricing Modifier Lines.Modifier Level Code 1MODIFIER_LEVEL_CODE_1MODIFIER_LEVEL_CODE_1272750
Net Amount Flag Pricing Modifier Lines.Net Amount FlagNET_AMOUNT_FLAGNET_AMOUNT_FLAG147954
Number Expiration Periods Pricing Modifier Lines.Number Expiration PeriodsNUMBER_EXPIRATION_PERIODSNUMBER_EXPIRATION_PERIODS148702
Operand Pricing Modifier Lines.OperandOPERANDOPERAND149486
Orig Sys Header Ref Pricing Modifier Lines.Orig Sys Header RefORIG_SYS_HEADER_REFORIG_SYS_HEADER_REF151516
Orig Sys Line Ref Pricing Modifier Lines.Orig Sys Line RefORIG_SYS_LINE_REFORIG_SYS_LINE_REF151530
Override Flag Pricing Modifier Lines.Override FlagOVERRIDE_FLAGOVERRIDE_FLAG151711
Price Break Type Code Pricing Modifier Lines.Price Break Type CodePRICE_BREAK_TYPE_CODEPRICE_BREAK_TYPE_CODE155317
Price Break Type Code 1 Pricing Modifier Lines.Price Break Type Code 1PRICE_BREAK_TYPE_CODE_1PRICE_BREAK_TYPE_CODE_1272749
Price By Formula ID Pricing Modifier Lines.Price By Formula IDPRICE_BY_FORMULA_IDPRICE_BY_FORMULA_ID155319
Pricing Group Sequence Pricing Modifier Lines.Pricing Group SequencePRICING_GROUP_SEQUENCEPRICING_GROUP_SEQUENCE155459
Pricing Group Sequence 1 Pricing Modifier Lines.Pricing Group Sequence 1PRICING_GROUP_SEQUENCE_1PRICING_GROUP_SEQUENCE_1272743
Pricing Phase ID Pricing Modifier Lines.Pricing Phase IDPRICING_PHASE_IDPRICING_PHASE_ID155463
Primary UOM Flag Pricing Modifier Lines.Primary UOM FlagPRIMARY_UOM_FLAGPRIMARY_UOM_FLAG155608
Product Precedence Pricing Modifier Lines.Product PrecedencePRODUCT_PRECEDENCEPRODUCT_PRECEDENCE155981
Rebate Transaction Type Pricing Modifier Lines.Rebate Transaction TypeREBATE_TRANSACTION_TYPEREBATE_TRANSACTION_TYPE157965
Rebate Transaction Type 1 Pricing Modifier Lines.Rebate Transaction Type 1REBATE_TRANSACTION_TYPE_1REBATE_TRANSACTION_TYPE_1272745
Start Date Active Pricing Modifier Lines.Start Date ActiveSTART_DATE_ACTIVESTART_DATE_ACTIVE163079
Start Date Active - Day Pricing Modifier Lines.Start Date Active START_DATE_ACTIVE_DAY190801
Start Date Active - Month Pricing Modifier Lines.Start Date Active START_DATE_ACTIVE_MONTH190843
Start Date Active - Quarter Pricing Modifier Lines.Start Date Active START_DATE_ACTIVE_QUARTER190877
Start Date Active - Year Pricing Modifier Lines.Start Date Active START_DATE_ACTIVE_YEAR190919
Accrual Conversion Rate Pricing Modifier Lines.Accrual Conversion RateACCRUAL_CONVERSION_RATEACCRUAL_CONVERSION_RATE114328
Accrual Flag Pricing Modifier Lines.Accrual FlagACCRUAL_FLAGACCRUAL_FLAG114331
Accum Attr Run Src Flag Pricing Modifier Lines.Accum Attr Run Src FlagACCUM_ATTR_RUN_SRC_FLAGACCUM_ATTR_RUN_SRC_FLAG114452
Accum Attribute Pricing Modifier Lines.Accum AttributeACCUM_ATTRIBUTEACCUM_ATTRIBUTE114451
Accum Context Pricing Modifier Lines.Accum ContextACCUM_CONTEXTACCUM_CONTEXT114453
Arithmetic Operator Pricing Modifier Lines.Arithmetic OperatorARITHMETIC_OPERATORARITHMETIC_OPERATOR116439
Arithmetic Operator 1 Pricing Modifier Lines.Arithmetic Operator 1ARITHMETIC_OPERATOR_1ARITHMETIC_OPERATOR_1272744
Benefit Qty Pricing Modifier Lines.Benefit QtyBENEFIT_QTYBENEFIT_QTY119515
Benefit UOM Code Pricing Modifier Lines.Benefit UOM CodeBENEFIT_UOM_CODEBENEFIT_UOM_CODE119517
Benefit UOM Name Pricing Modifier Lines.Benefit UOM NameBENEFIT_UOM_NAMEBENEFIT_UOM_NAME119519
Charge Subtype Code Pricing Modifier Lines.Charge Subtype CodeCHARGE_SUBTYPE_CODECHARGE_SUBTYPE_CODE121934
Charge Type Code Pricing Modifier Lines.Charge Type CodeCHARGE_TYPE_CODECHARGE_TYPE_CODE121938
Charge Type Code 1 Pricing Modifier Lines.Charge Type Code 1CHARGE_TYPE_CODE_1CHARGE_TYPE_CODE_1272746
Created By Pricing Modifier Lines.Created ByCREATED_BYCREATED_BY124659
Creation Date Pricing Modifier Lines.Creation DateCREATION_DATECREATION_DATE126085
End Date Active Pricing Modifier Lines.End Date ActiveEND_DATE_ACTIVEEND_DATE_ACTIVE132919
End Date Active - Day Pricing Modifier Lines.End Date Active END_DATE_ACTIVE_DAY178305
End Date Active - Month Pricing Modifier Lines.End Date Active END_DATE_ACTIVE_MONTH178347
End Date Active - Quarter Pricing Modifier Lines.End Date Active END_DATE_ACTIVE_QUARTER178381
End Date Active - Year Pricing Modifier Lines.End Date Active END_DATE_ACTIVE_YEAR178423
Estimated Accrual Rate Pricing Modifier Lines.Estimated Accrual RateESTIM_ACCRUAL_RATEESTIM_ACCRUAL_RATE133558
Expiration DateThe date on which the agreement expires.Pricing Modifier Lines.Expiration DateEXPIRATION_DATEEXPIRATION_DATE134090
Expiration Date - Day Pricing Modifier Lines.Expiration Date EXPIRATION_DATE_DAY179305
Expiration Date - Month Pricing Modifier Lines.Expiration Date EXPIRATION_DATE_MONTH179323
Expiration Date - Quarter Pricing Modifier Lines.Expiration Date EXPIRATION_DATE_QUARTER179341
Expiration Date - Year Pricing Modifier Lines.Expiration Date EXPIRATION_DATE_YEAR179359
Expiration Period Start Date Pricing Modifier Lines.Expiration Period Start DateEXPIRATION_PERIOD_START_DATEEXPIRATION_PERIOD_START_DATE134096
Expiration Period Start Date - Day Pricing Modifier Lines.Expiration Period Start Date EXPIRATION_PERIOD_START_DATE_DAY179365
Expiration Period Start Date - Month Pricing Modifier Lines.Expiration Period Start Date EXPIRATION_PERIOD_START_DATE_MONTH179369
Expiration Period Start Date - Quarter Pricing Modifier Lines.Expiration Period Start Date EXPIRATION_PERIOD_START_DATE_QUARTER179373
Expiration Period Start Date - Year Pricing Modifier Lines.Expiration Period Start Date EXPIRATION_PERIOD_START_DATE_YEAR179377
Expiration Period UOM Pricing Modifier Lines.Expiration Period UOMEXPIRATION_PERIOD_UOMEXPIRATION_PERIOD_UOM134098
Expiration Period UOM Name Pricing Modifier Lines.Expiration Period UOM NameEXP_PERIOD_UOM_NAMEEXP_PERIOD_UOM_NAME134124
Incompatibility Group Code Pricing Modifier Lines.Incompatibility Group CodeINCOMPATIBILITY_GRP_CODEINCOMPATIBILITY_GRP_CODE136244
Incompatibility Grp Code 1 Pricing Modifier Lines.Incompatibility Grp Code 1INCOMPATIBILITY_GRP_CODE_1INCOMPATIBILITY_GRP_CODE_1272747
Last Update Date Pricing Modifier Lines.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140621
Last Updated By Pricing Modifier Lines.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139284
List Header ID Pricing Modifier Lines.List Header IDLIST_HEADER_IDLIST_HEADER_ID144844
List Line ID Pricing Modifier Lines.List Line IDLIST_LINE_IDLIST_LINE_ID144860
List Line Number Pricing Modifier Lines.List Line NumberLIST_LINE_NOLIST_LINE_NO144866
List Line Type Code Pricing Modifier Lines.List Line Type CodeLIST_LINE_TYPE_CODELIST_LINE_TYPE_CODE144872
List Line Type Code 1 Pricing Modifier Lines.List Line Type Code 1LIST_LINE_TYPE_CODE_1LIST_LINE_TYPE_CODE_1272748
Modifier Level Code Pricing Modifier Lines.Modifier Level CodeMODIFIER_LEVEL_CODEMODIFIER_LEVEL_CODE147421
Modifier Level Code 1 Pricing Modifier Lines.Modifier Level Code 1MODIFIER_LEVEL_CODE_1MODIFIER_LEVEL_CODE_1272750
Net Amount Flag Pricing Modifier Lines.Net Amount FlagNET_AMOUNT_FLAGNET_AMOUNT_FLAG147954
Number Expiration Periods Pricing Modifier Lines.Number Expiration PeriodsNUMBER_EXPIRATION_PERIODSNUMBER_EXPIRATION_PERIODS148702
Operand Pricing Modifier Lines.OperandOPERANDOPERAND149486
Orig Sys Header Ref Pricing Modifier Lines.Orig Sys Header RefORIG_SYS_HEADER_REFORIG_SYS_HEADER_REF151516
Orig Sys Line Ref Pricing Modifier Lines.Orig Sys Line RefORIG_SYS_LINE_REFORIG_SYS_LINE_REF151530
Override Flag Pricing Modifier Lines.Override FlagOVERRIDE_FLAGOVERRIDE_FLAG151711
Price Break Type Code Pricing Modifier Lines.Price Break Type CodePRICE_BREAK_TYPE_CODEPRICE_BREAK_TYPE_CODE155317
Price Break Type Code 1 Pricing Modifier Lines.Price Break Type Code 1PRICE_BREAK_TYPE_CODE_1PRICE_BREAK_TYPE_CODE_1272749
Price By Formula ID Pricing Modifier Lines.Price By Formula IDPRICE_BY_FORMULA_IDPRICE_BY_FORMULA_ID155319
Pricing Group Sequence Pricing Modifier Lines.Pricing Group SequencePRICING_GROUP_SEQUENCEPRICING_GROUP_SEQUENCE155459
Pricing Group Sequence 1 Pricing Modifier Lines.Pricing Group Sequence 1PRICING_GROUP_SEQUENCE_1PRICING_GROUP_SEQUENCE_1272743
Pricing Phase ID Pricing Modifier Lines.Pricing Phase IDPRICING_PHASE_IDPRICING_PHASE_ID155463
Primary UOM Flag Pricing Modifier Lines.Primary UOM FlagPRIMARY_UOM_FLAGPRIMARY_UOM_FLAG155608
Product Precedence Pricing Modifier Lines.Product PrecedencePRODUCT_PRECEDENCEPRODUCT_PRECEDENCE155981
Rebate Transaction Type Pricing Modifier Lines.Rebate Transaction TypeREBATE_TRANSACTION_TYPEREBATE_TRANSACTION_TYPE157965
Rebate Transaction Type 1 Pricing Modifier Lines.Rebate Transaction Type 1REBATE_TRANSACTION_TYPE_1REBATE_TRANSACTION_TYPE_1272745
Start Date Active Pricing Modifier Lines.Start Date ActiveSTART_DATE_ACTIVESTART_DATE_ACTIVE163079
Start Date Active - Day Pricing Modifier Lines.Start Date Active START_DATE_ACTIVE_DAY190801
Start Date Active - Month Pricing Modifier Lines.Start Date Active START_DATE_ACTIVE_MONTH190843
Start Date Active - Quarter Pricing Modifier Lines.Start Date Active START_DATE_ACTIVE_QUARTER190877
Start Date Active - Year Pricing Modifier Lines.Start Date Active START_DATE_ACTIVE_YEAR190919
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Pricing Modifier Lines -> Benefit ProductsPricing Modifier Lines.List Line ID = Benefit Products.List Line IDAlways exist in master folderNoneNo
Pricing Modifier Lines -> Excluded ProductsPricing Modifier Lines.List Line ID = Excluded Products.List Line IDAlways exist in master folderNoneNo
Pricing Modifier Lines -> Factor List Associated Pricing AttributesPricing Modifier Lines.List Line ID = Factor List Associated Pricing Attributes.List Line IDAlways exist in master folderNoneNo
Pricing Modifier Lines -> Factor List Base Pricing AttributesPricing Modifier Lines.List Line ID = Factor List Base Pricing Attributes.List Line IDAlways exist in master folderNoneNo
Pricing Modifier Lines -> Pricing AttributesPricing Modifier Lines.List Line ID = Pricing Attributes.List Line IDAlways exist in master folderNoneNo
Pricing Modifier Lines -> Pricing Formula LinesPricing Modifier Lines.List Line ID = Pricing Formula Lines.Price List Line IDAlways exist in master folderNoneNo
Pricing Modifier Lines -> Pricing QualifiersPricing Modifier Lines.List Line ID = Pricing Qualifiers.List Line IDAlways exist in master folderNoneNo
Pricing Modifier Lines -> ProductsPricing Modifier Lines.List Line ID = Products.List Line IDAlways exist in master folderNoneNo