SO_InvoiceWrk SO Invoice Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: SO_InvoicePrinting_rpt,AR_InvoiceHistoryPrinting_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_InvoiceWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . . 2 GroupField. . . . . . . . . . 10 SNN Group Field . . . . . . . . . . 3 InvoiceNo . . . . . . . . . . 7 SNN InvoiceNo . . . . . . . . . . . 4 HeaderSeqNo . . . . . . . . . 6 SNN Header Sequence Number. . . . . 5 InvoiceType . . . . . . . . . 2 SNN Invoice Type. . . . . . . . . . DfltVal:IN 6 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE 7 SalesOrderNo. . . . . . . . . 7 SNN Sales Order Number. . . . . . . 8 OrderDate . . . . . . . . . . 8 SNN Order Date. . . . . . . . . . .DATE 9 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . . 10 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . . 11 TelephoneNo . . . . . . . . . 17 SNN Telephone Number. . . . . . . . 12 FaxNo . . . . . . . . . . . . 17 SNN Fax Number. . . . . . . . . . . 13 EmailAddress. . . . . . . . . 250 SNN Email Address . . . . . . . . . 14 CustomerPONo. . . . . . . . . 15 SNN Customer PO Number. . . . . . . 15 ConfirmTo . . . . . . . . . . 30 SNN Confirm To. . . . . . . . . . . 16 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . . 17 ShipVIA . . . . . . . . . . . 15 SNN Ship VIA. . . . . . . . . . . . 18 ShipZone. . . . . . . . . . . 5 SNN Ship Zone . . . . . . . . . . . 19 ShipDate. . . . . . . . . . . 8 SNN Ship Expire Date. . . . . . . .DATE 20 FOB . . . . . . . . . . . . . 15 SNN F. O. B.. . . . . . . . . . . . 21 TrackingNumbers . . . . . . . 132 SNN Tracking Numbers. . . . . . . . 22 TermsCode . . . . . . . . . . 2 SNN Terms Code. . . . . . . . . . . 23 TermsCodeDesc . . . . . . . . 30 SNN Terms Code Description. . . . . 24 InvoiceDueDate. . . . . . . . 8 SNN Invoice Due Date. . . . . . . .DATE 25 DiscountDueDate . . . . . . . 8 SNN Discount Due Date . . . . . . .DATE 26 PaymentType . . . . . . . . . 5 SNN Payment Type. . . . . . . . . . 27 OtherPaymentTypeRefNo . . . . 24 SNN Other Payment Type Reference Nu 28 CheckNoForDeposit . . . . . . 6 SNN Check Number for Deposit. . . . 29 Last4UnencryptedCreditCardNos 4 SNN Last 4 Unencrypted Credit Card 30 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . . 31 SalespersonNo . . . . . . . . 4 SNN Salesperson Code. . . . . . . . 32 SalespersonName . . . . . . . 30 SNN Salesperson Name. . . . . . . . 33 BillToName. . . . . . . . . . 30 SNN Bill To Name. . . . . . . . . . 34 BillToAddress1. . . . . . . . 30 SNN Bill To Address 1 . . . . . . . 35 BillToAddress2. . . . . . . . 30 SNN Bill To Address 2 . . . . . . . 36 BillToAddress3. . . . . . . . 30 SNN Bill To Address 3 . . . . . . . 37 BillToCity. . . . . . . . . . 20 SNN Bill To City. . . . . . . . . . 38 BillToState . . . . . . . . . 2 SNN Bill To State . . . . . . . . . 39 BillToZipCode . . . . . . . . 10 SNN Bill To ZIP Code. . . . . . . . 40 BillToCountryCode . . . . . . 3 SNN Bill To Country Code. . . . . . 41 BillToCountryName . . . . . . 30 SNN Bill To Country Name. . . . . . 42 ShipToCode. . . . . . . . . . 4 SNN Ship To Code. . . . . . . . . . 43 ShipToName. . . . . . . . . . 30 SNN Ship To Name. . . . . . . . . . 44 ShipToAddress1. . . . . . . . 30 SNN Ship To Address 1 . . . . . . . 45 ShipToAddress2. . . . . . . . 30 SNN Ship To Address 2 . . . . . . . 46 ShipToAddress3. . . . . . . . 30 SNN Ship To Address 3 . . . . . . . 47 ShipToCity. . . . . . . . . . 20 SNN Ship To City. . . . . . . . . . 48 ShipToState . . . . . . . . . 2 SNN Ship To State . . . . . . . . . 49 ShipToZipCode . . . . . . . . 10 SNN Ship To ZIP Code. . . . . . . . 50 ShipToCountryCode . . . . . . 3 SNN Ship To Country Code. . . . . . 51 ShipToCountryName . . . . . . 30 SNN Ship To Country Name. . . . . . 52 TaxSchedule . . . . . . . . . 9 SNN Tax Schedule. . . . . . . . . . 53 InvalidTaxCalc. . . . . . . . 1 SNN Invalid Tax Calculation . . . . 54 TaxCode1. . . . . . . . . . . 15 SNN Tax Code 1. . . . . . . . . . . 55 TaxCode2. . . . . . . . . . . 15 SNN Tax Code 2. . . . . . . . . . . 56 TaxCode3. . . . . . . . . . . 15 SNN Tax Code 3. . . . . . . . . . . 57 TaxCode4. . . . . . . . . . . 15 SNN Tax Code 4. . . . . . . . . . . 58 TaxCode1Desc. . . . . . . . . 30 SNN Tax Code 1 Description. . . . . 59 TaxCode2Desc. . . . . . . . . 30 SNN Tax Code 2 Description. . . . . 60 TaxCode3Desc. . . . . . . . . 30 SNN Tax Code 3 Description. . . . . 61 TaxCode4Desc. . . . . . . . . 30 SNN Tax Code 4 Description. . . . . 62 ExemptionNo1. . . . . . . . . 20 SNN Exemption Number 1. . . . . . . 63 ExemptionNo2. . . . . . . . . 20 SNN Exemption Number 2. . . . . . . 64 ExemptionNo3. . . . . . . . . 20 SNN Exemption Number 3. . . . . . . 65 ExemptionNo4. . . . . . . . . 20 SNN Exemption Number 4. . . . . . . 66 RegistrationNo1 . . . . . . . 20 SNN Registration Number 1 . . . . . 67 RegistrationNo2 . . . . . . . 20 SNN Registration Number 2 . . . . . 68 RegistrationNo3 . . . . . . . 20 SNN Registration Number 3 . . . . . 69 RegistrationNo4 . . . . . . . 20 SNN Registration Number 4 . . . . . 70 EBMSubmissionType . . . . . . 1 SNN EBM Submission Type . . . . . . 71 EBMUserIDSubmittingThisOrder. 15 SNN EBM User ID Submitting This Ord 72 LineSeqNo . . . . . . . . . . 14 SNN Line Sequence Number. . . . . . 73 LineNumber. . . . . . . . . . 14 SNN Line Number . . . . . . . . . . 74 ItemCode. . . . . . . . . . . 30 SNN Item Code . . . . . . . . . . . 75 AliasItemNo . . . . . . . . . 30 SNN Alias Item Number . . . . . . . 76 ItemType. . . . . . . . . . . 1 SNN Item Type . . . . . . . . . . . DfltVal:1 77 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . . 78 ExtendedDescriptionKey. . . . 10 SNN Extended Description Key. . . . 79 ExtendedDescriptionText . . . 4096 SNN Extended Description. . . . . . 80 LotSerialNo . . . . . . . . . 15 SNN Lot or Serial Number. . . . . . 81 TierType. . . . . . . . . . . 1 SNN Tier Type . . . . . . . . . . . DfltVal:4 82 Category1 . . . . . . . . . . 15 SNN Category 1. . . . . . . . . . . 83 Category2 . . . . . . . . . . 15 SNN Category 2. . . . . . . . . . . 84 Category3 . . . . . . . . . . 15 SNN Category 3. . . . . . . . . . . 85 Category4 . . . . . . . . . . 15 SNN Category 4. . . . . . . . . . . 86 BinLocation . . . . . . . . . 10 SNN Bin Location. . . . . . . . . . 87 LineWarehouseCode . . . . . . 3 SNN Line Warehouse Code . . . . . . 88 ProductLine . . . . . . . . . 4 SNN ProductLine . . . . . . . . . . 89 Discount. . . . . . . . . . . 1 SNN Discount. . . . . . . . . . . . 90 Commissionable. . . . . . . . 1 SNN Commissionable. . . . . . . . . 91 SubjectToExemption. . . . . . 1 SNN Subject To Exemption. . . . . . 92 DropShip. . . . . . . . . . . 1 SNN Drop Ship . . . . . . . . . . . 93 UnitOfMeasure . . . . . . . . 4 SNN Unit of Measure . . . . . . . . 94 CostOfGoodsSoldAcctKey. . . . 9 SNN Cost of Goods Sold Account Key. 95 CostOfGoodsSoldAccount. . . . 41 SNN Fully Formatted Cost of Goods S 96 SalesAcctKey. . . . . . . . . 9 SNN Sales Account Key . . . . . . . 97 SalesAccount. . . . . . . . . 41 SNN Fully Formatted Sales Account . 98 TaxClass. . . . . . . . . . . 2 SNN Tax Class . . . . . . . . . . . 99 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . . 100 ExplodedKitItem . . . . . . . 1 SNN Exploded Kit Item . . . . . . . 101 StandardKitBill . . . . . . . 1 SNN Standard Kit Bill . . . . . . . 102 Revision. . . . . . . . . . . 3 SNN Bill Revision Code. . . . . . . 103 BillOption1 . . . . . . . . . 2 SNN Bill Option 1 . . . . . . . . . 104 Option1Desc . . . . . . . . . 30 SNN Option 1 Description. . . . . . 105 BillOption2 . . . . . . . . . 2 SNN Bill Option 2 . . . . . . . . . 106 Option2Desc . . . . . . . . . 30 SNN Option 2 Description. . . . . . 107 BillOption3 . . . . . . . . . 2 SNN Bill Option 3 . . . . . . . . . 108 Option3Desc . . . . . . . . . 30 SNN Option 3 Description. . . . . . 109 BillOption4 . . . . . . . . . 2 SNN Bill Option 4 . . . . . . . . . 110 Option4Desc . . . . . . . . . 30 SNN Option 4 Description. . . . . . 111 BillOption5 . . . . . . . . . 2 SNN Bill Option 5 . . . . . . . . . 112 Option5Desc . . . . . . . . . 30 SNN Option 5 Description. . . . . . 113 BillOption6 . . . . . . . . . 2 SNN Bill Option 6 . . . . . . . . . 114 Option6Desc . . . . . . . . . 30 SNN Option 6 Description. . . . . . 115 BillOption7 . . . . . . . . . 2 SNN Bill Option 7 . . . . . . . . . 116 Option7Desc . . . . . . . . . 30 SNN Option 7 Description. . . . . . 117 BillOption8 . . . . . . . . . 2 SNN Bill Option 8 . . . . . . . . . 118 Option8Desc . . . . . . . . . 30 SNN Option 8 Description. . . . . . 119 BillOption9 . . . . . . . . . 2 SNN Bill Option 9 . . . . . . . . . 120 Option9Desc . . . . . . . . . 30 SNN Option 9 Description. . . . . . 121 SkipPrintCompLine . . . . . . 1 SNN Skip Printing of Component Line 122 SalesKitLineKey . . . . . . . 6 SNN Sales Kit Line Key. . . . . . . 123 RMANo . . . . . . . . . . . . 7 SNN RMA Number. . . . . . . . . . . 124 CustomerAction. . . . . . . . 1 SNN Customer Action . . . . . . . . 125 WarrantyCode. . . . . . . . . 10 SNN Warranty Code . . . . . . . . . 126 WarrantyCodeDesc. . . . . . . 30 SNN Warranty Code Description . . . 127 ExpirationDate. . . . . . . . 8 SNN Expiration Date . . . . . . . .DATE 128 JobNo . . . . . . . . . . . . 7 SNN Job Number. . . . . . . . . . . 129 CostCode. . . . . . . . . . . 9 SNN Cost Code . . . . . . . . . . . 130 CostCodeFormatted . . . . . . 11 SNN Cost Code Formatted . . . . . . 131 CostType. . . . . . . . . . . 1 SNN Cost Type . . . . . . . . . . . 132 MessageLine1. . . . . . . . . 50 SNN Message Line 1. . . . . . . . . 133 MessageLine2. . . . . . . . . 50 SNN Message Line 2. . . . . . . . . 134 FaxSendToCompany. . . . . . . 30 SNN Fax Send To Company . . . . . . 135 FaxSendToName . . . . . . . . 30 SNN FaxSendToName . . . . . . . . . 136 BatchFax. . . . . . . . . . . 1 SYN BatchFax. . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N 137 CRMUserID . . . . . . . . . . 11 SNN CRM User ID . . . . . . . . . . 138 CRMUserLastName . . . . . . . 30 SNN CRM User Last Name. . . . . . . 139 CRMUserFirstName. . . . . . . 30 SNN CRM User First Name . . . . . . 140 CRMCompanyID. . . . . . . . . 11 SNN CRM Company ID. . . . . . . . . 141 CRMCompanyName. . . . . . . . 120 SNN CRM Company Name. . . . . . . . 142 CRMPersonID . . . . . . . . . 11 SNN CRMPersonID . . . . . . . . . . 143 CRMPersonFirstName. . . . . . 60 SNN CRM Person First Name . . . . . 144 CRMPersonLastName . . . . . . 80 SNN CRM Person Last Name. . . . . . 145 CRMOpportunityID. . . . . . . 11 SNN CRM Opportunity ID. . . . . . . 146 CRMOpportunityDesc. . . . . . 80 SNN CRM Opportunity Description . . 147 PLPrint . . . . . . . . . . . 1 SYN Paperless Office Print CustomerYESNO DfltVal:N Valid:Y,N 148 PLEmail . . . . . . . . . . . 1 SYN Paperless Office E-Mail CustomeYESNO DfltVal:N Valid:Y,N 149 PLFax . . . . . . . . . . . . 1 SYN Paperless Office Fax Customer .YESNO DfltVal:N Valid:Y,N 150 PLPDF . . . . . . . . . . . . 1 SYN Paperless Office Create PDF . .YESNO DfltVal:N Valid:Y,N 151 QuantityOrdered . . . . . . . 16.6 NNN Quantity Ordered. . . . . . . . 152 QuantityShipped . . . . . . . 16.6 NNN Quantity Shipped. . . . . . . . 153 QuantityBackOrdered . . . . . 16.6 NNN Quantity Back Ordered . . . . . 154 LotSerialQuantityShipped. . . 16.6 NNN Lot or Serial Quantity Shipped. 155 ItemWeight. . . . . . . . . . 16.6 NNN Item Weight . . . . . . . . . . 156 SuggestedRetailPrice. . . . . 16.6 NNN Suggested Retail Price. . . . . 157 UnitPrice . . . . . . . . . . 16.6 NNN Unit Price. . . . . . . . . . . 158 ExtensionAmt. . . . . . . . . 12.2 NNN Extension Amount. . . . . . . . 159 LineDiscountPercent . . . . . 9.3 NNN Line Discount Percentage. . . . 160 TaxableAmt. . . . . . . . . . 15.2 NNN Taxable Amount. . . . . . . . . 161 NonTaxableAmt . . . . . . . . 15.2 NNN Non-Taxable Amount. . . . . . . 162 DiscountRate. . . . . . . . . 8.3 NNN Discount Rate . . . . . . . . . 163 DiscountAmt . . . . . . . . . 13.2 NNN Discount Amount . . . . . . . . 164 RetentionAmt. . . . . . . . . 13.2 NNN Retention Amount. . . . . . . . 165 FreightAmt. . . . . . . . . . 13.2 NNN Freight Amount. . . . . . . . . 166 SalesTaxAmt . . . . . . . . . 12.2 NNN Sales Tax Amount. . . . . . . . 167 SalesTaxAmt1. . . . . . . . . 12.2 NNN Sales Tax Amount 1. . . . . . . 168 SalesTaxAmt2. . . . . . . . . 12.2 NNN Sales Tax Amount 2. . . . . . . 169 SalesTaxAmt3. . . . . . . . . 12.2 NNN Sales Tax Amount 3. . . . . . . 170 SalesTaxAmt4. . . . . . . . . 12.2 NNN Sales Tax Amount 4. . . . . . . 171 DepositAmt. . . . . . . . . . 13.2 NNN Deposit Amount. . . . . . . . . 172 CreditCardPreAuthorizationAmt 13.2 NNN Credit Card Pre-Authorization A 173 CreditCardPaymentBalanceAmt . 13.2 NNN Credit Card Payment/Balance Amo 174 Weight. . . . . . . . . . . . 12.2 NNN Weight. . . . . . . . . . . . . 175 CurrentBalance. . . . . . . . 14.2 NNN Current Balance . . . . . . . . 176 AgingCategory1. . . . . . . . 14.2 NNN Aging Category 1. . . . . . . . 177 AgingCategory2. . . . . . . . 14.2 NNN Aging Category 2. . . . . . . . 178 AgingCategory3. . . . . . . . 14.2 NNN Aging Category 3. . . . . . . . 179 AgingCategory4. . . . . . . . 14.2 NNN Aging Category 4. . . . . . . .