Powered by InfoCaptor


Previous Page   Next Page

Planned Purchase Order Lines
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.POFG_PLAN_PO_LINESUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Allow Price Override Planned Purchase Order Lines.Allow Price OverrideALLOW_PRICE_OVERRIDEALLOW_PRICE_OVERRIDE275948
Cancel Date Planned Purchase Order Lines.Cancel DateCANCEL_DATECANCEL_DATE121468
Cancel Date - Day Planned Purchase Order Lines.Cancel Date CANCEL_DATE_DAY170275
Cancel Date - Month Planned Purchase Order Lines.Cancel Date CANCEL_DATE_MONTH170295
Cancel Date - Quarter Planned Purchase Order Lines.Cancel Date CANCEL_DATE_QUARTER170315
Cancel Date - Year Planned Purchase Order Lines.Cancel Date CANCEL_DATE_YEAR170335
Cancel Flag Planned Purchase Order Lines.Cancel FlagCANCEL_FLAGCANCEL_FLAG275949
Cancel Reason Planned Purchase Order Lines.Cancel ReasonCANCEL_REASONCANCEL_REASON121479
Cancelled By Planned Purchase Order Lines.Cancelled ByCANCELLED_BYCANCELLED_BY121426
Cancelled By Employee Name Planned Purchase Order Lines.Cancelled By Employee NameCANCELLED_BY_EMPLOYEE_NAMECANCELLED_BY_EMPLOYEE_NAME121432
Cancelled By Employee Number Planned Purchase Order Lines.Cancelled By Employee NumberCANCELLED_BY_EMPLOYEE_NUMBERCANCELLED_BY_EMPLOYEE_NUMBER121438
Capital Expense Flag Planned Purchase Order Lines.Capital Expense FlagCAPITAL_EXPENSE_FLAGCAPITAL_EXPENSE_FLAG275952
Category Planned Purchase Order Lines.CategoryCATEGORYCATEGORY275958
Category IDUnique identifier for CategoryPlanned Purchase Order Lines.Category IDCATEGORY_IDCATEGORY_ID121703
Closed By Planned Purchase Order Lines.Closed ByCLOSED_BYCLOSED_BY122163
Closed By Employee Name Planned Purchase Order Lines.Closed By Employee NameCLOSED_BY_EMPLOYEE_NAMECLOSED_BY_EMPLOYEE_NAME122167
Closed By Employee Number Planned Purchase Order Lines.Closed By Employee NumberCLOSED_BY_EMPLOYEE_NUMBERCLOSED_BY_EMPLOYEE_NUMBER122171
Closed Date Planned Purchase Order Lines.Closed DateCLOSED_DATECLOSED_DATE122180
Closed Date - Day Planned Purchase Order Lines.Closed Date CLOSED_DATE_DAY170523
Closed Date - Month Planned Purchase Order Lines.Closed Date CLOSED_DATE_MONTH170561
Closed Date - Quarter Planned Purchase Order Lines.Closed Date CLOSED_DATE_QUARTER170599
Closed Date - Year Planned Purchase Order Lines.Closed Date CLOSED_DATE_YEAR170639
Closed Reason Planned Purchase Order Lines.Closed ReasonCLOSED_REASONCLOSED_REASON122197
Closure Status Planned Purchase Order Lines.Closure StatusCLOSURE_STATUSCLOSURE_STATUS275950
Context Planned Purchase Order Lines.ContextCONTEXTCONTEXT275954
Created By Planned Purchase Order Lines.Created ByCREATED_BYCREATED_BY125224
Created Date Planned Purchase Order Lines.Created DateCREATED_DATECREATED_DATE125399
Created Date - Day Planned Purchase Order Lines.Created Date CREATED_DATE_DAY171221
Created Date - Month Planned Purchase Order Lines.Created Date CREATED_DATE_MONTH171375
Created Date - Quarter Planned Purchase Order Lines.Created Date CREATED_DATE_QUARTER171529
Created Date - Year Planned Purchase Order Lines.Created Date CREATED_DATE_YEAR171683
Hazard Class Planned Purchase Order Lines.Hazard ClassHAZARD_CLASSHAZARD_CLASS135600
Hazard Class IDUnique identifier for Hazard ClassPlanned Purchase Order Lines.Hazard Class IDHAZARD_CLASS_IDHAZARD_CLASS_ID135612
Item DescriptionShort description of the item that is displayed during the item look up.Planned Purchase Order Lines.Item DescriptionITEM_DESCRIPTIONITEM_DESCRIPTION137759
Item IDSurrogate key for the item for which results are recorded.Planned Purchase Order Lines.Item IDITEM_IDITEM_ID137805
Item Number Planned Purchase Order Lines.Item NumberITEM_NUMBERITEM_NUMBER275957
Item Organization Code Planned Purchase Order Lines.Item Organization CodeITEM_ORGANIZATION_CODEITEM_ORGANIZATION_CODE137859
Item Organization IDUnique identifier for Item OrganizationPlanned Purchase Order Lines.Item Organization IDITEM_ORGANIZATION_IDITEM_ORGANIZATION_ID137866
Item Revision Planned Purchase Order Lines.Item RevisionITEM_REVISIONITEM_REVISION137900
Last Updated By Planned Purchase Order Lines.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139804
Last Updated Date Planned Purchase Order Lines.Last Updated DateLAST_UPDATED_DATELAST_UPDATED_DATE139978
Last Updated Date - Day Planned Purchase Order Lines.Last Updated Date LAST_UPDATED_DATE_DAY182904
Last Updated Date - Month Planned Purchase Order Lines.Last Updated Date LAST_UPDATED_DATE_MONTH183066
Last Updated Date - Quarter Planned Purchase Order Lines.Last Updated Date LAST_UPDATED_DATE_QUARTER183228
Last Updated Date - Year Planned Purchase Order Lines.Last Updated Date LAST_UPDATED_DATE_YEAR183390
Line NumberUser-assigned bank statement line number to uniquely identifyindividual transactions.Planned Purchase Order Lines.Line NumberLINE_NUMBERLINE_NUMBER144742
Line TypeThe type of line : course payment / pre-purchase / delegate etc.Planned Purchase Order Lines.Line TypeLINE_TYPELINE_TYPE144795
List Price Planned Purchase Order Lines.List PriceLIST_PRICELIST_PRICE144882
Market Price Planned Purchase Order Lines.Market PriceMARKET_PRICEMARKET_PRICE146203
Minimum Release AmountThe minimum amount buyers can releasePlanned Purchase Order Lines.Minimum Release AmountMINIMUM_RELEASE_AMOUNTMINIMUM_RELEASE_AMOUNT147157
Negotiated By Buyer Flag Planned Purchase Order Lines.Negotiated By Buyer FlagNEGOTIATED_BY_BUYER_FLAGNEGOTIATED_BY_BUYER_FLAG275951
Oke Contract Header Id Planned Purchase Order Lines.Oke Contract Header IdOKE_CONTRACT_HEADER_IDOKE_CONTRACT_HEADER_ID275963
Oke Contract Line Num Planned Purchase Order Lines.Oke Contract Line NumOKE_CONTRACT_LINE_NUMOKE_CONTRACT_LINE_NUM275967
Oke Contract Num Planned Purchase Order Lines.Oke Contract NumOKE_CONTRACT_NUMOKE_CONTRACT_NUM275965
Oke Contract Version Id Planned Purchase Order Lines.Oke Contract Version IdOKE_CONTRACT_VERSION_IDOKE_CONTRACT_VERSION_ID275964
Oke Contract Version Num Planned Purchase Order Lines.Oke Contract Version NumOKE_CONTRACT_VERSION_NUMOKE_CONTRACT_VERSION_NUM275966
Operating Unit IDUnique identifier for Operating UnitPlanned Purchase Order Lines.Operating Unit IDOPERATING_UNIT_IDOPERATING_UNIT_ID149540
Operating Unit Name Planned Purchase Order Lines.Operating Unit NameOPERATING_UNIT_NAMEOPERATING_UNIT_NAME149588
Ordered Quantity Planned Purchase Order Lines.Ordered QuantityORDERED_QUANTITYORDERED_QUANTITY149761
Original ETA Planned Purchase Order Lines.Original ETAORIGINAL_ETAORIGINAL_ETA275955
Planned Purchase Order Document Number Planned Purchase Order Lines.Planned Purchase Order Document NumberPLANNED_PO_DOCUMENT_NUMBERPLANNED_PO_DOCUMENT_NUMBER154202
Planned Purchase Order IDUnique identifier for Planned Purchase OrderPlanned Purchase Order Lines.Planned Purchase Order IDPLANNED_PO_IDPLANNED_PO_ID154208
Preferred Grade Planned Purchase Order Lines.Preferred GradePREFERRED_GRADEPREFERRED_GRADE275962
Price LimitThe maximum price per item allowed for the item on this agreement linePlanned Purchase Order Lines.Price LimitPRICE_LIMITPRICE_LIMIT155332
Price Type Planned Purchase Order Lines.Price TypePRICE_TYPEPRICE_TYPE275947
Purchase Order Line IDUnique identifier for Purchase Order LinePlanned Purchase Order Lines.Purchase Order Line IDPO_LINE_IDPO_LINE_ID155054
SKU Item Planned Purchase Order Lines.SKU ItemSKU_ITEMSKU_ITEM275956
Secondary Quantity Planned Purchase Order Lines.Secondary QuantitySECONDARY_QUANTITYSECONDARY_QUANTITY275960
Secondary Unit Of Measure Planned Purchase Order Lines.Secondary Unit Of MeasureSECONDARY_UNIT_OF_MEASURESECONDARY_UNIT_OF_MEASURE275961
Source Document IDUnique identifier for Source DocumentPlanned Purchase Order Lines.Source Document IDSOURCE_DOCUMENT_IDSOURCE_DOCUMENT_ID162371
Source Document Line IDUnique identifier for Source Document LinePlanned Purchase Order Lines.Source Document Line IDSOURCE_DOCUMENT_LINE_IDSOURCE_DOCUMENT_LINE_ID162377
Source Document Line Number Planned Purchase Order Lines.Source Document Line NumberSOURCE_DOCUMENT_LINE_NUMBERSOURCE_DOCUMENT_LINE_NUMBER162381
Source Document Number Planned Purchase Order Lines.Source Document NumberSOURCE_DOCUMENT_NUMBERSOURCE_DOCUMENT_NUMBER162386
Source Document Type Planned Purchase Order Lines.Source Document TypeSOURCE_DOCUMENT_TYPESOURCE_DOCUMENT_TYPE275959
Supplier NoteNote to supplierPlanned Purchase Order Lines.Supplier NoteSUPPLIER_NOTESUPPLIER_NOTE164271
Supplier Product Number Planned Purchase Order Lines.Supplier Product NumberSUPPLIER_PRODUCT_NUMBERSUPPLIER_PRODUCT_NUMBER164288
Tax Code IDUnique identifier for Tax CodePlanned Purchase Order Lines.Tax Code IDTAX_CODE_IDTAX_CODE_ID164721
Tax Code Name Planned Purchase Order Lines.Tax Code NameTAX_CODE_NAMETAX_CODE_NAME164725
Taxable Flag Planned Purchase Order Lines.Taxable FlagTAXABLE_FLAGTAXABLE_FLAG275953
Transaction ReasonTransaction nature of the linePlanned Purchase Order Lines.Transaction ReasonTRANSACTION_REASONTRANSACTION_REASON165794
Type Of 10991099 tax information typePlanned Purchase Order Lines.Type Of 1099TYPE_OF_1099TYPE_OF_1099166170
UN NumberUnited Nations hazardous material classification numberPlanned Purchase Order Lines.UN NumberUN_NUMBERUN_NUMBER166350
UN Number IDUnique identifier for United Nations hazardous material classification numberPlanned Purchase Order Lines.UN Number IDUN_NUMBER_IDUN_NUMBER_ID166359
UOM ClassUnit of measure ClassPlanned Purchase Order Lines.UOM ClassUOM_CLASSUOM_CLASS166387
UOM DescriptionUnit of measure DescriptionPlanned Purchase Order Lines.UOM DescriptionUOM_DESCRIPTIONUOM_DESCRIPTION166422
Unit Of Measure Planned Purchase Order Lines.Unit Of MeasureUNIT_OF_MEASUREUNIT_OF_MEASURE166284
Unit Price Planned Purchase Order Lines.Unit PriceUNIT_PRICEUNIT_PRICE166314
Ussgl Transaction CodeTransaction code for creating US standard General Ledger journal entries (Oracle Public Sector Payables).Planned Purchase Order Lines.Ussgl Transaction CodeUSSGL_TRANSACTION_CODEUSSGL_TRANSACTION_CODE167057
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto