VQ354104 - Q35 Item Xref F4101/F4102/F4104
Cantara Business View Object which joins standard JDE tables F4101, F4102 and F4104
Fields
Name | Alias | Type | Table |
|---|---|---|---|
IdentifierShortItem | ITM | SHORTITEM | F4104 |
IdentifierShortItem1 | ITM | SHORTITEM | F4102 |
IdentifierShortItem2 | ITM | SHORTITEM | F4101 |
CostCenter | MCU | BUSINESSUNIT | F4102 |
AddressNumber | AN8 | ADDRESSNUMBER | F4104 |
TypeCrossReferTypeC | XRT | UDC | F4104 |
DateExpiredJulian1 | EXDJ | DATE | F4104 |
ItemNoCustomerVendor | CITM | STRING | F4104 |
ItemRevLevelCustomerSupplier | CIRV | STRING | F4104 |
DateEffectiveJulian1 | EFTJ | DATE | F4104 |
CostCenter1 | MCU | BUSINESSUNIT | F4104 |
DescriptionLine2 | DSC2 | STRING | F4104 |
DescriptionLine1 | DSC1 | STRING | F4104 |
SearchTextCompressed | ALN | STRING | F4104 |
Identifier3rdItem | AITM | STRING | F4104 |
Identifier2ndItem | LITM | STRING | F4104 |
DateUpdated | UPMJ | DATE | F4104 |
Identifier2ndItem1 | LITM | STRING | F4101 |
Identifier3rdItem1 | AITM | STRING | F4101 |
SalesReportingCode5 | SRP5 | UDC | F4101 |
SalesReportingCode4 | SRP4 | UDC | F4101 |
SalesReportingCode3 | SRP3 | UDC | F4101 |
SalesReportingCode2 | SRP2 | UDC | F4101 |
SalesReportingCode1 | SRP1 | UDC | F4101 |
SearchTextCompressed1 | ALN | STRING | F4101 |
SearchText | SRTX | STRING | F4101 |
DescriptionLine21 | DSC2 | STRING | F4101 |
DescriptionLine11 | DSC1 | STRING | F4101 |
PurchasingReportCode5 | PRP5 | UDC | F4101 |
PurchasingReportCode4 | PRP4 | UDC | F4101 |
PurchasingReportCode3 | PRP3 | UDC | F4101 |
PurchasingReportCode2 | PRP2 | UDC | F4101 |
PurchasingReportCode1 | PRP1 | UDC | F4101 |
SalesReportingCode10 | SRP0 | UDC | F4101 |
SalesReportingCode9 | SRP9 | UDC | F4101 |
SalesReportingCode8 | SRP8 | UDC | F4101 |
SalesReportingCode7 | SRP7 | UDC | F4101 |
SalesReportingCode6 | SRP6 | UDC | F4101 |
StockingType | STKT | UDC | F4101 |
LineType | LNTY | STRING | F4101 |
SalesReportingCode31 | SRP3 | UDC | F4102 |
SalesReportingCode21 | SRP2 | UDC | F4102 |
SalesReportingCode11 | SRP1 | UDC | F4102 |
PurchasingReportCode31 | PRP3 | UDC | F4102 |
PurchasingReportCode21 | PRP2 | UDC | F4102 |
PurchasingReportCode11 | PRP1 | UDC | F4102 |
SalesReportingCode101 | SRP0 | UDC | F4102 |
SalesReportingCode91 | SRP9 | UDC | F4102 |
SalesReportingCode81 | SRP8 | UDC | F4102 |
SalesReportingCode71 | SRP7 | UDC | F4102 |
SalesReportingCode61 | SRP6 | UDC | F4102 |
SalesReportingCode51 | SRP5 | UDC | F4102 |
SalesReportingCode41 | SRP4 | UDC | F4102 |
GlCategory | GLPT | UDC | F4102 |
StockingType1 | STKT | UDC | F4102 |
LineType1 | LNTY | STRING | F4102 |
PrimaryLastVendorNo | VEND | ADDRESSNUMBER | F4102 |