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