RA_CustomerInvoiceSearch RA Customer Invoice Search Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: SO_SalesJournal_upd SQL Def: Y SysDB: N "MAS_"+%C$+"/RA"+%C$+"/RA_CustomerInvoiceSearch.M4T"
KPRIMARY: ARDivisionNo+CustomerNo+ItemCode+InvoiceNo+HeaderSeqNo+DetailSeqNo KINVOICE: InvoiceNo+ARDivisionNo+CustomerNo+ItemCode+HeaderSeqNo+DetailSeqNo
Fld Column Name M/L TUR Description/Notes Class
1 ARDivisionNo. . . . . . . . . 2 SNY AR Division Number. . . . . . .ARDIVISION Mask:00 FmtType:ZEROFILL Notes: {RAS$(1,2)} 2 CustomerNo. . . . . . . . . . 20 SYY Customer Number . . . . . . . .CUSTOMERNO FmtType:MASTERNUMC ChngTag:Re place1/ARDivisionNo$ Notes: {RAS$(3,7)} 3 ItemCode. . . . . . . . . . . 30 SYN Item Code . . . . . . . . . . .ITEMCODE ChngTag:Replace0 Notes: {RAS$(10,15)} 4 ItemType. . . . . . . . . . . 1 SYN Item Type . . . . . . . . . . . Valid:1,2,3,5 Notes: 1=Regular Item, 2=Special Item, 3=Charge Item, 4=Comment Item, 5=Miscellaneo us Item 5 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . .DESCRIPTION Notes: {RAS$(43,30)} 6 InvoiceNo . . . . . . . . . . 7 SYN Invoice Number. . . . . . . . .INVOICE FmtType:MASTERNUM 7 HeaderSeqNo . . . . . . . . . 6 SNN Header Sequence Number. . . . . Mask:000000 FmtType:ZEROFILL Notes: {RAS$(32,3)} 8 DetailSeqNo . . . . . . . . . 6 SNN Detail Sequence Number. . . . . Mask:000000 FmtType:ZEROFILL Notes: {RAS$(35,5)} 9 ModuleCode. . . . . . . . . . 3 SYN Module Code . . . . . . . . . .MODULECODE Notes: {RAS$(40,2)} 10 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE Notes: {RAS$(73,6)} 11 ShipDate. . . . . . . . . . . 8 SNN Ship Date . . . . . . . . . . .DATE Notes: {RAS$(79,6)} 12 UnitOfMeasure . . . . . . . . 4 SYN Unit Of Measure . . . . . . . .UNITOFMEASURE Notes: {RAS$(85,4)} 13 SalesOrderNo. . . . . . . . . 7 SYN Sales Order Number. . . . . . .SALESORDERNO FmtType:CHARNUM Notes: {RAS$(89,7)} 14 CustomerPONo. . . . . . . . . 15 SNN Customer PO Number. . . . . . .CUSTOMERPONO Notes: {RAS$(96,15)} 15 QuantityShipped . . . . . . . 16.6 NNN Quantity Shipped. . . . . . . .QUANTITY Mask:##,###,###.000000- Notes: {RAS[0]}