Powered by InfoCaptor


Previous Page   Next Page

Resale Lines
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.OZF_RESALE_LINES_VUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Accepted amount Resale Lines.Accepted amountACCEPTED_AMOUNTACCEPTED_AMOUNT114040
Acctd calculated price Resale Lines.Acctd calculated priceACCTD_CALCULATED_PRICEACCTD_CALCULATED_PRICE114384
Acctd purchase price Resale Lines.Acctd purchase priceACCTD_PURCHASE_PRICEACCTD_PURCHASE_PRICE114387
Acctd selling price Resale Lines.Acctd selling priceACCTD_SELLING_PRICEACCTD_SELLING_PRICE114391
Agreement Resale Lines.AgreementAGREEMENTAGREEMENT115406
Agreement price Resale Lines.Agreement priceAGREEMENT_PRICEAGREEMENT_PRICE115441
Agreement type Resale Lines.Agreement typeAGREEMENT_TYPEAGREEMENT_TYPE115450
Agreement uom code Resale Lines.Agreement uom codeAGREEMENT_UOM_CODEAGREEMENT_UOM_CODE115453
Allowed amount Resale Lines.Allowed amountALLOWED_AMOUNTALLOWED_AMOUNT115532
Bill to contact name Resale Lines.Bill to contact nameBILL_TO_CONTACT_NAMEBILL_TO_CONTACT_NAME119903
Bill to contact party id Resale Lines.Bill to contact party idBILL_TO_CONTACT_PARTY_IDBILL_TO_CONTACT_PARTY_ID119905
Bill to cust account id Resale Lines.Bill to cust account idBILL_TO_CUST_ACCOUNT_IDBILL_TO_CUST_ACCOUNT_ID119925
Bill to cust name Resale Lines.Bill to cust nameBILL_TO_CUST_NAMEBILL_TO_CUST_NAME119926
Bill to site use address Resale Lines.Bill to site use addressBILL_TO_SITE_USE_ADDRESSBILL_TO_SITE_USE_ADDRESS119962
Bill to site use id Resale Lines.Bill to site use idBILL_TO_SITE_USE_IDBILL_TO_SITE_USE_ID119973
Bill to site use type Resale Lines.Bill to site use typeBILL_TO_SITE_USE_TYPEBILL_TO_SITE_USE_TYPE119974
Calculated amount Resale Lines.Calculated amountCALCULATED_AMOUNTCALCULATED_AMOUNT121299
Calculated price Resale Lines.Calculated priceCALCULATED_PRICECALCULATED_PRICE121312
Category name Resale Lines.Category nameCATEGORY_NAMECATEGORY_NAME121730
Claimed amount Resale Lines.Claimed amountCLAIMED_AMOUNTCLAIMED_AMOUNT122090
Corrected agreement id Resale Lines.Corrected agreement idCORRECTED_AGREEMENT_IDCORRECTED_AGREEMENT_ID123555
Corrected agreement name Resale Lines.Corrected agreement nameCORRECTED_AGREEMENT_NAMECORRECTED_AGREEMENT_NAME123556
Credit advice date Resale Lines.Credit advice dateCREDIT_ADVICE_DATECREDIT_ADVICE_DATE126711
Credit code Resale Lines.Credit codeCREDIT_CODECREDIT_CODE126743
Currency code Resale Lines.Currency codeCURRENCY_CODECURRENCY_CODE127039
Date invoiced Resale Lines.Date invoicedDATE_INVOICEDDATE_INVOICED128353
Date ordered Resale Lines.Date orderedDATE_ORDEREDDATE_ORDERED128558
Date shipped Resale Lines.Date shippedDATE_SHIPPEDDATE_SHIPPED128589
Derived agreement name Resale Lines.Derived agreement nameDERIVED_AGREEMENT_NAMEDERIVED_AGREEMENT_NAME129296
Derived bill to party name Resale Lines.Derived bill to party nameDERIVED_BILL_TO_PARTY_NAMEDERIVED_BILL_TO_PARTY_NAME129297
Derived end cust party name Resale Lines.Derived end cust party nameDERIVED_END_CUST_PARTY_NAMEDERIVED_END_CUST_PARTY_NAME129298
Derived inventory item name Resale Lines.Derived inventory item nameDERIVED_INVENTORY_ITEM_NAMEDERIVED_INVENTORY_ITEM_NAME129299
Derived ship from party name Resale Lines.Derived ship from party nameDERIVED_SHIP_FROM_PARTY_NAMEDERIVED_SHIP_FROM_PARTY_NAME129303
Derived ship to party name Resale Lines.Derived ship to party nameDERIVED_SHIP_TO_PARTY_NAMEDERIVED_SHIP_TO_PARTY_NAME129304
Derived sold from party name Resale Lines.Derived sold from party nameDERIVED_SOLD_FROM_PARTY_NAMEDERIVED_SOLD_FROM_PARTY_NAME129305
Derived uom Resale Lines.Derived uomDERIVED_UOMDERIVED_UOM129306
Direct customer flag Resale Lines.Direct customer flagDIRECT_CUSTOMER_FLAGDIRECT_CUSTOMER_FLAG130098
Disputedamount Resale Lines.DisputedamountDISPUTEDAMOUNTDISPUTEDAMOUNT130207
Distributor num Resale Lines.Distributor numDISTRIBUTOR_NUMDISTRIBUTOR_NUM130256
Distributoragreement Resale Lines.DistributoragreementDISTRIBUTORAGREEMENTDISTRIBUTORAGREEMENT130255
End cust party id Resale Lines.End cust party idEND_CUST_PARTY_IDEND_CUST_PARTY_ID132719
End cust party name Resale Lines.End cust party nameEND_CUST_PARTY_NAMEEND_CUST_PARTY_NAME132720
End cust party site address Resale Lines.End cust party site addressEND_CUST_PARTY_SITE_ADDRESSEND_CUST_PARTY_SITE_ADDRESS132721
End cust party site id Resale Lines.End cust party site idEND_CUST_PARTY_SITE_IDEND_CUST_PARTY_SITE_ID132722
End cust site use address Resale Lines.End cust site use addressEND_CUST_SITE_USE_ADDRESSEND_CUST_SITE_USE_ADDRESS132723
End cust site use code Resale Lines.End cust site use codeEND_CUST_SITE_USE_CODEEND_CUST_SITE_USE_CODE132724
End cust site use id Resale Lines.End cust site use idEND_CUST_SITE_USE_IDEND_CUST_SITE_USE_ID132725
Exchange rate Resale Lines.Exchange rateEXCHANGE_RATEEXCHANGE_RATE133792
Exchange rate date Resale Lines.Exchange rate dateEXCHANGE_RATE_DATEEXCHANGE_RATE_DATE133798
Exchange rate type Resale Lines.Exchange rate typeEXCHANGE_RATE_TYPEEXCHANGE_RATE_TYPE133808
Inventory item id Resale Lines.Inventory item idINVENTORY_ITEM_IDINVENTORY_ITEM_ID137278
Invoice number Resale Lines.Invoice numberINVOICE_NUMBERINVOICE_NUMBER137469
Item description Resale Lines.Item descriptionITEM_DESCRIPTIONITEM_DESCRIPTION137735
Item number Resale Lines.Item numberITEM_NUMBERITEM_NUMBER137842
Line tolerance amount Resale Lines.Line tolerance amountLINE_TOLERANCE_AMOUNTLINE_TOLERANCE_AMOUNT144781
Order number Resale Lines.Order numberORDER_NUMBERORDER_NUMBER149882
Orig sys uom Resale Lines.Orig sys uomORIG_SYS_UOMORIG_SYS_UOM151543
Orig system agreement curr Resale Lines.Orig system agreement currORIG_SYSTEM_AGREEMENT_CURRORIG_SYSTEM_AGREEMENT_CURR151471
Orig system agreement name Resale Lines.Orig system agreement nameORIG_SYSTEM_AGREEMENT_NAMEORIG_SYSTEM_AGREEMENT_NAME151472
Orig system agreement price Resale Lines.Orig system agreement priceORIG_SYSTEM_AGREEMENT_PRICEORIG_SYSTEM_AGREEMENT_PRICE151473
Orig system agreement status Resale Lines.Orig system agreement statusORIG_SYSTEM_AGREEMENT_STATUSORIG_SYSTEM_AGREEMENT_STATUS151474
Orig system agreement type Resale Lines.Orig system agreement typeORIG_SYSTEM_AGREEMENT_TYPEORIG_SYSTEM_AGREEMENT_TYPE151475
Orig system agreement uom Resale Lines.Orig system agreement uomORIG_SYSTEM_AGREEMENT_UOMORIG_SYSTEM_AGREEMENT_UOM151476
Orig system currency code Resale Lines.Orig system currency codeORIG_SYSTEM_CURRENCY_CODEORIG_SYSTEM_CURRENCY_CODE151478
Orig system item number Resale Lines.Orig system item numberORIG_SYSTEM_ITEM_NUMBERORIG_SYSTEM_ITEM_NUMBER151485
Orig system line reference Resale Lines.Orig system line referenceORIG_SYSTEM_LINE_REFERENCEORIG_SYSTEM_LINE_REFERENCE151486
Orig system purchase curr Resale Lines.Orig system purchase currORIG_SYSTEM_PURCHASE_CURRORIG_SYSTEM_PURCHASE_CURR151487
Orig system purchase price Resale Lines.Orig system purchase priceORIG_SYSTEM_PURCHASE_PRICEORIG_SYSTEM_PURCHASE_PRICE151488
Orig system purchase uom Resale Lines.Orig system purchase uomORIG_SYSTEM_PURCHASE_UOMORIG_SYSTEM_PURCHASE_UOM151489
Orig system quantity Resale Lines.Orig system quantityORIG_SYSTEM_QUANTITYORIG_SYSTEM_QUANTITY151490
Orig system reference Resale Lines.Orig system referenceORIG_SYSTEM_REFERENCEORIG_SYSTEM_REFERENCE151496
Orig system selling price Resale Lines.Orig system selling priceORIG_SYSTEM_SELLING_PRICEORIG_SYSTEM_SELLING_PRICE151500
Orig system uom Resale Lines.Orig system uomORIG_SYSTEM_UOMORIG_SYSTEM_UOM151504
Po number Resale Lines.Po numberPO_NUMBERPO_NUMBER155086
Po release number Resale Lines.Po release numberPO_RELEASE_NUMBERPO_RELEASE_NUMBER155094
Po type Resale Lines.Po typePO_TYPEPO_TYPE155116
Price list id Resale Lines.Price list idPRICE_LIST_IDPRICE_LIST_ID155365
Price list name Resale Lines.Price list namePRICE_LIST_NAMEPRICE_LIST_NAME155374
Product category id Resale Lines.Product category idPRODUCT_CATEGORY_IDPRODUCT_CATEGORY_ID155878
Product transfer date Resale Lines.Product transfer datePRODUCT_TRANSFER_DATEPRODUCT_TRANSFER_DATE156001
Purchase price Resale Lines.Purchase pricePURCHASE_PRICEPURCHASE_PRICE157083
Purchase uom code Resale Lines.Purchase uom codePURCHASE_UOM_CODEPURCHASE_UOM_CODE157086
Quantity Resale Lines.QuantityQUANTITYQUANTITY157279
Resale line id Resale Lines.Resale line idRESALE_LINE_IDRESALE_LINE_ID158882
Resale transfer type Resale Lines.Resale transfer typeRESALE_TRANSFER_TYPERESALE_TRANSFER_TYPE158883
Selling price Resale Lines.Selling priceSELLING_PRICESELLING_PRICE161314
Ship from contact name Resale Lines.Ship from contact nameSHIP_FROM_CONTACT_NAMESHIP_FROM_CONTACT_NAME161792
Ship from contact party id Resale Lines.Ship from contact party idSHIP_FROM_CONTACT_PARTY_IDSHIP_FROM_CONTACT_PARTY_ID161793
Ship from cust account id Resale Lines.Ship from cust account idSHIP_FROM_CUST_ACCOUNT_IDSHIP_FROM_CUST_ACCOUNT_ID161795
Ship from cust name Resale Lines.Ship from cust nameSHIP_FROM_CUST_NAMESHIP_FROM_CUST_NAME161796
Ship from site address Resale Lines.Ship from site addressSHIP_FROM_SITE_ADDRESSSHIP_FROM_SITE_ADDRESS161810
Ship from site id Resale Lines.Ship from site idSHIP_FROM_SITE_IDSHIP_FROM_SITE_ID161811
Ship to contact party id Resale Lines.Ship to contact party idSHIP_TO_CONTACT_PARTY_IDSHIP_TO_CONTACT_PARTY_ID161880
Ship to cust account id Resale Lines.Ship to cust account idSHIP_TO_CUST_ACCOUNT_IDSHIP_TO_CUST_ACCOUNT_ID161901
Ship to cust name Resale Lines.Ship to cust nameSHIP_TO_CUST_NAMESHIP_TO_CUST_NAME161902
Ship to party name Resale Lines.Ship to party nameSHIP_TO_PARTY_NAMESHIP_TO_PARTY_NAME161988
Ship to site use address Resale Lines.Ship to site use addressSHIP_TO_SITE_USE_ADDRESSSHIP_TO_SITE_USE_ADDRESS162005
Ship to site use id Resale Lines.Ship to site use idSHIP_TO_SITE_USE_IDSHIP_TO_SITE_USE_ID162031
Ship to site use type Resale Lines.Ship to site use typeSHIP_TO_SITE_USE_TYPESHIP_TO_SITE_USE_TYPE162040
Sold from contact party id Resale Lines.Sold from contact party idSOLD_FROM_CONTACT_PARTY_IDSOLD_FROM_CONTACT_PARTY_ID162225
Sold from contact party name Resale Lines.Sold from contact party nameSOLD_FROM_CONTACT_PARTY_NAMESOLD_FROM_CONTACT_PARTY_NAME162226
Sold from cust account id Resale Lines.Sold from cust account idSOLD_FROM_CUST_ACCOUNT_IDSOLD_FROM_CUST_ACCOUNT_ID162228
Sold from cust name Resale Lines.Sold from cust nameSOLD_FROM_CUST_NAMESOLD_FROM_CUST_NAME162229
Sold from site address Resale Lines.Sold from site addressSOLD_FROM_SITE_ADDRESSSOLD_FROM_SITE_ADDRESS162235
Sold from site id Resale Lines.Sold from site idSOLD_FROM_SITE_IDSOLD_FROM_SITE_ID162236
Status code Resale Lines.Status codeSTATUS_CODESTATUS_CODE163552
Tolerance flag Resale Lines.Tolerance flagTOLERANCE_FLAGTOLERANCE_FLAG165172
Total accepted amount Resale Lines.Total accepted amountTOTAL_ACCEPTED_AMOUNTTOTAL_ACCEPTED_AMOUNT165197
Total allowed amount Resale Lines.Total allowed amountTOTAL_ALLOWED_AMOUNTTOTAL_ALLOWED_AMOUNT165217
Total claimed amount Resale Lines.Total claimed amountTOTAL_CLAIMED_AMOUNTTOTAL_CLAIMED_AMOUNT165228
Tracing flag Resale Lines.Tracing flagTRACING_FLAGTRACING_FLAG165523
Transfer type meaning Resale Lines.Transfer type meaningTRANSFER_TYPE_MEANINGTRANSFER_TYPE_MEANING165963
Uom code Resale Lines.Uom codeUOM_CODEUOM_CODE166415
Upc code Resale Lines.Upc codeUPC_CODEUPC_CODE166446
User status Resale Lines.User statusUSER_STATUSUSER_STATUS166957
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Ozf resale lines v -> Ozf claim lines vResale Lines.Currency code = Claim Lines.Currency code Resale Lines.Exchange rate type = Claim Lines.Exchange rate type Resale Lines.Exchange rate date = Claim Lines.Exchange rate date Resale Lines.Exchange rate = Claim Lines.Exchange rateMight not exist in master folderNoneNo
Ozf resale lines v -> Ozf claims vResale Lines.Status code = Claims.Status code Resale Lines.Currency code = Claims.Currency code Resale Lines.Exchange rate type = Claims.Exchange rate type Resale Lines.Exchange rate date = Claims.Exchange rate date Resale Lines.Exchange rate = Claims.Exchange rate Resale Lines.Ship to cust account id = Claims.Ship to cust account idMight not exist in master folderNoneNo
Ozf resale lines v -> Ozf offers vResale Lines.Currency code = Offers.Currency code Resale Lines.Status code = Offers.Status codeMight not exist in master folderNoneNo
Ozf resale lines v -> Ozf resale batches vResale Lines.Status code = Resale Batches.Status code Resale Lines.Currency code = Resale Batches.Currency code Resale Lines.Claimed amount = Resale Batches.Claimed amount Resale Lines.Allowed amount = Resale Batches.Allowed amount Resale Lines.Accepted amount = Resale Batches.Accepted amount Resale Lines.Credit code = Resale Batches.Credit code Resale Lines.Credit advice date = Resale Batches.Credit advice dateMight not exist in master folderNoneNo
Ozf resale lines v -> Ozf resale headers v. ? .Might not exist in master folderNoneNo
Folder Filters
Used In ConditionItemBa NameBase ObjectFilter NameFilter TypeFolder Name
Hierarchies
Hierarchy NameCreated ByHierarchy LevelHierarchy Details
Item Classes
Item Class NamePrimary FolderUsed ByAlternate Sort
Security
Administration AllowedUser Role Responsibility
YesOracle Trade Management User
YesSYSADMIN
YesSystem Administrator
YesXXLS_APPS_EUL_US
Summaries
Summary Set NameOwnerTable NameTable ColumnMap ToFolder NameAggregationItem Name