RA_RMAReceiverWrk RA RMA Receiver Work Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: RA_RMAReceiverPrinting_rpt
SQL Def: Y SysDB: N "MAS_"+%C$+"/RA"+%C$+"/RA_RMAReceiverWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . .
2 GroupField. . . . . . . . . . 22 SNN Group Field . . . . . . . . . .
3 RMANo . . . . . . . . . . . . 7 SNN RMA Number. . . . . . . . . . .
4 RMADate . . . . . . . . . . . 8 SNN RMA Date. . . . . . . . . . . .DATE
5 ExpireDate. . . . . . . . . . 8 SNN Expire Date . . . . . . . . . .DATE
6 ReturnShipVia . . . . . . . . 15 SNN Return Ship Via . . . . . . . .
7 ConfirmTo . . . . . . . . . . 30 SNN Confirm To. . . . . . . . . . .
8 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . .
9 EmailAddress. . . . . . . . . 50 SNN Email Address . . . . . . . . .
10 FaxNo . . . . . . . . . . . . 17 SNN Fax Number. . . . . . . . . . .
11 InspectOnReceipt. . . . . . . 1 SNN Inspect On Receipt. . . . . . .
12 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .
13 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . .
14 TelephoneNo . . . . . . . . . 17 SNN Telephone Number. . . . . . . .
15 BillToName. . . . . . . . . . 30 SNN Bill To Name. . . . . . . . . .
16 BillToAddress1. . . . . . . . 30 SNN Bill To Address 1 . . . . . . .
17 BillToAddress2. . . . . . . . 30 SNN Bill To Address 2 . . . . . . .
18 BillToAddress3. . . . . . . . 30 SNN Bill To Address 3 . . . . . . .
19 BillToCity. . . . . . . . . . 20 SNN Bill To City. . . . . . . . . .
20 BillToState . . . . . . . . . 2 SNN Bill To State . . . . . . . . .
21 BillToZipCode . . . . . . . . 10 SNN Bill To Zip Code. . . . . . . .
22 BillToCountryCode . . . . . . 3 SNN Bill To Country Code. . . . . .
23 BillToCountryName . . . . . . 30 SNN Bill To Country Name. . . . . .
24 ShipToName. . . . . . . . . . 30 SNN Ship To Name. . . . . . . . . .
25 ShipToAddress1. . . . . . . . 30 SNN Ship To Address 1 . . . . . . .
26 ShipToAddress2. . . . . . . . 30 SNN Ship To Address 2 . . . . . . .
27 ShipToAddress3. . . . . . . . 30 SNN Ship To Address 3 . . . . . . .
28 ShipToCity. . . . . . . . . . 20 SNN Ship To City. . . . . . . . . .
29 ShipToState . . . . . . . . . 2 SNN Ship To State . . . . . . . . .
30 ShipToZipCode . . . . . . . . 10 SNN Ship To Zip Code. . . . . . . .
31 ShipToCountryCode . . . . . . 3 SNN Ship To Country Code. . . . . .
32 ShipToCountryName . . . . . . 30 SNN Ship To Country Name. . . . . .
33 ReturnToName. . . . . . . . . 30 SNN Return To Name. . . . . . . . .
34 ReturnToAddress1. . . . . . . 30 SNN Return To Address 1 . . . . . .
35 ReturnToAddress2. . . . . . . 30 SNN Return To Address 2 . . . . . .
36 ReturnToAddress3. . . . . . . 30 SNN Return To Address 3 . . . . . .
37 ReturnToCity. . . . . . . . . 20 SNN Return To City. . . . . . . . .
38 ReturnToState . . . . . . . . 2 SNN Return To State . . . . . . . .
39 ReturnToZipCode . . . . . . . 10 SNN Return To Zip Code. . . . . . .
40 ReturnToCountryCode . . . . . 3 SNN Return To Country Code. . . . .
41 ReturnToCountryName . . . . . 30 SNN Return To Country Name. . . . .
42 LineKey . . . . . . . . . . . 6 SNN Line Key. . . . . . . . . . . .
43 LineSeqNo . . . . . . . . . . 14 SNN Line Sequence Number. . . . . .
44 InvoiceNo . . . . . . . . . . 7 SNN Invoice Number. . . . . . . . .
45 HeaderSeqNo . . . . . . . . . 6 SNN Header Sequence Number. . . . .
46 DetailSeqNo . . . . . . . . . 6 SNN Detail Sequence Number. . . . .
47 ItemCode. . . . . . . . . . . 30 SNN Item Code . . . . . . . . . . .
48 ItemType. . . . . . . . . . . 1 SNN Item Type . . . . . . . . . . .
49 AliasItemNo . . . . . . . . . 30 SNN Alias Item Number . . . . . . .
50 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . .
51 ExtendedDescriptionKey. . . . 10 SNN Extended Description Key. . . .
52 ExtendedDescriptionText . . . 4096 SNN Extended Description Text . . .
53 WarehouseCode . . . . . . . . 3 SNN Warehouse Code. . . . . . . . .
54 BinLocation . . . . . . . . . 10 SNN Bin Location. . . . . . . . . .
55 ProductLine . . . . . . . . . 4 SNN Product Line. . . . . . . . . .
56 Valuation . . . . . . . . . . 1 SNN Valuation . . . . . . . . . . .
57 UnitOfMeasure . . . . . . . . 4 SNN Unit Of Measure . . . . . . . .
58 ReturnReasonCode. . . . . . . 10 SNN Return Reason Code. . . . . . .
59 CustomerAction. . . . . . . . 1 SNN Customer Action . . . . . . . .
60 ItemAction. . . . . . . . . . 1 SNN Item Action . . . . . . . . . .
61 CrossShip . . . . . . . . . . 1 SNN Cross Ship. . . . . . . . . . .
62 NotUsed . . . . . . . . . . . 1 SNN Not Used. . . . . . . . . . . .
63 WarrantyCode. . . . . . . . . 10 SNN WarrantyCode. . . . . . . . . .
64 ExpirationDate. . . . . . . . 8 SNN Expiration Date . . . . . . . .DATE
65 Category1 . . . . . . . . . . 10 SNN Category 1. . . . . . . . . . .
66 Category2 . . . . . . . . . . 10 SNN Category 2. . . . . . . . . . .
67 Category3 . . . . . . . . . . 10 SNN Category 3. . . . . . . . . . .
68 Category4 . . . . . . . . . . 10 SNN Category 4. . . . . . . . . . .
69 CostOfGoodsSoldAcctKey. . . . 9 SNN Cost Of Goods Sold Account Key.
70 CostOfGoodsSoldAccount. . . . 41 SNN Fully Formatted Cost Of Goods S
71 SalesAcctKey. . . . . . . . . 9 SNN Sales Account Key . . . . . . .
72 SalesAccount. . . . . . . . . 41 SNN Fully Formatted Sales Account N
73 HistoryCOGSAcctKey. . . . . . 9 SNN History Cost Of Goods Sold Acct
74 HistoryCOGSAccount. . . . . . 41 SNN Fully Formatted History Cost Of
75 Revision. . . . . . . . . . . 3 SNN Bill Revision Code. . . . . . .
76 BillOption1 . . . . . . . . . 2 SNN Bill Option 1 . . . . . . . . .
77 Option1Desc . . . . . . . . . 30 SNN Option 1 Description. . . . . .
78 BillOption2 . . . . . . . . . 2 SNN Bill Option 2 . . . . . . . . .
79 Option2Desc . . . . . . . . . 30 SNN Option 2 Description. . . . . .
80 BillOption3 . . . . . . . . . 2 SNN Bill Option 3 . . . . . . . . .
81 Option3Desc . . . . . . . . . 30 SNN Option 3 Description. . . . . .
82 BillOption4 . . . . . . . . . 2 SNN Bill Option 4 . . . . . . . . .
83 Option4Desc . . . . . . . . . 30 SNN Option 4 Description. . . . . .
84 BillOption5 . . . . . . . . . 2 SNN Bill Option 5 . . . . . . . . .
85 Option5Desc . . . . . . . . . 30 SNN Option 5 Description. . . . . .
86 BillOption6 . . . . . . . . . 2 SNN Bill Option 6 . . . . . . . . .
87 Option6Desc . . . . . . . . . 30 SNN Option 6 Description. . . . . .
88 BillOption7 . . . . . . . . . 2 SNN Bill Option 7 . . . . . . . . .
89 Option7Desc . . . . . . . . . 30 SNN Option 7 Description. . . . . .
90 BillOption8 . . . . . . . . . 2 SNN Bill Option 8 . . . . . . . . .
91 Option8Desc . . . . . . . . . 30 SNN Option 8 Description. . . . . .
92 BillOption9 . . . . . . . . . 2 SNN Bill Option 9 . . . . . . . . .
93 Option9Desc . . . . . . . . . 30 SNN Option 9 Description. . . . . .
94 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . .
95 LotSerialNo . . . . . . . . . 15 SNN Lot Serial Number . . . . . . .
96 LotSerialSeqNo. . . . . . . . 14 SNN Lot Serial Sequence Number. . .
97 ReplacementItemCode . . . . . 30 SNN Replacement Item Code . . . . .
98 ReplacementItemType . . . . . 1 SNN Replacement Item Type . . . . .
99 ReplacementItemCodeDesc . . . 30 SNN Replacement Item Code Descripti
100 MessageLine1. . . . . . . . . 50 SNN Message Line 1. . . . . . . . .
101 MessageLine2. . . . . . . . . 50 SNN Message Line 2. . . . . . . . .
102 FaxSendToCompany. . . . . . . 30 SNN Fax Send To Company . . . . . .
103 FaxSendToName . . . . . . . . 30 SNN Fax Send To Name. . . . . . . .
104 BatchFax. . . . . . . . . . . 1 SYN BatchFax. . . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N
105 QuantityReturned. . . . . . . 16.6 NNN Quantity Returned . . . . . . .
106 QuantityReceived. . . . . . . 16.6 NNN Quantity Received . . . . . . .
107 QuantityRemaining . . . . . . 16.6 NNN Quantity Remaining. . . . . . .
108 LotSerialQuantityReturned . . 16.6 NNN Lot Serial Quantity Returned. .
109 InvoiceUnitPrice. . . . . . . 16.6 NNN Invoice Unit Price. . . . . . .
110 ExtensionAmt. . . . . . . . . 12.2 NNN Extension Amount. . . . . . . .
111 RestockingCharge. . . . . . . 11.3 NNN Restocking Charge . . . . . . .