Powered by InfoCaptor


Previous Page   Next Page

Resale Headers
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.OZF_RESALE_HEADERS_VUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Bill to address Resale Headers.Bill to addressBILL_TO_ADDRESSBILL_TO_ADDRESS119873
Bill to city Resale Headers.Bill to cityBILL_TO_CITYBILL_TO_CITY119883
Bill to contact name Resale Headers.Bill to contact nameBILL_TO_CONTACT_NAMEBILL_TO_CONTACT_NAME119902
Bill to contact party id Resale Headers.Bill to contact party idBILL_TO_CONTACT_PARTY_IDBILL_TO_CONTACT_PARTY_ID119904
Bill to country Resale Headers.Bill to countryBILL_TO_COUNTRYBILL_TO_COUNTRY119906
Bill to cust account id Resale Headers.Bill to cust account idBILL_TO_CUST_ACCOUNT_IDBILL_TO_CUST_ACCOUNT_ID119924
Bill to duns number Resale Headers.Bill to duns numberBILL_TO_DUNS_NUMBERBILL_TO_DUNS_NUMBER119927
Bill to email Resale Headers.Bill to emailBILL_TO_EMAILBILL_TO_EMAIL119928
Bill to fax Resale Headers.Bill to faxBILL_TO_FAXBILL_TO_FAX119929
Bill to location Resale Headers.Bill to locationBILL_TO_LOCATIONBILL_TO_LOCATION119931
Bill to party id Resale Headers.Bill to party idBILL_TO_PARTY_IDBILL_TO_PARTY_ID119949
Bill to party name Resale Headers.Bill to party nameBILL_TO_PARTY_NAMEBILL_TO_PARTY_NAME119950
Bill to party site id Resale Headers.Bill to party site idBILL_TO_PARTY_SITE_IDBILL_TO_PARTY_SITE_ID119951
Bill to phone Resale Headers.Bill to phoneBILL_TO_PHONEBILL_TO_PHONE119952
Bill to postal code Resale Headers.Bill to postal codeBILL_TO_POSTAL_CODEBILL_TO_POSTAL_CODE119953
Bill to site use id Resale Headers.Bill to site use idBILL_TO_SITE_USE_IDBILL_TO_SITE_USE_ID119972
Bill to state Resale Headers.Bill to stateBILL_TO_STATEBILL_TO_STATE119976
Date ordered Resale Headers.Date orderedDATE_ORDEREDDATE_ORDERED128557
Date shipped Resale Headers.Date shippedDATE_SHIPPEDDATE_SHIPPED128588
Direct customer flag Resale Headers.Direct customer flagDIRECT_CUSTOMER_FLAGDIRECT_CUSTOMER_FLAG130097
Order category Resale Headers.Order categoryORDER_CATEGORYORDER_CATEGORY149821
Order number Resale Headers.Order numberORDER_NUMBERORDER_NUMBER149881
Order type Resale Headers.Order typeORDER_TYPEORDER_TYPE149905
Order type id Resale Headers.Order type idORDER_TYPE_IDORDER_TYPE_ID149919
Order type name Resale Headers.Order type nameORDER_TYPE_NAMEORDER_TYPE_NAME149923
Price list Resale Headers.Price listPRICE_LISTPRICE_LIST155339
Price list id Resale Headers.Price list idPRICE_LIST_IDPRICE_LIST_ID155364
Resale header id Resale Headers.Resale header idRESALE_HEADER_IDRESALE_HEADER_ID158881
Ship from cust account id Resale Headers.Ship from cust account idSHIP_FROM_CUST_ACCOUNT_IDSHIP_FROM_CUST_ACCOUNT_ID161794
Ship from party name Resale Headers.Ship from party nameSHIP_FROM_PARTY_NAMESHIP_FROM_PARTY_NAME161809
Ship to address Resale Headers.Ship to addressSHIP_TO_ADDRESSSHIP_TO_ADDRESS161842
Ship to city Resale Headers.Ship to citySHIP_TO_CITYSHIP_TO_CITY161852
Ship to contact name Resale Headers.Ship to contact nameSHIP_TO_CONTACT_NAMESHIP_TO_CONTACT_NAME161878
Ship to contact party id Resale Headers.Ship to contact party idSHIP_TO_CONTACT_PARTY_IDSHIP_TO_CONTACT_PARTY_ID161879
Ship to country Resale Headers.Ship to countrySHIP_TO_COUNTRYSHIP_TO_COUNTRY161881
Ship to cust account id Resale Headers.Ship to cust account idSHIP_TO_CUST_ACCOUNT_IDSHIP_TO_CUST_ACCOUNT_ID161900
Ship to duns number Resale Headers.Ship to duns numberSHIP_TO_DUNS_NUMBERSHIP_TO_DUNS_NUMBER161903
Ship to email Resale Headers.Ship to emailSHIP_TO_EMAILSHIP_TO_EMAIL161904
Ship to fax Resale Headers.Ship to faxSHIP_TO_FAXSHIP_TO_FAX161905
Ship to location Resale Headers.Ship to locationSHIP_TO_LOCATIONSHIP_TO_LOCATION161914
Ship to party id Resale Headers.Ship to party idSHIP_TO_PARTY_IDSHIP_TO_PARTY_ID161986
Ship to party name Resale Headers.Ship to party nameSHIP_TO_PARTY_NAMESHIP_TO_PARTY_NAME161987
Ship to party site id Resale Headers.Ship to party site idSHIP_TO_PARTY_SITE_IDSHIP_TO_PARTY_SITE_ID161989
Ship to phone Resale Headers.Ship to phoneSHIP_TO_PHONESHIP_TO_PHONE161990
Ship to postal code Resale Headers.Ship to postal codeSHIP_TO_POSTAL_CODESHIP_TO_POSTAL_CODE161991
Ship to site use id Resale Headers.Ship to site use idSHIP_TO_SITE_USE_IDSHIP_TO_SITE_USE_ID162030
Ship to state Resale Headers.Ship to stateSHIP_TO_STATESHIP_TO_STATE162042
Sold from cust account id Resale Headers.Sold from cust account idSOLD_FROM_CUST_ACCOUNT_IDSOLD_FROM_CUST_ACCOUNT_ID162227
Sold from party name Resale Headers.Sold from party nameSOLD_FROM_PARTY_NAMESOLD_FROM_PARTY_NAME162234
Status code Resale Headers.Status codeSTATUS_CODESTATUS_CODE163551
User status Resale Headers.User statusUSER_STATUSUSER_STATUS166956
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Ozf resale headers v -> Ozf claims vResale Headers.Status code = Claims.Status code Resale Headers.Order type id = Claims.Order type id Resale Headers.Ship to cust account id = Claims.Ship to cust account idMight not exist in master folderNoneNo
Ozf resale headers v -> Ozf offers vResale Headers.Status code = Offers.Status codeMight not exist in master folderNoneNo
Ozf resale headers v -> Ozf resale batches vResale Headers.Status code = Resale Batches.Status codeAlways exist in master folderNoneNo