SO_InvoiceDetail SO Invoice Detail Rel: 6.00 Bld: 1024 3/10/2020 Physical Path: "MAS_"+%C$+"/SO"+%C$+"/SO_InvoiceDetail.M4T" SQL Create: Y SQL Sys DB: N SQL Null Dates: N Exclude V/I: Y Create Tbl: N Bus Obj: SO_InvoiceDetail_bus RA_GenerateTransactions_upd BC_CommonImport Record ID Column: ItemType
KPRIMARY: InvoiceNo+LineKey KDISPLAY: InvoiceNo+LineSeqNo+LineKey KEXTENDEDDESC: ExtendedDescriptionKey+InvoiceNo+LineKey KITEM: ItemCode+InvoiceNo+LineKey KITEMWHSE: ItemCode+WarehouseCode+InvoiceNo+LineKey KVENDOR: APDivisionNo+VendorNo+InvoiceNo+LineKey
Fld Column Name M/L TUR Description/Notes Class
1 InvoiceNo . . . . . . . . . . 7 SYY Invoice Number. . . . . . . . .INVOICE Read Only:Y FmtType:MASTERNUM 2 LineKey . . . . . . . . . . . 6 SNY Line Key. . . . . . . . . . . . Read Only:Y Mask:000000 FmtType:ZEROFILL 3 LineSeqNo . . . . . . . . . . 14 SNY Line Sequence Number. . . . . . Read Only:Y Mask:000000000000 00 FmtType:ZEROFILL 4 ItemCode. . . . . . . . . . . 30 SYY Item Code . . . . . . . . . . .ITEMCODE ValGroup:ItemPriceByTotQty 5 ItemType. . . . . . . . . . . 1 SYY Item Type . . . . . . . . . . . Valid:1,2,3,4,5 Notes: 1=Regular Item, 2=Special Item, 3=Charge Item, 4=Comment Item, 5=Miscellaneo us Item 6 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . .DESCRIPTION ValGroup:NotComment, ItemRequired 7 ExtendedDescriptionKey. . . . 10 SNN Extended Description Key. . . .EXTDESCKEY Read Only:Y ValGroup:NotComme nt,ItemRequired 8 Discount. . . . . . . . . . . 1 SYN Discount. . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment, ItemRequired,NotComponent 9 Commissionable. . . . . . . . 1 SYN Commissionable. . . . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment, SalespersonReporting, NotComponent 10 SubjectToExemption. . . . . . 1 SYN Subject To Exemption. . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment 11 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE FmtType:CHARNUM DepVal:REQUIR ED ValGroup:IMIntegrated, NotComment,MultiWarehouse, ItemRequired,RegularItem, NotNulWarehouseCode 12 ProductLine . . . . . . . . . 4 SYN Product Line. . . . . . . . . .PRODUCTLINE FmtType:CHARNUM ValGroup:NotC omment 13 Valuation . . . . . . . . . . 1 SYN Valuation . . . . . . . . . . . Valid:1,2,3,4,5,6 ValGroup:No tComment Notes: 1=Standard, 2=Average, 3=Fifo, 4=Lifo, 5=Lot, 6=Serial 14 PriceLevel. . . . . . . . . . 1 SYN Price Level . . . . . . . . . . DepVal:REQUIRED ValGroup:IMIn tegrated,NotComment, ItemRequired,RegularItem, NotComponent,ItemPriceByTotQt y 15 UnitOfMeasure . . . . . . . . 4 SYN Unit Of Measure . . . . . . . .UNITOFMEASURE ValGroup:NotComment, ItemRequired,ItemTypes, ItemPriceByTotQty 16 DropShip. . . . . . . . . . . 1 SYN Drop Ship . . . . . . . . . . .YESNO DfltVal:N ValGroup:NotComment ,ItemTypes 17 LotSerialFullyDistributed . . 1 SYN Lot/Serial Fully Distributed. .YESNO DfltVal:Y Valid:Y,N ValGroup:NotComment 18 SalesKitLineKey . . . . . . . 6 SNN Sales Kit Line Key. . . . . . . Mask:000000 FmtType:ZEROFILL ValGroup:NotComment 19 CostOfGoodsSoldAcctKey. . . . 9 SYN Cost of Goods Sold Account Key.ACCOUNT DepVal:REQUIRED ValGroup:NotC omment,ItemRequired, ItemTypes 20 SalesAcctKey. . . . . . . . . 9 SYN Sales Account Key . . . . . . .ACCOUNT DepVal:REQUIRED ValGroup:NotC omment,ItemRequired 21 PriceOverridden . . . . . . . 1 SYN Price Overridden. . . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment 22 OrderWarehouse. . . . . . . . 3 SYN Order Warehouse . . . . . . . . FmtType:CHARNUM ValGroup:NotC omment 23 ExplodedKitItem . . . . . . . 1 SYN Exploded Kit Item . . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment 24 OrderLineKey. . . . . . . . . 6 SNN Order Line Key. . . . . . . . . Mask:000000 FmtType:ZEROFILL ValGroup:NotComment 25 Revision. . . . . . . . . . . 3 SNN Bill Revision Code. . . . . . . 26 BillOption1 . . . . . . . . . 2 SYN Bill Option 1 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, NotComment,BillHasOptions, ItemRequired,RegularItem 27 BillOption2 . . . . . . . . . 2 SYN Bill Option 2 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, NotComment,BillHasOptions, ItemRequired,RegularItem 28 BillOption3 . . . . . . . . . 2 SYN Bill Option 3 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, NotComment,BillHasOptions, ItemRequired,RegularItem 29 BillOption4 . . . . . . . . . 2 SYN Bill Option 4 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, NotComment,BillHasOptions, ItemRequired,RegularItem 30 BillOption5 . . . . . . . . . 2 SYN Bill Option 5 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, NotComment,BillHasOptions, ItemRequired,RegularItem 31 BillOption6 . . . . . . . . . 2 SYN Bill Option 6 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, NotComment,BillHasOptions, ItemRequired,RegularItem 32 BillOption7 . . . . . . . . . 2 SYN Bill Option 7 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, NotComment,BillHasOptions, ItemRequired,RegularItem 33 BillOption8 . . . . . . . . . 2 SYN Bill Option 8 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, NotComment,BillHasOptions, ItemRequired,RegularItem 34 BillOption9 . . . . . . . . . 2 SYN Bill Option 9 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, NotComment,BillHasOptions, ItemRequired,RegularItem 35 BackorderKitCompLine. . . . . 1 SYN Backorder Kit Component Line. .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment Notes: Kit Bckord=0, Comp Bckord>0 Flg=Y 36 StandardKitBill . . . . . . . 1 SYN Standard/Kit Bill . . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment 37 SkipPrintCompLine . . . . . . 1 SYN Skip Print Of Component Line inYESNO DfltVal:N Valid:Y,N ValGroup:NotComment 38 AliasItemNo . . . . . . . . . 30 SYN Alias Item Number . . . . . . . ValGroup:NotComment, ItemRequired,RegularItem 39 TaxClass. . . . . . . . . . . 2 SYN Tax Class . . . . . . . . . . .TAXCLASS DepVal:REQUIRED ValGroup:NotC omment 40 SOHistoryDetlSeqNo. . . . . . 14 SNN Sales Order History Detail Sequ Mask:00000000000000 FmtType:ZEROFILL ValGroup:Not Comment 41 CustomerAction. . . . . . . . 1 SYN Customer Action . . . . . . . . DfltVal:N Valid:N,C,P,R ValGroup:NotComment Notes: N=None, C=Credit, P=rePlaceme nt, R=Repair 42 WarrantyCode. . . . . . . . . 10 SYN Warranty Code . . . . . . . . .WARRANTYCODE DepVal:REQUIRED ValGroup:NotC omment,ItemRequired, RegularItem,WarrantyTracking 43 ExpirationDate. . . . . . . . 8 SNN Expiration Date . . . . . . . .DATE ValGroup:NotComment, ItemRequired,RegularItem, WarrantyTracking 44 ExpirationOverridden. . . . . 1 SYN Expiration Overridden . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment 45 CostOverridden. . . . . . . . 1 SYN Cost Overridden . . . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment 46 ItemAction. . . . . . . . . . 1 SYN Item Action . . . . . . . . . . DfltVal:N Valid:N,S,P,R ValGroup:NotComment Notes: N=None, S=Stock, P=scraP, R=Repair 47 CostCode. . . . . . . . . . . 9 SYN Cost Code . . . . . . . . . . .COSTCODE FmtType:CHARNUM DepVal:REQUIR ED ValGroup:PostJCCosts, NotComment 48 CostType. . . . . . . . . . . 1 SYN Cost Type . . . . . . . . . . .COSTTYPE DepVal:REQUIRED ValGroup:Post JCCosts,NotComment 49 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . .COMMENT DepVal:REQUIRED ValGroup:Item Required 50 PromiseDate . . . . . . . . . 8 SNN Promise Date. . . . . . . . . .DATE ValGroup:NotComment 51 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . .APDIVISION Mask:00 DepVal:REQUIRED ValGroup:NotComment,POSetup 52 VendorNo. . . . . . . . . . . 7 SYN Vendor Number . . . . . . . . .VENDORNO FmtType:MASTERNUM DepVal:REQU IRED ValGroup:NotComment, POSetup ChngTag:Replace1/APDi visionNo$ 53 PurchaseOrderNo . . . . . . . 7 SYN Purchase Order Number . . . . .PURCHASEORDERNO FmtType:CHARNUM ValGroup:NotC omment,POSetup 54 PurchaseOrderRequiredDate . . 8 SNN Purchase Order Required Date. .DATE ValGroup:NotComment,POSetup 55 CommodityCode . . . . . . . . 12 SNN Commodity Code. . . . . . . . .COMMODITYCODE ValGroup:NotComment, NotComponent Notes: Added in for CC Corporate Level III support 56 AlternateTaxIdentifier. . . . 15 SNN Alternate Tax Identifier. . . . ValGroup:CCLevel3Dtl, NotComment,NotComponent Notes: Added in for CC Corporate Level III support 57 TaxTypeApplied. . . . . . . . 4 SNN Tax Type Applied. . . . . . . . ValGroup:CCLevel3Dtl, NotComment,NotComponent Notes: Added in for CC Corporate Level III support 58 NetGrossIndicator . . . . . . 1 SNN Net Gross Indicator . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:CCLevel3Dtl, NotComment,NotComponent Notes: Added in for CC Corporate Level III supportAlways false (N); Per SPS, when true this indicates sales tax included in ExtendedItemAmount 59 DebitCreditIndicator. . . . . 1 SYN Debit Credit Indicator. . . . . DfltVal:C Valid:D,C ValGroup:CCLevel3Dtl, NotComment,NotComponent Notes: Added in for CC Corporate Level III supportPer SPS, Always 'C'reditcard 60 QuantityOrdered . . . . . . . 16.6 NNN Quantity Ordered. . . . . . . .QUANTITY Mask:##,###,###.000000- ValGroup:NotComment, ItemRequired,ItemTypes, ItemPriceByTotQty 61 QuantityShipped . . . . . . . 16.6 NNN Quantity Shipped. . . . . . . .QUANTITY Mask:##,###,###.000000- ValGroup:NotComment, ItemRequired,ItemTypes 62 QuantityBackordered . . . . . 16.6 NNN Quantity Backordered. . . . . .QUANTITY Mask:##,###,###.000000- ValGroup:NotComment, ItemRequired,ItemTypes 63 UnitPrice . . . . . . . . . . 16.6 NNN Unit Price. . . . . . . . . . .PRICE Mask:##,###,###.000000- ValGroup:NotComment, ItemRequired,ItemTypes, NotComponent,ItemPriceByTotQt y 64 ExtensionAmt. . . . . . . . . 12.2 NNN Extension Amount. . . . . . . . Mask:##,###,###.00- ValGroup:NotComment, ItemRequired,ItemPriceByTotQt y 65 ExtendedCost. . . . . . . . . 12.2 NNN Extended Cost . . . . . . . . .COST Mask:##,###,###.00- 66 ExtendedNegQtyAdj . . . . . . 12.2 NNN Extended Negative Quantity Adju Mask:##,###,###.00- 67 UnitCost. . . . . . . . . . . 16.6 NNN Unit Cost . . . . . . . . . . .COST Mask:##,###,###.000000- ValGroup:NotComment, ItemRequired,ItemTypes Notes: {Calc @ Pre (Unless Ds)} 68 UnitOfMeasureConvFactor . . . 12.4 NNN Unit Of Measure Conversion FactUMCONVFACTOR Mask:#####0.0000 ValGroup:Not Comment,ItemPriceByTotQty 69 CommissionAmt . . . . . . . . 13.2 NNN Commission Amount . . . . . . .AMOUNT Mask:###,###,###.00 ValGroup:NotComment Notes: (Calc @ Pre-Update) 70 QuantityPerBill . . . . . . . 16.6 NNN Quantity Per Bill . . . . . . .QUANTITY Mask:##,###,###.000000- ValGroup:NotComment 71 LineDiscountPercent . . . . . 9.3 NNN Line Discount Percent . . . . . Mask:###0.000- ValGroup:NotCo mment,LineDiscount,ItemRequir ed,ItemTypes 72 LineWeight. . . . . . . . . . 12.2 NNN Line Weight . . . . . . . . . .MISCAMOUNT Read Only:Y Mask:##,###, ###.00- 73 TaxAmt. . . . . . . . . . . . 12.2 NNN Tax Amount. . . . . . . . . . .MISCAMOUNT Mask:##,###,###.00- ValGroup:CCLevel3Dtl, NotComment,NotComponent Notes: Added in for CC Corporate Level III support 74 TaxRate . . . . . . . . . . . 11.6 NNN Tax Rate. . . . . . . . . . . . Mask:###.000000- Valid:0-999. 999999 ValGroup:CCLevel3Dtl, NotComment,NotComponent Notes: Added in for CC Corporate Level III support 75 AppliedSalesOrderNo . . . . . 7 SYN Applied Sales Order Number. . .SALESORDERNO 76 AppliedCustomerPONo . . . . . 30 SNN Applied Customer PO Number. . .CUSTOMERPONO