Powered by InfoCaptor


Previous Page   Next Page

Blanket Purchase Order Lines
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.POFG_BKT_PO_LINESUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Agreed AmountThe amount the buyer has agreed to spend with the supplierBlanket Purchase Order Lines.Agreed AmountAGREED_AMOUNTAGREED_AMOUNT115397
Agreed QuantityThe quantity the buyer has agreed to purchase from the supplierBlanket Purchase Order Lines.Agreed QuantityAGREED_QUANTITYAGREED_QUANTITY115402
Allow Price Override Blanket Purchase Order Lines.Allow Price OverrideALLOW_PRICE_OVERRIDEALLOW_PRICE_OVERRIDE275769
Amount Blanket Purchase Order Lines.AmountAMOUNTAMOUNT275798
Auction Display Number Blanket Purchase Order Lines.Auction Display NumberAUCTION_DISPLAY_NUMBERAUCTION_DISPLAY_NUMBER275784
Auction Header Id Blanket Purchase Order Lines.Auction Header IdAUCTION_HEADER_IDAUCTION_HEADER_ID275785
Auction Line Number Blanket Purchase Order Lines.Auction Line NumberAUCTION_LINE_NUMBERAUCTION_LINE_NUMBER275786
Base Unit Price Blanket Purchase Order Lines.Base Unit PriceBASE_UNIT_PRICEBASE_UNIT_PRICE275795
Bid Line Number Blanket Purchase Order Lines.Bid Line NumberBID_LINE_NUMBERBID_LINE_NUMBER275788
Bid Number Blanket Purchase Order Lines.Bid NumberBID_NUMBERBID_NUMBER275787
Blanket Purchase Order Document Number Blanket Purchase Order Lines.Blanket Purchase Order Document NumberBLANKET_PO_DOCUMENT_NUMBERBLANKET_PO_DOCUMENT_NUMBER119981
Blanket Purchase Order IDUnique identifier for Blanket Purchase OrderBlanket Purchase Order Lines.Blanket Purchase Order IDBLANKET_PO_IDBLANKET_PO_ID119986
Cancel Date Blanket Purchase Order Lines.Cancel DateCANCEL_DATECANCEL_DATE121466
Cancel Date - Day Blanket Purchase Order Lines.Cancel Date CANCEL_DATE_DAY170271
Cancel Date - Month Blanket Purchase Order Lines.Cancel Date CANCEL_DATE_MONTH170291
Cancel Date - Quarter Blanket Purchase Order Lines.Cancel Date CANCEL_DATE_QUARTER170311
Cancel Date - Year Blanket Purchase Order Lines.Cancel Date CANCEL_DATE_YEAR170331
Cancel Flag Blanket Purchase Order Lines.Cancel FlagCANCEL_FLAGCANCEL_FLAG275770
Cancel Reason Blanket Purchase Order Lines.Cancel ReasonCANCEL_REASONCANCEL_REASON121477
Cancelled By Blanket Purchase Order Lines.Cancelled ByCANCELLED_BYCANCELLED_BY121424
Cancelled By Employee Name Blanket Purchase Order Lines.Cancelled By Employee NameCANCELLED_BY_EMPLOYEE_NAMECANCELLED_BY_EMPLOYEE_NAME121430
Cancelled By Employee Number Blanket Purchase Order Lines.Cancelled By Employee NumberCANCELLED_BY_EMPLOYEE_NUMBERCANCELLED_BY_EMPLOYEE_NUMBER121436
Capital Expense Flag Blanket Purchase Order Lines.Capital Expense FlagCAPITAL_EXPENSE_FLAGCAPITAL_EXPENSE_FLAG275773
Category Blanket Purchase Order Lines.CategoryCATEGORYCATEGORY275779
Category IDUnique identifier for CategoryBlanket Purchase Order Lines.Category IDCATEGORY_IDCATEGORY_ID121700
Closed By Blanket Purchase Order Lines.Closed ByCLOSED_BYCLOSED_BY122162
Closed By Employee Name Blanket Purchase Order Lines.Closed By Employee NameCLOSED_BY_EMPLOYEE_NAMECLOSED_BY_EMPLOYEE_NAME122166
Closed By Employee Number Blanket Purchase Order Lines.Closed By Employee NumberCLOSED_BY_EMPLOYEE_NUMBERCLOSED_BY_EMPLOYEE_NUMBER122170
Closed Date Blanket Purchase Order Lines.Closed DateCLOSED_DATECLOSED_DATE122177
Closed Date - Day Blanket Purchase Order Lines.Closed Date CLOSED_DATE_DAY170517
Closed Date - Month Blanket Purchase Order Lines.Closed Date CLOSED_DATE_MONTH170555
Closed Date - Quarter Blanket Purchase Order Lines.Closed Date CLOSED_DATE_QUARTER170593
Closed Date - Year Blanket Purchase Order Lines.Closed Date CLOSED_DATE_YEAR170633
Closed Reason Blanket Purchase Order Lines.Closed ReasonCLOSED_REASONCLOSED_REASON122195
Closure Status Blanket Purchase Order Lines.Closure StatusCLOSURE_STATUSCLOSURE_STATUS275771
Context Blanket Purchase Order Lines.ContextCONTEXTCONTEXT275775
Created By Blanket Purchase Order Lines.Created ByCREATED_BYCREATED_BY125213
Created Date Blanket Purchase Order Lines.Created DateCREATED_DATECREATED_DATE125388
Created Date - Day Blanket Purchase Order Lines.Created Date CREATED_DATE_DAY171199
Created Date - Month Blanket Purchase Order Lines.Created Date CREATED_DATE_MONTH171353
Created Date - Quarter Blanket Purchase Order Lines.Created Date CREATED_DATE_QUARTER171507
Created Date - Year Blanket Purchase Order Lines.Created Date CREATED_DATE_YEAR171661
Expiration DateThe date on which the agreement expires.Blanket Purchase Order Lines.Expiration DateEXPIRATION_DATEEXPIRATION_DATE134093
Hazard Class Blanket Purchase Order Lines.Hazard ClassHAZARD_CLASSHAZARD_CLASS135598
Hazard Class IDUnique identifier for Hazard ClassBlanket Purchase Order Lines.Hazard Class IDHAZARD_CLASS_IDHAZARD_CLASS_ID135610
Item DescriptionShort description of the item that is displayed during the item look up.Blanket Purchase Order Lines.Item DescriptionITEM_DESCRIPTIONITEM_DESCRIPTION137757
Item IDSurrogate key for the item for which results are recorded.Blanket Purchase Order Lines.Item IDITEM_IDITEM_ID137803
Item Number Blanket Purchase Order Lines.Item NumberITEM_NUMBERITEM_NUMBER275778
Item Organization Code Blanket Purchase Order Lines.Item Organization CodeITEM_ORGANIZATION_CODEITEM_ORGANIZATION_CODE137858
Item Organization IDUnique identifier for Item OrganizationBlanket Purchase Order Lines.Item Organization IDITEM_ORGANIZATION_IDITEM_ORGANIZATION_ID137865
Item Revision Blanket Purchase Order Lines.Item RevisionITEM_REVISIONITEM_REVISION137898
Job Id Blanket Purchase Order Lines.Job IdJOB_IDJOB_ID275796
Job Name Blanket Purchase Order Lines.Job NameJOB_NAMEJOB_NAME275797
Last Updated By Blanket Purchase Order Lines.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139793
Last Updated Date Blanket Purchase Order Lines.Last Updated DateLAST_UPDATED_DATELAST_UPDATED_DATE139967
Last Updated Date - Day Blanket Purchase Order Lines.Last Updated Date LAST_UPDATED_DATE_DAY182882
Last Updated Date - Month Blanket Purchase Order Lines.Last Updated Date LAST_UPDATED_DATE_MONTH183044
Last Updated Date - Quarter Blanket Purchase Order Lines.Last Updated Date LAST_UPDATED_DATE_QUARTER183206
Last Updated Date - Year Blanket Purchase Order Lines.Last Updated Date LAST_UPDATED_DATE_YEAR183368
Line NumberUser-assigned bank statement line number to uniquely identifyindividual transactions.Blanket Purchase Order Lines.Line NumberLINE_NUMBERLINE_NUMBER144736
Line TypeThe type of line : course payment / pre-purchase / delegate etc.Blanket Purchase Order Lines.Line TypeLINE_TYPELINE_TYPE144794
List Price Blanket Purchase Order Lines.List PriceLIST_PRICELIST_PRICE144881
Market Price Blanket Purchase Order Lines.Market PriceMARKET_PRICEMARKET_PRICE146202
Matching Basis Blanket Purchase Order Lines.Matching BasisMATCHING_BASISMATCHING_BASIS275800
Minimum Release AmountThe minimum amount buyers can releaseBlanket Purchase Order Lines.Minimum Release AmountMINIMUM_RELEASE_AMOUNTMINIMUM_RELEASE_AMOUNT147155
Negotiated By Buyer Flag Blanket Purchase Order Lines.Negotiated By Buyer FlagNEGOTIATED_BY_BUYER_FLAGNEGOTIATED_BY_BUYER_FLAG275772
Oke Contract Header Id Blanket Purchase Order Lines.Oke Contract Header IdOKE_CONTRACT_HEADER_IDOKE_CONTRACT_HEADER_ID275790
Oke Contract Line Num Blanket Purchase Order Lines.Oke Contract Line NumOKE_CONTRACT_LINE_NUMOKE_CONTRACT_LINE_NUM275794
Oke Contract Num Blanket Purchase Order Lines.Oke Contract NumOKE_CONTRACT_NUMOKE_CONTRACT_NUM275792
Oke Contract Version Id Blanket Purchase Order Lines.Oke Contract Version IdOKE_CONTRACT_VERSION_IDOKE_CONTRACT_VERSION_ID275791
Oke Contract Version Num Blanket Purchase Order Lines.Oke Contract Version NumOKE_CONTRACT_VERSION_NUMOKE_CONTRACT_VERSION_NUM275793
Operating Unit IDUnique identifier for Operating UnitBlanket Purchase Order Lines.Operating Unit IDOPERATING_UNIT_IDOPERATING_UNIT_ID149531
Operating Unit Name Blanket Purchase Order Lines.Operating Unit NameOPERATING_UNIT_NAMEOPERATING_UNIT_NAME149579
Order Type Lookup Code Blanket Purchase Order Lines.Order Type Lookup CodeORDER_TYPE_LOOKUP_CODEORDER_TYPE_LOOKUP_CODE275801
Original ETA Blanket Purchase Order Lines.Original ETAORIGINAL_ETAORIGINAL_ETA275776
Preferred Grade Blanket Purchase Order Lines.Preferred GradePREFERRED_GRADEPREFERRED_GRADE275783
Price Break Type Blanket Purchase Order Lines.Price Break TypePRICE_BREAK_TYPEPRICE_BREAK_TYPE275768
Price LimitThe maximum price per item allowed for the item on the agreement lineBlanket Purchase Order Lines.Price LimitPRICE_LIMITPRICE_LIMIT155331
Price Type Blanket Purchase Order Lines.Price TypePRICE_TYPEPRICE_TYPE275767
Purchase Basis Blanket Purchase Order Lines.Purchase BasisPURCHASE_BASISPURCHASE_BASIS275799
Purchase Order Line IDUnique identifier for Purchase Order LineBlanket Purchase Order Lines.Purchase Order Line IDPO_LINE_IDPO_LINE_ID155048
Retroactive Date Blanket Purchase Order Lines.Retroactive DateRETROACTIVE_DATERETROACTIVE_DATE275789
SKU Item Blanket Purchase Order Lines.SKU ItemSKU_ITEMSKU_ITEM275777
Secondary Quantity Blanket Purchase Order Lines.Secondary QuantitySECONDARY_QUANTITYSECONDARY_QUANTITY275781
Secondary Unit Of Measure Blanket Purchase Order Lines.Secondary Unit Of MeasureSECONDARY_UNIT_OF_MEASURESECONDARY_UNIT_OF_MEASURE275782
Source Document IDUnique identifier for Source DocumentBlanket Purchase Order Lines.Source Document IDSOURCE_DOCUMENT_IDSOURCE_DOCUMENT_ID162370
Source Document Line IDUnique identifier for Source Document LineBlanket Purchase Order Lines.Source Document Line IDSOURCE_DOCUMENT_LINE_IDSOURCE_DOCUMENT_LINE_ID162376
Source Document Line Number Blanket Purchase Order Lines.Source Document Line NumberSOURCE_DOCUMENT_LINE_NUMBERSOURCE_DOCUMENT_LINE_NUMBER162380
Source Document Number Blanket Purchase Order Lines.Source Document NumberSOURCE_DOCUMENT_NUMBERSOURCE_DOCUMENT_NUMBER162385
Source Document Type Blanket Purchase Order Lines.Source Document TypeSOURCE_DOCUMENT_TYPESOURCE_DOCUMENT_TYPE275780
Supplier NoteNote to supplierBlanket Purchase Order Lines.Supplier NoteSUPPLIER_NOTESUPPLIER_NOTE164268
Supplier Product Number Blanket Purchase Order Lines.Supplier Product NumberSUPPLIER_PRODUCT_NUMBERSUPPLIER_PRODUCT_NUMBER164287
Tax Code IDUnique identifier for Tax CodeBlanket Purchase Order Lines.Tax Code IDTAX_CODE_IDTAX_CODE_ID164720
Tax Code Name Blanket Purchase Order Lines.Tax Code NameTAX_CODE_NAMETAX_CODE_NAME164724
Taxable Flag Blanket Purchase Order Lines.Taxable FlagTAXABLE_FLAGTAXABLE_FLAG275774
Transaction ReasonTransaction nature of the lineBlanket Purchase Order Lines.Transaction ReasonTRANSACTION_REASONTRANSACTION_REASON165793
Type Of 10991099 tax information typeBlanket Purchase Order Lines.Type Of 1099TYPE_OF_1099TYPE_OF_1099166169
UN NumberUnited Nations hazardous material classification numberBlanket Purchase Order Lines.UN NumberUN_NUMBERUN_NUMBER166349
UN Number IDUnique identifier for United Nations hazardous material classification numberBlanket Purchase Order Lines.UN Number IDUN_NUMBER_IDUN_NUMBER_ID166358
UOM ClassUnit of measure ClassBlanket Purchase Order Lines.UOM ClassUOM_CLASSUOM_CLASS166385
UOM DescriptionUnit of measure DescriptionBlanket Purchase Order Lines.UOM DescriptionUOM_DESCRIPTIONUOM_DESCRIPTION166420
US Standard GL Transaction CodeTransaction code for creating US standard General Ledger journal entries (Oracle Public Sector Payables).Blanket Purchase Order Lines.US Standard GL Transaction CodeUSSGL_TRANSACTION_CODEUSSGL_TRANSACTION_CODE167049
Unit Of Measure Blanket Purchase Order Lines.Unit Of MeasureUNIT_OF_MEASUREUNIT_OF_MEASURE166282
Unit Price Blanket Purchase Order Lines.Unit PriceUNIT_PRICEUNIT_PRICE166313
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto