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]}