Powered by InfoCaptor


Previous Page   Next Page

Contract Savings
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.POA_BIS_SAVINGS_VUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Account IDUnique identification number assigned to an account code combination, which is a concatenation of the account segment values.Contract Savings.Account IDACCOUNT_IDACCOUNT_ID114213
Buyer Contract Savings.BuyerBUYER_NAMEBUYER121225
Buyer ID Contract Savings.Buyer IDBUYER_IDBUYER_ID121238
Commodity Contract Savings.CommodityCATEGORY_NAMECOMMODITY122674
Commodity ID Contract Savings.Commodity IDCATEGORY_IDCOMMODITY_ID122682
Company ID Contract Savings.Company IDCOMPANY_IDCOMPANY_ID122773
Contract Purchases Contract Savings.Contract PurchasesCONTRACT_AMOUNTCONTRACT_PURCHASES123368
Cost Center ID Contract Savings.Cost Center IDCOST_CENTER_IDCOST_CENTER_ID123645
Created By Contract Savings.Created ByCREATED_BYCREATED_BY125209
Creation Date Contract Savings.Creation DateCREATION_DATECREATION_DATE126636
Currency CodeCurrency code for pricelist; Contract Savings.Currency CodeCURRENCY_CODECURRENCY_CODE127047
Distribution Transaction ID Contract Savings.Distribution Transaction IDDISTRIBUTION_TRANSACTION_IDDISTRIBUTION_TRANSACTION_ID130254
Document NumberThe journal entry document number.Contract Savings.Document NumberDOCUMENT_NUMBERDOCUMENT_NUMBER130342
Document Type Code Contract Savings.Document Type CodeDOCUMENT_TYPE_CODEDOCUMENT_TYPE_CODE130372
Item Contract Savings.ItemITEM_NAMEITEM137694
Item IDSurrogate key for the item for which results are recorded.Contract Savings.Item IDITEM_IDITEM_ID137801
Last Update Date Contract Savings.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE141163
Last Update Login Contract Savings.Last Update LoginLAST_UPDATE_LOGINLAST_UPDATE_LOGIN141672
Last Updated By Contract Savings.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139789
Leakage Contract Savings.LeakagePOT_CONTRACT_AMOUNTLEAKAGE141732
Negative Potential Savings Contract Savings.Negative Potential SavingsNEGATIVE_POTENTIAL_SAVINGNEGATIVE_POTENTIAL_SAVINGS147884
Non Contract Purchases Contract Savings.Non Contract PurchasesNON_CONTRACT_AMOUNTNON_CONTRACT_PURCHASES148157
Operating Unit Contract Savings.Operating UnitOPERATING_UNIT_NAMEOPERATING_UNIT149521
Operating Unit ID Contract Savings.Operating Unit IDOPERATING_UNIT_IDOPERATING_UNIT_ID149528
Positive Potential Savings Contract Savings.Positive Potential SavingsPOSITIVE_POTENTIAL_SAVINGPOSITIVE_POTENTIAL_SAVINGS154919
Potential Savings Contract Savings.Potential SavingsPOTENTIAL_SAVINGPOTENTIAL_SAVINGS155003
Program Application ID Contract Savings.Program Application IDPROGRAM_APPLICATION_IDPROGRAM_APPLICATION_ID156196
Program ID Contract Savings.Program IDPROGRAM_IDPROGRAM_ID156261
Program Update Date Contract Savings.Program Update DatePROGRAM_UPDATE_DATEPROGRAM_UPDATE_DATE156346
Project IDIdentifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects.Contract Savings.Project IDPROJECT_IDPROJECT_ID156503
Purchase Order Date Contract Savings.Purchase Order DatePURCHASE_CREATION_DATEPURCHASE_ORDER_DATE157049
Purchase Order Date - Day Contract Savings.Purchase Order Date PURCHASE_ORDER_DATE_-_DAY189229
Purchase Order Date - Month Contract Savings.Purchase Order Date PURCHASE_ORDER_DATE_-_MONTH189231
Purchase Order Date - Quarter Contract Savings.Purchase Order Date PURCHASE_ORDER_DATE_-_QUARTER189233
Purchase Order Date - Year Contract Savings.Purchase Order Date PURCHASE_ORDER_DATE_-_YEAR189235
Rate Date Contract Savings.Rate DateRATE_DATERATE_DATE157552
Rate Type Contract Savings.Rate TypeRATE_TYPERATE_TYPE157638
Request ID Contract Savings.Request IDREQUEST_IDREQUEST_ID158783
Requestor ID Contract Savings.Requestor IDREQUESTOR_IDREQUESTOR_ID158704
Ship To Location ID Contract Savings.Ship To Location IDSHIP_TO_LOCATION_IDSHIP_TO_LOCATION_ID161941
Ship To Organization Contract Savings.Ship To OrganizationSHIP_TO_ORGANIZATION_NAMESHIP_TO_ORGANIZATION161958
Ship To Organization ID Contract Savings.Ship To Organization IDSHIP_TO_ORGANIZATION_IDSHIP_TO_ORGANIZATION_ID161967
Supplier Contract Savings.SupplierSUPPLIER_NAMESUPPLIER164174
Supplier ID Contract Savings.Supplier IDSUPPLIER_IDSUPPLIER_ID164206
Supplier Site Contract Savings.Supplier SiteSUPPLIER_SITE_NAMESUPPLIER_SITE164299
Supplier Site ID Contract Savings.Supplier Site IDSUPPLIER_SITE_IDSUPPLIER_SITE_ID164323
Task IDIdentifier of the task from which costs are collected, summarized, and transferred from Oracle Projects. This column is only populated if the costs were summarized by task.Contract Savings.Task IDTASK_IDTASK_ID164603
Total Purchase Quantity Contract Savings.Total Purchase QuantityTOTAL_PURCHASE_QTYTOTAL_PURCHASE_QUANTITY165350
Total Purchases Contract Savings.Total PurchasesPURCHASE_AMOUNTTOTAL_PURCHASES165349
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto