Powered by InfoCaptor


Previous Page   Next Page

Coupon Issues
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.QPFG_COUPON_ISSUESUnknown
NoneNone.QPFG_COUPON_ISSUESUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Accrual Conversion Rate Coupon Issues.Accrual Conversion RateACCRUAL_CONVERSION_RATEACCRUAL_CONVERSION_RATE114327
Accrual Flag Coupon Issues.Accrual FlagACCRUAL_FLAGACCRUAL_FLAG114330
Benefit Modifier Line ID Coupon Issues.Benefit Modifier Line IDBENEFIT_MODIFIER_LINE_IDBENEFIT_MODIFIER_LINE_ID119511
Created By Coupon Issues.Created ByCREATED_BYCREATED_BY124646
Creation Date Coupon Issues.Creation DateCREATION_DATECREATION_DATE126072
End Date Active Coupon Issues.End Date ActiveEND_DATE_ACTIVEEND_DATE_ACTIVE132910
End Date Active - Day Coupon Issues.End Date Active END_DATE_ACTIVE_DAY178287
End Date Active - Month Coupon Issues.End Date Active END_DATE_ACTIVE_MONTH178329
End Date Active - Quarter Coupon Issues.End Date Active END_DATE_ACTIVE_QUARTER178363
End Date Active - Year Coupon Issues.End Date Active END_DATE_ACTIVE_YEAR178405
Estimated GL Value Coupon Issues.Estimated GL ValueESTIM_GL_VALUEESTIM_GL_VALUE133559
Expiration DateThe date on which the agreement expires.Coupon Issues.Expiration DateEXPIRATION_DATEEXPIRATION_DATE134089
Expiration Date - Day Coupon Issues.Expiration Date EXPIRATION_DATE_DAY179303
Expiration Date - Month Coupon Issues.Expiration Date EXPIRATION_DATE_MONTH179321
Expiration Date - Quarter Coupon Issues.Expiration Date EXPIRATION_DATE_QUARTER179339
Expiration Date - Year Coupon Issues.Expiration Date EXPIRATION_DATE_YEAR179357
Expiration Period Start Date Coupon Issues.Expiration Period Start DateEXPIRATION_PERIOD_START_DATEEXPIRATION_PERIOD_START_DATE134095
Expiration Period Start Date - Day Coupon Issues.Expiration Period Start Date EXPIRATION_PERIOD_START_DATE_DAY179363
Expiration Period Start Date - Month Coupon Issues.Expiration Period Start Date EXPIRATION_PERIOD_START_DATE_MONTH179367
Expiration Period Start Date - Quarter Coupon Issues.Expiration Period Start Date EXPIRATION_PERIOD_START_DATE_QUARTER179371
Expiration Period Start Date - Year Coupon Issues.Expiration Period Start Date EXPIRATION_PERIOD_START_DATE_YEAR179375
Expiration Period UOM Coupon Issues.Expiration Period UOMEXPIRATION_PERIOD_UOMEXPIRATION_PERIOD_UOM134097
Incompatibility Group Code Coupon Issues.Incompatibility Group CodeINCOMPATIBILITY_GRP_CODEINCOMPATIBILITY_GRP_CODE136242
Incompatibility Grp Code 1 Coupon Issues.Incompatibility Grp Code 1INCOMPATIBILITY_GRP_CODE_1INCOMPATIBILITY_GRP_CODE_1272706
Last Update Date Coupon Issues.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140608
Last Updated By Coupon Issues.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139271
List Header ID Coupon Issues.List Header IDLIST_HEADER_IDLIST_HEADER_ID144836
List Line ID Coupon Issues.List Line IDLIST_LINE_IDLIST_LINE_ID144853
List Line Number Coupon Issues.List Line NumberLIST_LINE_NOLIST_LINE_NO144864
List Line Type Code Coupon Issues.List Line Type CodeLIST_LINE_TYPE_CODELIST_LINE_TYPE_CODE144868
List Line Type Code 1 Coupon Issues.List Line Type Code 1LIST_LINE_TYPE_CODE_1LIST_LINE_TYPE_CODE_1272707
Modifier Level Code Coupon Issues.Modifier Level CodeMODIFIER_LEVEL_CODEMODIFIER_LEVEL_CODE147419
Modifier Level Code 1 Coupon Issues.Modifier Level Code 1MODIFIER_LEVEL_CODE_1MODIFIER_LEVEL_CODE_1272709
Number Expiration Periods Coupon Issues.Number Expiration PeriodsNUMBER_EXPIRATION_PERIODSNUMBER_EXPIRATION_PERIODS148701
Orig Sys Header Ref Coupon Issues.Orig Sys Header RefORIG_SYS_HEADER_REFORIG_SYS_HEADER_REF151509
Orig Sys Line Ref Coupon Issues.Orig Sys Line RefORIG_SYS_LINE_REFORIG_SYS_LINE_REF151522
Price Break Type Code Coupon Issues.Price Break Type CodePRICE_BREAK_TYPE_CODEPRICE_BREAK_TYPE_CODE155315
Price Break Type Code 1 Coupon Issues.Price Break Type Code 1PRICE_BREAK_TYPE_CODE_1PRICE_BREAK_TYPE_CODE_1272708
Pricing Group Sequence Coupon Issues.Pricing Group SequencePRICING_GROUP_SEQUENCEPRICING_GROUP_SEQUENCE155458
Pricing Phase ID Coupon Issues.Pricing Phase IDPRICING_PHASE_IDPRICING_PHASE_ID155460
Product Precedence Coupon Issues.Product PrecedencePRODUCT_PRECEDENCEPRODUCT_PRECEDENCE155978
Start Date Active Coupon Issues.Start Date ActiveSTART_DATE_ACTIVESTART_DATE_ACTIVE163070
Start Date Active - Day Coupon Issues.Start Date Active START_DATE_ACTIVE_DAY190783
Start Date Active - Month Coupon Issues.Start Date Active START_DATE_ACTIVE_MONTH190825
Start Date Active - Quarter Coupon Issues.Start Date Active START_DATE_ACTIVE_QUARTER190859
Start Date Active - Year Coupon Issues.Start Date Active START_DATE_ACTIVE_YEAR190901
UOM Name Coupon Issues.UOM NameUOM_NAMEUOM_NAME166438
Accrual Conversion Rate Coupon Issues.Accrual Conversion RateACCRUAL_CONVERSION_RATEACCRUAL_CONVERSION_RATE114327
Accrual Flag Coupon Issues.Accrual FlagACCRUAL_FLAGACCRUAL_FLAG114330
Benefit Modifier Line ID Coupon Issues.Benefit Modifier Line IDBENEFIT_MODIFIER_LINE_IDBENEFIT_MODIFIER_LINE_ID119511
Created By Coupon Issues.Created ByCREATED_BYCREATED_BY124646
Creation Date Coupon Issues.Creation DateCREATION_DATECREATION_DATE126072
End Date Active Coupon Issues.End Date ActiveEND_DATE_ACTIVEEND_DATE_ACTIVE132910
End Date Active - Day Coupon Issues.End Date Active END_DATE_ACTIVE_DAY178287
End Date Active - Month Coupon Issues.End Date Active END_DATE_ACTIVE_MONTH178329
End Date Active - Quarter Coupon Issues.End Date Active END_DATE_ACTIVE_QUARTER178363
End Date Active - Year Coupon Issues.End Date Active END_DATE_ACTIVE_YEAR178405
Estimated GL Value Coupon Issues.Estimated GL ValueESTIM_GL_VALUEESTIM_GL_VALUE133559
Expiration DateThe date on which the agreement expires.Coupon Issues.Expiration DateEXPIRATION_DATEEXPIRATION_DATE134089
Expiration Date - Day Coupon Issues.Expiration Date EXPIRATION_DATE_DAY179303
Expiration Date - Month Coupon Issues.Expiration Date EXPIRATION_DATE_MONTH179321
Expiration Date - Quarter Coupon Issues.Expiration Date EXPIRATION_DATE_QUARTER179339
Expiration Date - Year Coupon Issues.Expiration Date EXPIRATION_DATE_YEAR179357
Expiration Period Start Date Coupon Issues.Expiration Period Start DateEXPIRATION_PERIOD_START_DATEEXPIRATION_PERIOD_START_DATE134095
Expiration Period Start Date - Day Coupon Issues.Expiration Period Start Date EXPIRATION_PERIOD_START_DATE_DAY179363
Expiration Period Start Date - Month Coupon Issues.Expiration Period Start Date EXPIRATION_PERIOD_START_DATE_MONTH179367
Expiration Period Start Date - Quarter Coupon Issues.Expiration Period Start Date EXPIRATION_PERIOD_START_DATE_QUARTER179371
Expiration Period Start Date - Year Coupon Issues.Expiration Period Start Date EXPIRATION_PERIOD_START_DATE_YEAR179375
Expiration Period UOM Coupon Issues.Expiration Period UOMEXPIRATION_PERIOD_UOMEXPIRATION_PERIOD_UOM134097
Incompatibility Group Code Coupon Issues.Incompatibility Group CodeINCOMPATIBILITY_GRP_CODEINCOMPATIBILITY_GRP_CODE136242
Incompatibility Grp Code 1 Coupon Issues.Incompatibility Grp Code 1INCOMPATIBILITY_GRP_CODE_1INCOMPATIBILITY_GRP_CODE_1272706
Last Update Date Coupon Issues.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140608
Last Updated By Coupon Issues.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139271
List Header ID Coupon Issues.List Header IDLIST_HEADER_IDLIST_HEADER_ID144836
List Line ID Coupon Issues.List Line IDLIST_LINE_IDLIST_LINE_ID144853
List Line Number Coupon Issues.List Line NumberLIST_LINE_NOLIST_LINE_NO144864
List Line Type Code Coupon Issues.List Line Type CodeLIST_LINE_TYPE_CODELIST_LINE_TYPE_CODE144868
List Line Type Code 1 Coupon Issues.List Line Type Code 1LIST_LINE_TYPE_CODE_1LIST_LINE_TYPE_CODE_1272707
Modifier Level Code Coupon Issues.Modifier Level CodeMODIFIER_LEVEL_CODEMODIFIER_LEVEL_CODE147419
Modifier Level Code 1 Coupon Issues.Modifier Level Code 1MODIFIER_LEVEL_CODE_1MODIFIER_LEVEL_CODE_1272709
Number Expiration Periods Coupon Issues.Number Expiration PeriodsNUMBER_EXPIRATION_PERIODSNUMBER_EXPIRATION_PERIODS148701
Orig Sys Header Ref Coupon Issues.Orig Sys Header RefORIG_SYS_HEADER_REFORIG_SYS_HEADER_REF151509
Orig Sys Line Ref Coupon Issues.Orig Sys Line RefORIG_SYS_LINE_REFORIG_SYS_LINE_REF151522
Price Break Type Code Coupon Issues.Price Break Type CodePRICE_BREAK_TYPE_CODEPRICE_BREAK_TYPE_CODE155315
Price Break Type Code 1 Coupon Issues.Price Break Type Code 1PRICE_BREAK_TYPE_CODE_1PRICE_BREAK_TYPE_CODE_1272708
Pricing Group Sequence Coupon Issues.Pricing Group SequencePRICING_GROUP_SEQUENCEPRICING_GROUP_SEQUENCE155458
Pricing Phase ID Coupon Issues.Pricing Phase IDPRICING_PHASE_IDPRICING_PHASE_ID155460
Product Precedence Coupon Issues.Product PrecedencePRODUCT_PRECEDENCEPRODUCT_PRECEDENCE155978
Start Date Active Coupon Issues.Start Date ActiveSTART_DATE_ACTIVESTART_DATE_ACTIVE163070
Start Date Active - Day Coupon Issues.Start Date Active START_DATE_ACTIVE_DAY190783
Start Date Active - Month Coupon Issues.Start Date Active START_DATE_ACTIVE_MONTH190825
Start Date Active - Quarter Coupon Issues.Start Date Active START_DATE_ACTIVE_QUARTER190859
Start Date Active - Year Coupon Issues.Start Date Active START_DATE_ACTIVE_YEAR190901
UOM Name Coupon Issues.UOM NameUOM_NAMEUOM_NAME166438
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Coupon Issues -> Benefit ProductsCoupon Issues.List Line ID = Benefit Products.List Line IDAlways exist in master folderNoneNo
Coupon Issues -> Excluded ProductsCoupon Issues.List Line ID = Excluded Products.List Line IDAlways exist in master folderNoneNo
Coupon Issues -> Factor List Associated Pricing AttributesCoupon Issues.List Line ID = Factor List Associated Pricing Attributes.List Line IDAlways exist in master folderNoneNo
Coupon Issues -> Factor List Base Pricing AttributesCoupon Issues.List Line ID = Factor List Base Pricing Attributes.List Line IDAlways exist in master folderNoneNo
Coupon Issues -> Pricing AttributesCoupon Issues.List Line ID = Pricing Attributes.List Line IDAlways exist in master folderNoneNo
Coupon Issues -> Pricing Formula LinesCoupon Issues.List Line ID = Pricing Formula Lines.Price List Line IDAlways exist in master folderNoneNo
Coupon Issues -> Pricing QualifiersCoupon Issues.List Line ID = Pricing Qualifiers.List Line IDAlways exist in master folderNoneNo
Coupon Issues -> ProductsCoupon Issues.List Line ID = Products.List Line IDAlways exist in master folderNoneNo