SO_SalesOrderHeader SO Sales Order Header Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: SO_SalesOrder_bus,SO_SalesJournal_upd,IT_ShoppingCart_upd,RMirror: SO_SalesOrderHistoryHeader SQL Def: N SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_SalesOrderHeader.M4T"
KPRIMARY: SalesOrderNo KCUSTOMER: ARDivisionNo+CustomerNo+SalesOrderNo KBILLTO: BillToName+SalesOrderNo KCUSTOMERPO: CustomerPONo+SalesOrderNo KAUTHORIZ: AuthorizationRequiredFlag+SalesOrderNo KDUPLICATEPO: ARDivisionNo+CustomerNo+CustomerPONo+SalesOrderNo KCOMPANYID: CRMCompanyID+SalesOrderNo KPERSONID: CRMPersonID+SalesOrderNo KPROSPECTID: CRMProspectID+SalesOrderNo
Fld Column Name M/L TUR Description/Notes Class
1 SalesOrderNo. . . . . . . . . 7 SYY Sales Order Number. . . . . . .SALESORDERNO FmtType:CHARNUM Next:SalesOrd erNo$ Notes: {SO1$(1,7)} 2 OrderDate . . . . . . . . . . 8 SNN Order Date. . . . . . . . . . .DATE DepVal:REQUIRED Notes: {SO1$(8,6)} 3 OrderType . . . . . . . . . . 1 SYN Order Type. . . . . . . . . . . Valid:S,B,M,R,Q,P Notes: S=Standard, B=Backorder, Q=Quote, M=Master order, R=Repeating order, P=Prospect Quote {SO1$(14,1)} 4 OrderStatus . . . . . . . . . 1 SYN Order Status. . . . . . . . . . DfltVal:N Valid:N,O,C,H Notes: N=New, O=Open, C=Closed, H=Hold {SO1$(279, 1)} 5 MasterRepeatingOrderNo. . . . 7 SYN Master Repeating Order Number .SALESORDERNO FmtType:CHARNUM ValGroup:Stan dardOrder Notes: {SO1$(15,7)} 6 ShipExpireDate. . . . . . . . 8 SNN Ship Expire Date. . . . . . . .DATE Notes: {SO1$(280,6)} 7 ARDivisionNo. . . . . . . . . 2 SNY AR Division Number. . . . . . .ARDIVISION Mask:00 FmtType:ZEROFILL Notes: {SO1$(22,2)} 8 CustomerNo. . . . . . . . . . 20 SYY Customer Number . . . . . . . .CUSTOMERNO FmtType:MASTERNUMC Notes: {SO1$(24,7)} 9 BillToName. . . . . . . . . . 30 SNN Bill To Name. . . . . . . . . .NAME ValGroup:CustomerRequired Notes: {SO1$(31,30)} 10 BillToAddress1. . . . . . . . 30 SNN Bill To Address Line 1. . . . .ADDRESSLINE ValGroup:CustomerRequired Notes: {SO1$(61,30)} 11 BillToAddress2. . . . . . . . 30 SNN Bill To Address Line 2. . . . .ADDRESSLINE ValGroup:CustomerRequired Notes: {SO1$(91,30)} 12 BillToAddress3. . . . . . . . 30 SNN Bill To Address Line 3. . . . .ADDRESSLINE ValGroup:CustomerRequired Notes: {SO1$(531,30)} 13 BillToCity. . . . . . . . . . 20 SNN Bill To City. . . . . . . . . .CITY ValGroup:CustomerRequired Notes: {SO1$(121,20)} 14 BillToState . . . . . . . . . 2 SYN Bill To State . . . . . . . . .STATE ValGroup:CustomerRequired Notes: {SO1$(141,2)} 15 BillToZipCode . . . . . . . . 10 SNN Bill To Zip Code. . . . . . . .ZIPCODE ValGroup:CustomerRequired Notes: {SO1$(143,10)} 16 BillToCountryCode . . . . . . 3 SYN Bill To Country Code. . . . . .COUNTRY ValGroup:CustomerRequired Notes: {SO1$(561,3)} 17 ShipToCode. . . . . . . . . . 4 SYN Ship-To Code. . . . . . . . . .SHIPTO ValGroup:CustomerRequired Notes: {SO1$(153,4)} 18 ShipToName. . . . . . . . . . 30 SNN Ship To Name. . . . . . . . . .NAME ValGroup:CustomerRequired Notes: {SO1$(157,30)} 19 ShipToAddress1. . . . . . . . 30 SNN Ship To Address Line 1. . . . .ADDRESSLINE ValGroup:CustomerRequired Notes: {SO1$(187,30)} 20 ShipToAddress2. . . . . . . . 30 SNN Ship To Address Line 2. . . . .ADDRESSLINE ValGroup:CustomerRequired Notes: {SO1$(217,30)} 21 ShipToAddress3. . . . . . . . 30 SNN Ship To Address Line 3. . . . .ADDRESSLINE ValGroup:CustomerRequired Notes: {SO1$(581,30)} 22 ShipToCity. . . . . . . . . . 20 SNN Ship To City. . . . . . . . . .CITY ValGroup:CustomerRequired Notes: {SO1$(247,20)} 23 ShipToState . . . . . . . . . 2 SYN Ship To State . . . . . . . . .STATE ValGroup:CustomerRequired Notes: {SO1$(267,2)} 24 ShipToZipCode . . . . . . . . 10 SNN Ship To Zip Code. . . . . . . .ZIPCODE ValGroup:CustomerRequired Notes: {SO1$(269,10)} 25 ShipToCountryCode . . . . . . 3 SYN Ship To Country Code. . . . . .COUNTRY ValGroup:CustomerRequired Notes: {SO1$(611,3)} 26 ShipVia . . . . . . . . . . . 15 SYN Ship Via. . . . . . . . . . . .SHIPCODE Notes: {SO1$(301,15)} 27 ShipZone. . . . . . . . . . . 5 SYN Ship Zone . . . . . . . . . . .SHIPZONE Notes: (Maintained) {SO1$(444,5)} 28 ShipZoneActual. . . . . . . . 5 SYN Ship Zone Actual. . . . . . . .SHIPZONE Notes: (Inverse If Shp As Zip) {SO1$(454,5)} 29 ShipWeight. . . . . . . . . . 5 SYN Ship Weight . . . . . . . . . .SHIPWEIGHT Mask:00000 FmtType:ZEROFILL Notes: {SO1$(449,5)} 30 CustomerPONo. . . . . . . . . 15 SNN Customer PO Number. . . . . . .CUSTOMERPONO ValGroup:CustomerRequired Notes: {SO1$(286,15)} 31 FOB . . . . . . . . . . . . . 15 SNN F.O.B.. . . . . . . . . . . . . Notes: {SO1$(316,15)} 32 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE FmtType:CHARNUM DepVal:REQUIR ED ValGroup:MultiWarehouse Notes: {SO1$(331,3)} 33 ConfirmTo . . . . . . . . . . 30 SNN Confirm To. . . . . . . . . . . DepVal:REQUIRED Notes: {SO1$(334,30)} 34 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . .COMMENT30 Notes: {SO1$(364,30)} 35 TermsCode . . . . . . . . . . 2 SNN Terms Code. . . . . . . . . . .ARTERMS Mask:00 FmtType:ZEROFILL DepVal:REQUIRED Notes: {SO1$(403,2)} 36 TaxSchedule . . . . . . . . . 9 SYN Tax Schedule. . . . . . . . . .TAXSCHEDULE FmtType:CHARNUM DepVal:REQUIR ED ValGroup:ARSalesTax Notes: {SO1$(394,9)} 37 TaxExemptNo . . . . . . . . . 15 SNN Tax Exempt Number . . . . . . . Notes: (Only If Sales Tax Reporting = Yes) {SO1$(409, 15)} 38 InvalidTaxCalc. . . . . . . . 1 SYN Invalid Tax Calculation . . . .YESNO DfltVal:N Valid:Y,N ValGroup:ARSalesTax Notes: {SO1$(430,1)} 39 PrintSalesOrders. . . . . . . 1 SYN Print Sales Orders. . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {SO1$(424,1)} 40 PrintPickingSheets. . . . . . 1 SYN Print Picking Sheets. . . . . .YESNO DfltVal:N Valid:Y,N Notes: {SO1$(425,1)} 41 LastInvoiceOrderDate. . . . . 8 SNN Last Invoice Order Date . . . .DATE Notes: {SO1$(431,6)} 42 LastInvoiceOrderNo. . . . . . 7 SYN Last Invoice Order Number . . .INVOICE FmtType:MASTERNUM Notes: {SO1$(437,7)} 43 CurrentInvoiceNo. . . . . . . 7 SYN Current Invoice Number. . . . .INVOICE FmtType:MASTERNUM Notes: {SO1$(459,7)} 44 CheckNoForDeposit . . . . . . 10 SNN Check Number For Deposit. . . .CHECKNO FmtType:CHARNUM DepVal:REQUIR ED Notes: {SO1$(466,6)} 45 CycleCode . . . . . . . . . . 2 SYN Cycle Code. . . . . . . . . . . FmtType:CHARNUM ValGroup:Mast erRepeating Notes: {SO1$(472, 2)} 46 FaxNo . . . . . . . . . . . . 17 SNN Fax Number. . . . . . . . . . .TELEPHONENO DepVal:REQUIRED Notes: {SO1$(614,17)} 47 BatchFax. . . . . . . . . . . 1 SYN Batch Fax . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {SO1$(474,1)} 48 BatchEmail. . . . . . . . . . 1 SYN Batch Email . . . . . . . . . .YESNO DfltVal:N Valid:Y,N 49 EmailAddress. . . . . . . . . 250 SNN Email Address . . . . . . . . .EMAILADDRESS 50 FreightCalculationMethod. . . 1 SYN Freight Calculation Method. . . Valid:A,P,W Notes: A=Amount, P=Product line, W=Weight {SO1$(475,1)} 51 LotSerialLinesExist . . . . . 1 SYN Lot/Serial Lines Exist. . . . .YESNO DfltVal:N Valid:Y,N Notes: {SO1$(477,1)} 52 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . .ARDIVISION FmtType:ZEROFILL ValGroup:Cus tomerRequired,SalespersonRepo rting 53 SalespersonNo . . . . . . . . 4 SYN Salesperson Number. . . . . . .SALESPERSONNO FmtType:CHARNUM ValGroup:Cust omerRequired,SalespersonRepor ting Notes: {SO1$(405,4)} 54 SplitCommissions. . . . . . . 1 SYN Split Commissions . . . . . . . DfltVal:N Valid:Y,N,O ValGroup:CustomerRequired, SplitCommission,SalespersonRe quired Notes: Y=Yes, N=No, O=Override {SO1$(478,1)} 55 SalespersonDivisionNo2. . . . 2 SNN Salesperson Division Number 2 .ARDIVISION Mask:00 FmtType:ZEROFILL ValGroup:CustomerRequired, SplitCommission,SalespersonRe quired Notes: {SO1$(479,2)} 56 SalespersonNo2. . . . . . . . 4 SYN Salesperson Number 2. . . . . .SALESPERSONNO FmtType:CHARNUM DepVal:REQUIR ED ValGroup:CustomerRequired, SplitCommission,SalespersonRe quired Notes: {SO1$(481,4)} 57 SalespersonDivisionNo3. . . . 2 SNN Salesperson Division Number 3 .ARDIVISION Mask:00 FmtType:ZEROFILL ValGroup:CustomerRequired, SplitCommission,SalespersonRe quired Notes: {SO1$(492,2)} 58 SalespersonNo3. . . . . . . . 4 SYN Salesperson Number 3. . . . . .SALESPERSONNO FmtType:CHARNUM DepVal:REQUIR ED ValGroup:CustomerRequired, SplitCommission,SalespersonRe quired Notes: {SO1$(494,4)} 59 SalespersonDivisionNo4. . . . 2 SNN Salesperson Division Number 4 .ARDIVISION Mask:00 FmtType:ZEROFILL ValGroup:CustomerRequired, SplitCommission,SalespersonRe quired Notes: {SO1$(505,2)} 60 SalespersonNo4. . . . . . . . 4 SYN Salesperson Number 4. . . . . .SALESPERSONNO FmtType:CHARNUM DepVal:REQUIR ED ValGroup:CustomerRequired, SplitCommission,SalespersonRe quired Notes: {SO1$(507,4)} 61 SalespersonDivisionNo5. . . . 2 SNN Salesperson Division Number 5 .ARDIVISION Mask:00 FmtType:ZEROFILL ValGroup:CustomerRequired, SplitCommission,SalespersonRe quired Notes: {SO1$(518,2)} 62 SalespersonNo5. . . . . . . . 4 SYN Salesperson Number 5. . . . . .SALESPERSONNO FmtType:CHARNUM DepVal:REQUIR ED ValGroup:CustomerRequired, SplitCommission,SalespersonRe quired Notes: {SO1$(520,4)} 63 EBMUserType . . . . . . . . . 1 SNN EBM Internet User Type. . . . . Valid:1,2 Notes: (1=bus. 2=consumer) {SO1$(476,1)} 64 EBMSubmissionType . . . . . . 1 SYN EBM Internet Submission Type. . Read Only:Y Notes: {SO1$(564, 1)} 65 EBMUserIDSubmittingThisOrder. 15 SYN EBM Internet User ID Submitttin Read Only:Y Notes: {SO1$(565, 15)} 66 PaymentType . . . . . . . . . 5 SYN Payment Type. . . . . . . . . .PAYMENTTYPE DepVal:REQUIRED Notes: {SO1$(631,5)} 67 OtherPaymentTypeRefNo . . . . 24 SNN Other Payment Type Reference Nu DepVal:REQUIRED Notes: {SO1$(636,24)} 68 CorporateCustIDPurchOrder . . 25 SNN Corporate Customer ID / Purchas 69 CorporateTaxOverrd. . . . . . 1 SYY Corporate Tax Overridden. . . .YESNO DfltVal:N Valid:Y,N 70 DepositCorporateTaxOverrd . . 1 SYY Deposit Corporate Tax OverriddeYESNO DfltVal:N 71 CardholderName. . . . . . . . 30 SNN Cardholder Name . . . . . . . .NAME Notes: {SO1$(660,30)} 72 ExpirationDateYear. . . . . . 4 SNN Expiration Date Year. . . . . .YEAR Mask:0000 Notes: {SO1$(690, 2)} 73 ExpirationDateMonth . . . . . 2 SNN Expiration Date Month . . . . .MONTH Mask:00 Notes: {SO1$(692,2)} 74 EncryptedCreditCardNo . . . . 24 SNN Encrypted Credit Card Number. .ENCRYPTEDCREDITCARDNO Notes: {SO1$(717,24)} 75 CancelReasonCode. . . . . . . 5 SYN Cancellation Reason Code. . . .CANCELREASONCODE FmtType:CHARNUM Notes: {SO1$(712,5)} 76 CreditCardCVV2No. . . . . . . 5 SNN Credit Card CVV2 Number . . . . Notes: {SO1$(741,4)} 77 Last4UnencryptedCreditCardNos 4 SNN Last 4 Unencrypted Credit Card Notes: {SO1$(745,4)} 78 CreditCardAuthorizationNo . . 16 SNN Credit Card Authorization Numbe Notes: {SO1$(749,16)} 79 CreditCardTransactionID . . . 10 SNN Credit Card Transaction ID. . . Notes: {SO1$(765,10)} 80 AuthorizationDate . . . . . . 8 SNN Authorization Date. . . . . . .DATE Notes: {SO1$(775,6)} 81 AuthorizationTime . . . . . . 6 SNN Authorization Time. . . . . . . Notes: {SO1$(781,6)} 82 AuthorizationCodeForDeposit . 16 SNN Authorization Code For Deposit. ValSeqNo:9999 Notes: {SO1$(787,16)} 83 CreditCardTransactionIDForDep 10 SNN Credit Card Transaction ID for Notes: {SO1$(803,10)} 84 PaymentTypeCategory . . . . . 1 SYN Payment Type Category . . . . . DfltVal:D Valid:P,D Notes: P=Payment, D=Deposit {SO1$(813,1)} 85 PayBalanceByCreditCard. . . . 1 SYN Pay Balance By Credit Card. . .YESNO DfltVal:N Valid:Y,N Notes: {SO1$(814,1)} 86 AVSAddress. . . . . . . . . . 30 SNN AVS Address Line. . . . . . . .ADDRESSLINE Notes: {SO1$(815,30)} 87 AVSCity . . . . . . . . . . . 20 SNN AVS City. . . . . . . . . . . .CITY Notes: {SO1$(845,20)} 88 AVSState. . . . . . . . . . . 2 SYN AVS State . . . . . . . . . . .STATE Notes: {SO1$(865,2)} 89 AVSZipCode. . . . . . . . . . 10 SNN AVS Zip Code. . . . . . . . . .ZIPCODE Notes: {SO1$(867,10)} 90 CreditCardComment . . . . . . 30 SNN Credit Card Comment . . . . . .COMMENT30 Notes: {SO1$(877,30)} 91 AuthorizationRequiredFlag . . 1 SYN Authorization Required Flag . . DfltVal:O Valid:N,Y,O Notes: N=CC not authorized, Y=CC Authorized, O=Other payment or no deposit {SO1$(907,1)} 92 RMANo . . . . . . . . . . . . 7 SYN RMA Number. . . . . . . . . . .RMANO FmtType:CHARNUM Notes: {SO1$(694,7)} 93 JobNo . . . . . . . . . . . . 7 SYN Job Number. . . . . . . . . . .JOBNO FmtType:CHARNUM DepVal:REQUIR ED ValGroup:JCIntegrated, CustomerRequired 94 ResidentialAddress. . . . . . 1 SYN Residential Address . . . . . .YESNO DfltVal:N Valid:Y,N 95 CRMUserID . . . . . . . . . . 11 SNN CRM User ID . . . . . . . . . . ValGroup:CU_Integrated, CU_CheckOrderType,CU_CheckCom pany 96 CRMPersonID . . . . . . . . . 11 SNN CRM Person ID . . . . . . . . . ValGroup:CU_Integrated, CU_CheckOrderType,CU_CheckCom pany 97 CRMOpportunityID. . . . . . . 11 SNN CRM Opportunity ID. . . . . . . ValGroup:CU_Integrated, CU_CheckOrderType,CU_CheckCom pany 98 CRMCompanyID. . . . . . . . . 11 SNN CRM Company ID. . . . . . . . . ValGroup:CU_Integrated, CU_CheckOrderType,CU_CheckCom pany 99 CRMProspectID . . . . . . . . 11 SNN CRM Prospect ID . . . . . . . . ValGroup:CU_Integrated 100 TaxableSubjectToDiscount. . . 13.2 NNN Taxable Subject To Discount . .AMOUNT Read Only:Y Mask:###,###, ###.00 Notes: {SO1[1]} 101 NonTaxableSubjectToDiscount . 13.2 NNN Non-Taxable Subject To DiscountAMOUNT Read Only:Y Mask:###,###, ###.00 Notes: {SO1[2]} 102 TaxSubjToDiscPrcntOfTotSubjTo 7.2 NNN Tax-Subj-To-Disc % Of Total-Sub Read Only:Y Mask:##0.00 Notes: {SO1[3]} 103 DiscountRate. . . . . . . . . 8.3 NNN Discount Rate . . . . . . . . . Mask:##0.000 Notes: {SO1[4]} 104 DiscountAmt . . . . . . . . . 12.2 NNN Discount Amount . . . . . . . .MISCAMOUNT Mask:##,###,###.00- ValSeqNo:9999 Notes: {SO1[5]} 105 TaxableAmt. . . . . . . . . . 13.2 NNN Taxable Amount. . . . . . . . .AMOUNT Read Only:Y Mask:###,###, ###.00 Notes: {SO1[6]} 106 NonTaxableAmt . . . . . . . . 13.2 NNN Non-Taxable Amount. . . . . . .AMOUNT Read Only:Y Mask:###,###, ###.00 Notes: {SO1[7]} 107 SalesTaxAmt . . . . . . . . . 12.2 NNN Sales Tax Amount. . . . . . . .MISCAMOUNT Mask:##,###,###.00- ValGroup:ARSalesTax ValSeqNo:9999 Notes: {SO1[8]} 108 CreditCardPreAuthorizationAmt 13.2 NNN Credit Card Pre-Authorization AAMOUNT Mask:###,###,###.00 Notes: {SO1[9]} 109 Weight. . . . . . . . . . . . 12.2 NNN Weight. . . . . . . . . . . . .MISCAMOUNT Mask:##,###,###.00- Notes: {SO1[11]} 110 FreightAmt. . . . . . . . . . 12.2 NNN Freight Amount. . . . . . . . .MISCAMOUNT Mask:##,###,###.00- ValSeqNo:9999 Notes: {SO1[12]} 111 DepositAmt. . . . . . . . . . 13.2 NNN Deposit Amount. . . . . . . . .AMOUNT Mask:###,###,###.00 ValSeqNo:9999 Notes: {SO1[13]} 112 CreditCardPaymentBalanceAmt . 13.2 NNN Credit Card Payment / Balance AAMOUNT Mask:###,###,###.00 Notes: {SO1[14]} 113 CommissionRate. . . . . . . . 9.3 NNN Commission Rate . . . . . . . .COMMISSIONRATE Mask:###0.000 ValGroup:Salesp ersonReporting,SalespersonReq uired Notes: {SO1[10]} 114 SplitCommRate2. . . . . . . . 9.3 NNN Split Commission Rate 2 . . . .COMMISSIONRATE Mask:###0.000 ValGroup:SplitC ommission,SalespersonRequired Notes: {SO1$(485,7)} 115 SplitCommRate3. . . . . . . . 9.3 NNN Split Commission Rate 3 . . . .COMMISSIONRATE Mask:###0.000 ValGroup:SplitC ommission,SalespersonRequired Notes: {SO1$(498,7)} 116 SplitCommRate4. . . . . . . . 9.3 NNN Split Commission Rate 4 . . . .COMMISSIONRATE Mask:###0.000 ValGroup:SplitC ommission,SalespersonRequired Notes: {SO1$(511,7)} 117 SplitCommRate5. . . . . . . . 9.3 NNN Split Commission Rate 5 . . . .COMMISSIONRATE Mask:###0.000 ValGroup:SplitC ommission,SalespersonRequired Notes: {SO1$(524,7)} 118 NumberOfShippingLabels. . . . 2.0 NNN Number Of Shipping Labels . . . Mask:00 Notes: {SO1$(426,2)} 119 LastNoOfShippingLabels. . . . 2.0 NNN Last Number Of Shipping Labels. Mask:00 Notes: {SO1$(428,2)} 120 DepositCorporateSalesTax. . . 12.2 NNN Deposit Corporate Sales Tax . .MISCAMOUNT Mask:##,###,###.00- 121 CorporateSalesTax . . . . . . 12.2 NNN Corporate Sales Tax . . . . . .MISCAMOUNT Mask:##,###,###.00- 122 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 123 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . . Read Only:Y 124 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL 125 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 126 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . . Read Only:Y 127 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL