FQ354201 - Q35 Sales Order Header
Cantara Table Object used to save requests to create Sales Order Headers for later processing to standard JDE tables via standard JDE Master Business Functions.
Fields
| Name | Alias | Type |
|---|---|---|
| EdiUserId | EDUS | STRING |
| EdiTransactNumber | EDTN | STRING |
| EdiSuccessfullyProcess | EDSP | CHARACTER |
| DataItem | DTAI | STRING |
| CompanyKeyOrderNo | KCOO | COMPANY |
| DocumentOrderInvoiceE | DOCO | INTEGER |
| OrderType | DCTO | UDC |
| OrderSuffix | SFXO | STRING |
| CostCenter | MCU | BUSINESSUNIT |
| Company | CO | COMPANY |
| CompanyKeyOriginal | OKCO | COMPANY |
| OriginalPoSoNumber | OORN | STRING |
| OriginalOrderType | OCTO | UDC |
| CompanyKeyRelated | RKCO | COMPANY |
| RelatedPoSoNumber | RORN | STRING |
| RelatedOrderType | RCTO | UDC |
| AddressNumber | AN8 | ADDRESSNUMBER |
| AddressNumberShipTo | SHAN | ADDRESSNUMBER |
| AddressNumberParent | PA8 | ADDRESSNUMBER |
| DateRequestedJulian | DRQJ | DATE |
| DateTransactionJulian | TRDJ | DATE |
| ScheduledPickDate | PDDJ | DATE |
| DateOriginalPromisde | OPDJ | DATE |
| ActualShipDate | ADDJ | DATE |
| CancelDate | CNDJ | DATE |
| DatePriceEffectiveDate | PEFJ | DATE |
| DatePromisedShipJu | PPDJ | DATE |
| Reference1 | VR01 | STRING |
| Reference2Vendor | VR02 | STRING |
| DeliveryInstructLine1 | DEL1 | STRING |
| DeliveryInstructLine2 | DEL2 | STRING |
| PrintMessage1 | INMG | UDC |
| PaymentTermsCode01 | PTC | STRING |
| PaymentInstrumentA | RYIN | UDC |
| PriceAdjustmentScheduleN | ASN | UDC |
| PricingGroup | PRGP | UDC |
| DiscountTrade | TRDC | FLOAT |
| PercentRetainage1 | PCRT | FLOAT |
| TaxArea1 | TXA1 | STRING |
| TaxExplanationCode1 | EXR1 | UDC |
| CertificateTaxExempt | TXCT | STRING |
| AssociatedText | ATXT | CHARACTER |
| PriorityProcessing | PRIO | UDC |
| BackordersAllowedYN | BACK | CHARACTER |
| SubstitutesAllowedYN | SBAL | CHARACTER |
| NatureOfTransaction | NTR | UDC |
| 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 |
| ReasonCode | RCD | UDC |
| AmountOrderGross | OTOT | FLOAT |
| AmountTotalCost | TOTC | FLOAT |
| UnitOfMeasureWhtDisp | WUMD | UDC |
| UnitOfMeasureVolDisp | VUMD | UDC |
| AuthorizationNoCredit | AUTN | STRING |
| AcctNoCrBank | CACT | STRING |
| DateExpired | CEXP | DATE |
| CorrespondenceMethod | CRMD | UDC |
| CurrencyMode | CRRM | UDC |
| CurrencyCodeFrom | CRCD | STRING |
| CurrencyConverRateOv | CRR | FLOAT |
| LanguagePreference | LNGP | UDC |
| AmountForeignOpen | FAP | FLOAT |
| AmountForeignTotalC | FCST | FLOAT |
| OrderedBy | ORBY | STRING |
| OrderTakenBy | TKBY | STRING |
| UserReservedCode | URCD | STRING |
| UserReservedDate | URDT | DATE |
| UserReservedAmount | URAT | FLOAT |
| UserReservedNumber | URAB | INTEGER |
| UserReservedReference | URRF | STRING |
| TransactionOriginator | TORG | 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 |
| ReferenceUCISNo | VR03 | STRING |
| SourceOfOrder | SOOR | INTEGER |
| ScheduledShipmentTime | PMDT | INTEGER |
| PromisedDeliveryTime | RSDT | INTEGER |
| DateRequestedShip | RQSJ | DATE |
| TimeFuture2 | PSTM | INTEGER |
| PromisedPickTime | PDTT | INTEGER |
| TimeOriginalPromised | OPTT | INTEGER |
| RequestedDeliveryTime | DRQT | INTEGER |
| ActualShipmentTime | ADTM | INTEGER |
| DateActualDelivery | ADLJ | DATE |
| AddressNumberPaidBy | PBAN | INTEGER |
| AddressNumberInvoicedTo | ITAN | INTEGER |
| AddressNumberForwardedTo | FTAN | INTEGER |
| AddressNumberDeliveredTo | DVAN | ADDRESSNUMBER |
| DocumentOrderInvoi | DOC1 | INTEGER |
| DoctType | DCT4 | UDC |
| NumberChangeOrder | CORD | INTEGER |
| BuyingSegmentCode | BSC | UDC |
| CurrencyCodeBase | BCRC | STRING |
| HoldOrdersCode | HOLD | UDC |
| ApplyFreight | FUF1 | UDC |
| AddressNumberForTax | AUFT | UDC |
| AddressNumberForTransportation | AUFI | UDC |
| OPBusinessObjective | OPBO | UDC |
| OPTotalCost | OPTC | FLOAT |
| OPLatestLineDate | OPLD | DATE |
| OPNumberofBackorders | OPBK | INTEGER |
| OPNumberofSubstitutes | OPSB | INTEGER |
| OPPromisedStatus | OPPS | STRING |
| OPPartialOrderShipment | OPPL | CHARACTER |
| OPAllowMultiSource | OPMS | CHARACTER |
| OPAllowSubstitutes | OPSS | CHARACTER |
| OPAllowBackorders | OPBA | CHARACTER |
| OPPartialShipLineItems | OPLL | CHARACTER |
| PartnerAddressNumber | PRAN8 | INTEGER |
| PartnerContactLineNumID | PRCIDLN | INTEGER |
| OpportunityId | OPPID | INTEGER |
| CustomerContactLineNumberID | CCIDLN | INTEGER |
| SoldToAttention | SDATTN | STRING |
| ShipToCusContactLineNumID | SHCCIDLN | INTEGER |
| ShipToAttention | SPATTN | STRING |
| OrderTypeIndicator | OTIND | CHARACTER |