FQ354201 - Q35 Sales Order Header
Cantara Table Object
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 |