AR_InvoiceHistoryDetail AR Invoice History Detail Rel: 6.00 Bld: 1024 3/10/2020 Physical Path: "MAS_"+%C$+"/AR"+%C$+"/AR_InvoiceHistoryDetail.M4T" SQL Create: Y SQL Sys DB: N SQL Null Dates: N Exclude V/I: N Create Tbl: N Bus Obj: AR_InvoiceHistoryInquiryDetail_bus SO_SalesJournal_upd AR_SalesJournal_upd Record ID Column: ItemType
KPRIMARY: InvoiceNo+HeaderSeqNo+DetailSeqNo KEXTENDEDDESC: ExtendedDescriptionKey+InvoiceNo+HeaderSeqNo+DetailSeqNo KVENDOR: APDivisionNo+VendorNo+InvoiceNo+HeaderSeqNo+DetailSeqNo kAPPLIEDSO: AppliedSalesOrderNo+InvoiceNo+HeaderSeqNo+DetailSeqNo kINVOICEAPPLIEDSO: InvoiceNo+HeaderSeqNo+AppliedSalesOrderNo+DetailSeqNo kITEM: ItemCode+InvoiceNo+HeaderSeqNo+DetailSeqNo
Fld Column Name M/L TUR Description/Notes Class
1 InvoiceNo . . . . . . . . . . 7 SYY Invoice Number. . . . . . . . .INVOICE FmtType:MASTERNUM Notes: {ARO$(1,7)} 2 HeaderSeqNo . . . . . . . . . 6 SNY Header Sequence Number. . . . . Mask:000000 FmtType:ZEROFILL Notes: {ARO$(8,3)} 3 DetailSeqNo . . . . . . . . . 6 SNY Detail Sequence Number. . . . . Mask:000000 FmtType:ZEROFILL Notes: {ARO$(11,5)} 4 ItemCode. . . . . . . . . . . 30 SYY Item Code . . . . . . . . . . .ITEMCODE ChngTag:Replace0 Notes: {ARO$(20,6)} 5 ItemType. . . . . . . . . . . 1 SYY Item Type . . . . . . . . . . . Valid:1,2,3,4,5 Notes: 1=Inventory Item, 2=Special Item, 3=Charge Item, 4=Comment Item, 5=Miscellaneo us Item {ARO$(19,1)} 6 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . .DESCRIPTION Notes: {ARO$(26,30)} 7 ExtendedDescriptionKey. . . . 10 SYN Extended Description Key. . . .EXTDESCKEY Read Only:Y Notes: {ARO$(135, 1)} 8 SalesAcctKey. . . . . . . . . 9 SYN Sales Account Key . . . . . . .ACCOUNT Notes: {ARO$(56,9)} 9 CostOfGoodsSoldAcctKey. . . . 9 SYN Cost of Goods Sold Account Key.ACCOUNT Notes: {ARO$(65,9)} 10 InventoryAcctKey. . . . . . . 9 SYN Inventory Account Key . . . . .ACCOUNT Notes: {ARO$(74,9)} 11 UnitOfMeasure . . . . . . . . 4 SYN Unit Of Measure . . . . . . . .UNITOFMEASURE Notes: {ARO$(83,4)} 12 SubjectToExemption. . . . . . 1 SYN Subject To Exemption. . . . . .YESNO DfltVal:N Valid:Y,N Notes: {ARO$(87,1)} 13 Commissionable. . . . . . . . 1 SYN Commissionable. . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {ARO$(88,1)} 14 TaxClass. . . . . . . . . . . 2 SYN Tax Class . . . . . . . . . . .TAXCLASS Notes: {ARO$(89,2)} 15 Discount. . . . . . . . . . . 1 SYY Discount. . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {ARO$(40,1)} 16 DropShip. . . . . . . . . . . 1 SYY Drop Ship . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {ARO$(84,1)} 17 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE FmtType:CHARNUM Notes: {ARO$(103,3)} 18 PriceLevel. . . . . . . . . . 1 SYN Price Level . . . . . . . . . . Notes: {ARO$(106,1)} 19 ProductLine . . . . . . . . . 4 SYN Product Line. . . . . . . . . .PRODUCTLINE FmtType:CHARNUM Notes: {ARO$(108,4)} 20 Valuation . . . . . . . . . . 1 SNN Valuation . . . . . . . . . . . Valid:1,2,3,4,5,6 Notes: 1=Standard, 2=Average, 3=Fifo, 4=Lifo, 5=Lot, 6=Serial 21 PriceOverridden . . . . . . . 1 SYN Price Overridden. . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {ARO$(112,1)} 22 OrderWarehouse. . . . . . . . 3 SYN Order Warehouse . . . . . . . .WAREHOUSE FmtType:CHARNUM Notes: {ARO$(113,3)} 23 Revision. . . . . . . . . . . 3 SNN Bill Revision Code. . . . . . . 24 BillOption1 . . . . . . . . . 2 SYN Bill Option 1 . . . . . . . . .BILLOPTION FmtType:CHARNUM Notes: {ARO$(117,2)} 25 BillOption2 . . . . . . . . . 2 SYN Bill Option 2 . . . . . . . . .BILLOPTION FmtType:CHARNUM Notes: {ARO$(119,2)} 26 BillOption3 . . . . . . . . . 2 SYN Bill Option 3 . . . . . . . . .BILLOPTION FmtType:CHARNUM Notes: {ARO$(121,2)} 27 BillOption4 . . . . . . . . . 2 SYN Bill Option 4 . . . . . . . . .BILLOPTION FmtType:CHARNUM Notes: {ARO$(123,2)} 28 BillOption5 . . . . . . . . . 2 SYN Bill Option 5 . . . . . . . . .BILLOPTION FmtType:CHARNUM Notes: {ARO$(125,2)} 29 BillOption6 . . . . . . . . . 2 SYN Bill Option 6 . . . . . . . . .BILLOPTION FmtType:CHARNUM Notes: {ARO$(127,2)} 30 BillOption7 . . . . . . . . . 2 SYN Bill Option 7 . . . . . . . . .BILLOPTION FmtType:CHARNUM Notes: {ARO$(129,2)} 31 BillOption8 . . . . . . . . . 2 SYN Bill Option 8 . . . . . . . . .BILLOPTION FmtType:CHARNUM Notes: {ARO$(131,2)} 32 BillOption9 . . . . . . . . . 2 SYN Bill Option 9 . . . . . . . . .BILLOPTION FmtType:CHARNUM Notes: {ARO$(133,2)} 33 KitItem . . . . . . . . . . . 1 SYY Kit Item. . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {ARO$(116,1)} 34 ExplodedKitItem . . . . . . . 1 SYN Exploded Kit Item . . . . . . . DfltVal:N Valid:Y,N,C Notes: Y=Yes, N=No, C=Component {ARO$(145,1)} 35 SkipPrintCompLine . . . . . . 1 SYY Skip Print Of Component Lines .YESNO DfltVal:N Valid:Y,N Notes: {ARO$(147,1)} 36 StandardKitBill . . . . . . . 1 SYY Standard Kit Bill . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {ARO$(146,1)} 37 AliasItemNo . . . . . . . . . 30 SYN Alias Item Number . . . . . . . Notes: {ARO$(158,30)} 38 CustomerAction. . . . . . . . 1 SYN Customer Action . . . . . . . . DfltVal:N Valid:C,P,R,N Notes: C=Credit, P=rePlacemen t, R=Repair, N=None {ARO$(188,1)} 39 ItemAction. . . . . . . . . . 1 SYN Item Action . . . . . . . . . . DfltVal:N Valid:S,P,R,N Notes: S=Stock, P=scraP, R=Repair, N=None 40 WarrantyCode. . . . . . . . . 10 SYN Warranty Code . . . . . . . . .WARRANTYCODE Notes: {ARO$(189,10)} 41 ExpirationDate. . . . . . . . 8 SNN Expiration Date . . . . . . . .DATE Notes: {ARO$(199,6)} 42 ExpirationOverridden. . . . . 1 SYY Expiration Overridden . . . . .YESNO DfltVal:N Valid:Y,N Notes: {ARO$(205,1)} 43 CostCode. . . . . . . . . . . 9 SYN Cost Code . . . . . . . . . . .COSTCODE FmtType:CHARNUM 44 CostType. . . . . . . . . . . 1 SYN Cost Type . . . . . . . . . . .COSTTYPE Notes: {ARO$(107,1)} 45 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . .COMMENT Notes: {ARO$(40,100)} 46 PromiseDate . . . . . . . . . 8 SNN Promise Date. . . . . . . . . .DATE 47 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . .APDIVISION Mask:00 48 VendorNo. . . . . . . . . . . 7 SYN Vendor Number . . . . . . . . .VENDORNO FmtType:MASTERNUM ChngTag:Rep lace1/APDivisionNo$ 49 PurchaseOrderNo . . . . . . . 7 SYN Purchase Order Number . . . . .PURCHASEORDERNO FmtType:CHARNUM 50 PurchaseOrderRequiredDate . . 8 SNN Purchase Order Required Date. .DATE 51 CommodityCode . . . . . . . . 12 SNN Commodity Code. . . . . . . . . ValGroup:CCLevel3Dtl, NotComment,NotComponent Notes: Added in for CC Corporate Level III support 52 AlternateTaxIdentifier. . . . 15 SNN Alternate Tax Identifier. . . . ValGroup:CCLevel3Dtl, NotComment,NotComponent Notes: Added in for CC Corporate Level III support 53 TaxTypeApplied. . . . . . . . 4 SNN Tax Type Applied. . . . . . . . ValGroup:CCLevel3Dtl, NotComment,NotComponent Notes: Added in for CC Corporate Level III support 54 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 55 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 56 QuantityShipped . . . . . . . 16.6 NNN Quantity Shipped. . . . . . . .QUANTITY Mask:##,###,###.000000- Notes: {ARO[1]} 57 QuantityOrdered . . . . . . . 16.6 NNN Quantity Ordered. . . . . . . .QUANTITY Mask:##,###,###.000000- Notes: {ARO[0]} 58 QuantityBackordered . . . . . 16.6 NNN Quantity Backordered. . . . . .QUANTITY Mask:##,###,###.000000- Notes: {ARO[2]} 59 UnitPrice . . . . . . . . . . 16.6 NNN Unit Price. . . . . . . . . . .PRICE Mask:##,###,###.000000- Notes: {ARO[1]} 60 UnitCost. . . . . . . . . . . 16.6 NNN Unit Cost . . . . . . . . . . .COST Mask:##,###,###.000000- Notes: {ARO[2]} 61 UnitOfMeasureConvFactor . . . 12.4 NNN Unit Of Measure Conversion FactUMCONVFACTOR Mask:#####0.0000 Notes: {ARO[6]} 62 CommissionAmt . . . . . . . . 13.2 NNN Commission Amount . . . . . . .AMOUNT Mask:###,###,###.00 Notes: {ARO[7]} 63 LineDiscountPercent . . . . . 9.3 NNN Line Discount Percent . . . . . Mask:###0.000 Notes: {ARO$(73,7)} 64 QuantityPerBill . . . . . . . 16.6 NNN Quantity Per Bill . . . . . . .QUANTITY Mask:##,###,###.000000- Notes: {ARO$(148,10)} 65 ExtensionAmt. . . . . . . . . 12.2 NNN Extension Amount. . . . . . . . Mask:##,###,###.00 Notes: {ARO[3]} 66 TaxAmt. . . . . . . . . . . . 12.2 NNN Tax Amount. . . . . . . . . . .MISCAMOUNT Mask:##,###,###.00- ValGroup:CCLevel3Dtl, NotComment,NotComponent Notes: Added in for CC Corporate Level III support 67 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 68 AppliedSalesOrderNo . . . . . 7 SYN Applied Sales Order Number. . .SALESORDERNO 69 AppliedCustomerPONo . . . . . 30 SNN Applied Customer PO Number. . .CUSTOMERPONO