RA_DeleteRenumberMergeXref RA Delete/Renumber/Merge X-ReferencRel: 4.40 Bld: 398 8/28/2009
Bus Obj: N/A
SQL Def: Y SysDB: N "MAS_"+%C$+"/RA"+%C$+"/RA_DeleteRenumberMergeXref.M4T"
KPRIMARY: RecordType+RMANo+RMADetailLineKey
KITEM: RecordType+ItemCode+RMANo+RMADetailLineKey
KVENDOR: RecordType+APDivisionNo+VendorNo+RMANo+RMADetailLineKey
KITEMRECORD: ItemCode+RecordType+RMANo+RMADetailLineKey
Fld Column Name M/L TUR Description/Notes Class
1 RecordType. . . . . . . . . . 1 SYY Record Type . . . . . . . . . .
Valid:I,V Notes: I=Inventory
item, V=Vendor item {RAX$(1,
1)}
2 ItemCode. . . . . . . . . . . 30 SYN Item Code . . . . . . . . . . .ITEMCODE
ChngTag:Replace0 Notes:
{RAX$(2,15)}
3 ItemType. . . . . . . . . . . 1 SYN Item Type . . . . . . . . . . .
Valid:1 Notes: 1=Regular
Item, 2=Special Item,
3=Charge Item, 4=Comment
Item, 5=Miscellaneous Item
4 RMANo . . . . . . . . . . . . 7 SYN RMA Number. . . . . . . . . . .RMANO
FmtType:CHARNUM Notes:
{RAX$(22,7)}
5 RMADetailLineKey. . . . . . . 6 SNN RMA Detail Line Key . . . . . .
Mask:000000 FmtType:ZEROFILL
Notes: {RAX$(29,5)}
6 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . .APDIVISION
Mask:00 FmtType:ZEROFILL
Notes: {RAX$(2,2)}
7 VendorNo. . . . . . . . . . . 7 SYN Vendor Number . . . . . . . . .VENDORNO
FmtType:MASTERNUM ChngTag:Rep
lace1/APDivisionNo$ Notes:
{RAX$(4,7)}