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