Powered by InfoCaptor


Previous Page   Next Page

Deal and Promotion Headers
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.QPFG_PROMOTION_HEADERSUnknown
NoneNone.QPFG_PROMOTION_HEADERSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Active Date First Type Deal and Promotion Headers.Active Date First TypeACTIVE_DATE_FIRST_TYPEACTIVE_DATE_FIRST_TYPE114569
Active Date First Type 1 Deal and Promotion Headers.Active Date First Type 1ACTIVE_DATE_FIRST_TYPE_1ACTIVE_DATE_FIRST_TYPE_1272712
Active Date Second Type Deal and Promotion Headers.Active Date Second TypeACTIVE_DATE_SECOND_TYPEACTIVE_DATE_SECOND_TYPE114570
Active Date Second Type 1 Deal and Promotion Headers.Active Date Second Type 1ACTIVE_DATE_SECOND_TYPE_1ACTIVE_DATE_SECOND_TYPE_1272713
Active Flag Deal and Promotion Headers.Active FlagACTIVE_FLAGACTIVE_FLAG114573
Ask For Flag Deal and Promotion Headers.Ask For FlagASK_FOR_FLAGASK_FOR_FLAG116489
Automatic Flag Deal and Promotion Headers.Automatic FlagAUTOMATIC_FLAGAUTOMATIC_FLAG118636
Context Value Deal and Promotion Headers.Context ValueCONTEXT_VALUECONTEXT_VALUE272714
Created By Deal and Promotion Headers.Created ByCREATED_BYCREATED_BY124647
Creation Date Deal and Promotion Headers.Creation DateCREATION_DATECREATION_DATE126073
Currency CodeCurrency code for pricelist; FK to gl_curr_mst.Deal and Promotion Headers.Currency CodeCURRENCY_CODECURRENCY_CODE127014
Currency Name Deal and Promotion Headers.Currency NameCURRENCY_NAMECURRENCY_NAME127233
DescriptionThe accounting period description.Deal and Promotion Headers.DescriptionDESCRIPTIONDESCRIPTION129594
End Date Active Deal and Promotion Headers.End Date ActiveEND_DATE_ACTIVEEND_DATE_ACTIVE132911
End Date Active - Day Deal and Promotion Headers.End Date Active END_DATE_ACTIVE_DAY178289
End Date Active - Month Deal and Promotion Headers.End Date Active END_DATE_ACTIVE_MONTH178331
End Date Active - Quarter Deal and Promotion Headers.End Date Active END_DATE_ACTIVE_QUARTER178365
End Date Active - Year Deal and Promotion Headers.End Date Active END_DATE_ACTIVE_YEAR178407
End Date Active First Deal and Promotion Headers.End Date Active FirstEND_DATE_ACTIVE_FIRSTEND_DATE_ACTIVE_FIRST133072
End Date Active First - Day Deal and Promotion Headers.End Date Active First END_DATE_ACTIVE_FIRST_DAY178319
End Date Active First - Month Deal and Promotion Headers.End Date Active First END_DATE_ACTIVE_FIRST_MONTH178321
End Date Active First - Quarter Deal and Promotion Headers.End Date Active First END_DATE_ACTIVE_FIRST_QUARTER178323
End Date Active First - Year Deal and Promotion Headers.End Date Active First END_DATE_ACTIVE_FIRST_YEAR178325
End Date Active Second Deal and Promotion Headers.End Date Active SecondEND_DATE_ACTIVE_SECONDEND_DATE_ACTIVE_SECOND133073
End Date Active Second - Day Deal and Promotion Headers.End Date Active Second END_DATE_ACTIVE_SECOND_DAY178395
End Date Active Second - Month Deal and Promotion Headers.End Date Active Second END_DATE_ACTIVE_SECOND_MONTH178397
End Date Active Second - Quarter Deal and Promotion Headers.End Date Active Second END_DATE_ACTIVE_SECOND_QUARTER178399
End Date Active Second - Year Deal and Promotion Headers.End Date Active Second END_DATE_ACTIVE_SECOND_YEAR178401
Global Flag Deal and Promotion Headers.Global FlagGLOBAL_FLAGGLOBAL_FLAG135168
Last Update Date Deal and Promotion Headers.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140609
Last Updated By Deal and Promotion Headers.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139272
List Header ID Deal and Promotion Headers.List Header IDLIST_HEADER_IDLIST_HEADER_ID144837
List Source Code Deal and Promotion Headers.List Source CodeLIST_SOURCE_CODELIST_SOURCE_CODE144887
List Type Code Deal and Promotion Headers.List Type CodeLIST_TYPE_CODELIST_TYPE_CODE144892
List Type Code 1 Deal and Promotion Headers.List Type Code 1LIST_TYPE_CODE_1LIST_TYPE_CODE_1272710
NameName of the resource.Deal and Promotion Headers.NameNAMENAME147723
Orig Org Id Deal and Promotion Headers.Orig Org IdORIG_ORG_IDORIG_ORG_ID151375
Orig System Header Ref Deal and Promotion Headers.Orig System Header RefORIG_SYSTEM_HEADER_REFORIG_SYSTEM_HEADER_REF151479
Parent List Header ID Deal and Promotion Headers.Parent List Header IDPARENT_LIST_HEADER_IDPARENT_LIST_HEADER_ID151887
Primary DP Price List Deal and Promotion Headers.Primary DP Price ListPRIMARY_DP_PRICE_LISTPRIMARY_DP_PRICE_LIST272715
Promotion Number Deal and Promotion Headers.Promotion NumberPROMOTION_NUMBERPROMOTION_NUMBER156741
Pte Code Deal and Promotion Headers.Pte CodePTE_CODEPTE_CODE156978
Pte Code 1 Deal and Promotion Headers.Pte Code 1PTE_CODE_1PTE_CODE_1272716
Shareable Flag Deal and Promotion Headers.Shareable FlagSHAREABLE_FLAGSHAREABLE_FLAG161615
Source System Code Deal and Promotion Headers.Source System CodeSOURCE_SYSTEM_CODESOURCE_SYSTEM_CODE162568
Source System Code 1 Deal and Promotion Headers.Source System Code 1SOURCE_SYSTEM_CODE_1SOURCE_SYSTEM_CODE_1272711
Start Date Active Deal and Promotion Headers.Start Date ActiveSTART_DATE_ACTIVESTART_DATE_ACTIVE163071
Start Date Active - Day Deal and Promotion Headers.Start Date Active START_DATE_ACTIVE_DAY190785
Start Date Active - Month Deal and Promotion Headers.Start Date Active START_DATE_ACTIVE_MONTH190827
Start Date Active - Quarter Deal and Promotion Headers.Start Date Active START_DATE_ACTIVE_QUARTER190861
Start Date Active - Year Deal and Promotion Headers.Start Date Active START_DATE_ACTIVE_YEAR190903
Start Date Active First Deal and Promotion Headers.Start Date Active FirstSTART_DATE_ACTIVE_FIRSTSTART_DATE_ACTIVE_FIRST163234
Start Date Active First - Day Deal and Promotion Headers.Start Date Active First START_DATE_ACTIVE_FIRST_DAY190815
Start Date Active First - Month Deal and Promotion Headers.Start Date Active First START_DATE_ACTIVE_FIRST_MONTH190817
Start Date Active First - Quarter Deal and Promotion Headers.Start Date Active First START_DATE_ACTIVE_FIRST_QUARTER190819
Start Date Active First - Year Deal and Promotion Headers.Start Date Active First START_DATE_ACTIVE_FIRST_YEAR190821
Start Date Active Second Deal and Promotion Headers.Start Date Active SecondSTART_DATE_ACTIVE_SECONDSTART_DATE_ACTIVE_SECOND163235
Start Date Active Second - Day Deal and Promotion Headers.Start Date Active Second START_DATE_ACTIVE_SECOND_DAY190891
Start Date Active Second - Month Deal and Promotion Headers.Start Date Active Second START_DATE_ACTIVE_SECOND_MONTH190893
Start Date Active Second - Quarter Deal and Promotion Headers.Start Date Active Second START_DATE_ACTIVE_SECOND_QUARTER190895
Start Date Active Second - Year Deal and Promotion Headers.Start Date Active Second START_DATE_ACTIVE_SECOND_YEAR190897
Version Number Deal and Promotion Headers.Version NumberVERSION_NOVERSION_NO167493
Active Date First Type Deal and Promotion Headers.Active Date First TypeACTIVE_DATE_FIRST_TYPEACTIVE_DATE_FIRST_TYPE114569
Active Date First Type 1 Deal and Promotion Headers.Active Date First Type 1ACTIVE_DATE_FIRST_TYPE_1ACTIVE_DATE_FIRST_TYPE_1272712
Active Date Second Type Deal and Promotion Headers.Active Date Second TypeACTIVE_DATE_SECOND_TYPEACTIVE_DATE_SECOND_TYPE114570
Active Date Second Type 1 Deal and Promotion Headers.Active Date Second Type 1ACTIVE_DATE_SECOND_TYPE_1ACTIVE_DATE_SECOND_TYPE_1272713
Active Flag Deal and Promotion Headers.Active FlagACTIVE_FLAGACTIVE_FLAG114573
Ask For Flag Deal and Promotion Headers.Ask For FlagASK_FOR_FLAGASK_FOR_FLAG116489
Automatic Flag Deal and Promotion Headers.Automatic FlagAUTOMATIC_FLAGAUTOMATIC_FLAG118636
Context Value Deal and Promotion Headers.Context ValueCONTEXT_VALUECONTEXT_VALUE272714
Created By Deal and Promotion Headers.Created ByCREATED_BYCREATED_BY124647
Creation Date Deal and Promotion Headers.Creation DateCREATION_DATECREATION_DATE126073
Currency CodeCurrency code for pricelist; FK to gl_curr_mst.Deal and Promotion Headers.Currency CodeCURRENCY_CODECURRENCY_CODE127014
Currency Name Deal and Promotion Headers.Currency NameCURRENCY_NAMECURRENCY_NAME127233
DescriptionThe accounting period description.Deal and Promotion Headers.DescriptionDESCRIPTIONDESCRIPTION129594
End Date Active Deal and Promotion Headers.End Date ActiveEND_DATE_ACTIVEEND_DATE_ACTIVE132911
End Date Active - Day Deal and Promotion Headers.End Date Active END_DATE_ACTIVE_DAY178289
End Date Active - Month Deal and Promotion Headers.End Date Active END_DATE_ACTIVE_MONTH178331
End Date Active - Quarter Deal and Promotion Headers.End Date Active END_DATE_ACTIVE_QUARTER178365
End Date Active - Year Deal and Promotion Headers.End Date Active END_DATE_ACTIVE_YEAR178407
End Date Active First Deal and Promotion Headers.End Date Active FirstEND_DATE_ACTIVE_FIRSTEND_DATE_ACTIVE_FIRST133072
End Date Active First - Day Deal and Promotion Headers.End Date Active First END_DATE_ACTIVE_FIRST_DAY178319
End Date Active First - Month Deal and Promotion Headers.End Date Active First END_DATE_ACTIVE_FIRST_MONTH178321
End Date Active First - Quarter Deal and Promotion Headers.End Date Active First END_DATE_ACTIVE_FIRST_QUARTER178323
End Date Active First - Year Deal and Promotion Headers.End Date Active First END_DATE_ACTIVE_FIRST_YEAR178325
End Date Active Second Deal and Promotion Headers.End Date Active SecondEND_DATE_ACTIVE_SECONDEND_DATE_ACTIVE_SECOND133073
End Date Active Second - Day Deal and Promotion Headers.End Date Active Second END_DATE_ACTIVE_SECOND_DAY178395
End Date Active Second - Month Deal and Promotion Headers.End Date Active Second END_DATE_ACTIVE_SECOND_MONTH178397
End Date Active Second - Quarter Deal and Promotion Headers.End Date Active Second END_DATE_ACTIVE_SECOND_QUARTER178399
End Date Active Second - Year Deal and Promotion Headers.End Date Active Second END_DATE_ACTIVE_SECOND_YEAR178401
Global Flag Deal and Promotion Headers.Global FlagGLOBAL_FLAGGLOBAL_FLAG135168
Last Update Date Deal and Promotion Headers.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140609
Last Updated By Deal and Promotion Headers.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139272
List Header ID Deal and Promotion Headers.List Header IDLIST_HEADER_IDLIST_HEADER_ID144837
List Source Code Deal and Promotion Headers.List Source CodeLIST_SOURCE_CODELIST_SOURCE_CODE144887
List Type Code Deal and Promotion Headers.List Type CodeLIST_TYPE_CODELIST_TYPE_CODE144892
List Type Code 1 Deal and Promotion Headers.List Type Code 1LIST_TYPE_CODE_1LIST_TYPE_CODE_1272710
NameName of the resource.Deal and Promotion Headers.NameNAMENAME147723
Orig Org Id Deal and Promotion Headers.Orig Org IdORIG_ORG_IDORIG_ORG_ID151375
Orig System Header Ref Deal and Promotion Headers.Orig System Header RefORIG_SYSTEM_HEADER_REFORIG_SYSTEM_HEADER_REF151479
Parent List Header ID Deal and Promotion Headers.Parent List Header IDPARENT_LIST_HEADER_IDPARENT_LIST_HEADER_ID151887
Primary DP Price List Deal and Promotion Headers.Primary DP Price ListPRIMARY_DP_PRICE_LISTPRIMARY_DP_PRICE_LIST272715
Promotion Number Deal and Promotion Headers.Promotion NumberPROMOTION_NUMBERPROMOTION_NUMBER156741
Pte Code Deal and Promotion Headers.Pte CodePTE_CODEPTE_CODE156978
Pte Code 1 Deal and Promotion Headers.Pte Code 1PTE_CODE_1PTE_CODE_1272716
Shareable Flag Deal and Promotion Headers.Shareable FlagSHAREABLE_FLAGSHAREABLE_FLAG161615
Source System Code Deal and Promotion Headers.Source System CodeSOURCE_SYSTEM_CODESOURCE_SYSTEM_CODE162568
Source System Code 1 Deal and Promotion Headers.Source System Code 1SOURCE_SYSTEM_CODE_1SOURCE_SYSTEM_CODE_1272711
Start Date Active Deal and Promotion Headers.Start Date ActiveSTART_DATE_ACTIVESTART_DATE_ACTIVE163071
Start Date Active - Day Deal and Promotion Headers.Start Date Active START_DATE_ACTIVE_DAY190785
Start Date Active - Month Deal and Promotion Headers.Start Date Active START_DATE_ACTIVE_MONTH190827
Start Date Active - Quarter Deal and Promotion Headers.Start Date Active START_DATE_ACTIVE_QUARTER190861
Start Date Active - Year Deal and Promotion Headers.Start Date Active START_DATE_ACTIVE_YEAR190903
Start Date Active First Deal and Promotion Headers.Start Date Active FirstSTART_DATE_ACTIVE_FIRSTSTART_DATE_ACTIVE_FIRST163234
Start Date Active First - Day Deal and Promotion Headers.Start Date Active First START_DATE_ACTIVE_FIRST_DAY190815
Start Date Active First - Month Deal and Promotion Headers.Start Date Active First START_DATE_ACTIVE_FIRST_MONTH190817
Start Date Active First - Quarter Deal and Promotion Headers.Start Date Active First START_DATE_ACTIVE_FIRST_QUARTER190819
Start Date Active First - Year Deal and Promotion Headers.Start Date Active First START_DATE_ACTIVE_FIRST_YEAR190821
Start Date Active Second Deal and Promotion Headers.Start Date Active SecondSTART_DATE_ACTIVE_SECONDSTART_DATE_ACTIVE_SECOND163235
Start Date Active Second - Day Deal and Promotion Headers.Start Date Active Second START_DATE_ACTIVE_SECOND_DAY190891
Start Date Active Second - Month Deal and Promotion Headers.Start Date Active Second START_DATE_ACTIVE_SECOND_MONTH190893
Start Date Active Second - Quarter Deal and Promotion Headers.Start Date Active Second START_DATE_ACTIVE_SECOND_QUARTER190895
Start Date Active Second - Year Deal and Promotion Headers.Start Date Active Second START_DATE_ACTIVE_SECOND_YEAR190897
Version Number Deal and Promotion Headers.Version NumberVERSION_NOVERSION_NO167493
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Deal and Promotion Headers -> Coupon IssuesDeal and Promotion Headers.List Header ID = Coupon Issues.List Header IDAlways exist in master folderNoneNo
Deal and Promotion Headers -> Customer AgreementsDeal and Promotion Headers.List Header ID = Customer Agreements.Price List IDAlways exist in master folderNoneNo
Deal and Promotion Headers -> Order AgreementsDeal and Promotion Headers.List Header ID = Order Agreements.Price List IDAlways exist in master folderNoneNo
Deal and Promotion Headers -> Order HeadersDeal and Promotion Headers.List Header ID = Order Headers.Price List IDAlways exist in master folderNoneNo
Deal and Promotion Headers -> Price List LinesDeal and Promotion Headers.List Header ID = Price List Lines.List Header IDAlways exist in master folderNoneNo
Deal and Promotion Headers -> Pricing Formula LinesDeal and Promotion Headers.List Header ID = Pricing Formula Lines.Price Modifier List IDAlways exist in master folderNoneNo
Deal and Promotion Headers -> Pricing Item UpgradesDeal and Promotion Headers.List Header ID = Pricing Item Upgrades.List Header IDAlways exist in master folderNoneNo
Deal and Promotion Headers -> Pricing Modifier LinesDeal and Promotion Headers.List Header ID = Pricing Modifier Lines.List Header IDAlways exist in master folderNoneNo
Deal and Promotion Headers -> Pricing QualifiersDeal and Promotion Headers.List Header ID = Pricing Qualifiers.List Header IDAlways exist in master folderNoneNo
Deal and Promotion Headers -> Pricing Term SubstitutionsDeal and Promotion Headers.List Header ID = Pricing Term Substitutions.List Header IDAlways exist in master folderNoneNo
Deal and Promotion Headers -> Sales Order TypesDeal and Promotion Headers.List Header ID = Sales Order Types.Price List IDAlways exist in master folderNoneNo