Powered by InfoCaptor


Previous Page   Next Page

Pricing Agreements
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.QPFG_AGREEMENTSUnknown
NoneNone.QPFG_AGREEMENTSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Accounting Rule ID Pricing Agreements.Accounting Rule IDACCOUNTING_RULE_IDACCOUNTING_RULE_ID114113
Agreement Contact ID Pricing Agreements.Agreement Contact IDAGREEMENT_CONTACT_IDAGREEMENT_CONTACT_ID115411
Agreement IDThe unique identifier of the agreement.Pricing Agreements.Agreement IDAGREEMENT_IDAGREEMENT_ID115429
Agreement Name Pricing Agreements.Agreement NameAGR_NAMEAGR_NAME115454
Agreement Num Pricing Agreements.Agreement NumAGREEMENT_NUMAGREEMENT_NUM115436
Agreement Source Code Pricing Agreements.Agreement Source CodeAGREEMENT_SOURCE_CODEAGREEMENT_SOURCE_CODE115444
Agreement Type Code Pricing Agreements.Agreement Type CodeAGREEMENT_TYPE_CODEAGREEMENT_TYPE_CODE115451
Agreement Type Code 1 Pricing Agreements.Agreement Type Code 1AGREEMENT_TYPE_CODE_1AGREEMENT_TYPE_CODE_1272731
Created By Pricing Agreements.Created ByCREATED_BYCREATED_BY124654
Creation Date Pricing Agreements.Creation DateCREATION_DATECREATION_DATE126080
Customer Name Pricing Agreements.Customer NameCUSTOMER_NAMECUSTOMER_NAME127676
Customer Number Pricing Agreements.Customer NumberCUSTOMER_NUMBERCUSTOMER_NUMBER127718
End Date Active Pricing Agreements.End Date ActiveEND_DATE_ACTIVEEND_DATE_ACTIVE132915
End Date Active - Day Pricing Agreements.End Date Active END_DATE_ACTIVE_DAY178297
End Date Active - Month Pricing Agreements.End Date Active END_DATE_ACTIVE_MONTH178339
End Date Active - Quarter Pricing Agreements.End Date Active END_DATE_ACTIVE_QUARTER178373
End Date Active - Year Pricing Agreements.End Date Active END_DATE_ACTIVE_YEAR178415
Freight Terms Code Pricing Agreements.Freight Terms CodeFREIGHT_TERMS_CODEFREIGHT_TERMS_CODE134685
Freight Terms Name Pricing Agreements.Freight Terms NameFREIGHT_TERMS_NAMEFREIGHT_TERMS_NAME134688
Invoice Contact ID Pricing Agreements.Invoice Contact IDINVOICE_CONTACT_IDINVOICE_CONTACT_ID137398
Invoice To Org ID Pricing Agreements.Invoice To Org IDINVOICE_TO_ORG_IDINVOICE_TO_ORG_ID137494
Invoicing Rule ID Pricing Agreements.Invoicing Rule IDINVOICING_RULE_IDINVOICING_RULE_ID137535
Last Update Date Pricing Agreements.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140616
Last Updated By Pricing Agreements.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139279
NameName of the resource.Pricing Agreements.NameNAMENAME147725
Orig System Agr Id Pricing Agreements.Orig System Agr IdORIG_SYSTEM_AGR_IDORIG_SYSTEM_AGR_ID151477
Override Accounting Rule Flag Pricing Agreements.Override Accounting Rule FlagOVERRIDE_ARULE_FLAGOVERRIDE_ARULE_FLAG151708
Override Invoicing Rule Flag Pricing Agreements.Override Invoicing Rule FlagOVERRIDE_IRULE_FLAGOVERRIDE_IRULE_FLAG151712
Price List ID Pricing Agreements.Price List IDPRICE_LIST_IDPRICE_LIST_ID155363
Purchase Order Num Pricing Agreements.Purchase Order NumPURCHASE_ORDER_NUMPURCHASE_ORDER_NUM157059
Revision Pricing Agreements.RevisionREVISIONREVISION159511
Revision Date Pricing Agreements.Revision DateREVISION_DATEREVISION_DATE159529
Revision Date - Day Pricing Agreements.Revision Date REVISION_DATE_DAY189918
Revision Date - Month Pricing Agreements.Revision Date REVISION_DATE_MONTH189920
Revision Date - Quarter Pricing Agreements.Revision Date REVISION_DATE_QUARTER189922
Revision Date - Year Pricing Agreements.Revision Date REVISION_DATE_YEAR189924
Revision Reason Code Pricing Agreements.Revision Reason CodeREVISION_REASON_CODEREVISION_REASON_CODE159539
Revision Reason Code 1 Pricing Agreements.Revision Reason Code 1REVISION_REASON_CODE_1REVISION_REASON_CODE_1272730
Salesrepresentive ID Pricing Agreements.Salesrepresentive IDSALESREP_IDSALESREP_ID160619
Ship Method Code Pricing Agreements.Ship Method CodeSHIP_METHOD_CODESHIP_METHOD_CODE161815
Ship Method Name Pricing Agreements.Ship Method NameSHIP_METHOD_NAMESHIP_METHOD_NAME161819
Signature Date Pricing Agreements.Signature DateSIGNATURE_DATESIGNATURE_DATE162110
Sold To Org ID Pricing Agreements.Sold To Org IDSOLD_TO_ORG_IDSOLD_TO_ORG_ID162273
Start Date Active Pricing Agreements.Start Date ActiveSTART_DATE_ACTIVESTART_DATE_ACTIVE163075
Start Date Active - Day Pricing Agreements.Start Date Active START_DATE_ACTIVE_DAY190793
Start Date Active - Month Pricing Agreements.Start Date Active START_DATE_ACTIVE_MONTH190835
Start Date Active - Quarter Pricing Agreements.Start Date Active START_DATE_ACTIVE_QUARTER190869
Start Date Active - Year Pricing Agreements.Start Date Active START_DATE_ACTIVE_YEAR190911
Term IDUnique identifier for this payment term.Pricing Agreements.Term IDTERM_IDTERM_ID164979
Trading Partner Attribute Category Pricing Agreements.Trading Partner Attribute CategoryTP_ATTRIBUTE_CATEGORYTP_ATTRIBUTE_CATEGORY165512
Accounting Rule ID Pricing Agreements.Accounting Rule IDACCOUNTING_RULE_IDACCOUNTING_RULE_ID114113
Agreement Contact ID Pricing Agreements.Agreement Contact IDAGREEMENT_CONTACT_IDAGREEMENT_CONTACT_ID115411
Agreement IDThe unique identifier of the agreement.Pricing Agreements.Agreement IDAGREEMENT_IDAGREEMENT_ID115429
Agreement Name Pricing Agreements.Agreement NameAGR_NAMEAGR_NAME115454
Agreement Num Pricing Agreements.Agreement NumAGREEMENT_NUMAGREEMENT_NUM115436
Agreement Source Code Pricing Agreements.Agreement Source CodeAGREEMENT_SOURCE_CODEAGREEMENT_SOURCE_CODE115444
Agreement Type Code Pricing Agreements.Agreement Type CodeAGREEMENT_TYPE_CODEAGREEMENT_TYPE_CODE115451
Agreement Type Code 1 Pricing Agreements.Agreement Type Code 1AGREEMENT_TYPE_CODE_1AGREEMENT_TYPE_CODE_1272731
Created By Pricing Agreements.Created ByCREATED_BYCREATED_BY124654
Creation Date Pricing Agreements.Creation DateCREATION_DATECREATION_DATE126080
Customer Name Pricing Agreements.Customer NameCUSTOMER_NAMECUSTOMER_NAME127676
Customer Number Pricing Agreements.Customer NumberCUSTOMER_NUMBERCUSTOMER_NUMBER127718
End Date Active Pricing Agreements.End Date ActiveEND_DATE_ACTIVEEND_DATE_ACTIVE132915
End Date Active - Day Pricing Agreements.End Date Active END_DATE_ACTIVE_DAY178297
End Date Active - Month Pricing Agreements.End Date Active END_DATE_ACTIVE_MONTH178339
End Date Active - Quarter Pricing Agreements.End Date Active END_DATE_ACTIVE_QUARTER178373
End Date Active - Year Pricing Agreements.End Date Active END_DATE_ACTIVE_YEAR178415
Freight Terms Code Pricing Agreements.Freight Terms CodeFREIGHT_TERMS_CODEFREIGHT_TERMS_CODE134685
Freight Terms Name Pricing Agreements.Freight Terms NameFREIGHT_TERMS_NAMEFREIGHT_TERMS_NAME134688
Invoice Contact ID Pricing Agreements.Invoice Contact IDINVOICE_CONTACT_IDINVOICE_CONTACT_ID137398
Invoice To Org ID Pricing Agreements.Invoice To Org IDINVOICE_TO_ORG_IDINVOICE_TO_ORG_ID137494
Invoicing Rule ID Pricing Agreements.Invoicing Rule IDINVOICING_RULE_IDINVOICING_RULE_ID137535
Last Update Date Pricing Agreements.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140616
Last Updated By Pricing Agreements.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139279
NameName of the resource.Pricing Agreements.NameNAMENAME147725
Orig System Agr Id Pricing Agreements.Orig System Agr IdORIG_SYSTEM_AGR_IDORIG_SYSTEM_AGR_ID151477
Override Accounting Rule Flag Pricing Agreements.Override Accounting Rule FlagOVERRIDE_ARULE_FLAGOVERRIDE_ARULE_FLAG151708
Override Invoicing Rule Flag Pricing Agreements.Override Invoicing Rule FlagOVERRIDE_IRULE_FLAGOVERRIDE_IRULE_FLAG151712
Price List ID Pricing Agreements.Price List IDPRICE_LIST_IDPRICE_LIST_ID155363
Purchase Order Num Pricing Agreements.Purchase Order NumPURCHASE_ORDER_NUMPURCHASE_ORDER_NUM157059
Revision Pricing Agreements.RevisionREVISIONREVISION159511
Revision Date Pricing Agreements.Revision DateREVISION_DATEREVISION_DATE159529
Revision Date - Day Pricing Agreements.Revision Date REVISION_DATE_DAY189918
Revision Date - Month Pricing Agreements.Revision Date REVISION_DATE_MONTH189920
Revision Date - Quarter Pricing Agreements.Revision Date REVISION_DATE_QUARTER189922
Revision Date - Year Pricing Agreements.Revision Date REVISION_DATE_YEAR189924
Revision Reason Code Pricing Agreements.Revision Reason CodeREVISION_REASON_CODEREVISION_REASON_CODE159539
Revision Reason Code 1 Pricing Agreements.Revision Reason Code 1REVISION_REASON_CODE_1REVISION_REASON_CODE_1272730
Salesrepresentive ID Pricing Agreements.Salesrepresentive IDSALESREP_IDSALESREP_ID160619
Ship Method Code Pricing Agreements.Ship Method CodeSHIP_METHOD_CODESHIP_METHOD_CODE161815
Ship Method Name Pricing Agreements.Ship Method NameSHIP_METHOD_NAMESHIP_METHOD_NAME161819
Signature Date Pricing Agreements.Signature DateSIGNATURE_DATESIGNATURE_DATE162110
Sold To Org ID Pricing Agreements.Sold To Org IDSOLD_TO_ORG_IDSOLD_TO_ORG_ID162273
Start Date Active Pricing Agreements.Start Date ActiveSTART_DATE_ACTIVESTART_DATE_ACTIVE163075
Start Date Active - Day Pricing Agreements.Start Date Active START_DATE_ACTIVE_DAY190793
Start Date Active - Month Pricing Agreements.Start Date Active START_DATE_ACTIVE_MONTH190835
Start Date Active - Quarter Pricing Agreements.Start Date Active START_DATE_ACTIVE_QUARTER190869
Start Date Active - Year Pricing Agreements.Start Date Active START_DATE_ACTIVE_YEAR190911
Term IDUnique identifier for this payment term.Pricing Agreements.Term IDTERM_IDTERM_ID164979
Trading Partner Attribute Category Pricing Agreements.Trading Partner Attribute CategoryTP_ATTRIBUTE_CATEGORYTP_ATTRIBUTE_CATEGORY165512
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Pricing Agreements -> Order HeadersPricing Agreements.Agreement ID = Order Headers.Agreement IDAlways exist in master folderNoneNo
Pricing Agreements -> Order LinesPricing Agreements.Agreement ID = Order Lines.Agreement IDAlways exist in master folderNoneNo