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