Cantara Table Object used to save requests to create Sales Order Details for later processing to standard JDE tables via standard JDE Master Business Functions.
Fields
|
Name |
Alias |
Type |
|---|---|---|
|
EdiUserId |
EDUS |
STRING |
|
EdiTransactNumber |
EDTN |
STRING |
|
EdiLineNumber |
EDLN |
FLOAT |
|
EdiSuccessfullyProcess |
EDSP |
CHARACTER |
|
ActionCode2 |
ACTN |
CHARACTER |
|
DataItem |
DTAI |
STRING |
|
CompanyKeyOrderNo |
KCOO |
COMPANY |
|
DocumentOrderInvoiceE |
DOCO |
INTEGER |
|
OrderType |
DCTO |
UDC |
|
LineNumber |
LNID |
FLOAT |
|
OrderSuffix |
SFXO |
STRING |
|
CostCenter |
MCU |
BUSINESSUNIT |
|
Company |
CO |
COMPANY |
|
CompanyKeyOriginal |
OKCO |
COMPANY |
|
OriginalPoSoNumber |
OORN |
STRING |
|
OriginalOrderType |
OCTO |
UDC |
|
OriginalLineNumber |
OGNO |
FLOAT |
|
CompanyKeyRelated |
RKCO |
COMPANY |
|
RelatedPoSoNumber |
RORN |
STRING |
|
RelatedOrderType |
RCTO |
UDC |
|
RelatedPoSoLineNo |
RLLN |
FLOAT |
|
ContractNumberDistributi |
DMCT |
STRING |
|
ContractSupplementDistri |
DMCS |
INTEGER |
|
AddressNumber |
AN8 |
ADDRESSNUMBER |
|
AddressNumberShipTo |
SHAN |
ADDRESSNUMBER |
|
AddressNumberParent |
PA8 |
ADDRESSNUMBER |
|
DateRequestedJulian |
DRQJ |
DATE |
|
DateTransactionJulian |
TRDJ |
DATE |
|
DateOriginalPromisde |
OPDJ |
DATE |
|
ActualShipDate |
ADDJ |
DATE |
|
DateInvoiceJulian |
IVD |
DATE |
|
CancelDate |
CNDJ |
DATE |
|
DtForGLAndVouch1 |
DGL |
DATE |
|
DateReleaseJulian |
RSDJ |
DATE |
|
DatePriceEffectiveDate |
PEFJ |
DATE |
|
DatePromisedShipJu |
PPDJ |
DATE |
|
Reference1 |
VR01 |
STRING |
|
Reference2Vendor |
VR02 |
STRING |
|
IdentifierShortItem |
ITM |
SHORTITEM |
|
Identifier2ndItem |
LITM |
STRING |
|
Identifier3rdItem |
AITM |
STRING |
|
Location |
LOCN |
LOCATION |
|
Lot |
LOTN |
STRING |
|
FromGrade |
FRGD |
UDC |
|
ThruGrade |
THGD |
UDC |
|
FromPotency |
FRMP |
FLOAT |
|
ThruPotency |
THRP |
FLOAT |
|
DaysPastExpiration |
EXDP |
INTEGER |
|
DescriptionLine1 |
DSC1 |
STRING |
|
DescriptionLine2 |
DSC2 |
STRING |
|
LineType |
LNTY |
STRING |
|
StatusCodeNext |
NXTR |
UDC |
|
StatusCodeLast |
LTTR |
UDC |
|
CostCenterHeader |
EMCU |
BUSINESSUNIT |
|
ItemNumberRelatedKit |
RLIT |
STRING |
|
LineNumberKitMaster |
KTLN |
FLOAT |
|
ComponentNumber |
CPNT |
FLOAT |
|
RelatedKitComponent |
RKIT |
INTEGER |
|
NumbOfCpntPerParent |
KTP |
INTEGER |
|
SalesReportingCode1 |
SRP1 |
UDC |
|
SalesReportingCode2 |
SRP2 |
UDC |
|
SalesReportingCode3 |
SRP3 |
UDC |
|
SalesReportingCode4 |
SRP4 |
UDC |
|
SalesReportingCode5 |
SRP5 |
UDC |
|
PurchasingReportCode1 |
PRP1 |
UDC |
|
PurchasingReportCode2 |
PRP2 |
UDC |
|
PurchasingReportCode3 |
PRP3 |
UDC |
|
PurchasingReportCode4 |
PRP4 |
UDC |
|
PurchasingReportCode5 |
PRP5 |
UDC |
|
UnitOfMeasureAsInput |
UOM |
UDC |
|
UnitsTransactionQty |
UORG |
INTEGER |
|
UnitsQuantityShipped |
SOQS |
INTEGER |
|
UnitsQuanBackorHeld |
SOBK |
INTEGER |
|
UnitsQuantityCanceled |
SOCN |
INTEGER |
|
UnitsQuantityFuture |
SONE |
INTEGER |
|
UnitsOpenQuantity |
UOPN |
INTEGER |
|
QuantityShippedToDate |
QTYT |
INTEGER |
|
QuantityRelieved |
QRLV |
INTEGER |
|
CommittedHS |
COMM |
UDC |
|
OtherQuantity12 |
OTQY |
CHARACTER |
|
AmtPricePerUnit2 |
UPRC |
FLOAT |
|
AmountOpen1 |
AOPN |
FLOAT |
|
PriceOverrideCode |
PROV |
CHARACTER |
|
TemporaryPriceYN |
TPC |
CHARACTER |
|
UnitOfMeasureEntUP |
APUM |
UDC |
|
AmtListPricePerUnit |
LPRC |
FLOAT |
|
AmountUnitCost |
UNCS |
FLOAT |
|
AmountExtendedCost |
ECST |
FLOAT |
|
CostOverrideCode |
CSTO |
CHARACTER |
|
ExtendedCostTransfer |
TCST |
FLOAT |
|
PrintMessage1 |
INMG |
UDC |
|
PaymentTermsCode01 |
PTC |
STRING |
|
PaymentInstrumentA |
RYIN |
UDC |
|
BasedonDate |
DTBS |
UDC |
|
DiscountTrade |
TRDC |
FLOAT |
|
TradeDiscountOld |
FUN2 |
FLOAT |
|
PriceAdjustmentScheduleN |
ASN |
UDC |
|
PricingCategory |
PRGR |
UDC |
|
PricingCategoryLevel1 |
CLVL |
STRING |
|
DiscountCash |
CADC |
FLOAT |
|
CompanyKey |
KCO |
COMPANY |
|
DocVoucherInvoiceE |
DOC |
INTEGER |
|
DocumentType |
DCT |
UDC |
|
OriginalDocumentType |
ODCT |
UDC |
|
DocumentCompanyOriginal |
OKC |
COMPANY |
|
PickSlipNumber |
PSN |
INTEGER |
|
DeliveryNumber |
DELN |
INTEGER |
|
TaxableYN |
TAX1 |
UDC |
|
TaxArea1 |
TXA1 |
STRING |
|
TaxExplanationCode1 |
EXR1 |
UDC |
|
AssociatedText |
ATXT |
CHARACTER |
|
PriorityProcessing |
PRIO |
UDC |
|
ResolutionCodeBC |
RESL |
CHARACTER |
|
BackordersAllowedYN |
BACK |
CHARACTER |
|
SubstitutesAllowedYN |
SBAL |
CHARACTER |
|
PartialShipmntsAllowY |
APTS |
CHARACTER |
|
LineofBusiness |
LOB |
UDC |
|
EndUse |
EUSE |
UDC |
|
DutyStatus |
DTYS |
UDC |
|
NatureOfTransaction |
NTR |
UDC |
|
PrimaryLastVendorNo |
VEND |
ADDRESSNUMBER |
|
BuyerNumber |
ANBY |
ADDRESSNUMBER |
|
Carrier |
CARS |
ADDRESSNUMBER |
|
ModeOfTransport |
MOT |
UDC |
|
ConditionsOfTransport |
COT |
UDC |
|
RouteCode |
ROUT |
UDC |
|
StopCode |
STOP |
UDC |
|
ZoneNumber |
ZON |
UDC |
|
ContainerID |
CNID |
STRING |
|
FreightHandlingCode |
FRTH |
UDC |
|
ApplyFreightYN |
AFT |
CHARACTER |
|
ApplyFreight |
FUF1 |
UDC |
|
FreightCalculatedYN |
FRTC |
CHARACTER |
|
ShippingCommodityClass |
SHCM |
UDC |
|
ShippingConditionsCode |
SHCN |
UDC |
|
SerialNumberLot |
SERN |
STRING |
|
UnitOfMeasurePrimary |
UOM1 |
UDC |
|
UnitsPrimaryQtyOrder |
PQOR |
INTEGER |
|
UnitOfMeasureSecondary |
UOM2 |
UDC |
|
UnitsSecondaryQtyOr |
SQOR |
INTEGER |
|
UnitOfMeasurePricing |
UOM4 |
UDC |
|
AmountUnitWeight |
ITWT |
FLOAT |
|
WeightUnitOfMeasure |
WTUM |
UDC |
|
AmountUnitVolume |
ITVL |
FLOAT |
|
VolumeUnitOfMeasure |
VLUM |
UDC |
|
RepriceBasketPriceCat |
RPRC |
UDC |
|
OrderRepriceCategory |
ORPR |
UDC |
|
OrderRepricedIndicator |
ORP |
CHARACTER |
|
InventoryCostingMeth |
CMGP |
STRING |
|
Century |
CTRY |
INTEGER |
|
FiscalYear1 |
FY |
INTEGER |
|
SalesOrderStatus01 |
SO01 |
CHARACTER |
|
SalesOrderStatus02 |
SO02 |
CHARACTER |
|
SalesOrderStatus03 |
SO03 |
CHARACTER |
|
SalesOrderStatus05 |
SO05 |
CHARACTER |
|
SalesOrderStatus06 |
SO06 |
CHARACTER |
|
SalesOrderStatus07 |
SO07 |
CHARACTER |
|
SalesOrderStatus08 |
SO08 |
CHARACTER |
|
SalesOrderStatus09 |
SO09 |
CHARACTER |
|
SalesOrderStatus10 |
SO10 |
CHARACTER |
|
SalesOrderStatus11 |
SO11 |
CHARACTER |
|
SalesOrderStatus12 |
SO12 |
CHARACTER |
|
SalesOrderStatus13 |
SO13 |
CHARACTER |
|
SalesOrderStatus14 |
SO14 |
CHARACTER |
|
SalesOrderStatus15 |
SO15 |
CHARACTER |
|
ApplyCommissionYN |
ACOM |
CHARACTER |
|
CommissionCategory |
CMCG |
STRING |
|
ReasonCode |
RCD |
UDC |
|
GrossWeight |
GRWT |
FLOAT |
|
UnitOfMeasureGrossWt |
GWUM |
UDC |
|
Subledger |
SBL |
STRING |
|
SubledgerType |
SBLT |
UDC |
|
PriceCode1 |
UPC1 |
UDC |
|
PriceCode2 |
UPC2 |
UDC |
|
PriceCode3 |
UPC3 |
UDC |
|
StatusInWarehouse |
SWMS |
CHARACTER |
|
WoOrderFreezeCode |
UNCD |
UDC |
|
CorrespondenceMethod |
CRMD |
UDC |
|
CurrencyCodeFrom |
CRCD |
STRING |
|
CurrencyConverRateOv |
CRR |
FLOAT |
|
AmountListPriceForeign |
FPRC |
FLOAT |
|
AmtForPricePerUnit |
FUP |
FLOAT |
|
AmountForeignExtPrice |
FEA |
FLOAT |
|
AmountForeignUnitCost |
FUC |
FLOAT |
|
UserReservedCode |
URCD |
STRING |
|
UserReservedDate |
URDT |
DATE |
|
UserReservedAmount |
URAT |
FLOAT |
|
UserReservedReference |
URRF |
STRING |
|
UserId |
USER |
STRING |
|
ProgramId |
PID |
STRING |
|
WorkStationId |
JOBN |
STRING |
|
DateUpdated |
UPMJ |
DATE |
|
TimeOfDay |
TDAY |
INTEGER |
|
IntegrationReference01 |
IR01 |
STRING |
|
IntegrationReference02 |
IR02 |
STRING |
|
IntegrationReference03 |
IR03 |
STRING |
|
IntegrationReference04 |
IR04 |
STRING |
|
IntegrationReference05 |
IR05 |
STRING |
|
SourceOfOrder |
SOOR |
INTEGER |
|
DemandUniqueKey |
DEID |
INTEGER |
|
PullSignal |
PSIG |
STRING |
|
ScheduledShipmentTime |
PMDT |
INTEGER |
|
TimeRelease |
RLTM |
INTEGER |
|
ActualShipmentTime |
ADTM |
INTEGER |
|
TimeOriginalPromised |
OPTT |
INTEGER |
|
PromisedPickTime |
PDTT |
INTEGER |
|
TimeFuture2 |
PSTM |
INTEGER |
|
PromotionID |
PMTN |
STRING |
|
BuyingSegmentCode |
BSC |
UDC |
|
CurrentBuyingSegmentCode |
CBSC |
UDC |
|
RevisionReason |
RFRV |
UDC |
|
ShipmentNumber |
SHPN |
INTEGER |
|
ProjectNumber |
PRJM |
INTEGER |
|
HoldOrdersCode |
HOLD |
UDC |
|
PaymentTermsOverride |
PMTO |
CHARACTER |
|
DualUnitOfMeasureItem |
DUAL |
CHARACTER |
|
ProductionNumber |
PMPN |
STRING |
|
GlClass |
GLC |
STRING |
|
CodeLocationTaxStat |
LCOD |
UDC |
|
TransactionOriginator |
TORG |
STRING |
|
ReleaseNumber |
RLNU |
STRING |
|
AmountExtendedPrice |
AEXP |
FLOAT |
|
OriginalDocumentNo |
ODOC |
INTEGER |
|
AmountForeignExtCost |
FEC |
FLOAT |
|
UserReservedNumber |
URAB |
INTEGER |
|
RequestedDeliveryTime |
DRQT |
INTEGER |
|
AddressNumberDeliveredTo |
DVAN |
ADDRESSNUMBER |
|
ScheduledPickDate |
PDDJ |
DATE |
|
SalesOrderStatus04 |
SO04 |
CHARACTER |
|
DateRelease |
RLDJ |
DATE |
|
ShipToCusContactLineNumID |
SHCCIDLN |
INTEGER |
|
OpportunityId |
OPPID |
INTEGER |
|
ShipToAttention |
SPATTN |
STRING |
|
CatalogName |
CATNM |
STRING |
|
SalesOrderStatus18 |
SO18 |
CHARACTER |
|
OrganizationTypeStructur |
OSTP |
UDC |