Skip to main content
Skip table of contents

VQ3512J1 - F1201 join F1217 F1731 LO F17311

Cantara Business View Object for Assets/Equipment which joins selective columns of standard JDE tables F1201, F1217, 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

JavaScript errors detected

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

If this problem persists, please contact our support.