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
| 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 |