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
|
Name |
Alias |
Type |
Table |
|---|---|---|---|
|
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 |