Skip to main content
Skip table of contents

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.