Skip to main content

VQ3512J2 - F1201AC join F1217AC F1731 LO F17311

Cantara Business View Object for Assets/Equipment which joins all columns of standard JDE tables F1201, F1217, and selected columns of F1731 with Left Outer Join to F17311.

NOTE: As the F1731 data includes Historic and Current Location records, this view is typically used with a filter of F1731.AL < "H" to exclude Histoic records, but will include Asset Location records for <Blank>, "*" & "C" values.

Fields

NameAliasTypeTable

AssetItemNumber

NUMB

ASSETNUMBER

F1201

AssetItemNumber1

NUMB

ASSETNUMBER

F1217

AssetItemNumber2

NUMB

ASSETNUMBER

F1731

UniqueKeyIDInternal

UKID

INTEGER

F1731

UniqueKeyIDInternal1

UKID

INTEGER

F17311

Company

CO

COMPANY

F1201

UnitNumber

APID

STRING

F1201

ParentNumber

AAID

INTEGER

F1201

SerialTagNumber

ASID

STRING

F1201

MajorClass

ACL1

UDC

F1201

SubClass

ACL2

UDC

F1201

ClassCode3

ACL3

UDC

F1201

ClassCode4

ACL4

UDC

F1201

ClassCode5

ACL5

UDC

F1201

ClassCode6

ACL6

UDC

F1201

ClassCode7

ACL7

UDC

F1201

ClassCode8

ACL8

UDC

F1201

ClassCode9

ACL9

UDC

F1201

ClassCode0

ACL0

UDC

F1201

CatagoryCodeFA

FA1

UDC

F1201

CategoryCodeFA2

FA2

UDC

F1201

CategoryCodeFA3

FA3

UDC

F1201

CategoryCodeFA4

FA4

UDC

F1201

CategoryCodeFA5

FA5

UDC

F1201

CategoryCodeFA6

FA6

UDC

F1201

CategoryCodeFA7

FA7

UDC

F1201

CategoryCodeFA8

FA8

UDC

F1201

CategoryCodeFA9

FA9

UDC

F1201

CategoryCodeFA0

FA0

UDC

F1201

CategoryCodeFA21

FA21

UDC

F1201

CategoryCodeFA22

FA22

UDC

F1201

CategoryCodeFA23

FA23

UDC

F1201

Description001

DL01

STRING

F1201

Description01002

DL02

STRING

F1201

Description01003

DL03

STRING

F1201

CostCenter

MCU

BUSINESSUNIT

F1201

CostCenterLocation

LOC

BUSINESSUNIT

F1201

EquipmentStatus

EQST

UDC

F1201

AllowWorkOrderYN

WOYN

CHARACTER

F1201

ItemNumberShortKit

KIT

SHORTITEM

F1201

SubledgerInactiveCode

SBLI

UDC

F1201

CostCenterAlt

MMCU

BUSINESSUNIT

F1217

ProductFamily

PRODF

UDC

F1217

ProductModel

PRODM

UDC

F1217

CategoryCodeCustomerProfile01

ZE01

UDC

F1217

CategoryCodeCustomerProfile02

ZE02

UDC

F1217

CategoryCodeCustomerProfile03

ZE03

UDC

F1217

CategoryCodeCustomerProfile04

ZE04

UDC

F1217

CategoryCodeCustomerProfile05

ZE05

UDC

F1217

CategoryCodeCustomerProfile06

ZE06

UDC

F1217

CategoryCodeCustomerProfile07

ZE07

UDC

F1217

CategoryCodeCustomerProfile08

ZE08

UDC

F1217

CategoryCodeCustomerProfile09

ZE09

UDC

F1217

CategoryCodeCustomerProfile10

ZE10

UDC

F1217

AllowMeterSchedules

MTRYN

CHARACTER

F1217

UserReservedCode

URCD

STRING

F1217

UserReservedDate

URDT

DATE

F1217

UserReservedAmount

URAT

FLOAT

F1217

UserReservedNumber

URAB

INTEGER

F1217

UserReservedReference

URRF

STRING

F1217

CostCenter1

MCU

BUSINESSUNIT

F1217

MeterReadingRequired

MRRYN

CHARACTER

F1217

Location

LOCN

LOCATION

F1217

AddressNumberLessor

LANO

ADDRESSNUMBER

F1731

AddressNumber

AN8

ADDRESSNUMBER

F1731

CostCenterLocation1

LOC

BUSINESSUNIT

F1731

LocationHistOrSched

AL

UDC

F1731

Latitude

LATT

STRING

F17311

Longitude

LONG

STRING

F17311

Latitude1

NLATT

FLOAT

F17311

Longitude1

NLONG

FLOAT

F17311

NameMailing

MLNM

STRING

F17311

AddressLine1

ADD1

STRING

F17311

AddressLine2

ADD2

STRING

F17311

AddressLine3

ADD3

STRING

F17311

AddressLine4

ADD4

STRING

F17311

City

CTY1

STRING

F17311

CountyAddress

COUN

UDC

F17311

State

ADDS

UDC

F17311

ZipCodePostal

ADDZ

STRING

F17311

Country

CTR

UDC

F17311

ContactName

WHO

STRING

F17311

SequenceNumber1

SEQ

FLOAT

F1201

DescCompressed

DSCC

STRING

F1201

DateAcquired

DAJ

DATE

F1201

DateDisposal

DSP

DATE

F1201

NewOrUsedOnAcquisit

NORU

UDC

F1201

AmtEstSalvageVa

AESV

FLOAT

F1201

AmountReplacementCost

ARPC

FLOAT

F1201

AmtLastYearsReplace

ALRC

FLOAT

F1201

AssetCostAcctCostCen

AMCU

BUSINESSUNIT

F1201

AssetCostAcctObject

AOBJ

STRING

F1201

AssetCostAcctSubsid

ASUB

STRING

F1201

AccumDepreAcctCc

DMCU

STRING

F1201

AccumDepreAcctObj

DOBJ

STRING

F1201

AccumDepreAcctSub

DSUB

STRING

F1201

DepreciationExpenseCc

XMCU

STRING

F1201

DepreciationExpenseObj

XOBJ

STRING

F1201

DepreciaExpenseSubsid

XSUB

STRING

F1201

AssetRevenueCostCntr

RMCU

STRING

F1201

AssetRevenueObject

ROBJ

STRING

F1201

AssetRevenueSubsidiary

RSUB

STRING

F1201

AssetItemCurrentQuan

ARCQ

FLOAT

F1201

AssetItemOrigQuan

AROQ

FLOAT

F1201

TaxEntity

TXJS

ADDRESSNUMBER

F1201

AmtInvTaxCrYtd

AITY

FLOAT

F1201

AmtInvTaxCrPye

AITP

FLOAT

F1201

FinancingMethod

FINC

UDC

F1201

ItcOwnedFlag

ITCO

UDC

F1201

PurchaseOption

PURO

UDC

F1201

AmtPurchaseOptionPric

APUR

FLOAT

F1201

PurOptionCreditPercen

PURP

FLOAT

F1201

AmtPurchaseOptionMaxi

APOM

FLOAT

F1201

AddressNumberLessor1

LANO

ADDRESSNUMBER

F1201

DateContract

JCD

DATE

F1201

DateExpiredJulian

DEXJ

DATE

F1201

AmountMonthlyPayment

AMF

FLOAT

F1201

NameRemark

RMK

STRING

F1201

NameRemarksLine2

RMK2

STRING

F1201

InsurancePolicyNumber

INSP

STRING

F1201

InsuranceCompany

INSC

STRING

F1201

PolicyRenewalMonth

INSM

INTEGER

F1201

AmountInsurancePremium

INSA

FLOAT

F1201

AmountInsuranceValue

AIV

FLOAT

F1201

InsuranceValueIndex

INSI

FLOAT

F1201

DtLastChanged

LCT

DATE

F1201

State1

ADDS

UDC

F1201

DateBeginningEffective

EFTB

DATE

F1201

DateExpectedReturn

DER

DATE

F1201

ActionMessageControl

MSGA

UDC

F1201

NameExplanation

EX

STRING

F1201

NameRemarkExplanation

EXR

STRING

F1201

AddressNumber1

AN8

ADDRESSNUMBER

F1201

StandardFuelConsumptio

SFC

FLOAT

F1201

DisposalAccumDepreCc

DADC

STRING

F1201

DisposalAccumDepreObj

DADO

STRING

F1201

DisposalAccumDepreSub

DADS

STRING

F1201

UnitNo

UNIT

STRING

F1201

ItemNumber2ndKit

KITL

STRING

F1201

AfeNumber

AFE

STRING

F1201

JobCategory

JBCD

UDC

F1201

JobStep

JBST

UDC

F1201

UnionCode

UN

UDC

F1201

Criticality

CRTL

INTEGER

F1201

WarrantyFlag

WRFL

UDC

F1201

DateWarrantyExpiraJu

WARJ

DATE

F1201

UserId

USER

STRING

F1201

ProgramId

PID

STRING

F1201

WorkStationId

JOBN

STRING

F1201

DateUpdated

UPMJ

DATE

F1201

TimeLastUpdated

UPMT

INTEGER

F1201

Country1

CTR

UDC

F1217

CompanyOwned

COOWN

CHARACTER

F1217

DocumentOrderInvoiceE

DOCO

INTEGER

F1217

OrderType

DCTO

UDC

F1217

CompanyKeyOrderNo

KCOO

COMPANY

F1217

LineNumber

LNID

FLOAT

F1217

DateOrderedJulian

ORDJ

DATE

F1217

DateShippedJulian

SHPJ

DATE

F1217

ActualShipDate

ADDJ

DATE

F1217

AddressNumberShipTo

SHAN

ADDRESSNUMBER

F1217

AddressNumberParent

PA8

ADDRESSNUMBER

F1217

Salesperson1

SLSM

ADDRESSNUMBER

F1217

AddNumOwnerBilling

ANOB

ADDRESSNUMBER

F1217

RelatedPoSoNumber

RORN

STRING

F1217

RelatedOrderType

RCTO

UDC

F1217

DateCompletion

STRX

DATE

F1217

PrimaryLastVendorNo

VEND

ADDRESSNUMBER

F1217

OriginalPoSoNumber

OORN

STRING

F1217

OriginalOrderType

OCTO

UDC

F1217

CompanyKeyOriginal

OKCO

COMPANY

F1217

OrderSuffix

SFXO

STRING

F1217

OriginalLineNumber

OGNO

FLOAT

F1217

ProductComponent

PRODC

UDC

F1217

ConfiguredModel

CMOD

STRING

F1217

SystemCodeEncryptedMatri

SYEM

STRING

F1217

VehicleIdentNum

VINNU

STRING

F1217

ReferenceNumber

REFN

STRING

F1217

CreatedByUser

CRTU

STRING

F1217

Lot

LOTN

STRING

F1217

WorkOrderNumber

WOD

INTEGER

F1217

BillRevisionLevel

BREV

STRING

F1217

EffectiveFromDate

EFFF

DATE

F1217

DefaultDealer

AN8DL

ADDRESSNUMBER

F1217

AssessorNumber

AN8AS

ADDRESSNUMBER

F1217

TermsAcceptedFlag

TERMYN

CHARACTER

F1217

SalesType

SATYP

UDC

F1217

InServiceDate

INSDTE

DATE

F1217

RegistrationStatus

REGSTS

UDC

F1217

CompCode-Grp_Sys

VMRS31

UDC

F1217

CompCode-Assembly

VMRS32

UDC

F1217

Manufacturer

VMRS34

STRING

F1217

Distributor

AN8DR

ADDRESSNUMBER

F1217

EquipmentPartsNumber

EQPN

ASSETNUMBER

F1217

UserId1

USER

STRING

F1217

ProgramId1

PID

STRING

F1217

WorkStationId1

JOBN

STRING

F1217

DateUpdated1

UPMJ

DATE

F1217

TimeLastUpdated1

UPMT

INTEGER

F1217

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.