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 |