FQ354202 - Q35 Sales Order Detail
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 |