RA_ReturnReasonDetail RA Return Reason Detail Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: RA_GenerateTransactions_upd
SQL Def: Y SysDB: N "MAS_"+%C$+"/RA"+%C$+"/RA_ReturnReasonDetail.M4T"
KPRIMARY: ItemCode+ReceiptDate+RMANo+SequenceNo
KRETURNREASON: ReturnReasonCode+ItemCode+ReceiptDate+RMANo+SequenceNo
KPRODUCTLINE: ProductLine+ItemCode+ReceiptDate+RMANo+SequenceNo
KCUSTOMER: ARDivisionNo+CustomerNo+ItemCode+ReceiptDate+RMANo+SequenceNo
KVENDOR: APDivisionNo+VendorNo+ItemCode+ReceiptDate+RMANo+SequenceNo
KRECEIPTDATE: ReceiptDate(d)+ItemCode+RMANo+SequenceNo
Fld Column Name M/L TUR Description/Notes Class
1 ItemCode. . . . . . . . . . . 30 SYN Item Code . . . . . . . . . . .ITEMCODE
ChngTag:Replace0 Notes: Item
Number - verified against
IM1, Special Item Number -
Not verified, Misc Charge -
Verified against CI_Item,
Misc Item - Verified against
CI_Item {RAM$(1,15)}
2 ItemType. . . . . . . . . . . 1 SYY Item Type . . . . . . . . . . .
Valid:1,2,3,5 Notes:
1=Regular Item, 2=Special
Item, 3=Charge Item,
4=Comment Item, 5=Miscellaneo
us Item {RAM$(34,1)}
3 ReceiptDate . . . . . . . . . 8 SNN Receipt Date. . . . . . . . . .DATE
Notes: {RAM$(16,6)}
4 RMANo . . . . . . . . . . . . 7 SYN RMA Number. . . . . . . . . . .RMANO
FmtType:CHARNUM Notes:
{RAM$(22,7)}
5 SequenceNo. . . . . . . . . . 6 SNN Sequence Number . . . . . . . .
Mask:000000 FmtType:ZEROFILL
Notes: {RAM$(29,5)}
6 ReturnReasonCode. . . . . . . 10 SYN Return Reason Code. . . . . . .RETURNREASONCODE
Notes: {RAM$(35,10)}
7 ItemAction. . . . . . . . . . 1 SYN Item Action . . . . . . . . . .
Valid:S,P,R Notes: S=Stock,
P=Scrap,R=Repair {RAM$(45,1)}
8 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . .DESCRIPTION
Notes: {RAM$(46,30)}
9 ProductLine . . . . . . . . . 4 SYN Product Line. . . . . . . . . .PRODUCTLINE
FmtType:CHARNUM Notes:
{RAM$(76,4)}
10 UnitOfMeasure . . . . . . . . 4 SYN Unit Of Measure . . . . . . . .UNITOFMEASURE
Notes: {RAM$(80,4)}
11 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE
FmtType:CHARNUM Notes:
{RAM$(84,3)}
12 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .ARDIVISION
Mask:00 FmtType:ZEROFILL
Notes: {RAM$(87,2)}
13 CustomerNo. . . . . . . . . . 20 SYN Customer Number . . . . . . . .CUSTOMERNO
FmtType:MASTERNUMC ChngTag:Re
place1/ARDivisionNo$ Notes:
{RAM$(89,7)}
14 CustomerAction. . . . . . . . 1 SYN Customer Action . . . . . . . .
Valid:C,P,R Notes: C=Credit,
P=rePlacement,R=Repair
{RAM$(96,1)}
15 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . .APDIVISION
Mask:00 FmtType:ZEROFILL
Notes: {RAM$(97,2)}
16 VendorNo. . . . . . . . . . . 7 SYN Vendor Number . . . . . . . . .VENDORNO
FmtType:MASTERNUM ChngTag:Rep
lace1/APDivisionNo$ Notes:
{RAM$(99,7)}
17 VendorAction. . . . . . . . . 1 SYN Vendor Action . . . . . . . . .
Valid:C,P,N Notes: C=Credit,
P=rePlacement, N=None
{RAM$(106,1)}
18 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . .ARDIVISION
Mask:00 FmtType:ZEROFILL
19 SalespersonNo . . . . . . . . 4 SYN Salesperson Number. . . . . . .SALESPERSONNO
FmtType:CHARNUM Notes:
{RAM$(107,4)}
20 QuantityReturnedActual. . . . 16.6 NNN Quantity Returned Actual. . . .QUANTITY
Mask:##,###,###.000000-
Notes: {RAM[0]}
21 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
22 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y
23 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL