RA_RepairDetail RA Repair Detail Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: RA_GenerateTransactions_upd SQL Def: Y SysDB: N "MAS_"+%C$+"/RA"+%C$+"/RA_RepairDetail.M4T"
KPRIMARY: ARDivisionNo+CustomerNo+ItemCode+RMANo+SequenceNo KITEM: ItemCode+ARDivisionNo+CustomerNo+RMANo+SequenceNo KRMANO: RMANo+ARDivisionNo+CustomerNo+ItemCode+SequenceNo
Fld Column Name M/L TUR Description/Notes Class
1 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .ARDIVISION Mask:00 FmtType:ZEROFILL Notes: {RAI$(2,2)} 2 CustomerNo. . . . . . . . . . 20 SYN Customer Number . . . . . . . .CUSTOMERNO FmtType:MASTERNUMC ChngTag:Re place1/ARDivisionNo$ Notes: {RAI$(4,7)} 3 ItemCode. . . . . . . . . . . 30 SYN Item Code . . . . . . . . . . .ITEMCODE Notes: {RAI$(11,15)} 4 RMANo . . . . . . . . . . . . 7 SYN RMA Number. . . . . . . . . . .RMANO FmtType:CHARNUM Notes: {RAI$(26,7)} 5 SequenceNo. . . . . . . . . . 6 SNN Sequence Number . . . . . . . . Mask:000000 FmtType:ZEROFILL ChngTag:KeySeq Notes: {RAI$(33,5)} 6 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 {RAI$(38,1)} 7 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . .DESCRIPTION Notes: {RAI$(54,30)} 8 RMADate . . . . . . . . . . . 8 SNN RMA Date. . . . . . . . . . . .DATE Notes: {RAI$(84,6)} 9 ReceiptDate . . . . . . . . . 8 SNN Receipt Date. . . . . . . . . .DATE Notes: {RAI$(90,6)} 10 ReturnReasonCode. . . . . . . 10 SYN Return Reason Code. . . . . . .RETURNREASONCODE Notes: {RAI$(96,10)} 11 InvoiceNo . . . . . . . . . . 7 SYN Invoice Number. . . . . . . . .INVOICE FmtType:MASTERNUM Notes: {RAI$(106,7)} 12 InvoiceNotOnFile. . . . . . . 1 SYN Invoice Not on File . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {RAI$(113,1)} 13 QuantityReturned. . . . . . . 16.6 NNN Quantity Returned . . . . . . .QUANTITY Mask:##,###,###.000000- Notes: {RAI[0]} 14 QuantityReceived. . . . . . . 16.6 NNN Quantity Received . . . . . . .QUANTITY Mask:##,###,###.000000- Notes: {RAI[1]} 15 QuantityRemaining . . . . . . 16.6 NNN Quantity Remaining. . . . . . .QUANTITY Mask:##,###,###.000000- Notes: {RAI[2]} 16 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 17 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . . Read Only:Y 18 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL