Powered by InfoCaptor


Previous Page   Next Page

Approved Supplier Lists
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.POFG_APPROVED_SUPPLIER_LISTSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Approved Supplier List ID Approved Supplier Lists.Approved Supplier List IDAPPROVED_SUPPLIER_LIST_IDAPPROVED_SUPPLIER_LIST_ID116375
Approved Supplier List Status Approved Supplier Lists.Approved Supplier List StatusASL_STATUSASL_STATUS116490
Approved Supplier List Status Description Approved Supplier Lists.Approved Supplier List Status DescriptionASL_STATUS_DESCRIPTIONASL_STATUS_DESCRIPTION116491
Category Approved Supplier Lists.CategoryCATEGORYCATEGORY275730
Category IDUnique identifier for CategoryApproved Supplier Lists.Category IDCATEGORY_IDCATEGORY_ID121699
Consigned Billing Cycle Approved Supplier Lists.Consigned Billing CycleCONSIGNED_BILLING_CYCLECONSIGNED_BILLING_CYCLE275743
Consigned From Supp Flag Approved Supplier Lists.Consigned From Supp FlagCONSIGNED_FROM_SUPP_FLAGCONSIGNED_FROM_SUPP_FLAG275741
Country Of Origin Code Approved Supplier Lists.Country Of Origin CodeCOUNTRY_OF_ORIGIN_CODECOUNTRY_OF_ORIGIN_CODE275735
Created By Approved Supplier Lists.Created ByCREATED_BYCREATED_BY125210
Created Date Approved Supplier Lists.Created DateCREATED_DATECREATED_DATE125385
Created Date - Day Approved Supplier Lists.Created Date CREATED_DATE_DAY171193
Created Date - Month Approved Supplier Lists.Created Date CREATED_DATE_MONTH171347
Created Date - Quarter Approved Supplier Lists.Created Date CREATED_DATE_QUARTER171501
Created Date - Year Approved Supplier Lists.Created Date CREATED_DATE_YEAR171655
Delivery Calendar Approved Supplier Lists.Delivery CalendarDELIVERY_CALENDARDELIVERY_CALENDAR275734
DescriptionThe accounting period description.Approved Supplier Lists.DescriptionDESCRIPTIONDESCRIPTION129823
Document Sourcing Method Approved Supplier Lists.Document Sourcing MethodDOCUMENT_SOURCING_METHODDOCUMENT_SOURCING_METHOD275722
Enable Auto Schedule Approved Supplier Lists.Enable Auto ScheduleENABLE_AUTO_SCHEDULEENABLE_AUTO_SCHEDULE275726
Enable Plan Schedule Approved Supplier Lists.Enable Plan ScheduleENABLE_PLAN_SCHEDULEENABLE_PLAN_SCHEDULE275724
Enable Ship Schedule Approved Supplier Lists.Enable Ship ScheduleENABLE_SHIP_SCHEDULEENABLE_SHIP_SCHEDULE275725
Enable Vmi Auto Rep Flag Approved Supplier Lists.Enable Vmi Auto Rep FlagENABLE_VMI_AUTO_REP_FLAGENABLE_VMI_AUTO_REP_FLAG275739
Enable Vmi Flag Approved Supplier Lists.Enable Vmi FlagENABLE_VMI_FLAGENABLE_VMI_FLAG275736
Item DescriptionShort description of the item that is displayed during the item look up.Approved Supplier Lists.Item DescriptionITEM_DESCRIPTIONITEM_DESCRIPTION137756
Item IDSurrogate key for the item for which results are recorded.Approved Supplier Lists.Item IDITEM_IDITEM_ID137802
Item Number Approved Supplier Lists.Item NumberITEM_NUMBERITEM_NUMBER275729
Last Billing Date Approved Supplier Lists.Last Billing DateLAST_BILLING_DATELAST_BILLING_DATE275742
Last Updated By Approved Supplier Lists.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139790
Last Updated Date Approved Supplier Lists.Last Updated DateLAST_UPDATED_DATELAST_UPDATED_DATE139964
Last Updated Date - Day Approved Supplier Lists.Last Updated Date LAST_UPDATED_DATE_DAY182876
Last Updated Date - Month Approved Supplier Lists.Last Updated Date LAST_UPDATED_DATE_MONTH183038
Last Updated Date - Quarter Approved Supplier Lists.Last Updated Date LAST_UPDATED_DATE_QUARTER183200
Last Updated Date - Year Approved Supplier Lists.Last Updated Date LAST_UPDATED_DATE_YEAR183362
Manufacturer Approved Supplier IDUnique identifier for Manufacturer Approved Supplier ListApproved Supplier Lists.Manufacturer Approved Supplier IDMANUFACTURER_ASL_IDMANUFACTURER_ASL_ID146135
Manufacturer IDUnique identifier for ManufacturerApproved Supplier Lists.Manufacturer IDMANUFACTURER_IDMANUFACTURER_ID146137
Manufacturer Name Approved Supplier Lists.Manufacturer NameMANUFACTURER_NAMEMANUFACTURER_NAME146140
Min Order Qty Approved Supplier Lists.Min Order QtyMIN_ORDER_QTYMIN_ORDER_QTY275733
Ocessing Lead Time Approved Supplier Lists.Ocessing Lead TimeOCESSING_LEAD_TIMEOCESSING_LEAD_TIME275732
Owning Organization Code Approved Supplier Lists.Owning Organization CodeOWNING_ORGANIZATION_CODEOWNING_ORGANIZATION_CODE151776
Owning Organization IDUnique identifier for Owning OrganizationApproved Supplier Lists.Owning Organization IDOWNING_ORGANIZATION_IDOWNING_ORGANIZATION_ID151779
Owning Organization Name Approved Supplier Lists.Owning Organization NameOWNING_ORGANIZATION_NAMEOWNING_ORGANIZATION_NAME151782
Plan Schedule Type Approved Supplier Lists.Plan Schedule TypePLAN_SCHEDULE_TYPEPLAN_SCHEDULE_TYPE275727
Price Update Tolerance Approved Supplier Lists.Price Update TolerancePRICE_UPDATE_TOLERANCEPRICE_UPDATE_TOLERANCE275731
Purchasing Unit Of Measure Approved Supplier Lists.Purchasing Unit Of MeasurePURCHASING_UNIT_OF_MEASUREPURCHASING_UNIT_OF_MEASURE157090
Release Creation Method Approved Supplier Lists.Release Creation MethodRELEASE_CREATION_METHODRELEASE_CREATION_METHOD275723
Review By DateBy when a proactive business review will be performed for the supplierApproved Supplier Lists.Review By DateREVIEW_BY_DATEREVIEW_BY_DATE159489
Review By Date - Day Approved Supplier Lists.Review By Date REVIEW_BY_DATE_DAY189904
Review By Date - Month Approved Supplier Lists.Review By Date REVIEW_BY_DATE_MONTH189906
Review By Date - Quarter Approved Supplier Lists.Review By Date REVIEW_BY_DATE_QUARTER189908
Review By Date - Year Approved Supplier Lists.Review By Date REVIEW_BY_DATE_YEAR189910
Scheduler Employee Number Approved Supplier Lists.Scheduler Employee NumberSCHEDULER_EMPLOYEE_NUMBERSCHEDULER_EMPLOYEE_NUMBER160788
Scheduler IDUnique identifier for SchedulerApproved Supplier Lists.Scheduler IDSCHEDULER_IDSCHEDULER_ID160789
Scheduler Name Approved Supplier Lists.Scheduler NameSCHEDULER_NAMESCHEDULER_NAME160790
Ship Schedule Type Approved Supplier Lists.Ship Schedule TypeSHIP_SCHEDULE_TYPESHIP_SCHEDULE_TYPE275728
Site Operating Unit IDUnique identifier for Site Operating UnitApproved Supplier Lists.Site Operating Unit IDSITE_OPERATING_UNIT_IDSITE_OPERATING_UNIT_ID162122
Site Operating Unit Name Approved Supplier Lists.Site Operating Unit NameSITE_OPERATING_UNIT_NAMESITE_OPERATING_UNIT_NAME162124
Supplier Business Type Approved Supplier Lists.Supplier Business TypeSUPPLIER_BUSINESS_TYPESUPPLIER_BUSINESS_TYPE275721
Supplier IDUnique identifier for SupplierApproved Supplier Lists.Supplier IDSUPPLIER_IDSUPPLIER_ID164207
Supplier Name Approved Supplier Lists.Supplier NameSUPPLIER_NAMESUPPLIER_NAME164251
Supplier Product NumberSupplier, manufacturer, or distributor item numberApproved Supplier Lists.Supplier Product NumberSUPPLIER_PRODUCT_NUMBERSUPPLIER_PRODUCT_NUMBER164286
Supplier Site Approved Supplier Lists.Supplier SiteSUPPLIER_SITESUPPLIER_SITE164300
Supplier Site IDUnique identifier for Supplier SiteApproved Supplier Lists.Supplier Site IDSUPPLIER_SITE_IDSUPPLIER_SITE_ID164324
UOM ClassUnit of measure classApproved Supplier Lists.UOM ClassUOM_CLASSUOM_CLASS166384
UOM DescriptionUnit of measure descriptionApproved Supplier Lists.UOM DescriptionUOM_DESCRIPTIONUOM_DESCRIPTION166419
Using Organization Code Approved Supplier Lists.Using Organization CodeUSING_ORGANIZATION_CODEUSING_ORGANIZATION_CODE167034
Using Organization ID Approved Supplier Lists.Using Organization IDUSING_ORGANIZATION_IDUSING_ORGANIZATION_ID167036
Using Organization Name Approved Supplier Lists.Using Organization NameUSING_ORGANIZATION_NAMEUSING_ORGANIZATION_NAME167038
Vmi Max Qty Approved Supplier Lists.Vmi Max QtyVMI_MAX_QTYVMI_MAX_QTY275738
Vmi Min Qty Approved Supplier Lists.Vmi Min QtyVMI_MIN_QTYVMI_MIN_QTY275737
Vmi Replenishment Approval Approved Supplier Lists.Vmi Replenishment ApprovalVMI_REPLENISHMENT_APPROVALVMI_REPLENISHMENT_APPROVAL275740
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Approved Supplier Lists -> Approved Supplier List DocumentsApproved Supplier Lists.Approved Supplier List ID = Approved Supplier List Documents.Approved Supplier List ID Approved Supplier Lists.Using Organization ID = Approved Supplier List Documents.Using Organization ID Approved Supplier Lists.Site Operating Unit ID = Approved Supplier List Documents.Operating Unit IDAlways exist in master folderNoneNo